APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 667: /* Procedure ins_ra_cust_trx_line_salesreps */

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 */
669: /***************************************************************************/
670: PROCEDURE ins_ra_cust_trx_line_salesreps (
671: X_new_cust_trx_id IN NUMBER,

Line 668: /* Purpose : Get the fields to insert into ra_cust_trx_line_salesreps */

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 */
669: /***************************************************************************/
670: PROCEDURE ins_ra_cust_trx_line_salesreps (
671: X_new_cust_trx_id IN NUMBER,
672: X_new_cust_trx_line_id IN NUMBER,

Line 670: PROCEDURE ins_ra_cust_trx_line_salesreps (

666: /***************************************************************************/
667: /* Procedure ins_ra_cust_trx_line_salesreps */
668: /* Purpose : Get the fields to insert into ra_cust_trx_line_salesreps */
669: /***************************************************************************/
670: PROCEDURE ins_ra_cust_trx_line_salesreps (
671: X_new_cust_trx_id IN NUMBER,
672: X_new_cust_trx_line_id IN NUMBER,
673: X_salesrep_id IN NUMBER,
674: X_user_id IN NUMBER,

Line 684: INSERT INTO ra_cust_trx_line_salesreps (

680: SELECT org_id into l_org_id
681: FROM ra_customer_trx_all where
682: customer_trx_id = x_new_cust_trx_id;
683:
684: INSERT INTO ra_cust_trx_line_salesreps (
685: cust_trx_line_salesrep_id,
686: last_update_date,
687: last_updated_by,
688: creation_date,

Line 697: ra_cust_trx_line_salesreps_s.nextval,

693: revenue_percent_split,
694: revenue_amount_split,
695: org_id
696: ) VALUES (
697: ra_cust_trx_line_salesreps_s.nextval,
698: sysdate,
699: X_user_id,
700: sysdate,
701: X_user_id,

Line 710: INSERT INTO ra_cust_trx_line_salesreps (

706: X_invoice_amount,
707: l_org_id
708: );
709:
710: INSERT INTO ra_cust_trx_line_salesreps (
711: cust_trx_line_salesrep_id,
712: last_update_date,
713: last_updated_by,
714: creation_date,

Line 724: ra_cust_trx_line_salesreps_s.nextval,

720: revenue_percent_split,
721: revenue_amount_split,
722: org_id
723: ) VALUES (
724: ra_cust_trx_line_salesreps_s.nextval,
725: sysdate,
726: X_user_id,
727: sysdate,
728: X_user_id,

Line 737: END ins_ra_cust_trx_line_salesreps;

733: '100',
734: X_invoice_amount,
735: l_org_id
736: );
737: END ins_ra_cust_trx_line_salesreps;
738:
739: /************************************************************************/
740: /* Procedure ins_ra_cust_trx_line_gl_dist */
741: /* Purpose : Get the fields to insert into ra_cust_trx_line_gl_dist*/

Line 806: SELECT ra_cust_trx_line_salesreps_s.nextval

802: X_line_salesrepid := NULL;
803: ELSE
804: BEGIN
805: X_custtrx_line_id := X_customer_trx_line_id;
806: SELECT ra_cust_trx_line_salesreps_s.nextval
807: INTO X_line_salesrepid
808: FROM sys.dual;
809: END;
810: END IF;

Line 1134: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_salesreps (

1130: X_last_login,
1131: X_new_customer_trx_line_id
1132: );
1133: IF X_salesrep_id IS NOT NULL THEN
1134: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_salesreps (
1135: X_new_customer_trx_id,
1136: X_new_customer_trx_line_id,
1137: X_salesrep_id,
1138: X_user_id,