eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ADR_INTERFACE_PKG dependencies on XLA_CONDITIONS

Line 107: AD_ZD_SEED.PREPARE('XLA_CONDITIONS');

103:
104: AD_ZD_SEED.PREPARE('XLA_SEG_RULES_B');
105: AD_ZD_SEED.PREPARE('XLA_SEG_RULES_TL');
106: AD_ZD_SEED.PREPARE('XLA_SEG_RULE_DETAILS');
107: AD_ZD_SEED.PREPARE('XLA_CONDITIONS');
108: AD_ZD_SEED.PREPARE('XLA_LINE_DEFN_ADR_ASSGNS');
109:
110:
111: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 144: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t

140: FROM xla_rule_details_t
141: WHERE error_value = 0
142: FOR UPDATE of error_value;
143:
144: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t
145: SELECT *
146: FROM xla_conditions_t
147: WHERE error_value = 0
148: FOR UPDATE of error_value;

Line 146: FROM xla_conditions_t

142: FOR UPDATE of error_value;
143:
144: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t
145: SELECT *
146: FROM xla_conditions_t
147: WHERE error_value = 0
148: FOR UPDATE of error_value;
149:
150: CURSOR c_xla_line_assgns_t IS -- cursor for xla_line_assgns_t

Line 163: l_xla_conditions c_xla_conditions_t%ROWTYPE;

159: WHERE installed_flag = 'I';
160:
161: l_xla_rules c_xla_rules_t%ROWTYPE;
162: l_xla_rule_details c_xla_rule_details_t%ROWTYPE;
163: l_xla_conditions c_xla_conditions_t%ROWTYPE;
164: l_xla_line_assgns c_xla_line_assgns_t%ROWTYPE;
165: l_base_language VARCHAR2(4);
166: l_installed_language t_array_vl4;
167: l_user_id INTEGER;

Line 424: OPEN c_xla_conditions_t;

420: END; -- Block ends
421: END LOOP;
422: CLOSE c_xla_rule_details_t;
423:
424: OPEN c_xla_conditions_t;
425: LOOP
426: FETCH c_xla_conditions_t INTO l_xla_conditions;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:

Line 426: FETCH c_xla_conditions_t INTO l_xla_conditions;

422: CLOSE c_xla_rule_details_t;
423:
424: OPEN c_xla_conditions_t;
425: LOOP
426: FETCH c_xla_conditions_t INTO l_xla_conditions;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:
429: BEGIN -- Block begins
430: -- Insert data into xla_conditions

Line 427: EXIT WHEN c_xla_conditions_t%NOTFOUND;

423:
424: OPEN c_xla_conditions_t;
425: LOOP
426: FETCH c_xla_conditions_t INTO l_xla_conditions;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:
429: BEGIN -- Block begins
430: -- Insert data into xla_conditions
431: INSERT INTO xla_conditions

Line 430: -- Insert data into xla_conditions

