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_ASSIGNMENTS_HISTORY

Line 128: FROM pa_assignments_history pah,

124: /* Commenting this cursor for bug 4183614
125:
126: CURSOR get_assignment_id IS
127: SELECT 'X'
128: FROM pa_assignments_history pah,
129: pa_project_assignments ppa
130: WHERE pah.assignment_id = p_assignment_id
131: OR ( ppa.assignment_id = p_assignment_id
132: AND ppa.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved);

Line 140: FROM pa_assignments_history pah

136: /* Added this tuned query for cursor get_Assignment_id for bug 4183614 */
137:
138: CURSOR get_assignment_id IS
139: SELECT 'X'
140: FROM pa_assignments_history pah
141: WHERE pah.assignment_id = p_assignment_id
142: UNION ALL
143: SELECT 'X'
144: FROM pa_project_assignments ppa

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

185:
186:
187:
188: --
189: --Get the change_id from the pa_assignments_history table.
190: --
191: FUNCTION Get_Change_Id
192: (
193: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

Line 198: l_change_id pa_assignments_history.change_id%TYPE;

194: )
195: RETURN NUMBER
196: IS
197:
198: l_change_id pa_assignments_history.change_id%TYPE;
199:
200: CURSOR get_change_id IS
201: SELECT change_id
202: FROM pa_assignments_history

Line 202: FROM pa_assignments_history

198: l_change_id pa_assignments_history.change_id%TYPE;
199:
200: CURSOR get_change_id IS
201: SELECT change_id
202: FROM pa_assignments_history
203: WHERE assignment_id = p_assignment_id
204: AND last_approved_flag = 'Y';
205:
206: BEGIN

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

326: ,p_action_code IN VARCHAR2 := FND_API.G_MISS_CHAR
327: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE
328: ,p_note_to_approver IN VARCHAR2 := FND_API.G_MISS_CHAR
329: ,x_apprvl_status_code OUT NOCOPY pa_project_statuses.project_status_code%TYPE --File.Sql.39 bug 4440895
330: ,x_change_id OUT NOCOPY pa_assignments_history.change_id%TYPE --File.Sql.39 bug 4440895
331: ,x_record_version_number OUT NOCOPY pa_project_assignments.record_version_number%TYPE --File.Sql.39 bug 4440895
332: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
333: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
334: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

695: END Get_Next_Status_After_Action;
696:
697:
698: --
699: --This procedure inserts current record in the PA_PROJECT_ASSIGNMENTS into the PA_ASSIGNMENTS_HISTORY table when the
700: -- record's Assignment Approval Status changes from 'APPROVED' to 'WORKING'.
701: --
702: PROCEDURE Insert_Into_Assignment_History
703: (

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

701: --
702: PROCEDURE Insert_Into_Assignment_History
703: (
704: p_assignment_id IN pa_project_assignments.assignment_id%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;

Line 712: l_pending_approval_flag pa_assignments_history.pending_approval_flag%TYPE;

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);
714: l_msg_data VARCHAR2(2000);
715: l_msg_count NUMBER;
716: l_project_subteam_id NUMBER;

Line 934: -- PA_ASSIGNMENTS_HISTORY_PKG.Update_Row is not used, since the last_approved_flag is used as both

930: --so updating the previously last approved record's flag to 'N'.
931: --
932: --IF no previous approved record exist, this statement does nothing.
933: --
934: -- PA_ASSIGNMENTS_HISTORY_PKG.Update_Row is not used, since the last_approved_flag is used as both
935: -- an criteria for search and the parameter need to be updated.
936: --
937: UPDATE pa_assignments_history
938: SET last_approved_flag = 'N'

Line 937: UPDATE pa_assignments_history

933: --
934: -- PA_ASSIGNMENTS_HISTORY_PKG.Update_Row is not used, since the last_approved_flag is used as both
935: -- an criteria for search and the parameter need to be updated.
936: --
937: UPDATE pa_assignments_history
938: SET last_approved_flag = 'N'
939: WHERE assignment_id = p_assignment_id
940: AND last_approved_flag = 'Y';
941:

Line 952: PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row

948: ,x_msg => 'insert last approved record into assignment history table.'
949: ,x_log_level => 5);
950: END IF;
951:
952: PA_ASSIGNMENTS_HISTORY_PKG.Insert_Row
953: (p_assignment_id => l_assignment_rec.assignment_id
954: ,p_assignment_name => l_assignment_rec.assignment_name
955: ,p_assignment_type => l_assignment_rec.assignment_type
956: ,p_multiple_status_flag => l_assignment_rec.multiple_status_flag

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

1194:
1195: --
1196: -- Return following record based on p_assignment_is
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

Line 1246: FROM pa_assignments_history

1242: tp_rate_override,
1243: tp_calc_base_code_override,
1244: tp_percent_applied_override,
1245: staffing_owner_person_id
1246: FROM pa_assignments_history
1247: WHERE assignment_id = p_assignment_id
1248: AND last_approved_flag = 'Y';
1249:
1250: CURSOR get_apprvl_status_code IS