APPS.PA_PROJECT_STUS_UTILS dependencies on PA_UTILS2

Line 34: -- only since it calls pa_utils2.IsProjectClosed which compares Project

30: END Is_Project_Closed;
31: */
32:
33: -- STATUS MODEL changes - the following function is for status_type PROJECT
34: -- only since it calls pa_utils2.IsProjectClosed which compares Project
35: -- related system statuses only. The filer for status_type has been added
36: -- only to make it apparent that this function is for PROJECT only.
37: /* Bug 3059344: this function is commented, please see eof for the function code
38: FUNCTION Is_Project_Status_Closed

Line 56: IF pa_utils2.IsProjectClosed(l_system_stus_code) = 'Y' THEN

52: CLOSE l_stus_csr;
53: RETURN 'N';
54: END IF;
55: CLOSE l_stus_csr;
56: IF pa_utils2.IsProjectClosed(l_system_stus_code) = 'Y' THEN
57: RETURN 'Y';
58: ELSE
59: RETURN 'N';
60: END IF;

Line 107: -- only since it calls pa_utils2.IsProjectInPurgeStatus which compares Project

103: END Is_ARPR_Project_Status_Closed;
104:
105:
106: -- STATUS MODEL changes - the following function is for status_type PROJECT
107: -- only since it calls pa_utils2.IsProjectInPurgeStatus which compares Project
108: -- related system statuses only. The filer for status_type has been added
109: -- only to make it apparent that this function is for PROJECT only.
110: FUNCTION Is_Project_In_Purge_Status
111: (x_project_status_code IN VARCHAR2 ) return VARCHAR2 IS

Line 128: IF pa_utils2.IsProjectInPurgeStatus(l_system_stus_code) = 'Y' THEN

124: CLOSE l_stus_csr;
125: RETURN 'N';
126: END IF;
127: CLOSE l_stus_csr;
128: IF pa_utils2.IsProjectInPurgeStatus(l_system_stus_code) = 'Y' THEN
129: RETURN 'Y';
130: ELSE
131: RETURN 'N';
132: END IF;

Line 980: -- only since it calls pa_utils2.IsProjectClosed which compares Project

976: RETURN 'N';
977: END Is_Project_Closed;
978:
979: -- STATUS MODEL changes - the following function is for status_type PROJECT
980: -- only since it calls pa_utils2.IsProjectClosed which compares Project
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:

Line 1000: G_PROJ_STS_CLOSED := pa_utils2.IsProjectClosed(l_system_status_code);

996: WHERE project_status_code = x_project_status_code
997: and status_type = 'PROJECT';
998:
999: g_project_status_code := x_project_status_code;
1000: G_PROJ_STS_CLOSED := pa_utils2.IsProjectClosed(l_system_status_code);
1001:
1002: --Dbms_Output.Put_Line('after select');
1003: Exception
1004: When No_Data_Found Then