APPS.PA_PROJECTS_MAINT_PVT dependencies on PA_TASKS

Line 4223: from pa_tasks

4219:
4220: cursor get_min_task_start_date
4221: IS
4222: select min(start_date) task_start_date
4223: from pa_tasks
4224: where project_id = p_project_id
4225: and start_date is not null;
4226:
4227: cursor get_max_task_completion_date

Line 4230: from pa_tasks

4226:
4227: cursor get_max_task_completion_date
4228: IS
4229: select max(completion_date) task_completion_date
4230: from pa_tasks
4231: where project_id = p_project_id
4232: and completion_date is not null;
4233:
4234: l_min_task_start_date pa_tasks.start_date%TYPE;

Line 4234: l_min_task_start_date pa_tasks.start_date%TYPE;

4230: from pa_tasks
4231: where project_id = p_project_id
4232: and completion_date is not null;
4233:
4234: l_min_task_start_date pa_tasks.start_date%TYPE;
4235: l_max_task_completion_date pa_tasks.completion_date%TYPE;
4236: l_start_date_error BOOLEAN := FALSE;
4237: l_completion_date_error BOOLEAN := FALSE;
4238: l_distribution_rule pa_project_type_distributions.distribution_rule%TYPE;

Line 4235: l_max_task_completion_date pa_tasks.completion_date%TYPE;

4231: where project_id = p_project_id
4232: and completion_date is not null;
4233:
4234: l_min_task_start_date pa_tasks.start_date%TYPE;
4235: l_max_task_completion_date pa_tasks.completion_date%TYPE;
4236: l_start_date_error BOOLEAN := FALSE;
4237: l_completion_date_error BOOLEAN := FALSE;
4238: l_distribution_rule pa_project_type_distributions.distribution_rule%TYPE;
4239: l_billable_capitalizable_flag pa_work_types_vl.billable_capitalizable_flag%TYPE;

Line 4845: -- Update PA_TASKS with project type values

4841:
4842: --Federal changes by sunkalya.Bug#5511353.
4843:
4844:
4845: -- Update PA_TASKS with project type values
4846: OPEN get_billable_cap_flag(l_project_type_rec.work_type_id);
4847: FETCH get_billable_cap_flag INTO l_billable_capitalizable_flag;
4848: CLOSE get_billable_cap_flag;
4849:

Line 4850: UPDATE pa_tasks

4846: OPEN get_billable_cap_flag(l_project_type_rec.work_type_id);
4847: FETCH get_billable_cap_flag INTO l_billable_capitalizable_flag;
4848: CLOSE get_billable_cap_flag;
4849:
4850: UPDATE pa_tasks
4851: SET work_type_id = l_project_type_rec.work_type_id,
4852: billable_flag = decode(NVL(PA_INSTALL.is_prm_licensed(),'N'), 'Y', l_billable_capitalizable_flag, 'N', billable_flag), /* added decode for bug#3481807 */
4853: emp_bill_rate_schedule_id = l_project_type_rec.emp_bill_rate_schedule_id,
4854: job_bill_rate_schedule_id = l_project_type_rec.job_bill_rate_schedule_id,