APPS.ENG_ECO_UTIL dependencies on BOM_OPERATION_SEQUENCES

Line 1199: UPDATE BOM_OPERATION_SEQUENCES bos

1195: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1196: END IF ;
1197:
1198: -- update operation sequences EFFECTIVITY_DATE
1199: UPDATE BOM_OPERATION_SEQUENCES bos
1200: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1201: WHERE bos.CHANGE_NOTICE = x_change_notice
1202: AND exists
1203: (select 'x' from bom_operational_routings

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

1205: and organization_id = x_organization_id )
1206: AND bos.IMPLEMENTATION_DATE IS NULL;
1207:
1208: IF FND_API.to_Boolean( p_debug ) THEN
1209: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1210: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1211: END IF ;
1212:
1213: -- update operation sequences DISABLE_DATE

Line 1214: UPDATE BOM_OPERATION_SEQUENCES bos1

1210: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1211: END IF ;
1212:
1213: -- update operation sequences DISABLE_DATE
1214: UPDATE BOM_OPERATION_SEQUENCES bos1
1215: SET bos1.DISABLE_DATE = p_effectivity_date
1216: WHERE bos1.CHANGE_NOTICE = x_change_notice
1217: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1218: AND exists

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

1221: and organization_id = x_organization_id )
1222: AND bos1.IMPLEMENTATION_DATE IS NULL;
1223:
1224: IF FND_API.to_Boolean( p_debug ) THEN
1225: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1226: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1227: END IF ;
1228:
1229: -- Modified query for performance bug 4251776

Line 1549: UPDATE BOM_OPERATION_SEQUENCES bos

1545: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1546: END IF ;
1547:
1548: -- update operation sequences EFFECTIVITY_DATE
1549: UPDATE BOM_OPERATION_SEQUENCES bos
1550: SET bos.EFFECTIVITY_DATE = p_effectivity_date
1551: WHERE bos.CHANGE_NOTICE = x_change_notice
1552: AND exists
1553: (select 'x' from bom_operational_routings

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

1555: and organization_id = x_organization_id )
1556: AND bos.IMPLEMENTATION_DATE IS NULL;
1557:
1558: IF FND_API.to_Boolean( p_debug ) THEN
1559: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.EFFECTIVITY_DATE updated ... ' );
1560: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1561: END IF ;
1562:
1563: -- update operation sequences DISABLE_DATE

Line 1564: UPDATE BOM_OPERATION_SEQUENCES bos1

1560: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1561: END IF ;
1562:
1563: -- update operation sequences DISABLE_DATE
1564: UPDATE BOM_OPERATION_SEQUENCES bos1
1565: SET bos1.DISABLE_DATE = p_effectivity_date
1566: WHERE bos1.CHANGE_NOTICE = x_change_notice
1567: and bos1.ACD_TYPE = 3 -- ACD Type: Disable
1568: AND exists

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

1571: and organization_id = x_organization_id )
1572: AND bos1.IMPLEMENTATION_DATE IS NULL;
1573:
1574: IF FND_API.to_Boolean( p_debug ) THEN
1575: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_OPERATION_SEQUENCES.DISABLE_DATE updated ... ' );
1576: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1577: END IF ;
1578:
1579: -- Modified query for performance bug 4251776

Line 1730: FROM BOM_OPERATION_SEQUENCES bos

1726:
1727: -- Delete substitute operation resources of all pending revised items on ECO
1728: DELETE FROM BOM_SUB_OPERATION_RESOURCES sor
1729: WHERE EXISTS (SELECT NULL
1730: FROM BOM_OPERATION_SEQUENCES bos
1731: , ENG_REVISED_ITEMS ri
1732: WHERE sor.operation_sequence_id = bos.operation_sequence_id
1733: AND bos.implementation_date IS NULL
1734: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 1744: FROM BOM_OPERATION_SEQUENCES bos

1740: -- Delete operation resources of all pending revised items on ECO
1741:
1742: DELETE FROM BOM_OPERATION_RESOURCES bor
1743: WHERE EXISTS (SELECT NULL
1744: FROM BOM_OPERATION_SEQUENCES bos
1745: , ENG_REVISED_ITEMS ri
1746: WHERE bor.operation_sequence_id = bos.operation_sequence_id
1747: AND bos.implementation_date IS NULL
1748: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 1885: FROM BOM_OPERATION_SEQUENCES bos

1881: , bos.REVISED_ITEM_SEQUENCE_ID
1882: , SYSDATE -- Cancellation Date
1883: , substr(p_cancel_comments, 1, 240) -- Cancel Comments
1884: , p_original_system_ref
1885: FROM BOM_OPERATION_SEQUENCES bos
1886: , ENG_REVISED_ITEMS ri
1887: WHERE bos.implementation_date IS NULL
1888: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id
1889: AND ri.status_type = 5 -- Cancelled

Line 1894: -- Delete the rows from bom_operation_sequences

1890: AND ri.organization_id = p_org_id
1891: AND ri.change_notice = p_eco_name ;
1892:
1893:
1894: -- Delete the rows from bom_operation_sequences
1895:
1896: DELETE FROM BOM_OPERATION_SEQUENCES bos
1897: WHERE EXISTS (SELECT NULL
1898: FROM ENG_REVISED_ITEMS ri

Line 1896: DELETE FROM BOM_OPERATION_SEQUENCES bos

1892:
1893:
1894: -- Delete the rows from bom_operation_sequences
1895:
1896: DELETE FROM BOM_OPERATION_SEQUENCES bos
1897: WHERE EXISTS (SELECT NULL
1898: FROM ENG_REVISED_ITEMS ri
1899: WHERE bos.implementation_date IS NULL
1900: AND bos.revised_item_sequence_id = ri.revised_item_sequence_id

Line 1933: FROM BOM_OPERATION_SEQUENCES bos

1929: AND ri.organization_id = p_org_id
1930: AND ri.change_notice = p_eco_name
1931: )
1932: AND NOT EXISTS (SELECT NULL
1933: FROM BOM_OPERATION_SEQUENCES bos
1934: WHERE bos.routing_sequence_id = bor.routing_sequence_id
1935: AND (bos.change_notice IS NULL
1936: OR bos.change_notice <> p_eco_name)
1937: )