DBA Data[Home] [Help]

APPS.XLA_ANALYTICAL_CRITERIA_PKG dependencies on XLA_AE_HEADERS

Line 721: ' row(s) inserted into xla_ae_headers_details '

717: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
718: trace
719: ( p_module => l_log_module
720: ,p_msg => SQL%ROWCOUNT ||
721: ' row(s) inserted into xla_ae_headers_details '
722: ,p_level => C_LEVEL_STATEMENT);
723: END IF;
724:
725: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1530: FROM xla_ae_headers xah

1526:
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

Line 2086: FROM xla_ae_headers xah

2082: ,cp_ae_header_id INTEGER
2083: )
2084: IS
2085: SELECT 1
2086: FROM xla_ae_headers xah
2087: WHERE xah.application_id = cp_application_id
2088: AND xah.ae_header_id = cp_ae_header_id
2089: FOR UPDATE NOWAIT;
2090:

Line 2098: FROM xla_ae_headers xah

2094: ,cp_ae_line_num INTEGER
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

Line 2515: FROM xla_ae_headers xah

2511: ,cp_ae_header_id INTEGER
2512: )
2513: IS
2514: SELECT 1
2515: FROM xla_ae_headers xah
2516: WHERE xah.application_id = cp_application_id
2517: AND xah.ae_header_id = cp_ae_header_id
2518: FOR UPDATE NOWAIT;
2519:

Line 2527: FROM xla_ae_headers xah

2523: ,cp_ae_line_num INTEGER
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

Line 2849: FROM xla_ae_headers xah

2845: ,cp_ae_header_id INTEGER
2846: )
2847: IS
2848: SELECT 1
2849: FROM xla_ae_headers xah
2850: WHERE xah.application_id = cp_application_id
2851: AND xah.ae_header_id = cp_ae_header_id
2852: FOR UPDATE NOWAIT;
2853:

Line 2861: FROM xla_ae_headers xah

2857: ,cp_ae_line_num INTEGER
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