APPS.CN_ADJUSTMENTS_PKG dependencies on CN_COMM_LINES_API_S

Line 194: SELECT cn_comm_lines_api_s.NEXTVAL

190: WHERE comm_lines_api_id = x_comm_lines_api_id;
191: FOR api_curs_rec IN header_cur(l_reversal_header_id)
192: LOOP
193: --
194: SELECT cn_comm_lines_api_s.NEXTVAL
195: INTO l_comm_lines_api_id
196: FROM dual;
197: --
198: l_api_rec.salesrep_id := api_curs_rec.direct_salesrep_id;

Line 446: SELECT cn_comm_lines_api_s.NEXTVAL

442: ELSE
443: l_adjust_status := 'MASSASGN';
444: END IF;
445: --
446: SELECT cn_comm_lines_api_s.NEXTVAL
447: INTO l_comm_lines_api_id
448: FROM DUAL;
449: --
450:

Line 1144: SELECT cn_comm_lines_api_s.NEXTVAL

1140: INTO l_salesrep_number
1141: FROM cn_salesreps
1142: WHERE salesrep_id = x_salesrep_id;
1143: --
1144: SELECT cn_comm_lines_api_s.NEXTVAL
1145: INTO l_ins_comm_lines_api_id
1146: FROM dual;
1147: --
1148: l_newtx_rec.direct_salesrep_id := x_salesrep_id;

Line 1295: SELECT cn_comm_lines_api_s.NEXTVAL

1291: INTO l_salesrep_number
1292: FROM cn_salesreps
1293: WHERE salesrep_id = x_to_salesrep_id;
1294: --
1295: SELECT cn_comm_lines_api_s.NEXTVAL
1296: INTO l_ins_comm_lines_api_id
1297: FROM dual;
1298: --
1299: l_newtx_rec.direct_salesrep_id := x_to_salesrep_id;