APPS.ZPB_WF_NTF dependencies on WF_USERS

Line 500: -- sets wf_local_roles, wf_local_user_roles for views wf_users, wf_roles

496: avalue => l_deadDate);
497: end if;
498:
499: -- Create AdHoc Roles when needed and set user lists for WF Directory
500: -- sets wf_local_roles, wf_local_user_roles for views wf_users, wf_roles
501: -- and wf_user_roles.
502:
503: if UserToNotifyP = 'Y' then
504:

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

540: end if;
541:
542:
543: -- b 4948928
544: -- if Expired WF users have been detected then send list to BPO or its proxy
545: -- otherwise do nothing.
546: zpb_wf_ntf.SendExpiredUserMsg(thisOwnerID, TaskID, itemType);
547:
548:

Line 941: from wf_users

937: if zpb_wf_ntf.has_Shadow(thisUserID) = 'Y' then
938: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID);
939: select distinct display_name
940: into NewDispName
941: from wf_users
942: where name = thisRecipient;
943: -- add (And Shadows) display to role dispaly name
944: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
945: l_label := FND_MESSAGE.GET;

Line 985: from wf_users

981: if zpb_wf_ntf.has_Shadow(thisOwnerID) = 'Y' then
982: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID);
983: select distinct display_name
984: into NewDispName
985: from wf_users
986: where name = thisOwner;
987:
988: -- add (And Shadows) display to role dispaly name
989: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 1318: from wf_users

1314: if zpb_wf_ntf.has_Shadow(curUserID) = 'Y' then
1315: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID);
1316: select distinct display_name
1317: into NewDispName
1318: from wf_users
1319: where name = curUser;
1320:
1321: -- add (And Shadows) display to role dispaly name
1322: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');

Line 1501: from wf_users

1497: --DBMS_OUTPUT.PUT_LINE('has shadow');
1498: l_RoleName := zpb_wf_ntf.MakeRoleName(l_InstanceID, l_TaskID);
1499: select distinct display_name
1500: into l_NewDispName
1501: from wf_users
1502: where name = l_thisRecipient;
1503: -- add (And Shadows) display to role dispaly name
1504: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1505: l_label := FND_MESSAGE.GET;

Line 1665: from wf_users

1661: l_RoleName := zpb_wf_ntf.MakeRoleName(l_InstanceID, l_TaskID);
1662:
1663: select distinct display_name
1664: into l_NewDispName
1665: from wf_users
1666: where name = l_thisRecipient;
1667: -- add (And Shadows) display to role dispaly name
1668: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1669: l_label := FND_MESSAGE.GET;