DBA Data[Home] [Help]

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: