DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SET_ID_S

Line 37214: SET ship_set_id = msc_st_set_id_s.NEXTVAL

37210: IF c4%ROWCOUNT > 0 THEN
37211: v_sql_stmt := 15.1;
37212: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37213: UPDATE msc_st_sales_orders
37214: SET ship_set_id = msc_st_set_id_s.NEXTVAL
37215: WHERE rowid = lb_rowid(j)
37216: AND ship_set_id is null;
37217:
37218: v_sql_stmt := 15.2;

Line 37316: SET arrival_set_id = msc_st_set_id_s.NEXTVAL

37312: IF c5%ROWCOUNT > 0 THEN
37313: v_sql_stmt := 16.1;
37314: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37315: UPDATE msc_st_sales_orders
37316: SET arrival_set_id = msc_st_set_id_s.NEXTVAL
37317: WHERE rowid = lb_rowid(j)
37318: AND arrival_set_id is null;
37319:
37320: v_sql_stmt := 16.2;