DBA Data[Home] [Help]

APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 709: /* Procedure ins_ra_cust_trx_line_gl_dist */

705: );
706: END ins_ra_cust_trx_line_salesreps;
707:
708: /************************************************************************/
709: /* Procedure ins_ra_cust_trx_line_gl_dist */
710: /* Purpose : Get the fields to insert into ra_cust_trx_line_gl_dist*/
711: /************************************************************************/
712: PROCEDURE ins_ra_cust_trx_line_gl_dist (
713: X_customer_trx_id IN NUMBER,

Line 710: /* Purpose : Get the fields to insert into ra_cust_trx_line_gl_dist*/

706: END ins_ra_cust_trx_line_salesreps;
707:
708: /************************************************************************/
709: /* Procedure ins_ra_cust_trx_line_gl_dist */
710: /* Purpose : Get the fields to insert into ra_cust_trx_line_gl_dist*/
711: /************************************************************************/
712: PROCEDURE ins_ra_cust_trx_line_gl_dist (
713: X_customer_trx_id IN NUMBER,
714: X_customer_trx_line_id IN OUT NOCOPY NUMBER,

Line 712: PROCEDURE ins_ra_cust_trx_line_gl_dist (

708: /************************************************************************/
709: /* Procedure ins_ra_cust_trx_line_gl_dist */
710: /* Purpose : Get the fields to insert into ra_cust_trx_line_gl_dist*/
711: /************************************************************************/
712: PROCEDURE ins_ra_cust_trx_line_gl_dist (
713: X_customer_trx_id IN NUMBER,
714: X_customer_trx_line_id IN OUT NOCOPY NUMBER,
715: X_invoice_amount IN NUMBER,
716: X_set_of_books_id IN NUMBER,

Line 740: l_dist_rec ra_cust_trx_line_gl_dist%ROWTYPE;

736: X_line_salesrepid NUMBER(15);
737: X_custtrx_line_id NUMBER(15);
738: X_memo_line_id NUMBER(15);
739: X_cust_trx_line_gl_dist_id NUMBER(15);
740: l_dist_rec ra_cust_trx_line_gl_dist%ROWTYPE;
741: x_struct_num NUMBER(15);
742: invalid_account EXCEPTION;
743: l_org_id NUMBER(15);
744:

Line 786: /* INSERT INTO ra_cust_trx_line_gl_dist (

782: X_gl_date := NULL;
783: END IF;
784:
785: --Commented out for Bug 3067731; Need to call AR table handler instead of direct insert
786: /* INSERT INTO ra_cust_trx_line_gl_dist (
787: cust_trx_line_gl_dist_id,
788: customer_trx_line_id,
789: code_combination_id,
790: set_of_books_id,

Line 807: ra_cust_trx_line_gl_dist_s.nextval,

803: account_set_flag,
804: acctd_amount,
805: latest_rec_flag
806: ) VALUES (
807: ra_cust_trx_line_gl_dist_s.nextval,
808: X_custtrx_line_id,
809: X_code_id,
810: X_set_of_books_id,
811: sysdate,

Line 853: END ins_ra_cust_trx_line_gl_dist;

849: WHEN OTHERS THEN
850: x_error_code := sqlcode;
851: x_error_msg := sqlerrm;
852:
853: END ins_ra_cust_trx_line_gl_dist;
854:
855: /************************************************************************/
856: /* Procedure ins_ar_payment_schedules */
857: /* Purpose : Get the fields to insert into ar_payment_schedules */

Line 1103: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_gl_dist (

1099: X_invoice_amount
1100: );
1101: END IF;
1102:
1103: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_gl_dist (
1104: X_new_customer_trx_id,
1105: X_new_customer_trx_line_id,
1106: X_invoice_amount,
1107: X_set_of_books_id,

Line 1124: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_gl_dist (

1120: x_error_msg,
1121: x_token
1122: );
1123:
1124: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_gl_dist (
1125: X_new_customer_trx_id,
1126: X_new_customer_trx_line_id,
1127: X_invoice_amount,
1128: X_set_of_books_id,