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_UTILS dependencies on PA_BILLING_WRKBNCH_EVENTS

Line 673: AND nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(ver.project_id,p_dlvr_version_id,ver.element_version_id) ,'N') = 'N'

669: AND obj.object_id_to2 = ver.proj_element_id
670: AND
671: (
672: PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'BILLING'
673: AND nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(ver.project_id,p_dlvr_version_id,ver.element_version_id) ,'N') = 'N'
674: )
675: );
676:
677: l_system_status_code pa_lookups.lookup_code%TYPE ;

Line 2733: AND 'Y' = PA_Billing_Wrkbnch_Events.CHECK_BILLING_EVENT_EXISTS(p_project_id,ppe.proj_element_id)

2729: FROM pa_proj_elements ppe
2730: WHERE ppe.project_id = p_project_id
2731: AND ppe.object_type = 'PA_ACTIONS'
2732: AND PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(ppe.proj_element_id) = 'BILLING'
2733: AND 'Y' = PA_Billing_Wrkbnch_Events.CHECK_BILLING_EVENT_EXISTS(p_project_id,ppe.proj_element_id)
2734: );
2735:
2736: l_debug_mode VARCHAR2(1);
2737: l_debug_level2 CONSTANT NUMBER := 2;

Line 5956: AND nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(ver.project_id,p_dlv_version_id,ver.element_version_id),'N') = 'Y'

5952: AND obj.object_type_from = 'PA_DELIVERABLES'
5953: AND obj.object_id_to2 = ver.proj_element_id
5954: AND obj.relationship_type = 'A'
5955: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
5956: AND nvl(PA_BILLING_WRKBNCH_EVENTS.CHECK_DELV_EVENT_PROCESSED(ver.project_id,p_dlv_version_id,ver.element_version_id),'N') = 'Y'
5957: ) ;
5958: l_dummy VARCHAR2(1) := 'N' ;
5959: l_return_status VARCHAR2(1) := 'N' ;
5960: BEGIN