DBA Data[Home] [Help]

APPS.AR_RECEIPT_API_COVER dependencies on AR_CASH_RECEIPTS

Line 144: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: -- Receipt application parameters.
144: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
145: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
146: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
147: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
148: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,

Line 145: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: -- Receipt application parameters.
144: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
145: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
146: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
147: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
148: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
149: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,

Line 237: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

233: x_return_status OUT NOCOPY VARCHAR2 ,
234: x_msg_count OUT NOCOPY NUMBER ,
235: x_msg_data OUT NOCOPY VARCHAR2 ,
236: -- *** Receipt Info. parameters *****
237: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
238: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
239: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
240: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
241: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,

Line 238: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

234: x_msg_count OUT NOCOPY NUMBER ,
235: x_msg_data OUT NOCOPY VARCHAR2 ,
236: -- *** Receipt Info. parameters *****
237: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
238: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
239: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
240: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
241: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,
242: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE ,

Line 287: p_currency_code IN ar_cash_receipts.currency_code%TYPE ,

283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2,
285: -- Receipt info. parameters
286: p_usr_currency_code IN VARCHAR2 , --the translated currency code
287: p_currency_code IN ar_cash_receipts.currency_code%TYPE ,
288: p_usr_exchange_rate_type IN VARCHAR2 ,
289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,

Line 289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,

285: -- Receipt info. parameters
286: p_usr_currency_code IN VARCHAR2 , --the translated currency code
287: p_currency_code IN ar_cash_receipts.currency_code%TYPE ,
288: p_usr_exchange_rate_type IN VARCHAR2 ,
289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,

Line 290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,

286: p_usr_currency_code IN VARCHAR2 , --the translated currency code
287: p_currency_code IN ar_cash_receipts.currency_code%TYPE ,
288: p_usr_exchange_rate_type IN VARCHAR2 ,
289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

Line 291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,

287: p_currency_code IN ar_cash_receipts.currency_code%TYPE ,
288: p_usr_exchange_rate_type IN VARCHAR2 ,
289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,

Line 292: p_amount IN ar_cash_receipts.amount%TYPE ,

288: p_usr_exchange_rate_type IN VARCHAR2 ,
289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,
296: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE ,

Line 293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,

289: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE ,
290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,
296: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE ,
297: p_maturity_date IN DATE ,

Line 294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

290: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE ,
291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,
296: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE ,
297: p_maturity_date IN DATE ,
298: p_postmark_date IN DATE ,

Line 295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,

291: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE ,
292: p_amount IN ar_cash_receipts.amount%TYPE ,
293: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE ,
294: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,
296: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE ,
297: p_maturity_date IN DATE ,
298: p_postmark_date IN DATE ,
299: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE ,

Line 299: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE ,

295: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE ,
296: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE ,
297: p_maturity_date IN DATE ,
298: p_postmark_date IN DATE ,
299: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE ,
300: p_customer_name IN hz_parties.party_name%TYPE ,
301: p_customer_number IN hz_cust_accounts.account_number%TYPE ,
302: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE ,
303: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,

Line 302: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE ,

298: p_postmark_date IN DATE ,
299: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE ,
300: p_customer_name IN hz_parties.party_name%TYPE ,
301: p_customer_number IN hz_cust_accounts.account_number%TYPE ,
302: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE ,
303: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
304: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
305: p_location IN hz_cust_site_uses.location%TYPE ,
306: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE ,

Line 307: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE ,

303: p_customer_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
304: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
305: p_location IN hz_cust_site_uses.location%TYPE ,
306: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE ,
307: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE ,
308: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE ,
309: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,
310: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
311: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,

Line 308: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE ,

304: p_customer_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
305: p_location IN hz_cust_site_uses.location%TYPE ,
306: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE ,
307: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE ,
308: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE ,
309: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,
310: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
311: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
312: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,

Line 309: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,

305: p_location IN hz_cust_site_uses.location%TYPE ,
306: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE ,
307: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE ,
308: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE ,
309: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,
310: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
311: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
312: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,
313: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,

Line 312: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,

308: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE ,
309: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,
310: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
311: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
312: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,
313: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
314: p_receipt_method_name IN ar_receipt_methods.name%TYPE ,
315: p_doc_sequence_value IN NUMBER ,
316: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE ,

