APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUSTOMER_TRX_LINES

Line 605: /* Procedure ins_ra_customer_trx_lines */

601: 'IL: Id da Transacao Invalido'||sqlerrm );
602: END ins_ra_customer_trx;
603:
604: /************************************************************************/
605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
607: /************************************************************************/
608:
609: PROCEDURE ins_ra_customer_trx_lines (

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

602: END ins_ra_customer_trx;
603:
604: /************************************************************************/
605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
607: /************************************************************************/
608:
609: PROCEDURE ins_ra_customer_trx_lines (
610: X_new_customer_trx_id IN NUMBER,

Line 609: PROCEDURE ins_ra_customer_trx_lines (

605: /* Procedure ins_ra_customer_trx_lines */
606: /* Purpose : Get the fields to insert into ra_customer_trx_lines */
607: /************************************************************************/
608:
609: PROCEDURE ins_ra_customer_trx_lines (
610: X_new_customer_trx_id IN NUMBER,
611: X_invoice_amount IN NUMBER,
612: X_set_of_books_id IN NUMBER,
613: X_user_id IN NUMBER,

Line 619: SELECT ra_customer_trx_lines_s.nextval

615: X_customertrx_line_id IN OUT NOCOPY NUMBER
616: ) IS
617: l_org_id NUMBER(15);
618: BEGIN
619: SELECT ra_customer_trx_lines_s.nextval
620: INTO X_customertrx_line_id
621: FROM dual;
622:
623: SELECT org_id into l_org_id

Line 627: INSERT INTO ra_customer_trx_lines (

623: SELECT org_id into l_org_id
624: FROM ra_customer_trx_all
625: Where customer_trx_id = x_new_customer_trx_id;
626:
627: INSERT INTO ra_customer_trx_lines (
628: customer_trx_line_id,
629: last_update_date,
630: last_updated_by,
631: creation_date,

Line 664: END ins_ra_customer_trx_lines;

660: X_invoice_amount,
661: 'S',
662: l_org_id
663: );
664: END ins_ra_customer_trx_lines;
665:
666: /***************************************************************************/
667: /* Procedure ins_ra_cust_trx_line_salesreps */
668: /* Purpose : Get the fields to insert into ra_cust_trx_line_salesreps */

Line 1125: jl_br_ar_generate_debit_memo.ins_ra_customer_trx_lines (

1121: X_batch_id,
1122: X_interest_DM_date
1123: );
1124:
1125: jl_br_ar_generate_debit_memo.ins_ra_customer_trx_lines (
1126: X_new_customer_trx_id,
1127: X_invoice_amount,
1128: X_set_of_books_id,
1129: X_user_id,