[Home] [Help]
425:
426: IF (p_ae_header_id IS NULL) THEN
427: -- g_caller := C_CALLER_ACCT_PROGRAM; -- 4262811
428:
429: UPDATE xla_ae_headers_gt h
430: SET (period_year,period_closing_status) =
431: (SELECT period_year,closing_status
432: FROM gl_period_statuses gl
433: WHERE gl.period_name = h.period_name
1272: ,NULL -- substituted_ccid
1273: ,h.accounting_entry_status_code
1274: ,h.period_name
1275: ,l.gain_or_loss_flag
1276: FROM xla_ae_headers_gt h
1277: ,xla_ae_lines l
1278: ,gl_code_combinations ccid
1279: ,fnd_currencies fcu
1280: WHERE ccid.code_combination_id(+) = l.code_combination_id
1710: NVL(gsa1.code_combination_id,
1711: NVL(gsa2.code_combination_id, gsa3.code_combination_id)))
1712: ,h.accounting_entry_status_code
1713: ,h.period_name
1714: FROM xla_ae_headers_gt h
1715: ,xla_ae_lines l
1716: ,gl_code_combinations ccid
1717: ,gl_code_combinations ccid1
1718: ,gl_suspense_accounts gsa
2247: ELSE NULL END
2248: ,h.accounting_entry_status_code
2249: ,h.period_name
2250: ,l.gain_or_loss_flag
2251: FROM xla_ae_headers_gt h
2252: ,xla_ae_lines l
2253: ,gl_code_combinations ccid
2254: ,gl_code_combinations ccid1
2255: ,fnd_currencies fcu
2672: ,CASE WHEN h.doc_sequence_id IS NOT NULL AND doc.doc_sequence_id IS NULL
2673: THEN 'N'
2674: ELSE 'Y'
2675: END doc_sequence_id_valid_flag
2676: FROM xla_ae_headers_gt h
2677: LEFT OUTER JOIN fnd_doc_sequence_categories cat
2678: ON cat.code = h.doc_category_code
2679: LEFT OUTER JOIN fnd_document_sequences doc
2680: ON doc.doc_sequence_id = h.doc_sequence_id
2987: ,CASE WHEN h.balance_type_code = 'B' AND
2988: h.period_year > b.latest_opened_year
2989: THEN 'N'
2990: ELSE 'Y' END budget_period_valid_flag
2991: FROM xla_ae_headers_gt h
2992: LEFT OUTER JOIN gl_budget_versions bv
2993: ON bv.budget_version_id = h.budget_version_id
2994: LEFT OUTER JOIN gl_budgets b
2995: ON b.budget_name = bv.budget_name
3351: ,NVL(h.header_num,0) header_num -- 4262811
3352: ,h.period_closing_status period_closing_status -- 4262811
3353: ,h.period_name period_name -- 5136994
3354: ,h.gl_transfer_status_code
3355: FROM xla_ae_headers_gt h
3356: WHERE h.ledger_id = g_ledger_id
3357: AND (h.accounting_date <= g_end_date OR h.period_closing_status IN ('P','C') -- 4262811
3358: OR h.period_name IS NULL) -- 5136994
3359: AND ((h.balance_type_code = 'B' AND h.budget_version_id IS NULL) OR
6531: , hdr.entity_id
6532: , hdr.event_id
6533: , hdr.ae_header_id
6534: FROM fun_bal_errors_gt err
6535: , xla_ae_headers_gt hdr
6536: , gl_je_categories je
6537: , xle_entity_profiles le1
6538: , xle_entity_profiles le2
6539: , xle_entity_profiles le3
8995: -- 4262811. Added c_caller_mpa_program
8996: IF (g_caller in (C_CALLER_MPA_PROGRAM, C_CALLER_THIRD_PARTY_MERGE)) THEN
8997: DELETE FROM xla_ae_segment_values
8998: WHERE ae_header_id in (SELECT /*+ UNNEST NO_SEMIJOIN */ ae_header_id -- 4752774
8999: FROM xla_ae_headers_gt
9000: WHERE ledger_id = g_ledger_id
9001: AND accounting_date <= NVL(g_end_date, accounting_date)); -- 4262811
9002: ELSIF g_caller = C_CALLER_ACCT_PROGRAM THEN
9003: NULL; -- bug 4883830
9242:
9243: ELSE
9244:
9245: --
9246: -- Possible values returned to xla_ae_headers_gt.funds_status_codes are:
9247: -- S - If all rows in the packet pass funds check (Success)
9248: -- A - If all rows in the packet pass funds check and some of the rows have advisory warnings (Advisory)
9249: -- F - If all rows in the packet fail funds check (Fail)
9250: -- P - If some rows in the packet pass while some fail (Partial)
9258: l_array_ae_header_id
9259: , l_array_hdr_funds_status_code
9260: , l_array_event_id
9261: , l_array_entity_id
9262: FROM xla_ae_headers_gt
9263: WHERE ledger_id = g_ledger_id;
9264:
9265: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
9266: FOR i IN 1 .. l_array_ae_header_id.count LOOP