APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on PA_PROJECT_STATUSES

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

67: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
68: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
69: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE
70: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
71: ,x_apprvl_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
72: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
73: ,x_record_version_number OUT NOCOPY pa_project_assignments.record_version_number%TYPE --File.Sql.39 bug 4440895
74: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
75: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 88: ,p_status_code IN pa_project_statuses.project_status_code%TYPE:= FND_API.G_MISS_CHAR

84: --
85: PROCEDURE Get_Next_Status_After_Action
86: (
87: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
88: ,p_status_code IN pa_project_statuses.project_status_code%TYPE:= FND_API.G_MISS_CHAR
89: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
90: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
91: );
92:

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

85: PROCEDURE Get_Next_Status_After_Action
86: (
87: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
88: ,p_status_code IN pa_project_statuses.project_status_code%TYPE:= FND_API.G_MISS_CHAR
89: ,x_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
90: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
91: );
92:
93: