APPS.ENG_ROUTING_PKG dependencies on BOM_OPERATIONAL_ROUTINGS

Line 40: UPDATE BOM_OPERATIONAL_ROUTINGS

36: X_stmt_num NUMBER;
37: BEGIN
38:
39: X_stmt_num := 500;
40: UPDATE BOM_OPERATIONAL_ROUTINGS
41: SET ROUTING_TYPE = 1
42: WHERE ORGANIZATION_ID = X_org_id
43: AND ASSEMBLY_ITEM_ID = X_eng_item_id
44: AND ((X_designator_option = 2 AND

Line 63: FROM BOM_OPERATIONAL_ROUTINGS BOR

59: OR (X_transfer_option = 3
60: AND NVL(BOS.DISABLE_DATE, X_effectivity_date + 1) <
61: X_effectivity_date))
62: AND EXISTS (SELECT 'X'
63: FROM BOM_OPERATIONAL_ROUTINGS BOR
64: WHERE ORGANIZATION_ID = X_org_id
65: AND ASSEMBLY_ITEM_ID = X_eng_item_id
66: AND ROUTING_TYPE = 1
67: AND BOS.ROUTING_SEQUENCE_ID = BOR.ROUTING_SEQUENCE_ID

Line 134: FROM BOM_OPERATIONAL_ROUTINGS

130: X_from_rtg_sequence_id NUMBER;
131:
132: CURSOR RTG_CURSOR IS
133: SELECT ROUTING_SEQUENCE_ID, ALTERNATE_ROUTING_DESIGNATOR
134: FROM BOM_OPERATIONAL_ROUTINGS
135: WHERE ORGANIZATION_ID = X_org_id
136: AND ASSEMBLY_ITEM_ID = X_mfg_item_id
137: AND COMMON_ROUTING_SEQUENCE_ID = ROUTING_SEQUENCE_ID;
138:

Line 142: FROM BOM_OPERATIONAL_ROUTINGS BOR

138:
139: -- BUG 3503220
140: CURSOR RTG_COPIES IS
141: SELECT ROUTING_SEQUENCE_ID, ALTERNATE_ROUTING_DESIGNATOR
142: FROM BOM_OPERATIONAL_ROUTINGS BOR
143: WHERE ORGANIZATION_ID = X_org_id
144: AND ASSEMBLY_ITEM_ID = X_mfg_item_id
145: AND COMMON_ROUTING_SEQUENCE_ID = ROUTING_SEQUENCE_ID
146: AND ((X_designator_option = 2 AND

Line 157: --- BOM_OPERATIONAL_ROUTINGS

153: BEGIN
154:
155: X_stmt_num := 800;
156:
157: --- BOM_OPERATIONAL_ROUTINGS
158: -- Bug 5104285 Added all columns in the insert. Otherwise flow routing was being
159: -- copied as a normal routing.
160: BEGIN
161: INSERT INTO BOM_OPERATIONAL_ROUTINGS(

Line 161: INSERT INTO BOM_OPERATIONAL_ROUTINGS(

157: --- BOM_OPERATIONAL_ROUTINGS
158: -- Bug 5104285 Added all columns in the insert. Otherwise flow routing was being
159: -- copied as a normal routing.
160: BEGIN
161: INSERT INTO BOM_OPERATIONAL_ROUTINGS(
162: ROUTING_SEQUENCE_ID,
163: ASSEMBLY_ITEM_ID,
164: ORGANIZATION_ID,
165: ALTERNATE_ROUTING_DESIGNATOR,

Line 205: BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL,

201: PENDING_FROM_ECN,
202: ORIGINAL_SYSTEM_REFERENCE,
203: SERIALIZATION_START_OP)
204: SELECT
205: BOM_OPERATIONAL_ROUTINGS_S.NEXTVAL,
206: X_mfg_item_id,
207: BOR.ORGANIZATION_ID,
208: BOR.ALTERNATE_ROUTING_DESIGNATOR,
209: SYSDATE,

Line 216: DECODE(BOR.COMMON_ROUTING_SEQUENCE_ID,BOR.ROUTING_SEQUENCE_ID,BOM_OPERATIONAL_ROUTINGS_S.CURRVAL,BOR.COMMON_ROUTING_SEQUENCE_ID),

212: to_number(Fnd_Profile.Value('USER_ID')),
213: to_number(Fnd_Profile.Value('LOGIN_ID')),
214: 1,
215: BOR.COMMON_ASSEMBLY_ITEM_ID,
216: DECODE(BOR.COMMON_ROUTING_SEQUENCE_ID,BOR.ROUTING_SEQUENCE_ID,BOM_OPERATIONAL_ROUTINGS_S.CURRVAL,BOR.COMMON_ROUTING_SEQUENCE_ID),
217: BOR.ROUTING_COMMENT,
218: BOR.COMPLETION_SUBINVENTORY,
219: BOR.COMPLETION_LOCATOR_ID,
220: BOR.ATTRIBUTE_CATEGORY,

Line 247: FROM BOM_OPERATIONAL_ROUTINGS BOR

243: TASK_ID,
244: PENDING_FROM_ECN,
245: ORIGINAL_SYSTEM_REFERENCE,
246: SERIALIZATION_START_OP
247: FROM BOM_OPERATIONAL_ROUTINGS BOR
248: WHERE ORGANIZATION_ID = X_org_id
249: AND ASSEMBLY_ITEM_ID = X_eng_item_id
250: AND ((X_designator_option = 2 AND
251: BOR.ALTERNATE_ROUTING_DESIGNATOR IS NULL)

Line 293: FROM BOM_OPERATIONAL_ROUTINGS

289: X_stmt_num := 801;
290: BEGIN
291: SELECT ROUTING_SEQUENCE_ID
292: INTO X_from_rtg_sequence_id
293: FROM BOM_OPERATIONAL_ROUTINGS
294: WHERE ORGANIZATION_ID = X_org_id
295: AND ASSEMBLY_ITEM_ID = X_eng_item_id
296: AND NVL(ALTERNATE_ROUTING_DESIGNATOR,'NONE') = NVL(RTG.ALTERNATE_ROUTING_DESIGNATOR,'NONE');
297: EXCEPTION

Line 317: UPDATE BOM_OPERATIONAL_ROUTINGS

313: to_alternate => RTG.ALTERNATE_ROUTING_DESIGNATOR,
314: rev_date => X_effectivity_date);
315:
316: IF (X_designator_option = 3 AND X_alt_rtg_designator IS NOT NULL) THEN -- bug 3570053
317: UPDATE BOM_OPERATIONAL_ROUTINGS
318: SET ALTERNATE_ROUTING_DESIGNATOR = NULL
319: WHERE ROUTING_SEQUENCE_ID = RTG.ROUTING_SEQUENCE_ID;
320: END IF;
321: END LOOP;