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_ASSIGNMENT_APPROVAL_PUB

Line 15: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;

11: PROCEDURE Validate_approver_orders (
12: x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
13: IS
14:
15: l_approver_rec PA_ASSIGNMENT_APPROVAL_PUB.Asgmt_Approvers_Rec_Type;
16: l_return_status VARCHAR2(1);
17: l_sorted BOOLEAN;
18: l_first BINARY_INTEGER;
19: l_before_last BINARY_INTEGER;

Line 37: IF PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST IS NULL AND PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST IS NULL THEN

33: --
34: --If table empty, then return error that at least one approver is needed.
35: --Else use bubble sort to put approvers according to their order, then check if any duplicate order exists.
36: --
37: IF PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST IS NULL AND PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST IS NULL THEN
38: PA_UTILS.Add_Message( p_app_short_name => 'PA'
39: ,p_msg_name => 'PA_NO_NON_EXCLUDED_APR');
40: l_return_status := FND_API.G_RET_STS_ERROR;
41: ELSE

Line 54: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST <>PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST) THEN

50: --
51: --Starting Bubble Sort.
52: --
53: l_sorted := FALSE;
54: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST <>PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST) THEN
55: l_first := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST;
56: l_before_last := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.PRIOR(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST);
57: WHILE l_sorted = FALSE LOOP
58:

Line 55: l_first := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST;

51: --Starting Bubble Sort.
52: --
53: l_sorted := FALSE;
54: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST <>PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST) THEN
55: l_first := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST;
56: l_before_last := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.PRIOR(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST);
57: WHILE l_sorted = FALSE LOOP
58:
59: l_sorted := TRUE;

Line 56: l_before_last := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.PRIOR(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST);

52: --
53: l_sorted := FALSE;
54: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST <>PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST) THEN
55: l_first := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.FIRST;
56: l_before_last := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.PRIOR(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.LAST);
57: WHILE l_sorted = FALSE LOOP
58:
59: l_sorted := TRUE;
60: FOR i IN l_first .. l_before_last LOOP

Line 62: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders >

58:
59: l_sorted := TRUE;
60: FOR i IN l_first .. l_before_last LOOP
61:
62: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders >
63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);
65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=
66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));

Line 63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN

59: l_sorted := TRUE;
60: FOR i IN l_first .. l_before_last LOOP
61:
62: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders >
63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);
65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=
66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));
67: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)) := l_approver_rec;

Line 64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);

60: FOR i IN l_first .. l_before_last LOOP
61:
62: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders >
63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);
65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=
66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));
67: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)) := l_approver_rec;
68: l_sorted := FALSE;

Line 65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=

61:
62: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders >
63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);
65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=
66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));
67: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)) := l_approver_rec;
68: l_sorted := FALSE;
69: END IF;

Line 66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));

62: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders >
63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);
65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=
66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));
67: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)) := l_approver_rec;
68: l_sorted := FALSE;
69: END IF;
70: END LOOP;

Line 67: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)) := l_approver_rec;

63: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
64: l_approver_rec := PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i);
65: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i) :=
66: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i));
67: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)) := l_approver_rec;
68: l_sorted := FALSE;
69: END IF;
70: END LOOP;
71: END LOOP;

Line 82: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders =

78: END IF;
79: --Check if any duplicate orders exist.
80: FOR i IN l_first .. l_before_last LOOP
81:
82: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders =
83: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
84: PA_UTILS.Add_Message( p_app_short_name => 'PA'
85: ,p_msg_name => 'PA_DUPLICATE_APR_ORDERS');
86: l_return_status := FND_API.G_RET_STS_ERROR;

Line 83: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN

79: --Check if any duplicate orders exist.
80: FOR i IN l_first .. l_before_last LOOP
81:
82: IF (PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(i).orders =
83: PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl(PA_ASSIGNMENT_APPROVAL_PUB.g_approver_tbl.NEXT(i)).orders) THEN
84: PA_UTILS.Add_Message( p_app_short_name => 'PA'
85: ,p_msg_name => 'PA_DUPLICATE_APR_ORDERS');
86: l_return_status := FND_API.G_RET_STS_ERROR;
87: END IF;

Line 132: AND ppa.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved);

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:
134: End of comment for bug 4183614 */
135:
136: /* Added this tuned query for cursor get_Assignment_id for bug 4183614 */

