APPS.INVPAGI3 dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 29: FROM mtl_item_revisions_interface

25: is
26:
27: CURSOR c_item_number_err IS
28: SELECT organization_id,rowid
29: FROM mtl_item_revisions_interface
30: WHERE inventory_item_id IS NULL
31: AND set_process_id = xset_id
32: AND process_flag = 1
33: AND (organization_id = org_id OR

Line 41: from mtl_item_revisions_interface

37: */
38: --Removed distinct clause and added rowid for Bug 5182304
39: CURSOR cc is select item_number, rowid,
40: organization_id
41: from mtl_item_revisions_interface
42: where inventory_item_id is NULL
43: and item_number is not NULL
44: and organization_id is not NULL
45: and set_process_id = xset_id

Line 53: from mtl_item_revisions_interface

49: ** for assign transacton id
50: */
51: CURSOR ff is select distinct inventory_item_id,
52: organization_id
53: from mtl_item_revisions_interface
54: where process_flag = 1
55: and set_process_id = xset_id
56: and transaction_id IS NULL --Bug: 3019435 Added condition
57: and (organization_id = org_id or

Line 65: FROM mtl_item_revisions_interface

61: ** R12 C for assign revision id during default
62: */
63: CURSOR c_null_rev_id IS
64: SELECT rowid
65: FROM mtl_item_revisions_interface
66: WHERE process_flag = 1
67: AND set_process_id = xset_id
68: AND transaction_type = 'CREATE'
69: AND revision_id IS NULL

Line 94: update MTL_ITEM_REVISIONS_INTERFACE i

90: /*
91: ** assign all the missing organization_id from organization_code
92: */
93:
94: update MTL_ITEM_REVISIONS_INTERFACE i
95: set i.organization_id = (select o.organization_id
96: from MTL_PARAMETERS o
97: where o.organization_code = i.organization_code)
98: where i.organization_id is NULL

Line 118: update mtl_item_revisions_interface

114: err_text);
115:
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;

Line 144: 'MTL_ITEM_REVISIONS_INTERFACE',

140: request_id,
141: tran_id,
142: err_text,
143: 'item_number',
144: 'MTL_ITEM_REVISIONS_INTERFACE',
145: 'BOM_OP_VALIDATION_ERR',
146: err_text);
147: If dumm_status < 0 then
148: raise LOGGING_ERROR ;

Line 151: update mtl_item_revisions_interface

147: If dumm_status < 0 then
148: raise LOGGING_ERROR ;
149: End if ;
150: /*
151: update mtl_item_revisions_interface
152: set process_flag = l_process_flag_3,
153: transaction_id = tran_id
154: where item_number = cr.item_number
155: and inventory_item_id is NULL

Line 165: update mtl_item_revisions_interface

161: raise ASSIGN_ERROR;
162: end if;
163:
164: else if status = 0 then
165: update mtl_item_revisions_interface
166: set inventory_item_id = flex_id
167: where item_number = cr.item_number
168: and set_process_id = xset_id
169: and organization_id = cr.organization_id;

Line 183: update mtl_item_revisions_interface

179: select MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
180: into tran_id
181: from dual;
182:
183: update mtl_item_revisions_interface
184: set transaction_id = tran_id
185: where inventory_item_id = cr.inventory_item_id
186: and organization_id = cr.organization_id
187: and set_process_id + 0 = xset_id

Line 198: update mtl_item_revisions_interface

194: select MTL_ITEM_REVISIONS_B_S.nextval
195: into rev_id
196: from dual;
197:
198: update mtl_item_revisions_interface
199: set revision_id = rev_id
200: where rowid = cr.rowid;
201: END LOOP;
202:

Line 208: update mtl_item_revisions_interface

204: /*
205: ** update process flag , at last
206: ** For bug 3226359 added code to update date fields with sysdate + 1/86400 (1 sec) if they are NULL
207: */
208: update mtl_item_revisions_interface
209: set process_flag = DECODE(default_flag, 1, l_process_flag_2 , l_process_flag_1),
210: LAST_UPDATE_DATE = nvl(LAST_UPDATE_DATE,(sysdate + 1/86400)),
211: /* LAST_UPDATED_BY = -1,
212: ** NP 13OCT94 If you encounter ORA-6502 then see TAR 106456.555

Line 236: /* update mtl_item_revisions_interface i

232: ** set process flag for the records with errors
233: */
234:
235: --Bug :3625086
236: /* update mtl_item_revisions_interface i
237: set i.process_flag = l_process_flag_3,
238: i.LAST_UPDATE_DATE = sysdate,
239: i.LAST_UPDATED_BY = decode(i.LAST_UPDATED_BY, NULL, user_id,i.LAST_UPDATED_BY),
240: i.CREATION_DATE = l_sysdate,

Line 253: UPDATE mtl_item_revisions_interface i

249: ** failed within the same set
250: */
251:
252: FOR rec IN c_item_number_err LOOP
253: UPDATE mtl_item_revisions_interface i
254: SET i.process_flag = l_process_flag_3,
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,

Line 273: 'MTL_ITEM_REVISIONS_INTERFACE',

269: request_id,
270: tran_id,
271: null,
272: 'item_number',
273: 'MTL_ITEM_REVISIONS_INTERFACE',
274: 'INV_IOI_ITEM_NUMBER_NO_EXIST',
275: err_text);
276:
277: IF dumm_status < 0 THEN

Line 282: update mtl_item_revisions_interface i

278: raise LOGGING_ERROR ;
279: END IF ;
280: END LOOP;
281: --End 3625086
282: update mtl_item_revisions_interface i
283: set i.process_flag = l_process_flag_3
284: where i.transaction_id in (select m.transaction_id
285: from mtl_item_revisions_interface m
286: where m.process_flag = l_process_flag_3

Line 285: from mtl_item_revisions_interface m

281: --End 3625086
282: update mtl_item_revisions_interface i
283: set i.process_flag = l_process_flag_3
284: where i.transaction_id in (select m.transaction_id
285: from mtl_item_revisions_interface m
286: where m.process_flag = l_process_flag_3
287: and (m.organization_id = org_id or
288: all_org = l_all_org )
289: and set_process_id = xset_id )

Line 315: 'MTL_ITEM_REVISIONS_INTERFACE',

311: request_id,
312: tran_id,
313: err_text,
314: null,
315: 'MTL_ITEM_REVISIONS_INTERFACE',
316: 'BOM_PARSE_ITEM_ERROR',
317: err_text);
318: return(SQLCODE);
319: -- return(status);