APPS.PA_TASK_TYPE_PVT dependencies on PA_DELIVERABLE_UTILS

Line 395: l_return_status := PA_DELIVERABLE_UTILS.IS_DLV_TYPE_NAME_UNIQUE (p_deliverable_type_name);

391: RAISE INV_ARG_EXC;
392: END IF;
393:
394: --Check if Deliverable Type name is unique
395: l_return_status := PA_DELIVERABLE_UTILS.IS_DLV_TYPE_NAME_UNIQUE (p_deliverable_type_name);
396: IF(l_return_status = 'N')
397: THEN
398: PA_UTILS.ADD_MESSAGE
399: (p_app_short_name => 'PA',

Line 407: l_return_status :=PA_DELIVERABLE_UTILS.IS_EFF_FROM_TO_DATE_VALID(p_effective_from,p_effective_to);

403:
404: PA_DEBUG.WRITE(g_module_name,'After Unique Chk',
405: l_debug_level3);
406: --Check if the date range is valid
407: l_return_status :=PA_DELIVERABLE_UTILS.IS_EFF_FROM_TO_DATE_VALID(p_effective_from,p_effective_to);
408: IF(l_return_status = 'N')
409: THEN
410: PA_UTILS.ADD_MESSAGE
411: (p_app_short_name => 'PA',

Line 610: AND 'Y' = (pa_deliverable_utils.IS_DELIVERABLE_HAS_PROGRESS(PROJECT_ID,PROJ_ELEMENT_ID)));

606: (SELECT proj_element_id
607: FROM pa_proj_elements
608: WHERE TYPE_ID=p_deliverable_type_id
609: AND OBJECT_TYPE='PA_DELIVERABLES'
610: AND 'Y' = (pa_deliverable_utils.IS_DELIVERABLE_HAS_PROGRESS(PROJECT_ID,PROJ_ELEMENT_ID)));
611:
612: --The cursor takes the original values from the database
613:
614: Cursor c_original_value_rec IS

Line 710: l_return_status := PA_DELIVERABLE_UTILS.IS_DLV_TYPE_NAME_UNIQUE (p_deliverable_type_name);

706: -- If the Deliverable Type Name has changed
707: -- then check for unique name
708: IF l_original_value_rec.TASK_TYPE <> p_deliverable_type_name
709: THEN
710: l_return_status := PA_DELIVERABLE_UTILS.IS_DLV_TYPE_NAME_UNIQUE (p_deliverable_type_name);
711: IF(l_return_status = 'N')
712: THEN
713: PA_UTILS.ADD_MESSAGE
714: (p_app_short_name => 'PA'

Line 730: l_return_status :=PA_DELIVERABLE_UTILS.IS_EFF_FROM_TO_DATE_VALID(p_effective_from,p_effective_to);

726: THEN
727: IF (TRUNC(l_original_value_rec.START_DATE_ACTIVE) <> TRUNC(p_effective_from)) OR (l_original_value_rec.END_DATE_ACTIVE IS NULL)
728: OR (l_original_value_rec.END_DATE_ACTIVE IS NOT NULL AND TRUNC(l_original_value_rec.END_DATE_ACTIVE) <> TRUNC(p_effective_to))
729: THEN
730: l_return_status :=PA_DELIVERABLE_UTILS.IS_EFF_FROM_TO_DATE_VALID(p_effective_from,p_effective_to);
731: IF(l_return_status = 'N')
732: THEN
733: PA_UTILS.ADD_MESSAGE
734: (p_app_short_name => 'PA'

Line 748: l_return_status :=PA_DELIVERABLE_UTILS.IS_DLV_TYPE_IN_USE(p_deliverable_type_id);

744: --If the Deliverable Type Class has changed then check whether it is in use
745: --If Yes,Throw Error
746: If l_original_value_rec.TASK_TYPE_CLASS_CODE <> p_deliverable_type_class
747: THEN
748: l_return_status :=PA_DELIVERABLE_UTILS.IS_DLV_TYPE_IN_USE(p_deliverable_type_id);
749: If (l_return_status='Y' )
750: THEN
751: PA_UTILS.ADD_MESSAGE
752: (p_app_short_name => 'PA'

Line 773: -- l_return_status :=PA_DELIVERABLE_UTILS.IS_DLV_BASED_ASSCN_EXISTS(p_deliverable_type_id);

769: -- Relaxed the check that enable progress entry cannot
770: -- cannot be unchecked if deliverbale type is used by
771: -- deliverables which are associated to deliverable based task.
772:
773: -- l_return_status :=PA_DELIVERABLE_UTILS.IS_DLV_BASED_ASSCN_EXISTS(p_deliverable_type_id);
774: -- IF(l_return_status='Y')
775: -- THEN
776: -- PA_UTILS.ADD_MESSAGE
777: -- (p_app_short_name => 'PA'

Line 823: l_return_status :=PA_DELIVERABLE_UTILS.IS_DLV_ACTIONS_EXISTS(p_deliverable_type_id);

819: --If Yes ,Throw Error
820: --Else delete those actions
821: IF p_enable_dlvr_actions_flag = 'N' AND l_original_value_rec.ENABLE_DLVR_ACTIONS_FLAG = 'Y'
822: THEN
823: l_return_status :=PA_DELIVERABLE_UTILS.IS_DLV_ACTIONS_EXISTS(p_deliverable_type_id);
824: IF (l_return_status='Y')
825: THEN
826: PA_UTILS.ADD_MESSAGE
827: (p_app_short_name => 'PA'