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

Line 526: , xla_jlt_acct_attrs xja

522: AND xpa.event_class_code = p_event_class_code
523: AND EXISTS (SELECT 'x'
524: FROM xla_aad_line_defn_assgns xal
525: , xla_line_defn_jlt_assgns xld
526: , xla_jlt_acct_attrs xja
527: WHERE xja.application_id = p_application_id
528: AND xja.event_class_code = p_event_class_code
529: AND xja.accounting_attribute_code = p_accounting_attribute_code
530: AND xja.event_class_default_flag = 'Y'

Line 603: , xla_jlt_acct_attrs xja

599: AND xpa.event_class_code = p_event_class_code
600: AND xpa.validation_status_code <> 'N'
601: AND EXISTS (SELECT 'X'
602: FROM xla_line_defn_jlt_assgns xld
603: , xla_jlt_acct_attrs xja
604: WHERE xja.application_id = p_application_id
605: AND xja.event_class_code = p_event_class_code
606: AND xja.accounting_attribute_code = p_accounting_attribute_code
607: AND xja.event_class_default_flag = 'Y'

Line 628: , xla_jlt_acct_attrs xja

624: AND xpa.validation_status_code <> 'N'
625: AND EXISTS (SELECT 'X'
626: FROM xla_aad_line_defn_assgns xal
627: , xla_line_defn_jlt_assgns xld
628: , xla_jlt_acct_attrs xja
629: WHERE xja.application_id = p_application_id
630: AND xja.event_class_code = p_event_class_code
631: AND xja.accounting_attribute_code = p_accounting_attribute_code
632: AND xja.event_class_default_flag = 'Y'

Line 658: , xla_jlt_acct_attrs xja

654: AND xpr.compile_status_code <> 'N'
655: AND EXISTS (SELECT 'X'
656: FROM xla_aad_line_defn_assgns xal
657: , xla_line_defn_jlt_assgns xld
658: , xla_jlt_acct_attrs xja
659: WHERE xja.application_id = p_application_id
660: AND xja.event_class_code = p_event_class_code
661: AND xja.accounting_attribute_code = p_accounting_attribute_code
662: AND xja.event_class_default_flag = 'Y'

Line 913: , xla_jlt_acct_attrs xaa

909: AND xpa.event_class_code = p_event_class_code
910: AND EXISTS (SELECT 'x'
911: FROM xla_aad_line_defn_assgns xal
912: , xla_line_defn_jlt_assgns xja
913: , xla_jlt_acct_attrs xaa
914: WHERE xaa.application_id = p_application_id
915: AND xaa.event_class_code = p_event_class_code
916: AND xaa.accounting_attribute_code = p_accounting_attribute_code
917: AND xaa.event_class_default_flag = NVL(p_event_class_default_flag,

Line 993: , xla_jlt_acct_attrs xaa

989: AND xld.event_class_code = p_event_class_code
990: AND xld.validation_status_code <> 'N'
991: AND EXISTS (SELECT 'X'
992: FROM xla_line_defn_jlt_assgns xja
993: , xla_jlt_acct_attrs xaa
994: WHERE xaa.application_id = p_application_id
995: AND xaa.event_class_code = p_event_class_code
996: AND xaa.accounting_attribute_code = p_accounting_attribute_code
997: AND xaa.event_class_default_flag = NVL(p_event_class_default_flag,

Line 1022: , xla_jlt_acct_attrs xaa

1018: AND xpa.validation_status_code <> 'N'
1019: AND EXISTS (SELECT 'x'
1020: FROM xla_aad_line_defn_assgns xal
1021: , xla_line_defn_jlt_assgns xja
1022: , xla_jlt_acct_attrs xaa
1023: WHERE xaa.application_id = p_application_id
1024: AND xaa.event_class_code = p_event_class_code
1025: AND xaa.accounting_attribute_code = p_accounting_attribute_code
1026: AND xaa.event_class_default_flag = NVL(p_event_class_default_flag,

Line 1056: , xla_jlt_acct_attrs xaa

1052: AND xpr.compile_status_code <> 'N'
1053: AND EXISTS (SELECT 'x'
1054: FROM xla_aad_line_defn_assgns xal
1055: , xla_line_defn_jlt_assgns xja
1056: , xla_jlt_acct_attrs xaa
1057: WHERE xaa.application_id = p_application_id
1058: AND xaa.event_class_code = p_event_class_code
1059: AND xaa.accounting_attribute_code = p_accounting_attribute_code
1060: AND xaa.event_class_default_flag = NVL(p_event_class_default_flag,

Line 1607: FROM xla_jlt_acct_attrs

1603:
1604: CURSOR c_jlt_assgn_exist
1605: IS
1606: SELECT 'x'
1607: FROM xla_jlt_acct_attrs
1608: WHERE application_id = p_application_id
1609: AND event_class_code = p_event_class_code
1610: AND accounting_attribute_code = p_accounting_attribute_code;
1611:

Line 1636: FROM xla_jlt_acct_attrs a

1632: WHERE application_id = p_application_id
1633: AND event_class_code = p_event_class_code
1634: AND business_method_code = 'PRIOR_ENTRY'
1635: AND EXISTS (SELECT 'x'
1636: FROM xla_jlt_acct_attrs a
1637: WHERE a.application_id = b.application_id
1638: AND a.event_class_code = b.event_class_code
1639: AND a.amb_context_code = b.amb_context_code
1640: AND a.accounting_line_type_code = b.accounting_line_type_code

Line 1690: INSERT INTO xla_jlt_acct_attrs

1686: END IF;
1687:
1688: IF l_arr_acct_line_code.COUNT > 0 THEN
1689: FORALL i IN l_arr_acct_line_code.FIRST..l_arr_acct_line_code.LAST
1690: INSERT INTO xla_jlt_acct_attrs
1691: (application_id
1692: ,amb_context_code
1693: ,event_class_code
1694: ,accounting_line_type_code

Line 1738: UPDATE xla_jlt_acct_attrs

1734:
1735: ELSE
1736:
1737: -- Update default assignments for JLTs
1738: UPDATE xla_jlt_acct_attrs
1739: SET source_application_id = p_source_application_id
1740: ,source_type_code = p_source_type_code
1741: ,source_code = p_source_code
1742: WHERE application_id = p_application_id

Line 1796: INSERT INTO xla_jlt_acct_attrs

1792: END IF;
1793:
1794: IF l_arr_acct_line_code.COUNT > 0 THEN
1795: FORALL i IN l_arr_acct_line_code.FIRST..l_arr_acct_line_code.LAST
1796: INSERT INTO xla_jlt_acct_attrs
1797: (application_id
1798: ,amb_context_code
1799: ,event_class_code
1800: ,accounting_line_type_code

Line 1849: UPDATE xla_jlt_acct_attrs

1845: INTO l_prior_entry_line_types;
1846: EXIT WHEN c_prior_entry_line_types%NOTFOUND;
1847:
1848: -- Update default assignments for JLTs to null for the prior entry JLTs
1849: UPDATE xla_jlt_acct_attrs
1850: SET source_application_id = NULL
1851: ,source_type_code = NULL
1852: ,source_code = NULL
1853: WHERE application_id = p_application_id

Line 1934: FROM xla_jlt_acct_attrs a

1930: FROM xla_acct_line_types_b b
1931: WHERE application_id = p_application_id
1932: AND event_class_code = p_event_class_code
1933: AND EXISTS (SELECT 'x'
1934: FROM xla_jlt_acct_attrs a
1935: WHERE a.application_id = b.application_id
1936: AND a.event_class_code = b.event_class_code
1937: AND a.amb_context_code = b.amb_context_code
1938: AND a.accounting_line_type_code = b.accounting_line_type_code

Line 1952: FROM xla_jlt_acct_attrs a

1948: WHERE application_id = p_application_id
1949: AND event_class_code = p_event_class_code
1950: AND business_method_code <> 'PRIOR_ENTRY'
1951: AND EXISTS (SELECT 'x'
1952: FROM xla_jlt_acct_attrs a
1953: WHERE a.application_id = b.application_id
1954: AND a.event_class_code = b.event_class_code
1955: AND a.amb_context_code = b.amb_context_code
1956: AND a.accounting_line_type_code = b.accounting_line_type_code

Line 1984: UPDATE xla_jlt_acct_attrs

1980: INTO l_non_pe_line_types;
1981: EXIT WHEN c_non_pe_line_types%NOTFOUND;
1982:
1983: -- Update default assignments for JLTs which are not prior entry JLTs
1984: UPDATE xla_jlt_acct_attrs
1985: SET source_application_id = p_source_application_id
1986: ,source_type_code = p_source_type_code
1987: ,source_code = p_source_code
1988: WHERE application_id = p_application_id

Line 2006: UPDATE xla_jlt_acct_attrs

2002: INTO l_line_types;
2003: EXIT WHEN c_line_types%NOTFOUND;
2004:
2005: -- Update default assignments for JLTs which are not prior entry JLTs
2006: UPDATE xla_jlt_acct_attrs
2007: SET source_application_id = p_source_application_id
2008: ,source_type_code = p_source_type_code
2009: ,source_code = p_source_code
2010: WHERE application_id = p_application_id

Line 2052: UPDATE xla_jlt_acct_attrs

2048: ,x_event_type_name => l_event_type_name
2049: ,x_locking_status_flag => l_locking_status_flag);
2050:
2051: -- Update default assignments for JLTs with the null source mapping
2052: UPDATE xla_jlt_acct_attrs
2053: SET source_application_id = NULL
2054: ,source_type_code = NULL
2055: ,source_code = NULL
2056: WHERE application_id = p_application_id

Line 2148: FROM xla_jlt_acct_attrs

2144: IF l_count = 1 THEN
2145: -- it is the last assignment, so delete from JLT
2146:
2147: DELETE
2148: FROM xla_jlt_acct_attrs
2149: WHERE application_id = p_application_id
2150: AND event_class_code = p_event_class_code
2151: AND accounting_attribute_code = p_accounting_attribute_code;
2152:

Line 2182: UPDATE xla_jlt_acct_attrs

2178: ,x_event_type_name => l_event_type_name
2179: ,x_locking_status_flag => l_locking_status_flag);
2180:
2181: -- Update default assignments for JLTs with the null source mapping
2182: UPDATE xla_jlt_acct_attrs
2183: SET source_application_id = NULL
2184: ,source_type_code = NULL
2185: ,source_code = NULL
2186: WHERE application_id = p_application_id