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 1614: FROM xla_ae_headers xah

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

Line 2251: FROM xla_ae_headers xah

2247: ,cp_ae_header_id INTEGER
2248: )
2249: IS
2250: SELECT 1
2251: FROM xla_ae_headers xah
2252: WHERE xah.application_id = cp_application_id
2253: AND xah.ae_header_id = cp_ae_header_id
2254: FOR UPDATE NOWAIT;
2255:

Line 2263: FROM xla_ae_headers xah

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

Line 2680: FROM xla_ae_headers xah

2676: ,cp_ae_header_id INTEGER
2677: )
2678: IS
2679: SELECT 1
2680: FROM xla_ae_headers xah
2681: WHERE xah.application_id = cp_application_id
2682: AND xah.ae_header_id = cp_ae_header_id
2683: FOR UPDATE NOWAIT;
2684:

Line 2692: FROM xla_ae_headers xah

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

Line 3014: FROM xla_ae_headers xah

3010: ,cp_ae_header_id INTEGER
3011: )
3012: IS
3013: SELECT 1
3014: FROM xla_ae_headers xah
3015: WHERE xah.application_id = cp_application_id
3016: AND xah.ae_header_id = cp_ae_header_id
3017: FOR UPDATE NOWAIT;
3018:

Line 3026: FROM xla_ae_headers xah

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