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 231: IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id_FP) = 'N')

227: l_debug_level3);
228: END IF;
229:
230: -- Check for FP TASK to be lowest
231: IF (PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id_FP) = 'N')
232: THEN
233: --Raise en error and populate message
234: x_error_message_code := 'PA_PS_NOT_LOWEST_FINTASK';
235: x_return_status := FND_API.G_RET_STS_ERROR;

Line 386: l_task_name pa_proj_elements.name%TYPE;

382: ( p_task_version_id IN NUMBER
383: ) RETURN VARCHAR2
384: IS
385:
386: l_task_name pa_proj_elements.name%TYPE;
387:
388: CURSOR c_get_task_name IS
389: SELECT projelem.name
390: FROM pa_proj_elements projelem

Line 390: FROM pa_proj_elements projelem

386: l_task_name pa_proj_elements.name%TYPE;
387:
388: CURSOR c_get_task_name IS
389: SELECT projelem.name
390: FROM pa_proj_elements projelem
391: , pa_proj_element_versions elemver
392: WHERE elemver.element_version_id = p_task_version_id
393: AND elemver.proj_element_id = projelem.proj_element_id
394: AND elemver.object_type = 'PA_TASKS'

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

468: LOOP
469: select proj_element_id into l_proj_element_id
470: from pa_proj_element_versions
471: where element_version_id = l_c1rec.object_id_to1;
472: if (PA_PROJ_ELEMENTS_UTILS.CHECK_IS_FINANCIAL_TASK(l_proj_element_id) = 'Y') then
473: l_mapped_fin_task_version_id := l_c1rec.object_id_to1;
474: end if;
475: if l_mapped_fin_task_version_id IS NOT NULL then
476: EXIT;

Line 512: l_mapped_fin_task_name pa_proj_elements.name%TYPE; --Bug8443049:BIG WORDS DO NOT APPEAR IN THE FIELD FINANCIAL TASK MAPPED IN WBS

508: (p_element_version_id IN NUMBER
509: ,p_structure_sharing_code IN VARCHAR2) RETURN VARCHAR2
510: IS
511: l_mapped_fin_task_version_id NUMBER;
512: l_mapped_fin_task_name pa_proj_elements.name%TYPE; --Bug8443049:BIG WORDS DO NOT APPEAR IN THE FIELD FINANCIAL TASK MAPPED IN WBS
513: BEGIN
514: l_mapped_fin_task_version_id := GET_MAPPED_FIN_TASK_VERSION_ID(p_element_version_id,p_structure_sharing_code);
515: l_mapped_fin_task_name := GET_TASK_NAME_FROM_VERSION(l_mapped_fin_task_version_id);
516: return (l_mapped_fin_task_name);

Line 551: pa_proj_elements ppe,

547: IS
548: CURSOR C_get_mapped_wkp_task_names IS
549: select ppe.name
550: from
551: pa_proj_elements ppe,
552: pa_proj_element_versions ppev,
553: pa_object_relationships por_mapping
554: where
555: ppe.proj_element_id=ppev.proj_element_id

Line 599: pa_proj_elements ppe,

595: IS
596: CURSOR C_get_mapped_wkp_task_Ids IS
597: select ppe.proj_element_id
598: from
599: pa_proj_elements ppe,
600: pa_proj_element_versions ppev,
601: pa_object_relationships por_mapping
602: where
603: ppe.proj_element_id=ppev.proj_element_id

Line 646: pa_proj_elements ppe,

642: IS
643: CURSOR C_get_mapped_fin_task_Id IS
644: select ppe.proj_element_id
645: from
646: pa_proj_elements ppe,
647: pa_proj_element_versions ppev,
648: pa_object_relationships por_mapping
649: where
650: ppe.proj_element_id=ppev.proj_element_id

Line 689: pa_proj_elements ppe,

685: IS
686: CURSOR C_get_mapped_fin_task_name IS
687: select ppe.name
688: from
689: pa_proj_elements ppe,
690: pa_proj_element_versions ppev,
691: pa_object_relationships por_mapping
692: where
693: ppe.proj_element_id=ppev.proj_element_id