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_PROJECTS_MAINT_UTILS dependencies on PA_PROJECT_STATUSES

Line 63: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required

59: -- API name : check_check_project_status_or_id
60: -- Type : Public
61: -- Pre-reqs : None.
62: -- Parameters :
63: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
64: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
65: -- p_check_id_flag IN VARCHAR2 Required
66: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
67: -- x_return_status OUT VARCHAR2 Required

Line 64: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required

60: -- Type : Public
61: -- Pre-reqs : None.
62: -- Parameters :
63: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
64: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
65: -- p_check_id_flag IN VARCHAR2 Required
66: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
67: -- x_return_status OUT VARCHAR2 Required
68: -- x_error_msg_code OUT VARCHAR2 Required

Line 66: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required

62: -- Parameters :
63: -- p_project_status_code IN pa_project_statuses.project_status_code%TYPE Required
64: -- p_project_status_name IN pa_project_statuses.project_status_name%TYPE Required
65: -- p_check_id_flag IN VARCHAR2 Required
66: -- x_project_status_code OUT pa_project_statuses.project_status_code%TYPE Required
67: -- x_return_status OUT VARCHAR2 Required
68: -- x_error_msg_code OUT VARCHAR2 Required
69: --
70: -- History

Line 76: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE

72: -- 18-AUG-2000 -- Sakthi/William - Created.
73: --
74: --
75: procedure Check_project_status_or_id
76: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
77: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
78: ,p_check_id_flag IN VARCHAR2
79: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
80: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 77: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE

73: --
74: --
75: procedure Check_project_status_or_id
76: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
77: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
78: ,p_check_id_flag IN VARCHAR2
79: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
80: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 79: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895

75: procedure Check_project_status_or_id
76: (p_project_status_code IN pa_project_statuses.project_status_code%TYPE
77: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE
78: ,p_check_id_flag IN VARCHAR2
79: ,x_project_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
80: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
81: ,x_error_msg_code OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
82: IS
83: BEGIN

Line 88: FROM pa_project_statuses

84: IF (p_project_status_code IS NOT NULL) THEN
85: IF (p_check_id_flag = 'Y') THEN
86: SELECT project_status_code
87: INTO x_project_status_code
88: FROM pa_project_statuses
89: WHERE project_status_code = p_project_status_code;
90: ELSE
91: x_project_status_code := p_project_status_code;
92: END IF;

Line 96: FROM pa_project_statuses

92: END IF;
93: ELSE
94: SELECT project_status_code
95: INTO x_project_status_code
96: FROM pa_project_statuses
97: WHERE project_status_name = p_project_status_name;
98: END IF;
99: x_return_status:= FND_API.G_RET_STS_SUCCESS;
100: EXCEPTION

Line 965: FROM PA_PROJECT_STATUSES

961: IS
962: CURSOR l_project_system_status_csr(c_project_status_code VARCHAR2)
963: IS
964: SELECT project_system_status_code
965: FROM PA_PROJECT_STATUSES
966: WHERE project_status_code = c_project_status_code;
967: l_project_system_Status VARCHAR(250);
968: BEGIN
969: x_return_status := 'S';

Line 2231: FROM pa_project_statuses ps, pa_projects_all pp

2227: WHERE class_category = p_class_category;
2228:
2229: CURSOR C2 IS
2230: SELECT ps.project_system_status_code
2231: FROM pa_project_statuses ps, pa_projects_all pp
2232: WHERE pp.project_id = p_project_id
2233: AND pp.project_status_code = ps.project_status_code;
2234:
2235: /* added cursor c3 for bug 2784433 */

Line 2249: l_project_status pa_project_statuses.project_system_status_code%TYPE;

2245: WHERE pta.project_type = ppa.project_type
2246: AND project_id = p_project_id));
2247:
2248: x_mandatory_flag VARCHAR2(1);
2249: l_project_status pa_project_statuses.project_system_status_code%TYPE;
2250:
2251: BEGIN
2252: OPEN C2;
2253: FETCH C2 INTO l_project_status;