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: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t

103: FROM xla_rule_details_t
104: WHERE error_value = 0
105: FOR UPDATE of error_value;
106:
107: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t
108: SELECT *
109: FROM xla_conditions_t
110: WHERE error_value = 0
111: FOR UPDATE of error_value;

Line 109: FROM xla_conditions_t

105: FOR UPDATE of error_value;
106:
107: CURSOR c_xla_conditions_t IS -- cursor for xla_conditions_t
108: SELECT *
109: FROM xla_conditions_t
110: WHERE error_value = 0
111: FOR UPDATE of error_value;
112:
113: CURSOR c_xla_line_assgns_t IS -- cursor for xla_line_assgns_t

Line 126: l_xla_conditions c_xla_conditions_t%ROWTYPE;

122: WHERE installed_flag = 'I';
123:
124: l_xla_rules c_xla_rules_t%ROWTYPE;
125: l_xla_rule_details c_xla_rule_details_t%ROWTYPE;
126: l_xla_conditions c_xla_conditions_t%ROWTYPE;
127: l_xla_line_assgns c_xla_line_assgns_t%ROWTYPE;
128: l_base_language VARCHAR2(4);
129: l_installed_language t_array_vl4;
130: l_user_id INTEGER;

Line 384: OPEN c_xla_conditions_t;

380: END; -- Block ends
381: END LOOP;
382: CLOSE c_xla_rule_details_t;
383:
384: OPEN c_xla_conditions_t;
385: LOOP
386: FETCH c_xla_conditions_t INTO l_xla_conditions;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:

Line 386: FETCH c_xla_conditions_t INTO l_xla_conditions;

382: CLOSE c_xla_rule_details_t;
383:
384: OPEN c_xla_conditions_t;
385: LOOP
386: FETCH c_xla_conditions_t INTO l_xla_conditions;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:
389: BEGIN -- Block begins
390: -- Insert data into xla_conditions

Line 387: EXIT WHEN c_xla_conditions_t%NOTFOUND;

383:
384: OPEN c_xla_conditions_t;
385: LOOP
386: FETCH c_xla_conditions_t INTO l_xla_conditions;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:
389: BEGIN -- Block begins
390: -- Insert data into xla_conditions
391: INSERT INTO xla_conditions

Line 390: -- Insert data into xla_conditions

