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 1157: UPDATE xla_ae_lines xal

1153: );
1154:
1155: IF l_balancing_flag = 'Y'
1156: THEN
1157: UPDATE xla_ae_lines xal
1158: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_PEND
1159: WHERE xal.application_id = p_application_id
1160: AND xal.ae_header_id = p_ae_header_id
1161: AND xal.ae_line_num = p_ae_line_num;

Line 1304: FROM xla_ae_lines xal

1300: CLOSE lc_lock_ae_line_details;
1301:
1302: SELECT xal.analytical_balance_flag
1303: INTO l_analytical_balance_flag
1304: FROM xla_ae_lines xal
1305: WHERE xal.application_id = p_application_id
1306: AND xal.ae_header_id = p_ae_header_id
1307: AND xal.ae_line_num = p_ae_line_num;
1308:

Line 1369: UPDATE xla_ae_lines xal

1365: END IF; --l_balancing_flag = 'Y'
1366:
1367: IF l_balancing_flag = 'Y'
1368: THEN
1369: UPDATE xla_ae_lines xal
1370: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_PEND
1371: WHERE xal.application_id = p_application_id
1372: AND xal.ae_header_id = p_ae_header_id
1373: AND xal.ae_line_num = p_ae_line_num;

Line 1466: FROM xla_ae_lines xal

1462: ,cp_application_id INTEGER
1463: )
1464: IS
1465: SELECT 1
1466: FROM xla_ae_lines xal
1467: ,xla_ae_line_details xald
1468: WHERE xal.ae_header_id = cp_ae_header_id
1469: AND xal.application_id = cp_application_id
1470: AND xald.ae_header_id = xal.ae_header_id

Line 1537: FROM xla_ae_lines xal

1533: CLOSE lc_lock_ae_lines_and_details;
1534:
1535: SELECT COUNT(*)
1536: INTO l_balanced_lined_count
1537: FROM xla_ae_lines xal
1538: WHERE xal.application_id = p_application_id
1539: AND xal.ae_header_id = p_ae_header_id
1540: AND xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_DONE;
1541:

Line 1615: ,xla_ae_lines xal

1611: --loop on all the journal entry lines
1612: FOR i IN (
1613: SELECT xal.ae_line_num
1614: FROM xla_ae_headers xah
1615: ,xla_ae_lines xal
1616: WHERE xah.application_id = p_application_id
1617: AND xah.ae_header_id = p_ae_header_id
1618: AND xal.application_id = xah.application_id
1619: AND xal.ae_header_id = xah.ae_header_id

Line 1631: UPDATE xla_ae_lines xal

1627: );
1628: END LOOP;
1629:
1630: --update the balance flag of the lines to NULL
1631: UPDATE xla_ae_lines xal
1632: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1633: WHERE xal.application_id = p_application_id
1634: AND xal.ae_header_id = p_ae_header_id;
1635:

Line 1642: || ' in xla_ae_lines'

1638: ( p_module => l_log_module
1639: ,p_msg => SQL%ROWCOUNT
1640: || ' row(s) updated to '
1641: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1642: || ' in xla_ae_lines'
1643: ,p_level => C_LEVEL_STATEMENT);
1644: END IF;
1645:
1646: ELSE --p_analytical_detail_value_id IS NOT NULL

Line 1680: FROM xla_ae_lines xal

1676: CLOSE lc_lock_ae_line_details;
1677:
1678: SELECT xal.analytical_balance_flag
1679: INTO l_analytical_balance_flag
1680: FROM xla_ae_lines xal
1681: WHERE xal.application_id = p_application_id
1682: AND xal.ae_header_id = p_ae_header_id
1683: AND xal.ae_line_num = p_ae_line_num;
1684:

Line 1747: UPDATE xla_ae_lines xal

1743: ,p_ae_line_num => p_ae_line_num
1744: ,p_analytical_detail_value_id => NULL
1745: );
1746:
1747: UPDATE xla_ae_lines xal
1748: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1749: WHERE xal.application_id = p_application_id
1750: AND xal.ae_header_id = p_ae_header_id
1751: AND xal.ae_line_num = p_ae_line_num;

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

1753: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1754: trace
1755: ( p_module => l_log_module
1756: ,p_msg => SQL%ROWCOUNT
1757: || ' row(s) updated in xla_ae_lines: '
1758: || 'analytical_balance_flag updated to '
1759: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1760: ,p_level => C_LEVEL_STATEMENT
1761: );

Line 1775: UPDATE xla_ae_lines xal

1771: );
1772:
1773: --set balance flag for the line to NULL if no details left
1774: --disregarded indentation for readability
1775: UPDATE xla_ae_lines xal
1776: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
1777: WHERE xal.application_id = p_application_id
1778: AND xal.ae_header_id = p_ae_header_id
1779: AND xal.ae_line_num = p_ae_line_num

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

1795: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1796: trace
1797: ( p_module => l_log_module
1798: ,p_msg => SQL%ROWCOUNT
1799: || ' row(s) updated in xla_ae_lines: '
1800: || 'analytical_balance_flag updated to '
1801: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
1802: ,p_level => C_LEVEL_STATEMENT
1803: );

Line 1910: FROM xla_ae_lines xal

1906: ,cp_application_id INTEGER
1907: )
1908: IS
1909: SELECT 1
1910: FROM xla_ae_lines xal
1911: ,xla_ae_line_acs xald
1912: WHERE xal.ae_header_id = cp_ae_header_id
1913: AND xal.application_id = cp_application_id
1914: AND xald.ae_header_id = xal.ae_header_id

Line 1982: FROM xla_ae_lines xal

1978: CLOSE lc_lock_ae_lines_and_details;
1979:
1980: SELECT COUNT(*)
1981: INTO l_balanced_lined_count
1982: FROM xla_ae_lines xal
1983: WHERE xal.application_id = p_application_id
1984: AND xal.ae_header_id = p_ae_header_id
1985: AND xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_DONE;
1986:

Line 2045: UPDATE xla_ae_lines xal

2041: END IF;
2042: END IF; --l_balanced_lined_count > 0
2043:
2044: --update the balance flag of the lines to NULL
2045: UPDATE xla_ae_lines xal
2046: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
2047: WHERE xal.application_id = p_application_id
2048: AND xal.ae_header_id = p_ae_header_id;
2049:

Line 2056: || ' in xla_ae_lines'

2052: ( p_module => l_log_module
2053: ,p_msg => SQL%ROWCOUNT
2054: || ' row(s) updated to '
2055: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
2056: || ' in xla_ae_lines'
2057: ,p_level => C_LEVEL_STATEMENT);
2058: END IF;
2059:
2060: END IF;

Line 2073: FROM xla_ae_lines xal

2069: CLOSE lc_lock_ae_line_details;
2070:
2071: SELECT xal.analytical_balance_flag
2072: INTO l_analytical_balance_flag
2073: FROM xla_ae_lines xal
2074: WHERE xal.application_id = p_application_id
2075: AND xal.ae_header_id = p_ae_header_id
2076: AND xal.ae_line_num = p_ae_line_num;
2077:

Line 2134: UPDATE xla_ae_lines xal

2130:
2131: IF (p_anacri_code IS NULL)
2132: THEN
2133:
2134: UPDATE xla_ae_lines xal
2135: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
2136: WHERE xal.application_id = p_application_id
2137: AND xal.ae_header_id = p_ae_header_id
2138: AND xal.ae_line_num = p_ae_line_num;

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

2140: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2141: trace
2142: ( p_module => l_log_module
2143: ,p_msg => SQL%ROWCOUNT
2144: || ' row(s) updated in xla_ae_lines: '
2145: || 'analytical_balance_flag updated to '
2146: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
2147: ,p_level => C_LEVEL_STATEMENT
2148: );

Line 2155: UPDATE xla_ae_lines xal

2151: ELSE --p_anacri_code IS NOT NULL
2152:
2153: --set balance flag for the line to NULL if no details left
2154: --disregarded indentation for readability
2155: UPDATE xla_ae_lines xal
2156: SET xal.analytical_balance_flag = C_ANALYTICAL_BAL_FLAG_NO
2157: WHERE xal.application_id = p_application_id
2158: AND xal.ae_header_id = p_ae_header_id
2159: AND xal.ae_line_num = p_ae_line_num

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

2173: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2174: trace
2175: ( p_module => l_log_module
2176: ,p_msg => SQL%ROWCOUNT
2177: || ' row(s) updated in xla_ae_lines: '
2178: || 'analytical_balance_flag updated to '
2179: || NVL(C_ANALYTICAL_BAL_FLAG_NO, 'NULL')
2180: ,p_level => C_LEVEL_STATEMENT
2181: );

Line 2264: ,xla_ae_lines xal

2260: )
2261: IS
2262: SELECT 1
2263: FROM xla_ae_headers xah
2264: ,xla_ae_lines xal
2265: WHERE xah.application_id = cp_application_id
2266: AND xah.ae_header_id = cp_ae_header_id
2267: AND xal.application_id = xah.application_id
2268: AND xal.ae_header_id = xah.ae_header_id

Line 2693: ,xla_ae_lines xal

2689: )
2690: IS
2691: SELECT 1
2692: FROM xla_ae_headers xah
2693: ,xla_ae_lines xal
2694: WHERE xah.application_id = cp_application_id
2695: AND xah.ae_header_id = cp_ae_header_id
2696: AND xal.application_id = xah.application_id
2697: AND xal.ae_header_id = xah.ae_header_id

Line 3027: ,xla_ae_lines xal

3023: )
3024: IS
3025: SELECT 1
3026: FROM xla_ae_headers xah
3027: ,xla_ae_lines xal
3028: WHERE xah.application_id = cp_application_id
3029: AND xah.ae_header_id = cp_ae_header_id
3030: AND xal.application_id = xah.application_id
3031: AND xal.ae_header_id = xah.ae_header_id