APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_TASKS

Line 225: l_own_task_id pa_tasks.task_id%TYPE;

221: l_project_name pa_projects_all.name%TYPE;
222: l_project_number pa_projects_all.segment1%TYPE;
223: l_new_project_number pa_projects_all.segment1%TYPE;
224: l_org_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
225: l_own_task_id pa_tasks.task_id%TYPE;
226: l_prob_percent pa_probability_members.probability_percentage%TYPE;
227: l_period_profile_type pa_proj_period_profiles.period_profile_type%TYPE;
228: l_pfi_assignment_id pa_forecast_items.assignment_id%TYPE;
229: l_pfi_resource_id pa_forecast_items.resource_id%TYPE;

Line 359: FROM pa_tasks

355:
356: CURSOR sub_tasks IS
357: SELECT carrying_out_organization_id,
358: task_id
359: FROM pa_tasks
360: WHERE project_id = l_project_id;
361:
362: /* Transfer Price Logic as part of Select statement:
363:

Line 1132: UPDATE pa_tasks

1128:
1129: IF l_task_organization_id <> l_organization_id THEN
1130: l_stage := 2400;
1131: -- hr_utility.trace(to_char(l_stage));
1132: UPDATE pa_tasks
1133: SET carrying_out_organization_id = l_organization_id
1134: WHERE project_id = l_project_id
1135: AND task_id = l_own_task_id;
1136: END IF;

Line 1288: UPDATE pa_tasks

1284:
1285: IF l_task_organization_id <> l_organization_id THEN
1286: l_stage := 2800;
1287: -- hr_utility.trace(to_char(l_stage));
1288: UPDATE pa_tasks
1289: SET carrying_out_organization_id = l_organization_id
1290: WHERE project_id = l_project_id
1291: AND task_id = l_own_task_id;
1292: END IF;

Line 1787: UPDATE pa_tasks

1783:
1784: IF l_task_organization_id <> l_organization_id THEN
1785: l_stage := 4100;
1786: -- hr_utility.trace(to_char(l_stage));
1787: UPDATE pa_tasks
1788: SET carrying_out_organization_id = l_organization_id
1789: WHERE project_id = l_project_id
1790: AND task_id = l_own_task_id;
1791: END IF;

Line 4344: -- Reference to pa_tasks is changed to pa_struct_task_wbs_v (bug 3354518)

4340: OR pra.total_plan_burdened_cost IS NOT NULL
4341: OR pra.total_plan_revenue IS NOT NULL);
4342: ***/
4343: -- cursor diferent_projects_cur is going to be used when the source and target projects are different
4344: -- Reference to pa_tasks is changed to pa_struct_task_wbs_v (bug 3354518)
4345:
4346: CURSOR different_projects_task_cur IS
4347: SELECT pra.resource_assignment_id -- SOURCE_RES_ASSIGNMENT_ID
4348: ,pa_resource_assignments_s.nextval -- TARGET_RES_ASSIGNMENT_ID

Line 4363: ,pa_tasks source_tasks

4359: ,pra.planning_start_date + l_shift_days -- SCHEDULE_START_DATE
4360: ,pra.planning_end_date + l_shift_days -- SCHEDULE_END_DATE
4361: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4362: FROM pa_resource_assignments pra
4363: ,pa_tasks source_tasks
4364: ,pa_tasks target_tasks
4365: ,pa_resource_list_members source_rlm -- bug 3615617
4366: ,pa_resource_list_members target_rlm -- bug 3615617
4367: WHERE pra.budget_version_id = p_source_plan_version_id

Line 4364: ,pa_tasks target_tasks

4360: ,pra.planning_end_date + l_shift_days -- SCHEDULE_END_DATE
4361: ,target_rlm.resource_list_member_id -- bug 3615617 TARGET_RLM_ID
4362: FROM pa_resource_assignments pra
4363: ,pa_tasks source_tasks
4364: ,pa_tasks target_tasks
4365: ,pa_resource_list_members source_rlm -- bug 3615617
4366: ,pa_resource_list_members target_rlm -- bug 3615617
4367: WHERE pra.budget_version_id = p_source_plan_version_id
4368: AND pra.project_id = p_source_project_id --bug#2708524

Line 4681: FROM pa_tasks t

4677: END IF;
4678:
4679: SELECt min(t.start_date)
4680: INTO l_start_date
4681: FROM pa_tasks t
4682: WHERE t.project_id = l_source_project_id;
4683:
4684: IF l_start_date is NULL THEN
4685: