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.OKC_REP_WF_PVT dependencies on WF_NOTIFICATION

Line 457: -- WF Notification process are started for the approvers pending notification

453: -- Start of comments
454: --API name : is_approval_complete
455: --Type : Private.
456: --Function : This procedure is called by workflow Master Process to check if the approval is complete.
457: -- WF Notification process are started for the approvers pending notification
458: -- Updates workflow with the approver list.
459: --Pre-reqs : None.
460: --Parameters :
461: --IN : itemtype IN VARCHAR2 Required

Line 952: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

948:
949: CURSOR notif_csr (p_notification_id NUMBER) IS
950: SELECT fu.user_id user_id, fu.user_name user_name,
951: fu1.user_id original_user_id,fu1.user_name original_user_name
952: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
953: WHERE fu.user_name = wfn.recipient_role
954: AND fu1.user_name = wfn.original_recipient
955: AND wfn.notification_id = p_notification_id ;
956:

Line 985: l_wf_note := WF_NOTIFICATION.GetAttrText(

981: itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'CONTRACT_VERSION');
984: -- Get the approver comments
985: l_wf_note := WF_NOTIFICATION.GetAttrText(
986: nid => WF_ENGINE.context_nid,
987: aname => 'WF_NOTE');
988: -- Get the approval status
989: l_approval_status := WF_NOTIFICATION.GetAttrText(

Line 989: l_approval_status := WF_NOTIFICATION.GetAttrText(

985: l_wf_note := WF_NOTIFICATION.GetAttrText(
986: nid => WF_ENGINE.context_nid,
987: aname => 'WF_NOTE');
988: -- Get the approval status
989: l_approval_status := WF_NOTIFICATION.GetAttrText(
990: nid => WF_ENGINE.context_nid,
991: aname => 'RESULT');
992: --14758583 : kkolukul : HR position support
993: l_approver_type := WF_NOTIFICATION.GetAttrText(

Line 993: l_approver_type := WF_NOTIFICATION.GetAttrText(

989: l_approval_status := WF_NOTIFICATION.GetAttrText(
990: nid => WF_ENGINE.context_nid,
991: aname => 'RESULT');
992: --14758583 : kkolukul : HR position support
993: l_approver_type := WF_NOTIFICATION.GetAttrText(
994: nid => WF_ENGINE.context_nid,
995: aname => 'APPROVER_TYPE');
996: l_approver_name := WF_NOTIFICATION.GetAttrText(
997: nid => WF_ENGINE.context_nid,

Line 996: l_approver_name := WF_NOTIFICATION.GetAttrText(

992: --14758583 : kkolukul : HR position support
993: l_approver_type := WF_NOTIFICATION.GetAttrText(
994: nid => WF_ENGINE.context_nid,
995: aname => 'APPROVER_TYPE');
996: l_approver_name := WF_NOTIFICATION.GetAttrText(
997: nid => WF_ENGINE.context_nid,
998: aname => 'APPROVER_POS_NAME');
999:
1000: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1292: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

1288:
1289: CURSOR notif_csr (p_notification_id NUMBER) IS
1290: SELECT fu.user_id user_id, fu.user_name user_name,
1291: fu1.user_id original_user_id,fu1.user_name original_user_name
1292: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
1293: WHERE fu.user_name = wfn.recipient_role
1294: AND fu1.user_name = wfn.original_recipient
1295: AND wfn.notification_id = p_notification_id ;
1296:

Line 1327: l_wf_note := WF_NOTIFICATION.GetAttrText(

1323: itemtype => itemtype,
1324: itemkey => itemkey,
1325: aname => 'CONTRACT_VERSION');
1326: -- Get the approver comments
1327: l_wf_note := WF_NOTIFICATION.GetAttrText(
1328: nid => WF_ENGINE.context_nid,
1329: aname => 'WF_NOTE');
1330: -- Get the approval status
1331: l_approval_status := WF_NOTIFICATION.GetAttrText(

Line 1331: l_approval_status := WF_NOTIFICATION.GetAttrText(

1327: l_wf_note := WF_NOTIFICATION.GetAttrText(
1328: nid => WF_ENGINE.context_nid,
1329: aname => 'WF_NOTE');
1330: -- Get the approval status
1331: l_approval_status := WF_NOTIFICATION.GetAttrText(
1332: nid => WF_ENGINE.context_nid,
1333: aname => 'RESULT');
1334: -- 14758583 : kkolukul : HR position support
1335: l_approver_type := WF_NOTIFICATION.GetAttrText(

Line 1335: l_approver_type := WF_NOTIFICATION.GetAttrText(

1331: l_approval_status := WF_NOTIFICATION.GetAttrText(
1332: nid => WF_ENGINE.context_nid,
1333: aname => 'RESULT');
1334: -- 14758583 : kkolukul : HR position support
1335: l_approver_type := WF_NOTIFICATION.GetAttrText(
1336: nid => WF_ENGINE.context_nid,
1337: aname => 'APPROVER_TYPE');
1338: l_approver_name := WF_NOTIFICATION.GetAttrText(
1339: nid => WF_ENGINE.context_nid,

Line 1338: l_approver_name := WF_NOTIFICATION.GetAttrText(

1334: -- 14758583 : kkolukul : HR position support
1335: l_approver_type := WF_NOTIFICATION.GetAttrText(
1336: nid => WF_ENGINE.context_nid,
1337: aname => 'APPROVER_TYPE');
1338: l_approver_name := WF_NOTIFICATION.GetAttrText(
1339: nid => WF_ENGINE.context_nid,
1340: aname => 'APPROVER_POS_NAME');
1341: --Bug 16231003
1342: l_group_id := WF_NOTIFICATION.GetAttrText(

Line 1342: l_group_id := WF_NOTIFICATION.GetAttrText(

1338: l_approver_name := WF_NOTIFICATION.GetAttrText(
1339: nid => WF_ENGINE.context_nid,
1340: aname => 'APPROVER_POS_NAME');
1341: --Bug 16231003
1342: l_group_id := WF_NOTIFICATION.GetAttrText(
1343: nid => WF_ENGINE.context_nid,
1344: aname => 'APPROVER_GROUP_ID');
1345:
1346: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1505: l_forwardTo := wf_notification.GetAttrText(WF_ENGINE.context_nid, 'FORWARD_TO_USERNAME_RESPONSE');

1501: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1502: END IF;
1503:
1504:
1505: l_forwardTo := wf_notification.GetAttrText(WF_ENGINE.context_nid, 'FORWARD_TO_USERNAME_RESPONSE');
1506:
1507: if(l_forwardTo is null) then
1508: fnd_message.set_name('OKC', 'OKC_WF_NOTIF_NO_USER');
1509: app_exception.raise_exception;