Line 313: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,

309: p_remittance_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE ,
310: p_remittance_bank_account_num IN ap_bank_accounts.bank_account_num%TYPE ,
311: p_remittance_bank_account_name IN ap_bank_accounts.bank_account_name%TYPE ,
312: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,
313: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
314: p_receipt_method_name IN ar_receipt_methods.name%TYPE ,
315: p_doc_sequence_value IN NUMBER ,
316: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE ,
317: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE ,

Line 316: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE ,

312: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE ,
313: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
314: p_receipt_method_name IN ar_receipt_methods.name%TYPE ,
315: p_doc_sequence_value IN NUMBER ,
316: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE ,
317: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE ,
318: p_called_from IN VARCHAR2 ,
319: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
320: -- ******* Global Flexfield parameters *******

Line 317: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE ,

313: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE ,
314: p_receipt_method_name IN ar_receipt_methods.name%TYPE ,
315: p_doc_sequence_value IN NUMBER ,
316: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE ,
317: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE ,
318: p_called_from IN VARCHAR2 ,
319: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
320: -- ******* Global Flexfield parameters *******
321: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,

Line 324: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE ,

320: -- ******* Global Flexfield parameters *******
321: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
322: p_receipt_comments IN VARCHAR2 ,
323: -- *** Notes Receivable Additional Information ***
324: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE ,
325: p_issue_date IN ar_cash_receipts.issue_date%TYPE ,
326: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE ,
327: -- ** OUT NOCOPY variables for Creating receipt
328: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 325: p_issue_date IN ar_cash_receipts.issue_date%TYPE ,

321: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
322: p_receipt_comments IN VARCHAR2 ,
323: -- *** Notes Receivable Additional Information ***
324: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE ,
325: p_issue_date IN ar_cash_receipts.issue_date%TYPE ,
326: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE ,
327: -- ** OUT NOCOPY variables for Creating receipt
328: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
329: -- Receipt application parameters

Line 326: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE ,

322: p_receipt_comments IN VARCHAR2 ,
323: -- *** Notes Receivable Additional Information ***
324: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE ,
325: p_issue_date IN ar_cash_receipts.issue_date%TYPE ,
326: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE ,
327: -- ** OUT NOCOPY variables for Creating receipt
328: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
329: -- Receipt application parameters
330: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

Line 328: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

324: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE ,
325: p_issue_date IN ar_cash_receipts.issue_date%TYPE ,
326: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE ,
327: -- ** OUT NOCOPY variables for Creating receipt
328: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
329: -- Receipt application parameters
330: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
331: p_trx_number IN ra_customer_trx.trx_number%TYPE ,
332: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE ,

Line 450: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

446: x_return_status OUT NOCOPY VARCHAR2,
447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
449: -- Receipt reversal related parameters
450: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
451: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
452: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,
453: p_reversal_category_name IN ar_lookups.meaning%TYPE ,
454: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,

Line 451: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

447: x_msg_count OUT NOCOPY NUMBER,
448: x_msg_data OUT NOCOPY VARCHAR2,
449: -- Receipt reversal related parameters
450: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
451: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
452: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,
453: p_reversal_category_name IN ar_lookups.meaning%TYPE ,
454: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,
455: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,

Line 452: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,

448: x_msg_data OUT NOCOPY VARCHAR2,
449: -- Receipt reversal related parameters
450: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
451: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
452: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,
453: p_reversal_category_name IN ar_lookups.meaning%TYPE ,
454: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,
455: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,
456: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE ,

Line 455: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,

451: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
452: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,
453: p_reversal_category_name IN ar_lookups.meaning%TYPE ,
454: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,
455: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,
456: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE ,
457: p_reversal_reason_name IN ar_lookups.meaning%TYPE ,
458: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE ,
459: p_called_from IN VARCHAR2 ,

Line 456: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE ,

452: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE ,
453: p_reversal_category_name IN ar_lookups.meaning%TYPE ,
454: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,
455: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,
456: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE ,
457: p_reversal_reason_name IN ar_lookups.meaning%TYPE ,
458: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE ,
459: p_called_from IN VARCHAR2 ,
460: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,

Line 458: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE ,

