APPS.CTO_ORDER_PURGE dependencies on BOM_CTO_ORDER_DEMAND

Line 85: --cursor to lock bom_cto_order_demand

81: FROM bom_cto_order_lines
82: WHERE header_id = p_header_id
83: FOR UPDATE NOWAIT;
84:
85: --cursor to lock bom_cto_order_demand
86: CURSOR c_bcod IS
87: SELECT header_id
88: FROM bom_cto_order_demand
89: WHERE header_id = p_header_id

Line 88: FROM bom_cto_order_demand

84:
85: --cursor to lock bom_cto_order_demand
86: CURSOR c_bcod IS
87: SELECT header_id
88: FROM bom_cto_order_demand
89: WHERE header_id = p_header_id
90: FOR UPDATE NOWAIT;
91:
92: --cursor to lock bom_cto_src_orgs

Line 175: --lock table bom_cto_order_demand

171:
172:
173: END IF;
174:
175: --lock table bom_cto_order_demand
176: OPEN c_bcod;
177:
178: CLOSE c_bcod;
179: IF PG_DEBUG <> 0 THEN

Line 183: DELETE FROM bom_cto_order_demand

179: IF PG_DEBUG <> 0 THEN
180: oe_debug_pub.add('cto_purge_tables: ' || 'locked table bcod ',3);
181: END IF;
182:
183: DELETE FROM bom_cto_order_demand
184: WHERE header_id = p_header_id;
185: l_row_deleted :=sql%rowcount;
186: IF PG_DEBUG <> 0 THEN
187: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_demand'||l_row_deleted,3);

Line 187: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_demand'||l_row_deleted,3);

183: DELETE FROM bom_cto_order_demand
184: WHERE header_id = p_header_id;
185: l_row_deleted :=sql%rowcount;
186: IF PG_DEBUG <> 0 THEN
187: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_demand'||l_row_deleted,3);
188: END IF;
189:
190: --bugfix#3763753
191: --Remove the pre-configure data from bcol and bcso_b