APPS.PA_PROJECT_STUS_UTILS dependencies on PA_PROJECTS_ALL

Line 11: FROM pa_projects_all

7: (x_project_id IN NUMBER ) return VARCHAR2 IS
8:
9: CURSOR l_proj_csr IS
10: SELECT project_status_code
11: FROM pa_projects_all
12: WHERE project_id = x_project_id;
13: l_proj_status_code VARCHAR2(30);
14: l_closed VARCHAR2(1) := 'N';
15: BEGIN

Line 549: from PA_PROJECTS_ALL P

545: Into x_err_stage,x_allow_deletion_flag
546: From dual
547: Where exists
548: (select '1'
549: from PA_PROJECTS_ALL P
550: where P.project_status_code=p_project_status_code);
551: if (x_allow_deletion_flag='N') then
552: return;
553: end if;

Line 924: l_proj_status_code pa_projects_all.project_status_code%type;

920:
921: --start Bug 3059344
922: FUNCTION Is_Project_Closed(x_project_id IN NUMBER ) return VARCHAR2 IS
923: l_Found BOOLEAN := FALSE;
924: l_proj_status_code pa_projects_all.project_status_code%type;
925: X_PROJ_CLOSED VARCHAR2(1);
926: Begin
927: -- Check if there are any records in the pl/sql table.
928: If G_ProjID_Tab.COUNT > 0 Then

Line 956: FROM pa_projects_all

952: Begin
953: --Dbms_Output.Put_Line('select');
954: SELECT project_status_code
955: into l_proj_status_code
956: FROM pa_projects_all
957: WHERE project_id = x_project_id;
958:
959: X_PROJ_CLOSED := Is_Project_Status_Closed (l_proj_status_code);
960:

Line 985: l_system_status_code pa_projects_all.project_status_code%type;

981: -- related system statuses only. The filer for status_type has been added
982: -- only to make it apparent that this function is for PROJECT only.
983: FUNCTION Is_Project_Status_Closed (x_project_status_code IN VARCHAR2 ) return VARCHAR2 IS
984:
985: l_system_status_code pa_projects_all.project_status_code%type;
986: Begin
987:
988: If x_project_status_code = g_project_status_code Then
989: RETURN g_proj_sts_closed;