APPS.EGO_MASS_UPDATE_PVT dependencies on MTL_SYSTEM_ITEMS_INTF_SETS_S

Line 66: SELECT mtl_system_items_intf_sets_s.NEXTVAL

62: -- This will be the initial set_process_id which will
63: -- be changed in the update loop
64: -- Can we avoid this select and directly use the seq val
65: -- Using currval in the insert may perhaps give diff values if nextval is used elsewhere?
66: SELECT mtl_system_items_intf_sets_s.NEXTVAL
67: INTO l_set_process_id
68: FROM dual;
69:
70: Write_Debug('In Item Org Assignment API');

Line 185: /* SELECT mtl_system_items_intf_sets_s.NEXTVAL

181: -- Can we avoid this select and directly use the seq value
182: -- If used directly then error 'Exact fetch return more than one row' occurs
183: -- because for each row the sequence value is being incremented
184:
185: /* SELECT mtl_system_items_intf_sets_s.NEXTVAL
186: INTO l_batch_set_process_id
187: FROM dual;
188:
189: UPDATE mtl_system_items_interface