APPS.CTO_CONFIGURED_ITEM_GRP dependencies on CTO_MATCH_CONFIG

Line 128: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;

124:
125: l_dummy_line_id number;
126: j number;
127:
128: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
129: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
130: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;
131:
132: CURSOR c_models_match_flag

Line 129: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;

125: l_dummy_line_id number;
126: j number;
127:
128: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
129: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
130: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;
131:
132: CURSOR c_models_match_flag
133: IS

Line 130: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;

126: j number;
127:
128: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
129: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
130: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;
131:
132: CURSOR c_models_match_flag
133: IS
134: SELECT line_id,

Line 190: CTO_MATCH_CONFIG.Insert_into_bcol_gt(p_match_rec_of_tab =>p_cto_match_rec,

186:
187: IF p_Source <> 'GOP' THEN
188: lStmtNum:=30;
189:
190: CTO_MATCH_CONFIG.Insert_into_bcol_gt(p_match_rec_of_tab =>p_cto_match_rec,
191: x_return_status =>x_return_status,
192: x_msg_count =>X_msg_count,
193: x_msg_data =>X_msg_data
194: );

Line 199: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);

195:
196: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
197:
198: -- IF PG_DEBUG <> 0 THEN
199: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
200: -- END IF;
201:
202: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
203: RAISE fnd_api.g_exc_error;

Line 226: CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag

222:
223: IF l_model_exists = 'Y' THEN
224:
225: lStmtNum:=50;
226: CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag
227: (
228: x_return_status => x_return_status,
229: x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data

Line 236: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);

232:
233: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
234: --level1
235: -- IF PG_DEBUG <> 0 THEN
236: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
237: -- END IF;
238: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
239: RAISE fnd_api.g_exc_error;
240: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 248: CTO_MATCH_CONFIG.prepare_bcol_temp_data(

244: lStmtNum:=60;
245: IF p_Source NOT IN ('CTO','GOP') THEN
246:
247: lStmtNum:=70;
248: CTO_MATCH_CONFIG.prepare_bcol_temp_data(
249: p_source => p_Source,
250: p_match_rec_of_tab => p_cto_match_rec,
251: x_return_status => x_return_status,
252: x_msg_count => X_msg_count,

Line 258: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);

254: );
255: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
256: --level1
257: -- IF PG_DEBUG <> 0 THEN
258: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
259: -- END IF;
260: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
261: RAISE fnd_api.g_exc_error;
262: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 295: CTO_MATCH_CONFIG.perform_match

291: lStmtNum:=90;
292: FOR i in 1..l_last_index LOOP
293:
294: lStmtNum:= 100;
295: CTO_MATCH_CONFIG.perform_match
296: (
297: p_ato_line_id => l_ato_line_tbl(i),
298: -- p_custom_match_profile => l_custom_match_profile,
299: x_return_status => x_return_status,

Line 309: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'

305:
306: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
307: --level 3
308: IF PG_DEBUG <> 0 THEN
309: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'
310: ||l_ato_line_tbl(i), 3);
311: END IF;
312:
313: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN