APPS.ZPB_EXCEPTION_ALERT dependencies on ZPB_TASK_PARAMETERS

Line 35: from ZPB_TASK_PARAMETERS

31: where TASK_ID = TaskID;
32:
33: if countEx > 0 then
34: select value into ExplainReq
35: from ZPB_TASK_PARAMETERS
36: where TASK_ID = TaskID and NAME = 'EXPLANATION_REQUIRED_FLAG';
37:
38: -- type of exception
39: if ExplainReq = 'N' then

Line 80: from ZPB_TASK_PARAMETERS

76: l_label varchar2(4000);
77:
78: CURSOR c_tskparams is
79: select NAME, VALUE
80: from ZPB_TASK_PARAMETERS
81: where TASK_ID = TaskID and NAME <> 'SPECIFIED_TARGET_NAME';
82:
83: v_tskparams c_tskparams%ROWTYPE;
84:

Line 163: from zpb_task_parameters

159: end if;
160:
161: -- bug 3482485
162: select value into l_authorIDT
163: from zpb_task_parameters
164: where task_id = TaskID and name = 'OWNER_ID';
165:
166: authorID := to_number(l_authorIDT);
167:

Line 199: from ZPB_TASK_PARAMETERS

195: errmsg varchar2(100);
196:
197: CURSOR c_recipient is
198: select NAME, value
199: from ZPB_TASK_PARAMETERS
200: where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';
201:
202: v_recipient c_recipient%ROWTYPE;
203:

Line 298: from zpb_task_parameters

294:
295:
296: -- bug 3482485
297: select value into l_authorIDT
298: from zpb_task_parameters
299: where task_id = TaskID and name = 'OWNER_ID';
300:
301: AuthorID := to_number(l_authorIDT);
302:

Line 306: from ZPB_TASK_PARAMETERS

302:
303:
304: select VALUE
305: into ExcType
306: from ZPB_TASK_PARAMETERS
307: where TASK_ID = TaskID and name = 'EXCEPTION_TYPE';
308:
309: -- create NEWItemKey for FYI workflow
310: charDate := to_char(sysdate, 'MM/DD/YYYY-HH24:MI:SS');

Line 466: from ZPB_TASK_PARAMETERS

462: thisOwnerID number; -- b 4948928
463:
464: CURSOR c_deadline is
465: select NAME, VALUE
466: from ZPB_TASK_PARAMETERS
467: where TASK_ID = TaskID and ( NAME = 'WAIT_TYPE' or NAME = 'WAIT_VALUE' );
468:
469: v_deadline c_deadline%ROWTYPE;
470:

Line 484: from zpb_task_parameters

480: aname => 'TASKID');
481:
482: -- bug 3482485
483: select value into l_authorIDT
484: from zpb_task_parameters
485: where task_id = TaskID and name = 'OWNER_ID';
486:
487: authorID := to_number(l_authorIDT);
488:

Line 495: from ZPB_TASK_PARAMETERS

491: aname => '#FROM_ROLE',
492: avalue => ZPB_WF_NTF.ID_to_FNDUser(authorID));
493:
494: select value into ntfType
495: from ZPB_TASK_PARAMETERS
496: where TASK_ID = TaskID and NAME = 'EXPLANATION_REQUIRED_FLAG';
497:
498: select value into ntfTarget
499: from ZPB_TASK_PARAMETERS

Line 499: from ZPB_TASK_PARAMETERS

495: from ZPB_TASK_PARAMETERS
496: where TASK_ID = TaskID and NAME = 'EXPLANATION_REQUIRED_FLAG';
497:
498: select value into ntfTarget
499: from ZPB_TASK_PARAMETERS
500: where TASK_ID = TaskID and NAME = 'NOTIFICATION_RECIPIENT_TYPE';
501:
502: select value into ExcType
503: from ZPB_TASK_PARAMETERS

Line 503: from ZPB_TASK_PARAMETERS

499: from ZPB_TASK_PARAMETERS
500: where TASK_ID = TaskID and NAME = 'NOTIFICATION_RECIPIENT_TYPE';
501:
502: select value into ExcType
503: from ZPB_TASK_PARAMETERS
504: where TASK_ID = TaskID and NAME = 'EXCEPTION_TYPE';
505:
506: if NtfType = 'N' then
507:

Line 689: select value into l_dimname from ZPB_TASK_PARAMETERS

685:
686:
687: -- Exceptionable member[s]:
688:
689: select value into l_dimname from ZPB_TASK_PARAMETERS
690: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
691:
692: -- Following ZPB_WF_DIMNAME members have an alert
693:

Line 1197: from ZPB_TASK_PARAMETERS

1193:
1194: -- Exceptionable member[s]:
1195:
1196: select value into l_dimname
1197: from ZPB_TASK_PARAMETERS
1198: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
1199:
1200: -- Following ZPB_WF_DIMNAME members have an alert
1201: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');

Line 1589: from ZPB_TASK_PARAMETERS

1585: v_child c_children%ROWTYPE;
1586:
1587: CURSOR c_recipient is
1588: select value
1589: from ZPB_TASK_PARAMETERS
1590: where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';
1591:
1592: v_recipient c_recipient%ROWTYPE;
1593:

Line 1636: from ZPB_TASK_PARAMETERS

1632: where INSTANCE_AC_ID = InstanceID;
1633:
1634: select value
1635: into ApproverTYPE
1636: from ZPB_TASK_PARAMETERS
1637: where TASK_ID = TaskID and name = 'EXPLANATION_APPROVER';
1638:
1639: if ApproverTYPE = 'AUTHOR_OF_EXCEPTION' then
1640: thisApprover := zpb_wf_ntf.ID_to_fnduser(thisApproverID);

Line 1863: from ZPB_TASK_PARAMETERS

1859: l_label varchar2(4000);
1860:
1861: CURSOR c_tparams is
1862: select NAME, value
1863: from ZPB_TASK_PARAMETERS
1864: where TASK_ID = TaskID;
1865:
1866: v_tparams c_tparams%ROWTYPE;
1867:

Line 2541: from ZPB_TASK_PARAMETERS

2537:
2538: -- Exceptionable member[s]:
2539:
2540: select value into l_dimname
2541: from ZPB_TASK_PARAMETERS
2542: where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';
2543:
2544: -- Following ZPB_WF_DIMNAME members have an alert
2545: FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_DIMMEMBERS');

Line 2660: from zpb_task_parameters

2656: where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;
2657:
2658: -- bug 3482485
2659: select value into l_authorIDT
2660: from zpb_task_parameters
2661: where task_id = TaskID and name = 'OWNER_ID';
2662:
2663: authorID := to_number(l_authorIDT);
2664:

Line 2673: from ZPB_TASK_PARAMETERS

2669: where INSTANCE_AC_ID = InstanceID;
2670:
2671: select VALUE
2672: into ExcType
2673: from ZPB_TASK_PARAMETERS
2674: where TASK_ID = TaskID and name = 'EXCEPTION_TYPE';
2675:
2676: -- FOR EACH OWNER start a explanation required process
2677: for v_thisowner in c_thisowner loop

Line 2874: from ZPB_TASK_PARAMETERS

2870: where INSTANCE_AC_ID = InstanceID;
2871:
2872: select value
2873: into ApproverTYPE
2874: from ZPB_TASK_PARAMETERS
2875: where TASK_ID = TaskID and name = 'EXPLANATION_APPROVER';
2876:
2877: if ApproverTYPE = 'AUTHOR_OF_EXCEPTION' then
2878: thisApprover := zpb_wf_ntf.ID_to_fnduser(thisApproverID);