APPS.PA_PROJ_STRUC_MAPPING_UTILS dependencies on PA_PROJ_ELEMENTS

Line 72: IF (Pa_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_proj_element_id) <> 'Y') THEN

68: -- Checking mapping exists
69: -- Check whether the task id passed is Financial Task or WorkPlan Task
70: -- This is done additionally so that this API can also be called for Workplan task
71: IF ( p_proj_element_id IS NOT NULL AND p_project_id IS NOT NULL ) THEN
72: IF (Pa_Proj_Elements_Utils.CHECK_IS_FINANCIAL_TASK(p_proj_element_id) <> 'Y') THEN
73: return l_mapping_exists;
74: END IF;
75:
76: OPEN c_get_element_version_id;

Line 222: IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id_FP) = 'N')

218: l_debug_level3);
219: END IF;
220:
221: -- Check for FP TASK to be lowest
222: IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id_FP) = 'N')
223: THEN
224: --Raise en error and populate message
225: x_error_message_code := 'PA_PS_NOT_LOWEST_FINTASK';
226: x_return_status := FND_API.G_RET_STS_ERROR;

Line 377: l_task_name pa_proj_elements.name%TYPE;

373: ( p_task_version_id IN NUMBER
374: ) RETURN VARCHAR2
375: IS
376:
377: l_task_name pa_proj_elements.name%TYPE;
378:
379: CURSOR c_get_task_name IS
380: SELECT projelem.name
381: FROM pa_proj_elements projelem

Line 381: FROM pa_proj_elements projelem

377: l_task_name pa_proj_elements.name%TYPE;
378:
379: CURSOR c_get_task_name IS
380: SELECT projelem.name
381: FROM pa_proj_elements projelem
382: , pa_proj_element_versions elemver
383: WHERE elemver.element_version_id = p_task_version_id
384: AND elemver.proj_element_id = projelem.proj_element_id
385: AND elemver.object_type = 'PA_TASKS'

Line 463: if (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') then

459: LOOP
460: select proj_element_id into l_proj_element_id
461: from pa_proj_element_versions
462: where element_version_id = l_c1rec.object_id_to1;
463: if (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') then
464: l_mapped_fin_task_version_id := l_c1rec.object_id_to1;
465: end if;
466: if l_mapped_fin_task_version_id IS NOT NULL then
467: EXIT;

Line 542: pa_proj_elements ppe,

538: IS
539: CURSOR C_get_mapped_wkp_task_names IS
540: select ppe.name
541: from
542: pa_proj_elements ppe,
543: pa_proj_element_versions ppev,
544: pa_object_relationships por_mapping
545: where
546: ppe.proj_element_id=ppev.proj_element_id

Line 590: pa_proj_elements ppe,

586: IS
587: CURSOR C_get_mapped_wkp_task_Ids IS
588: select ppe.proj_element_id
589: from
590: pa_proj_elements ppe,
591: pa_proj_element_versions ppev,
592: pa_object_relationships por_mapping
593: where
594: ppe.proj_element_id=ppev.proj_element_id

Line 637: pa_proj_elements ppe,

633: IS
634: CURSOR C_get_mapped_fin_task_Id IS
635: select ppe.proj_element_id
636: from
637: pa_proj_elements ppe,
638: pa_proj_element_versions ppev,
639: pa_object_relationships por_mapping
640: where
641: ppe.proj_element_id=ppev.proj_element_id

Line 680: pa_proj_elements ppe,

676: IS
677: CURSOR C_get_mapped_fin_task_name IS
678: select ppe.name
679: from
680: pa_proj_elements ppe,
681: pa_proj_element_versions ppev,
682: pa_object_relationships por_mapping
683: where
684: ppe.proj_element_id=ppev.proj_element_id