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_AAD_MERGE_PVT dependencies on XLA_LINE_DEFINITIONS_TL

Line 882: DELETE FROM xla_line_definitions_tl w

878: p_log_type_code => 'MERGE',
879: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,
880: p_component_code => 'clean_oracle_jlds');
881: FORALL i IN 1..l_codes.COUNT
882: DELETE FROM xla_line_definitions_tl w
883: WHERE application_id = g_application_id
884: AND amb_context_code = g_amb_context_code
885: AND event_class_code = l_event_class_codes(i)
886: AND event_type_code = l_event_type_codes(i)

Line 891: trace(p_msg => '# xla_line_definitions_tl deleted = '||l_num_rows,

887: AND line_definition_owner_code = C_OWNER_SYSTEM
888: AND line_definition_code = l_codes(i);
889: l_num_rows:= SQL%ROWCOUNT;
890: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
891: trace(p_msg => '# xla_line_definitions_tl deleted = '||l_num_rows,
892: p_module => l_log_module,
893: p_level => C_LEVEL_STATEMENT);
894: END IF;
895: -- Bug : 9923803

Line 902: p_encoded_message => '# xla_line_definitions_tl deleted = '||l_num_rows,

898: p_amb_context_code => g_amb_context_code,
899: p_application_id => g_application_id,
900: p_request_code => 'IMPORT' ,
901: p_log_type_code => 'MERGE',
902: p_encoded_message => '# xla_line_definitions_tl deleted = '||l_num_rows,
903: p_component_code => 'clean_oracle_jlds');
904:
905: FORALL i IN 1..l_codes.COUNT
906: DELETE FROM xla_line_definitions_b w

Line 3339: DELETE FROM xla_line_definitions_tl w