386: FETCH c_xla_conditions_t INTO l_xla_conditions;
387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:
389: BEGIN -- Block begins
390: -- Insert data into xla_conditions
391: INSERT INTO xla_conditions
392: (condition_id
393: ,user_sequence
394: ,application_id

Line 391: INSERT INTO xla_conditions

387: EXIT WHEN c_xla_conditions_t%NOTFOUND;
388:
389: BEGIN -- Block begins
390: -- Insert data into xla_conditions
391: INSERT INTO xla_conditions
392: (condition_id
393: ,user_sequence
394: ,application_id
395: ,amb_context_code

Line 424: (l_xla_conditions.condition_id

420: ,last_update_login
421: ,independent_value_constant
422: )
423: VALUES
424: (l_xla_conditions.condition_id
425: ,l_xla_conditions.user_sequence
426: ,l_xla_conditions.application_id
427: ,l_xla_conditions.amb_context_code
428: ,NULL

Line 425: ,l_xla_conditions.user_sequence

421: ,independent_value_constant
422: )
423: VALUES
424: (l_xla_conditions.condition_id
425: ,l_xla_conditions.user_sequence
426: ,l_xla_conditions.application_id
427: ,l_xla_conditions.amb_context_code
428: ,NULL
429: ,NULL

Line 426: ,l_xla_conditions.application_id

422: )
423: VALUES
424: (l_xla_conditions.condition_id
425: ,l_xla_conditions.user_sequence
426: ,l_xla_conditions.application_id
427: ,l_xla_conditions.amb_context_code
428: ,NULL
429: ,NULL
430: ,NULL

Line 427: ,l_xla_conditions.amb_context_code

423: VALUES
424: (l_xla_conditions.condition_id
425: ,l_xla_conditions.user_sequence
426: ,l_xla_conditions.application_id
427: ,l_xla_conditions.amb_context_code
428: ,NULL
429: ,NULL
430: ,NULL
431: ,NULL

Line 432: ,l_xla_conditions.segment_rule_detail_id

428: ,NULL
429: ,NULL
430: ,NULL
431: ,NULL
432: ,l_xla_conditions.segment_rule_detail_id
433: ,NULL
434: ,l_xla_conditions.bracket_left_code
435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code

Line 434: ,l_xla_conditions.bracket_left_code

430: ,NULL
431: ,NULL
432: ,l_xla_conditions.segment_rule_detail_id
433: ,NULL
434: ,l_xla_conditions.bracket_left_code
435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code

Line 435: ,l_xla_conditions.bracket_right_code

431: ,NULL
432: ,l_xla_conditions.segment_rule_detail_id
433: ,NULL
434: ,l_xla_conditions.bracket_left_code
435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code

Line 436: ,l_xla_conditions.value_type_code

432: ,l_xla_conditions.segment_rule_detail_id
433: ,NULL
434: ,l_xla_conditions.bracket_left_code
435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code

Line 437: ,l_xla_conditions.source_application_id

433: ,NULL
434: ,l_xla_conditions.bracket_left_code
435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code

Line 438: ,l_xla_conditions.source_type_code

434: ,l_xla_conditions.bracket_left_code
435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id

Line 439: ,l_xla_conditions.source_code

435: ,l_xla_conditions.bracket_right_code
436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code

Line 440: ,l_xla_conditions.flexfield_segment_code

436: ,l_xla_conditions.value_type_code
437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code

Line 441: ,l_xla_conditions.value_flexfield_segment_code

437: ,l_xla_conditions.source_application_id
438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant

Line 442: ,l_xla_conditions.value_source_application_id

438: ,l_xla_conditions.source_type_code
439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant
446: ,l_xla_conditions.line_operator_code

Line 443: ,l_xla_conditions.value_source_type_code

439: ,l_xla_conditions.source_code
440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant
446: ,l_xla_conditions.line_operator_code
447: ,l_xla_conditions.logical_operator_code

Line 444: ,l_xla_conditions.value_source_code

440: ,l_xla_conditions.flexfield_segment_code
441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant
446: ,l_xla_conditions.line_operator_code
447: ,l_xla_conditions.logical_operator_code
448: ,l_date

Line 445: ,l_xla_conditions.value_constant

441: ,l_xla_conditions.value_flexfield_segment_code
442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant
446: ,l_xla_conditions.line_operator_code
447: ,l_xla_conditions.logical_operator_code
448: ,l_date
449: ,l_user_id

Line 446: ,l_xla_conditions.line_operator_code

442: ,l_xla_conditions.value_source_application_id
443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant
446: ,l_xla_conditions.line_operator_code
447: ,l_xla_conditions.logical_operator_code
448: ,l_date
449: ,l_user_id
450: ,l_date

Line 447: ,l_xla_conditions.logical_operator_code

443: ,l_xla_conditions.value_source_type_code
444: ,l_xla_conditions.value_source_code
445: ,l_xla_conditions.value_constant
446: ,l_xla_conditions.line_operator_code
447: ,l_xla_conditions.logical_operator_code
448: ,l_date
449: ,l_user_id
450: ,l_date
451: ,l_user_id

Line 453: ,l_xla_conditions.independent_value_constant

449: ,l_user_id
450: ,l_date
451: ,l_user_id
452: ,l_login_id
453: ,l_xla_conditions.independent_value_constant
454: );
455: -- Mark the row in the interface table as been processed
456: UPDATE xla_conditions_t
457: SET error_value = 1 -- The row has been processed with no error

Line 456: UPDATE xla_conditions_t

452: ,l_login_id
453: ,l_xla_conditions.independent_value_constant
454: );
455: -- Mark the row in the interface table as been processed
456: UPDATE xla_conditions_t
457: SET error_value = 1 -- The row has been processed with no error
458: WHERE CURRENT OF c_xla_conditions_t;
459: EXCEPTION
460: WHEN OTHERS THEN

Line 458: WHERE CURRENT OF c_xla_conditions_t;

454: );
455: -- Mark the row in the interface table as been processed
456: UPDATE xla_conditions_t
457: SET error_value = 1 -- The row has been processed with no error
458: WHERE CURRENT OF c_xla_conditions_t;
459: EXCEPTION
460: WHEN OTHERS THEN
461: l_error_code := SQLCODE;
462: UPDATE xla_conditions_t

Line 462: UPDATE xla_conditions_t

458: WHERE CURRENT OF c_xla_conditions_t;
459: EXCEPTION
460: WHEN OTHERS THEN
461: l_error_code := SQLCODE;
462: UPDATE xla_conditions_t
463: SET error_value = l_error_code -- The row has been processed with errors
464: WHERE CURRENT OF c_xla_conditions_t;
465: END; -- Block ends
466: END LOOP;

Line 464: WHERE CURRENT OF c_xla_conditions_t;

460: WHEN OTHERS THEN
461: l_error_code := SQLCODE;
462: UPDATE xla_conditions_t
463: SET error_value = l_error_code -- The row has been processed with errors
464: WHERE CURRENT OF c_xla_conditions_t;
465: END; -- Block ends
466: END LOOP;
467: CLOSE c_xla_conditions_t;
468:

Line 467: CLOSE c_xla_conditions_t;

463: SET error_value = l_error_code -- The row has been processed with errors
464: WHERE CURRENT OF c_xla_conditions_t;
465: END; -- Block ends
466: END LOOP;
467: CLOSE c_xla_conditions_t;
468:
469: OPEN c_xla_line_assgns_t;
470: LOOP
471: FETCH c_xla_line_assgns_t INTO l_xla_line_assgns;