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_DEFN_AC_ASSGNS

Line 653: DELETE FROM xla_line_defn_ac_assgns w

649: p_log_type_code => 'MERGE',
650: p_encoded_message => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,
651: p_component_code => 'clean_oracle_jlds');
652:
653: DELETE FROM xla_line_defn_ac_assgns w
654: WHERE application_id = g_application_id
655: AND amb_context_code = g_amb_context_code
656: AND line_definition_owner_code = C_OWNER_SYSTEM
657: AND NOT EXISTS

Line 659: FROM xla_line_defn_ac_assgns s

655: AND amb_context_code = g_amb_context_code
656: AND line_definition_owner_code = C_OWNER_SYSTEM
657: AND NOT EXISTS
658: (SELECT 1
659: FROM xla_line_defn_ac_assgns s
660: WHERE s.application_id = g_application_id
661: AND s.amb_context_code = g_staging_context_code
662: AND s.event_class_code = w.event_class_code
663: AND s.event_type_code = w.event_type_code

Line 672: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,

668: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
669: AND s.analytical_criterion_code = w.analytical_criterion_code);
670: l_num_rows := SQL%ROWCOUNT;
671: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
672: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,
673: p_module => l_log_module,
674: p_level => C_LEVEL_STATEMENT);
675: END IF;
676: -- Bug : 9923803

Line 683: p_encoded_message => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,

679: p_amb_context_code => g_amb_context_code,
680: p_application_id => g_application_id,
681: p_request_code => 'IMPORT' ,
682: p_log_type_code => 'MERGE',
683: p_encoded_message => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,
684: p_component_code => 'clean_oracle_jlds');
685:
686: DELETE FROM xla_line_defn_adr_assgns w
687: WHERE application_id = g_application_id

Line 1107: DELETE FROM xla_line_defn_ac_assgns w

1103: p_log_type_code => 'MERGE',
1104: p_encoded_message => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
1105: p_component_code => 'clean_oracle_jlts');
1106: FORALL i IN 1..l_codes.COUNT
1107: DELETE FROM xla_line_defn_ac_assgns w
1108: WHERE application_id = g_application_id
1109: AND amb_context_code = g_amb_context_code
1110: AND event_class_code = l_event_class_codes(i)
1111: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1115: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,

1111: AND accounting_line_type_code = C_OWNER_SYSTEM
1112: AND accounting_line_code = l_codes(i);
1113: l_num_rows := SQL%ROWCOUNT;
1114: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1115: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,
1116: p_module => l_log_module,
1117: p_level => C_LEVEL_STATEMENT);
1118: END IF;
1119: -- Bug : 9923803

Line 1126: p_encoded_message => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,

1122: p_amb_context_code => g_amb_context_code,
1123: p_application_id => g_application_id,
1124: p_request_code => 'IMPORT' ,
1125: p_log_type_code => 'MERGE',
1126: p_encoded_message => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,
1127: p_component_code => 'clean_oracle_jlts');
1128:
1129: FORALL i IN 1..l_codes.COUNT
1130: DELETE FROM xla_line_defn_jlt_assgns w

Line 1843: DELETE FROM xla_line_defn_ac_assgns w

1839: p_level => C_LEVEL_STATEMENT);
1840: END IF;
1841:
1842: FORALL i IN 1..l_codes.COUNT
1843: DELETE FROM xla_line_defn_ac_assgns w
1844: WHERE amb_context_code = g_amb_context_code
1845: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1846: AND analytical_criterion_code = l_codes(i);
1847:

Line 1849: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,

1845: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1846: AND analytical_criterion_code = l_codes(i);
1847:
1848: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1849: trace(p_msg => '# xla_line_defn_ac_assgns deleted = '||SQL%ROWCOUNT,
1850: p_module => l_log_module,
1851: p_level => C_LEVEL_STATEMENT);
1852: END IF;
1853:

Line 2924: 'XLA_LINE_DEFN_AC_ASSGNS'

2920: event_type_code,
2921: line_definition_code,
2922: accounting_line_code,
2923: analytical_criterion_code,
2924: 'XLA_LINE_DEFN_AC_ASSGNS'
2925: from
2926: (select event_class_code,
2927: event_type_code,
2928: line_definition_code,

Line 2931: 'XLA_LINE_DEFN_AC_ASSGNS',

2927: event_type_code,
2928: line_definition_code,
2929: accounting_line_code,
2930: analytical_criterion_code,
2931: 'XLA_LINE_DEFN_AC_ASSGNS',
2932: amb_context_code,
2933: last_update_date ,
2934: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2935: from

Line 2941: 'XLA_LINE_DEFN_AC_ASSGNS',

2937: event_type_code,
2938: line_definition_code,
2939: accounting_line_code,
2940: analytical_criterion_code,
2941: 'XLA_LINE_DEFN_AC_ASSGNS',
2942: amb_context_code,
2943: last_update_date ,
2944: lag(last_update_date) over (PARTITION by application_id,
2945: event_class_code,

Line 2955: from XLA_LINE_DEFN_AC_ASSGNS

2951: analytical_criterion_code,
2952: analytical_criterion_type_code
2953: order by amb_context_code
2954: ) lag_date
2955: from XLA_LINE_DEFN_AC_ASSGNS
2956: order by amb_context_code
2957: ) x
2958: where x.amb_context_code = g_staging_context_code
2959: )

