APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUSTOMER_TRX_LINES

Line 574: /* Procedure ins_ra_customer_trx_lines */

570: 'IL: Id da Transacao Invalido'||sqlerrm );
571: END ins_ra_customer_trx;
572:
573: /************************************************************************/
574: /* Procedure ins_ra_customer_trx_lines */
575: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
576: /************************************************************************/
577:
578: PROCEDURE ins_ra_customer_trx_lines (

Line 575: /* Purpose : Get the fields to insert into ra_customer_trx_lines */

571: END ins_ra_customer_trx;
572:
573: /************************************************************************/
574: /* Procedure ins_ra_customer_trx_lines */
575: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
576: /************************************************************************/
577:
578: PROCEDURE ins_ra_customer_trx_lines (
579: X_new_customer_trx_id IN NUMBER,

Line 578: PROCEDURE ins_ra_customer_trx_lines (

574: /* Procedure ins_ra_customer_trx_lines */
575: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
576: /************************************************************************/
577:
578: PROCEDURE ins_ra_customer_trx_lines (
579: X_new_customer_trx_id IN NUMBER,
580: X_invoice_amount IN NUMBER,
581: X_set_of_books_id IN NUMBER,
582: X_user_id IN NUMBER,

Line 588: SELECT ra_customer_trx_lines_s.nextval

584: X_customertrx_line_id IN OUT NOCOPY NUMBER
585: ) IS
586: l_org_id NUMBER(15);
587: BEGIN
588: SELECT ra_customer_trx_lines_s.nextval
589: INTO X_customertrx_line_id
590: FROM dual;
591:
592: SELECT org_id into l_org_id

Line 596: INSERT INTO ra_customer_trx_lines (

592: SELECT org_id into l_org_id
593: FROM ra_customer_trx_all
594: Where customer_trx_id = x_new_customer_trx_id;
595:
596: INSERT INTO ra_customer_trx_lines (
597: customer_trx_line_id,
598: last_update_date,
599: last_updated_by,
600: creation_date,

Line 633: END ins_ra_customer_trx_lines;

629: X_invoice_amount,
630: 'S',
631: l_org_id
632: );
633: END ins_ra_customer_trx_lines;
634:
635: /***************************************************************************/
636: /* Procedure ins_ra_cust_trx_line_salesreps */
637: /* Purpose : Get the fields to insert into ra_cust_trx_line_salesreps */

Line 1084: jl_br_ar_generate_debit_memo.ins_ra_customer_trx_lines (

1080: X_batch_id,
1081: X_interest_DM_date
1082: );
1083:
1084: jl_br_ar_generate_debit_memo.ins_ra_customer_trx_lines (
1085: X_new_customer_trx_id,
1086: X_invoice_amount,
1087: X_set_of_books_id,
1088: X_user_id,