DBA Data[Home] [Help]

APPS.MSC_CL_RPO_PRE_PROCESS dependencies on MSC_ST_IRO_SUPPLY_S

Line 472: msc_st_iro_supply_s is the new sequence that needs to be created. */

468: MSC_CL_PRE_PROCESS.v_instance_code,
469: lv_batch_id;
470:
471: /* for all the row in given batch_id with process_flag =2 and repair_line_id as null populate repair line id
472: msc_st_iro_supply_s is the new sequence that needs to be created. */
473: OPEN c2(lv_batch_id);
474: FETCH c2 BULK COLLECT INTO lb_rowid ;
475: if c2%ROWCOUNT >0 THEN
476: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST

Line 478: SET disposition_id = msc_st_iro_supply_s.NEXTVAL

474: FETCH c2 BULK COLLECT INTO lb_rowid ;
475: if c2%ROWCOUNT >0 THEN
476: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
477: UPDATE msc_st_supplies
478: SET disposition_id = msc_st_iro_supply_s.NEXTVAL
479: WHERE rowid = lb_rowid(j);
480:
481: MSC_CL_PRE_PROCESS.v_sql_stmt := 13;
482: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST