[Home] [Help]
2659: /*---------------------------*
2660: | Get the unique identifier |
2661: *---------------------------*/
2662:
2663: SELECT RA_CUST_TRX_LINE_SALESREPS_S.NEXTVAL
2664: INTO l_cust_trx_line_salesrep_id
2665: FROM DUAL;
2666:
2667:
2841: non_revenue_amount_split,
2842: non_revenue_salesgroup_id,
2843: org_id
2844: )
2845: SELECT ra_cust_trx_line_salesreps_s.nextval,
2846: sysdate, /* last_update_date */
2847: pg_user_id, /* last_updated_by */
2848: sysdate, /* creation_date */
2849: pg_user_id, /* created_by */
2935: non_revenue_amount_split
2936: ,non_revenue_salesgroup_id -- added here and in SELECT - bug 3067675
2937: ,org_id
2938: )
2939: SELECT ra_cust_trx_line_salesreps_s.nextval,
2940: sysdate, /* last_update_date */
2941: pg_user_id, /* last_updated_by */
2942: sysdate, /* creation_date */
2943: pg_user_id, /* created_by */
3081: non_revenue_percent_split,
3082: non_revenue_amount_split
3083: ,org_id
3084: )
3085: SELECT ra_cust_trx_line_salesreps_s.nextval,
3086: sysdate, /* last_update_date */
3087: pg_user_id, /* last_updated_by */
3088: sysdate, /* creation_date */
3089: pg_user_id, /* created_by */
3201: non_revenue_percent_split,
3202: non_revenue_amount_split
3203: ,org_id
3204: )
3205: SELECT ra_cust_trx_line_salesreps_s.nextval,
3206: sysdate, /* last_update_date */
3207: pg_user_id, /* last_updated_by */
3208: sysdate, /* creation_date */
3209: pg_user_id, /* created_by */
3339: ra_cust_trx_line_salesreps.customer_trx_id%type,
3340: p_customer_trx_line_id IN
3341: ra_cust_trx_line_salesreps.customer_trx_line_id%type,
3342: p_salesrep_id IN
3343: ra_cust_trx_line_salesreps.salesrep_id%type,
3344: p_revenue_amount_split IN
3345: ra_cust_trx_line_salesreps.revenue_amount_split%type,
3346: p_non_revenue_amount_split IN
3347: ra_cust_trx_line_salesreps.non_revenue_amount_split%type,