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 OKE_DELIVERABLE_UTILS_PUB

Line 448: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(ver.element_version_id),'N') = 'Y'

444: AND obj.object_type_from = 'PA_DELIVERABLES'
445: AND obj.object_id_to2 = ver.proj_element_id
446: AND obj.RELATIONSHIP_TYPE = 'A'
447: AND obj.RELATIONSHIP_SUBTYPE = 'DELIVERABLE_TO_ACTION'
448: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(ver.element_version_id),'N') = 'Y'
449: OR nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(ver.element_version_id),'N') = 'Y' )
450: ) ;
451:
452: l_debug_mode VARCHAR2(10);

Line 449: OR nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(ver.element_version_id),'N') = 'Y' )

445: AND obj.object_id_to2 = ver.proj_element_id
446: AND obj.RELATIONSHIP_TYPE = 'A'
447: AND obj.RELATIONSHIP_SUBTYPE = 'DELIVERABLE_TO_ACTION'
448: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(ver.element_version_id),'N') = 'Y'
449: OR nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(ver.element_version_id),'N') = 'Y' )
450: ) ;
451:
452: l_debug_mode VARCHAR2(10);
453: l_msg_count NUMBER ;

Line 490: x_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn (P_Action_ID => p_action_version_id),'N') ;

486: CLOSE ship_procure_flag_dlv ;
487: ELSE
488: -- Initialize all the out parameters
489:
490: x_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn (P_Action_ID => p_action_version_id),'N') ;
491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;
492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;

Line 491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;

487: ELSE
488: -- Initialize all the out parameters
489:
490: x_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn (P_Action_ID => p_action_version_id),'N') ;
491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;
492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;

Line 492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;

488: -- Initialize all the out parameters
489:
490: x_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn (P_Action_ID => p_action_version_id),'N') ;
491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;
492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;

Line 493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;

489:
490: x_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn (P_Action_ID => p_action_version_id),'N') ;
491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;
492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;

Line 494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;

490: x_ready_to_ship := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn (P_Action_ID => p_action_version_id),'N') ;
491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;
492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;

Line 495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;

491: x_ready_to_procure := nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(P_Action_ID => p_action_version_id ),'N') ;
492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;

Line 496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;

492: x_planning_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
500:

Line 497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;

493: x_proc_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
500:
501: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';

Line 498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;

494: x_shipping_initiated := nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(P_Action_ID => p_action_version_id ),'N') ;
495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
500:
501: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
502: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;

Line 499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;

495: -- x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(P_Action_ID => p_action_version_id ),'N') ;
496: x_item_exists := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn( p_dlvr_version_id ),'N') ;
497: x_item_shippable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Shippable_Yn(P_Deliverable_ID=>p_dlvr_version_id),'N') ;
498: x_item_billable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Billable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
499: x_item_purchasable := nvl(OKE_DELIVERABLE_UTILS_PUB.Item_Purchasable_Yn(P_Deliverable_ID => p_dlvr_version_id ),'N') ;
500:
501: pa_debug.g_err_stage:= 'Inside CREATE_DLV_ACTIONS_IN_BULK ';
502: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
503: END IF ;

Line 612: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'

608: AND obj.object_type_from = 'PA_DELIVERABLES'
609: AND obj.object_id_to2 = ver.proj_element_id
610: AND obj.relationship_type = 'A'
611: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
612: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'
613: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'
614: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'BILLING')
615: ) ;
616:

Line 613: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'

609: AND obj.object_id_to2 = ver.proj_element_id
610: AND obj.relationship_type = 'A'
611: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
612: AND (nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'
613: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'
614: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'BILLING')
615: ) ;
616:
617: -- This cursor will fetch the system_status_code

Line 645: -- Commented for Bug 3503296 AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'

641: AND
642: (
643: (
644: PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'SHIPPING'
645: -- Commented for Bug 3503296 AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'
646: AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'N' --Included for Bug 3503296
647: )
648: OR
649: (

Line 646: AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'N' --Included for Bug 3503296

642: (
643: (
644: PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'SHIPPING'
645: -- Commented for Bug 3503296 AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'
646: AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'N' --Included for Bug 3503296
647: )
648: OR
649: (
650: PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'PROCUREMENT'

Line 651: -- Commented for Bug 3503296 AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'

647: )
648: OR
649: (
650: PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'PROCUREMENT'
651: -- Commented for Bug 3503296 AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'
652: AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'N' --Included for Bug 3503296
653: )
654: )
655: );

Line 652: AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'N' --Included for Bug 3503296

648: OR
649: (
650: PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(object_id_to2) = 'PROCUREMENT'
651: -- Commented for Bug 3503296 AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'
652: AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'N' --Included for Bug 3503296
653: )
654: )
655: );
656:

Line 741: IF OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_dlvr_version_id) = 'N' THEN

737: END IF ;
738:
739: ELSIF PA_DELIVERABLE_UTILS.GET_DLV_TYPE_CLASS_CODE(p_dlv_type_id) = 'ITEM' THEN
740:
741: IF OKE_DELIVERABLE_UTILS_PUB.Item_Defined_Yn(p_dlvr_version_id) = 'N' THEN
742: l_status_change_allowed := 'N' ;
743: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
744: p_msg_name => 'PA_DLV_ITEM_NOT_DEFINED');
745: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2251: AND nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(ver.element_version_id),'N') = 'Y'

2247: AND obj.object_type_from = 'PA_DELIVERABLES'
2248: AND obj.object_id_to2 = ver.proj_element_id
2249: AND obj.relationship_type = 'A'
2250: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
2251: AND nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Ship_Yn(ver.element_version_id),'N') = 'Y'
2252: ) ;
2253: l_dummy VARCHAR2(1) := 'N' ;
2254: l_return_status VARCHAR2(1) := 'N' ;
2255: BEGIN

Line 2285: AND nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(ver.element_version_id),'N') = 'Y'

2281: AND obj.object_type_from = 'PA_DELIVERABLES'
2282: AND obj.object_id_to2 = ver.proj_element_id
2283: AND obj.relationship_type = 'A'
2284: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
2285: AND nvl(OKE_DELIVERABLE_UTILS_PUB.Ready_To_Procure_Yn(ver.element_version_id),'N') = 'Y'
2286: ) ;
2287: l_dummy VARCHAR2(1) := 'N' ;
2288: l_return_status VARCHAR2(1) := 'N' ;
2289: BEGIN

Line 2894: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'

2890: AND obj2.object_type_from='PA_DELIVERABLES'
2891: AND obj2.object_type_to='PA_ACTIONS'
2892: AND ppv.proj_element_id=obj2.object_id_to2
2893: AND ppv.object_type='PA_ACTIONS'
2894: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
2895: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
2896: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(obj2.object_id_to2) = 'BILLING' )
2897: );
2898: CURSOR cur_get_assoc_dlvr IS

Line 2895: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'

2891: AND obj2.object_type_to='PA_ACTIONS'
2892: AND ppv.proj_element_id=obj2.object_id_to2
2893: AND ppv.object_type='PA_ACTIONS'
2894: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
2895: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
2896: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(obj2.object_id_to2) = 'BILLING' )
2897: );
2898: CURSOR cur_get_assoc_dlvr IS
2899: SELECT proj_element_id

Line 3028: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'

3024: AND obj2.object_type_from='PA_DELIVERABLES'
3025: AND obj2.object_type_to='PA_ACTIONS'
3026: AND ppv.proj_element_id=obj2.object_id_to2
3027: AND ppv.object_type='PA_ACTIONS'
3028: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3029: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3030: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3031: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(obj2.object_id_to2) = 'BILLING' )
3032: );

Line 3029: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'

3025: AND obj2.object_type_to='PA_ACTIONS'
3026: AND ppv.proj_element_id=obj2.object_id_to2
3027: AND ppv.object_type='PA_ACTIONS'
3028: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3029: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3030: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3031: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(obj2.object_id_to2) = 'BILLING' )
3032: );
3033:

Line 3030: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppv.element_version_id),'N') = 'Y'

3026: AND ppv.proj_element_id=obj2.object_id_to2
3027: AND ppv.object_type='PA_ACTIONS'
3028: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3029: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3030: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppv.element_version_id),'N') = 'Y'
3031: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(obj2.object_id_to2) = 'BILLING' )
3032: );
3033:
3034: l_debug_mode VARCHAR2(1);

Line 3256: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppev.element_version_id),'N') = 'Y'

3252: AND obj2.object_type_from = 'PA_TASKS'
3253: AND obj2.object_type_to = 'PA_DELIVERABLES'
3254: AND ppe2.proj_element_id=obj2.object_id_from1
3255: AND ppe2.object_type='PA_TASKS'
3256: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3257: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3258: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3259: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(ppe.proj_element_id) = 'BILLING' )
3260: );

Line 3257: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppev.element_version_id),'N') = 'Y'

3253: AND obj2.object_type_to = 'PA_DELIVERABLES'
3254: AND ppe2.proj_element_id=obj2.object_id_from1
3255: AND ppe2.object_type='PA_TASKS'
3256: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3257: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3258: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3259: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(ppe.proj_element_id) = 'BILLING' )
3260: );
3261:

Line 3258: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppev.element_version_id),'N') = 'Y'

3254: AND ppe2.proj_element_id=obj2.object_id_from1
3255: AND ppe2.object_type='PA_TASKS'
3256: AND ( nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3257: OR nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3258: OR nvl(OKE_DELIVERABLE_UTILS_PUB.MDS_Initiated_Yn(ppev.element_version_id),'N') = 'Y'
3259: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(ppe.proj_element_id) = 'BILLING' )
3260: );
3261:
3262: l_debug_mode VARCHAR2(1);

Line 5864: AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'

5860: AND obj.object_type_from = 'PA_DELIVERABLES'
5861: AND obj.object_id_to2 = ver.proj_element_id
5862: AND obj.relationship_type = 'A'
5863: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
5864: AND nvl(OKE_DELIVERABLE_UTILS_PUB.WSH_Initiated_Yn(ver.element_version_id),'N') = 'Y'
5865: ) ;
5866: l_dummy VARCHAR2(1) := 'N' ;
5867: l_return_status VARCHAR2(1) := 'N' ;
5868: BEGIN

Line 5910: AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'

5906: AND obj.object_type_from = 'PA_DELIVERABLES'
5907: AND obj.object_id_to2 = ver.proj_element_id
5908: AND obj.relationship_type = 'A'
5909: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'
5910: AND nvl(OKE_DELIVERABLE_UTILS_PUB.REQ_Initiated_Yn(ver.element_version_id),'N') = 'Y'
5911: ) ;
5912: l_dummy VARCHAR2(1) := 'N' ;
5913: l_return_status VARCHAR2(1) := 'N' ;
5914: BEGIN