APPS.JL_BR_AR_GENERATE_DEBIT_MEMO dependencies on RA_CUST_TRX_LINE_SALESREPS

Line 636: /* Procedure ins_ra_cust_trx_line_salesreps */

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 */
638: /***************************************************************************/
639: PROCEDURE ins_ra_cust_trx_line_salesreps (
640: X_new_cust_trx_id IN NUMBER,

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

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 */
638: /***************************************************************************/
639: PROCEDURE ins_ra_cust_trx_line_salesreps (
640: X_new_cust_trx_id IN NUMBER,
641: X_new_cust_trx_line_id IN NUMBER,

Line 639: PROCEDURE ins_ra_cust_trx_line_salesreps (

635: /***************************************************************************/
636: /* Procedure ins_ra_cust_trx_line_salesreps */
637: /* Purpose : Get the fields to insert into ra_cust_trx_line_salesreps */
638: /***************************************************************************/
639: PROCEDURE ins_ra_cust_trx_line_salesreps (
640: X_new_cust_trx_id IN NUMBER,
641: X_new_cust_trx_line_id IN NUMBER,
642: X_salesrep_id IN NUMBER,
643: X_user_id IN NUMBER,

Line 653: INSERT INTO ra_cust_trx_line_salesreps (

649: SELECT org_id into l_org_id
650: FROM ra_customer_trx_all where
651: customer_trx_id = x_new_cust_trx_id;
652:
653: INSERT INTO ra_cust_trx_line_salesreps (
654: cust_trx_line_salesrep_id,
655: last_update_date,
656: last_updated_by,
657: creation_date,

Line 666: ra_cust_trx_line_salesreps_s.nextval,

662: revenue_percent_split,
663: revenue_amount_split,
664: org_id
665: ) VALUES (
666: ra_cust_trx_line_salesreps_s.nextval,
667: sysdate,
668: X_user_id,
669: sysdate,
670: X_user_id,

Line 679: INSERT INTO ra_cust_trx_line_salesreps (

675: X_invoice_amount,
676: l_org_id
677: );
678:
679: INSERT INTO ra_cust_trx_line_salesreps (
680: cust_trx_line_salesrep_id,
681: last_update_date,
682: last_updated_by,
683: creation_date,

Line 693: ra_cust_trx_line_salesreps_s.nextval,

689: revenue_percent_split,
690: revenue_amount_split,
691: org_id
692: ) VALUES (
693: ra_cust_trx_line_salesreps_s.nextval,
694: sysdate,
695: X_user_id,
696: sysdate,
697: X_user_id,

Line 706: END ins_ra_cust_trx_line_salesreps;

702: '100',
703: X_invoice_amount,
704: l_org_id
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*/

Line 767: SELECT ra_cust_trx_line_salesreps_s.nextval

763: X_line_salesrepid := NULL;
764: ELSE
765: BEGIN
766: X_custtrx_line_id := X_customer_trx_line_id;
767: SELECT ra_cust_trx_line_salesreps_s.nextval
768: INTO X_line_salesrepid
769: FROM sys.dual;
770: END;
771: END IF;

Line 1093: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_salesreps (

1089: X_last_login,
1090: X_new_customer_trx_line_id
1091: );
1092: IF X_salesrep_id IS NOT NULL THEN
1093: jl_br_ar_generate_debit_memo.ins_ra_cust_trx_line_salesreps (
1094: X_new_customer_trx_id,
1095: X_new_customer_trx_line_id,
1096: X_salesrep_id,
1097: X_user_id,