DBA Data[Home] [Help]

APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_PROGRESS_UTILS

Line 115: SELECT prog.actual_finish_date, pa_progress_utils.Check_object_has_prog(

111: and a.project_id = b.project_id
112: and a.project_id = p_project_id;
113:
114: CURSOR C_Progress_Exists(p_project_id IN NUMBER, p_task_id IN NUMBER, p_resource_assignment_id IN NUMBER) IS
115: SELECT prog.actual_finish_date, pa_progress_utils.Check_object_has_prog(
116: p_project_id,
117: p_task_id,
118: p_resource_assignment_id,
119: 'PA_ASSIGNMENTS',

Line 1047: IF 'Y' = pa_progress_utils.check_prog_exists_and_delete(

1043: * If progress has been applied for this task assignment, then set
1044: * l_prog_resource_assignment_id to l_resource_assignment_id_tbl(i)
1045: * for later validations to kick in.
1046: */
1047: IF 'Y' = pa_progress_utils.check_prog_exists_and_delete(
1048: p_project_id => l_project_id,
1049: p_task_id => l_d_task_id,
1050: p_object_type => 'PA_ASSIGNMENTS',
1051: p_object_id => p_task_assignment_periods_in(i).resource_list_member_id,

Line 1064: IF 'Y' = pa_progress_utils.check_prog_exists_and_delete(

1060: * If progress has been applied for this task assignment, then set
1061: * l_prog_resource_assignment_id to l_resource_assignment_id_tbl(i)
1062: * for later validations to kick in.
1063: */
1064: IF 'Y' = pa_progress_utils.check_prog_exists_and_delete(
1065: p_project_id => l_project_id,
1066: p_task_id => l_d_task_id,
1067: p_object_type => 'PA_ASSIGNMENTS',
1068: p_object_id => p_task_assignment_periods_in(i).resource_list_member_id,

Line 2142: PA_PROGRESS_UTILS.Check_Prog_Exists_And_Delete

2138: pa_proj_element_versions pev,
2139: pa_proj_elem_ver_schedule pevs
2140: WHERE
2141: ra_old.budget_version_id = old_budget_version_id AND
2142: PA_PROGRESS_UTILS.Check_Prog_Exists_And_Delete
2143: (
2144: ra_old.project_id,
2145: ra_old.task_id,
2146: 'PA_ASSIGNMENTS',