Line 2964: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_line_defn_ac_assgns is :'||l_num_rows,

2960: where flag = 'False';
2961: l_num_rows := SQL%ROWCOUNT;
2962:
2963: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2964: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_line_defn_ac_assgns is :'||l_num_rows,
2965: p_module => l_log_module,
2966: p_level => C_LEVEL_PROCEDURE);
2967: END IF;
2968: -- Bug : 9923803

Line 2975: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_ac_assgns is :'||l_num_rows,

2971: p_amb_context_code => g_amb_context_code,
2972: p_application_id => g_application_id,
2973: p_request_code => 'IMPORT' ,
2974: p_log_type_code => 'MERGE',
2975: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_ac_assgns is :'||l_num_rows,
2976: p_component_code => 'merge_journal_line_defns');
2977:
2978: INSERT INTO xla_aads_gt
2979: ( event_class_code

Line 3430: DELETE FROM xla_line_defn_ac_assgns w

3426: p_log_type_code => 'MERGE',
3427: p_encoded_message =>'# xla_line_defn_adr_assgns deleted : '||l_num_rows,
3428: p_component_code => 'merge_journal_line_defns');
3429:
3430: DELETE FROM xla_line_defn_ac_assgns w
3431: WHERE application_id = g_application_id
3432: AND amb_context_code = g_amb_context_code
3433: AND EXISTS (SELECT 1
3434: FROM xla_line_defn_ac_assgns s

Line 3434: FROM xla_line_defn_ac_assgns s

3430: DELETE FROM xla_line_defn_ac_assgns w
3431: WHERE application_id = g_application_id
3432: AND amb_context_code = g_amb_context_code
3433: AND EXISTS (SELECT 1
3434: FROM xla_line_defn_ac_assgns s
3435: WHERE s.application_id = g_application_id
3436: AND s.amb_context_code = g_staging_context_code
3437: AND s.event_class_code = w.event_class_code
3438: AND s.event_type_code = w.event_type_code

Line 3447: trace(p_msg => '# xla_line_defn_ac_assgns deleted : '||l_num_rows,

3443: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
3444: AND s.analytical_criterion_code = w.analytical_criterion_code);
3445: l_num_rows := SQL%ROWCOUNT;
3446: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3447: trace(p_msg => '# xla_line_defn_ac_assgns deleted : '||l_num_rows,
3448: p_module => l_log_module,
3449: p_level => C_LEVEL_STATEMENT);
3450: END IF;
3451: -- Bug : 9923803

Line 3458: p_encoded_message =>'# xla_line_defn_ac_assgns deleted : '||l_num_rows,

3454: p_amb_context_code => g_amb_context_code,
3455: p_application_id => g_application_id,
3456: p_request_code => 'IMPORT' ,
3457: p_log_type_code => 'MERGE',
3458: p_encoded_message =>'# xla_line_defn_ac_assgns deleted : '||l_num_rows,
3459: p_component_code => 'merge_journal_line_defns');
3460:
3461: -- bug8635648 MPA JLT's deleted even when no data for JLT's in Staging Table
3462: DELETE FROM xla_mpa_jlt_assgns w

Line 3740: UPDATE xla_line_defn_ac_assgns

3736: p_log_type_code => 'MERGE',
3737: p_encoded_message => '# xla_line_defn_adr_assgns updated : '||l_num_rows,
3738: p_component_code => 'merge_journal_line_defns');
3739:
3740: UPDATE xla_line_defn_ac_assgns
3741: SET amb_context_code = g_amb_context_code
3742: WHERE application_id = g_application_id
3743: AND amb_context_code = g_staging_context_code;
3744: l_num_rows := SQL%ROWCOUNT;

Line 3746: trace(p_msg => '# xla_line_defn_ac_assgns updated : '||l_num_rows,

3742: WHERE application_id = g_application_id
3743: AND amb_context_code = g_staging_context_code;
3744: l_num_rows := SQL%ROWCOUNT;
3745: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3746: trace(p_msg => '# xla_line_defn_ac_assgns updated : '||l_num_rows,
3747: p_module => l_log_module,
3748: p_level => C_LEVEL_STATEMENT);
3749: END IF;
3750: -- Bug : 9923803

Line 3757: p_encoded_message => '# xla_line_defn_ac_assgns updated : '||l_num_rows,

3753: p_amb_context_code => g_amb_context_code,
3754: p_application_id => g_application_id,
3755: p_request_code => 'IMPORT' ,
3756: p_log_type_code => 'MERGE',
3757: p_encoded_message => '# xla_line_defn_ac_assgns updated : '||l_num_rows,
3758: p_component_code => 'merge_journal_line_defns');
3759:
3760: UPDATE xla_mpa_jlt_assgns
3761: SET amb_context_code = g_amb_context_code