Line 146: AND ppa.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved;

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
149: -- Initialize the Error Stack
150: PA_DEBUG.set_err_stack('PA_ASSIGNMENT_APPROVAL_PVT.Is_New_Assignment');

Line 380: IF l_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved

376:
377:
378: -- IF current status is 'Approved' and action to be performed is 'Update', then insert the current record
379: -- into history table.
380: IF l_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved
381: AND p_action_code =PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
382:
383: --Log Message
384: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 381: AND p_action_code =PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN

377:
378: -- IF current status is 'Approved' and action to be performed is 'Update', then insert the current record
379: -- into history table.
380: IF l_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved
381: AND p_action_code =PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
382:
383: --Log Message
384: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
385: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.insert_history'

Line 448: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN

444:
445: --In the case of Approve or Reject, also call schedule's success/failure method to update schedule statuses.
446: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
447:
448: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
449: --call schedule's success method
450: --Log Message
451: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
452: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.schedule_success'

Line 466: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN

462: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
463: x_return_status := l_return_status;
464: END IF;
465: l_record_version_number := NULL;
466: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
467: --call schedule's failure method
468: --Log Message
469: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
470: PA_DEBUG.write_log (x_module => 'pa.plsql.PA_ASSIGNMENT_APPROVAL_PVT.Update_Approval_Status.schedule_failure'

Line 594: IF p_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,

590: x_return_status := FND_API.G_RET_STS_SUCCESS;
591:
592:
593: --Check only valid action is passed in.
594: IF p_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,
595: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_update_action,
596: PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action,
597: PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
598: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 595: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_update_action,

591:
592:
593: --Check only valid action is passed in.
594: IF p_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,
595: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_update_action,
596: PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action,
597: PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
598: PA_UTILS.Add_Message( p_app_short_name => 'PA'
599: ,p_msg_name => 'PA_UNEXP_APPRVL_ACTION');

Line 596: PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action,

592:
593: --Check only valid action is passed in.
594: IF p_action_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action, PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action,
595: PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action, PA_ASSIGNMENT_APPROVAL_PUB.g_update_action,
596: PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action, PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action,
597: PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
598: PA_UTILS.Add_Message( p_app_short_name => 'PA'
599: ,p_msg_name => 'PA_UNEXP_APPRVL_ACTION');
600: --dbms_output.put_line('unexpected action code');

Line 607: IF p_status_code IS NOT NULL AND p_status_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approved,

603:
604:
605:
606: --Check only valid assignment approval status is passed in
607: IF p_status_code IS NOT NULL AND p_status_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approved,
608: PA_ASSIGNMENT_APPROVAL_PUB.g_rejected,
609: PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,
610: PA_ASSIGNMENT_APPROVAL_PUB.g_working,
611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN

Line 608: PA_ASSIGNMENT_APPROVAL_PUB.g_rejected,

604:
605:
606: --Check only valid assignment approval status is passed in
607: IF p_status_code IS NOT NULL AND p_status_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approved,
608: PA_ASSIGNMENT_APPROVAL_PUB.g_rejected,
609: PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,
610: PA_ASSIGNMENT_APPROVAL_PUB.g_working,
611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN
612: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 609: PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,

605:
606: --Check only valid assignment approval status is passed in
607: IF p_status_code IS NOT NULL AND p_status_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approved,
608: PA_ASSIGNMENT_APPROVAL_PUB.g_rejected,
609: PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,
610: PA_ASSIGNMENT_APPROVAL_PUB.g_working,
611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN
612: PA_UTILS.Add_Message( p_app_short_name => 'PA'
613: ,p_msg_name => 'PA_INVALID_APPRVL_STUS');

Line 610: PA_ASSIGNMENT_APPROVAL_PUB.g_working,

606: --Check only valid assignment approval status is passed in
607: IF p_status_code IS NOT NULL AND p_status_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approved,
608: PA_ASSIGNMENT_APPROVAL_PUB.g_rejected,
609: PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,
610: PA_ASSIGNMENT_APPROVAL_PUB.g_working,
611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN
612: PA_UTILS.Add_Message( p_app_short_name => 'PA'
613: ,p_msg_name => 'PA_INVALID_APPRVL_STUS');
614: --dbms_output.put_line('unexpected apprvl status');

Line 611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN

607: IF p_status_code IS NOT NULL AND p_status_code NOT IN (PA_ASSIGNMENT_APPROVAL_PUB.g_approved,
608: PA_ASSIGNMENT_APPROVAL_PUB.g_rejected,
609: PA_ASSIGNMENT_APPROVAL_PUB.g_submitted,
610: PA_ASSIGNMENT_APPROVAL_PUB.g_working,
611: PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub) THEN
612: PA_UTILS.Add_Message( p_app_short_name => 'PA'
613: ,p_msg_name => 'PA_INVALID_APPRVL_STUS');
614: --dbms_output.put_line('unexpected apprvl status');
615: x_return_status := FND_API.G_RET_STS_ERROR;

Line 618: IF (p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action

614: --dbms_output.put_line('unexpected apprvl status');
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: END IF;
617:
618: IF (p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action
619: OR
620: p_action_code = PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
621:
622: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

Line 622: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

618: IF (p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submit_action
619: OR
620: p_action_code = PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
621:
622: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
623:
624: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action THEN
625:
626: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;

Line 624: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action THEN

620: p_action_code = PA_MASS_ASGMT_TRX.g_save_and_submit) THEN /*SAVE_AND_SUBMIT added for bug 6625421*/
621:
622: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
623:
624: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action THEN
625:
626: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
627:
628: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action THEN

Line 626: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;

622: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
623:
624: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action THEN
625:
626: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
627:
628: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action THEN
629:
630: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_canceled;

Line 628: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action THEN

624: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_revert_action THEN
625:
626: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
627:
628: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action THEN
629:
630: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_canceled;
631:
632: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN

Line 630: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_canceled;

626: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approved;
627:
628: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action THEN
629:
630: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_canceled;
631:
632: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
633:
634: IF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_working THEN

Line 632: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN

628: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_cancel_action THEN
629:
630: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_canceled;
631:
632: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
633:
634: IF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_working THEN
635:
636: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working;

Line 634: IF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_working THEN

630: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_canceled;
631:
632: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
633:
634: IF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_working THEN
635:
636: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working;
637:
638: ELSIF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN

Line 636: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working;

632: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_update_action THEN
633:
634: IF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_working THEN
635:
636: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working;
637:
638: ELSIF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
639: /*
640: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 638: ELSIF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN

634: IF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_working THEN
635:
636: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_working;
637:
638: ELSIF p_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted THEN
639: /*
640: PA_UTILS.Add_Message( p_app_short_name => 'PA'
641: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 644: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

640: PA_UTILS.Add_Message( p_app_short_name => 'PA'
641: ,p_msg_name => 'PA_WF_APPROVAL_PENDING');
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: */
644: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
645:
646: ELSIF p_status_code IS NULL THEN
647: x_status_code := NULL;
648: ELSE

Line 649: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub;

645:
646: ELSIF p_status_code IS NULL THEN
647: x_status_code := NULL;
648: ELSE
649: x_status_code := PA_ASSIGNMENT_APPROVAL_PUB.g_req_resub;
650: END IF;
651:
652: ELSE
653:

Line 664: (p_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

660: --
661: --call get_workflow_info to get success and failure status code
662: --
663: PA_PROJECT_STUS_UTILS.get_wf_success_failure_status
664: (p_status_code => PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
665: ,p_status_type => 'ASGMT_APPRVL'
666: ,x_wf_success_status_code => l_success_status_code
667: ,x_wf_failure_status_code => l_failure_status_code
668: ,x_return_status => l_return_status

Line 679: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN

675: PA_UTILS.Add_Message( p_app_short_name => 'PA'
676: ,p_msg_name => l_error_message_code);
677: ELSE
678:
679: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
680: x_status_code := l_success_status_code;
681: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
682: x_status_code := l_failure_status_code;
683: END IF;

Line 681: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN

677: ELSE
678:
679: IF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
680: x_status_code := l_success_status_code;
681: ELSIF p_action_code = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
682: x_status_code := l_failure_status_code;
683: END IF;
684: END IF;
685: END IF; --end of checking p_action_code

Line 1303: (l_change_id <> -1 AND l_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)) THEN

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.
1302: IF (l_change_id = -1 OR
1303: (l_change_id <> -1 AND l_apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)) THEN
1304: OPEN get_saved_asmt_rec;
1305: FETCH get_saved_asmt_rec INTO
1306: x_asmt_history_rec.assignment_id,
1307: x_asmt_history_rec.assignment_name,