APPS.XLA_JE_VALIDATION_PKG dependencies on FUN_BAL_LINES_GT

Line 7499: INSERT INTO fun_bal_lines_gt (

7495: END IF;
7496:
7497:
7498: --normal case
7499: INSERT INTO fun_bal_lines_gt (
7500: group_id
7501: ,bal_seg_val
7502: ,entered_amt_dr
7503: ,entered_amt_cr

Line 7536: trace(p_msg => '# non-reversal rows inserted into fun_bal_lines_gt: '||SQL%ROWCOUNT,

7532: AND (xdl.temp_line_num IS NULL OR xdl.temp_line_num >0)
7533: AND xdl.application_id = g_application_id);
7534:
7535: IF (C_LEVEL_EVENT >= g_log_level) THEN
7536: trace(p_msg => '# non-reversal rows inserted into fun_bal_lines_gt: '||SQL%ROWCOUNT,
7537: p_module => l_log_module,
7538: p_level => C_LEVEL_EVENT);
7539: END IF;
7540:

Line 7543: INSERT INTO fun_bal_lines_gt (

7539: END IF;
7540:
7541:
7542: --reversal case
7543: INSERT INTO fun_bal_lines_gt (
7544: group_id
7545: ,bal_seg_val
7546: ,entered_amt_dr
7547: ,entered_amt_cr

Line 7581: trace(p_msg => '# reversal rows inserted into fun_bal_lines_gt: '||SQL%ROWCOUNT,

7577: AND xdl.application_id = g_application_id);
7578:
7579:
7580: IF (C_LEVEL_EVENT >= g_log_level) THEN
7581: trace(p_msg => '# reversal rows inserted into fun_bal_lines_gt: '||SQL%ROWCOUNT,
7582: p_module => l_log_module,
7583: p_level => C_LEVEL_EVENT);
7584: END IF;
7585:

Line 10745: DELETE FROM fun_bal_lines_gt;

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:
10749:

Line 10766: DELETE FROM fun_bal_lines_gt;

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:
10770: balance_by_ledger(l_array_ledgers(l_count)

Line 10865: DELETE FROM fun_bal_lines_gt;

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:
10869: balance_by_ledger(p_ledger_array(l_count)

Line 10965: DELETE FROM fun_bal_lines_gt;

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:
10969: g_ae_header_id := p_ae_header_ids(i);