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_ASGMT_WFSTD dependencies on PA_ASSIGNMENT_APPROVAL_PUB

Line 3500: IF (l_conflict_group_id IS NOT NULL AND p_result_type=PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action) THEN

3496: ( itemtype => p_item_type
3497: , itemkey => p_item_key
3498: , aname => 'WORKFLOW_STARTED_BY_UNAME');
3499:
3500: IF (l_conflict_group_id IS NOT NULL AND p_result_type=PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action) THEN
3501: -- resolve remaining conflicts by taking action chosen by user
3502: PA_SCHEDULE_PVT.RESOLVE_CONFLICTS (p_conflict_group_id => l_conflict_group_id
3503: ,p_assignment_id => p_assignment_id
3504: ,x_return_status => l_return_status

Line 4550: AND asmt.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_rejected;

4546: WHERE pf.group_id = p_group_id
4547: AND pf.approver_group_id = p_approver_group_id
4548: AND pf.routing_order = p_routing_order
4549: AND pf.object_id1 = asmt.assignment_id
4550: AND asmt.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_rejected;
4551: EXCEPTION
4552: WHEN NO_DATA_FOUND THEN
4553: l_number_of_assignments := 0;
4554: END;

Line 4954: IF l_aprvl_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN

4950: WHERE assignment_id = p_assignment_id;
4951:
4952: log_message('After getting recepients approval type:' || l_aprvl_status);
4953:
4954: IF l_aprvl_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
4955: l_notification_type := 'APPROVAL_FYI';
4956: ELSE l_notification_type := 'REJECTION_FYI';
4957: END IF;
4958:

Line 5097: IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN

5093:
5094: ----------------------------------------------------------------
5095: -- Set subject, description and overcommiment conflict detail URL
5096: ---------------------------------------------------------------
5097: IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
5098:
5099: -- If there is no overcommitment conflict
5100: IF (p_conflict_group_id IS NULL) THEN
5101: l_msg_subj_code := 'PA_NFSUBJ_ASGMT_APPROVED';

Line 5124: END IF; -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)

5120: END IF; -- If (p_conflict_group_id IS NULL)
5121: ELSE
5122: l_msg_subj_code := 'PA_NFSUBJ_ASGMT_REJECTED';
5123: l_msg_desc_code := 'PA_NFDESC_ASGMT_REJECTED';
5124: END IF; -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved)
5125:
5126: -- get the message from fnd messages for subject and description
5127: FND_MESSAGE.SET_NAME ('PA',l_msg_subj_code);
5128: l_msg_subj_text := FND_MESSAGE.GET;

Line 5156: -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved AND

5152: , itemkey => l_itemkey
5153: , aname => 'MSG_DESCRIPTION'
5154: , avalue => l_msg_desc_text );
5155:
5156: -- IF (l_assignments_rec.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved AND
5157: -- p_conflict_group_id IS NOT NULL) THEN
5158: wf_engine.SetItemAttrText
5159: ( itemtype => l_wf_item_type
5160: , itemkey => l_itemkey

Line 6066: IF l_aprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN

6062: INTO l_aprvl_status_code
6063: FROM pa_project_assignments
6064: WHERE assignment_id = l_assignment_id_tbl(i);
6065:
6066: IF l_aprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
6067: l_notification_type := 'APPROVAL_FYI';
6068: ELSE l_notification_type := 'REJECTION_FYI';
6069: END IF;
6070:

Line 6742: IF (pending_approvals%NOTFOUND) OR (p_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action) THEN

6738:
6739: OPEN pending_approvals (p_assignment_id);
6740: FETCH pending_approvals INTO l_pending_approvals;
6741:
6742: IF (pending_approvals%NOTFOUND) OR (p_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action) THEN
6743:
6744: log_message('No pending approvals for assignment:' || p_assignment_id);
6745:
6746: OPEN get_rec_num ( p_assignment_id );

Line 6901: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

6897: FROM pa_wf_ntf_performers ntf,
6898: pa_project_assignments asgn
6899: WHERE ntf.group_id = p_group_id
6900: AND ntf.object_id1 = asgn.assignment_id
6901: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
6902: AND ntf.routing_order = p_routing_order + 1; */
6903:
6904: CURSOR distinct_approvers IS
6905: SELECT distinct ntf.user_name

Line 6911: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted

6907: pa_project_assignments asgn,
6908: pa_wf_ntf_performers ntf1
6909: WHERE ntf.group_id = p_group_id
6910: AND ntf.object_id1 = asgn.assignment_id
6911: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted
6912: AND ntf.routing_order = p_routing_order + 1
6913: AND ntf1.group_id = p_group_id
6914: AND ntf1.object_id1 = asgn.assignment_id
6915: AND ntf1.routing_order = p_routing_order

Line 6924: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

6920: FROM pa_wf_ntf_performers ntf,
6921: pa_project_assignments asgn
6922: WHERE ntf.group_id = p_group_id
6923: AND ntf.object_id1 = asgn.assignment_id
6924: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
6925:
6926: l_pending_txn_approvals pending_txn_approvals%ROWTYPE;
6927:
6928: l_num_apr_asgns NUMBER;

Line 7020: IF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN

7016: FOR i IN 1..p_assignment_id_tbl.COUNT LOOP
7017:
7018: l_approval_status := p_approval_status_tbl(i);
7019:
7020: IF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
7021:
7022: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
7023: --l_num_apr_asgns := l_num_apr_asgns + 1;
7024:

Line 7022: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

7018: l_approval_status := p_approval_status_tbl(i);
7019:
7020: IF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action THEN
7021:
7022: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
7023: --l_num_apr_asgns := l_num_apr_asgns + 1;
7024:
7025: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
7026:

Line 7025: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN

7021:
7022: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
7023: --l_num_apr_asgns := l_num_apr_asgns + 1;
7024:
7025: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
7026:
7027: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action;
7028: --l_num_rej_asgns := l_num_rej_asgns + 1;
7029:

Line 7027: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action;

7023: --l_num_apr_asgns := l_num_apr_asgns + 1;
7024:
7025: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action THEN
7026:
7027: l_action_code := PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action;
7028: --l_num_rej_asgns := l_num_rej_asgns + 1;
7029:
7030: END IF;
7031:

Line 7081: AND p_approval_status_tbl(k) = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;

7077: WHERE group_id = p_group_id
7078: AND user_name = rec.user_name
7079: AND routing_order = p_routing_order + 1
7080: AND object_id1 = p_assignment_id_tbl(k)
7081: AND p_approval_status_tbl(k) = PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
7082:
7083: log_message('New approver group id:' || l_approver_group_id);
7084:
7085: ----------------------------------------------------------

Line 7157: IF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN

7153: WHEN NO_DATA_FOUND THEN
7154: null;
7155: END;
7156:
7157: IF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
7158:
7159: l_num_apr_asgns := l_num_apr_asgns + 1;
7160:
7161: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected THEN

Line 7161: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected THEN

7157: IF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_approved THEN
7158:
7159: l_num_apr_asgns := l_num_apr_asgns + 1;
7160:
7161: ELSIF l_approval_status = PA_ASSIGNMENT_APPROVAL_PUB.g_rejected THEN
7162:
7163: l_num_rej_asgns := l_num_rej_asgns + 1;
7164:
7165: END IF;

Line 7860: AND ( asgn.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_rejected OR

7856: AND ntf.routing_order = l_routing_order
7857: AND ntf.user_name = l_ntfy_apprvl_recip_name -- added for bug 5488496
7858: AND ntf.object_id1 = asgn.assignment_id
7859: AND ntf.object_id2 <> 100
7860: AND ( asgn.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_rejected OR
7861: asgn.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved );
7862:
7863: l_pending_txn_approvals pending_txn_approvals%ROWTYPE;
7864:

Line 7861: asgn.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved );

7857: AND ntf.user_name = l_ntfy_apprvl_recip_name -- added for bug 5488496
7858: AND ntf.object_id1 = asgn.assignment_id
7859: AND ntf.object_id2 <> 100
7860: AND ( asgn.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_rejected OR
7861: asgn.apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved );
7862:
7863: l_pending_txn_approvals pending_txn_approvals%ROWTYPE;
7864:
7865: BEGIN

Line 7928: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

7924: WHERE ntf.group_id = l_group_id
7925: AND ntf.approver_group_id = l_approver_group_id
7926: AND ntf.routing_order = l_routing_order
7927: AND ntf.object_id1 = asgn.assignment_id
7928: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
7929:
7930: l_project_id := wf_engine.getItemAttrNumber
7931: ( itemtype => itemtype
7932: , itemkey => itemkey

Line 7970: l_approval_status_tbl(i) := PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action;

7966: , aname => 'NOTE_TO_APPROVER');
7967:
7968: FOR i IN 1..l_assignment_id_tbl.COUNT LOOP
7969: l_approval_status_tbl.extend;
7970: l_approval_status_tbl(i) := PA_ASSIGNMENT_APPROVAL_PUB.g_reject_action;
7971: END LOOP;
7972:
7973: process_approval_result
7974: ( p_project_id => l_project_id

Line 8100: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;

8096: pa_project_assignments asgn
8097: WHERE ntf.group_id = l_group_id
8098: AND ntf.routing_order = 1
8099: AND ntf.object_id1 = asgn.assignment_id
8100: AND asgn.apprvl_status_code = PA_ASSIGNMENT_APPROVAL_PUB.g_submitted;
8101:
8102:
8103: --if there are any aborted items then add a message to the stack
8104: --saying that those items were aborted by the sysadmin.