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;
946: NewDispName := NewDispName || l_label;
947:
948: zpb_wf_ntf.SetRole(rolename, relative+7, 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;
946: NewDispName := NewDispName || l_label;
947:
948: zpb_wf_ntf.SetRole(rolename, relative+7, NewDispName);
949: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
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');
990: l_label := FND_MESSAGE.GET;
991: NewDispName := NewDispName || l_label;
992: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
993: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisOwner);
986: where name = thisOwner;
987:
988: -- add (And Shadows) display to role dispaly name
989: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
990: l_label := FND_MESSAGE.GET;
991: NewDispName := NewDispName || l_label;
992: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
993: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisOwner);
994: zpb_wf_ntf.add_Shadow(rolename, thisOwnerID);
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');
1323: l_label := FND_MESSAGE.GET;
1324: NewDispName := NewDispName || l_label;
1325:
1326: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
1319: where name = curUser;
1320:
1321: -- add (And Shadows) display to role dispaly name
1322: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_ANDSHADOWS');
1323: l_label := FND_MESSAGE.GET;
1324: NewDispName := NewDispName || l_label;
1325:
1326: zpb_wf_ntf.SetRole(rolename, relative, NewDispName);
1327: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, curUser);
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;
1506:
1507: l_NewDispName := l_NewDispName || l_label;
1508: zpb_wf_ntf.SetRole(l_RoleName, 7, 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;
1506:
1507: l_NewDispName := l_NewDispName || l_label;
1508: zpb_wf_ntf.SetRole(l_RoleName, 7, l_NewDispName);
1509: -- b4948928
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;
1670: l_NewDispName := l_NewDispName || l_label;
1671:
1672:
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;
1670: l_NewDispName := l_NewDispName || l_label;
1671:
1672:
1673: zpb_wf_ntf.SetRole(l_RoleName, 7, l_NewDispName);