[Home] [Help]
7417: -- balancing API
7418: --
7419: IF (l_bal_count>0) THEN
7420: FORALL j IN 1..l_bal_count
7421: INSERT INTO fun_bal_headers_gt (
7422: group_id
7423: ,ledger_id
7424: ,je_source_name
7425: ,je_category_name
7433: ,l_accounting_dates(j)
7434: ,'OK');
7435:
7436: IF (C_LEVEL_EVENT >= g_log_level) THEN
7437: trace(p_msg => '# rows inserted into fun_bal_headers_gt: '||SQL%ROWCOUNT,
7438: p_module => l_log_module,
7439: p_level => C_LEVEL_EVENT);
7440: END IF;
7441:
7451:
7452:
7453: --HINTS added on several sqls in this procedure for 9351919
7454:
7455: INSERT INTO fun_bal_headers_gt( group_id
7456: ,ledger_id
7457: ,je_source_name
7458: ,je_category_name
7459: ,gl_date
7463: ,je_source_name
7464: ,je_category_name
7465: ,gl_date
7466: ,status
7467: FROM fun_bal_headers_gt fgt
7468: WHERE EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7469: FROM xla_distribution_links xdl
7470: WHERE fgt.group_id = xdl.ae_header_id
7471: AND xdl.temp_line_num <0
7472: AND xdl.application_id = g_application_id);
7473:
7474:
7475: IF (C_LEVEL_EVENT >= g_log_level) THEN
7476: trace(p_msg => '# rows inserted into fun_bal_headers_gt: (insert negative headers if full/partial reversal exists) '||SQL%ROWCOUNT,
7477: p_module => l_log_module,
7478: p_level => C_LEVEL_EVENT);
7479: END IF;
7480:
7478: p_level => C_LEVEL_EVENT);
7479: END IF;
7480:
7481:
7482: DELETE FROM fun_bal_headers_gt fgt
7483: WHERE fgt.group_id > 0
7484: AND NOT EXISTS (SELECT /*+ NO_UNNEST INDEX(xdl XLA_DISTRIBUTION_LINKS_N3)*/ 1
7485: FROM xla_distribution_links xdl
7486: WHERE fgt.group_id = xdl.ae_header_id
7488: AND xdl.application_id = g_application_id);
7489:
7490:
7491: IF (C_LEVEL_EVENT >= g_log_level) THEN
7492: trace(p_msg => '# rows deleted fun_bal_headers_gt: (delete positive headers if all header-lines are reversed) '||SQL%ROWCOUNT,
7493: p_module => l_log_module,
7494: p_level => C_LEVEL_EVENT);
7495: END IF;
7496:
7519: ,l.unrounded_accounted_dr
7520: ,l.unrounded_accounted_cr
7521: ,'N'
7522: FROM xla_validation_lines_gt l
7523: ,fun_bal_headers_gt h
7524: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7525: AND l.ae_header_id = h.group_id
7526: AND l.entered_currency_code <> 'STAT' -- added for bug#10166812
7527: AND h.group_id > 0
7563: ,l.unrounded_accounted_cr
7564: ,l.unrounded_accounted_dr
7565: ,'N'
7566: FROM xla_validation_lines_gt l
7567: ,fun_bal_headers_gt h
7568: WHERE l.balancing_line_type = C_LINE_TYPE_PROCESS
7569: AND l.ae_header_id = h.group_id * -1
7570: AND l.entered_currency_code <> 'STAT' -- added for bug#10166812
7571: AND h.group_id < 0
10740: IF l_array_ledgers.COUNT > 0 THEN
10741: FOR l_count IN 1 .. l_array_ledgers.COUNT LOOP
10742:
10743: DELETE FROM xla_validation_lines_gt;
10744: DELETE FROM fun_bal_headers_gt; --bug9526716 added fun table deletes in multiple place in xlajebal.pkb
10745: DELETE FROM fun_bal_lines_gt;
10746: DELETE FROM fun_bal_results_gt;
10747: DELETE FROM fun_bal_errors_gt;
10748:
10761: IF l_array_ledgers.COUNT > 0 THEN
10762: FOR l_count IN 1 .. l_array_ledgers.COUNT LOOP
10763:
10764: DELETE FROM xla_validation_lines_gt;
10765: DELETE FROM fun_bal_headers_gt;
10766: DELETE FROM fun_bal_lines_gt;
10767: DELETE FROM fun_bal_results_gt;
10768: DELETE FROM fun_bal_errors_gt;
10769:
10860: FOR l_count IN 1 .. p_ledger_array.COUNT loop
10861: IF(g_err_count=0) THEN
10862:
10863: DELETE FROM xla_validation_lines_gt;
10864: DELETE FROM fun_bal_headers_gt;
10865: DELETE FROM fun_bal_lines_gt;
10866: DELETE FROM fun_bal_results_gt;
10867: DELETE FROM fun_bal_errors_gt;
10868:
10960: -- Process ALC ledgers
10961: FOR i IN 1 .. p_ledger_ids.COUNT LOOP
10962:
10963: DELETE FROM xla_validation_lines_gt;
10964: DELETE FROM fun_bal_headers_gt;
10965: DELETE FROM fun_bal_lines_gt;
10966: DELETE FROM fun_bal_results_gt;
10967: DELETE FROM fun_bal_errors_gt;
10968: