DECLARE
X_RETURN_STATUS VARCHAR2 (1);
BEGIN
ZX_REGISTRATIONS_PKG.INSERT_ROW (
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 => NULL,
P_SELF_ASSESS_FLAG => 'Y',
P_REGISTRATION_STATUS_CODE => 'REGISTERED',
P_REGISTRATION_SOURCE_CODE => 'EXPLICIT',
P_REGISTRATION_REASON_CODE => 'REVENUE_THRESHOLD',
P_TAX => 'VAT TAX',
P_TAX_REGIME_CODE => 'DUBAI VAT REGIME',
P_INCLUSIVE_TAX_FLAG => 'N',
P_EFFECTIVE_FROM => TO_DATE ('01-DEC-2007', 'DD-MON-YYYY'),
P_EFFECTIVE_TO => NULL,
P_REP_PARTY_TAX_NAME => NULL,
P_DEFAULT_REGISTRATION_FLAG => 'N',
P_BANK_ACCOUNT_NUM => NULL,
P_RECORD_TYPE_CODE => NULL,
P_LEGAL_LOCATION_ID => NULL,
P_TAX_AUTHORITY_ID => NULL,
P_REP_TAX_AUTHORITY_ID => NULL,
P_COLL_TAX_AUTHORITY_ID => NULL,
P_REGISTRATION_TYPE_CODE => 'CPF',
P_REGISTRATION_NUMBER => NULL,
P_PARTY_TAX_PROFILE_ID => 874753,
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.INSERT_ROW (
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 => NULL,
P_SELF_ASSESS_FLAG => 'Y',
P_REGISTRATION_STATUS_CODE => 'REGISTERED',
P_REGISTRATION_SOURCE_CODE => 'EXPLICIT',
P_REGISTRATION_REASON_CODE => 'REVENUE_THRESHOLD',
P_TAX => 'VAT TAX',
P_TAX_REGIME_CODE => 'DUBAI VAT REGIME',
P_INCLUSIVE_TAX_FLAG => 'N',
P_EFFECTIVE_FROM => TO_DATE ('01-DEC-2007', 'DD-MON-YYYY'),
P_EFFECTIVE_TO => NULL,
P_REP_PARTY_TAX_NAME => NULL,
P_DEFAULT_REGISTRATION_FLAG => 'N',
P_BANK_ACCOUNT_NUM => NULL,
P_RECORD_TYPE_CODE => NULL,
P_LEGAL_LOCATION_ID => NULL,
P_TAX_AUTHORITY_ID => NULL,
P_REP_TAX_AUTHORITY_ID => NULL,
P_COLL_TAX_AUTHORITY_ID => NULL,
P_REGISTRATION_TYPE_CODE => 'CPF',
P_REGISTRATION_NUMBER => NULL,
P_PARTY_TAX_PROFILE_ID => 874753,
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;
No comments:
Post a Comment