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.PA_FP_VIEW_PLANS_PUB dependencies on PA_FIN_VP_AMTS_VIEW_TMP

Line 683: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;

679: -- G_FP_ALL_VERSION_NAME
680: -- G_FP_ALL_VERSION_NUMBER
681: --hr_utility.trace('calling view_plan_temp_tables');
682: -- delete residual data in the temp tables
683: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;
684: DELETE from PA_FIN_VP_PDS_VIEW_TMP;
685: pa_fp_view_plans_pub.view_plan_temp_tables
686: (p_project_id => l_project_id,
687: p_budget_version_id => p_orgfcst_version_id,

Line 724: DELETE FROM pa_fin_vp_amts_view_tmp

720: bv.resource_list_id = rl.resource_list_id;
721:
722:
723: IF l_uncategorized_flag = 'Y' THEN
724: DELETE FROM pa_fin_vp_amts_view_tmp
725: WHERE project_id=l_project_id AND
726: resource_list_member_id > 0;
727:
728: DELETE FROM pa_fin_vp_pds_view_tmp tmp1

Line 1963: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;

1959: -- G_FP_ALL_VERSION_NAME
1960: -- G_FP_ALL_VERSION_NUMBER
1961: --hr_utility.trace('calling view_plan_temp_tables');
1962: -- delete residual data in the temp tables
1963: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;
1964: DELETE from PA_FIN_VP_PDS_VIEW_TMP;
1965:
1966: /* -- since we've already found the complements, we call the appropriate
1967: * global temp table populating procedures ourselves

Line 6545: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP from the

6541: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate', '500: iterated through rev pl/sql table', 1);
6542:
6543: /* TRANSFER DATA FROM PL/SQL TABLES TO GLOBAL TEMPORARY TABLES */
6544:
6545: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP from the
6546: -- COST PL/SQL table
6547: -- rows in the COST PL/SQL table
6548:
6549: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then

Line 6551: insert into pa_fin_vp_amts_view_tmp

6547: -- rows in the COST PL/SQL table
6548:
6549: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
6550: forall x in nvl(l_c_project_id.first,0)..nvl(l_c_project_id.last,-1)
6551: insert into pa_fin_vp_amts_view_tmp
6552: (project_id,
6553: task_id,
6554: resource_list_member_id,
6555: element_name,

Line 6594: insert into pa_fin_vp_amts_view_tmp

6590: l_err_stage := 800;
6591: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_separate', '600: transfer from cost pl/sql table to amts_tmp table', 1);
6592: -- rows in the REVENUE PL/SQL table
6593: forall y in nvl(l_r_project_id.first,0)..nvl(l_r_project_id.last,-1)
6594: insert into pa_fin_vp_amts_view_tmp
6595: (project_id,
6596: task_id,
6597: resource_list_member_id,
6598: element_name,

Line 6834: * Populates pa_fin_vp_amts_view_tmp assuming that both cost and revenue numbers are

6830: end pa_fp_vp_pop_tables_separate;
6831: /* ------------------------------------------------------------------ */
6832:
6833: /* PROCEDURE: pa_fp_vp_pop_tables_together
6834: * Populates pa_fin_vp_amts_view_tmp assuming that both cost and revenue numbers are
6835: * stored in same budget version
6836: */
6837: -- modified for new AMOUNT_TYPE_CODE and AMOUNT_SUBTYPE_CODE
6838: -- modified for RAW_COST logic and MARGIN calculation logic 06/20/02

Line 8009: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP

8005: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_together', '400: populated the pds pl/sql tables', 1);
8006: --hr_utility.trace('populated the pds pl/sql tables: 400');
8007:
8008: /* TRANSFER DATA FROM PL/SQL TABLES TO GLOBAL TEMPORARY TABLES */
8009: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP
8010: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
8011: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
8012: forall i in nvl(l_project_id.first,0)..nvl(l_project_id.last,-1)
8013: insert into pa_fin_vp_amts_view_tmp

Line 8013: insert into pa_fin_vp_amts_view_tmp

8009: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP
8010: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
8011: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
8012: forall i in nvl(l_project_id.first,0)..nvl(l_project_id.last,-1)
8013: insert into pa_fin_vp_amts_view_tmp
8014: (project_id,
8015: task_id,
8016: resource_list_member_id,
8017: element_name,

Line 8057: update pa_fin_vp_amts_view_tmp

8053: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_together', '500: populated the amts_tmp tables', 1);
8054: --hr_utility.trace('populated the amts_tmp table: 500');
8055:
8056: -- Bug 8868407:10394217 : Rollup margin and margin_percent to tasks and project levels.
8057: update pa_fin_vp_amts_view_tmp
8058: set margin_percent = DECODE(pa_fp_view_plans_pub.G_FP_CALC_MARGIN_FROM,
8059: 'R', DECODE(NVL(revenue,0),0,0,(revenue - raw_cost)/revenue),
8060: DECODE(NVL(revenue,0),0,0,(revenue - burdened_cost)/revenue)),
8061: margin = DECODE(pa_fp_view_plans_pub.G_FP_CALC_MARGIN_FROM,

Line 8269: * Populates pa_fin_vp_amts_view_tmp assuming that only one budget version

8265: end pa_fp_vp_pop_tables_together;
8266: /* ------------------------------------------------------------- */
8267:
8268: /* PROCEDURE: pa_fp_vp_pop_tables_single
8269: * Populates pa_fin_vp_amts_view_tmp assuming that only one budget version
8270: * (either COST_ONLY or REVENUE_ONLY) is supplied
8271: */
8272: -- modified for new AMOUNT_TYPE_CODE and AMOUNT_SUBTYPE_CODE
8273: -- modified for logic for RAW_COST and MARGIN 06/20/02

Line 9394: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP

9390: end if; --pa_fp_view_plans_pub.G_AMT_OR_PD = 'P'
9391: l_err_stage := 400;
9392: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_single', '400: COST version - FINISHED populating amts pl/sql tables', 1);
9393:
9394: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP
9395: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
9396: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
9397: forall i in nvl(l_project_id.first,0)..nvl(l_project_id.last,-1)
9398: insert into pa_fin_vp_amts_view_tmp

Line 9398: insert into pa_fin_vp_amts_view_tmp

9394: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP
9395: -- ONLY if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
9396: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
9397: forall i in nvl(l_project_id.first,0)..nvl(l_project_id.last,-1)
9398: insert into pa_fin_vp_amts_view_tmp
9399: (project_id,
9400: task_id,
9401: resource_list_member_id,
9402: element_name,

Line 10333: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP

10329: l_err_stage:= 900;
10330: pa_debug.write('pa_fp_view_plans_pub.pa_fp_vp_pop_tables_single', '600: REVENUE version - FINISHED populating amts pl/sql tables', 1);
10331: --hr_utility.trace('finished populating amts pl/sql tables: 600');
10332:
10333: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP
10334: -- only if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
10335: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
10336: forall i in nvl(l_project_id.first,0)..nvl(l_project_id.last,-1)
10337: insert into pa_fin_vp_amts_view_tmp

Line 10337: insert into pa_fin_vp_amts_view_tmp

10333: -- POPULATE global temporary table PA_FIN_VP_AMTS_VIEW_TMP
10334: -- only if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A'
10335: if pa_fp_view_plans_pub.G_AMT_OR_PD = 'A' then
10336: forall i in nvl(l_project_id.first,0)..nvl(l_project_id.last,-1)
10337: insert into pa_fin_vp_amts_view_tmp
10338: (project_id,
10339: task_id,
10340: resource_list_member_id,
10341: element_name,