[Home] [Help]
1441: ,accounting_entry_status_code
1442: ,period_name
1443: ,gain_or_loss_flag
1444: )
1445: SELECT /*+ cardinality(h,1) index(l, XLA_AE_LINES_U1) use_nl(l) use_nl(ccid) */
1446: h.ae_header_id
1447: ,l.ae_line_num
1448: ,h.ledger_id
1449: ,l.displayed_line_number
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
1546: AND l.ae_header_id = h.ae_header_id
1640: ,suspense_code_combination_id
1641: ,accounting_entry_status_code
1642: ,period_name
1643: )
1644: SELECT /*+ leading(h) cardinality(h,1) index(l, XLA_AE_LINES_U1) use_nl(l) use_nl(ccid) */
1645: h.ae_header_id
1646: ,l.ae_line_num
1647: ,h.ledger_id
1648: ,l.displayed_line_number
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
1987: ,gl_suspense_accounts gsa1
2253: ,accounting_entry_status_code
2254: ,period_name
2255: ,gain_or_loss_flag
2256: )
2257: SELECT /*+ cardinality(h,1) index(l, XLA_AE_LINES_U1) use_nl(l) use_nl(ccid) */
2258: h.ae_header_id
2259: ,l.ae_line_num
2260: ,h.ledger_id
2261: ,l.displayed_line_number
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
2530: WHERE ccid.code_combination_id(+) = l.code_combination_id
2582: group by ae_header_id
2583: having sum(abs(accounted_cr)) = 0 and sum(abs(accounted_dr))=0);
2584:
2585: IF (p_budgetary_control_mode = 'NONE') THEN
2586: UPDATE /*+ index(XAL,XLA_AE_LINES_U1)*/ xla_ae_lines xal -- 4769388
2587: SET (code_combination_id, substituted_ccid)=
2588: (SELECT code_combination_id, substituted_ccid
2589: FROM xla_validation_lines_gt xvlg
2590: WHERE xvlg.ae_header_id = xal.ae_header_id
2596: from xla_validation_lines_gt GT -- 4769388
2597: where substituted_ccid is not NULL);
2598:
2599: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2600: trace(p_msg => '# of rows updated to xla_ae_lines:'||to_char(SQL%ROWCOUNT),
2601: p_module => l_log_module,
2602: p_level => C_LEVEL_STATEMENT);
2603: END IF;
2604: END IF;
2865: THEN 'Y'
2866: ELSE NULL
2867: END
2868: FROM xla_ae_headers h
2869: ,xla_ae_lines l
2870: ,gl_code_combinations ccid
2871: ,fnd_currencies fcu
2872: WHERE ccid.code_combination_id(+) = l.code_combination_id
2873: AND l.ae_header_id = h.ae_header_id
5104: CLOSE c_account;
5105: END IF;
5106:
5107: SELECT gain_or_loss_flag INTO l_gain_or_loss_flag
5108: FROM xla_ae_lines
5109: WHERE application_id = g_application_id
5110: AND ae_header_id = l_err.ae_header_id
5111: AND ae_line_num = l_err.ae_line_num;
5112:
5644:
5645: --=============================================================================
5646: --
5647: -- Name: balance_by_bsv_and_ledger_curr
5648: -- Description: This function inserts rows to the xla_ae_lines of the specified
5649: -- subledger journal entry so that the entry will be balanced by
5650: -- balancing segments and ledger currency.
5651: --
5652: --=============================================================================
9453: --=============================================================================
9454: --
9455: -- Name: populate_balancing_lines
9456: -- Description: This function inserts the new entry lines created for the
9457: -- balancing routines into the real xla_ae_lines table.
9458: --
9459: --=============================================================================
9460: PROCEDURE populate_balancing_lines
9461: IS
9498: END IF;
9499:
9500:
9501:
9502: INSERT INTO xla_ae_lines
9503: (ae_header_id
9504: ,ae_line_num
9505: ,displayed_line_number
9506: ,code_combination_id
9630: ,'BALANCE');
9631:
9632:
9633: IF (C_LEVEL_EVENT >= g_log_level) THEN
9634: trace(p_msg => '# xla_ae_lines inserted for balancing = '||SQL%ROWCOUNT,
9635: p_module => l_log_module,
9636: p_level => C_LEVEL_EVENT);
9637: END IF;
9638:
10127:
10128: -- Update line level funds status, and update the amount to zero if it is
10129: -- an encumbrance entry and the BC validation partially failed for the JE
10130: FORALL i IN 1 .. l_array_ae_header_id.count
10131: UPDATE xla_ae_lines
10132: SET funds_status_code = l_array_ln_funds_status_code(i)
10133: , entered_cr = CASE WHEN entered_cr IS NULL
10134: THEN NULL
10135: WHEN l_array_hdr_funds_status_code(i) = 'P'
10186: AND ae_header_id = l_array_ae_header_id(i)
10187: AND ae_line_num = l_array_ae_line_num(i);
10188:
10189: IF (C_LEVEL_EVENT >= g_log_level) THEN
10190: trace(p_msg => '# row updated in xla_ae_lines = '||SQL%ROWCOUNT,
10191: p_module => l_log_module,
10192: p_level => C_LEVEL_EVENT);
10193: END IF;
10194:
10193: END IF;
10194:
10195: -- Adjust the amount for the RFE lines for any failed BC lines
10196: FORALL i in 1 .. l_array_ae_header_id.count
10197: UPDATE xla_ae_lines
10198: SET entered_cr = CASE WHEN entered_cr IS NULL
10199: THEN NULL
10200: ELSE entered_cr - NVL(l_array_entered_dr(i),0)
10201: END
10237: AND SUBSTR(l_array_ln_funds_status_code(i),1,1) = 'F'
10238: AND accounting_class_code = 'RFE';
10239:
10240: IF (C_LEVEL_EVENT >= g_log_level) THEN
10241: trace(p_msg => '# RFE row updated in xla_ae_lines = '||SQL%ROWCOUNT,
10242: p_module => l_log_module,
10243: p_level => C_LEVEL_EVENT);
10244: END IF;
10245: