APPS.CTO_ORDER_PURGE dependencies on BOM_CTO_SRC_ORGS_B

Line 31: | Refrence to bom_cto_src_orgs is changed to bom_cto_src_orgs_b

27: | data in bcol
28: |
29: | 03/26/2004 bugfix#3524022
30: | Kkonada added code to delete data from bom_cto_model_orgs
31: | Refrence to bom_cto_src_orgs is changed to bom_cto_src_orgs_b
32: |
33: |
34: | 04/05/2004 bugfix#3524022
35: | coorected bugfix.

Line 95: FROM bom_cto_src_orgs_b --3524022

91:
92: --cursor to lock bom_cto_src_orgs
93: CURSOR c_b_src_org Is
94: SELECT top_model_line_id
95: FROM bom_cto_src_orgs_b --3524022
96: WHERE top_model_line_id=l_top_model_line_id
97: FOR UPDATE NOWAIT;
98:
99:

Line 156: DELETE FROM bom_cto_src_orgs_b --3524022

152:
153:
154: --Delete data from tables
155:
156: DELETE FROM bom_cto_src_orgs_b --3524022
157: WHERE top_model_line_id=l_top_model_line_id;
158: l_row_deleted :=sql%rowcount;
159: IF PG_DEBUG <> 0 THEN
160: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_src_orgs_b'||l_row_deleted,3);

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

156: DELETE FROM bom_cto_src_orgs_b --3524022
157: WHERE top_model_line_id=l_top_model_line_id;
158: l_row_deleted :=sql%rowcount;
159: IF PG_DEBUG <> 0 THEN
160: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_src_orgs_b'||l_row_deleted,3);
161: END IF;
162:
163:
164:

Line 203: delete from bom_cto_src_orgs_b

199: IF PG_DEBUG <> 0 THEN
200: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_order_lines'||l_row_deleted,3);
201: END IF;
202:
203: delete from bom_cto_src_orgs_b
204: where line_id < 0;
205: l_row_deleted :=sql%rowcount;
206: IF PG_DEBUG <> 0 THEN
207: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_src_orgs_b'||l_row_deleted,3);

Line 207: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_src_orgs_b'||l_row_deleted,3);

203: delete from bom_cto_src_orgs_b
204: where line_id < 0;
205: l_row_deleted :=sql%rowcount;
206: IF PG_DEBUG <> 0 THEN
207: oe_debug_pub.add('cto_purge_tables: ' || 'pre-cfg rows deleted from bom_cto_src_orgs_b'||l_row_deleted,3);
208: END IF;
209: --end bugfix#3763753
210:
211: x_return_status := FND_API.G_RET_STS_SUCCESS;