APPS.INVPAGI3 dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

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

116: if status <> 0 then /* Oracle error */
117: ----Bug: 3019435 Changed the code with in IF st.
118: update mtl_item_revisions_interface
119: set process_flag = l_process_flag_3,
120: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
121: where ROWID = cr.ROWID
122: RETURNING transaction_id INTO tran_id;
123: /*Bug 5183204 where item_number = cr.item_number
124: and inventory_item_id is NULL

Line 130: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

126: and set_process_id = xset_id
127: and organization_id = cr.organization_id */
128:
129: /*
130: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
131: into tran_id
132: from dual;
133: */
134: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 179: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

175: ** Assign transaction_id
176: */
177: for cr in ff loop
178:
179: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
180: into tran_id
181: from dual;
182:
183: update mtl_item_revisions_interface

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

255: i.LAST_UPDATE_DATE = sysdate,
256: i.LAST_UPDATED_BY = decode(i.LAST_UPDATED_BY, NULL, user_id,i.LAST_UPDATED_BY),
257: i.CREATION_DATE = l_sysdate,
258: i.CREATED_BY = decode(i.LAST_UPDATED_BY, NULL, user_id,i.LAST_UPDATED_BY),
259: i.transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
260: WHERE i.rowid = rec.rowid
261: RETURNING i.transaction_id INTO tran_id ;
262:
263: dumm_status := INVPUOPI.mtl_log_interface_err(