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_FIN_PLAN_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 913: from pa_resource_assignments

909: set start_date= v_project_start_date,
910: end_date = v_project_completion_date
911: where resource_assignment_id in
912: (select resource_assignment_id
913: from pa_resource_assignments
914: where budget_version_id = l_target_version_id)
915: and ((start_date <> v_project_start_date) OR (end_date <> v_project_completion_date));
916:
917: -- Check that rows should be updated only if the project start or end

Line 931: from pa_tasks t ,pa_resource_assignments r

927:
928: for bl_rec in (select start_date,
929: completion_date ,
930: resource_assignment_id
931: from pa_tasks t ,pa_resource_assignments r
932: where t.task_id = r.task_id and
933: r.budget_version_id = l_target_version_id)
934: loop
935: bl_rec.start_date := nvl(bl_rec.start_date,v_project_start_date);

Line 2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;

2176: l_created_version_id pa_budget_versions.budget_version_id%TYPE;
2177: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
2181: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
2182: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
2183:
2184: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab; /* Included for bug 2672654 */

Line 2182: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

2178: l_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2179:
2180: l_uncat_rlmid pa_resource_assignments.resource_list_member_id%TYPE;
2181: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
2182: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
2183:
2184: l_ci_rec_tab pa_fin_plan_pvt.ci_rec_tab; /* Included for bug 2672654 */
2185:
2186: -- Bug Fix: 4569365. Removed MRC code.

Line 2736: l_dummy_ra_id PA_RESOURCE_ASSIGNMENTS.resource_assignment_id%TYPE;

2732:
2733: DECLARE
2734: l_dummy_res_list_id PA_RESOURCE_LISTS_ALL_BG.resource_list_id%TYPE;
2735: l_dummy_row_id ROWID;
2736: l_dummy_ra_id PA_RESOURCE_ASSIGNMENTS.resource_assignment_id%TYPE;
2737: BEGIN
2738:
2739: PA_FIN_PLAN_UTILS.Get_Uncat_Resource_List_Info
2740: (x_resource_list_id => l_dummy_res_list_id

Line 2772: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';

2768: x_msg_count => x_msg_count,
2769: x_msg_data => x_msg_data);
2770:
2771: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2772: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
2773: IF P_PA_DEBUG_MODE = 'Y' THEN
2774: pa_debug.write('CREATE_DRAFT: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2775: END IF;
2776: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2909: pa_resource_assignments, pa_budget_lines, pa_mc_budget_lines and also takes

2905: END CREATE_DRAFT;
2906:
2907: /*
2908: This procedure would use the input budget_line_tbl to insert records into
2909: pa_resource_assignments, pa_budget_lines, pa_mc_budget_lines and also takes
2910: care of rolling up the resource assignments and maintaining the denorm table.
2911: */
2912: PROCEDURE CREATE_FINPLAN_LINES
2913: ( -- Bug Fix: 4569365. Removed MRC code.

Line 3673: FROM pa_resource_assignments pra

3669: -- Bug 15861188 : added following update statement
3670: UPDATE PA_FP_SPREAD_CALC_TMP1 cache
3671: SET (cache.start_date ,cache.end_date) =
3672: (select planning_start_date,planning_end_date
3673: FROM pa_resource_assignments pra
3674: where pra.resource_assignment_id = cache.resource_assignment_id )
3675: where cache.budget_version_id = p_fin_plan_version_id
3676: AND cache.start_date IS NULL
3677: AND cache.end_date IS NULL;

Line 3679: update pa_resource_assignments pra

3675: where cache.budget_version_id = p_fin_plan_version_id
3676: AND cache.start_date IS NULL
3677: AND cache.end_date IS NULL;
3678:
3679: update pa_resource_assignments pra
3680: set (planning_start_date, planning_end_date)
3681: = (select nvl(tmp.start_date, planning_start_date),
3682: nvl(tmp.end_date, planning_end_date)
3683: from pa_fp_spread_calc_tmp1 tmp

Line 3688: update pa_resource_assignments pra

3684: where tmp.resource_assignment_id = pra.resource_assignment_id)
3685: where pra.budget_version_id = p_fin_plan_version_id;
3686:
3687: ELSE
3688: update pa_resource_assignments pra
3689: set (planning_start_date, planning_end_date)
3690: = (select decode(min(pbl.start_date),NULL,
3691: nvl(min(tmp.start_date), planning_start_date),
3692: least(nvl(min(tmp.start_date), planning_start_date),

Line 3701: update pa_resource_assignments pra

3697: and pbl.resource_assignment_id (+)= tmp.resource_assignment_id)
3698: where pra.budget_version_id = p_fin_plan_version_id;
3699: END IF;
3700: --bug#14089767 Making sure that sp_fixed_date is in sync with the corresponding planning_start_date for Fixed Date spread curve
3701: update pa_resource_assignments pra
3702: set pra.sp_fixed_date = pra.planning_start_date
3703: where pra.budget_version_id = p_fin_plan_version_id
3704: and pra.spread_curve_id = 6;
3705: ELSE

Line 3706: update pa_resource_assignments pra

3702: set pra.sp_fixed_date = pra.planning_start_date
3703: where pra.budget_version_id = p_fin_plan_version_id
3704: and pra.spread_curve_id = 6;
3705: ELSE
3706: update pa_resource_assignments pra
3707: set (planning_start_date, planning_end_date)
3708: = (select nvl(min(start_date), planning_start_date),
3709: nvl(max(end_date), planning_end_date)
3710: from pa_fp_spread_calc_tmp1 tmp /* Bug 4221590 */