[Home] [Help]
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,
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(
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,
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,
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,
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_num%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,
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,
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;
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: -- Receipt application parameters.
364: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
365: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
366: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
367: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: -- Receipt application parameters.
364: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
365: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
366: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
367: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
368: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
369: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
406: x_return_status OUT NOCOPY VARCHAR2,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,
409: -- Receipt application parameters.
410: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
411: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
412: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
413: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
414: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
407: x_msg_count OUT NOCOPY NUMBER,
408: x_msg_data OUT NOCOPY VARCHAR2,
409: -- Receipt application parameters.
410: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
411: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
412: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
413: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
414: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
415: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
469: x_return_status OUT NOCOPY VARCHAR2 ,
470: x_msg_count OUT NOCOPY NUMBER ,
471: x_msg_data OUT NOCOPY VARCHAR2 ,
472: -- *** Receipt Info. parameters *****
473: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
474: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
475: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
470: x_msg_count OUT NOCOPY NUMBER ,
471: x_msg_data OUT NOCOPY VARCHAR2 ,
472: -- *** Receipt Info. parameters *****
473: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
474: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
475: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
476: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
477: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
478: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
502: x_msg_count OUT NOCOPY NUMBER,
503: x_msg_data OUT NOCOPY VARCHAR2,
504: -- Receipt info. parameters
505: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
506: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
507: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
508: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
504: -- Receipt info. parameters
505: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
506: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
507: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
508: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
505: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
506: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
507: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
508: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
506: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
507: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
508: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
514: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
507: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
508: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
514: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
515: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
508: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
514: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
515: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
516: p_maturity_date IN DATE DEFAULT NULL,
509: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
514: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
515: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
516: p_maturity_date IN DATE DEFAULT NULL,
517: p_postmark_date IN DATE DEFAULT NULL,
510: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
511: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
512: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL,
513: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
514: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
515: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
516: p_maturity_date IN DATE DEFAULT NULL,
517: p_postmark_date IN DATE DEFAULT NULL,
518: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
514: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
515: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
516: p_maturity_date IN DATE DEFAULT NULL,
517: p_postmark_date IN DATE DEFAULT NULL,
518: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
519: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
520: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
521: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
522: /* 6612301 */
517: p_postmark_date IN DATE DEFAULT NULL,
518: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
519: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
520: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
521: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL,
522: /* 6612301 */
523: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL,
524: p_customer_bank_account_name IN iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL,
525: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
525: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
526: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
527: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
528: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
529: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
530: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
531: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
532: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
533: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
526: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
527: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
528: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
529: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
530: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
531: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
532: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
533: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
534: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
527: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
528: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --The default site use bug4448307-4509459.
529: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL,
530: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
531: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
532: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
533: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
534: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
535: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
530: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
531: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
532: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
533: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
534: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
535: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
536: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
537: p_doc_sequence_value IN NUMBER DEFAULT NULL,
538: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
531: p_remittance_bank_account_id IN ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL,
532: p_remittance_bank_account_num IN ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL,
533: p_remittance_bank_account_name IN ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL,
534: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
535: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
536: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
537: p_doc_sequence_value IN NUMBER DEFAULT NULL,
538: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
539: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
534: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
535: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
536: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
537: p_doc_sequence_value IN NUMBER DEFAULT NULL,
538: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
539: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
540: p_called_from IN VARCHAR2 DEFAULT NULL,
541: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
542: -- ******* Global Flexfield parameters *******
535: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
536: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
537: p_doc_sequence_value IN NUMBER DEFAULT NULL,
538: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL,
539: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE DEFAULT NULL,
540: p_called_from IN VARCHAR2 DEFAULT NULL,
541: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
542: -- ******* Global Flexfield parameters *******
543: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
542: -- ******* Global Flexfield parameters *******
543: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
544: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
545: -- *** Notes Receivable Additional Information ***
546: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
547: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
548: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
549: -- ** OUT NOCOPY variables for Creating receipt
550: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
543: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const,
544: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
545: -- *** Notes Receivable Additional Information ***
546: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
547: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
548: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
549: -- ** OUT NOCOPY variables for Creating receipt
550: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
551: -- Receipt application parameters
544: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
545: -- *** Notes Receivable Additional Information ***
546: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
547: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
548: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
549: -- ** OUT NOCOPY variables for Creating receipt
550: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
551: -- Receipt application parameters
552: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
546: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
547: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
548: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
549: -- ** OUT NOCOPY variables for Creating receipt
550: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
551: -- Receipt application parameters
552: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
553: p_trx_number IN ra_customer_trx.trx_number%TYPE DEFAULT NULL,
554: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL,
594: x_return_status OUT NOCOPY VARCHAR2,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2,
597: -- Receipt reversal related parameters
598: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
599: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
600: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
601: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
602: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2,
597: -- Receipt reversal related parameters
598: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
599: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
600: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
601: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
602: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
603: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
596: x_msg_data OUT NOCOPY VARCHAR2,
597: -- Receipt reversal related parameters
598: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
599: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
600: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
601: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
602: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
603: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
604: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
599: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
600: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
601: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
602: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
603: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
604: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
605: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
606: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
607: p_called_from IN VARCHAR2 DEFAULT NULL,
600: p_reversal_category_code IN ar_cash_receipts.reversal_category%TYPE DEFAULT NULL,
601: p_reversal_category_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
602: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
603: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
604: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
605: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
606: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
607: p_called_from IN VARCHAR2 DEFAULT NULL,
608: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
602: p_reversal_gl_date IN ar_cash_receipt_history.reversal_gl_date%TYPE DEFAULT NULL,
603: p_reversal_date IN ar_cash_receipts.reversal_date%TYPE DEFAULT NULL,
604: p_reversal_reason_code IN ar_cash_receipts.reversal_reason_code%TYPE DEFAULT NULL,
605: p_reversal_reason_name IN ar_lookups.meaning%TYPE DEFAULT NULL,
606: p_reversal_comments IN ar_cash_receipts.reversal_comments%TYPE DEFAULT NULL,
607: p_called_from IN VARCHAR2 DEFAULT NULL,
608: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
609: --p_global_attribute_rec IN global_attribute_rec_type_upd DEFAULT global_attribute_rec_upd_cons
610: p_global_attribute_rec IN global_attribute_rec_type DEFAULT global_attribute_rec_const ,
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2,
632: -- Receipt application parameters.
633: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
634: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2,
632: -- Receipt application parameters.
633: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
634: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
635: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
636: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
637: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
638: p_ussgl_transaction_code IN ar_receivable_applications.ussgl_transaction_code%TYPE DEFAULT NULL,
670: x_return_status OUT NOCOPY VARCHAR2 ,
671: x_msg_count OUT NOCOPY NUMBER ,
672: x_msg_data OUT NOCOPY VARCHAR2 ,
673: -- *** Receipt Info. parameters *****
674: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
675: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
676: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
677: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
678: p_org_id IN NUMBER DEFAULT NULL
671: x_msg_count OUT NOCOPY NUMBER ,
672: x_msg_data OUT NOCOPY VARCHAR2 ,
673: -- *** Receipt Info. parameters *****
674: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
675: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
676: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
677: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
678: p_org_id IN NUMBER DEFAULT NULL
679: );
696: x_return_status OUT NOCOPY VARCHAR2,
697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,
699: -- Receipt application parameters.
700: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
701: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
702: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
697: x_msg_count OUT NOCOPY NUMBER,
698: x_msg_data OUT NOCOPY VARCHAR2,
699: -- Receipt application parameters.
700: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
701: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
702: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
703: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE, --this has no default
704: p_link_to_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL,
705: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE, --this has no default
723: p_customer_reference IN ar_receivable_applications.customer_reference%TYPE DEFAULT NULL,
724: p_val_writeoff_limits_flag IN VARCHAR2 DEFAULT 'Y',
725: p_called_from IN VARCHAR2 DEFAULT NULL,
726: p_netted_receipt_flag IN VARCHAR2 DEFAULT NULL,
727: p_netted_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
728: p_secondary_app_ref_type IN
729: ar_receivable_applications.secondary_application_ref_type%TYPE := null,
730: p_secondary_app_ref_num IN
731: ar_receivable_applications.secondary_application_ref_num%TYPE := null,
742: ,p_remittance_message2 IN ap_invoices.remittance_message2%TYPE DEFAULT NULL
743: ,p_remittance_message3 IN ap_invoices.remittance_message3%TYPE DEFAULT NULL
744: ,p_party_id IN hz_parties.party_id%TYPE DEFAULT NULL
745: ,p_party_site_id IN hz_party_sites.party_site_id%TYPE DEFAULT NULL
746: ,p_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL
747: ,p_payment_priority IN ap_invoices_interface.PAYMENT_PRIORITY%TYPE DEFAULT NULL --Bug8290172
748: ,p_terms_id IN ap_invoices_interface.TERMS_ID%TYPE DEFAULT NULL --Bug8290172
749: );
750:
765: x_return_status OUT NOCOPY VARCHAR2 ,
766: x_msg_count OUT NOCOPY NUMBER ,
767: x_msg_data OUT NOCOPY VARCHAR2 ,
768: -- *** Receipt Info. parameters *****
769: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
770: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
771: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
772: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
773: p_called_from IN VARCHAR2,
766: x_msg_count OUT NOCOPY NUMBER ,
767: x_msg_data OUT NOCOPY VARCHAR2 ,
768: -- *** Receipt Info. parameters *****
769: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
770: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
771: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
772: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
773: p_called_from IN VARCHAR2,
774: p_org_id IN NUMBER DEFAULT NULL
794: x_msg_count OUT NOCOPY NUMBER,
795: x_msg_data OUT NOCOPY VARCHAR2,
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797: -- Receipt application parameters.
798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
795: x_msg_data OUT NOCOPY VARCHAR2,
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,
797: -- Receipt application parameters.
798: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
799: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
800: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
801: p_receivables_trx_id IN ar_receivable_applications.receivables_trx_id%TYPE DEFAULT NULL,
802: p_applied_payment_schedule_id IN ar_receivable_applications.applied_payment_schedule_id%TYPE DEFAULT NULL,
803: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
836: x_return_status OUT NOCOPY VARCHAR2 ,
837: x_msg_count OUT NOCOPY NUMBER ,
838: x_msg_data OUT NOCOPY VARCHAR2 ,
839: -- *** Receipt Info. parameters *****
840: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
841: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
842: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
843: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
844: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
837: x_msg_count OUT NOCOPY NUMBER ,
838: x_msg_data OUT NOCOPY VARCHAR2 ,
839: -- *** Receipt Info. parameters *****
840: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
841: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
842: p_receivable_application_id IN ar_receivable_applications.receivable_application_id%TYPE,
843: p_reversal_gl_date IN ar_receivable_applications.reversal_gl_date%TYPE DEFAULT NULL,
844: p_cancel_claim_flag IN VARCHAR2 DEFAULT 'Y',
845: p_called_from IN VARCHAR2 DEFAULT NULL,
899: p_comments IN VARCHAR2 DEFAULT NULL,
900: p_org_id IN NUMBER DEFAULT NULL,
901: p_misc_receipt_id OUT NOCOPY NUMBER,
902: p_called_from IN VARCHAR2 DEFAULT NULL,
903: p_payment_trxn_extension_id In ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL); /* Bug fix 3619780*/
904:
905:
906: Method_Cache_Tbl Rec_Method_Tbl_Type ;
907: Customer_Cache_Tbl Rec_Customer_Tbl_Type;
935: x_return_status OUT NOCOPY VARCHAR2,
936: x_msg_count OUT NOCOPY NUMBER,
937: x_msg_data OUT NOCOPY VARCHAR2,
938: -- Receipt application parameters.
939: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
940: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
936: x_msg_count OUT NOCOPY NUMBER,
937: x_msg_data OUT NOCOPY VARCHAR2,
938: -- Receipt application parameters.
939: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
940: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
938: -- Receipt application parameters.
939: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
940: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
939: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
940: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
941: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
942: p_open_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
943: p_open_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
944: p_open_rec_app_id IN ar_receivable_applications.receivable_application_id%TYPE DEFAULT NULL,
945: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
946: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
947: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,
1045: x_msg_count OUT NOCOPY NUMBER,
1046: x_msg_data OUT NOCOPY VARCHAR2,
1047: -- Receipt info. parameters
1048: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1049: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1050: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1051: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1047: -- Receipt info. parameters
1048: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1049: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1050: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1051: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1048: p_usr_currency_code IN VARCHAR2 DEFAULT NULL, --the translated currency code
1049: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1050: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1051: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056: DEFAULT NULL,
1049: p_currency_code IN ar_cash_receipts.currency_code%TYPE DEFAULT NULL,
1050: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1051: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056: DEFAULT NULL,
1057: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1050: p_usr_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
1051: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056: DEFAULT NULL,
1057: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1058: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1051: p_exchange_rate_type IN ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL,
1052: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056: DEFAULT NULL,
1057: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1058: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1059: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1053: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056: DEFAULT NULL,
1057: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1058: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1059: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1060: p_maturity_date IN DATE DEFAULT NULL,
1061: p_postmark_date IN DATE DEFAULT NULL,
1054: p_amount IN ar_cash_receipts.amount%TYPE DEFAULT NULL,
1055: p_factor_discount_amount IN ar_cash_receipts.factor_discount_amount%TYPE
1056: DEFAULT NULL,
1057: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
1058: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1059: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1060: p_maturity_date IN DATE DEFAULT NULL,
1061: p_postmark_date IN DATE DEFAULT NULL,
1062: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1058: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1059: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1060: p_maturity_date IN DATE DEFAULT NULL,
1061: p_postmark_date IN DATE DEFAULT NULL,
1062: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1063: /* tca uptake */
1064: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
1065: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
1066: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
1062: p_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
1063: /* tca uptake */
1064: p_customer_name IN hz_parties.party_name%TYPE DEFAULT NULL,
1065: p_customer_number IN hz_cust_accounts.account_number%TYPE DEFAULT NULL,
1066: p_customer_bank_account_id IN ar_cash_receipts.customer_bank_account_id%TYPE
1067: DEFAULT NULL,
1068: /* 6612301 */
1069: p_customer_bank_account_num IN iby_ext_bank_accounts_v.bank_account_number%TYPE
1070: DEFAULT NULL,
1073: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL, --payment uptake changes bichatte
1074: p_location IN hz_cust_site_uses.location%TYPE DEFAULT NULL,
1075: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
1076: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
1077: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
1078: DEFAULT NULL,
1079: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
1080: DEFAULT NULL,
1081: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1075: p_customer_site_use_id IN hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL,
1076: p_default_site_use IN VARCHAR2 DEFAULT 'Y', --bug 4448307-4509459
1077: p_customer_receipt_reference IN ar_cash_receipts.customer_receipt_reference%TYPE
1078: DEFAULT NULL,
1079: p_override_remit_account_flag IN ar_cash_receipts.override_remit_account_flag%TYPE
1080: DEFAULT NULL,
1081: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1082: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1083: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1080: DEFAULT NULL,
1081: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1082: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1083: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1084: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1085: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1086: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1087: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1088: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1081: p_remittance_bank_account_id IN NUMBER DEFAULT NULL,
1082: p_remittance_bank_account_num IN VARCHAR2 DEFAULT NULL,
1083: p_remittance_bank_account_name IN VARCHAR2 DEFAULT NULL,
1084: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1085: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1086: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1087: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1088: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1089: DEFAULT NULL,
1084: p_deposit_date IN ar_cash_receipts.deposit_date%TYPE DEFAULT NULL,
1085: p_receipt_method_id IN ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL,
1086: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1087: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1088: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1089: DEFAULT NULL,
1090: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
1091: DEFAULT NULL,
1092: p_called_from IN VARCHAR2 DEFAULT NULL,
1086: p_receipt_method_name IN ar_receipt_methods.name%TYPE DEFAULT NULL,
1087: p_doc_sequence_value IN NUMBER DEFAULT NULL,
1088: p_ussgl_transaction_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1089: DEFAULT NULL,
1090: p_anticipated_clearing_date IN ar_cash_receipts.anticipated_clearing_date%TYPE
1091: DEFAULT NULL,
1092: p_called_from IN VARCHAR2 DEFAULT NULL,
1093: p_attribute_rec IN attribute_rec_type DEFAULT attribute_rec_const,
1094: -- ******* Global Flexfield parameters *******
1095: p_global_attribute_rec IN global_attribute_rec_type
1096: DEFAULT global_attribute_rec_const,
1097: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1098: -- *** Notes Receivable Additional Information ***
1099: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1100: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1101: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1102: -- ** OUT NOCOPY variables for Creating receipt
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1096: DEFAULT global_attribute_rec_const,
1097: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1098: -- *** Notes Receivable Additional Information ***
1099: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1100: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1101: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1102: -- ** OUT NOCOPY variables for Creating receipt
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104: -- Receipt application parameters
1097: p_receipt_comments IN VARCHAR2 DEFAULT NULL,
1098: -- *** Notes Receivable Additional Information ***
1099: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1100: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1101: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1102: -- ** OUT NOCOPY variables for Creating receipt
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104: -- Receipt application parameters
1105: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1099: p_issuer_name IN ar_cash_receipts.issuer_name%TYPE DEFAULT NULL,
1100: p_issue_date IN ar_cash_receipts.issue_date%TYPE DEFAULT NULL,
1101: p_issuer_bank_branch_id IN ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL,
1102: -- ** OUT NOCOPY variables for Creating receipt
1103: p_cr_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1104: -- Receipt application parameters
1105: p_amount_applied IN ar_receivable_applications.amount_applied%TYPE DEFAULT NULL,
1106: p_apply_date IN ar_receivable_applications.apply_date%TYPE DEFAULT NULL,
1107: p_apply_gl_date IN ar_receivable_applications.gl_date%TYPE DEFAULT NULL,