APPS.ZPB_EXCEPTION_ALERT dependencies on WF_USERS

Line 579: -- if Expired WF users have been detected then send list to BPO or its proxy

575: resultout := 'ERROR';
576: end if;
577:
578: -- b 4948928
579: -- if Expired WF users have been detected then send list to BPO or its proxy
580: -- otherwise do nothing.
581:
582: thisOwnerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
583: Itemkey => ItemKey,

Line 1005: from wf_users

1001: if zpb_wf_ntf.has_Shadow(thisOwnerID) = 'Y' then
1002: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisOwnerID);
1003: select distinct display_name
1004: into NewDispName
1005: from wf_users
1006: where name = thisOwner;
1007:
1008: -- add (And Shadows) display to role dispaly name
1009: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 1035: from wf_users

1031: if zpb_wf_ntf.has_Shadow(thisApproverID) = 'Y' then
1032: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisApproverID);
1033: select distinct display_name
1034: into NewDispName
1035: from wf_users
1036: where name = thisApprover;
1037:
1038: -- add (And Shadows) display to role dispaly name
1039: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 1684: from wf_users

1680: if zpb_wf_ntf.has_Shadow(thisRecipientID) = 'Y' then
1681: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisRecipientID);
1682: select distinct display_name
1683: into NewDispName
1684: from wf_users
1685: where name = thisRecipient;
1686:
1687: -- add (And Shadows) display to role dispaly name
1688: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 1713: from wf_users

1709: if zpb_wf_ntf.has_Shadow(thisApproverID) = 'Y' then
1710: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisApproverID);
1711: select distinct display_name
1712: into NewDispName
1713: from wf_users
1714: where name = thisApprover;
1715:
1716: -- add (And Shadows) display to role dispaly name
1717: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 2277: from wf_users

2273: if zpb_wf_ntf.has_Shadow(thisOwnerID) = 'Y' then
2274: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisOwnerID);
2275: select distinct display_name
2276: into NewDispName
2277: from wf_users
2278: where name = thisOwner;
2279:
2280: -- add (And Shadows) display to role dispaly name
2281: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 2304: from wf_users

2300: if zpb_wf_ntf.has_Shadow(thisApproverID) = 'Y' then
2301: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisApproverID);
2302: select distinct display_name
2303: into NewDispName
2304: from wf_users
2305: where name = thisApprover;
2306:
2307: -- add (And Shadows) display to role dispaly name
2308: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 2430: -- if Expired WF users have been detected then send list to BPO or its proxy

2426: ItemKey => NewItemKey);
2427: end loop;
2428:
2429: -- b 4948928
2430: -- if Expired WF users have been detected then send list to BPO or its proxy
2431: -- otherwise do nothing.
2432:
2433: ProcOwnerID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,
2434: Itemkey => ItemKey,

Line 2709: from wf_users

2705: if zpb_wf_ntf.has_Shadow(thisOwnerID) = 'Y' then
2706: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID);
2707: select distinct display_name
2708: into NewDispName
2709: from wf_users
2710: where name = thisOwner;
2711:
2712: -- add (And Shadows) display to role dispaly name
2713: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 2919: from wf_users

2915: if zpb_wf_ntf.has_Shadow(thisRecipientID) = 'Y' then
2916: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisRecipientID);
2917: select distinct display_name
2918: into NewDispName
2919: from wf_users
2920: where name = thisRecipient;
2921:
2922: -- add (And Shadows) display to role dispaly name
2923: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 2948: from wf_users

2944: if zpb_wf_ntf.has_Shadow(thisApproverID) = 'Y' then
2945: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID, thisApproverID);
2946: select distinct display_name
2947: into NewDispName
2948: from wf_users
2949: where name = thisApprover;
2950:
2951: -- add (And Shadows) display to role dispaly name
2952: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');