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_ANALYTICAL_CRITERIA_PKG dependencies on XLA_AE_LINES

Line 1064: FROM xla_ae_lines xal

1060: CLOSE lc_lock_ae_line_details;
1061:
1062: SELECT xal.analytical_balance_flag
1063: INTO l_analytical_balance_flag
1064: FROM xla_ae_lines xal
1065: WHERE xal.application_id = p_application_id
1066: AND xal.ae_header_id = p_ae_header_id
1067: AND xal.ae_line_num = p_ae_line_num;
1068:

Line 1129: UPDATE xla_ae_lines xal

1125: );
1126:
1127: IF l_balancing_flag = 'Y'
1128: THEN
1129: UPDATE xla_ae_lines xal
1130: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_PEND
1131: WHERE xal.application_id = p_application_id
1132: AND xal.ae_header_id = p_ae_header_id
1133: AND xal.ae_line_num = p_ae_line_num;

Line 1276: FROM xla_ae_lines xal

1272: CLOSE lc_lock_ae_line_details;
1273:
1274: SELECT xal.analytical_balance_flag
1275: INTO l_analytical_balance_flag
1276: FROM xla_ae_lines xal
1277: WHERE xal.application_id = p_application_id
1278: AND xal.ae_header_id = p_ae_header_id
1279: AND xal.ae_line_num = p_ae_line_num;
1280:

Line 1313: UPDATE xla_ae_lines xal

1309: END IF; --l_balancing_flag = 'Y'
1310:
1311: IF l_balancing_flag = 'Y'
1312: THEN
1313: UPDATE xla_ae_lines xal
1314: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_PEND
1315: WHERE xal.application_id = p_application_id
1316: AND xal.ae_header_id = p_ae_header_id
1317: AND xal.ae_line_num = p_ae_line_num;

Line 1410: FROM xla_ae_lines xal

1406: ,cp_application_id INTEGER
1407: )
1408: IS
1409: SELECT 1
1410: FROM xla_ae_lines xal
1411: ,xla_ae_line_details xald
1412: WHERE xal.ae_header_id = cp_ae_header_id
1413: AND xal.application_id = cp_application_id
1414: AND xald.ae_header_id = xal.ae_header_id

Line 1481: FROM xla_ae_lines xal

1477: CLOSE lc_lock_ae_lines_and_details;
1478:
1479: SELECT COUNT(*)
1480: INTO l_balanced_lined_count
1481: FROM xla_ae_lines xal
1482: WHERE xal.application_id = p_application_id
1483: AND xal.ae_header_id = p_ae_header_id
1484: AND xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_DONE;
1485:

Line 1531: ,xla_ae_lines xal

1527: --loop on all the journal entry lines
1528: FOR i IN (
1529: SELECT xal.ae_line_num
1530: FROM xla_ae_headers xah
1531: ,xla_ae_lines xal
1532: WHERE xah.application_id = p_application_id
1533: AND xah.ae_header_id = p_ae_header_id
1534: AND xal.application_id = xah.application_id
1535: AND xal.ae_header_id = xah.ae_header_id

Line 1547: UPDATE xla_ae_lines xal

1543: );
1544: END LOOP;
1545:
1546: --update the balance flag of the lines to NULL
1547: UPDATE xla_ae_lines xal
1548: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1549: WHERE xal.application_id = p_application_id
1550: AND xal.ae_header_id = p_ae_header_id;
1551:

Line 1558: || ' in xla_ae_lines'

1554: ( p_module => l_log_module
1555: ,p_msg => SQL%ROWCOUNT
1556: || ' row(s) updated to '
1557: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1558: || ' in xla_ae_lines'
1559: ,p_level => C_LEVEL_STATEMENT);
1560: END IF;
1561:
1562: ELSE --p_analytical_detail_value_id IS NOT NULL

Line 1596: FROM xla_ae_lines xal

1592: CLOSE lc_lock_ae_line_details;
1593:
1594: SELECT xal.analytical_balance_flag
1595: INTO l_analytical_balance_flag
1596: FROM xla_ae_lines xal
1597: WHERE xal.application_id = p_application_id
1598: AND xal.ae_header_id = p_ae_header_id
1599: AND xal.ae_line_num = p_ae_line_num;
1600:

Line 1637: UPDATE xla_ae_lines xal

1633: ,p_ae_line_num => p_ae_line_num
1634: ,p_analytical_detail_value_id => NULL
1635: );
1636:
1637: UPDATE xla_ae_lines xal
1638: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1639: WHERE xal.application_id = p_application_id
1640: AND xal.ae_header_id = p_ae_header_id
1641: AND xal.ae_line_num = p_ae_line_num;

Line 1647: || ' row(s) updated in xla_ae_lines: '

1643: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1644: trace
1645: ( p_module => l_log_module
1646: ,p_msg => SQL%ROWCOUNT
1647: || ' row(s) updated in xla_ae_lines: '
1648: || 'analytical_balance_flag updated to '
1649: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1650: ,p_level => C_LEVEL_STATEMENT
1651: );

Line 1665: UPDATE xla_ae_lines xal

1661: );
1662:
1663: --set balance flag for the line to NULL if no details left
1664: --disregarded indentation for readability
1665: UPDATE xla_ae_lines xal
1666: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1667: WHERE xal.application_id = p_application_id
1668: AND xal.ae_header_id = p_ae_header_id
1669: AND xal.ae_line_num = p_ae_line_num

