DBA Data[Home] [Help]

APPS.ICX_CAT_SQE_PVT dependencies on CTX_QUERY

Line 84: ctx_query.store_sqe(l_int_sqe_name, l_int_intermedia_expression);

80: l_both_sqe_name := 'icxzb' || l_sqe_sequence;
81:
82: l_err_loc := 700;
83: -- now store the sqes
84: ctx_query.store_sqe(l_int_sqe_name, l_int_intermedia_expression);
85: ctx_query.store_sqe(l_purch_sqe_name, l_purch_intermedia_expression);
86: ctx_query.store_sqe(l_both_sqe_name, l_both_intermedia_expression);
87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 85: ctx_query.store_sqe(l_purch_sqe_name, l_purch_intermedia_expression);

81:
82: l_err_loc := 700;
83: -- now store the sqes
84: ctx_query.store_sqe(l_int_sqe_name, l_int_intermedia_expression);
85: ctx_query.store_sqe(l_purch_sqe_name, l_purch_intermedia_expression);
86: ctx_query.store_sqe(l_both_sqe_name, l_both_intermedia_expression);
87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: l_log_string := 'Finished Storing sqes';

Line 86: ctx_query.store_sqe(l_both_sqe_name, l_both_intermedia_expression);

82: l_err_loc := 700;
83: -- now store the sqes
84: ctx_query.store_sqe(l_int_sqe_name, l_int_intermedia_expression);
85: ctx_query.store_sqe(l_purch_sqe_name, l_purch_intermedia_expression);
86: ctx_query.store_sqe(l_both_sqe_name, l_both_intermedia_expression);
87:
88: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
89: l_log_string := 'Finished Storing sqes';
90: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,

Line 744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));

740: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
742: END IF;
743: l_err_loc := 300;
744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
747: END LOOP;
748: EXCEPTION

Line 745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));

741: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
742: END IF;
743: l_err_loc := 300;
744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
747: END LOOP;
748: EXCEPTION
749: WHEN OTHERS THEN

Line 746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));

742: END IF;
743: l_err_loc := 300;
744: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
745: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
746: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
747: END LOOP;
748: EXCEPTION
749: WHEN OTHERS THEN
750: NULL;