eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_RECEIPT_API_PUB dependencies on AR_CASH_RECEIPTS

Line 93: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE

89:
90: TYPE Receipt_Method_Rec IS RECORD
91: (
92: receipt_method_id ar_receipt_methods.receipt_method_id%TYPE,
93: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE
94: );
95:
96: TYPE Customer_Rec IS RECORD
97: (customer_id ar_cash_receipts.pay_from_customer%TYPE,

Line 97: (customer_id ar_cash_receipts.pay_from_customer%TYPE,

93: remit_bank_acct_use_id ar_cash_receipts.remit_bank_acct_use_id%TYPE
94: );
95:
96: TYPE Customer_Rec IS RECORD
97: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
98: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
99: );
100:
101: TYPE attribute_rec_type IS RECORD(

Line 98: site_use_id ar_cash_receipts.customer_site_use_id%TYPE

94: );
95:
96: TYPE Customer_Rec IS RECORD
97: (customer_id ar_cash_receipts.pay_from_customer%TYPE,
98: site_use_id ar_cash_receipts.customer_site_use_id%TYPE
99: );
100:
101: TYPE attribute_rec_type IS RECORD(
102: attribute_category VARCHAR2(30) DEFAULT NULL,

Line 187: ( cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

183:
184: TYPE Rec_Customer_Tbl_Type IS TABLE OF Customer_Rec
185: INDEX BY BINARY_INTEGER;
186: TYPE G_application_rec_type IS RECORD
187: ( cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
188: receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
189: customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 188: receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

184: TYPE Rec_Customer_Tbl_Type IS TABLE OF Customer_Rec
185: INDEX BY BINARY_INTEGER;
186: TYPE G_application_rec_type IS RECORD
187: ( cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
188: receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
189: customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
190: trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL,
191: installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
192: applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 205: customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,

201: customer_number hz_cust_accounts.account_number%TYPE,
202: cust_site_use_id hz_cust_site_uses.site_use_id%TYPE,
203: location hz_cust_site_uses.location%TYPE,
204: /* 6612301 */
205: customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE,
206: customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE,
207: customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE,
208: remit_bank_acct_use_id ce_bank_acct_uses_all.bank_acct_use_id%TYPE,
209: remittance_bank_account_num ce_bank_accounts.bank_account_name%TYPE,

Line 219: receipt_number ar_cash_receipts.receipt_number%TYPE,

215: (trx_number ra_customer_trx.trx_number%TYPE,
216: customer_trx_id ar_receivable_applications.customer_trx_id%TYPE,
217: applied_ps_id ar_receivable_applications.applied_payment_schedule_id%TYPE,
218: cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223: receipt_number ar_cash_receipts.receipt_number%TYPE,

Line 223: receipt_number ar_cash_receipts.receipt_number%TYPE,

219: receipt_number ar_cash_receipts.receipt_number%TYPE,
220: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
221: TYPE G_unapp_on_ac_rec IS RECORD
222: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
223: receipt_number ar_cash_receipts.receipt_number%TYPE,
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225: TYPE G_activity_unapp_rec IS RECORD
226: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
227: receipt_number ar_cash_receipts.receipt_number%TYPE,

Line 227: receipt_number ar_cash_receipts.receipt_number%TYPE,

223: receipt_number ar_cash_receipts.receipt_number%TYPE,
224: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
225: TYPE G_activity_unapp_rec IS RECORD
226: (cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE,
227: receipt_number ar_cash_receipts.receipt_number%TYPE,
228: receivable_application_id ar_receivable_applications.receivable_application_id%TYPE);
229:
230: Original_create_cash_info G_create_cash_rec_type;
231: Original_application_info G_application_rec_type;

Line 354: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

350: x_return_status OUT NOCOPY VARCHAR2,
351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: -- Receipt application parameters.
354: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
355: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
356: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
357: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 355: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

351: x_msg_count OUT NOCOPY NUMBER,
352: x_msg_data OUT NOCOPY VARCHAR2,
353: -- Receipt application parameters.
354: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
355: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
356: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
357: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
358: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
359: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 400: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

396: x_return_status OUT NOCOPY VARCHAR2,
397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2,
399: -- Receipt application parameters.
400: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
401: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
402: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
403: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
404: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 401: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

397: x_msg_count OUT NOCOPY NUMBER,
398: x_msg_data OUT NOCOPY VARCHAR2,
399: -- Receipt application parameters.
400: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
401: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
402: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
403: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
404: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
405: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 463: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

459: x_return_status OUT NOCOPY VARCHAR2 ,
460: x_msg_count OUT NOCOPY NUMBER ,
461: x_msg_data OUT NOCOPY VARCHAR2 ,
462: -- *** Receipt Info. parameters *****
463: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
464: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
465: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
466: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 464: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

460: x_msg_count OUT NOCOPY NUMBER ,
461: x_msg_data OUT NOCOPY VARCHAR2 ,
462: -- *** Receipt Info. parameters *****
463: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
464: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
465: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
466: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
467: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
468: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

Line 496: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

492: x_msg_count OUT NOCOPY NUMBER,
493: x_msg_data OUT NOCOPY VARCHAR2,
494: -- Receipt info. parameters
495: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
496: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
497: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

Line 498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,

494: -- Receipt info. parameters
495: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
496: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
497: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

Line 499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,

495: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
496: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
497: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

496: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
497: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

Line 501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,

497: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
505: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

Line 502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,

498: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
505: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
506: p_maturity_date IN DATE DEFAULT NULL,

Line 503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

499: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
505: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
506: p_maturity_date IN DATE DEFAULT NULL,
507: p_postmark_date IN DATE DEFAULT NULL,

Line 504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

500: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
501: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
502: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
503: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
505: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
506: p_maturity_date IN DATE DEFAULT NULL,
507: p_postmark_date IN DATE DEFAULT NULL,
508: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 508: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

504: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
505: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
506: p_maturity_date IN DATE DEFAULT NULL,
507: p_postmark_date IN DATE DEFAULT NULL,
508: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
509: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
510: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
511: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
512: /* 6612301 */

Line 511: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,

507: p_postmark_date IN DATE DEFAULT NULL,
508: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
509: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
510: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
511: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
512: /* 6612301 */
513: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
514: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
515: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte

Line 519: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,

515: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
516: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
517: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
518: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
519: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,

Line 520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

516: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
517: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
518: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
519: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

Line 521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,

517: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
518: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
519: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

Line 524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

520: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
527: p_doc_sequence_value IN NUMBER DEFAULT NULL,
528: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

521: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
522: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
523: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
527: p_doc_sequence_value IN NUMBER DEFAULT NULL,
528: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
529: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

Line 528: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,

524: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
527: p_doc_sequence_value IN NUMBER DEFAULT NULL,
528: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
529: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
530: p_called_from IN VARCHAR2 DEFAULT NULL,
531: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
532: -- ******* Global Flexfield parameters *******

Line 529: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,

525: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
526: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
527: p_doc_sequence_value IN NUMBER DEFAULT NULL,
528: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
529: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
530: p_called_from IN VARCHAR2 DEFAULT NULL,
531: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
532: -- ******* Global Flexfield parameters *******
533: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,

Line 536: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,

532: -- ******* Global Flexfield parameters *******
533: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
534: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
535: -- *** Notes Receivable Additional Information ***
536: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
537: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
538: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
539: -- ** OUT NOCOPY variables for Creating receipt
540: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 537: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,

533: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
534: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
535: -- *** Notes Receivable Additional Information ***
536: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
537: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
538: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
539: -- ** OUT NOCOPY variables for Creating receipt
540: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
541: -- Receipt application parameters

Line 538: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,

534: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
535: -- *** Notes Receivable Additional Information ***
536: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
537: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
538: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
539: -- ** OUT NOCOPY variables for Creating receipt
540: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
541: -- Receipt application parameters
542: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

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

536: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
537: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
538: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
539: -- ** OUT NOCOPY variables for Creating receipt
540: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
541: -- Receipt application parameters
542: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
543: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
544: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,

Line 588: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: -- Receipt reversal related parameters
588: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
589: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
590: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
591: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
592: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,

Line 589: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: -- Receipt reversal related parameters
588: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
589: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
590: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
591: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
592: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
593: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,

Line 590: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,

586: x_msg_data OUT NOCOPY VARCHAR2,
587: -- Receipt reversal related parameters
588: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
589: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
590: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
591: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
592: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
593: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
594: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,

Line 593: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,

589: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
590: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
591: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
592: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
593: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
594: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
595: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
596: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
597: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 594: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,

590: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
591: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
592: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
593: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
594: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
595: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
596: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
597: p_called_from IN VARCHAR2 DEFAULT NULL,
598: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,

Line 596: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,

592: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
593: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
594: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
595: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
596: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
597: p_called_from IN VARCHAR2 DEFAULT NULL,
598: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
599: --p_global_attribute_rec IN global_attribute_rec_type_upd DEFAULT global_attribute_rec_upd_cons
600: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const ,

Line 623: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

619: x_return_status OUT NOCOPY VARCHAR2,
620: x_msg_count OUT NOCOPY NUMBER,
621: x_msg_data OUT NOCOPY VARCHAR2,
622: -- Receipt application parameters.
623: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

620: x_msg_count OUT NOCOPY NUMBER,
621: x_msg_data OUT NOCOPY VARCHAR2,
622: -- Receipt application parameters.
623: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
624: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
625: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
626: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
627: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
628: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,

Line 664: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

660: x_return_status OUT NOCOPY VARCHAR2 ,
661: x_msg_count OUT NOCOPY NUMBER ,
662: x_msg_data OUT NOCOPY VARCHAR2 ,
663: -- *** Receipt Info. parameters *****
664: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
665: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
666: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
667: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
668: p_org_id IN NUMBER DEFAULT NULL

Line 665: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

661: x_msg_count OUT NOCOPY NUMBER ,
662: x_msg_data OUT NOCOPY VARCHAR2 ,
663: -- *** Receipt Info. parameters *****
664: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
665: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
666: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
667: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
668: p_org_id IN NUMBER DEFAULT NULL
669: );

Line 690: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

686: x_return_status OUT NOCOPY VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,
689: -- Receipt application parameters.
690: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
691: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
692: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,

Line 691: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

687: x_msg_count OUT NOCOPY NUMBER,
688: x_msg_data OUT NOCOPY VARCHAR2,
689: -- Receipt application parameters.
690: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
691: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
692: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
693: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
694: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
695: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default

Line 717: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

713: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
714: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
715: p_called_from IN VARCHAR2 DEFAULT NULL,
716: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
717: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
718: p_secondary_app_ref_type IN
719: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
720: p_secondary_app_ref_num IN
721: ar_receivable_applications.secondary_application_ref_num%TYPE := null,

Line 736: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL

732: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE DEFAULT NULL
733: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE DEFAULT NULL
734: ,p_party_id IN hz_parties.party_id%TYPE DEFAULT NULL
735: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE DEFAULT NULL
736: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL
737: );
738:
739: /*#
740: * Use this procedure to create a reversal of an activity application

Line 757: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

753: x_return_status OUT NOCOPY VARCHAR2 ,
754: x_msg_count OUT NOCOPY NUMBER ,
755: x_msg_data OUT NOCOPY VARCHAR2 ,
756: -- *** Receipt Info. parameters *****
757: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
758: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
759: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
760: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
761: p_called_from IN VARCHAR2,

Line 758: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

754: x_msg_count OUT NOCOPY NUMBER ,
755: x_msg_data OUT NOCOPY VARCHAR2 ,
756: -- *** Receipt Info. parameters *****
757: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
758: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
759: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
760: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
761: p_called_from IN VARCHAR2,
762: p_org_id IN NUMBER DEFAULT NULL

Line 786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

782: x_msg_count OUT NOCOPY NUMBER,
783: x_msg_data OUT NOCOPY VARCHAR2,
784: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
785: -- Receipt application parameters.
786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,

Line 787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

783: x_msg_data OUT NOCOPY VARCHAR2,
784: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
785: -- Receipt application parameters.
786: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
787: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
788: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
789: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
790: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
791: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

Line 828: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

824: x_return_status OUT NOCOPY VARCHAR2 ,
825: x_msg_count OUT NOCOPY NUMBER ,
826: x_msg_data OUT NOCOPY VARCHAR2 ,
827: -- *** Receipt Info. parameters *****
828: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
829: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
830: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
831: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
832: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',

Line 829: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

825: x_msg_count OUT NOCOPY NUMBER ,
826: x_msg_data OUT NOCOPY VARCHAR2 ,
827: -- *** Receipt Info. parameters *****
828: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
829: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
830: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
831: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
832: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
833: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 891: p_payment_trxn_extension_id In ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL); /* Bug fix 3619780*/

887: p_comments IN VARCHAR2 DEFAULT NULL,
888: p_org_id IN NUMBER DEFAULT NULL,
889: p_misc_receipt_id OUT NOCOPY NUMBER,
890: p_called_from IN VARCHAR2 DEFAULT NULL,
891: p_payment_trxn_extension_id In ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL); /* Bug fix 3619780*/
892:
893:
894: Method_Cache_Tbl Rec_Method_Tbl_Type ;
895: Customer_Cache_Tbl Rec_Customer_Tbl_Type;

Line 927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

923: x_return_status OUT NOCOPY VARCHAR2,
924: x_msg_count OUT NOCOPY NUMBER,
925: x_msg_data OUT NOCOPY VARCHAR2,
926: -- Receipt application parameters.
927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

924: x_msg_count OUT NOCOPY NUMBER,
925: x_msg_data OUT NOCOPY VARCHAR2,
926: -- Receipt application parameters.
927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,

Line 930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

926: -- Receipt application parameters.
927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,

Line 931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

927: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
928: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
929: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
930: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
931: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
932: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
933: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
934: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
935: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,

Line 1037: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,

1033: x_msg_count OUT NOCOPY NUMBER,
1034: x_msg_data OUT NOCOPY VARCHAR2,
1035: -- Receipt info. parameters
1036: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1037: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1038: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

Line 1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,

1035: -- Receipt info. parameters
1036: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1037: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1038: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE

Line 1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,

1036: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1037: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1038: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044: DEFAULT NULL,

Line 1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,

1037: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1038: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044: DEFAULT NULL,
1045: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

Line 1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,

1038: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044: DEFAULT NULL,
1045: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1046: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

Line 1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE

1039: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1040: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044: DEFAULT NULL,
1045: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1046: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1047: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,

Line 1045: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,

1041: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044: DEFAULT NULL,
1045: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1046: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1047: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1048: p_maturity_date IN DATE DEFAULT NULL,
1049: p_postmark_date IN DATE DEFAULT NULL,

Line 1046: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

1042: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1043: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1044: DEFAULT NULL,
1045: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1046: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1047: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1048: p_maturity_date IN DATE DEFAULT NULL,
1049: p_postmark_date IN DATE DEFAULT NULL,
1050: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

Line 1050: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

1046: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1047: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1048: p_maturity_date IN DATE DEFAULT NULL,
1049: p_postmark_date IN DATE DEFAULT NULL,
1050: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1051: /* tca uptake */
1052: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
1053: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
1054: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE

Line 1054: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE

1050: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1051: /* tca uptake */
1052: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
1053: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
1054: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
1055: DEFAULT NULL,
1056: /* 6612301 */
1057: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
1058: DEFAULT NULL,

Line 1065: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE

1061: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
1062: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
1063: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
1064: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
1065: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
1066: DEFAULT NULL,
1067: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
1068: DEFAULT NULL,
1069: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,

Line 1067: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE

1063: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
1064: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
1065: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
1066: DEFAULT NULL,
1067: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
1068: DEFAULT NULL,
1069: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1070: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1071: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,

Line 1072: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,

1068: DEFAULT NULL,
1069: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1070: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1071: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1072: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1073: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1074: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1075: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1076: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE

Line 1073: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,

1069: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1070: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1071: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1072: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1073: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1074: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1075: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1076: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1077: DEFAULT NULL,

Line 1076: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE

1072: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1073: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1074: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1075: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1076: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1077: DEFAULT NULL,
1078: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
1079: DEFAULT NULL,
1080: p_called_from IN VARCHAR2 DEFAULT NULL,

Line 1078: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE

1074: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1075: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1076: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1077: DEFAULT NULL,
1078: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
1079: DEFAULT NULL,
1080: p_called_from IN VARCHAR2 DEFAULT NULL,
1081: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1082: -- ******* Global Flexfield parameters *******

Line 1087: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,

1083: p_global_attribute_rec IN global_attribute_rec_type
1084: DEFAULT global_attribute_rec_const,
1085: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1086: -- *** Notes Receivable Additional Information ***
1087: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1088: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1089: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1090: -- ** OUT NOCOPY variables for Creating receipt
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,

Line 1088: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,

1084: DEFAULT global_attribute_rec_const,
1085: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1086: -- *** Notes Receivable Additional Information ***
1087: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1088: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1089: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1090: -- ** OUT NOCOPY variables for Creating receipt
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092: -- Receipt application parameters

Line 1089: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,

1085: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1086: -- *** Notes Receivable Additional Information ***
1087: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1088: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1089: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1090: -- ** OUT NOCOPY variables for Creating receipt
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092: -- Receipt application parameters
1093: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,

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

1087: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1088: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1089: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1090: -- ** OUT NOCOPY variables for Creating receipt
1091: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1092: -- Receipt application parameters
1093: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1094: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1095: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,