[Home] [Help]
1176: ,accounting_entry_status_code
1177: ,period_name
1178: ,gain_or_loss_flag
1179: )
1180: SELECT /*+ cardinality(h,1) index(l, XLA_AE_LINES_U1) use_nl(l) use_nl(ccid) */
1181: h.ae_header_id
1182: ,l.ae_line_num
1183: ,h.ledger_id
1184: ,l.displayed_line_number
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
1281: AND l.ae_header_id = h.ae_header_id
1372: ,suspense_code_combination_id
1373: ,accounting_entry_status_code
1374: ,period_name
1375: )
1376: SELECT /*+ leading(h) cardinality(h,1) index(l, XLA_AE_LINES_U1) use_nl(l) use_nl(ccid) */
1377: h.ae_header_id
1378: ,l.ae_line_num
1379: ,h.ledger_id
1380: ,l.displayed_line_number
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
1719: ,gl_suspense_accounts gsa1
1979: ,accounting_entry_status_code
1980: ,period_name
1981: ,gain_or_loss_flag
1982: )
1983: SELECT /*+ cardinality(h,1) index(l, XLA_AE_LINES_U1) use_nl(l) use_nl(ccid) */
1984: h.ae_header_id
1985: ,l.ae_line_num
1986: ,h.ledger_id
1987: ,l.displayed_line_number
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
2256: WHERE ccid.code_combination_id(+) = l.code_combination_id
2308: group by ae_header_id
2309: having sum(abs(accounted_cr)) = 0 and sum(abs(accounted_dr))=0);
2310:
2311: IF (p_budgetary_control_mode = 'NONE') THEN
2312: UPDATE /*+ index(XAL,XLA_AE_LINES_U1)*/ xla_ae_lines xal -- 4769388
2313: SET (code_combination_id, substituted_ccid)=
2314: (SELECT code_combination_id, substituted_ccid
2315: FROM xla_validation_lines_gt xvlg
2316: WHERE xvlg.ae_header_id = xal.ae_header_id
2322: from xla_validation_lines_gt GT -- 4769388
2323: where substituted_ccid is not NULL);
2324:
2325: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2326: trace(p_msg => '# of rows updated to xla_ae_lines:'||to_char(SQL%ROWCOUNT),
2327: p_module => l_log_module,
2328: p_level => C_LEVEL_STATEMENT);
2329: END IF;
2330: END IF;
2590: THEN 'Y'
2591: ELSE NULL
2592: END
2593: FROM xla_ae_headers h
2594: ,xla_ae_lines l
2595: ,gl_code_combinations ccid
2596: ,fnd_currencies fcu
2597: WHERE ccid.code_combination_id(+) = l.code_combination_id
2598: AND l.ae_header_id = h.ae_header_id
4812: CLOSE c_account;
4813: END IF;
4814:
4815: SELECT gain_or_loss_flag INTO l_gain_or_loss_flag
4816: FROM xla_ae_lines
4817: WHERE application_id = g_application_id
4818: AND ae_header_id = l_err.ae_header_id
4819: AND ae_line_num = l_err.ae_line_num;
4820:
5341:
5342: --=============================================================================
5343: --
5344: -- Name: balance_by_bsv_and_ledger_curr
5345: -- Description: This function inserts rows to the xla_ae_lines of the specified
5346: -- subledger journal entry so that the entry will be balanced by
5347: -- balancing segments and ledger currency.
5348: --
5349: --=============================================================================
8772: --=============================================================================
8773: --
8774: -- Name: populate_balancing_lines
8775: -- Description: This function inserts the new entry lines created for the
8776: -- balancing routines into the real xla_ae_lines table.
8777: --
8778: --=============================================================================
8779: PROCEDURE populate_balancing_lines
8780: IS
8817: END IF;
8818:
8819:
8820:
8821: INSERT INTO xla_ae_lines
8822: (ae_header_id
8823: ,ae_line_num
8824: ,displayed_line_number
8825: ,code_combination_id
8949: ,'BALANCE');
8950:
8951:
8952: IF (C_LEVEL_EVENT >= g_log_level) THEN
8953: trace(p_msg => '# xla_ae_lines inserted for balancing = '||SQL%ROWCOUNT,
8954: p_module => l_log_module,
8955: p_level => C_LEVEL_EVENT);
8956: END IF;
8957:
9446:
9447: -- Update line level funds status, and update the amount to zero if it is
9448: -- an encumbrance entry and the BC validation partially failed for the JE
9449: FORALL i IN 1 .. l_array_ae_header_id.count
9450: UPDATE xla_ae_lines
9451: SET funds_status_code = l_array_ln_funds_status_code(i)
9452: , entered_cr = CASE WHEN entered_cr IS NULL
9453: THEN NULL
9454: WHEN l_array_hdr_funds_status_code(i) = 'P'
9505: AND ae_header_id = l_array_ae_header_id(i)
9506: AND ae_line_num = l_array_ae_line_num(i);
9507:
9508: IF (C_LEVEL_EVENT >= g_log_level) THEN
9509: trace(p_msg => '# row updated in xla_ae_lines = '||SQL%ROWCOUNT,
9510: p_module => l_log_module,
9511: p_level => C_LEVEL_EVENT);
9512: END IF;
9513:
9512: END IF;
9513:
9514: -- Adjust the amount for the RFE lines for any failed BC lines
9515: FORALL i in 1 .. l_array_ae_header_id.count
9516: UPDATE xla_ae_lines
9517: SET entered_cr = CASE WHEN entered_cr IS NULL
9518: THEN NULL
9519: ELSE entered_cr - NVL(l_array_entered_dr(i),0)
9520: END
9556: AND SUBSTR(l_array_ln_funds_status_code(i),1,1) = 'F'
9557: AND accounting_class_code = 'RFE';
9558:
9559: IF (C_LEVEL_EVENT >= g_log_level) THEN
9560: trace(p_msg => '# RFE row updated in xla_ae_lines = '||SQL%ROWCOUNT,
9561: p_module => l_log_module,
9562: p_level => C_LEVEL_EVENT);
9563: END IF;
9564: