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 733: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));

729: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
731: END IF;
732: l_err_loc := 300;
733: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
734: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
735: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
736: END LOOP;
737: EXCEPTION

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

730: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name), l_log_string);
731: END IF;
732: l_err_loc := 300;
733: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
734: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
735: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
736: END LOOP;
737: EXCEPTION
738: WHEN OTHERS THEN

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

731: END IF;
732: l_err_loc := 300;
733: ctx_query.remove_sqe('icxzi' || l_sqe_sequences(i));
734: ctx_query.remove_sqe('icxzp' || l_sqe_sequences(i));
735: ctx_query.remove_sqe('icxzb' || l_sqe_sequences(i));
736: END LOOP;
737: EXCEPTION
738: WHEN OTHERS THEN
739: NULL;