[Home] [Help]
607: -- G_FP_ALL_VERSION_ID (may be set already, if user-entered)
608: -- G_FP_ALL_VERSION_NAME
609: -- G_FP_ALL_VERSION_NUMBER
610: --hr_utility.trace('calling view_plan_temp_tables');
611: -- delete residual data in the temp tables
612: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;
613: DELETE from PA_FIN_VP_PDS_VIEW_TMP;
614: pa_fp_view_plans_pub.view_plan_temp_tables
615: (p_project_id => l_project_id,
1847: -- G_FP_ALL_VERSION_ID (may be set already, if user-entered)
1848: -- G_FP_ALL_VERSION_NAME
1849: -- G_FP_ALL_VERSION_NUMBER
1850: --hr_utility.trace('calling view_plan_temp_tables');
1851: -- delete residual data in the temp tables
1852: DELETE from PA_FIN_VP_AMTS_VIEW_TMP;
1853: DELETE from PA_FIN_VP_PDS_VIEW_TMP;
1854:
1855: /* -- since we've already found the complements, we call the appropriate
3837: 'PROJFUNC', 'PROJ_FUNCTIONAL',
3838: 'PROJ', 'PROJECT',
3839: 'TRANSACTION')
3840: into l_currency_type
3841: from dual;
3842:
3843: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_rev_budget_version_id;
3844: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_cost_budget_version_id;
3845: pa_fp_view_plans_pub.G_DISPLAY_FROM := 'BOTH';
6416: 'PROJFUNC', 'PROJ_FUNCTIONAL',
6417: 'PROJ', 'PROJECT',
6418: 'TRANSACTION')
6419: into l_currency_type
6420: from dual;
6421:
6422: -- this is for populating PERIODS PL/SQL table
6423: l_row_number := 0;
6424: select NVL(po.report_labor_hrs_from_code, 'COST'),
7530: 'PROJFUNC', 'PROJ_FUNCTIONAL',
7531: 'PROJ', 'PROJECT',
7532: 'TRANSACTION')
7533: into l_currency_type
7534: from dual;
7535:
7536: -- this is for populating PERIODS PL/SQL table
7537: l_row_number := 0;
7538: select NVL(po.report_labor_hrs_from_code, 'COST'),
9006: ra.task_id <> 0 and
9007: ra.task_id = t.task_id and
9008: t.parent_task_id is null);
9009: */
9010: select 1 from dual where exists (
9011: select ra.task_id -- doesn't matter what we select here
9012: from pa_resource_assignments ra
9013: where ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2)
9014: and (
9033: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or
9034: (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and
9035: ra.task_id = t.task_id and t.parent_task_id = p_task_id);
9036: */
9037: select 1 from dual where exists (
9038: select ra.task_id
9039: from pa_resource_assignments ra
9040: where ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
9041: (