3335: p_log_type_code => 'MERGE',
3336: p_encoded_message =>'# xla_line_definitions_b deleted : '||l_num_rows,
3337: p_component_code => 'merge_journal_line_defns');
3338:
3339: DELETE FROM xla_line_definitions_tl w
3340: WHERE application_id = g_application_id
3341: AND amb_context_code = g_amb_context_code
3342: AND EXISTS (SELECT 1
3343: FROM xla_line_definitions_tl s

Line 3343: FROM xla_line_definitions_tl s

3339: DELETE FROM xla_line_definitions_tl w
3340: WHERE application_id = g_application_id
3341: AND amb_context_code = g_amb_context_code
3342: AND EXISTS (SELECT 1
3343: FROM xla_line_definitions_tl s
3344: WHERE s.application_id = g_application_id
3345: AND s.amb_context_code = g_staging_context_code
3346: AND s.event_class_code = w.event_class_code
3347: AND s.event_type_code = w.event_type_code

Line 3353: trace(p_msg => '# xla_line_definitions_tl deleted : '||l_num_rows,

3349: AND s.line_definition_code = w.line_definition_code
3350: AND s.language = w.language);
3351: l_num_rows := SQL%ROWCOUNT;
3352: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3353: trace(p_msg => '# xla_line_definitions_tl deleted : '||l_num_rows,
3354: p_module => l_log_module,
3355: p_level => C_LEVEL_STATEMENT);
3356: END IF;
3357: -- Bug : 9923803

Line 3364: p_encoded_message =>'# xla_line_definitions_tl deleted : '||l_num_rows,

3360: p_amb_context_code => g_amb_context_code,
3361: p_application_id => g_application_id,
3362: p_request_code => 'IMPORT' ,
3363: p_log_type_code => 'MERGE',
3364: p_encoded_message =>'# xla_line_definitions_tl deleted : '||l_num_rows,
3365: p_component_code => 'merge_journal_line_defns');
3366:
3367: DELETE FROM xla_line_defn_jlt_assgns w
3368: WHERE application_id = g_application_id

Line 3641: UPDATE xla_line_definitions_tl w

3637: p_log_type_code => 'MERGE',
3638: p_encoded_message => '# xla_line_definitions_b updated : '||l_num_rows,
3639: p_component_code => 'merge_journal_line_defns');
3640:
3641: UPDATE xla_line_definitions_tl w
3642: SET amb_context_code = g_amb_context_code
3643: WHERE application_id = g_application_id
3644: AND amb_context_code = g_staging_context_code
3645: AND NOT EXISTS (SELECT 1

Line 3646: FROM xla_line_definitions_tl s

3642: SET amb_context_code = g_amb_context_code
3643: WHERE application_id = g_application_id
3644: AND amb_context_code = g_staging_context_code
3645: AND NOT EXISTS (SELECT 1
3646: FROM xla_line_definitions_tl s
3647: WHERE s.application_id = g_application_id
3648: AND s.amb_context_code = g_amb_context_code
3649: AND s.event_class_code = w.event_class_code
3650: AND s.event_type_code = w.event_type_code

Line 3656: trace(p_msg => '# xla_line_definitions_tl 1 updated : '||l_num_rows,

3652: AND s.name = w.name
3653: AND s.language = w.language);
3654: l_num_rows := SQL%ROWCOUNT;
3655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3656: trace(p_msg => '# xla_line_definitions_tl 1 updated : '||l_num_rows,
3657: p_module => l_log_module,
3658: p_level => C_LEVEL_STATEMENT);
3659: END IF;
3660: -- Bug : 9923803

Line 3667: p_encoded_message => '# xla_line_definitions_tl 1 updated : '||l_num_rows,

3663: p_amb_context_code => g_amb_context_code,
3664: p_application_id => g_application_id,
3665: p_request_code => 'IMPORT' ,
3666: p_log_type_code => 'MERGE',
3667: p_encoded_message => '# xla_line_definitions_tl 1 updated : '||l_num_rows,
3668: p_component_code => 'merge_journal_line_defns');
3669:
3670: UPDATE xla_line_definitions_tl w
3671: SET amb_context_code = g_amb_context_code

Line 3670: UPDATE xla_line_definitions_tl w

3666: p_log_type_code => 'MERGE',
3667: p_encoded_message => '# xla_line_definitions_tl 1 updated : '||l_num_rows,
3668: p_component_code => 'merge_journal_line_defns');
3669:
3670: UPDATE xla_line_definitions_tl w
3671: SET amb_context_code = g_amb_context_code
3672: , name = substr('('||line_definition_code||') '||name,1,80)
3673: WHERE application_id = g_application_id
3674: AND amb_context_code = g_staging_context_code

Line 3676: FROM xla_line_definitions_tl s

3672: , name = substr('('||line_definition_code||') '||name,1,80)
3673: WHERE application_id = g_application_id
3674: AND amb_context_code = g_staging_context_code
3675: AND EXISTS (SELECT 1
3676: FROM xla_line_definitions_tl s
3677: WHERE s.application_id = g_application_id
3678: AND s.amb_context_code = g_amb_context_code
3679: AND s.event_class_code = w.event_class_code
3680: AND s.event_type_code = w.event_type_code

Line 3686: trace(p_msg => '# xla_line_definitions_tl 2 updated : '||l_num_rows,

3682: AND s.name = w.name
3683: AND s.language = w.language);
3684: l_num_rows := SQL%ROWCOUNT;
3685: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3686: trace(p_msg => '# xla_line_definitions_tl 2 updated : '||l_num_rows,
3687: p_module => l_log_module,
3688: p_level => C_LEVEL_STATEMENT);
3689: END IF;
3690: -- Bug : 9923803

Line 3697: p_encoded_message => '# xla_line_definitions_tl 2 updated : '||l_num_rows,

3693: p_amb_context_code => g_amb_context_code,
3694: p_application_id => g_application_id,
3695: p_request_code => 'IMPORT' ,
3696: p_log_type_code => 'MERGE',
3697: p_encoded_message => '# xla_line_definitions_tl 2 updated : '||l_num_rows,
3698: p_component_code => 'merge_journal_line_defns');
3699:
3700: UPDATE xla_line_defn_jlt_assgns
3701: SET amb_context_code = g_amb_context_code