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 116: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

112: --A new assignment is one that has not been previously approved.
113: --
114: FUNCTION Is_New_Assignment
115: (
116: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
117: )
118: RETURN VARCHAR2
119: IS
120:

Line 129: pa_project_assignments ppa

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);
133:

Line 144: FROM pa_project_assignments ppa

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
145: WHERE ppa.assignment_id = p_assignment_id
146: AND ppa.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
147:
148: BEGIN

Line 193: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

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
194: )
195: RETURN NUMBER
196: IS
197:

Line 248: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

244: --Determine if the specified assignment requires approval.
245: --
246: PROCEDURE Check_Approval_Required
247: (
248: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
249: ,p_new_assignment_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
250: -- ,p_resource_authority_flag IN VARCHAR2 := FND_API.G_MISS_CHAR
251: ,x_approval_required_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
252: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 325: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

321: --The allowed actions are: 'APPROVE', 'REJECT', 'SUBMIT', 'UPDATE', and 'REVERT'.
322: --
323: PROCEDURE Update_Approval_Status
324: (
325: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
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

Line 327: ,p_record_version_number IN pa_project_assignments.record_version_number%TYPE

323: PROCEDURE Update_Approval_Status
324: (
325: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
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

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

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

Line 348: FROM pa_project_assignments

344: l_msg_index_out NUMBER;
345:
346: CURSOR get_status_and_rec_num IS
347: SELECT apprvl_status_code, record_version_number
348: FROM pa_project_assignments
349: WHERE assignment_id = p_assignment_id;
350:
351: BEGIN
352:

Line 429: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row ( p_assignment_id => p_assignment_id

425: --If no error, update the current assignment record with the new status and increment record_version_number
426: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
427: --dbms_output.put_line('calling update row');
428:
429: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row ( p_assignment_id => p_assignment_id
430: ,p_record_version_number => p_record_version_number
431: ,p_apprvl_status_code => x_apprvl_status_code
432: ,p_note_to_approver => p_note_to_approver
433: ,x_return_status => l_return_status );

Line 511: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row ( p_assignment_id => p_assignment_id

507: --apprvl_status_code has been changed.
508: IF (p_note_to_approver <> FND_API.G_MISS_CHAR AND p_note_to_approver IS NOT NULL) OR
509: ((x_apprvl_status_code IS NOT NULL AND l_apprvl_status_code IS NULL) OR
510: (x_apprvl_status_code <> l_apprvl_status_code)) THEN
511: PA_PROJECT_ASSIGNMENTS_PKG.Update_Row ( p_assignment_id => p_assignment_id
512: ,p_record_version_number => l_record_version_number
513: ,p_apprvl_status_code => x_apprvl_status_code
514: ,p_note_to_approver => p_note_to_approver
515: ,x_return_status => l_return_status );

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 704: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

700: -- record's Assignment Approval Status changes from 'APPROVED' to 'WORKING'.
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:

Line 721: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'

717:
718: CURSOR get_project_subteam_id IS
719: SELECT project_subteam_id
720: FROM pa_project_subteam_parties
721: WHERE object_type = 'PA_PROJECT_ASSIGNMENTS'
722: AND object_id = p_assignment_id
723: AND primary_subteam_flag = 'Y';
724:
725: BEGIN

Line 910: FROM pa_project_assignments

906: ,l_assignment_rec.transfer_price_rate -- Added for bug 3051110
907: ,l_assignment_rec.transfer_pr_rate_curr
908: ,l_assignment_rec.discount_percentage -- Added for bug 3041583
909: ,l_assignment_rec.rate_disc_reason_code -- Added for bug 3041583
910: FROM pa_project_assignments
911: WHERE assignment_id = p_assignment_id;
912:
913: --
914: --Get the subteam id

Line 1093: p_assignment_id IN pa_project_assignments.assignment_id%TYPE

1089: --and update the pending_approval_flag to 'N'
1090: --
1091: PROCEDURE Abort_Assignment_Approval
1092: (
1093: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1094: ,p_project_id IN pa_project_assignments.project_id%TYPE
1095: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1096: )
1097: IS

Line 1094: ,p_project_id IN pa_project_assignments.project_id%TYPE

1090: --
1091: PROCEDURE Abort_Assignment_Approval
1092: (
1093: p_assignment_id IN pa_project_assignments.assignment_id%TYPE
1094: ,p_project_id IN pa_project_assignments.project_id%TYPE
1095: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1096: )
1097: IS
1098:

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

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

Line 1224: FROM pa_project_assignments

1220: tp_rate_override,
1221: tp_calc_base_code_override,
1222: tp_percent_applied_override,
1223: staffing_owner_person_id
1224: FROM pa_project_assignments
1225: WHERE assignment_id = p_assignment_id;
1226:
1227: CURSOR get_asmt_history_rec IS
1228: SELECT assignment_id,

Line 1252: FROM pa_project_assignments

1248: AND last_approved_flag = 'Y';
1249:
1250: CURSOR get_apprvl_status_code IS
1251: SELECT apprvl_status_code
1252: FROM pa_project_assignments
1253: WHERE assignment_id = p_assignment_id;
1254:
1255: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
1256: l_change_id NUMBER;

Line 1255: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;

1251: SELECT apprvl_status_code
1252: FROM pa_project_assignments
1253: WHERE assignment_id = p_assignment_id;
1254:
1255: l_apprvl_status_code pa_project_assignments.apprvl_status_code%TYPE;
1256: l_change_id NUMBER;
1257:
1258: BEGIN
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1297: -- Following two cases we need to get data for x_asmt_history_rec from pa_project_assignments

1293: OPEN get_apprvl_status_code;
1294: FETCH get_apprvl_status_code INTO l_apprvl_status_code;
1295: CLOSE get_apprvl_status_code;
1296:
1297: -- Following two cases we need to get data for x_asmt_history_rec from pa_project_assignments
1298: -- 1. If history table doesn't have a record for this assignment
1299: -- 2. If history table has a record but its approval_status is 'approved'
1300: -- Then it is mass update/schedule submit case, the record in history table is last approved
1301: -- data not the current approved one which is what we want to show on Change details page.