426: FETCH c_xla_conditions_t INTO l_xla_conditions;
427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:
429: BEGIN -- Block begins
430: -- Insert data into xla_conditions
431: INSERT INTO xla_conditions
432: (condition_id
433: ,user_sequence
434: ,application_id

Line 431: INSERT INTO xla_conditions

427: EXIT WHEN c_xla_conditions_t%NOTFOUND;
428:
429: BEGIN -- Block begins
430: -- Insert data into xla_conditions
431: INSERT INTO xla_conditions
432: (condition_id
433: ,user_sequence
434: ,application_id
435: ,amb_context_code

Line 464: (l_xla_conditions.condition_id

460: ,last_update_login
461: ,independent_value_constant
462: )
463: VALUES
464: (l_xla_conditions.condition_id
465: ,l_xla_conditions.user_sequence
466: ,l_xla_conditions.application_id
467: ,l_xla_conditions.amb_context_code
468: ,NULL

Line 465: ,l_xla_conditions.user_sequence

461: ,independent_value_constant
462: )
463: VALUES
464: (l_xla_conditions.condition_id
465: ,l_xla_conditions.user_sequence
466: ,l_xla_conditions.application_id
467: ,l_xla_conditions.amb_context_code
468: ,NULL
469: ,NULL

Line 466: ,l_xla_conditions.application_id

462: )
463: VALUES
464: (l_xla_conditions.condition_id
465: ,l_xla_conditions.user_sequence
466: ,l_xla_conditions.application_id
467: ,l_xla_conditions.amb_context_code
468: ,NULL
469: ,NULL
470: ,NULL

Line 467: ,l_xla_conditions.amb_context_code

463: VALUES
464: (l_xla_conditions.condition_id
465: ,l_xla_conditions.user_sequence
466: ,l_xla_conditions.application_id
467: ,l_xla_conditions.amb_context_code
468: ,NULL
469: ,NULL
470: ,NULL
471: ,NULL

Line 472: ,l_xla_conditions.segment_rule_detail_id

468: ,NULL
469: ,NULL
470: ,NULL
471: ,NULL
472: ,l_xla_conditions.segment_rule_detail_id
473: ,NULL
474: ,l_xla_conditions.bracket_left_code
475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code

Line 474: ,l_xla_conditions.bracket_left_code

470: ,NULL
471: ,NULL
472: ,l_xla_conditions.segment_rule_detail_id
473: ,NULL
474: ,l_xla_conditions.bracket_left_code
475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code

Line 475: ,l_xla_conditions.bracket_right_code

471: ,NULL
472: ,l_xla_conditions.segment_rule_detail_id
473: ,NULL
474: ,l_xla_conditions.bracket_left_code
475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code

Line 476: ,l_xla_conditions.value_type_code

472: ,l_xla_conditions.segment_rule_detail_id
473: ,NULL
474: ,l_xla_conditions.bracket_left_code
475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code

Line 477: ,l_xla_conditions.source_application_id

473: ,NULL
474: ,l_xla_conditions.bracket_left_code
475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code

Line 478: ,l_xla_conditions.source_type_code

474: ,l_xla_conditions.bracket_left_code
475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id

Line 479: ,l_xla_conditions.source_code

475: ,l_xla_conditions.bracket_right_code
476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code

Line 480: ,l_xla_conditions.flexfield_segment_code

476: ,l_xla_conditions.value_type_code
477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code

Line 481: ,l_xla_conditions.value_flexfield_segment_code

477: ,l_xla_conditions.source_application_id
478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant

Line 482: ,l_xla_conditions.value_source_application_id

478: ,l_xla_conditions.source_type_code
479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant
486: ,l_xla_conditions.line_operator_code

Line 483: ,l_xla_conditions.value_source_type_code

479: ,l_xla_conditions.source_code
480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant
486: ,l_xla_conditions.line_operator_code
487: ,l_xla_conditions.logical_operator_code

Line 484: ,l_xla_conditions.value_source_code

480: ,l_xla_conditions.flexfield_segment_code
481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant
486: ,l_xla_conditions.line_operator_code
487: ,l_xla_conditions.logical_operator_code
488: ,l_date

Line 485: ,l_xla_conditions.value_constant

481: ,l_xla_conditions.value_flexfield_segment_code
482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant
486: ,l_xla_conditions.line_operator_code
487: ,l_xla_conditions.logical_operator_code
488: ,l_date
489: ,l_user_id

Line 486: ,l_xla_conditions.line_operator_code

482: ,l_xla_conditions.value_source_application_id
483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant
486: ,l_xla_conditions.line_operator_code
487: ,l_xla_conditions.logical_operator_code
488: ,l_date
489: ,l_user_id
490: ,l_date

Line 487: ,l_xla_conditions.logical_operator_code

483: ,l_xla_conditions.value_source_type_code
484: ,l_xla_conditions.value_source_code
485: ,l_xla_conditions.value_constant
486: ,l_xla_conditions.line_operator_code
487: ,l_xla_conditions.logical_operator_code
488: ,l_date
489: ,l_user_id
490: ,l_date
491: ,l_user_id

Line 493: ,l_xla_conditions.independent_value_constant

489: ,l_user_id
490: ,l_date
491: ,l_user_id
492: ,l_login_id
493: ,l_xla_conditions.independent_value_constant
494: );
495: -- Mark the row in the interface table as been processed
496: UPDATE xla_conditions_t
497: SET error_value = 1 -- The row has been processed with no error

Line 496: UPDATE xla_conditions_t

492: ,l_login_id
493: ,l_xla_conditions.independent_value_constant
494: );
495: -- Mark the row in the interface table as been processed
496: UPDATE xla_conditions_t
497: SET error_value = 1 -- The row has been processed with no error
498: WHERE CURRENT OF c_xla_conditions_t;
499: EXCEPTION
500: WHEN OTHERS THEN

Line 498: WHERE CURRENT OF c_xla_conditions_t;

494: );
495: -- Mark the row in the interface table as been processed
496: UPDATE xla_conditions_t
497: SET error_value = 1 -- The row has been processed with no error
498: WHERE CURRENT OF c_xla_conditions_t;
499: EXCEPTION
500: WHEN OTHERS THEN
501: l_error_code := SQLCODE;
502: UPDATE xla_conditions_t

Line 502: UPDATE xla_conditions_t

498: WHERE CURRENT OF c_xla_conditions_t;
499: EXCEPTION
500: WHEN OTHERS THEN
501: l_error_code := SQLCODE;
502: UPDATE xla_conditions_t
503: SET error_value = l_error_code -- The row has been processed with errors
504: WHERE CURRENT OF c_xla_conditions_t;
505: END; -- Block ends
506: END LOOP;

Line 504: WHERE CURRENT OF c_xla_conditions_t;

500: WHEN OTHERS THEN
501: l_error_code := SQLCODE;
502: UPDATE xla_conditions_t
503: SET error_value = l_error_code -- The row has been processed with errors
504: WHERE CURRENT OF c_xla_conditions_t;
505: END; -- Block ends
506: END LOOP;
507: CLOSE c_xla_conditions_t;
508:

Line 507: CLOSE c_xla_conditions_t;

503: SET error_value = l_error_code -- The row has been processed with errors
504: WHERE CURRENT OF c_xla_conditions_t;
505: END; -- Block ends
506: END LOOP;
507: CLOSE c_xla_conditions_t;
508:
509: OPEN c_xla_line_assgns_t;
510: LOOP
511: FETCH c_xla_line_assgns_t INTO l_xla_line_assgns;