APPS.PA_DELIVERABLE_UTILS dependencies on PA_PROJECT_STATUSES

Line 622: FROM pa_project_statuses

618: -- for the given status_code .
619:
620: CURSOR c_get_system_status IS
621: SELECT project_system_status_code
622: FROM pa_project_statuses
623: WHERE project_status_code = p_dlvr_status_code
624: AND status_type = 'DELIVERABLE' ;
625: -- Bug 3503296 In the following cursor ,we have to check
626: --"Whether Shipping Or Procurement has NOT been initiated for any of the deliverable's actions"

Line 2865: ,p_status_code IN PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE

2861: PROCEDURE UPDATE_TSK_STATUS_CANCELLED( p_api_version IN NUMBER := 1.0
2862: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2863: ,p_debug_mode IN VARCHAR2 := 'N'
2864: ,p_task_id IN NUMBER
2865: ,p_status_code IN PA_PROJECT_STATUSES.PROJECT_STATUS_CODE%TYPE
2866: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2867: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2868: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2869: )

Line 2916: l_system_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;

2912: l_debug_level3 CONSTANT NUMBER := 3;
2913: l_debug_level4 CONSTANT NUMBER := 4;
2914: l_debug_level5 CONSTANT NUMBER := 5;
2915:
2916: l_system_code PA_PROJECT_STATUSES.PROJECT_SYSTEM_STATUS_CODE%TYPE;
2917: l_dummy NUMBER;
2918: BEGIN
2919: x_return_status := FND_API.G_RET_STS_SUCCESS;
2920: x_msg_count := 0;

Line 2938: FROM pa_project_statuses

2934: l_debug_level3);
2935: END IF;
2936:
2937: SELECT distinct PROJECT_SYSTEM_STATUS_CODE INTO l_system_code
2938: FROM pa_project_statuses
2939: WHERE STATUS_TYPE='TASK'
2940: AND PROJECT_STATUS_CODE=p_status_code;
2941:
2942: IF 'DELIVERABLE' <> PA_DELIVERABLE_UTILS.GET_PROGRESS_ROLLUP_METHOD(p_task_id)

Line 4282: FROM PA_PROJECT_STATUSES

4278: l_dummy varchar2(1);
4279:
4280: CURSOR c_status_code_exists IS
4281: SELECT 'X'
4282: FROM PA_PROJECT_STATUSES
4283: WHERE UPPER(project_status_code) = UPPER(p_status_code)
4284: AND UPPER(project_system_status_code) = DECODE(p_calling_mode, 'INSERT', 'DLVR_NOT_STARTED',project_system_status_code)
4285: AND status_type = 'DELIVERABLE'
4286: AND sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active,sysdate);