DBA Data[Home] [Help]

APPS.ZPB_WF_EVENT dependencies on ZPB_WF_NTF

Line 70: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);

66: into ACstatusCode, ACname, OwnerID
67: from zpb_analysis_cycles
68: where ANALYSIS_CYCLE_ID = ACID;
69:
70: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);
71:
72:
73:
74:

Line 260: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);

256: ZPB_WF_EVENT.SET_AUTHORIZED_USERS (ACID, OwnerID, itemtype, itemkey, instanceID);
257: else
258: -- some error encountered
259: -- BUG 4355208 WF_INVALID_ROLE ancillary corrections for rolename and recipients
260: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);
261: zpb_wf_ntf.SetRole(rolename, relative);
262:
263: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT
264: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,

Line 261: zpb_wf_ntf.SetRole(rolename, relative);

257: else
258: -- some error encountered
259: -- BUG 4355208 WF_INVALID_ROLE ancillary corrections for rolename and recipients
260: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);
261: zpb_wf_ntf.SetRole(rolename, relative);
262:
263: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT
264: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,
265: Itemkey => ItemKey,

Line 269: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then

265: Itemkey => ItemKey,
266: aname => 'EPBPERFORMER');
267:
268:
269: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
270: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
271: end if;
272:
273: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT

Line 278: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then

274: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,
275: Itemkey => ItemKey,
276: aname => 'FNDUSERNAM');
277:
278: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
279: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
280: end if;
281:
282: -- reset EPBPERFORMER to ntf role

Line 388: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);

384: ('ZPB_CONTROLLER_RESP', 'ZPB_SUPER_CONTROLLER_RESP', 'ZPB_MANAGER_RESP'));
385:
386: -- fnd_global.apps_initialize(ownerID, respID, RespAppId);
387:
388: Owner := ZPB_WF_NTF.ID_to_FNDUser(OwnerID);
389: workflow := 'ACIDWFEVENT_START';
390:
391: -- create itemkey and event key for workflow - they are the same value
392: charDate := to_char(sysdate, 'MM/DD/YYYY-HH24-MI-SS');

Line 418: wf_event.AddParameterToList('FNDUSERNAM', ZPB_WF_NTF.ID_to_FNDUser(fnd_global.USER_ID), l_parameter_list);

414: wf_event.AddParameterToList('EPBPERFORMER', Owner, l_parameter_list);
415: wf_event.AddParameterToList('WF_ADMINISTRATOR', Owner, l_parameter_list);
416: -- wf_event.AddParameterToList('FNDUSERNAM', Owner, l_parameter_list);
417: -- caller of program
418: wf_event.AddParameterToList('FNDUSERNAM', ZPB_WF_NTF.ID_to_FNDUser(fnd_global.USER_ID), l_parameter_list);
419:
420:
421: -- Budnik, A. 1/12/06 B 4947816 add in business area id
422: wf_event.AddParameterToList('BUSINESSAREAID', l_business_area_id, l_parameter_list);

Line 462: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);

458:
459: BEGIN
460: -- BUG 4355208 WF_INVALID_ROLE moved here from loop below.
461: -- make and set role name we will always generate a role even for one user.
462: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);
463: zpb_wf_ntf.SetRole(rolename, relative);
464: -- end BUG 4355208
465:
466: for v_notify in c_notify loop

Line 463: zpb_wf_ntf.SetRole(rolename, relative);

459: BEGIN
460: -- BUG 4355208 WF_INVALID_ROLE moved here from loop below.
461: -- make and set role name we will always generate a role even for one user.
462: rolename := zpb_wf_ntf.MakeRoleName(ACID, instanceID, OwnerID);
463: zpb_wf_ntf.SetRole(rolename, relative);
464: -- end BUG 4355208
465:
466: for v_notify in c_notify loop
467:

Line 470: thisRecipient:= zpb_wf_ntf.ID_to_FNDUser(thisrecipID);

466: for v_notify in c_notify loop
467:
468: thisRecipID := v_notify.user_id;
469: -- convert ID to username
470: thisRecipient:= zpb_wf_ntf.ID_to_FNDUser(thisrecipID);
471:
472: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
473: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
474: -- DBMS_OUTPUT.PUT_LINE('name set2: ' || thisRecipient);

Line 472: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then

468: thisRecipID := v_notify.user_id;
469: -- convert ID to username
470: thisRecipient:= zpb_wf_ntf.ID_to_FNDUser(thisrecipID);
471:
472: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
473: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
474: -- DBMS_OUTPUT.PUT_LINE('name set2: ' || thisRecipient);
475: end if;
476:

Line 478: -- thisUserID := zpb_wf_ntf.fnduser_to_ID(thisRecipient);

474: -- DBMS_OUTPUT.PUT_LINE('name set2: ' || thisRecipient);
475: end if;
476:
477: -- add in shadow if there is one
478: -- thisUserID := zpb_wf_ntf.fnduser_to_ID(thisRecipient);
479: zpb_wf_ntf.add_Shadow(rolename, thisRecipID);
480:
481: end loop;
482:

Line 479: zpb_wf_ntf.add_Shadow(rolename, thisRecipID);

475: end if;
476:
477: -- add in shadow if there is one
478: -- thisUserID := zpb_wf_ntf.fnduser_to_ID(thisRecipient);
479: zpb_wf_ntf.add_Shadow(rolename, thisRecipID);
480:
481: end loop;
482:
483: -- add BP owner as recipient also

Line 484: thisRecipient := zpb_wf_ntf.ID_to_FNDUser(OwnerID);

480:
481: end loop;
482:
483: -- add BP owner as recipient also
484: thisRecipient := zpb_wf_ntf.ID_to_FNDUser(OwnerID);
485:
486: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
487: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
488: zpb_wf_ntf.add_Shadow(rolename, OwnerID);

Line 486: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then

482:
483: -- add BP owner as recipient also
484: thisRecipient := zpb_wf_ntf.ID_to_FNDUser(OwnerID);
485:
486: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
487: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
488: zpb_wf_ntf.add_Shadow(rolename, OwnerID);
489: -- DBMS_OUTPUT.PUT_LINE('owner name set: ' || thisRecipient);
490: end if;

Line 488: zpb_wf_ntf.add_Shadow(rolename, OwnerID);

484: thisRecipient := zpb_wf_ntf.ID_to_FNDUser(OwnerID);
485:
486: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
487: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
488: zpb_wf_ntf.add_Shadow(rolename, OwnerID);
489: -- DBMS_OUTPUT.PUT_LINE('owner name set: ' || thisRecipient);
490: end if;
491:
492: -- BUG 4355208 WF_INVALID_ROLE add in caller if not already there.

Line 497: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then

493: -- BUG 4407850 06/02/2005 NTF NOT SENT TO CALLER changed ATTRNumber to ATTRTEXT
494: thisRecipient := wf_engine.GetItemAttrText(Itemtype => ItemType,
495: Itemkey => ItemKey, aname => 'FNDUSERNAM');
496:
497: if zpb_wf_ntf.user_in_role(rolename, thisRecipient) = 'N' then
498: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, thisRecipient);
499: end if;
500:
501: -- end BUG 4355208