80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: -- Receipt application parameters.
84: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
85: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
86: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
87: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
88: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: -- Receipt application parameters.
84: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
85: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
86: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
87: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
88: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
89: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
124: x_return_status OUT NOCOPY VARCHAR2 ,
125: x_msg_count OUT NOCOPY NUMBER ,
126: x_msg_data OUT NOCOPY VARCHAR2 ,
127: -- *** Receipt Info. parameters *****
128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
129: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
131: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
132: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
125: x_msg_count OUT NOCOPY NUMBER ,
126: x_msg_data OUT NOCOPY VARCHAR2 ,
127: -- *** Receipt Info. parameters *****
128: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
129: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
130: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
131: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
132: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
133: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: -- Receipt info. parameters
150: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
149: -- Receipt info. parameters
150: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
150: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
151: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
152: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
153: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
154: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,
155: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
156: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
157: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
158: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,
163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
159: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
160: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
161: p_maturity_date IN DATE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,
163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
164: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
165: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
166: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
167: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
162: p_postmark_date IN DATE DEFAULT NULL,
163: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
164: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
165: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
166: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
167: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
168: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
167: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
168: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
168: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
169: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
170: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
171: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
172: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
173: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE DEFAULT NULL,
174: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
175: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
176: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
182: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
183: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
184: -- ******* Global Flexfield parameters *******
177: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
178: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
179: p_doc_sequence_value IN NUMBER DEFAULT NULL,
180: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
181: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
182: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
183: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
184: -- ******* Global Flexfield parameters *******
185: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
184: -- ******* Global Flexfield parameters *******
185: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
186: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187: -- *** Notes Receivable Additional Information ***
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
185: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const,
186: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187: -- *** Notes Receivable Additional Information ***
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193: -- Receipt application parameters
186: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
187: -- *** Notes Receivable Additional Information ***
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193: -- Receipt application parameters
194: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
188: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
189: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
190: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
191: -- ** OUT NOCOPY variables for Creating receipt
192: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
193: -- Receipt application parameters
194: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
195: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
196: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: -- Receipt reversal related parameters
232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: -- Receipt reversal related parameters
232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: -- Receipt reversal related parameters
232: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
233: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
234: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
235: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
242: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
236: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
237: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
238: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
239: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
240: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
241: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT',
242: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type DEFAULT ar_receipt_api_pub.attribute_rec_const,
243: --p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type_upd DEFAULT ar_receipt_api_pub.global_attribute_rec_upd_cons
244: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type DEFAULT ar_receipt_api_pub.global_attribute_rec_const ,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: -- Receipt application parameters.
258: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
259: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
260: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
261: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
262: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: -- Receipt application parameters.
258: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
259: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
260: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
261: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
262: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
263: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
280: x_return_status OUT NOCOPY VARCHAR2 ,
281: x_msg_count OUT NOCOPY NUMBER ,
282: x_msg_data OUT NOCOPY VARCHAR2 ,
283: -- *** Receipt Info. parameters *****
284: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
285: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
286: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
287: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL
288: );
281: x_msg_count OUT NOCOPY NUMBER ,
282: x_msg_data OUT NOCOPY VARCHAR2 ,
283: -- *** Receipt Info. parameters *****
284: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
285: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
286: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
287: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL
288: );
289:
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: -- Receipt application parameters.
300: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
301: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
302: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
303: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
304: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: -- Receipt application parameters.
300: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
301: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
302: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
303: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
304: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
305: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
334: x_return_status OUT NOCOPY VARCHAR2 ,
335: x_msg_count OUT NOCOPY NUMBER ,
336: x_msg_data OUT NOCOPY VARCHAR2 ,
337: -- *** Receipt Info. parameters *****
338: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
339: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
340: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
341: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
342: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
335: x_msg_count OUT NOCOPY NUMBER ,
336: x_msg_data OUT NOCOPY VARCHAR2 ,
337: -- *** Receipt Info. parameters *****
338: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
339: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
340: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
341: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
342: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
343: );
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
355: -- Receipt application parameters.
356: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
357: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
358: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
359: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
360: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
355: -- Receipt application parameters.
356: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
357: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
358: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
359: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
360: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
361: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
385: x_return_status OUT NOCOPY VARCHAR2 ,
386: x_msg_count OUT NOCOPY NUMBER ,
387: x_msg_data OUT NOCOPY VARCHAR2 ,
388: -- *** Receipt Info. parameters *****
389: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
390: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
391: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
392: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
393: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
386: x_msg_count OUT NOCOPY NUMBER ,
387: x_msg_data OUT NOCOPY VARCHAR2 ,
388: -- *** Receipt Info. parameters *****
389: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
390: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
391: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
392: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
393: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
394: p_called_from IN VARCHAR2 DEFAULT 'TRADE_MANAGEMENT'
447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2,
450: -- Receipt application parameters.
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
448: x_msg_count OUT NOCOPY NUMBER,
449: x_msg_data OUT NOCOPY VARCHAR2,
450: -- Receipt application parameters.
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
450: -- Receipt application parameters.
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
457: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
458: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
451: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
452: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
453: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
454: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
455: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
456: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
457: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
458: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
459: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,