[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 24-JUL-2003 K.Boussema Updated the error messages |
| 30-JUL-2003 K.Boussema Updated the definition of C_FLEXFIELD_SEGMENT|
| 27-SEP-2003 K.Boussema Reviewed the generation of conditions |
| 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
| 3310291 and 3320689 |
| 23-FEB-2004 K.Boussema Made changes for the FND_LOG. |
| 22-MAR-2004 K.Boussema Added a parameter p_module to the TRACE calls|
| and the procedure. |
| 28-APR-2004 K.Boussema Bug 3596711: |
| Changed the compiler to allow a row in cond.|
| with just one bracket, reviewed |
| GetOneCondition() function |
| 11-MAY-2004 K.Boussema Removed the call to XLA trace routine from |
| trace() procedure |
| 01-JUN-2004 A.Quaglia Added changes for Transaction Account Builder |
| added C_TAD_FLEXFIELD_SEGMENT |
| modified GetOneRowCondition |
| 02-JUN-2004 A.Quaglia Changed TAD_ADR with TAB_ADR |
| 07-Mar-2005 K.Boussema Changed for ADR-enhancements. |
| 11-Oct-2005 Jorge Larre Fix for bug 4567102: the compiler must |
| consider that when using a segment of a source of type |
| flexfield in a condition, if the right operand is a |
| constant, the right operand must be treated as a char and |
| not as a number. |
+===========================================================================*/
--
g_chr_newline CONSTANT VARCHAR2(10):= xla_environment_pkg.g_chr_newline;
SELECT xc.user_sequence user_sequence
, xc.bracket_left_code bracket_left_code
, xc.bracket_right_code bracket_right_code
, xc.source_application_id source_application_id
, xc.source_type_code source_type_code
, xc.source_code source_code
, xc.flexfield_segment_code flexfield_segment
, xc.value_type_code value_type_code
, xc.value_source_application_id value_source_application_id
, xc.value_source_type_code value_source_type_code
, xc.value_source_code value_source_code
, xc.value_flexfield_segment_code value_flexfield_segment
, xc.value_constant value_constant
, xc.line_operator_code line_operator_code
, xc.logical_operator_code logical_operator_code
FROM xla_conditions xc
WHERE condition_id = p_condition
;
SELECT condition_id
, user_sequence
FROM xla_conditions xc
WHERE xc.application_id = p_application_id
AND xc.amb_context_code = p_amb_context_code
AND xc.description_prio_id = p_description_prio_id
ORDER BY user_sequence ) LOOP
l_cond := l_cond || GetOneRowCondition(
p_condition_id => condition_rec.condition_id
, p_array_cond_source_index => p_array_cond_source_index
, p_rec_sources => p_rec_sources
);
SELECT condition_id
, user_sequence
FROM xla_conditions xc
WHERE xc.application_id = p_application_id
AND xc.amb_context_code = p_amb_context_code
AND xc.segment_rule_detail_id = p_segment_rule_detail_id
ORDER BY user_sequence ) LOOP
l_cond := l_cond || GetOneRowCondition(
p_condition_id => condition_rec.condition_id
, p_array_cond_source_index => p_array_cond_source_index
, p_rec_sources => p_rec_sources
);
SELECT condition_id
, user_sequence
FROM xla_conditions xc
WHERE xc.application_id = p_application_id
AND xc.amb_context_code = p_amb_context_code
AND xc.accounting_line_code = p_acctg_line_code
AND xc.accounting_line_type_code = p_acctg_line_type_code
AND xc.entity_code = p_entity_code
AND xc.event_class_code = p_event_class_code
ORDER BY user_sequence
) LOOP
l_cond := l_cond || GetOneRowCondition(
p_condition_id => condition_rec.condition_id
, p_array_cond_source_index => p_array_cond_source_index
, p_rec_sources => p_rec_sources
);