DBA Data[Home] [Help]

APPS.ZPB_WF_NTF dependencies on ZPB_TASK_PARAMETERS

Line 279: from ZPB_TASK_PARAMETERS

275: l_deadDate varchar2(100);
276:
277: CURSOR c_tparams is
278: select NAME, value
279: from ZPB_TASK_PARAMETERS
280: where TASK_ID = TaskID;
281:
282: v_tparams c_tparams%ROWTYPE;
283:

Line 377: from zpb_task_parameters

373: -- if workflowprocess = 'NOTIFY' then
374: -- bug 3482485
375:
376: select value into l_authorIDT
377: from zpb_task_parameters
378: where task_id = TaskID and name = 'OWNER_ID';
379:
380: authorID := to_number(l_authorIDT);
381:

Line 389: -- read parameters from ZPB_TASK_PARAMETERS using task ID.

385: avalue => ZPB_WF_NTF.ID_to_FNDUser(authorID));
386:
387: -- end if;
388:
389: -- read parameters from ZPB_TASK_PARAMETERS using task ID.
390:
391: UserList := 'NONE';
392: Dtype := 'NONE';
393: UserToNotifyP := 'N';

Line 880: from ZPB_TASK_PARAMETERS

876:
877:
878: CURSOR c_recipient is
879: select NAME, value
880: from ZPB_TASK_PARAMETERS
881: where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';
882:
883: v_recipient c_recipient%ROWTYPE;
884:

Line 887: from ZPB_TASK_PARAMETERS

883: v_recipient c_recipient%ROWTYPE;
884:
885: CURSOR c_type is
886: select name, value
887: from ZPB_TASK_PARAMETERS
888: where TASK_ID = TaskID and name = 'NOTIFICATION_RECIPIENT_TYPE';
889:
890: v_type c_type%ROWTYPE;
891:

Line 909: from ZPB_TASK_PARAMETERS

905: end if;
906:
907: select count(*)
908: into cCount
909: from ZPB_TASK_PARAMETERS
910: where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';
911:
912:
913: InstanceID := wf_engine.GetItemAttrNumber(Itemtype => ItemType,