eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DELIVERABLE_PVT dependencies on PA_PROGRESS_UTILS

Line 2345: IF nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(p_project_id,p_dlv_element_id),'N') = 'Y' THEN

2341: -- Bug 3651781 While deleting association between a deliverable based task and a deliverable ,we have to
2342: -- Look for 'PUBLISHED' progress records ,NOT mere existence of progress records
2343:
2344: -- IF nvl(PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(p_project_id,p_dlv_element_id),'N') = 'Y' THEN
2345: IF nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(p_project_id,p_dlv_element_id),'N') = 'Y' THEN
2346: IF p_calling_context = 'TASKS' THEN -- Bug 3555460 Calling context newly introduced
2347: PA_UTILS.ADD_MESSAGE('PA','PA_TASK_PROGRESS_NO_DISASCN') ;
2348: ELSIF p_calling_context = 'DELIVERABLES' THEN
2349: PA_UTILS.ADD_MESSAGE('PA','PA_DLV_PROGRESS_NO_DISASCN') ;

Line 3227: OR nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , pev.proj_element_id),'N') = 'Y'

3223: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(pev.element_version_id),'N') = 'Y'
3224: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(pev.element_version_id),'N') = 'Y'
3225: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(pev.proj_element_id) = 'BILLING'
3226: -- OR nvl(PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(c_project_id,pev.proj_element_id),'N') = 'Y' Commented for 3651781
3227: OR nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , pev.proj_element_id),'N') = 'Y'
3228: )
3229: );
3230: */
3231:

Line 3252: and nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , obj1.object_id_to2),'N') = 'Y');

3248: AND obj1.object_id_from2 = ppe.proj_element_id
3249: and ppe.type_id = ptt.task_type_id
3250: and ppe.object_type = 'PA_TASKS'
3251: and nvl(ppe.base_percent_comp_deriv_code,ptt.base_percent_comp_deriv_code) = 'DELIVERABLE'
3252: and nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , obj1.object_id_to2),'N') = 'Y');
3253:
3254: -- 3899363 end
3255:
3256: BEGIN

Line 3460: OR nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , pev.proj_element_id),'N') = 'Y'

3456: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(pev.element_version_id),'N') = 'Y'
3457: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(pev.element_version_id),'N') = 'Y'
3458: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(pev.element_version_id),'N') = 'Y'
3459: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(pev.proj_element_id) = 'BILLING'
3460: OR nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , pev.proj_element_id),'N') = 'Y'
3461: )
3462: );
3463: */
3464:

Line 3487: and nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , obj1.object_id_to2),'N') = 'Y');

3483: AND obj1.relationship_type = 'A'
3484: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'
3485: AND obj1.object_type_from = 'PA_TASKS'
3486: AND obj1.object_type_to = 'PA_DELIVERABLES'
3487: and nvl(PA_PROGRESS_UTILS.published_dlv_prog_exists(c_project_id , obj1.object_id_to2),'N') = 'Y');
3488:
3489: -- 3899363 end
3490:
3491: BEGIN