APPS.INVPAGI3 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 125: FROM mtl_system_items_interface

121: for ctr in ct LOOP
122: /* Start of Bug 9099489 : Added the Exception Block */
123: begin
124: SELECT inventory_item_id INTO flex_id
125: FROM mtl_system_items_interface
126: WHERE transaction_id = ctr.transaction_id
127: AND ROWNUM = 1;
128:
129: UPDATE mtl_item_revisions_interface

Line 162: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)

158: if status <> 0 then /* Oracle error */
159: ----Bug: 3019435 Changed the code with in IF st.
160: update mtl_item_revisions_interface
161: set process_flag = l_process_flag_3,
162: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
163:
164: where item_number = cr.item_number
165: and inventory_item_id is NULL
166: and process_flag = l_process_flag_1

Line 172: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

168: and organization_id = cr.organization_id
169: RETURNING transaction_id INTO tran_id;
170:
171: /*
172: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
173: into tran_id
174: from dual;
175: */
176: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 221: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

217: ** Assign transaction_id
218: */
219: for cr in ff loop
220:
221: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
222: into tran_id
223: from dual;
224:
225: update mtl_item_revisions_interface

Line 302: i.transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)

298: i.LAST_UPDATE_DATE = sysdate,
299: i.LAST_UPDATED_BY = decode(i.LAST_UPDATED_BY, NULL, user_id,i.LAST_UPDATED_BY),
300: i.CREATION_DATE = l_sysdate,
301: i.CREATED_BY = decode(i.LAST_UPDATED_BY, NULL, user_id,i.LAST_UPDATED_BY),
302: i.transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
303: WHERE i.rowid = rec.rowid
304: RETURNING i.transaction_id INTO tran_id ;
305:
306: dumm_status := INVPUOPI.mtl_log_interface_err(