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_ASSIGNMENT_APPROVAL_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 21: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

17: --A new assignment is one that has not been previously approved.
18: --
19: FUNCTION Is_New_Assignment
20: (
21: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
22: )
23: RETURN VARCHAR2;
24:
25:

Line 32: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

28: --Get the change_id from the pa_assignments_history table.
29: --
30: FUNCTION Get_Change_Id
31: (
32: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
33: )
34: RETURN NUMBER;
35:
36: --

Line 49: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

45: --Determine if the specified assignment requires approval.
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

Line 67: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

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

Line 69: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE

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
73: ,x_record_version_number OUT NOCOPY pa_project_assignments.record_version_number%TYPE --File.Sql.39 bug 4440895

Line 73: ,x_record_version_number OUT NOCOPY pa_project_assignments.record_version_number%TYPE --File.Sql.39 bug 4440895

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
76: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
77: );

Line 96: --This procedure inserts current record in the PA_PROJECT_ASSIGNMENTS into the PA_ASSIGNMENTS_HISTORY table when the

92:
93:
94:
95: --
96: --This procedure inserts current record in the PA_PROJECT_ASSIGNMENTS into the PA_ASSIGNMENTS_HISTORY table when the
97: -- record's Assignment Approval Status changes from 'APPROVED' to 'WORKING'.
98: --
99: PROCEDURE Insert_Into_Assignment_History
100: (

Line 101: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

97: -- record's Assignment Approval Status changes from 'APPROVED' to 'WORKING'.
98: --
99: PROCEDURE Insert_Into_Assignment_History
100: (
101: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
102: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
103: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
104: );
105:

Line 112: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

108: --and update the pending_approval_flag to 'N'
109: --
110: PROCEDURE Abort_Assignment_Approval
111: (
112: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
113: ,p_project_id IN pa_project_assignments.project_id%TYPE
114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115: );
116:

Line 113: ,p_project_id IN pa_project_assignments.project_id%TYPE

109: --
110: PROCEDURE Abort_Assignment_Approval
111: (
112: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
113: ,p_project_id IN pa_project_assignments.project_id%TYPE
114: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
115: );
116:
117:

Line 120: -- x_saved_asmt_rec : assignment record having values in pa_project_assignments

116:
117:
118: --
119: -- Return following record based on p_assignment_is
120: -- x_saved_asmt_rec : assignment record having values in pa_project_assignments
121: -- x_asmt_history_rec : assignment record having values in pa_assignments_history
122: --
123: PROCEDURE get_asmt_and_asmt_history_rec (p_assignment_id IN NUMBER
124: ,x_saved_asmt_rec OUT NOCOPY PA_ASSIGNMENTS_PUB.assignment_rec_type --File.Sql.39 bug 4440895