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.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_CASH_RECEIPTS

Line 453: l_usr_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;

449: )IS
450: l_api_version NUMBER := 1.0;
451: l_api_name VARCHAR2(50) := 'create_emd_receipt_and_apply';
452: l_progress NUMBER;
453: l_usr_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;

Line 454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;

450: l_api_version NUMBER := 1.0;
451: l_api_name VARCHAR2(50) := 'create_emd_receipt_and_apply';
452: l_progress NUMBER;
453: l_usr_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;

Line 455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;

451: l_api_name VARCHAR2(50) := 'create_emd_receipt_and_apply';
452: l_progress NUMBER;
453: l_usr_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;

Line 456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;

452: l_progress NUMBER;
453: l_usr_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;

Line 457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;

453: l_usr_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;

Line 458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;

454: l_currency_code ar_cash_receipts.currency_code%TYPE DEFAULT NULL;
455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;

Line 459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;

455: l_usr_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;
463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;

Line 460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;

456: l_exchange_rate_type ar_cash_receipts.exchange_rate_type%TYPE DEFAULT NULL;
457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;
463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;
464: l_maturity_date DATE DEFAULT NULL;

Line 461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;

457: l_exchange_rate ar_cash_receipts.exchange_rate%TYPE DEFAULT NULL;
458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;
463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;
464: l_maturity_date DATE DEFAULT NULL;
465: l_postmark_date DATE DEFAULT NULL;

Line 462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;

458: l_exchange_date ar_cash_receipts.exchange_date%TYPE DEFAULT NULL;
459: l_amount ar_cash_receipts.amount%TYPE DEFAULT NULL;
460: l_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE DEFAULT NULL;
461: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;
463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;
464: l_maturity_date DATE DEFAULT NULL;
465: l_postmark_date DATE DEFAULT NULL;
466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;

Line 466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;

462: l_receipt_date ar_cash_receipts.receipt_date%TYPE DEFAULT NULL;
463: l_gl_date ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL;
464: l_maturity_date DATE DEFAULT NULL;
465: l_postmark_date DATE DEFAULT NULL;
466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;
467: l_customer_name hz_parties.party_name%TYPE DEFAULT NULL;
468: l_customer_number hz_parties.party_number%TYPE DEFAULT NULL;
469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;

Line 469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;

465: l_postmark_date DATE DEFAULT NULL;
466: l_customer_id ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL;
467: l_customer_name hz_parties.party_name%TYPE DEFAULT NULL;
468: l_customer_number hz_parties.party_number%TYPE DEFAULT NULL;
469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;
471: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL;
472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte
473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;

Line 472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte

468: l_customer_number hz_parties.party_number%TYPE DEFAULT NULL;
469: l_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
470: l_customer_bank_account_num iby_ext_bank_accounts_v.bank_account_number%TYPE DEFAULT NULL;
471: l_customer_bank_account_name iby_ext_bank_accounts_v.bank_account_name%TYPE DEFAULT NULL;
472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte
473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;
474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;
475: l_default_site_use VARCHAR2(1) DEFAULT 'Y';
476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;

Line 476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;

472: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE DEFAULT NULL; --payment uptake changes bichatte
473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;
474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;
475: l_default_site_use VARCHAR2(1) DEFAULT 'Y';
476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;
477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;
478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;
479: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL;
480: l_remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL;

Line 477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;

473: l_location hz_cust_site_uses.location%TYPE DEFAULT NULL;
474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;
475: l_default_site_use VARCHAR2(1) DEFAULT 'Y';
476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;
477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;
478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;
479: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL;
480: l_remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL;
481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;

Line 478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;

474: l_customer_site_use_id hz_cust_site_uses.site_use_id%TYPE DEFAULT NULL;
475: l_default_site_use VARCHAR2(1) DEFAULT 'Y';
476: l_customer_receipt_reference ar_cash_receipts.customer_receipt_reference%TYPE DEFAULT NULL;
477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;
478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;
479: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL;
480: l_remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL;
481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;
482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;

Line 481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;

477: l_override_remit_account_flag ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL;
478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;
479: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL;
480: l_remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL;
481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;
482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;
483: l_receipt_method_name ar_receipt_methods.name%TYPE DEFAULT NULL;
484: l_doc_sequence_value NUMBER DEFAULT NULL;
485: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;

Line 482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;

478: l_remittance_bank_account_id ar_cash_receipts.remit_bank_acct_use_id%TYPE DEFAULT NULL;
479: l_remittance_bank_account_num ce_bank_accounts.bank_account_num%TYPE DEFAULT NULL;
480: l_remittance_bank_account_name ce_bank_accounts.bank_account_name%TYPE DEFAULT NULL;
481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;
482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;
483: l_receipt_method_name ar_receipt_methods.name%TYPE DEFAULT NULL;
484: l_doc_sequence_value NUMBER DEFAULT NULL;
485: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
486: l_anticipated_clearing_date ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;

Line 485: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;

481: l_deposit_date ar_cash_receipts.deposit_date%TYPE DEFAULT NULL;
482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;
483: l_receipt_method_name ar_receipt_methods.name%TYPE DEFAULT NULL;
484: l_doc_sequence_value NUMBER DEFAULT NULL;
485: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
486: l_anticipated_clearing_date ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
487: l_called_from VARCHAR2(20) DEFAULT NULL;
488: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
489: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;

Line 486: l_anticipated_clearing_date ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;

482: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE DEFAULT NULL;
483: l_receipt_method_name ar_receipt_methods.name%TYPE DEFAULT NULL;
484: l_doc_sequence_value NUMBER DEFAULT NULL;
485: l_ussgl_transaction_code ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
486: l_anticipated_clearing_date ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
487: l_called_from VARCHAR2(20) DEFAULT NULL;
488: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
489: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
490: l_comments ar_cash_receipts.comments%TYPE DEFAULT NULL;

Line 490: l_comments ar_cash_receipts.comments%TYPE DEFAULT NULL;

486: l_anticipated_clearing_date ar_cash_receipts.ussgl_transaction_code%TYPE DEFAULT NULL;
487: l_called_from VARCHAR2(20) DEFAULT NULL;
488: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
489: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
490: l_comments ar_cash_receipts.comments%TYPE DEFAULT NULL;
491: l_issuer_name ar_cash_receipts.issuer_name%TYPE DEFAULT NULL;
492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;
493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;
494: l_cr_id NUMBER DEFAULT NULL;

Line 491: l_issuer_name ar_cash_receipts.issuer_name%TYPE DEFAULT NULL;

487: l_called_from VARCHAR2(20) DEFAULT NULL;
488: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
489: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
490: l_comments ar_cash_receipts.comments%TYPE DEFAULT NULL;
491: l_issuer_name ar_cash_receipts.issuer_name%TYPE DEFAULT NULL;
492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;
493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;
494: l_cr_id NUMBER DEFAULT NULL;
495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;

Line 492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;

488: l_attribute_rec AR_RECEIPT_API_PUB.attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.attribute_rec_const;
489: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
490: l_comments ar_cash_receipts.comments%TYPE DEFAULT NULL;
491: l_issuer_name ar_cash_receipts.issuer_name%TYPE DEFAULT NULL;
492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;
493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;
494: l_cr_id NUMBER DEFAULT NULL;
495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;

Line 493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;

489: l_global_attribute_rec AR_RECEIPT_API_PUB.global_attribute_rec_type DEFAULT AR_RECEIPT_API_PUB.global_attribute_rec_const;
490: l_comments ar_cash_receipts.comments%TYPE DEFAULT NULL;
491: l_issuer_name ar_cash_receipts.issuer_name%TYPE DEFAULT NULL;
492: l_issue_date ar_cash_receipts.issue_date%TYPE DEFAULT NULL;
493: l_issuer_bank_branch_id ar_cash_receipts.issuer_bank_branch_id%TYPE DEFAULT NULL;
494: l_cr_id NUMBER DEFAULT NULL;
495: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
496: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
497: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;

Line 661: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;

657:
658: l_api_version NUMBER := 1.0;
659: l_api_name VARCHAR2(50) := 'unapply_emd_receipt';
660: l_progress NUMBER;
661: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
662: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
663: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
665: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;

Line 662: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;

658: l_api_version NUMBER := 1.0;
659: l_api_name VARCHAR2(50) := 'unapply_emd_receipt';
660: l_progress NUMBER;
661: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
662: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
663: l_trx_number ra_customer_trx.trx_number%TYPE DEFAULT NULL;
664: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
665: l_installment ar_payment_schedules.terms_sequence_number%TYPE DEFAULT NULL;
666: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL;

Line 785: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;

781:
782: l_api_version NUMBER := 1.0;
783: l_api_name VARCHAR2(50) := 'refund_activity_on_emd_receipt';
784: l_progress NUMBER;
785: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
786: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;

Line 786: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;

782: l_api_version NUMBER := 1.0;
783: l_api_name VARCHAR2(50) := 'refund_activity_on_emd_receipt';
784: l_progress NUMBER;
785: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
786: l_receipt_number ar_cash_receipts.receipt_number%TYPE DEFAULT NULL;
787: l_amount_applied ar_receivable_applications.amount_applied%TYPE DEFAULT NULL;
788: l_applied_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE; --this has no default
789: l_link_to_customer_trx_id ra_customer_trx.customer_trx_id%TYPE DEFAULT NULL;
790: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE; --this has no default

Line 807: l_netted_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;

803: l_customer_reference ar_receivable_applications.customer_reference%TYPE DEFAULT NULL;
804: l_val_writeoff_limits_flag VARCHAR2(1);
805: l_called_from VARCHAR2(30) DEFAULT NULL;
806: l_netted_receipt_flag VARCHAR2(1) DEFAULT NULL;
807: l_netted_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL;
808: l_secondary_apl_ref_type ar_receivable_applications.secondary_application_ref_type%TYPE := null;
809: l_secondary_apl_ref_num ar_receivable_applications.secondary_application_ref_num%TYPE := null;
810: l_org_id NUMBER DEFAULT NULL;
811: l_customer_reason ar_receivable_applications.customer_reason%TYPE DEFAULT NULL;

Line 823: l_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;

819: l_remittance_message2 ap_invoices.remittance_message2%TYPE DEFAULT NULL;
820: l_remittance_message3 ap_invoices.remittance_message3%TYPE DEFAULT NULL;
821: l_party_id hz_parties.party_id%TYPE DEFAULT NULL;
822: l_party_site_id hz_party_sites.party_site_id%TYPE DEFAULT NULL;
823: l_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE DEFAULT NULL;
824: x_msg_count NUMBER;
825: x_msg_data VARCHAR2(1000);
826: l_organization_name hr_operating_units.NAME%TYPE;
827:

Line 2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;

2171: x_location hz_locations.city%TYPE := NULL;
2172:
2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;

Line 2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

2172:
2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 2177: x_receipt_status ar_cash_receipts_all.status%TYPE;

2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2181: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

Line 2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;

2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:

Line 2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

Line 2784: x_receipt_status ar_cash_receipts_all.status%TYPE;

2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

Line 4332: ar_cash_receipts_all acr

4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id
4334: AND arp.org_id = p_org_id
4335: AND arp.status = 'APP'
4336: AND arp.applied_customer_trx_id = rct.customer_trx_id

Line 4364: ar_cash_receipts_all acr

4360: acrh.status
4361: INTO x_receipt_num,
4362: x_receipt_status
4363: FROM ar_cash_Receipt_history_all acrh,
4364: ar_cash_receipts_all acr
4365: WHERE acrh.cash_receipt_id =acr.cash_receipt_id
4366: AND acrh.current_record_flag = 'Y'
4367: AND acrh.status = 'CLEARED'
4368: AND acr.cash_receipt_id = x_cash_receipt_id;