APPS.ENG_ECO_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 1586: UPDATE BOM_OPERATION_SEQUENCES bos

1582: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1583: END IF ;
1584:
1585: -- update operation sequences EFFECTIVITY_DATE
1586: UPDATE BOM_OPERATION_SEQUENCES bos
1587: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1588: WHERE bos.CHANGE_NOTICE = x_change_notice
1589: AND exists
1590: (select 'x' from bom_operational_routings

Line 1596: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );

1592: and organization_id = x_organization_id )
1593: AND bos.IMPLEMENTATION_DATE IS NULL;
1594:
1595: IF FND_API.to_Boolean( p_debug ) THEN
1596: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1597: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1598: END IF ;
1599:
1600: -- update operation sequences DISABLE_DATE

Line 1601: UPDATE BOM_OPERATION_SEQUENCES bos1

1597: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1598: END IF ;
1599:
1600: -- update operation sequences DISABLE_DATE
1601: UPDATE BOM_OPERATION_SEQUENCES bos1
1602: SET bos1.DISABLE_DATE = p_effectivity_date
1603: WHERE bos1.CHANGE_NOTICE = x_change_notice
1604: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1605: AND exists

Line 1612: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );

1608: and organization_id = x_organization_id )
1609: AND bos1.IMPLEMENTATION_DATE IS NULL;
1610:
1611: IF FND_API.to_Boolean( p_debug ) THEN
1612: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1613: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1614: END IF ;
1615:
1616: -- Modified query for performance bug 4251776

Line 1976: UPDATE BOM_OPERATION_SEQUENCES bos

1972: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1973: END IF ;
1974:
1975: -- update operation sequences EFFECTIVITY_DATE
1976: UPDATE BOM_OPERATION_SEQUENCES bos
1977: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1978: WHERE bos.CHANGE_NOTICE = x_change_notice
1979: AND exists
1980: (select 'x' from bom_operational_routings

Line 1986: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );

1982: and organization_id = x_organization_id )
1983: AND bos.IMPLEMENTATION_DATE IS NULL;
1984:
1985: IF FND_API.to_Boolean( p_debug ) THEN
1986: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1987: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1988: END IF ;
1989:
1990: -- update operation sequences DISABLE_DATE

Line 1991: UPDATE BOM_OPERATION_SEQUENCES bos1

1987: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1988: END IF ;
1989:
1990: -- update operation sequences DISABLE_DATE
1991: UPDATE BOM_OPERATION_SEQUENCES bos1
1992: SET bos1.DISABLE_DATE = p_effectivity_date
1993: WHERE bos1.CHANGE_NOTICE = x_change_notice
1994: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1995: AND exists

Line 2002: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );

1998: and organization_id = x_organization_id )
1999: AND bos1.IMPLEMENTATION_DATE IS NULL;
2000:
2001: IF FND_API.to_Boolean( p_debug ) THEN
2002: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
2003: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
2004: END IF ;
2005:
2006: -- Modified query for performance bug 4251776

Line 2157: FROM BOM_OPERATION_SEQUENCES bos

2153:
2154: -- Delete substitute operation resources of all pending revised items on ECO
2155: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
2156: WHERE EXISTS (SELECT NULL
2157: FROM BOM_OPERATION_SEQUENCES bos
2158: , ENG_REVISED_ITEMS ri
2159: WHERE sor.operation_sequence_id = bos.operation_sequence_id
2160: AND bos.implementation_date IS NULL
2161: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 2171: FROM BOM_OPERATION_SEQUENCES bos

2167: -- Delete operation resources of all pending revised items on ECO
2168:
2169: DELETE FROM BOM_OPERATION_RESOURCES bor
2170: WHERE EXISTS (SELECT NULL
2171: FROM BOM_OPERATION_SEQUENCES bos
2172: , ENG_REVISED_ITEMS ri
2173: WHERE bor.operation_sequence_id = bos.operation_sequence_id
2174: AND bos.implementation_date IS NULL
2175: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 2312: FROM BOM_OPERATION_SEQUENCES bos

2308: , bos.REVISED_ITEM_SEQUENCE_ID
2309: , SYSDATE -- Cancellation Date
2310: , substr(p_cancel_comments, 1, 240) -- Cancel Comments
2311: , p_original_system_ref
2312: FROM BOM_OPERATION_SEQUENCES bos
2313: , ENG_REVISED_ITEMS ri
2314: WHERE bos.implementation_date IS NULL
2315: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
2316: AND ri.status_type = 5 -- Cancelled

Line 2321: -- Delete the rows from bom_operation_sequences

2317: AND ri.organization_id = p_org_id
2318: AND ri.change_notice = p_eco_name ;
2319:
2320:
2321: -- Delete the rows from bom_operation_sequences
2322:
2323: DELETE FROM BOM_OPERATION_SEQUENCES bos
2324: WHERE EXISTS (SELECT NULL
2325: FROM ENG_REVISED_ITEMS ri

Line 2323: DELETE FROM BOM_OPERATION_SEQUENCES bos

2319:
2320:
2321: -- Delete the rows from bom_operation_sequences
2322:
2323: DELETE FROM BOM_OPERATION_SEQUENCES bos
2324: WHERE EXISTS (SELECT NULL
2325: FROM ENG_REVISED_ITEMS ri
2326: WHERE bos.implementation_date IS NULL
2327: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 2360: FROM BOM_OPERATION_SEQUENCES bos

2356: AND ri.organization_id = p_org_id
2357: AND ri.change_notice = p_eco_name
2358: )
2359: AND NOT EXISTS (SELECT NULL
2360: FROM BOM_OPERATION_SEQUENCES bos
2361: WHERE bos.routing_sequence_id = bor.routing_sequence_id
2362: AND (bos.change_notice IS NULL
2363: OR bos.change_notice <> p_eco_name)
2364: )