[Home] [Help]
678: -- G_FP_ALL_VERSION_ID (may be set already, if user-entered)
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,
1958: -- G_FP_ALL_VERSION_ID (may be set already, if user-entered)
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
3987: 'PROJFUNC', 'PROJ_FUNCTIONAL',
3988: 'PROJ', 'PROJECT',
3989: 'TRANSACTION')
3990: into l_currency_type
3991: from dual;
3992:
3993: pa_fp_view_plans_pub.G_FP_REV_VERSION_ID := p_rev_budget_version_id;
3994: pa_fp_view_plans_pub.G_FP_COST_VERSION_ID := p_cost_budget_version_id;
3995: pa_fp_view_plans_pub.G_DISPLAY_FROM := 'BOTH';
4131: l_c_row_level(l_inc_count),
4132: l_c_parent_element_name(l_inc_count),
4133: l_c_unit_of_measure(l_inc_count),
4134: l_c_has_child_element(l_inc_count)
4135: from dual;
4136:
4137:
4138: /* Now loop through all the resource assignments fetched and insert the parent record if its not found or rollup the amounts if its found -- COST*/
4139: for i in 1..l_loop_count loop
4224: l_c_row_level(l_inc_count),
4225: l_c_parent_element_name(l_inc_count),
4226: l_c_unit_of_measure(l_inc_count),
4227: l_c_has_child_element(l_inc_count)
4228: from dual;
4229: end if;
4230:
4231: end loop;
4232:
4300: l_r_row_level(l_inc_count),
4301: l_r_parent_element_name(l_inc_count),
4302: l_r_unit_of_measure(l_inc_count),
4303: l_r_has_child_element(l_inc_count)
4304: from dual;
4305:
4306:
4307: /* Now loop through all the resource assignments fetched and insert the parent record if its not found or rollup the amounts if its found -- REVENUE*/
4308: for i in 1..l_loop_count loop
4395: l_r_row_level(l_inc_count),
4396: l_r_parent_element_name(l_inc_count),
4397: l_r_unit_of_measure(l_inc_count),
4398: l_r_has_child_element(l_inc_count)
4399: from dual;
4400: end if;
4401:
4402: end loop;
4403:
7065: 'PROJFUNC', 'PROJ_FUNCTIONAL',
7066: 'PROJ', 'PROJECT',
7067: 'TRANSACTION')
7068: into l_currency_type
7069: from dual;
7070:
7071: -- this is for populating PERIODS PL/SQL table
7072: l_row_number := 0;
7073: select NVL(po.report_labor_hrs_from_code, 'COST'),
7200: l_row_level(l_inc_count),
7201: l_parent_element_name(l_inc_count),
7202: l_unit_of_measure(l_inc_count),
7203: l_has_child_element(l_inc_count)
7204: from dual;
7205:
7206:
7207: /* Now loop through all the resource assignments fetched and insert the parent record if its not found or rollup the amounts if its found */
7208: for i in 1..l_loop_count loop
7291: l_row_level(l_inc_count),
7292: l_parent_element_name(l_inc_count),
7293: l_unit_of_measure(l_inc_count),
7294: l_has_child_element(l_inc_count)
7295: from dual;
7296: end if;
7297:
7298: end loop;
7299:
8538: 'PROJFUNC', 'PROJ_FUNCTIONAL',
8539: 'PROJ', 'PROJECT',
8540: 'TRANSACTION')
8541: into l_currency_type
8542: from dual;
8543:
8544: -- this is for populating PERIODS PL/SQL table
8545: l_row_number := 0;
8546: select NVL(po.report_labor_hrs_from_code, 'COST'),
8676: l_row_level(l_inc_count),
8677: l_parent_element_name(l_inc_count),
8678: l_unit_of_measure(l_inc_count),
8679: l_has_child_element(l_inc_count)
8680: from dual;
8681:
8682:
8683: /* Now loop through all the resource assignments fetched and insert the parent record if its not found or rollup the amounts if its found */
8684: for i in 1..l_loop_count loop
8767: l_row_level(l_inc_count),
8768: l_parent_element_name(l_inc_count),
8769: l_unit_of_measure(l_inc_count),
8770: l_has_child_element(l_inc_count)
8771: from dual;
8772: end if;
8773:
8774: end loop;
8775:
9735: l_row_level(l_inc_count),
9736: l_parent_element_name(l_inc_count),
9737: l_unit_of_measure(l_inc_count),
9738: l_has_child_element(l_inc_count)
9739: from dual;
9740:
9741: /* Now loop through all the resource assignments fetched and insert the parent record if its not found or rollup the amounts if its found */
9742: for i in 1..l_loop_count loop
9743: /* rolling up the project level amounts */
9822: l_row_level(l_inc_count),
9823: l_parent_element_name(l_inc_count),
9824: l_unit_of_measure(l_inc_count),
9825: l_has_child_element(l_inc_count)
9826: from dual;
9827: end if;
9828:
9829: end loop;
9830:
10615: ra.task_id <> 0 and
10616: ra.task_id = t.task_id and
10617: t.parent_task_id is null);
10618: */
10619: select 1 from dual where exists (
10620: select ra.task_id -- doesn't matter what we select here
10621: from pa_resource_assignments ra
10622: where ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2)
10623: and (
10642: not (ra.resource_list_member_id in (0,pa_fp_view_plans_pub.Get_Uncat_Res_List_Member_Id))) or
10643: (ra.budget_version_id in (p_budget_version_id1, p_budget_version_id2) and
10644: ra.task_id = t.task_id and t.parent_task_id = p_task_id);
10645: */
10646: select 1 from dual where exists (
10647: select ra.task_id
10648: from pa_resource_assignments ra
10649: where ra.budget_version_id in(p_budget_version_id1, p_budget_version_id2) and
10650: (