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_JLT_ASSGNS

Line 630: DELETE FROM xla_line_defn_jlt_assgns w

626: p_module => l_log_module,
627: p_level => C_LEVEL_STATEMENT);
628: END IF;
629:
630: DELETE FROM xla_line_defn_jlt_assgns w
631: WHERE application_id = g_application_id
632: AND amb_context_code = g_amb_context_code
633: AND line_definition_owner_code = C_OWNER_SYSTEM
634: AND NOT EXISTS

Line 636: FROM xla_line_defn_jlt_assgns s

632: AND amb_context_code = g_amb_context_code
633: AND line_definition_owner_code = C_OWNER_SYSTEM
634: AND NOT EXISTS
635: (SELECT 1
636: FROM xla_line_defn_jlt_assgns s
637: WHERE s.application_id = g_application_id
638: AND s.amb_context_code = g_staging_context_code
639: AND s.event_class_code = w.event_class_code
640: AND s.event_type_code = w.event_type_code

Line 647: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,

643: AND s.accounting_line_type_code = w.accounting_line_type_code
644: AND s.accounting_line_code = w.accounting_line_code);
645:
646: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
647: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,
648: p_module => l_log_module,
649: p_level => C_LEVEL_STATEMENT);
650: END IF;
651:

Line 930: DELETE FROM xla_line_defn_jlt_assgns w

926: p_level => C_LEVEL_STATEMENT);
927: END IF;
928:
929: FORALL i IN 1..l_codes.COUNT
930: DELETE FROM xla_line_defn_jlt_assgns w
931: WHERE application_id = g_application_id
932: AND amb_context_code = g_amb_context_code
933: AND event_class_code = l_event_class_codes(i)
934: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 938: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,

934: AND accounting_line_type_code = C_OWNER_SYSTEM
935: AND accounting_line_code = l_codes(i);
936:
937: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
938: trace(p_msg => '# xla_line_defn_jlt_assgns deleted = '||SQL%ROWCOUNT,
939: p_module => l_log_module,
940: p_level => C_LEVEL_STATEMENT);
941: END IF;
942:

Line 1059: UPDATE xla_line_defn_jlt_assgns

1055: END IF;
1056:
1057: IF (l_codes.COUNT > 0) THEN
1058: FORALL i IN 1..l_codes.COUNT
1059: UPDATE xla_line_defn_jlt_assgns
1060: SET description_type_code = NULL
1061: , description_code = NULL
1062: WHERE application_id = g_application_id
1063: AND amb_context_code = g_amb_context_code

Line 1068: trace(p_msg => '# xla_line_defn_jlt_assgns clear description = '||SQL%ROWCOUNT,

1064: AND description_type_code = C_OWNER_SYSTEM
1065: AND description_code = l_codes(i);
1066:
1067: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1068: trace(p_msg => '# xla_line_defn_jlt_assgns clear description = '||SQL%ROWCOUNT,
1069: p_module => l_log_module,
1070: p_level => C_LEVEL_STATEMENT);
1071: END IF;
1072:

Line 2013: DELETE FROM xla_line_defn_jlt_assgns w

2009: p_module => l_log_module,
2010: p_level => C_LEVEL_STATEMENT);
2011: END IF;
2012:
2013: DELETE FROM xla_line_defn_jlt_assgns w
2014: WHERE application_id = g_application_id
2015: AND amb_context_code = g_amb_context_code
2016: AND EXISTS (SELECT 1
2017: FROM xla_line_defn_jlt_assgns s

Line 2017: FROM xla_line_defn_jlt_assgns s

2013: DELETE FROM xla_line_defn_jlt_assgns w
2014: WHERE application_id = g_application_id
2015: AND amb_context_code = g_amb_context_code
2016: AND EXISTS (SELECT 1
2017: FROM xla_line_defn_jlt_assgns s
2018: WHERE s.application_id = g_application_id
2019: AND s.amb_context_code = g_staging_context_code
2020: AND s.event_class_code = w.event_class_code
2021: AND s.event_type_code = w.event_type_code

Line 2028: trace(p_msg => '# xla_line_defn_jlt_assgns deleted : '||SQL%ROWCOUNT,

2024: AND s.accounting_line_type_code = w.accounting_line_type_code
2025: AND s.accounting_line_code = w.accounting_line_code);
2026:
2027: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2028: trace(p_msg => '# xla_line_defn_jlt_assgns deleted : '||SQL%ROWCOUNT,
2029: p_module => l_log_module,
2030: p_level => C_LEVEL_STATEMENT);
2031: END IF;
2032:

Line 2039: FROM xla_line_defn_jlt_assgns s

2035: DELETE FROM xla_line_defn_adr_assgns w
2036: WHERE application_id = g_application_id
2037: AND amb_context_code = g_amb_context_code
2038: AND EXISTS (SELECT 1
2039: FROM xla_line_defn_jlt_assgns s
2040: WHERE s.application_id = g_application_id
2041: AND s.amb_context_code = g_staging_context_code
2042: AND s.event_class_code = w.event_class_code
2043: AND s.event_type_code = w.event_type_code

Line 2252: UPDATE xla_line_defn_jlt_assgns

2248: p_module => l_log_module,
2249: p_level => C_LEVEL_STATEMENT);
2250: END IF;
2251:
2252: UPDATE xla_line_defn_jlt_assgns
2253: SET amb_context_code = g_amb_context_code
2254: WHERE application_id = g_application_id
2255: AND amb_context_code = g_staging_context_code;
2256:

Line 2258: trace(p_msg => '# xla_line_defn_jlt_assgns updated : '||SQL%ROWCOUNT,

2254: WHERE application_id = g_application_id
2255: AND amb_context_code = g_staging_context_code;
2256:
2257: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2258: trace(p_msg => '# xla_line_defn_jlt_assgns updated : '||SQL%ROWCOUNT,
2259: p_module => l_log_module,
2260: p_level => C_LEVEL_STATEMENT);
2261: END IF;
2262: