APPS.CTO_AUTO_PURGE_PK dependencies on BOM_ATO_CONFIGURATIONS

Line 10: | DESCRIPTION : Purge Configurations from bom_ato_configurations table |

6: | Oracle Manufacturing |
7: +=============================================================================+
8: | |
9: | FILE NAME : CTODCFGB.pls |
10: | DESCRIPTION : Purge Configurations from bom_ato_configurations table |
11: | HISTORY : |
12: | 26-Nov-2002 : Kundan Sarkar Initial Version
13: |
14: |

Line 119: delete from bom_ato_configurations

115: return ;
116: end if ;
117:
118: -- Process deletion of rows
119: delete from bom_ato_configurations
120: where ( p_base_model is null
121: or ( p_base_model is not null and p_option_item is null and base_model_id = p_base_model)
122: or ( p_base_model is not null and p_option_item is not null and config_item_id in
123: ( select config_item_id from bom_ato_configurations bac

Line 123: ( select config_item_id from bom_ato_configurations bac

119: delete from bom_ato_configurations
120: where ( p_base_model is null
121: or ( p_base_model is not null and p_option_item is null and base_model_id = p_base_model)
122: or ( p_base_model is not null and p_option_item is not null and config_item_id in
123: ( select config_item_id from bom_ato_configurations bac
124: where bac.base_model_id = p_base_model
125: and bac.component_item_id = p_option_item )
126: )
127: )