APPS.BOMPASGR dependencies on MTL_RTG_ITEM_REVS_INTERFACE

Line 38: MTL_RTG_ITEM_REVS_INTERFACE

34: MODIFIES
35: BOM_OP_ROUTINGS_INTERFACE
36: BOM_OP_SEQUENCES_INTERFACE
37: BOM_OP_RESOURCES_INTERFACE
38: MTL_RTG_ITEM_REVS_INTERFACE
39: MTL_INTERFACE_ERRORS
40: RETURNS
41: 0 if successful
42: SQLCODE if unsuccessful

Line 109: update mtl_rtg_item_revs_interface ori

105: end loop;
106:
107: stmt_num := 4;
108: loop
109: update mtl_rtg_item_revs_interface ori
110: set organization_id = (select organization_id from
111: mtl_parameters a
112: where a.organization_code = ori.organization_code)
113: where process_flag = 1

Line 137: MTL_RTG_ITEM_REVS_INTERFACE. If any application error occurs, it

133: /* NAME
134: bmasrrev_assign_rtg_revision - assign routing revision
135: DESCRIPTION
136: assign defaults and various ids in the interface table
137: MTL_RTG_ITEM_REVS_INTERFACE. If any application error occurs, it
138: inserts record into MTL_INTERFACE_ERRORS.
139:
140: REQUIRES
141: err_text out buffer to return error message

Line 143: MTL_RTG_ITEM_REVS_INTERFACE

139:
140: REQUIRES
141: err_text out buffer to return error message
142: MODIFIES
143: MTL_RTG_ITEM_REVS_INTERFACE
144: MTL_INTERFACE_ERRORS
145: RETURNS
146: 0 if successful
147: SQLCODE if unsuccessful

Line 173: from mtl_rtg_item_revs_interface

169: process_revision PR,
170: inventory_item_id III, inventory_item_number IIN,
171: transaction_id TI, change_notice CN, ecn_initiation_date CID,
172: implementation_date ID, effectivity_date ED
173: from mtl_rtg_item_revs_interface
174: where process_flag = 1
175: and (all_org = 1
176: or
177: (all_org = 2 and organization_id = org_id)

Line 186: update mtl_rtg_item_revs_interface

182: /*
183: ** assign transaction ids to all rows first
184: */
185: loop
186: update mtl_rtg_item_revs_interface
187: set transaction_id = mtl_system_items_interface_s.nextval
188: where transaction_id is null
189: and process_flag = 1
190: and rownum < 500;

Line 211: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

207: prog_id => prog_id,
208: req_id => req_id,
209: trans_id => c1rec.TI,
210: error_text => err_text,
211: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
212: msg_name => 'BOM_ORG_ID_MISSING',
213: err_text => err_text);
214: update mtl_rtg_item_revs_interface set
215: process_flag = 3

Line 214: update mtl_rtg_item_revs_interface set

210: error_text => err_text,
211: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
212: msg_name => 'BOM_ORG_ID_MISSING',
213: err_text => err_text);
214: update mtl_rtg_item_revs_interface set
215: process_flag = 3
216: where transaction_id = c1rec.TI;
217:
218: goto continue_loop;

Line 240: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',

236: prog_id => prog_id,
237: req_id => req_id,
238: trans_id => c1rec.TI,
239: error_text => err_text,
240: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
241: msg_name => 'BOM_INV_ITEM_ID_MISSING',
242: err_text => err_text);
243: update mtl_rtg_item_revs_interface set
244: process_flag = 3

Line 243: update mtl_rtg_item_revs_interface set

239: error_text => err_text,
240: tbl_name => 'MTL_RTG_ITEM_REVS_INTERFACE',
241: msg_name => 'BOM_INV_ITEM_ID_MISSING',
242: err_text => err_text);
243: update mtl_rtg_item_revs_interface set
244: process_flag = 3
245: where transaction_id = c1rec.TI;
246:
247: if (ret_code <> 0) then

Line 256: update mtl_rtg_item_revs_interface set

252: end if;
253:
254: stmt_num := 3;
255:
256: update mtl_rtg_item_revs_interface set
257: organization_id = nvl(organization_id, c1rec.OI),
258: inventory_item_id = nvl(inventory_item_id, c1rec.III),
259: process_revision = UPPER(c1rec.PR),
260: process_flag = 2,

Line 529: insert into mtl_rtg_item_revs_interface

525: /*
526: ** insert given process_revision
527: */
528: if (c1rec.PR is not null) then
529: insert into mtl_rtg_item_revs_interface
530: (organization_id,
531: inventory_item_id,
532: process_revision,
533: process_flag,

Line 574: from mtl_rtg_item_revs_interface

570: ** check to see if a record exists in the revs interface table for this
571: ** item/org combination
572: */
573: select count(process_revision) into revs_int
574: from mtl_rtg_item_revs_interface
575: where organization_id = c1rec.OI
576: and inventory_item_id = c1rec.AII
577: and process_flag <> 3 and process_flag <> 7;
578: /*

Line 592: insert into mtl_rtg_item_revs_interface

588: /*
589: ** insert a record into the revs interface table because one does not exist
590: */
591: if (revs = 0) then
592: insert into mtl_rtg_item_revs_interface
593: (organization_id,
594: inventory_item_id,
595: process_revision,
596: process_flag,