Line 1689: || ' row(s) updated in xla_ae_lines: '

1685: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1686: trace
1687: ( p_module => l_log_module
1688: ,p_msg => SQL%ROWCOUNT
1689: || ' row(s) updated in xla_ae_lines: '
1690: || 'analytical_balance_flag updated to '
1691: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1692: ,p_level => C_LEVEL_STATEMENT
1693: );

Line 1800: FROM xla_ae_lines xal

1796: ,cp_application_id INTEGER
1797: )
1798: IS
1799: SELECT 1
1800: FROM xla_ae_lines xal
1801: ,xla_ae_line_acs xald
1802: WHERE xal.ae_header_id = cp_ae_header_id
1803: AND xal.application_id = cp_application_id
1804: AND xald.ae_header_id = xal.ae_header_id

Line 1871: FROM xla_ae_lines xal

1867: CLOSE lc_lock_ae_lines_and_details;
1868:
1869: SELECT COUNT(*)
1870: INTO l_balanced_lined_count
1871: FROM xla_ae_lines xal
1872: WHERE xal.application_id = p_application_id
1873: AND xal.ae_header_id = p_ae_header_id
1874: AND xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_DONE;
1875:

Line 1906: UPDATE xla_ae_lines xal

1902: END IF;
1903: END IF; --l_balanced_lined_count > 0
1904:
1905: --update the balance flag of the lines to NULL
1906: UPDATE xla_ae_lines xal
1907: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1908: WHERE xal.application_id = p_application_id
1909: AND xal.ae_header_id = p_ae_header_id;
1910:

Line 1917: || ' in xla_ae_lines'

1913: ( p_module => l_log_module
1914: ,p_msg => SQL%ROWCOUNT
1915: || ' row(s) updated to '
1916: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1917: || ' in xla_ae_lines'
1918: ,p_level => C_LEVEL_STATEMENT);
1919: END IF;
1920:
1921: END IF;

Line 1934: FROM xla_ae_lines xal

1930: CLOSE lc_lock_ae_line_details;
1931:
1932: SELECT xal.analytical_balance_flag
1933: INTO l_analytical_balance_flag
1934: FROM xla_ae_lines xal
1935: WHERE xal.application_id = p_application_id
1936: AND xal.ae_header_id = p_ae_header_id
1937: AND xal.ae_line_num = p_ae_line_num;
1938:

Line 1969: UPDATE xla_ae_lines xal

1965:
1966: IF (p_anacri_code IS NULL)
1967: THEN
1968:
1969: UPDATE xla_ae_lines xal
1970: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1971: WHERE xal.application_id = p_application_id
1972: AND xal.ae_header_id = p_ae_header_id
1973: AND xal.ae_line_num = p_ae_line_num;

Line 1979: || ' row(s) updated in xla_ae_lines: '

1975: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1976: trace
1977: ( p_module => l_log_module
1978: ,p_msg => SQL%ROWCOUNT
1979: || ' row(s) updated in xla_ae_lines: '
1980: || 'analytical_balance_flag updated to '
1981: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1982: ,p_level => C_LEVEL_STATEMENT
1983: );

Line 1990: UPDATE xla_ae_lines xal

1986: ELSE --p_anacri_code IS NOT NULL
1987:
1988: --set balance flag for the line to NULL if no details left
1989: --disregarded indentation for readability
1990: UPDATE xla_ae_lines xal
1991: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1992: WHERE xal.application_id = p_application_id
1993: AND xal.ae_header_id = p_ae_header_id
1994: AND xal.ae_line_num = p_ae_line_num

Line 2012: || ' row(s) updated in xla_ae_lines: '

2008: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2009: trace
2010: ( p_module => l_log_module
2011: ,p_msg => SQL%ROWCOUNT
2012: || ' row(s) updated in xla_ae_lines: '
2013: || 'analytical_balance_flag updated to '
2014: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
2015: ,p_level => C_LEVEL_STATEMENT
2016: );

Line 2099: ,xla_ae_lines xal

2095: )
2096: IS
2097: SELECT 1
2098: FROM xla_ae_headers xah
2099: ,xla_ae_lines xal
2100: WHERE xah.application_id = cp_application_id
2101: AND xah.ae_header_id = cp_ae_header_id
2102: AND xal.application_id = xah.application_id
2103: AND xal.ae_header_id = xah.ae_header_id

Line 2528: ,xla_ae_lines xal

2524: )
2525: IS
2526: SELECT 1
2527: FROM xla_ae_headers xah
2528: ,xla_ae_lines xal
2529: WHERE xah.application_id = cp_application_id
2530: AND xah.ae_header_id = cp_ae_header_id
2531: AND xal.application_id = xah.application_id
2532: AND xal.ae_header_id = xah.ae_header_id

Line 2862: ,xla_ae_lines xal

2858: )
2859: IS
2860: SELECT 1
2861: FROM xla_ae_headers xah
2862: ,xla_ae_lines xal
2863: WHERE xah.application_id = cp_application_id
2864: AND xah.ae_header_id = cp_ae_header_id
2865: AND xal.application_id = xah.application_id
2866: AND xal.ae_header_id = xah.ae_header_id