DBA Data[Home] [Help]

APPS.CTO_CONFIGURED_ITEM_GRP dependencies on CTO_MATCH_CONFIG

Line 89: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;

85:
86: l_dummy_line_id number;
87: j number;
88:
89: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
90: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
91: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;
92:
93: CURSOR c_models_match_flag

Line 90: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;

86: l_dummy_line_id number;
87: j number;
88:
89: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
90: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
91: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;
92:
93: CURSOR c_models_match_flag
94: IS

Line 91: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;

87: j number;
88:
89: l_match_flag_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
90: x_sparse_match_tab CTO_MATCH_CONFIG.MATCH_FLAG_TBL_TYPE;
91: l_match_flag_rec_of_tab CTO_MATCH_CONFIG.Match_flag_rec_of_tab;
92:
93: CURSOR c_models_match_flag
94: IS
95: SELECT line_id,

Line 153: CTO_MATCH_CONFIG.Insert_into_bcol_gt(

149:
150:
151: IF p_Source <> 'GOP' THEN
152: lStmtNum:=30;
153: CTO_MATCH_CONFIG.Insert_into_bcol_gt(
154: p_match_rec_of_tab =>p_cto_match_rec,
155: x_return_status =>x_return_status,
156: x_msg_count =>X_msg_count,
157: x_msg_data =>X_msg_data

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

159:
160: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
161:
162: -- IF PG_DEBUG <> 0 THEN
163: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Insert_into_bcol_gt', 1);
164: -- END IF;
165:
166:
167: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 193: CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag

189:
190: IF l_model_exists = 'Y' THEN
191:
192: lStmtNum:=50;
193: CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag
194: (
195: x_return_status => x_return_status,
196: x_msg_count => x_msg_count,
197: x_msg_data => x_msg_data

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

199:
200: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
201: --level1
202: -- IF PG_DEBUG <> 0 THEN
203: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.Update_BCOLGT_with_match_flag', 1);
204: -- END IF;
205: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
206: RAISE fnd_api.g_exc_error;
207: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 216: CTO_MATCH_CONFIG.prepare_bcol_temp_data(

212: lStmtNum:=60;
213: IF p_Source NOT IN ('CTO','GOP') THEN
214:
215: lStmtNum:=70;
216: CTO_MATCH_CONFIG.prepare_bcol_temp_data(
217: p_source => p_Source,
218: p_match_rec_of_tab => p_cto_match_rec,
219: x_return_status => x_return_status,
220: x_msg_count => X_msg_count,

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

222: );
223: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
224: --level1
225: -- IF PG_DEBUG <> 0 THEN
226: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.prepare_bcol_temp_data', 1);
227: -- END IF;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE fnd_api.g_exc_error;
230: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 264: CTO_MATCH_CONFIG.perform_match

260: lStmtNum:=90;
261: FOR i in 1..l_last_index LOOP
262:
263: lStmtNum:= 100;
264: CTO_MATCH_CONFIG.perform_match
265: (
266: p_ato_line_id => l_ato_line_tbl(i),
267: -- p_custom_match_profile => l_custom_match_profile,
268: x_return_status => x_return_status,

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

272:
273: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
274: --level 3
275: IF PG_DEBUG <> 0 THEN
276: oe_debug_pub.add('MATCH_CONFIGURED_ITEM:'||'success after CTO_MATCH_CONFIG.perform_match for line_id=>'
277: ||l_ato_line_tbl(i), 3);
278: END IF;
279:
280: