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_JE_VALIDATION_PKG dependencies on XLA_AE_HEADERS_GT

Line 694: UPDATE xla_ae_headers_gt h

690:
691: IF (p_ae_header_id IS NULL) THEN
692: -- g_caller := C_CALLER_ACCT_PROGRAM; -- 4262811
693:
694: UPDATE xla_ae_headers_gt h
695: SET (period_year,period_closing_status) =
696: (SELECT period_year,closing_status
697: FROM gl_period_statuses gl
698: WHERE gl.period_name = h.period_name

Line 1541: FROM xla_ae_headers_gt h

1537: ,NULL -- substituted_ccid
1538: ,h.accounting_entry_status_code
1539: ,h.period_name
1540: ,l.gain_or_loss_flag
1541: FROM xla_ae_headers_gt h
1542: ,xla_ae_lines l
1543: ,gl_code_combinations ccid
1544: ,fnd_currencies fcu
1545: WHERE ccid.code_combination_id(+) = l.code_combination_id

Line 1982: FROM xla_ae_headers_gt h

1978: NVL(gsa1.code_combination_id,
1979: NVL(gsa2.code_combination_id, gsa3.code_combination_id)))
1980: ,h.accounting_entry_status_code
1981: ,h.period_name
1982: FROM xla_ae_headers_gt h
1983: ,xla_ae_lines l
1984: ,gl_code_combinations ccid
1985: ,gl_code_combinations ccid1
1986: ,gl_suspense_accounts gsa

Line 2525: FROM xla_ae_headers_gt h

2521: ELSE NULL END
2522: ,h.accounting_entry_status_code
2523: ,h.period_name
2524: ,l.gain_or_loss_flag
2525: FROM xla_ae_headers_gt h
2526: ,xla_ae_lines l
2527: ,gl_code_combinations ccid
2528: ,gl_code_combinations ccid1
2529: ,fnd_currencies fcu

Line 2951: FROM xla_ae_headers_gt h

2947: ,CASE WHEN h.doc_sequence_id IS NOT NULL AND doc.doc_sequence_id IS NULL
2948: THEN 'N'
2949: ELSE 'Y'
2950: END doc_sequence_id_valid_flag
2951: FROM xla_ae_headers_gt h
2952: LEFT OUTER JOIN fnd_doc_sequence_categories cat
2953: ON cat.code = h.doc_category_code
2954: LEFT OUTER JOIN fnd_document_sequences doc
2955: ON doc.doc_sequence_id = h.doc_sequence_id

Line 3266: FROM xla_ae_headers_gt h

3262: ,CASE WHEN h.balance_type_code = 'B' AND
3263: h.period_year > b.latest_opened_year
3264: THEN 'N'
3265: ELSE 'Y' END budget_period_valid_flag
3266: FROM xla_ae_headers_gt h
3267: LEFT OUTER JOIN gl_budget_versions bv
3268: ON bv.budget_version_id = h.budget_version_id
3269: LEFT OUTER JOIN gl_budgets b
3270: ON b.budget_name = bv.budget_name

Line 3634: FROM xla_ae_headers_gt h

3630: ,NVL(h.header_num,0) header_num -- 4262811
3631: ,h.period_closing_status period_closing_status -- 4262811
3632: ,h.period_name period_name -- 5136994
3633: ,h.gl_transfer_status_code
3634: FROM xla_ae_headers_gt h
3635: WHERE h.ledger_id = g_ledger_id
3636: AND (h.accounting_date <= g_end_date OR h.period_closing_status IN ('P','C') -- 4262811
3637: OR h.period_name IS NULL) -- 5136994
3638: AND ((h.balance_type_code = 'B' AND h.budget_version_id IS NULL) OR

Line 6890: , xla_ae_headers_gt hdr

6886: , hdr.event_id
6887: , hdr.ae_header_id
6888: , err.error_message --added for 10180336
6889: FROM fun_bal_errors_gt err
6890: , xla_ae_headers_gt hdr
6891: , gl_je_categories je
6892: , xle_entity_profiles le1
6893: , xle_entity_profiles le2
6894: , xle_entity_profiles le3

Line 9679: WHERE ae_header_id in (SELECT /+ UNNEST NO_SEMIJOIN cardinality(XLA_AE_HEADERS_GT,1)/ ae_header_id -- 4752774 bug9174950

9675:
9676: -- 4262811. Added c_caller_mpa_program
9677: IF (g_caller in (C_CALLER_MPA_PROGRAM, C_CALLER_THIRD_PARTY_MERGE)) THEN
9678: DELETE FROM xla_ae_segment_values
9679: WHERE ae_header_id in (SELECT /*+ UNNEST NO_SEMIJOIN cardinality(XLA_AE_HEADERS_GT,1)*/ ae_header_id -- 4752774 bug9174950
9680: FROM xla_ae_headers_gt
9681: WHERE ledger_id = g_ledger_id
9682: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811
9683: ELSIF g_caller = C_CALLER_ACCT_PROGRAM THEN

Line 9680: FROM xla_ae_headers_gt

9676: -- 4262811. Added c_caller_mpa_program
9677: IF (g_caller in (C_CALLER_MPA_PROGRAM, C_CALLER_THIRD_PARTY_MERGE)) THEN
9678: DELETE FROM xla_ae_segment_values
9679: WHERE ae_header_id in (SELECT /*+ UNNEST NO_SEMIJOIN cardinality(XLA_AE_HEADERS_GT,1)*/ ae_header_id -- 4752774 bug9174950
9680: FROM xla_ae_headers_gt
9681: WHERE ledger_id = g_ledger_id
9682: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811
9683: ELSIF g_caller = C_CALLER_ACCT_PROGRAM THEN
9684: NULL; -- bug 4883830

Line 9927: -- Possible values returned to xla_ae_headers_gt.funds_status_codes are:

9923:
9924: ELSE
9925:
9926: --
9927: -- Possible values returned to xla_ae_headers_gt.funds_status_codes are:
9928: -- S - If all rows in the packet pass funds check (Success)
9929: -- A - If all rows in the packet pass funds check and some of the rows have advisory warnings (Advisory)
9930: -- F - If all rows in the packet fail funds check (Fail)
9931: -- P - If some rows in the packet pass while some fail (Partial)

Line 9943: FROM xla_ae_headers_gt

9939: l_array_ae_header_id
9940: , l_array_hdr_funds_status_code
9941: , l_array_event_id
9942: , l_array_entity_id
9943: FROM xla_ae_headers_gt
9944: WHERE ledger_id = g_ledger_id;
9945:
9946: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9947: FOR i IN 1 .. l_array_ae_header_id.count LOOP