DECLARE
X_RETURN_STATUS VARCHAR2 (1);
BEGIN
ZX_PARTY_TAX_PROFILE_PKG.update_row (
P_PARTY_TAX_PROFILE_ID => 872733,
P_COLLECTING_AUTHORITY_FLAG => NULL,
P_PROVIDER_TYPE_CODE => NULL,
P_CREATE_AWT_DISTS_TYPE_CODE => NULL,
P_CREATE_AWT_INVOICES_TYPE_COD => NULL,
P_TAX_CLASSIFICATION_CODE => NULL, --Tax Classification
P_SELF_ASSESS_FLAG => NULL,
P_ALLOW_OFFSET_TAX_FLAG => NULL, --Allow Offset Taxes
P_REP_REGISTRATION_NUMBER => NULL,
P_EFFECTIVE_FROM_USE_LE => NULL,
P_RECORD_TYPE_CODE => NULL,
P_REQUEST_ID => NULL,
P_ATTRIBUTE1 => NULL,
P_ATTRIBUTE2 => NULL,
P_ATTRIBUTE3 => NULL,
P_ATTRIBUTE4 => NULL,
P_ATTRIBUTE5 => NULL,
P_ATTRIBUTE6 => NULL,
P_ATTRIBUTE7 => NULL,
P_ATTRIBUTE8 => NULL,
P_ATTRIBUTE9 => NULL,
P_ATTRIBUTE10 => NULL,
P_ATTRIBUTE11 => NULL,
P_ATTRIBUTE12 => NULL,
P_ATTRIBUTE13 => NULL,
P_ATTRIBUTE14 => NULL,
P_ATTRIBUTE15 => NULL,
P_ATTRIBUTE_CATEGORY => NULL,
P_PARTY_ID => NULL,
P_PROGRAM_LOGIN_ID => NULL,
P_PARTY_TYPE_CODE => NULL,
P_SUPPLIER_FLAG => NULL,
P_CUSTOMER_FLAG => NULL,
P_SITE_FLAG => NULL,
P_PROCESS_FOR_APPLICABILITY_FL => 'Y', --Allow Tax Applicability
P_ROUNDING_LEVEL_CODE => NULL,--'HEADER', -- Rounding Level
P_ROUNDING_RULE_CODE => NULL,--'UP', --Rounding Rule
P_WITHHOLDING_START_DATE => NULL,
P_INCLUSIVE_TAX_FLAG => NULL,
P_ALLOW_AWT_FLAG => NULL,
P_USE_LE_AS_SUBSCRIBER_FLAG => NULL,
P_LEGAL_ESTABLISHMENT_FLAG => NULL,
P_FIRST_PARTY_LE_FLAG => NULL,
P_REPORTING_AUTHORITY_FLAG => NULL,
X_RETURN_STATUS => X_RETURN_STATUS,
P_REGISTRATION_TYPE_CODE => NULL,
P_COUNTRY_CODE => NULL
);
COMMIT;
DBMS_OUTPUT.PUT_LINE ('RETURN STATUS :' || X_RETURN_STATUS);
END;
X_RETURN_STATUS VARCHAR2 (1);
BEGIN
ZX_PARTY_TAX_PROFILE_PKG.update_row (
P_PARTY_TAX_PROFILE_ID => 872733,
P_COLLECTING_AUTHORITY_FLAG => NULL,
P_PROVIDER_TYPE_CODE => NULL,
P_CREATE_AWT_DISTS_TYPE_CODE => NULL,
P_CREATE_AWT_INVOICES_TYPE_COD => NULL,
P_TAX_CLASSIFICATION_CODE => NULL, --Tax Classification
P_SELF_ASSESS_FLAG => NULL,
P_ALLOW_OFFSET_TAX_FLAG => NULL, --Allow Offset Taxes
P_REP_REGISTRATION_NUMBER => NULL,
P_EFFECTIVE_FROM_USE_LE => NULL,
P_RECORD_TYPE_CODE => NULL,
P_REQUEST_ID => NULL,
P_ATTRIBUTE1 => NULL,
P_ATTRIBUTE2 => NULL,
P_ATTRIBUTE3 => NULL,
P_ATTRIBUTE4 => NULL,
P_ATTRIBUTE5 => NULL,
P_ATTRIBUTE6 => NULL,
P_ATTRIBUTE7 => NULL,
P_ATTRIBUTE8 => NULL,
P_ATTRIBUTE9 => NULL,
P_ATTRIBUTE10 => NULL,
P_ATTRIBUTE11 => NULL,
P_ATTRIBUTE12 => NULL,
P_ATTRIBUTE13 => NULL,
P_ATTRIBUTE14 => NULL,
P_ATTRIBUTE15 => NULL,
P_ATTRIBUTE_CATEGORY => NULL,
P_PARTY_ID => NULL,
P_PROGRAM_LOGIN_ID => NULL,
P_PARTY_TYPE_CODE => NULL,
P_SUPPLIER_FLAG => NULL,
P_CUSTOMER_FLAG => NULL,
P_SITE_FLAG => NULL,
P_PROCESS_FOR_APPLICABILITY_FL => 'Y', --Allow Tax Applicability
P_ROUNDING_LEVEL_CODE => NULL,--'HEADER', -- Rounding Level
P_ROUNDING_RULE_CODE => NULL,--'UP', --Rounding Rule
P_WITHHOLDING_START_DATE => NULL,
P_INCLUSIVE_TAX_FLAG => NULL,
P_ALLOW_AWT_FLAG => NULL,
P_USE_LE_AS_SUBSCRIBER_FLAG => NULL,
P_LEGAL_ESTABLISHMENT_FLAG => NULL,
P_FIRST_PARTY_LE_FLAG => NULL,
P_REPORTING_AUTHORITY_FLAG => NULL,
X_RETURN_STATUS => X_RETURN_STATUS,
P_REGISTRATION_TYPE_CODE => NULL,
P_COUNTRY_CODE => NULL
);
COMMIT;
DBMS_OUTPUT.PUT_LINE ('RETURN STATUS :' || X_RETURN_STATUS);
END;
No comments:
Post a Comment