APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_BILL_SEQUENCE_ID_S
Line 40986: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S
40982: RAISE ex_logging_err;
40983: END IF;
40984:
40985: -- Now generate bill_sequence_id for New BOM and populate the same in 40986: -- LID table and MSC_ST_BOMS , Sequence to be used MSC_ST_BILL_SEQUENCE_ID_S 40987:
40988: v_sql_stmt := 09;
40989:
40990: OPEN c3(lv_batch_id);
Line 40998: SET bill_sequence_id = msc_st_bill_sequence_id_s.NEXTVAL
40994:
40995: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
40996:
40997: UPDATE msc_st_boms 40998: SET bill_sequence_id = msc_st_bill_sequence_id_s.NEXTVAL 40999: WHERE rowid = lb_rowid(j);
41000:
41001: v_sql_stmt := 10;
41002: