APPS.FII_GL_BUDGET_EXTRACTION dependencies on FII_BUDGET_BASE

Line 667: --the group by condition since it is part of index FII_BUDGET_BASE_U1.

663:
664: --If posted_date is to be populated from
665: --the temp table like the rest of the
666: --columns, then it should be added to
667: --the group by condition since it is part of index FII_BUDGET_BASE_U1.
668: --It will also have to be added to the delete statement.
669:
670:
671: if g_debug_flag = 'Y' then

Line 757: --- Deleting from fii_budget_base by diffing with temp table -------------

753:
754: commit;
755:
756:
757: --- Deleting from fii_budget_base by diffing with temp table -------------
758: --------------------------------------------------------------------------
759: g_phase := 'Deleting from fii_budget_base by diffing with temp table.';
760:
761: if g_debug_flag = 'Y' then

Line 759: g_phase := 'Deleting from fii_budget_base by diffing with temp table.';

755:
756:
757: --- Deleting from fii_budget_base by diffing with temp table -------------
758: --------------------------------------------------------------------------
759: g_phase := 'Deleting from fii_budget_base by diffing with temp table.';
760:
761: if g_debug_flag = 'Y' then
762: FII_UTIL.write_log('');
763: FII_UTIL.put_line(g_phase);

Line 767: DELETE FROM fii_budget_base

763: FII_UTIL.put_line(g_phase);
764: FII_UTIL.start_timer;
765: end if;
766:
767: DELETE FROM fii_budget_base
768: WHERE (time_id,
769: period_type_id,
770: ledger_id,
771: company_id,

Line 799: FROM fii_budget_base

795: prim_amount_g,
796: sec_amount_g,
797: prim_amount_total,
798: sec_amount_total
799: FROM fii_budget_base
800: MINUS
801: SELECT time_id,
802: period_type_id,
803: ledger_id,

Line 821: FII_UTIL.write_log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_budget_base.');

817: WHERE time_id is not null);
818:
819:
820: if g_debug_flag = 'Y' then
821: FII_UTIL.write_log('Deleted ' || SQL%ROWCOUNT || ' rows from fii_budget_base.');
822: FII_UTIL.stop_timer;
823: FII_UTIL.print_timer('Duration');
824: end if;
825: /* l_row_count := SQL%ROWCOUNT; */

Line 826: /* DBMS_OUTPUT.put_line('Deleted ' || TO_CHAR(l_row_count) || ' rows from fii_budget_base.'); */

822: FII_UTIL.stop_timer;
823: FII_UTIL.print_timer('Duration');
824: end if;
825: /* l_row_count := SQL%ROWCOUNT; */
826: /* DBMS_OUTPUT.put_line('Deleted ' || TO_CHAR(l_row_count) || ' rows from fii_budget_base.'); */
827: /* l_row_count := 0; */
828:
829:
830: --- Insert contents of temp table into fii_budget_base --------------------

Line 830: --- Insert contents of temp table into fii_budget_base --------------------

826: /* DBMS_OUTPUT.put_line('Deleted ' || TO_CHAR(l_row_count) || ' rows from fii_budget_base.'); */
827: /* l_row_count := 0; */
828:
829:
830: --- Insert contents of temp table into fii_budget_base --------------------
831: --------------------------------------------------------------------------
832: g_phase := 'Insert contents of temp table into fii_budget_base.';
833:
834: if g_debug_flag = 'Y' then

Line 832: g_phase := 'Insert contents of temp table into fii_budget_base.';

828:
829:
830: --- Insert contents of temp table into fii_budget_base --------------------
831: --------------------------------------------------------------------------
832: g_phase := 'Insert contents of temp table into fii_budget_base.';
833:
834: if g_debug_flag = 'Y' then
835: FII_UTIL.write_log('');
836: FII_UTIL.write_log(g_phase);

Line 841: INSERT /*+ append parallel(f) */ INTO fii_budget_base f

837: FII_UTIL.start_timer;
838: end if;
839:
840:
841: INSERT /*+ append parallel(f) */ INTO fii_budget_base f
842: (plan_type_code,
843: time_id,
844: period_type_id,
845: ledger_id,

Line 901: FROM fii_budget_base b

897: prim_amount_g,
898: sec_amount_g,
899: prim_amount_total,
900: sec_amount_total
901: FROM fii_budget_base b
902: WHERE time_id = t.time_id
903: and period_type_id = t.period_type_id
904: and ledger_id = t.ledger_id
905: and company_id = t.company_id

Line 920: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_budget_base.');

916: and sec_amount_total = t.sec_amount_g));
917:
918:
919: if g_debug_flag = 'Y' then
920: FII_UTIL.write_log('Inserted ' || SQL%ROWCOUNT || ' rows into fii_budget_base.');
921: FII_UTIL.stop_timer;
922: FII_UTIL.print_timer('Duration');
923: end if;
924: /* l_row_count := SQL%ROWCOUNT; */

Line 925: /* DBMS_OUTPUT.put_line('Inserted ' || TO_CHAR(l_row_count) || ' rows into fii_budget_base.'); */

921: FII_UTIL.stop_timer;
922: FII_UTIL.print_timer('Duration');
923: end if;
924: /* l_row_count := SQL%ROWCOUNT; */
925: /* DBMS_OUTPUT.put_line('Inserted ' || TO_CHAR(l_row_count) || ' rows into fii_budget_base.'); */
926: /* l_row_count := 0; */
927:
928: --
929: -- Commit all changes