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_DEPOSIT_API_PUB dependencies on RA_CUSTOMER_TRX

Line 502: ra_customer_trx.trx_number%type,

498: p_org_id IN NUMBER DEFAULT NULL,
499: p_payment_trxn_extension_id IN NUMBER DEFAULT NULL,
500: -- ** OUT NOCOPY variables
501: X_new_trx_number OUT NOCOPY
502: ra_customer_trx.trx_number%type,
503: X_new_customer_trx_id OUT NOCOPY
504: ra_customer_trx.customer_trx_id%type,
505: X_new_customer_trx_line_id OUT NOCOPY
506: ra_customer_trx_lines.customer_trx_line_id%type,

Line 504: ra_customer_trx.customer_trx_id%type,

500: -- ** OUT NOCOPY variables
501: X_new_trx_number OUT NOCOPY
502: ra_customer_trx.trx_number%type,
503: X_new_customer_trx_id OUT NOCOPY
504: ra_customer_trx.customer_trx_id%type,
505: X_new_customer_trx_line_id OUT NOCOPY
506: ra_customer_trx_lines.customer_trx_line_id%type,
507: X_new_rowid OUT NOCOPY VARCHAR2 ) IS
508:

Line 506: ra_customer_trx_lines.customer_trx_line_id%type,

502: ra_customer_trx.trx_number%type,
503: X_new_customer_trx_id OUT NOCOPY
504: ra_customer_trx.customer_trx_id%type,
505: X_new_customer_trx_line_id OUT NOCOPY
506: ra_customer_trx_lines.customer_trx_line_id%type,
507: X_new_rowid OUT NOCOPY VARCHAR2 ) IS
508:
509: /*-----------------------------------------------------------------------+
510: | Local Variable Declarations and initializations |

Line 516: l_deposit_number ra_customer_trx_all.trx_number%type;

512:
513: l_api_name CONSTANT VARCHAR2(20) := 'Create_Deposit';
514: l_api_version CONSTANT NUMBER := 1.0;
515:
516: l_deposit_number ra_customer_trx_all.trx_number%type;
517: l_default_batch_source_id ra_batch_sources.batch_source_id%type;
518: l_default_batch_source_name ra_batch_sources.name%type;
519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;

Line 553: l_printing_pending ra_customer_trx_all.printing_pending%type;

549: l_term_id ra_terms.term_id%type;
550: l_salesrep_id ra_salesreps.salesrep_id%type;
551: l_default_salesrep_id ra_salesreps.salesrep_id%type;
552: l_dft_bill_to_contact_id Number;
553: l_printing_pending ra_customer_trx_all.printing_pending%type;
554: l_doc_sequence_id NUMBER;
555: l_doc_sequence_value VARCHAR2(50);
556: l_attribute_rec attr_rec_type;
557: l_hd_attribute_rec attr_rec_type;

Line 559: l_new_trx_number ra_customer_trx.trx_number%type;

555: l_doc_sequence_value VARCHAR2(50);
556: l_attribute_rec attr_rec_type;
557: l_hd_attribute_rec attr_rec_type;
558: l_in_comm_attribute_rec attr_rec_type;
559: l_new_trx_number ra_customer_trx.trx_number%type;
560: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;
561: l_new_rowid varchar(18);
562: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
563: l_bill_to_customer_name hz_parties.party_name%type;

Line 560: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;

556: l_attribute_rec attr_rec_type;
557: l_hd_attribute_rec attr_rec_type;
558: l_in_comm_attribute_rec attr_rec_type;
559: l_new_trx_number ra_customer_trx.trx_number%type;
560: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;
561: l_new_rowid varchar(18);
562: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
563: l_bill_to_customer_name hz_parties.party_name%type;
564: l_bill_to_customer_number hz_cust_accounts.account_number%type;

Line 562: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;

558: l_in_comm_attribute_rec attr_rec_type;
559: l_new_trx_number ra_customer_trx.trx_number%type;
560: l_new_customer_trx_id ra_customer_trx.customer_trx_id%type;
561: l_new_rowid varchar(18);
562: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
563: l_bill_to_customer_name hz_parties.party_name%type;
564: l_bill_to_customer_number hz_cust_accounts.account_number%type;
565: l_bill_to_location hz_cust_site_uses.location%type;
566: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;

Line 566: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;

562: l_bill_to_customer_id ra_customer_trx.bill_to_customer_id%type;
563: l_bill_to_customer_name hz_parties.party_name%type;
564: l_bill_to_customer_number hz_cust_accounts.account_number%type;
565: l_bill_to_location hz_cust_site_uses.location%type;
566: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
567: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
568: l_bill_to_contact_first_name hz_parties.person_first_name%type;
569: l_bill_to_contact_last_name hz_parties.person_last_name%type;
570: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;

Line 567: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;

563: l_bill_to_customer_name hz_parties.party_name%type;
564: l_bill_to_customer_number hz_cust_accounts.account_number%type;
565: l_bill_to_location hz_cust_site_uses.location%type;
566: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
567: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
568: l_bill_to_contact_first_name hz_parties.person_first_name%type;
569: l_bill_to_contact_last_name hz_parties.person_last_name%type;
570: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
571: l_ship_to_customer_name hz_parties.party_name%type;

Line 570: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;

566: l_bill_to_site_use_id ra_customer_trx.bill_to_site_use_id%type;
567: l_bill_to_contact_id ra_customer_trx.bill_to_contact_id%type;
568: l_bill_to_contact_first_name hz_parties.person_first_name%type;
569: l_bill_to_contact_last_name hz_parties.person_last_name%type;
570: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
571: l_ship_to_customer_name hz_parties.party_name%type;
572: l_ship_to_customer_number hz_cust_accounts.account_number%type;
573: l_ship_to_location hz_cust_site_uses.location%type;
574: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;

Line 574: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;

570: l_ship_to_customer_id ra_customer_trx.ship_to_customer_id%type;
571: l_ship_to_customer_name hz_parties.party_name%type;
572: l_ship_to_customer_number hz_cust_accounts.account_number%type;
573: l_ship_to_location hz_cust_site_uses.location%type;
574: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
575: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
576: l_ship_to_contact_first_name hz_parties.person_first_name%type;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;

Line 575: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;

571: l_ship_to_customer_name hz_parties.party_name%type;
572: l_ship_to_customer_number hz_cust_accounts.account_number%type;
573: l_ship_to_location hz_cust_site_uses.location%type;
574: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
575: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
576: l_ship_to_contact_first_name hz_parties.person_first_name%type;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;

Line 578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;

574: l_ship_to_site_use_id ra_customer_trx.ship_to_site_use_id%type;
575: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
576: l_ship_to_contact_first_name hz_parties.person_first_name%type;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
582: l_exchange_rate ra_customer_trx.exchange_rate%type;

Line 579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;

575: l_ship_to_contact_id ra_customer_trx.ship_to_contact_id%type;
576: l_ship_to_contact_first_name hz_parties.person_first_name%type;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
582: l_exchange_rate ra_customer_trx.exchange_rate%type;
583: l_exchange_rate_date ra_customer_trx.exchange_date%type;

Line 580: l_currency_code ra_customer_trx.invoice_currency_code%type;

576: l_ship_to_contact_first_name hz_parties.person_first_name%type;
577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
582: l_exchange_rate ra_customer_trx.exchange_rate%type;
583: l_exchange_rate_date ra_customer_trx.exchange_date%type;
584: l_amount NUMBER;

Line 581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;

577: l_ship_to_contact_last_name hz_parties.person_last_name%type;
578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
582: l_exchange_rate ra_customer_trx.exchange_rate%type;
583: l_exchange_rate_date ra_customer_trx.exchange_date%type;
584: l_amount NUMBER;
585: l_memo_line_id NUMBER;

Line 582: l_exchange_rate ra_customer_trx.exchange_rate%type;

578: l_usr_currency_code ra_customer_trx.invoice_currency_code%type;
579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
582: l_exchange_rate ra_customer_trx.exchange_rate%type;
583: l_exchange_rate_date ra_customer_trx.exchange_date%type;
584: l_amount NUMBER;
585: l_memo_line_id NUMBER;
586: l_memo_line_name VARCHAR2(240);

Line 583: l_exchange_rate_date ra_customer_trx.exchange_date%type;

579: l_usr_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
580: l_currency_code ra_customer_trx.invoice_currency_code%type;
581: l_exchange_rate_type ra_customer_trx.exchange_rate_type%type;
582: l_exchange_rate ra_customer_trx.exchange_rate%type;
583: l_exchange_rate_date ra_customer_trx.exchange_date%type;
584: l_amount NUMBER;
585: l_memo_line_id NUMBER;
586: l_memo_line_name VARCHAR2(240);
587: l_inventory_id NUMBER;

Line 590: l_remit_to_address_id ra_customer_trx.remit_to_address_id%type;

586: l_memo_line_name VARCHAR2(240);
587: l_inventory_id NUMBER;
588: l_deposit_date Date;
589: l_gl_date Date;
590: l_remit_to_address_id ra_customer_trx.remit_to_address_id%type;
591: l_cust_location_site_num hz_cust_acct_sites.cust_acct_site_id%type;
592: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%type;
593: l_sold_to_customer_name hz_parties.party_name%type;
594: l_sold_to_customer_number hz_cust_accounts.account_number%type;

Line 592: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%type;

588: l_deposit_date Date;
589: l_gl_date Date;
590: l_remit_to_address_id ra_customer_trx.remit_to_address_id%type;
591: l_cust_location_site_num hz_cust_acct_sites.cust_acct_site_id%type;
592: l_sold_to_customer_id ra_customer_trx.bill_to_customer_id%type;
593: l_sold_to_customer_name hz_parties.party_name%type;
594: l_sold_to_customer_number hz_cust_accounts.account_number%type;
595: l_start_date_commitmenmt DATE;
596: l_end_date_commitmenmt DATE;

Line 597: l_paying_customer_id ra_customer_trx.ship_to_customer_id%type;

593: l_sold_to_customer_name hz_parties.party_name%type;
594: l_sold_to_customer_number hz_cust_accounts.account_number%type;
595: l_start_date_commitmenmt DATE;
596: l_end_date_commitmenmt DATE;
597: l_paying_customer_id ra_customer_trx.ship_to_customer_id%type;
598: l_paying_customer_name hz_parties.party_name%type;
599: l_paying_customer_number hz_cust_accounts.account_number%type;
600: l_paying_location hz_cust_site_uses.location%type;
601: l_paying_site_use_id ra_customer_trx.ship_to_site_use_id%type;

Line 601: l_paying_site_use_id ra_customer_trx.ship_to_site_use_id%type;

597: l_paying_customer_id ra_customer_trx.ship_to_customer_id%type;
598: l_paying_customer_name hz_parties.party_name%type;
599: l_paying_customer_number hz_cust_accounts.account_number%type;
600: l_paying_location hz_cust_site_uses.location%type;
601: l_paying_site_use_id ra_customer_trx.ship_to_site_use_id%type;
602: l_receipt_method_id ra_customer_trx.receipt_method_id%type;
603: l_receipt_method_name ar_receipt_methods.name%type;
604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;
605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;

Line 602: l_receipt_method_id ra_customer_trx.receipt_method_id%type;

598: l_paying_customer_name hz_parties.party_name%type;
599: l_paying_customer_number hz_cust_accounts.account_number%type;
600: l_paying_location hz_cust_site_uses.location%type;
601: l_paying_site_use_id ra_customer_trx.ship_to_site_use_id%type;
602: l_receipt_method_id ra_customer_trx.receipt_method_id%type;
603: l_receipt_method_name ar_receipt_methods.name%type;
604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;
605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;
606: l_cust_bank_account_number ap_bank_accounts.bank_account_num%type;

Line 604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;

600: l_paying_location hz_cust_site_uses.location%type;
601: l_paying_site_use_id ra_customer_trx.ship_to_site_use_id%type;
602: l_receipt_method_id ra_customer_trx.receipt_method_id%type;
603: l_receipt_method_name ar_receipt_methods.name%type;
604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;
605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;
606: l_cust_bank_account_number ap_bank_accounts.bank_account_num%type;
607: l_agreement_id ra_customer_trx.agreement_id%type;
608: l_fin_payment_method_name ar_receipt_methods.name%type;

Line 607: l_agreement_id ra_customer_trx.agreement_id%type;

603: l_receipt_method_name ar_receipt_methods.name%type;
604: l_cust_bank_account_id ra_customer_trx.customer_bank_account_id%type;
605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;
606: l_cust_bank_account_number ap_bank_accounts.bank_account_num%type;
607: l_agreement_id ra_customer_trx.agreement_id%type;
608: l_fin_payment_method_name ar_receipt_methods.name%type;
609: l_fin_receipt_method_id ra_customer_trx.receipt_method_id%type;
610: l_fin_creation_method_code ar_receipt_classes.creation_method_code%type;
611: l_fin_bank_account_num ap_bank_accounts.bank_account_num%type;

Line 609: l_fin_receipt_method_id ra_customer_trx.receipt_method_id%type;

605: l_cust_bank_account_name ap_bank_accounts.bank_account_name%type;
606: l_cust_bank_account_number ap_bank_accounts.bank_account_num%type;
607: l_agreement_id ra_customer_trx.agreement_id%type;
608: l_fin_payment_method_name ar_receipt_methods.name%type;
609: l_fin_receipt_method_id ra_customer_trx.receipt_method_id%type;
610: l_fin_creation_method_code ar_receipt_classes.creation_method_code%type;
611: l_fin_bank_account_num ap_bank_accounts.bank_account_num%type;
612: l_fin_bank_name ce_bank_branches_v.bank_name%type;
613: l_fin_bank_branch_name ce_bank_branches_v.bank_branch_name%type;

Line 615: l_financial_charges ra_customer_trx.finance_charges%type;

611: l_fin_bank_account_num ap_bank_accounts.bank_account_num%type;
612: l_fin_bank_name ce_bank_branches_v.bank_name%type;
613: l_fin_bank_branch_name ce_bank_branches_v.bank_branch_name%type;
614: l_fin_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
615: l_financial_charges ra_customer_trx.finance_charges%type;
616:
617: --*******status
618: l_receipt_method_status VARCHAR2(1000);
619: l_bank_acct_status VARCHAR2(1000);

Line 632: ra_customer_trx.customer_bank_account_id%type;

628: l_id_return_status VARCHAR2(1000);
629: l_dft_return_status VARCHAR2(1000);
630: l_dummy NUMBER;
631: l_fin_customer_bank_account_id
632: ra_customer_trx.customer_bank_account_id%type;
633: l_new_customer_trx_line_id
634: ra_customer_trx_lines.customer_trx_line_id%type;
635: l_ctt_bs_deflt_ctrx_type_id
636: ra_cust_trx_types.cust_trx_type_id%type;

Line 634: ra_customer_trx_lines.customer_trx_line_id%type;

630: l_dummy NUMBER;
631: l_fin_customer_bank_account_id
632: ra_customer_trx.customer_bank_account_id%type;
633: l_new_customer_trx_line_id
634: ra_customer_trx_lines.customer_trx_line_id%type;
635: l_ctt_bs_deflt_ctrx_type_id
636: ra_cust_trx_types.cust_trx_type_id%type;
637: l_allow_overapplication_flag
638: ra_cust_trx_types.allow_overapplication_flag%type;

Line 1129: 'RA_CUSTOMER_TRX',

1125: +-----------------------------------------------------------------------------*/
1126:
1127: ar_deposit_lib_pvt.Validate_Desc_Flexfield(
1128: l_attribute_rec,
1129: 'RA_CUSTOMER_TRX',
1130: l_dflex_val_return_status
1131: );
1132: ar_deposit_lib_pvt.Validate_Desc_Flexfield(
1133: l_hd_attribute_rec,

Line 1487: -- ****update ra_customer_trx and line for globalization felx

1483: /* PAYMENT UPTAKE END */
1484:
1485:
1486:
1487: -- ****update ra_customer_trx and line for globalization felx
1488:
1489: /*-----------------------------------------------------------------------------+
1490: | Posting commit activities i.e completing the deposit create by routine , |
1491: | arp_process_header_insrt_cover.insert_header_cover using |

Line 1532: update ra_customer_trx

1528: -- Bug # 3177345
1529: IF NVL(l_copy_doc_number_flag, 'N') = 'Y' AND
1530: (l_doc_sequence_value IS NOT NULL)
1531: THEN
1532: update ra_customer_trx
1533: set old_trx_number = l_new_trx_number ,
1534: trx_number = l_doc_sequence_value
1535: where customer_trx_id = l_new_customer_trx_id ;
1536: --Bug # 3515882 -also updatingh trx_number in payment schedule

Line 1640: l_deposit_number ra_customer_trx.trx_number%type;

1636:
1637: l_api_name CONSTANT VARCHAR2(100) := 'insert_non_rev_salescredit';
1638: l_api_version CONSTANT NUMBER := 1.0;
1639:
1640: l_deposit_number ra_customer_trx.trx_number%type;
1641: l_deposit_date ra_customer_trx.trx_date%type;
1642: l_customer_trx_id ra_cust_trx_line_salesreps.customer_trx_id%type;
1643: l_salesrep_number ra_salesreps.salesrep_number%type;
1644: l_salesrep_id ra_cust_trx_line_salesreps.salesrep_id%type;

Line 1641: l_deposit_date ra_customer_trx.trx_date%type;

1637: l_api_name CONSTANT VARCHAR2(100) := 'insert_non_rev_salescredit';
1638: l_api_version CONSTANT NUMBER := 1.0;
1639:
1640: l_deposit_number ra_customer_trx.trx_number%type;
1641: l_deposit_date ra_customer_trx.trx_date%type;
1642: l_customer_trx_id ra_cust_trx_line_salesreps.customer_trx_id%type;
1643: l_salesrep_number ra_salesreps.salesrep_number%type;
1644: l_salesrep_id ra_cust_trx_line_salesreps.salesrep_id%type;
1645: l_non_revenue_amount_split ra_cust_trx_line_salesreps.non_revenue_amount_split%type;

Line 1654: l_INVOICE_CURRENCY_CODE ra_customer_trx.INVOICE_CURRENCY_CODE%type;

1650: l_dept_no_return_status varchar2(1000);
1651: l_sales_val_return_status varchar2(1000);
1652: l_nonrev_amt_pct_return_status varchar2(1000);
1653: l_dummy_return_status varchar2(1000);
1654: l_INVOICE_CURRENCY_CODE ra_customer_trx.INVOICE_CURRENCY_CODE%type;
1655:
1656: l_cust_trx_line_salesrep_id number;
1657: l_customer_trx_line_id number;
1658: l_status varchar2(100);

Line 1745: FROM ra_customer_trx

1741: p_customer_trx_id IS NOT NULL ) then
1742: begin
1743: SELECT customer_trx_id,INVOICE_CURRENCY_CODE,trx_date
1744: INTO l_customer_trx_id,l_INVOICE_CURRENCY_CODE,l_deposit_date
1745: FROM ra_customer_trx
1746: WHERE customer_trx_id = p_customer_trx_id;
1747:
1748: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ING');
1749: FND_MSG_PUB.Add;

Line 1752: FROM ra_customer_trx cust_trx ,

1748: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ING');
1749: FND_MSG_PUB.Add;
1750:
1751: SELECT customer_trx_id into l_dummy_number
1752: FROM ra_customer_trx cust_trx ,
1753: ra_cust_trx_types cust_trx_type
1754: WHERE cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id
1755: and customer_trx_id = l_customer_trx_id
1756: and cust_trx_type.TYPE = 'DEP';

Line 1769: FROM ra_customer_trx

1765: p_customer_trx_id IS NOT NULL ) then
1766: begin
1767: SELECT customer_trx_id,INVOICE_CURRENCY_CODE,trx_date
1768: INTO l_customer_trx_id,l_INVOICE_CURRENCY_CODE,l_deposit_date
1769: FROM ra_customer_trx
1770: WHERE customer_trx_id = p_customer_trx_id;
1771:
1772: SELECT customer_trx_id into l_dummy_number
1773: FROM ra_customer_trx cust_trx ,

Line 1773: FROM ra_customer_trx cust_trx ,

1769: FROM ra_customer_trx
1770: WHERE customer_trx_id = p_customer_trx_id;
1771:
1772: SELECT customer_trx_id into l_dummy_number
1773: FROM ra_customer_trx cust_trx ,
1774: ra_cust_trx_types cust_trx_type
1775: WHERE cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id
1776: and customer_trx_id = l_customer_trx_id and
1777: cust_trx_type.TYPE = 'DEP';

Line 1790: FROM ra_customer_trx

1786: p_customer_trx_id IS NULL ) then
1787: begin
1788: SELECT customer_trx_id,INVOICE_CURRENCY_CODE,trx_date
1789: INTO l_customer_trx_id,l_INVOICE_CURRENCY_CODE,l_deposit_date
1790: FROM ra_customer_trx
1791: WHERE trx_number = p_deposit_number;
1792:
1793: SELECT customer_trx_id into l_dummy_number
1794: FROM ra_customer_trx cust_trx ,

Line 1794: FROM ra_customer_trx cust_trx ,

1790: FROM ra_customer_trx
1791: WHERE trx_number = p_deposit_number;
1792:
1793: SELECT customer_trx_id into l_dummy_number
1794: FROM ra_customer_trx cust_trx ,
1795: ra_cust_trx_types cust_trx_type
1796: WHERE cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id
1797: and customer_trx_id = l_customer_trx_id and
1798: cust_trx_type.TYPE = 'DEP';

Line 1812: from ra_customer_trx_lines

1808: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1809: begin
1810: select sum(EXTENDED_AMOUNT)
1811: into l_amount
1812: from ra_customer_trx_lines
1813: where customer_trx_id = l_customer_trx_id;
1814: end;
1815: end if;
1816:

Line 1821: from ra_customer_trx_lines

1817: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1818: begin
1819: select customer_trx_line_id
1820: into l_customer_trx_line_id
1821: from ra_customer_trx_lines
1822: where customer_trx_id = l_customer_trx_id; --only line per deposit
1823: exception when others then raise;
1824: end;
1825: end if;

Line 2132: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

2128:
2129: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
2130: l_cpy_msg_data VARCHAR2(2000);
2131: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
2132: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
2133: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2134: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
2135: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
2136:

Line 2135: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;

2131: l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
2132: p_trxn_entity_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
2133: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2134: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
2135: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
2136:
2137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2138: l_assignment_id NUMBER;
2139:

Line 2145: l_customer_id ra_customer_trx.paying_customer_id%type;

2141: l_msg_data VARCHAR2(2000);
2142:
2143:
2144: l_payment_channel ar_receipt_methods.payment_channel_code%type;
2145: l_customer_id ra_customer_trx.paying_customer_id%type;
2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2147: l_org_id ra_customer_trx.org_id%type;
2148: l_trx_number ra_customer_trx.trx_number%type;
2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

Line 2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;

2142:
2143:
2144: l_payment_channel ar_receipt_methods.payment_channel_code%type;
2145: l_customer_id ra_customer_trx.paying_customer_id%type;
2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2147: l_org_id ra_customer_trx.org_id%type;
2148: l_trx_number ra_customer_trx.trx_number%type;
2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2150: l_party_id hz_parties.party_id%type;

Line 2147: l_org_id ra_customer_trx.org_id%type;

2143:
2144: l_payment_channel ar_receipt_methods.payment_channel_code%type;
2145: l_customer_id ra_customer_trx.paying_customer_id%type;
2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2147: l_org_id ra_customer_trx.org_id%type;
2148: l_trx_number ra_customer_trx.trx_number%type;
2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2150: l_party_id hz_parties.party_id%type;
2151:

Line 2148: l_trx_number ra_customer_trx.trx_number%type;

2144: l_payment_channel ar_receipt_methods.payment_channel_code%type;
2145: l_customer_id ra_customer_trx.paying_customer_id%type;
2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2147: l_org_id ra_customer_trx.org_id%type;
2148: l_trx_number ra_customer_trx.trx_number%type;
2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2150: l_party_id hz_parties.party_id%type;
2151:
2152:

Line 2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;

2145: l_customer_id ra_customer_trx.paying_customer_id%type;
2146: l_customer_site_use_id ra_customer_trx.paying_site_use_id%type;
2147: l_org_id ra_customer_trx.org_id%type;
2148: l_trx_number ra_customer_trx.trx_number%type;
2149: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
2150: l_party_id hz_parties.party_id%type;
2151:
2152:
2153: BEGIN

Line 2180: ra_customer_trx trx,

2176: l_payment_channel,
2177: l_customer_trx_id
2178: FROM hz_cust_accounts hca,
2179: hz_parties party,
2180: ra_customer_trx trx,
2181: ar_receipt_methods rm
2182: WHERE trx.customer_trx_id = p_customer_trx_id
2183: AND hca.party_id = party.party_id
2184: AND hca.cust_account_id = trx.paying_customer_id

Line 2250: update ra_customer_trx

2246:
2247: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );
2248:
2249:
2250: update ra_customer_trx
2251: set payment_trxn_extension_id = o_payment_trxn_extension_id
2252: where customer_trx_id = p_customer_trx_id ;
2253:
2254: