eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_BUDGET_FORECAST_C dependencies on FII_BUDGET_STG

Line 731: -- and insert them into fii_budget_stg.

727: -- Procedure
728: -- Psi_Insert_Stg()
729: -- Purpose
730: -- This routine is used to extract budget data from gl_je_headers/lines
731: -- and insert them into fii_budget_stg.
732: -- Arguments
733: -- None
734: -- Example
735: -- result := FII_BUDGET_FORECAST_C.Psi_Insert_Stg

Line 752: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);

748: END IF;
749:
750: -- PSI Budget Extraction will always extract budget data from scratch
751: g_phase := 'Truncate the staging table FII_BUDGET_BASE';
752: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);
753:
754: -- Check if UDD1 is enabled or not
755: SELECT DBI_ENABLED_FLAG
756: INTO l_udd1_enabled_flag

Line 768: ' INSERT /+ append parallel(fii_budget_stg)/ INTO FII_BUDGET_STG'||

764: -- We'll pick up data from the set of books/companies set up in FDS
765: -- where the functional currency = global primary currency.
766: ------------------------------------------------------------------------
767: l_sqlstmt :=
768: ' INSERT /*+ append parallel(fii_budget_stg)*/ INTO FII_BUDGET_STG'||
769: ' ( plan_type_code, day, year,'||
770: ' ledger_id, company_id, cost_center_id, fin_category_id,category_id, '||
771: ' user_dim1_id, user_dim2_id, prim_amount_g, prim_amount_total, '||
772: ' baseline_amount_prim, posted_date, budget_version_id, '||

Line 936: ' rows into fii_budget_stg');

932: END IF;
933:
934: IF (FIIBUUP_DEBUG) THEN
935: fii_util.put_line('Inserted '||SQL%ROWCOUNT||
936: ' rows into fii_budget_stg');
937: END IF;
938:
939: -- Need to commit after inserting data into base in parallel mode
940: FND_CONCURRENT.Af_Commit;

Line 1037: ' INSERT /+ append parallel(fii_budget_stg)/ INTO FII_BUDGET_STG'||

1033: -- where the functional currency = global primary currency and
1034: -- begin_balance_dr/begin_balance_cr is not zero.
1035: ------------------------------------------------------------------------
1036: l_sqlstmt :=
1037: ' INSERT /*+ append parallel(fii_budget_stg)*/ INTO FII_BUDGET_STG'||
1038: ' ( plan_type_code, day, year,'||
1039: ' ledger_id, company_id, cost_center_id, fin_category_id,category_id, '||
1040: ' user_dim1_id, user_dim2_id, prim_amount_g, prim_amount_total, '||
1041: ' baseline_amount_prim, posted_date, budget_version_id, '||

Line 1154: ' rows into fii_budget_stg');

1150: END IF;
1151:
1152: IF (FIIBUUP_DEBUG) THEN
1153: fii_util.put_line('Inserted '||SQL%ROWCOUNT||
1154: ' rows into fii_budget_stg');
1155: END IF;
1156:
1157: -- Need to commit after inserting data into base in parallel mode
1158: FND_CONCURRENT.Af_Commit;

Line 1242: -- Rollup data in fii_budget_stg along time dimension

1238:
1239: g_phase := 'PSI Rollup';
1240:
1241: ------------------------------------------------------------------------
1242: -- Rollup data in fii_budget_stg along time dimension
1243: ------------------------------------------------------------------------
1244: l_sqlstmt :=
1245: ' INSERT /*+ append parallel(fii_budget_stg) */ INTO fii_budget_stg '||
1246: ' ( plan_type_code, period, quarter, year, ledger_id, '||

Line 1245: ' INSERT /+ append parallel(fii_budget_stg) / INTO fii_budget_stg '||

1241: ------------------------------------------------------------------------
1242: -- Rollup data in fii_budget_stg along time dimension
1243: ------------------------------------------------------------------------
1244: l_sqlstmt :=
1245: ' INSERT /*+ append parallel(fii_budget_stg) */ INTO fii_budget_stg '||
1246: ' ( plan_type_code, period, quarter, year, ledger_id, '||
1247: ' company_id, cost_center_id, fin_category_id, category_id, '||
1248: ' user_dim1_id, user_dim2_id, prim_amount_g, '||
1249: ' prim_amount_total, baseline_amount_prim, '||

Line 1265: ' FROM fii_budget_stg b, '||

1261: ' SUM(b.baseline_amount_prim )baseline_amount_prim, '||
1262: ' b.posted_date, b.code_combination_id, b.budget_version_id, '||
1263: ' b.last_update_date, b.last_updated_by, '||
1264: ' b.creation_date, b.created_by, b.last_update_login '||
1265: ' FROM fii_budget_stg b, '||
1266: ' fii_time_day fday '||
1267: ' WHERE b.day = fday.report_date_julian '||
1268: ' GROUP BY '||
1269: ' b.plan_type_code, b.ledger_id, b.company_id, b.cost_center_id, '||

Line 1299: ' rows into fii_budget_stg');

1295: EXECUTE IMMEDIATE l_sqlstmt;
1296:
1297: IF (FIIBUUP_DEBUG) THEN
1298: fii_util.put_line('Inserted '||SQL%ROWCOUNT||
1299: ' rows into fii_budget_stg');
1300: END IF;
1301:
1302: -- Need to commit
1303: FND_CONCURRENT.Af_Commit;

Line 1365: -- that exists in fii_budget_base but not in fii_budget_stg (new data).

1361: -- Procedure
1362: -- Psi_DeleteDiff()
1363: -- Purpose
1364: -- This routine will delete budget data with time/dimension combination
1365: -- that exists in fii_budget_base but not in fii_budget_stg (new data).
1366: -- Arguments
1367: -- None
1368: -- Example
1369: -- result := FII_BUDGET_FORECAST_C.Psi_DeleteDiff;

Line 1387: -- not exists in the new data in fii_budget_stg.

1383: g_phase := 'PSI DeleteDiff';
1384:
1385: ------------------------------------------------------------------------
1386: -- Delete rows from fii_budget_base if time/dimension combination does
1387: -- not exists in the new data in fii_budget_stg.
1388: ------------------------------------------------------------------------
1389: l_sqlstmt :=
1390: ' DELETE FROM fii_budget_base '||
1391: ' WHERE ( plan_type_code, '||

Line 1437: ' FROM fii_budget_stg '||

1433: ' user_dim2_id, '||
1434: ' posted_date, '||
1435: ' sum(prim_amount_g), '||
1436: ' sum(baseline_amount_prim) '||
1437: ' FROM fii_budget_stg '||
1438: ' GROUP BY plan_type_code, '||
1439: ' nvl(day, nvl(period, nvl(quarter, year))), '||
1440: ' decode(day, null, '||
1441: ' decode(period, null, '||

Line 1538: -- This routine will merge new/modified budget data from fii_budget_stg

1534: --
1535: -- Procedure
1536: -- Psi_Insert_Base()
1537: -- Purpose
1538: -- This routine will merge new/modified budget data from fii_budget_stg
1539: -- into fii_budget_base.
1540: -- Arguments
1541: -- None
1542: -- Example

Line 1560: -- Insert new/modified budget data in fii_budget_stg into fii_budget_base

1556:
1557: g_phase := 'PSI Insert Base';
1558:
1559: ------------------------------------------------------------------------
1560: -- Insert new/modified budget data in fii_budget_stg into fii_budget_base
1561: ------------------------------------------------------------------------
1562: -- Bug 5004852: Changed to populate company_cost_center_org_id as well
1563: -- Bug 4943332: Added hints suggested by the performance team
1564: l_sqlstmt :=

Line 1591: ' FROM fii_budget_stg '||

1587: ' user_dim2_id, '||
1588: ' trunc(posted_date), '||
1589: ' sysdate, :user_id, sysdate, :user_id, :login_id, '||
1590: ' :ver_date '||
1591: ' FROM fii_budget_stg '||
1592: ' GROUP BY plan_type_code, '||
1593: ' nvl(day, nvl(period, nvl(quarter, year))), '||
1594: ' decode(day, null, '||
1595: ' decode(period, null, '||

Line 1753: FROM fii_budget_stg stg

1749: gl_budget_versions bud,
1750: (SELECT code_combination_id, count(*)
1751: FROM (SELECT /*+ parallel(stg) */ stg.code_combination_id,
1752: stg.budget_version_id
1753: FROM fii_budget_stg stg
1754: GROUP BY stg.code_combination_id, stg.budget_version_id)
1755: GROUP BY code_combination_id
1756: HAVING COUNT(*) > 1) stg2,
1757: fii_budget_stg stg3

Line 1757: fii_budget_stg stg3

1753: FROM fii_budget_stg stg
1754: GROUP BY stg.code_combination_id, stg.budget_version_id)
1755: GROUP BY code_combination_id
1756: HAVING COUNT(*) > 1) stg2,
1757: fii_budget_stg stg3
1758: WHERE acct.code_combination_id = stg2.code_combination_id
1759: AND stg3.code_combination_id = stg2.code_combination_id
1760: AND bud.budget_version_id = stg3.budget_version_id
1761: ORDER BY acct.concatenated_segments, bud.budget_name;

Line 1771: FROM fii_budget_stg

1767: decode(quarter, null, 128, 64), 32), 1) period_type_id,
1768: ledger_id, company_id, cost_center_id, fin_category_id,
1769: category_id, user_dim1_id, user_dim2_id, posted_date,
1770: baseline_amount_prim
1771: FROM fii_budget_stg
1772: MINUS
1773: SELECT time_id, period_type_id,
1774: ledger_id, company_id, cost_center_id, fin_category_id,
1775: category_id, user_dim1_id, user_dim2_id, posted_date,

Line 1782: -- company_id and cost_center_id of FII_BUDGET_STG

1778: gl_ledgers_public_v sob
1779: WHERE sob.ledger_id = v.ledger_id;
1780:
1781: -- Bug 5004852: Added to select the company_cost_center_org_id for the
1782: -- company_id and cost_center_id of FII_BUDGET_STG
1783: CURSOR ccc_org_cursor IS
1784: SELECT DISTINCT NVL(cccorg.ccc_org_id, -1),
1785: stg.company_id, stg.cost_center_id
1786: FROM FII_CCC_MGR_GT cccorg,

Line 1787: FII_BUDGET_STG stg

1783: CURSOR ccc_org_cursor IS
1784: SELECT DISTINCT NVL(cccorg.ccc_org_id, -1),
1785: stg.company_id, stg.cost_center_id
1786: FROM FII_CCC_MGR_GT cccorg,
1787: FII_BUDGET_STG stg
1788: WHERE cccorg.company_id (+) = stg.company_id
1789: AND cccorg.cost_center_id (+) = stg.cost_center_id;
1790:
1791: -- Bug 5004852: Added the new record types and variables required

Line 1852: -- Insert budget data into FII_BUDGET_STG from gl_je_headers/lines

1848: FII_UTIL.Write_Output (l_sob_name || ' (' || l_currency_code || ')');
1849: END LOOP;
1850:
1851: ------------------------------------------------------------------------
1852: -- Insert budget data into FII_BUDGET_STG from gl_je_headers/lines
1853: ------------------------------------------------------------------------
1854: IF (NOT FII_BUDGET_FORECAST_C.Psi_Insert_Stg) THEN
1855: raise FIIBUUP_fatal_err;
1856: END IF;

Line 1859: -- Insert carry forward budget data into FII_BUDGET_STG from gl_balances

1855: raise FIIBUUP_fatal_err;
1856: END IF;
1857:
1858: ------------------------------------------------------------------------
1859: -- Insert carry forward budget data into FII_BUDGET_STG from gl_balances
1860: ------------------------------------------------------------------------
1861: IF (NOT FII_BUDGET_FORECAST_C.Psi_Carry_Forward) THEN
1862: raise FIIBUUP_fatal_err;
1863: END IF;

Line 1923: -- Delete time/dimension combination not exists in new data in fii_budget_stg

1919: FII_UTIL.Write_Output (l_sob_name);
1920: END LOOP;
1921:
1922: ------------------------------------------------------------------------
1923: -- Delete time/dimension combination not exists in new data in fii_budget_stg
1924: ------------------------------------------------------------------------
1925: IF (NOT FII_BUDGET_FORECAST_C.Psi_DeleteDiff) THEN
1926: raise FIIBUUP_fatal_err;
1927: END IF;

Line 1942: -- Bug 5004852: Populate company_cost_center_org_id in fii_budget_stg

1938: fii_util.write_log('Table FII_CCC_MGR_GT is not populated');
1939: raise NO_DATA_FOUND;
1940: END IF;
1941:
1942: -- Bug 5004852: Populate company_cost_center_org_id in fii_budget_stg
1943: -- before inserting data into fii_budget_base
1944: g_phase := 'Open ccc_org_cursor to cache the CCC ORG IDs';
1945:
1946: OPEN ccc_org_cursor;

Line 1951: g_phase := 'Populate CCC Org IDs of FII_BUDGET_STG';

1947: FETCH ccc_org_cursor BULK COLLECT INTO l_ccc_org_rec.l_ccc_org_id,
1948: l_ccc_org_rec.l_com_id,
1949: l_ccc_org_rec.l_cc_id;
1950:
1951: g_phase := 'Populate CCC Org IDs of FII_BUDGET_STG';
1952:
1953: FORALL i in l_ccc_org_rec.l_cc_id.FIRST .. l_ccc_org_rec.l_cc_id.LAST
1954: UPDATE fii_budget_stg stg
1955: SET stg.company_cost_center_org_id = l_ccc_org_rec.l_ccc_org_id(i)

Line 1954: UPDATE fii_budget_stg stg

1950:
1951: g_phase := 'Populate CCC Org IDs of FII_BUDGET_STG';
1952:
1953: FORALL i in l_ccc_org_rec.l_cc_id.FIRST .. l_ccc_org_rec.l_cc_id.LAST
1954: UPDATE fii_budget_stg stg
1955: SET stg.company_cost_center_org_id = l_ccc_org_rec.l_ccc_org_id(i)
1956: WHERE stg.company_id = l_ccc_org_rec.l_com_id(i)
1957: AND stg.cost_center_id = l_ccc_org_rec.l_cc_id(i);
1958:

Line 1962: -- Merge data in fii_budget_stg into fii_budget_base

1958:
1959: CLOSE ccc_org_cursor;
1960:
1961: ------------------------------------------------------------------------
1962: -- Merge data in fii_budget_stg into fii_budget_base
1963: ------------------------------------------------------------------------
1964: IF (NOT FII_BUDGET_FORECAST_C.Psi_Insert_Base) THEN
1965: raise FIIBUUP_fatal_err;
1966: END IF;

Line 4788: -- This routine populates data into fii_budget_stg.

4784: -- Procedure
4785: -- Stage
4786: --
4787: -- Purpose
4788: -- This routine populates data into fii_budget_stg.
4789: -- Arguments
4790: -- version_date
4791: -- Example
4792: -- result := FII_BUDGET_FORECAST_C.Stage(version_date);

Line 4859: l_bud_sqlstmt := ' INSERT INTO FII_BUDGET_STG ( ' ||

4855: -- because of the variable time period involved.
4856: g_phase := 'Build the SQL statement';
4857:
4858: -- Start building the SQL statement
4859: l_bud_sqlstmt := ' INSERT INTO FII_BUDGET_STG ( ' ||
4860: ' version_date, ' || l_bud_stg_col_name || ', ';
4861:
4862: l_fc_sqlstmt := ' INSERT INTO FII_BUDGET_STG ( ' ||
4863: ' version_date, ' || l_fc_stg_col_name || ', ';

Line 4862: l_fc_sqlstmt := ' INSERT INTO FII_BUDGET_STG ( ' ||

4858: -- Start building the SQL statement
4859: l_bud_sqlstmt := ' INSERT INTO FII_BUDGET_STG ( ' ||
4860: ' version_date, ' || l_bud_stg_col_name || ', ';
4861:
4862: l_fc_sqlstmt := ' INSERT INTO FII_BUDGET_STG ( ' ||
4863: ' version_date, ' || l_fc_stg_col_name || ', ';
4864:
4865: l_tmpstmt := ' plan_type_code, creation_date, created_by, '||
4866: ' last_update_date, last_updated_by, last_update_login, '||

Line 5075: v2 => 'FII_BUDGET_STG');

5071: token_num => 2,
5072: t1 => 'NUM',
5073: v1 => TO_CHAR(NVL(SQL%ROWCOUNT, 0)),
5074: t2 => 'TABLE',
5075: v2 => 'FII_BUDGET_STG');
5076: END IF;
5077:
5078: IF (FIIBUUP_DEBUG) THEN
5079: FII_MESSAGE.Write_Log

Line 5119: v2 => 'FII_BUDGET_STG');

5115: token_num => 2,
5116: t1 => 'NUM',
5117: v1 => TO_CHAR(NVL(SQL%ROWCOUNT, 0)),
5118: t2 => 'TABLE',
5119: v2 => 'FII_BUDGET_STG');
5120: END IF;
5121:
5122: -- stage completed, return with success
5123: IF (FIIBUUP_DEBUG) THEN

Line 5280: ' FROM FII_BUDGET_BASE b, FII_BUDGET_STG s '||

5276: ' b.company_id, b.cost_center_id, b.fin_category_id, '||
5277: ' b.category_id, b.user_dim1_id, b.user_dim2_id, '||
5278: ' b.time_id, b.period_type_id, '||
5279: ' s.day, s.week, s.period, s.quarter, s.year '||
5280: ' FROM FII_BUDGET_BASE b, FII_BUDGET_STG s '||
5281: ' WHERE b.plan_type_code = s. plan_type_code '||
5282: ' AND b.ledger_id = s.ledger_id '||
5283: ' AND b.company_id = s.company_id '||
5284: ' AND b.cost_center_id = s.cost_center_id '||

Line 5596: -- Rollup records in fii_budget_stg along time dimension.

5592: -- Procedure
5593: -- Rollup_Stage
5594: --
5595: -- Purpose
5596: -- Rollup records in fii_budget_stg along time dimension.
5597: -- Arguments
5598: -- version_date
5599: -- Example
5600: -- result := FII_BUDGET_FORECAST_C.Rollup_Stage;

Line 5667: ' INSERT INTO FII_BUDGET_STG ( '||

5663: g_phase := 'Build the SQL statement';
5664:
5665: -- Start building the SQL statement
5666: l_tmpstmt :=
5667: ' INSERT INTO FII_BUDGET_STG ( '||
5668: ' version_date, period, quarter, year, plan_type_code, '||
5669: ' creation_date, created_by, last_update_date, '||
5670: ' last_updated_by, last_update_login, ledger_id, '||
5671: ' company_cost_center_org_id, company_id, '||

Line 5702: ' FROM FII_BUDGET_STG s, ';

5698: ' s.category_id, s.user_dim1_id, s.user_dim2_id, '||
5699: ' s.no_version_flag, s.overwrite_version_date, s.data_type, '||
5700: ' SUM(s.prim_amount_total), SUM(s.prim_amount_g), '||
5701: ' SUM(s.sec_amount_total), SUM(s.sec_amount_g) '||
5702: ' FROM FII_BUDGET_STG s, ';
5703:
5704: IF (FIIBUUP_BUDGET_TIME_UNIT <> 'Y') THEN
5705: l_bud_sqlstmt := l_bud_sqlstmt || l_tmpstmt || l_bud_time_tab_name ||
5706: ' WHERE s.plan_type_code = ''B'' ' ||

Line 5793: v2 => 'FII_BUDGET_STG');

5789: token_num => 2,
5790: t1 => 'NUM',
5791: v1 => TO_CHAR(NVL(SQL%ROWCOUNT, 0)),
5792: t2 => 'TABLE',
5793: v2 => 'FII_BUDGET_STG');
5794: END IF;
5795:
5796: IF (FIIBUUP_DEBUG) THEN
5797: FII_MESSAGE.Write_Log

Line 5820: v2 => 'FII_BUDGET_STG');

5816: token_num => 2,
5817: t1 => 'NUM',
5818: v1 => TO_CHAR(NVL(SQL%ROWCOUNT, 0)),
5819: t2 => 'TABLE',
5820: v2 => 'FII_BUDGET_STG');
5821: END IF;
5822:
5823: IF (FIIBUUP_DEBUG) THEN
5824: FII_MESSAGE.Write_Log

Line 5896: -- time dimension into fii_budget_stg.

5892: --
5893: -- Purpose
5894: -- For cases where we are overwriting existing records in fii_budget_base,
5895: -- we'll add the adjustment records we need to make to the rolled up
5896: -- time dimension into fii_budget_stg.
5897: -- Arguments
5898: -- version_date
5899: -- Example
5900: -- result := FII_BUDGET_FORECAST_C.Adjust_Stage;

Line 5921: ' INSERT INTO FII_BUDGET_STG ( '||

5917: g_phase := 'Build the SQL statement';
5918:
5919: -- Start building the SQL statement
5920: l_tmpstmt :=
5921: ' INSERT INTO FII_BUDGET_STG ( '||
5922: ' version_date, period, quarter, year, plan_type_code, '||
5923: ' creation_date, created_by, last_update_date, '||
5924: ' last_updated_by, last_update_login, ledger_id, '||
5925: ' company_cost_center_org_id, company_id, '||

Line 6005: v2 => 'FII_BUDGET_STG');

6001: token_num => 2,
6002: t1 => 'NUM',
6003: v1 => TO_CHAR(NVL(SQL%ROWCOUNT, 0)),
6004: t2 => 'TABLE',
6005: v2 => 'FII_BUDGET_STG');
6006: END IF;
6007: END IF;
6008:
6009: IF (FIIBUUP_FORECAST_TIME_UNIT <> 'Y') THEN

Line 6030: v2 => 'FII_BUDGET_STG');

6026: token_num => 2,
6027: t1 => 'NUM',
6028: v1 => TO_CHAR(NVL(SQL%ROWCOUNT, 0)),
6029: t2 => 'TABLE',
6030: v2 => 'FII_BUDGET_STG');
6031: END IF;
6032: END IF;
6033:
6034: -- adjust_stage completed, return with success

Line 6135: ' FROM FII_BUDGET_STG stg ' ||

6131: ' no_version_flag, sum(prim_amount_total) PRIM_AMOUNT_TOTAL, '||
6132: ' sum(sec_amount_total) SEC_AMOUNT_TOTAL, '||
6133: ' sum(prim_amount_g) PRIM_AMOUNT_G, '||
6134: ' sum(sec_amount_g) SEC_AMOUNT_G '||
6135: ' FROM FII_BUDGET_STG stg ' ||
6136: ' WHERE plan_type_code = :plan_type_code '||
6137: ' GROUP BY version_date, plan_type_code, '||
6138: ' NVL(period, NVL(quarter, year)), '||
6139: ' DECODE(period, '||

Line 6368: ' FROM FII_BUDGET_STG s '||

6364: l_tmpstmt :=
6365: ' UPDATE FII_BUDGET_BASE b '||
6366: ' SET (b.version_date, b.no_version_flag) = '||
6367: ' (SELECT MAX(s.overwrite_version_date), MAX(s.no_version_flag) '||
6368: ' FROM FII_BUDGET_STG s '||
6369: ' WHERE ';
6370:
6371: l_bud_sqlstmt := l_tmpstmt || ' s.plan_type_code = ''B'' ';
6372: l_fc_sqlstmt := l_tmpstmt || ' s.plan_type_code = ''F'' ';

Line 6392: ' FROM fii_budget_stg s2 '||

6388: ' NVL(s2.period, NVL(s2.quarter, s2.year)), '||
6389: ' DECODE(period, null, DECODE(quarter, null, 128, 64), 32), '||
6390: ' ledger_id, company_id, cost_center_id, fin_category_id, '||
6391: ' category_id, user_dim1_id, user_dim2_id, version_date '||
6392: ' FROM fii_budget_stg s2 '||
6393: ' WHERE data_type = -4) ';
6394:
6395: l_bud_sqlstmt := l_bud_sqlstmt || l_tmpstmt || ' AND b.plan_type_code = ''B'' ';
6396: l_fc_sqlstmt := l_fc_sqlstmt || l_tmpstmt || ' AND b.plan_type_code = ''F'' ';

Line 7314: v2 => 'Truncating FII_BUDGET_STG...');

7310: token_num => 2,
7311: t1 => 'ROUTINE',
7312: v1 => 'Main()',
7313: t2 => 'ACTION',
7314: v2 => 'Truncating FII_BUDGET_STG...');
7315: END IF;
7316:
7317: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7318: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);

Line 7317: g_phase := 'Truncate the staging table FII_BUDGET_STG';

7313: t2 => 'ACTION',
7314: v2 => 'Truncating FII_BUDGET_STG...');
7315: END IF;
7316:
7317: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7318: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);
7319:
7320: FND_CONCURRENT.Af_Commit;
7321:

Line 7318: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);

7314: v2 => 'Truncating FII_BUDGET_STG...');
7315: END IF;
7316:
7317: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7318: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);
7319:
7320: FND_CONCURRENT.Af_Commit;
7321:
7322: -- Check if there is anything to upload. If nothing,

Line 7494: v2 => 'Truncating FII_BUDGET_STG...');

7490: token_num => 2,
7491: t1 => 'ROUTINE',
7492: v1 => 'Main()',
7493: t2 => 'ACTION',
7494: v2 => 'Truncating FII_BUDGET_STG...');
7495: END IF;
7496:
7497: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7498: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);

Line 7497: g_phase := 'Truncate the staging table FII_BUDGET_STG';

7493: t2 => 'ACTION',
7494: v2 => 'Truncating FII_BUDGET_STG...');
7495: END IF;
7496:
7497: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7498: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);
7499:
7500: IF(NOT FII_BUDGET_FORECAST_C.Prior_version(l_version_date)) THEN
7501: raise FIIBUUP_fatal_err;

Line 7498: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);

7494: v2 => 'Truncating FII_BUDGET_STG...');
7495: END IF;
7496:
7497: g_phase := 'Truncate the staging table FII_BUDGET_STG';
7498: FII_UTIL.truncate_table ('FII_BUDGET_STG', 'FII', g_retcode);
7499:
7500: IF(NOT FII_BUDGET_FORECAST_C.Prior_version(l_version_date)) THEN
7501: raise FIIBUUP_fatal_err;
7502: END IF;