DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on FND_API

Line 50: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

46: --
47: PROCEDURE Check_Approval_Required
48: (
49: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
50: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
51: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
52: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
54: );

Line 51: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR

47: PROCEDURE Check_Approval_Required
48: (
49: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
50: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
51: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
52: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
53: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
54: );
55:

Line 68: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

64: --
65: PROCEDURE Update_Approval_Status
66: (
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

Line 70: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR

66: (
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

Line 87: p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR

83: --The allowed actions are: 'APPROVE', 'REJECT', 'SUBMIT', 'UPDATE', and 'REVERT'.
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: );

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: