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_ROLLUP_PKG dependencies on PA_BUDGET_VERSIONS

Line 99: FROM pa_budget_versions pbv

95: INTO x_resource_list_id
96: ,x_uncat_flag
97: ,x_rl_group_type_id
98: ,x_project_id
99: FROM pa_budget_versions pbv
100: ,pa_resource_lists prl
101: WHERE budget_version_id = p_budget_version_id
102: AND pbv.resource_list_id = prl.resource_list_id; /* M21-AUG: Join was missing */
103:

Line 194: PROCEDURE INSERT_PARENT_REC_TMP(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

190: based on the Level of the records being inserted (i.e Resource Group level, Task level and Parent
191: Task level) for rollup of amounts into the Denorm table. This procedure is called from
192: Refresh_Period_Denorm and Insert_Parent_Rec_Tmp.
193: =================================================================================================*/
194: PROCEDURE INSERT_PARENT_REC_TMP(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
195: ,PX_INSERTING_RES_GROUP_LEVEL IN OUT NOCOPY boolean --File.Sql.39 bug 4440895
196: ,PX_INSERTING_TASK_LEVEL IN OUT NOCOPY boolean --File.Sql.39 bug 4440895
197: ,PX_INSERTING_PARENT_TASK_LEVEL IN OUT NOCOPY boolean --File.Sql.39 bug 4440895
198: ,p_curr_rollup_level IN NUMBER) IS

Line 340: pa_resource_assignments, PA_PROJ_PERIODS_DENORM and pa_budget_versions_tables.

336: END Insert_Parent_Rec_Tmp;
337:
338: /*====================================================================================================
339: ROLLUP_BUDGET_VERSION: This is the main API which will do whatever necessary for doing rollup into
340: pa_resource_assignments, PA_PROJ_PERIODS_DENORM and pa_budget_versions_tables.
341:
342:
343: r11.5 FP.M Developement ----------------------------------
344:

Line 353: b) pa_resource_assignments to pa_budget_versions

349:
350:
351: - Replaced pre-M rollup logic with two-level rollup:
352: a) pa_budget_lines to pa_resource_assignments
353: b) pa_resource_assignments to pa_budget_versions
354:
355: - For p_entire_version = 'N', gutted all logic for
356: this condition. All logic was obsolete.
357:

Line 400: l_period_profile_id PA_BUDGET_VERSIONS.PERIOD_PROFILE_ID%TYPE;

396: l_quantity_tbl l_quantity_tbl_typ;
397: l_uom_tbl l_unit_of_measure_tbl_typ;
398: l_ra_id_tbl l_ra_id_tbl_typ;
399:
400: l_period_profile_id PA_BUDGET_VERSIONS.PERIOD_PROFILE_ID%TYPE;
401:
402: l_msg_count NUMBER := 0;
403: l_data VARCHAR2(2000);
404: l_msg_data VARCHAR2(2000);

Line 515: FROM PA_BUDGET_VERSIONS

511:
512:
513: SELECT PERIOD_PROFILE_ID
514: INTO l_period_profile_id
515: FROM PA_BUDGET_VERSIONS
516: WHERE budget_version_id = p_budget_version_id;
517:
518:
519: IF (p_entire_version = 'Y') THEN

Line 586: FROM pa_budget_versions v

582:
583: BEGIN
584: SELECT org_project_flag
585: INTO l_org_forecast_flag
586: FROM pa_budget_versions v
587: , pa_projects_all p
588: , pa_project_types_all pt
589: WHERE v.budget_version_id = p_budget_version_id
590: AND v.project_id = p.project_id

Line 665: in pa_budget_versions. */

661: END IF;
662:
663: /* #2593261: Added the total_plan_quantity column which was missed out
664: earlier, because of which labor_quantity was not being updated
665: in pa_budget_versions. */
666:
667:
668: /* Opening a cursor to get the project levee amounts. */
669:

Line 710: UPDATE pa_budget_versions

706: END IF;
707:
708: -- Bug 3441943, 18-FEB-2004: New Vars for people (labor) and equipment quantities ------------
709:
710: UPDATE pa_budget_versions
711: SET raw_cost = l_projfunc_raw_cost
712: ,burdened_cost = l_projfunc_burdened_cost
713: ,revenue = l_projfunc_revenue
714: ,total_project_raw_cost = l_proj_raw_cost

Line 2033: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;

2029: l_unit_of_measure_tbl l_unit_of_measure_tbl_typ;
2030:
2031: /* Declare the local variables. to get the values of OUT parameters. */
2032:
2033: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
2034: l_resource_list_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;
2035: l_uncat_flag pa_resource_lists.UNCATEGORIZED_FLAG%TYPE;
2036: l_rl_group_type_id pa_resource_lists.GROUP_RESOURCE_TYPE_ID%TYPE;
2037: l_uncat_rlm_id pa_resource_lists.RESOURCE_LIST_ID%TYPE;

Line 2116: FROM pa_budget_versions

2112: END IF;
2113:
2114: SELECT period_profile_id
2115: INTO l_period_profile_id
2116: FROM pa_budget_versions
2117: WHERE budget_version_id = p_budget_version_id;
2118:
2119: pa_debug.g_err_stage := 'period profile id = ' || l_period_profile_id ;
2120: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3687: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

3683: l_project_id pa_projects.project_id%TYPE;
3684: l_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;
3685: l_proj_currency_code pa_projects_all.project_currency_code%TYPE;
3686:
3687: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
3688:
3689: l_curr_rollup_level NUMBER := 0;
3690:
3691: L_INSERTING_RES_GROUP_LEVEL boolean := false;

Line 3770: FROM pa_budget_versions

3766:
3767:
3768: SELECT period_profile_id
3769: INTO l_period_profile_id
3770: FROM pa_budget_versions
3771: WHERE budget_version_id = p_budget_version_id;
3772:
3773: pa_debug.g_err_stage := 'period profile id = ' || l_period_profile_id ;
3774: IF P_PA_DEBUG_MODE = 'Y' THEN