454: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE ,
455: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE ,
456: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE ,
457: p_reversal_reason_name IN ar_lookups.meaning%TYPE ,
458: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE ,
459: p_called_from IN VARCHAR2 ,
460: p_attribute_rec IN ar_receipt_api_pub.attribute_rec_type ,
461: p_global_attribute_rec IN ar_receipt_api_pub.global_attribute_rec_type ,
462: p_cancel_claims_flag IN VARCHAR2

Line 505: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

501: x_return_status OUT NOCOPY VARCHAR2,
502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: -- Receipt application parameters.
505: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,

Line 506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: -- Receipt application parameters.
505: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
506: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
507: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
508: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
509: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,
510: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE ,

Line 562: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

558: x_return_status OUT NOCOPY VARCHAR2 ,
559: x_msg_count OUT NOCOPY NUMBER ,
560: x_msg_data OUT NOCOPY VARCHAR2 ,
561: -- *** Receipt Info. parameters *****
562: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
563: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
564: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
565: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE
566: )

Line 563: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

559: x_msg_count OUT NOCOPY NUMBER ,
560: x_msg_data OUT NOCOPY VARCHAR2 ,
561: -- *** Receipt Info. parameters *****
562: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
563: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
564: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
565: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE
566: )
567: IS

Line 599: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

595: x_return_status OUT NOCOPY VARCHAR2,
596: x_msg_count OUT NOCOPY NUMBER,
597: x_msg_data OUT NOCOPY VARCHAR2,
598: -- Receipt application parameters.
599: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
600: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
601: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
602: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,

Line 600: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

596: x_msg_count OUT NOCOPY NUMBER,
597: x_msg_data OUT NOCOPY VARCHAR2,
598: -- Receipt application parameters.
599: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
600: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
601: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
602: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
603: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
604: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default

Line 676: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

672: x_return_status OUT NOCOPY VARCHAR2 ,
673: x_msg_count OUT NOCOPY NUMBER ,
674: x_msg_data OUT NOCOPY VARCHAR2 ,
675: -- *** Receipt Info. parameters *****
676: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
677: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
678: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
679: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
680: p_called_from IN VARCHAR2

Line 677: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

673: x_msg_count OUT NOCOPY NUMBER ,
674: x_msg_data OUT NOCOPY VARCHAR2 ,
675: -- *** Receipt Info. parameters *****
676: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
677: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
678: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE ,
679: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
680: p_called_from IN VARCHAR2
681: )

Line 716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

712: x_msg_count OUT NOCOPY NUMBER,
713: x_msg_data OUT NOCOPY VARCHAR2,
714: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
715: -- Receipt application parameters.
716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,

Line 717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

713: x_msg_data OUT NOCOPY VARCHAR2,
714: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
715: -- Receipt application parameters.
716: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
717: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
718: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
719: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE ,
720: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE ,
721: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,

Line 788: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

784: x_return_status OUT NOCOPY VARCHAR2 ,
785: x_msg_count OUT NOCOPY NUMBER ,
786: x_msg_data OUT NOCOPY VARCHAR2 ,
787: -- *** Receipt Info. parameters *****
788: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
789: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
790: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
791: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
792: p_cancel_claim_flag IN VARCHAR2 ,

Line 789: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

785: x_msg_count OUT NOCOPY NUMBER ,
786: x_msg_data OUT NOCOPY VARCHAR2 ,
787: -- *** Receipt Info. parameters *****
788: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
789: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
790: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
791: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE ,
792: p_cancel_claim_flag IN VARCHAR2 ,
793: p_called_from IN VARCHAR2

Line 923: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

919: x_return_status OUT NOCOPY VARCHAR2,
920: x_msg_count OUT NOCOPY NUMBER,
921: x_msg_data OUT NOCOPY VARCHAR2,
922: -- Receipt application parameters.
923: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
924: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
925: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

Line 924: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

920: x_msg_count OUT NOCOPY NUMBER,
921: x_msg_data OUT NOCOPY VARCHAR2,
922: -- Receipt application parameters.
923: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
924: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
925: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,

Line 926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,

922: -- Receipt application parameters.
923: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
924: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
925: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,

Line 927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,

923: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
924: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
925: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
926: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE ,
927: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE ,
928: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE ,
929: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE ,
930: p_apply_date IN ar_receivable_applications.apply_date%TYPE ,
931: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE ,