DBA Data[Home] [Help]

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 447: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 1146: SELECT cn_comm_lines_api_s.NEXTVAL

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

Line 1297: SELECT cn_comm_lines_api_s.NEXTVAL

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