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_LINE_TYPES_PKG dependencies on XLA_JLT_ACCT_ATTRS

Line 109: FROM xla_jlt_acct_attrs

105: ,p_accounting_line_type_code => l_accounting_line_type_code
106: ,p_accounting_line_code => l_accounting_line_code);
107:
108: DELETE
109: FROM xla_jlt_acct_attrs
110: WHERE application_id = p_application_id
111: AND amb_context_code = p_amb_context_code
112: AND event_class_code = p_event_class_code
113: AND accounting_line_type_code = p_accounting_line_type_code

Line 185: FROM xla_jlt_acct_attrs

181: CURSOR c_acct_sources
182: IS
183: SELECT accounting_attribute_code, source_application_id,
184: source_type_code, source_code, event_class_default_flag
185: FROM xla_jlt_acct_attrs
186: WHERE application_id = p_application_id
187: AND amb_context_code = p_amb_context_code
188: AND event_class_code = p_event_class_code
189: AND accounting_line_type_code = p_old_accting_line_type_code

Line 358: INSERT INTO xla_jlt_acct_attrs

354: FETCH c_acct_sources
355: INTO l_acct_source;
356: EXIT WHEN c_acct_sources%notfound;
357:
358: INSERT INTO xla_jlt_acct_attrs
359: (application_id
360: ,amb_context_code
361: ,event_class_code
362: ,accounting_line_type_code

Line 842: delete xla_jlt_acct_attrs

838: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
839: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
840: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
841:
842: delete xla_jlt_acct_attrs
843: WHERE application_id = p_application_id
844: AND amb_context_code = p_amb_context_code
845: AND event_class_code = p_event_class_code
846: AND accounting_line_type_code = p_accounting_line_type_code

Line 911: INSERT into xla_jlt_acct_attrs(

907: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
908: xla_utility_pkg.trace('accounting_line_type_code = '||p_accounting_line_type_code , 20);
909: xla_utility_pkg.trace('accounting_line_code = '||p_accounting_line_code , 20);
910:
911: INSERT into xla_jlt_acct_attrs(
912: application_id
913: ,amb_context_code
914: ,event_class_code
915: ,accounting_line_type_code

Line 964: UPDATE xla_jlt_acct_attrs

960: l_arr_source_type_code, l_arr_source_code;
961:
962: IF l_arr_acct_attribute_code.COUNT > 0 THEN
963: FORALL i IN l_arr_acct_attribute_code.FIRST..l_arr_acct_attribute_code.LAST
964: UPDATE xla_jlt_acct_attrs
965: SET source_application_id = l_arr_source_application_id(i)
966: ,source_type_code = l_arr_source_type_code(i)
967: ,source_code = l_arr_source_code(i)
968: WHERE application_id = p_application_id

Line 1007: FROM xla_jlt_acct_attrs

1003: l_temp VARCHAR2(1);
1004: l_result boolean;
1005: cursor c_non_gain_acct_attrs is
1006: SELECT 'x'
1007: FROM xla_jlt_acct_attrs
1008: WHERE application_id = p_application_id
1009: AND amb_context_code = p_amb_context_code
1010: AND event_class_code = p_event_class_code
1011: AND accounting_line_type_code = p_accounting_line_type_code

Line 1090: FROM xla_jlt_acct_attrs

1086:
1087: CURSOR c_acct_sources
1088: IS
1089: SELECT 'x'
1090: FROM xla_jlt_acct_attrs
1091: WHERE application_id = p_application_id
1092: AND amb_context_code = p_amb_context_code
1093: AND event_class_code = p_event_class_code
1094: AND accounting_line_type_code = p_accounting_line_type_code

Line 1137: INSERT into xla_jlt_acct_attrs(

1133:
1134: -- Insert accounting attributes of level 'EVT_CLASS_JLT' and 'JLT_ONLY'
1135: -- with null source mapping
1136: IF p_side_code = 'G' THEN
1137: INSERT into xla_jlt_acct_attrs(
1138: application_id
1139: ,amb_context_code
1140: ,event_class_code
1141: ,accounting_line_type_code

Line 1201: INSERT into xla_jlt_acct_attrs(

1197: FROM xla_acct_attributes_b l
1198: WHERE l.assignment_level_code = 'JLT_ONLY'
1199: );
1200: ELSE
1201: INSERT into xla_jlt_acct_attrs(
1202: application_id
1203: ,amb_context_code
1204: ,event_class_code
1205: ,accounting_line_type_code

Line 1269: UPDATE xla_jlt_acct_attrs

1265:
1266: IF l_arr_p_acct_attribute_code.COUNT > 0 THEN
1267: FORALL i IN l_arr_p_acct_attribute_code.FIRST..l_arr_p_acct_attribute_code.LAST
1268:
1269: UPDATE xla_jlt_acct_attrs
1270: SET source_application_id = l_arr_p_source_application_id(i)
1271: ,source_type_code = l_arr_p_source_type_code(i)
1272: ,source_code = l_arr_p_source_code(i)
1273: WHERE application_id = p_application_id

Line 1295: UPDATE xla_jlt_acct_attrs

1291:
1292: IF l_arr_acct_attribute_code.COUNT > 0 THEN
1293: FORALL i IN l_arr_acct_attribute_code.FIRST..l_arr_acct_attribute_code.LAST
1294:
1295: UPDATE xla_jlt_acct_attrs
1296: SET source_application_id = l_arr_source_application_id(i)
1297: ,source_type_code = l_arr_source_type_code(i)
1298: ,source_code = l_arr_source_code(i)
1299: WHERE application_id = p_application_id

Line 1687: FROM xla_jlt_acct_attrs a

1683: SELECT distinct s.assignment_group_code
1684: FROM xla_acct_attributes_b s
1685: WHERE s.assignment_group_code IS NOT NULL
1686: AND EXISTS (SELECT 'x'
1687: FROM xla_jlt_acct_attrs a
1688: WHERE a.application_id = p_application_id
1689: AND a.amb_context_code = p_amb_context_code
1690: AND a.event_class_code = p_event_class_code
1691: AND a.accounting_line_type_code = p_accounting_line_type_code

Line 1716: FROM xla_jlt_acct_attrs a

1712: WHERE assignment_level_code = 'EVT_CLASS_JLT'
1713: AND assignment_required_code = 'G'
1714: AND assignment_group_code = l_mapping_group.assignment_group_code
1715: AND exists (SELECT 'x'
1716: FROM xla_jlt_acct_attrs a
1717: WHERE a.application_id = p_application_id
1718: AND a.amb_context_code = p_amb_context_code
1719: AND a.event_class_code = p_event_class_code
1720: AND a.accounting_line_type_code = p_accounting_line_type_code

Line 1736: FROM xla_jlt_acct_attrs a

1732: AND assignment_required_code = 'G'
1733: AND inherited_flag = 'N'
1734: AND assignment_group_code = l_mapping_group.assignment_group_code
1735: AND exists (SELECT 'x'
1736: FROM xla_jlt_acct_attrs a
1737: WHERE a.application_id = p_application_id
1738: AND a.amb_context_code = p_amb_context_code
1739: AND a.event_class_code = p_event_class_code
1740: AND a.accounting_line_type_code = p_accounting_line_type_code

Line 2057: UPDATE xla_jlt_acct_attrs

2053:
2054: IF l_arr_p_acct_attribute_code.COUNT > 0 THEN
2055: FORALL i IN l_arr_p_acct_attribute_code.FIRST..l_arr_p_acct_attribute_code.LAST
2056:
2057: UPDATE xla_jlt_acct_attrs
2058: SET source_application_id = null
2059: ,source_type_code = null
2060: ,source_code = null
2061: WHERE application_id = p_application_id

Line 2082: UPDATE xla_jlt_acct_attrs

2078:
2079: IF l_arr_acct_attribute_code.COUNT > 0 THEN
2080: FORALL i IN l_arr_acct_attribute_code.FIRST..l_arr_acct_attribute_code.LAST
2081:
2082: UPDATE xla_jlt_acct_attrs
2083: SET source_application_id = l_arr_source_application_id(i)
2084: ,source_type_code = l_arr_source_type_code(i)
2085: ,source_code = l_arr_source_code(i)
2086: ,event_class_default_flag = 'Y'