APPS.BOMPASGB dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 127: update mtl_item_revisions_interface ori

123: end loop;
124:
125: stmt_num := 6;
126: loop
127: update mtl_item_revisions_interface ori
128: set organization_id = (select organization_id from
129: mtl_parameters a
130: where a.organization_code = ori.organization_code)
131: where process_flag = 1

Line 162: MTL_ITEM_REVISIONS_INTERFACE

158:
159: REQUIRES
160: err_text out buffer to return error message
161: MODIFIES
162: MTL_ITEM_REVISIONS_INTERFACE
163: MTL_INTERFACE_ERRORS
164: RETURNS
165: 0 if successful
166: SQLCODE if unsuccessful

Line 193: from mtl_item_revisions_interface

189: revision R,
190: inventory_item_id III, item_number IIN,
191: transaction_id TI,
192: implementation_date ID, effectivity_date ED
193: from mtl_item_revisions_interface
194: where process_flag = 1
195: and (all_org = 1
196: or
197: (all_org = 2 and organization_id = org_id)

Line 205: update mtl_item_revisions_interface

201: /*
202: ** assign transaction ids to all rows first
203: */
204: loop
205: update mtl_item_revisions_interface
206: set transaction_id = mtl_system_items_interface_s.nextval
207: where transaction_id is null
208: and process_flag = 1
209: and rownum < 500;

Line 230: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

226: prog_id => prog_id,
227: req_id => req_id,
228: trans_id => c1rec.TI,
229: error_text => err_text,
230: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
231: msg_name => 'BOM_ORG_ID_MISSING',
232: err_text => err_text);
233: update mtl_item_revisions_interface set
234: process_flag = 3

Line 233: update mtl_item_revisions_interface set

229: error_text => err_text,
230: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
231: msg_name => 'BOM_ORG_ID_MISSING',
232: err_text => err_text);
233: update mtl_item_revisions_interface set
234: process_flag = 3
235: where transaction_id = c1rec.TI;
236:
237: goto continue_loop;

Line 259: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

255: prog_id => prog_id,
256: req_id => req_id,
257: trans_id => c1rec.TI,
258: error_text => err_text,
259: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
260: msg_name => 'BOM_INV_ITEM_ID_MISSING',
261: err_text => err_text);
262: update mtl_item_revisions_interface set
263: process_flag = 3

Line 262: update mtl_item_revisions_interface set

258: error_text => err_text,
259: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
260: msg_name => 'BOM_INV_ITEM_ID_MISSING',
261: err_text => err_text);
262: update mtl_item_revisions_interface set
263: process_flag = 3
264: where transaction_id = c1rec.TI;
265:
266: if (ret_code <> 0) then

Line 275: update mtl_item_revisions_interface set

271: end if;
272:
273: stmt_num := 3;
274:
275: update mtl_item_revisions_interface set
276: organization_id = nvl(organization_id, c1rec.OI),
277: inventory_item_id = nvl(inventory_item_id, c1rec.III),
278: revision = UPPER(c1rec.R),
279: process_flag = 2,

Line 395: from MTL_ITEM_REVISIONS_INTERFACE

391: and rownum < 500;
392:
393: cursor c3 is select 1
394: from dual where exists ( select 1
395: from MTL_ITEM_REVISIONS_INTERFACE
396: where inventory_item_id = assembly_id
397: and organization_id = assembly_org_id
398: and revision = item_rev);
399:

Line 565: insert into mtl_item_revisions_interface

561: for x_count in c3 loop
562: x_dummy := 1;
563: end loop;
564: if x_dummy = 0 then
565: insert into mtl_item_revisions_interface
566: (INVENTORY_ITEM_ID,
567: ORGANIZATION_ID,
568: REVISION,
569: LAST_UPDATE_DATE,