APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on PA_ASSIGNMENTS_HISTORY

Line 28: --Get the change_id from the pa_assignments_history table.

24:
25:
26:
27: --
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

Line 72: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895

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

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 102: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895

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:
106: --

Line 121: -- x_asmt_history_rec : assignment record having values in pa_assignments_history

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
125: ,x_asmt_history_rec OUT NOCOPY pa_assignments_pub.assignment_rec_type --File.Sql.39 bug 4440895