[Home] [Help]
141: IS
142: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
143: l_api_version CONSTANT NUMBER := 1.0;
144:
145: l_currency_code ar_cash_receipts.currency_code%TYPE;
146: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
142: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
143: l_api_version CONSTANT NUMBER := 1.0;
144:
145: l_currency_code ar_cash_receipts.currency_code%TYPE;
146: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
143: l_api_version CONSTANT NUMBER := 1.0;
144:
145: l_currency_code ar_cash_receipts.currency_code%TYPE;
146: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
144:
145: l_currency_code ar_cash_receipts.currency_code%TYPE;
146: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
145: l_currency_code ar_cash_receipts.currency_code%TYPE;
146: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
146: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
154: l_maturity_date DATE;
147: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
154: l_maturity_date DATE;
155: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
148: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
149: l_amount ar_cash_receipts.amount%TYPE;
150: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
154: l_maturity_date DATE;
155: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
156: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
151: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
152: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
154: l_maturity_date DATE;
155: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
156: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
157: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
153: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
154: l_maturity_date DATE;
155: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
156: l_customer_name hz_parties.party_name%TYPE; /*tca uptake*/
157: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
161: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
157: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
161: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
162: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;
164: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
158: /* 6612301 */
159: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE;
160: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE;
161: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
162: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;
164: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
161: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
162: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;
164: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
162: l_customer_bank_branch_id ar_cash_receipts.customer_bank_branch_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;
164: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
163: l_location hz_cust_site_uses.location%TYPE;
164: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
171: l_receipt_method_name ar_receipt_methods.name%TYPE;
165: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
171: l_receipt_method_name ar_receipt_methods.name%TYPE;
172: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
173: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
166: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
167: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
171: l_receipt_method_name ar_receipt_methods.name%TYPE;
172: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
173: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
174: l_state VARCHAR2(30);
168: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
171: l_receipt_method_name ar_receipt_methods.name%TYPE;
172: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
173: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
174: l_state VARCHAR2(30);
175: l_cr_id NUMBER;
176: l_ps_id NUMBER;
169: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
170: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
171: l_receipt_method_name ar_receipt_methods.name%TYPE;
172: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
173: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
174: l_state VARCHAR2(30);
175: l_cr_id NUMBER;
176: l_ps_id NUMBER;
177: l_row_id VARCHAR2(30);
196: /* bichatte payment uptake */
197: l_copy_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
198: l_copy_msg_count NUMBER;
199: l_copy_msg_data VARCHAR2(2000);
200: l_copy_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
201: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
202: l_create_msg_count NUMBER;
203: l_create_msg_data VARCHAR2(2000);
204: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
200: l_copy_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
201: l_create_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
202: l_create_msg_count NUMBER;
203: l_create_msg_data VARCHAR2(2000);
204: l_create_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
205: l_default_site_use VARCHAR2(1); --bug4448307-4509459
206: l_rec_creation_rule_code ar_receipt_methods.receipt_creation_rule_code%TYPE;
207:
208: BEGIN
447: ELSE
448: --validate and default the flexfields
449: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
450: l_attribute_rec,
451: 'AR_CASH_RECEIPTS',
452: l_dflex_val_return_status
453: );
454:
455: --validation and defaulting of the global descriptive flexfield
452: l_dflex_val_return_status
453: );
454:
455: --validation and defaulting of the global descriptive flexfield
456: JG_AR_CASH_RECEIPTS.Validate_gbl(
457: l_global_attribute_rec.global_attribute_category,
458: l_global_attribute_rec.global_attribute1,
459: l_global_attribute_rec.global_attribute2,
460: l_global_attribute_rec.global_attribute3,
1007: IS
1008: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
1009: l_api_version CONSTANT NUMBER := 1.0;
1010:
1011: l_currency_code ar_cash_receipts.currency_code%TYPE;
1012: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1008: l_api_name CONSTANT VARCHAR2(20) := 'Create_cash';
1009: l_api_version CONSTANT NUMBER := 1.0;
1010:
1011: l_currency_code ar_cash_receipts.currency_code%TYPE;
1012: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1009: l_api_version CONSTANT NUMBER := 1.0;
1010:
1011: l_currency_code ar_cash_receipts.currency_code%TYPE;
1012: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1010:
1011: l_currency_code ar_cash_receipts.currency_code%TYPE;
1012: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1011: l_currency_code ar_cash_receipts.currency_code%TYPE;
1012: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1012: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1020: l_maturity_date DATE;
1013: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1020: l_maturity_date DATE;
1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1014: l_exchange_rate_date ar_cash_receipts.exchange_date%TYPE;
1015: l_amount ar_cash_receipts.amount%TYPE;
1016: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1020: l_maturity_date DATE;
1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1017: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
1018: l_receipt_date ar_cash_receipts.receipt_date%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1020: l_maturity_date DATE;
1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1019: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
1020: l_maturity_date DATE;
1021: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1022: l_customer_name hz_parties.party_name%TYPE; /* tca uptake */
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1023: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1024: l_location hz_cust_site_uses.location%TYPE;
1025: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1032: l_receipt_method_name ar_receipt_methods.name%TYPE;
1026: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1032: l_receipt_method_name ar_receipt_methods.name%TYPE;
1033: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1034: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1027: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE;
1028: l_remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE;
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1032: l_receipt_method_name ar_receipt_methods.name%TYPE;
1033: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1034: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1035: l_state VARCHAR2(30);
1029: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1032: l_receipt_method_name ar_receipt_methods.name%TYPE;
1033: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1034: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1035: l_state VARCHAR2(30);
1036: l_cr_id NUMBER;
1037: l_ps_id NUMBER;
1030: l_deposit_date ar_cash_receipts.deposit_date%TYPE;
1031: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
1032: l_receipt_method_name ar_receipt_methods.name%TYPE;
1033: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE;
1034: l_anticipated_clearing_date ar_cash_receipts.anticipated_clearing_date%TYPE;
1035: l_state VARCHAR2(30);
1036: l_cr_id NUMBER;
1037: l_ps_id NUMBER;
1038: l_row_id VARCHAR2(30);
1123: x_return_status OUT NOCOPY VARCHAR2,
1124: x_msg_count OUT NOCOPY NUMBER,
1125: x_msg_data OUT NOCOPY VARCHAR2,
1126: -- Receipt application parameters.
1127: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1124: x_msg_count OUT NOCOPY NUMBER,
1125: x_msg_data OUT NOCOPY VARCHAR2,
1126: -- Receipt application parameters.
1127: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1129: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1131: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1132: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
1873: x_return_status OUT NOCOPY VARCHAR2,
1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: -- Receipt application parameters.
1877: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1878: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1881: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1874: x_msg_count OUT NOCOPY NUMBER,
1875: x_msg_data OUT NOCOPY VARCHAR2,
1876: -- Receipt application parameters.
1877: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
1878: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1879: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
1880: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
1881: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
1882: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
2876: x_return_status OUT NOCOPY VARCHAR2,
2877: x_msg_count OUT NOCOPY NUMBER,
2878: x_msg_data OUT NOCOPY VARCHAR2,
2879: -- *** Receipt Info. parameters *****
2880: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2881: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2877: x_msg_count OUT NOCOPY NUMBER,
2878: x_msg_data OUT NOCOPY VARCHAR2,
2879: -- *** Receipt Info. parameters *****
2880: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
2881: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
2882: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
2883: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
2884: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
2885: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
3385: ba.bank_account_num,
3386: ba.bank_account_name,
3387: ba.inactive_date,
3388: cr.unique_reference --bug 3672953
3389: FROM ar_cash_receipts cr,
3390: ar_receipt_methods rm,
3391: ar_receipt_classes rc,
3392: ap_bank_accounts ba
3393: WHERE cr.cash_receipt_id = p_cash_receipt_id
3397:
3398:
3399: rct_info rct_info_cur%ROWTYPE;
3400:
3401: l_cr_rec ar_cash_receipts%ROWTYPE;
3402:
3403:
3404: l_payee_rec IBY_Payment_Adapter_pub.Payee_Rec_type;
3405: l_customer_rec IBY_Payment_Adapter_pub.Payer_Rec_type;
3781: cr.pay_from_customer,
3782: cr.customer_site_use_id,
3783: cr.payment_trxn_extension_id,
3784: cr.receipt_date
3785: FROM ar_cash_receipts_all cr,
3786: ar_receipt_methods rm,
3787: ar_receipt_classes rc,
3788: hz_cust_accounts hca,
3789: hz_parties party
3795:
3796:
3797:
3798: rct_info rct_info_cur%ROWTYPE;
3799: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3800: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3801: l_action VARCHAR2(80);
3802: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3803: l_msg_count NUMBER;
4288: l_cpy_msg_data VARCHAR2(2000);
4289: l_pmt_channel_code VARCHAR2(20);
4290: l_assignment_id NUMBER;
4291: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
4292: l_payment_trxn_extension_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4293: p_trxn_entity_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4294: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4295: l_party_id NUMBER;
4296: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4289: l_pmt_channel_code VARCHAR2(20);
4290: l_assignment_id NUMBER;
4291: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
4292: l_payment_trxn_extension_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4293: p_trxn_entity_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4294: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4295: l_party_id NUMBER;
4296: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4297: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4293: p_trxn_entity_id AR_CASH_RECEIPTS.PAYMENT_TRXN_EXTENSION_ID%TYPE;
4294: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4295: l_party_id NUMBER;
4296: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4297: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4298: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4299: l_org_id ar_cash_receipts.org_id%TYPE;
4300: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4301: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4294: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
4295: l_party_id NUMBER;
4296: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4297: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4298: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4299: l_org_id ar_cash_receipts.org_id%TYPE;
4300: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4301: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4302:
4295: l_party_id NUMBER;
4296: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4297: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4298: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4299: l_org_id ar_cash_receipts.org_id%TYPE;
4300: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4301: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4302:
4303:
4296: lc_trxn_entity_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
4297: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4298: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4299: l_org_id ar_cash_receipts.org_id%TYPE;
4300: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4301: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4302:
4303:
4304:
4297: l_customer_id ar_cash_receipts.pay_from_customer%TYPE;
4298: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE;
4299: l_org_id ar_cash_receipts.org_id%TYPE;
4300: l_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
4301: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
4302:
4303:
4304:
4305: BEGIN
4594: x_msg_count OUT NOCOPY NUMBER,
4595: x_msg_data OUT NOCOPY VARCHAR2,
4596: -- Receipt info. parameters
4597: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4598: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4599: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4600: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4596: -- Receipt info. parameters
4597: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4598: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4599: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4600: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4597: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4598: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4599: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4600: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4605: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4598: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4599: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4600: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4605: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4606: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4599: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4600: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4605: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4606: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4607: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4600: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4605: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4606: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4607: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4608: p_maturity_date IN DATE DEFAULT NULL,
4601: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4605: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4606: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4607: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4608: p_maturity_date IN DATE DEFAULT NULL,
4609: p_postmark_date IN DATE DEFAULT NULL,
4602: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4603: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4604: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
4605: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4606: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4607: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4608: p_maturity_date IN DATE DEFAULT NULL,
4609: p_postmark_date IN DATE DEFAULT NULL,
4610: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4606: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4607: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4608: p_maturity_date IN DATE DEFAULT NULL,
4609: p_postmark_date IN DATE DEFAULT NULL,
4610: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4611: /* tca uptake */
4612: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4613: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4614: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4610: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4611: /* tca uptake */
4612: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4613: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4614: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
4615: /* 6612301 */
4616: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
4617: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
4618: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4618: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4619: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4620: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4621: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4622: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4623: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4624: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4625: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4626: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4619: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4620: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4621: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4622: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4623: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4624: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4625: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4626: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4627: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4620: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4621: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug4448307-4509459
4622: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
4623: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4624: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4625: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4626: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4627: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4628: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4623: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
4624: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4625: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4626: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4627: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4628: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4629: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4630: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4631: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4624: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
4625: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
4626: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
4627: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4628: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4629: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4630: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4631: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4632: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4627: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4628: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4629: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4630: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4631: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4632: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4633: p_called_from IN VARCHAR2 DEFAULT NULL,
4634: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4635: -- ******* Global Flexfield parameters *******
4628: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4629: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4630: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4631: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
4632: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
4633: p_called_from IN VARCHAR2 DEFAULT NULL,
4634: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4635: -- ******* Global Flexfield parameters *******
4636: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4635: -- ******* Global Flexfield parameters *******
4636: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4637: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4638: -- *** Notes Receivable Additional Information ***
4639: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4640: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4641: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4642: -- ** OUT NOCOPY variables for Creating receipt
4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4636: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
4637: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4638: -- *** Notes Receivable Additional Information ***
4639: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4640: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4641: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4642: -- ** OUT NOCOPY variables for Creating receipt
4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4644: -- Receipt application parameters
4637: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4638: -- *** Notes Receivable Additional Information ***
4639: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4640: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4641: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4642: -- ** OUT NOCOPY variables for Creating receipt
4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4644: -- Receipt application parameters
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4639: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4640: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4641: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4642: -- ** OUT NOCOPY variables for Creating receipt
4643: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4644: -- Receipt application parameters
4645: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
4646: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
4647: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
4669: l_cash_receipt_id NUMBER(15);
4670: l_create_return_status VARCHAR2(1);
4671: l_create_msg_count NUMBER;
4672: l_create_msg_data VARCHAR2(2000);
4673: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
4674:
4675: -- OSTEINME 3/2/2001: added return variable for credit card call
4676: l_cc_return_status VARCHAR2(1); -- credit card return status
4677: l_response_error_code VARCHAR2(80);
4916: x_msg_count OUT NOCOPY NUMBER,
4917: x_msg_data OUT NOCOPY VARCHAR2,
4918: -- Receipt info. parameters
4919: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4920: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4921: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4922: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4923: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4918: -- Receipt info. parameters
4919: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4920: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4921: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4922: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4923: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4919: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
4920: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4921: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4922: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4923: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4927: DEFAULT NULL,
4920: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
4921: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4922: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4923: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4927: DEFAULT NULL,
4928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4921: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
4922: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4923: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4927: DEFAULT NULL,
4928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4929: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4922: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
4923: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4927: DEFAULT NULL,
4928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4929: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4930: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4924: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4927: DEFAULT NULL,
4928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4929: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4930: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4931: p_maturity_date IN DATE DEFAULT NULL,
4932: p_postmark_date IN DATE DEFAULT NULL,
4925: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
4926: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
4927: DEFAULT NULL,
4928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
4929: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4930: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4931: p_maturity_date IN DATE DEFAULT NULL,
4932: p_postmark_date IN DATE DEFAULT NULL,
4933: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4929: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
4930: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
4931: p_maturity_date IN DATE DEFAULT NULL,
4932: p_postmark_date IN DATE DEFAULT NULL,
4933: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4934: /* tca uptake */
4935: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4936: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4937: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
4933: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4934: /* tca uptake */
4935: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
4936: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
4937: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
4938: DEFAULT NULL,
4939: /* 6612301 */
4940: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
4941: DEFAULT NULL,
4944: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, /* bichatte payment uptake */
4945: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
4946: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4947: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
4948: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
4949: DEFAULT NULL,
4950: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
4951: DEFAULT NULL,
4952: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
4946: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
4947: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
4948: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
4949: DEFAULT NULL,
4950: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
4951: DEFAULT NULL,
4952: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
4953: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
4954: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
4951: DEFAULT NULL,
4952: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
4953: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
4954: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
4955: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4956: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4957: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4958: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4959: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
4952: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
4953: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
4954: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
4955: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4956: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4957: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4958: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4959: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
4960: DEFAULT NULL,
4955: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
4956: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
4957: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4958: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4959: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
4960: DEFAULT NULL,
4961: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
4962: DEFAULT NULL,
4963: p_called_from IN VARCHAR2 DEFAULT NULL,
4957: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
4958: p_doc_sequence_value IN NUMBER DEFAULT NULL,
4959: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
4960: DEFAULT NULL,
4961: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
4962: DEFAULT NULL,
4963: p_called_from IN VARCHAR2 DEFAULT NULL,
4964: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
4965: -- ******* Global Flexfield parameters *******
4966: p_global_attribute_rec IN global_attribute_rec_type
4967: DEFAULT global_attribute_rec_const,
4968: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4969: -- *** Notes Receivable Additional Information ***
4970: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4971: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4972: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4973: -- ** OUT NOCOPY variables for Creating receipt
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4967: DEFAULT global_attribute_rec_const,
4968: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4969: -- *** Notes Receivable Additional Information ***
4970: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4971: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4972: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4973: -- ** OUT NOCOPY variables for Creating receipt
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4975: -- Receipt application parameters
4968: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
4969: -- *** Notes Receivable Additional Information ***
4970: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4971: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4972: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4973: -- ** OUT NOCOPY variables for Creating receipt
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4975: -- Receipt application parameters
4976: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4970: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
4971: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
4972: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
4973: -- ** OUT NOCOPY variables for Creating receipt
4974: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
4975: -- Receipt application parameters
4976: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
4977: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
4978: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
4997: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4998: p_org_id IN NUMBER DEFAULT NULL
4999: ) IS
5000:
5001: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%type;
5002:
5003: l_create_return_status VARCHAR2(1);
5004: l_create_msg_count NUMBER;
5005: l_create_msg_data VARCHAR2(2000);
5013: l_api_name CONSTANT VARCHAR2(20) := 'Create_Apply_On_Acc';
5014: l_api_version CONSTANT NUMBER := 1.0;
5015: l_creation_method_code VARCHAR2(50);
5016: l_response_error_code VARCHAR2(80);
5017: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
5018:
5019: BEGIN
5020:
5021: IF PG_DEBUG in ('Y', 'C') THEN
5300:
5301: ) IS
5302: l_rev_crh_id NUMBER;
5303: l_crh_rec ar_cash_receipt_history%ROWTYPE;
5304: l_cr_rec ar_cash_receipts%ROWTYPE;
5305: l_ps_rec ar_payment_schedules%ROWTYPE;
5306: BEGIN
5307: p_return_status := FND_API.G_RET_STS_SUCCESS;
5308: /*-------------------------------------------------+
5408: x_return_status OUT NOCOPY VARCHAR2,
5409: x_msg_count OUT NOCOPY NUMBER,
5410: x_msg_data OUT NOCOPY VARCHAR2,
5411: -- Receipt reversal related parameters
5412: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5413: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5414: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5415: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5416: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5409: x_msg_count OUT NOCOPY NUMBER,
5410: x_msg_data OUT NOCOPY VARCHAR2,
5411: -- Receipt reversal related parameters
5412: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5413: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5414: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5415: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5416: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5417: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5410: x_msg_data OUT NOCOPY VARCHAR2,
5411: -- Receipt reversal related parameters
5412: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5413: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5414: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5415: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5416: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5417: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5418: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5413: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5414: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5415: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5416: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5417: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5418: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5419: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5420: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
5421: p_called_from IN VARCHAR2 DEFAULT NULL,
5414: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
5415: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5416: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5417: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5418: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5419: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5420: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
5421: p_called_from IN VARCHAR2 DEFAULT NULL,
5422: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5416: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
5417: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
5418: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
5419: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
5420: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
5421: p_called_from IN VARCHAR2 DEFAULT NULL,
5422: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
5423: --p_global_attribute_rec IN global_attribute_rec_type_upd DEFAULT global_attribute_rec_upd_cons
5424: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
5619:
5620: --validate and default the flexfields
5621: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
5622: l_attribute_rec,
5623: 'AR_CASH_RECEIPTS',
5624: l_dflex_val_return_status
5625: );
5626: IF PG_DEBUG in ('Y', 'C') THEN
5627: arp_util.debug('Apply: ' || 'l_dflex_val_return_status :'||l_dflex_val_return_status);
5639: );
5640: IF l_attribute_rec.attribute_category IS NOT NULL THEN
5641: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
5642: l_attribute_rec,
5643: 'AR_CASH_RECEIPTS',
5644: l_dflex_val1_return_status
5645: );
5646: END IF;
5647: END IF;
5649: arp_util.debug( 'l_dflex_def_return_status :'||l_dflex_def_return_status);
5650: arp_util.debug( 'l_dflex_val1_return_status :'||l_dflex_val1_return_status);
5651: END IF;
5652:
5653: jg_ar_cash_receipts.reverse(
5654: l_cash_receipt_id,
5655: l_glob_return_status);
5656:
5657: IF PG_DEBUG in ('Y', 'C') THEN
5950: x_return_status OUT NOCOPY VARCHAR2,
5951: x_msg_count OUT NOCOPY NUMBER,
5952: x_msg_data OUT NOCOPY VARCHAR2,
5953: -- Receipt application parameters.
5954: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5955: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5956: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5957: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5958: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5951: x_msg_count OUT NOCOPY NUMBER,
5952: x_msg_data OUT NOCOPY VARCHAR2,
5953: -- Receipt application parameters.
5954: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5955: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
5956: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
5957: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
5958: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
5959: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
6376: x_return_status OUT NOCOPY VARCHAR2 ,
6377: x_msg_count OUT NOCOPY NUMBER ,
6378: x_msg_data OUT NOCOPY VARCHAR2 ,
6379: -- *** Receipt Info. parameters *****
6380: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6381: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6382: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6383: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6384: p_org_id IN NUMBER DEFAULT NULL
6377: x_msg_count OUT NOCOPY NUMBER ,
6378: x_msg_data OUT NOCOPY VARCHAR2 ,
6379: -- *** Receipt Info. parameters *****
6380: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
6381: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
6382: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
6383: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
6384: p_org_id IN NUMBER DEFAULT NULL
6385: ) IS
6684: x_return_status OUT NOCOPY VARCHAR2 ,
6685: x_msg_count OUT NOCOPY NUMBER ,
6686: x_msg_data OUT NOCOPY VARCHAR2 ,
6687: -- *** Receipt Info. parameters *****
6688: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6689: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6690: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6691: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6692: p_cancel_claim_flag IN VARCHAR2,
6685: x_msg_count OUT NOCOPY NUMBER ,
6686: x_msg_data OUT NOCOPY VARCHAR2 ,
6687: -- *** Receipt Info. parameters *****
6688: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
6689: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
6690: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
6691: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE,
6692: p_cancel_claim_flag IN VARCHAR2,
6693: p_called_from IN VARCHAR2,
6696: l_api_name CONSTANT VARCHAR2(20) := 'Unapply_on_account';
6697: l_api_version CONSTANT NUMBER := 1.0;
6698: l_customer_trx_id NUMBER;
6699: l_cash_receipt_id NUMBER;
6700: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
6701: l_receivable_application_id NUMBER;
6702: l_applied_ps_id NUMBER;
6703: l_sec_app_ref_id NUMBER;
6704: l_amount_applied NUMBER;
7056: x_return_status OUT NOCOPY VARCHAR2,
7057: x_msg_count OUT NOCOPY NUMBER,
7058: x_msg_data OUT NOCOPY VARCHAR2,
7059: -- Receipt application parameters.
7060: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7061: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7057: x_msg_count OUT NOCOPY NUMBER,
7058: x_msg_data OUT NOCOPY VARCHAR2,
7059: -- Receipt application parameters.
7060: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7061: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7062: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
7063: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
7064: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
7065: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE,
7083: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE,
7084: p_val_writeoff_limits_flag IN VARCHAR2,
7085: p_called_from IN VARCHAR2,
7086: p_netted_receipt_flag IN VARCHAR2,
7087: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
7088: p_secondary_app_ref_type IN
7089: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
7090: p_secondary_app_ref_num IN
7091: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
7102: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE
7103: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE
7104: ,p_party_id IN hz_parties.party_id%TYPE
7105: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE
7106: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
7107: ) IS
7108:
7109: l_api_name CONSTANT VARCHAR2(20) := 'Activity_application';
7110: l_api_version CONSTANT NUMBER := 1.0;
7146: l_payment_reason_name iby_payment_reasons_vl.meaning%TYPE;
7147: l_delivery_channel_code iby_delivery_channels_vl.delivery_channel_code%TYPE;
7148: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;
7149: l_pay_alone_flag VARCHAR2(1);
7150: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7151: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7153: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7154: l_invoice_id ap_invoices.invoice_id%TYPE;
7147: l_delivery_channel_code iby_delivery_channels_vl.delivery_channel_code%TYPE;
7148: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;
7149: l_pay_alone_flag VARCHAR2(1);
7150: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7151: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7153: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7154: l_invoice_id ap_invoices.invoice_id%TYPE;
7155: l_dft_ref_return_status VARCHAR2(1);
7148: l_delivery_channel_name iby_delivery_channels_vl.meaning%TYPE;
7149: l_pay_alone_flag VARCHAR2(1);
7150: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7151: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7153: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7154: l_invoice_id ap_invoices.invoice_id%TYPE;
7155: l_dft_ref_return_status VARCHAR2(1);
7156: l_called_from varchar2(20); /*5444407*/
7149: l_pay_alone_flag VARCHAR2(1);
7150: l_legal_entity_id ar_cash_receipts.legal_entity_id%TYPE;
7151: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE;
7152: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
7153: l_exchange_date ar_cash_receipts.exchange_date%TYPE;
7154: l_invoice_id ap_invoices.invoice_id%TYPE;
7155: l_dft_ref_return_status VARCHAR2(1);
7156: l_called_from varchar2(20); /*5444407*/
7157:
7667: x_return_status OUT NOCOPY VARCHAR2 ,
7668: x_msg_count OUT NOCOPY NUMBER ,
7669: x_msg_data OUT NOCOPY VARCHAR2 ,
7670: -- *** Receipt Info. parameters *****
7671: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7672: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7673: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
7674: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
7675: p_called_from IN VARCHAR2,
7668: x_msg_count OUT NOCOPY NUMBER ,
7669: x_msg_data OUT NOCOPY VARCHAR2 ,
7670: -- *** Receipt Info. parameters *****
7671: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
7672: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
7673: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
7674: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
7675: p_called_from IN VARCHAR2,
7676: p_org_id IN NUMBER DEFAULT NULL
8007: x_msg_count OUT NOCOPY NUMBER,
8008: x_msg_data OUT NOCOPY VARCHAR2,
8009: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8010: -- Receipt application parameters.
8011: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8008: x_msg_data OUT NOCOPY VARCHAR2,
8009: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
8010: -- Receipt application parameters.
8011: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
8012: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
8013: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
8014: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
8015: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
8016: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
8536: p_comments IN VARCHAR2 DEFAULT NULL,
8537: p_org_id IN NUMBER DEFAULT NULL,
8538: p_misc_receipt_id OUT NOCOPY NUMBER,
8539: p_called_from IN VARCHAR2 DEFAULT NULL,
8540: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL ) /* Bug fix 3619780*/
8541: IS
8542: l_currency_code ar_cash_receipts.currency_code%TYPE;
8543: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8544: l_exchange_rate NUMBER;
8538: p_misc_receipt_id OUT NOCOPY NUMBER,
8539: p_called_from IN VARCHAR2 DEFAULT NULL,
8540: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL ) /* Bug fix 3619780*/
8541: IS
8542: l_currency_code ar_cash_receipts.currency_code%TYPE;
8543: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8544: l_exchange_rate NUMBER;
8545: l_exchange_date DATE;
8546: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
8539: p_called_from IN VARCHAR2 DEFAULT NULL,
8540: p_payment_trxn_extension_id IN ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL ) /* Bug fix 3619780*/
8541: IS
8542: l_currency_code ar_cash_receipts.currency_code%TYPE;
8543: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8544: l_exchange_rate NUMBER;
8545: l_exchange_date DATE;
8546: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
8547: l_amount NUMBER;
8542: l_currency_code ar_cash_receipts.currency_code%TYPE;
8543: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE;
8544: l_exchange_rate NUMBER;
8545: l_exchange_date DATE;
8546: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
8547: l_amount NUMBER;
8548: l_receipt_date DATE;
8549: l_gl_date DATE;
8550: l_receivables_trx_id NUMBER(15);
8580: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
8581: l_org_return_status VARCHAR2(1);
8582: l_org_id NUMBER;
8583: l_legal_entity_id NUMBER; /* R12 LE uptake */
8584: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
8585: /* bichatte payment uptake */
8586: l_copy_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8587: l_copy_msg_count NUMBER;
8588: l_copy_msg_data VARCHAR2(2000);
8585: /* bichatte payment uptake */
8586: l_copy_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8587: l_copy_msg_count NUMBER;
8588: l_copy_msg_data VARCHAR2(2000);
8589: l_copy_pmt_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE; /* bichatte payment uptake project */
8590: l_default_site_use VARCHAR2(1);
8591: l_customer_id NUMBER(15);
8592: l_customer_site_use_id NUMBER(15);
8593: BEGIN
8776: IF NVL(p_called_from ,'X') NOT IN
8777: ('CC_REFUND','CM_REFUND','CC_CHARGEBACK') THEN
8778: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
8779: l_attribute_rec,
8780: 'AR_CASH_RECEIPTS',
8781: l_dflex_val_return_status
8782: );
8783: END IF;
8784: END IF;
8921: arp_standard.debug('calling copy Extension....');
8922: /* 5955921 */
8923: select pay_from_customer,customer_site_use_id
8924: into l_customer_id,l_customer_site_use_id
8925: from ar_cash_receipts
8926: --where payment_trxn_extension_id = l_payment_trxn_extension_id;
8927: --Bug : 6855895
8928: where cash_receipt_id = l_reference_id;
8929:
9304: x_return_status OUT NOCOPY VARCHAR2,
9305: x_msg_count OUT NOCOPY NUMBER,
9306: x_msg_data OUT NOCOPY VARCHAR2,
9307: -- Receipt application parameters.
9308: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9309: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9305: x_msg_count OUT NOCOPY NUMBER,
9306: x_msg_data OUT NOCOPY VARCHAR2,
9307: -- Receipt application parameters.
9308: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9309: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9307: -- Receipt application parameters.
9308: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9309: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9308: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9309: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9310: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
9311: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
9312: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE,
9313: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE,
9314: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE,
9315: p_apply_date IN ar_receivable_applications.apply_date%TYPE,
9316: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE,
9329: ) IS
9330: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9331: l_api_version CONSTANT NUMBER := 1.0;
9332: l_cash_receipt_id NUMBER;
9333: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9334: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9335: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9336: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9337: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9330: l_api_name CONSTANT VARCHAR2(20) := 'Apply_Open_Receipt';
9331: l_api_version CONSTANT NUMBER := 1.0;
9332: l_cash_receipt_id NUMBER;
9333: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9334: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9335: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9336: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9337: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9338: l_cr_gl_date DATE;
9331: l_api_version CONSTANT NUMBER := 1.0;
9332: l_cash_receipt_id NUMBER;
9333: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
9334: l_open_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
9335: l_open_receipt_number ar_cash_receipts.receipt_number%TYPE;
9336: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
9337: l_open_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
9338: l_cr_gl_date DATE;
9339: l_open_cr_gl_date DATE;