APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_ATO_CONFIGURATIONS

Line 95: | Remove from bom_ato_configurations so that de- |

91: | check onhand for the config item before |
92: | deactivating. |
93: | |
94: | bugfix 2477125 |
95: | Remove from bom_ato_configurations so that de- |
96: | activated items are not used for matching. |
97: | |
98: | 10/01/2003 KSARKAR Changes to program for fp-J. |
99: | 11/19/2003 SBHASKAR bugfix 3275577. Added x_return_status parameter to|

Line 637: from bom_ato_configurations

633: and base_item_id is NOT NULL
634: and inventory_item_status_code <> l_del_status
635: and NOT EXISTS (
636: select 1
637: from bom_ato_configurations
638: where config_item_id = msi.inventory_item_id
639: and rownum = 1)
640: ORDER BY inventory_item_id;
641:

Line 667: -- no rows in bom_ato_configurations.

663: -- check if config is in match table
664:
665: -- bugfix 3443251 : Add exception
666: -- handling NO_DATA_FOUND exception and continue if there are
667: -- no rows in bom_ato_configurations.
668:
669: Begin
670: select 1 into l_chk_cfg
671: from bom_ato_configurations

Line 671: from bom_ato_configurations

667: -- no rows in bom_ato_configurations.
668:
669: Begin
670: select 1 into l_chk_cfg
671: from bom_ato_configurations
672: where config_item_id = l_config_id;
673: Exception
674: WHEN NO_DATA_FOUND THEN
675: WriteToLog(' This configuration '||l_config_id||' does not exist in match table.', 2);

Line 1491: -- Inserting pending status and deleting matched items from bom_ato_configurations

1487:
1488:
1489: l_stat_num := 140;
1490: --
1491: -- Inserting pending status and deleting matched items from bom_ato_configurations
1492: --
1493:
1494: x_return_status := FND_API.G_RET_STS_SUCCESS;
1495:

Line 1735: -- also remove the de-activated configurations from the bom_ato_configurations ,

1731:
1732: -- bug 2477125:
1733:
1734: -- In addition to disabling the bom and routing for deactivated items, we should
1735: -- also remove the de-activated configurations from the bom_ato_configurations ,
1736: -- so that these are not used for future matches.
1737:
1738: -- Please note that configurations stored in this tables are org-indepedent
1739: -- (matched across orgs), so we will use the following criteria for deletion...

Line 1752: WriteToLog ('Deleting from Bom_Ato_Configurations..',3);

1748:
1749:
1750: if ( gAttrControl = 1 or p_table(l_index).cfg_orgn_id = gMasterOrgn )
1751: then
1752: WriteToLog ('Deleting from Bom_Ato_Configurations..',3);
1753:
1754: DELETE FROM bom_ato_configurations
1755: WHERE config_item_id = p_table(l_index).cfg_item_id;
1756:

Line 1754: DELETE FROM bom_ato_configurations

1750: if ( gAttrControl = 1 or p_table(l_index).cfg_orgn_id = gMasterOrgn )
1751: then
1752: WriteToLog ('Deleting from Bom_Ato_Configurations..',3);
1753:
1754: DELETE FROM bom_ato_configurations
1755: WHERE config_item_id = p_table(l_index).cfg_item_id;
1756:
1757: --bugfix 3557190
1758: l_row_deleted :=sql%rowcount;

Line 1787: WriteToLog ('Deleted item_id '||p_table(l_index).cfg_item_id ||' from Bom_Ato_Configurations..',3);

1783:
1784:
1785:
1786: if sql%found then
1787: WriteToLog ('Deleted item_id '||p_table(l_index).cfg_item_id ||' from Bom_Ato_Configurations..',3);
1788: end if;
1789: end if;
1790:
1791: EXIT WHEN l_index = p_table.LAST;