DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_BILL_SEQUENCE_ID_S

Line 36202: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S

36198: RAISE ex_logging_err;
36199: END IF;
36200:
36201: -- Now generate bill_sequence_id for New BOM and populate the same in
36202: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S
36203:
36204: v_sql_stmt := 09;
36205:
36206: OPEN c3(lv_batch_id);

Line 36214: SET bill_sequence_id = msc_st_bill_sequence_id_s.NEXTVAL

36210:
36211: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36212:
36213: UPDATE msc_st_boms
36214: SET bill_sequence_id = msc_st_bill_sequence_id_s.NEXTVAL
36215: WHERE rowid = lb_rowid(j);
36216:
36217: v_sql_stmt := 10;
36218: