APPS.PA_ASSIGNMENT_APPROVAL_PVT dependencies on PA_ASSIGNMENTS_PUB

Line 709: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;

705: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
706: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
707: ) IS
708:
709: l_assignment_rec PA_ASSIGNMENTS_PUB.Assignment_Rec_Type;
710: l_assignment_row_id ROWID;
711: l_change_id NUMBER;
712: l_pending_approval_flag pa_assignments_history.pending_approval_flag%TYPE;
713: l_return_status VARCHAR2(1);

Line 1201: ,x_saved_asmt_rec OUT NOCOPY PA_ASSIGNMENTS_PUB.assignment_rec_type --File.Sql.39 bug 4440895

1197: -- x_saved_asmt_rec : assignment record having values in pa_project_assignments
1198: -- x_asmt_history_rec : assignment record having values in pa_assignments_history
1199: --
1200: PROCEDURE get_asmt_and_asmt_history_rec (p_assignment_id IN NUMBER
1201: ,x_saved_asmt_rec OUT NOCOPY PA_ASSIGNMENTS_PUB.assignment_rec_type --File.Sql.39 bug 4440895
1202: ,x_asmt_history_rec OUT NOCOPY pa_assignments_pub.assignment_rec_type --File.Sql.39 bug 4440895
1203: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1204: IS
1205: CURSOR get_saved_asmt_rec IS

Line 1202: ,x_asmt_history_rec OUT NOCOPY pa_assignments_pub.assignment_rec_type --File.Sql.39 bug 4440895

1198: -- x_asmt_history_rec : assignment record having values in pa_assignments_history
1199: --
1200: PROCEDURE get_asmt_and_asmt_history_rec (p_assignment_id IN NUMBER
1201: ,x_saved_asmt_rec OUT NOCOPY PA_ASSIGNMENTS_PUB.assignment_rec_type --File.Sql.39 bug 4440895
1202: ,x_asmt_history_rec OUT NOCOPY pa_assignments_pub.assignment_rec_type --File.Sql.39 bug 4440895
1203: ,x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1204: IS
1205: CURSOR get_saved_asmt_rec IS
1206: SELECT assignment_id,