APPS.CTO_ORDER_PURGE dependencies on BOM_CTO_ORDER_LINES

Line 68: l_top_model_line_id bom_cto_order_lines.top_model_line_id%type;

64:
65: IS
66:
67:
68: l_top_model_line_id bom_cto_order_lines.top_model_line_id%type;
69:
70: --flags to control process flow depending on existance of header_id
71: bcol_flag_1 VARCHAR2(1) := 'Y';
72:

Line 78: --cursor to lock bom_cto_order_lines

74: --dummy variable
75: l_dummy number;
76: l_row_deleted number;
77:
78: --cursor to lock bom_cto_order_lines
79: CURSOR c_bcol IS
80: SELECT header_id
81: FROM bom_cto_order_lines
82: WHERE header_id = p_header_id

Line 81: FROM bom_cto_order_lines

77:
78: --cursor to lock bom_cto_order_lines
79: CURSOR c_bcol IS
80: SELECT header_id
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

Line 111: FROM bom_cto_order_lines

107: --to check if rows exists for header_id in cto tables
108: BEGIN
109: SELECT header_id
110: INTO l_dummy
111: FROM bom_cto_order_lines
112: where header_id= p_header_id
113: and rownum=1;
114: EXCEPTION
115: WHEN OTHERS THEN

Line 127: --lock table bom_cto_order_lines

123:
124:
125: IF bcol_flag_1 = 'Y' THEN
126:
127: --lock table bom_cto_order_lines
128: OPEN c_bcol;
129:
130: CLOSE c_bcol;
131: IF PG_DEBUG <> 0 THEN

Line 137: FROM bom_cto_order_lines

133: END IF;
134:
135: SELECT top_model_line_id
136: INTO l_top_model_line_id
137: FROM bom_cto_order_lines
138: where header_id= p_header_id
139: and rownum=1;
140: IF PG_DEBUG <> 0 THEN
141: oe_debug_pub.add('cto_purge_tables: ' || 'select top_model_line_id for lock bom_cto_src_org',3);

Line 165: DELETE FROM bom_cto_order_lines

161: END IF;
162:
163:
164:
165: DELETE FROM bom_cto_order_lines
166: WHERE header_id = p_header_id;
167: l_row_deleted :=sql%rowcount;
168: IF PG_DEBUG <> 0 THEN
169: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_lines'||l_row_deleted,3);

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

165: DELETE FROM bom_cto_order_lines
166: WHERE header_id = p_header_id;
167: l_row_deleted :=sql%rowcount;
168: IF PG_DEBUG <> 0 THEN
169: oe_debug_pub.add('cto_purge_tables: ' || 'deleted from bom_cto_order_lines'||l_row_deleted,3);
170: END IF;
171:
172:
173: END IF;

Line 196: delete from bom_cto_order_lines

192: --as they are not needed for any future use
193: --this is only for data created pre-11.5.10(BUT this is coded in 11.5.10)
194: --In 11.5.10 data is deleted at the end of pre-cfg process
195:
196: delete from bom_cto_order_lines
197: where line_id < 0;
198: l_row_deleted :=sql%rowcount;
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);

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

196: delete from bom_cto_order_lines
197: where line_id < 0;
198: l_row_deleted :=sql%rowcount;
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;