APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_TASKS

Line 224: l_own_task_id pa_tasks.task_id%TYPE;

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

Line 358: FROM pa_tasks

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

Line 1131: UPDATE pa_tasks

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

Line 1287: UPDATE pa_tasks

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

Line 1786: UPDATE pa_tasks

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

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

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

Line 4362: ,pa_tasks source_tasks

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

Line 4363: ,pa_tasks target_tasks

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

Line 4680: FROM pa_tasks t

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