DECLARE
X_RETURN_STATUS VARCHAR2 (1);
BEGIN
ZX_REGISTRATIONS_PKG.UPDATE_ROW (
P_REGISTRATION_ID => 44664,
P_REQUEST_ID => NULL,
P_ATTRIBUTE1 => NULL,
P_ATTRIBUTE2 => NULL,
P_ATTRIBUTE3 => NULL,
P_ATTRIBUTE4 => NULL,
P_ATTRIBUTE5 => NULL,
P_ATTRIBUTE6 => NULL,
P_VALIDATION_RULE => NULL,
P_ROUNDING_RULE_CODE => 'UP',
P_TAX_JURISDICTION_CODE => 'IND TAX JURISDICTION', --Tax Jurisdiction Code
P_SELF_ASSESS_FLAG => NULL,
P_REGISTRATION_STATUS_CODE => 'REGISTERED', --Tax Registration Status
P_REGISTRATION_SOURCE_CODE => 'IMPLICIT', --Source
P_REGISTRATION_REASON_CODE => 'MINIMUM_PRESENCE', --Tax Registration Reason
P_TAX => 'VAT INDIA TAX', --Tax
P_TAX_REGIME_CODE => 'VAT INDIA', --Tax Regime Code
P_INCLUSIVE_TAX_FLAG => 'N', --Set Invoice Values as Tax Inclusive
P_EFFECTIVE_FROM => TO_DATE ('01-DEC-2007', 'DD-MON-YYYY'), --Effective From
P_EFFECTIVE_TO => TO_DATE ('01-DEC-2018', 'DD-MON-YYYY'), --Effective To
P_REP_PARTY_TAX_NAME => 'abcd', --Company Reporting Name
P_DEFAULT_REGISTRATION_FLAG => 'N', --Set as Default Registration
P_BANK_ACCOUNT_NUM => NULL,
P_RECORD_TYPE_CODE => NULL,
P_LEGAL_LOCATION_ID => 1759, --Legal Registration Address
P_TAX_AUTHORITY_ID => NULL, --Issuing Tax Authority
P_REP_TAX_AUTHORITY_ID => NULL,
P_COLL_TAX_AUTHORITY_ID => NULL,
P_REGISTRATION_TYPE_CODE => 'VAT', --Tax Registration Type
P_REGISTRATION_NUMBER => '123456789', --Tax Registration Number
P_PARTY_TAX_PROFILE_ID => NULL,
P_LEGAL_REGISTRATION_ID => NULL,
P_BANK_ID => NULL,
P_BANK_BRANCH_ID => NULL,
P_ACCOUNT_SITE_ID => NULL,
P_ATTRIBUTE14 => NULL,
P_ATTRIBUTE15 => NULL,
P_ATTRIBUTE_CATEGORY => NULL,
P_PROGRAM_LOGIN_ID => NULL,
P_ACCOUNT_ID => NULL,
P_TAX_CLASSIFICATION_CODE => NULL,
P_ATTRIBUTE7 => NULL,
P_ATTRIBUTE8 => NULL,
P_ATTRIBUTE9 => NULL,
P_ATTRIBUTE10 => NULL,
P_ATTRIBUTE11 => NULL,
P_ATTRIBUTE12 => NULL,
P_ATTRIBUTE13 => NULL,
X_RETURN_STATUS => X_RETURN_STATUS
);
COMMIT;
DBMS_OUTPUT.PUT_LINE ('RETURN STATUS :' || X_RETURN_STATUS);
END;
X_RETURN_STATUS VARCHAR2 (1);
BEGIN
ZX_REGISTRATIONS_PKG.UPDATE_ROW (
P_REGISTRATION_ID => 44664,
P_REQUEST_ID => NULL,
P_ATTRIBUTE1 => NULL,
P_ATTRIBUTE2 => NULL,
P_ATTRIBUTE3 => NULL,
P_ATTRIBUTE4 => NULL,
P_ATTRIBUTE5 => NULL,
P_ATTRIBUTE6 => NULL,
P_VALIDATION_RULE => NULL,
P_ROUNDING_RULE_CODE => 'UP',
P_TAX_JURISDICTION_CODE => 'IND TAX JURISDICTION', --Tax Jurisdiction Code
P_SELF_ASSESS_FLAG => NULL,
P_REGISTRATION_STATUS_CODE => 'REGISTERED', --Tax Registration Status
P_REGISTRATION_SOURCE_CODE => 'IMPLICIT', --Source
P_REGISTRATION_REASON_CODE => 'MINIMUM_PRESENCE', --Tax Registration Reason
P_TAX => 'VAT INDIA TAX', --Tax
P_TAX_REGIME_CODE => 'VAT INDIA', --Tax Regime Code
P_INCLUSIVE_TAX_FLAG => 'N', --Set Invoice Values as Tax Inclusive
P_EFFECTIVE_FROM => TO_DATE ('01-DEC-2007', 'DD-MON-YYYY'), --Effective From
P_EFFECTIVE_TO => TO_DATE ('01-DEC-2018', 'DD-MON-YYYY'), --Effective To
P_REP_PARTY_TAX_NAME => 'abcd', --Company Reporting Name
P_DEFAULT_REGISTRATION_FLAG => 'N', --Set as Default Registration
P_BANK_ACCOUNT_NUM => NULL,
P_RECORD_TYPE_CODE => NULL,
P_LEGAL_LOCATION_ID => 1759, --Legal Registration Address
P_TAX_AUTHORITY_ID => NULL, --Issuing Tax Authority
P_REP_TAX_AUTHORITY_ID => NULL,
P_COLL_TAX_AUTHORITY_ID => NULL,
P_REGISTRATION_TYPE_CODE => 'VAT', --Tax Registration Type
P_REGISTRATION_NUMBER => '123456789', --Tax Registration Number
P_PARTY_TAX_PROFILE_ID => NULL,
P_LEGAL_REGISTRATION_ID => NULL,
P_BANK_ID => NULL,
P_BANK_BRANCH_ID => NULL,
P_ACCOUNT_SITE_ID => NULL,
P_ATTRIBUTE14 => NULL,
P_ATTRIBUTE15 => NULL,
P_ATTRIBUTE_CATEGORY => NULL,
P_PROGRAM_LOGIN_ID => NULL,
P_ACCOUNT_ID => NULL,
P_TAX_CLASSIFICATION_CODE => NULL,
P_ATTRIBUTE7 => NULL,
P_ATTRIBUTE8 => NULL,
P_ATTRIBUTE9 => NULL,
P_ATTRIBUTE10 => NULL,
P_ATTRIBUTE11 => NULL,
P_ATTRIBUTE12 => NULL,
P_ATTRIBUTE13 => NULL,
X_RETURN_STATUS => X_RETURN_STATUS
);
COMMIT;
DBMS_OUTPUT.PUT_LINE ('RETURN STATUS :' || X_RETURN_STATUS);
END;
Thanks For this code.
ReplyDelete