101:
102: OPEN get_user_name_csr;
103: FETCH get_user_name_csr INTO l_emp_login;
104: if get_user_name_csr%NOTFOUND then
105: result := wf_engine.eng_completed||':'||'N';
106: else
107: result := wf_engine.eng_completed||':'||'Y';
108: end if;
109: close get_user_name_csr;
103: FETCH get_user_name_csr INTO l_emp_login;
104: if get_user_name_csr%NOTFOUND then
105: result := wf_engine.eng_completed||':'||'N';
106: else
107: result := wf_engine.eng_completed||':'||'Y';
108: end if;
109: close get_user_name_csr;
110:
111: wf_engine.setitemattrtext(itemtype,
107: result := wf_engine.eng_completed||':'||'Y';
108: end if;
109: close get_user_name_csr;
110:
111: wf_engine.setitemattrtext(itemtype,
112: itemkey,
113: 'EMP_NAME',
114: L_emp_name);
115: --dbms_output.put_line('Emp Name ' || l_emp_name);
113: 'EMP_NAME',
114: L_emp_name);
115: --dbms_output.put_line('Emp Name ' || l_emp_name);
116:
117: wf_engine.setitemattrtext(itemtype,
118: itemkey,
119: 'EMP_NO',
120: L_emp_num);
121: --dbms_output.put_line('Emp No ' || l_emp_num);
119: 'EMP_NO',
120: L_emp_num);
121: --dbms_output.put_line('Emp No ' || l_emp_num);
122:
123: wf_engine.setitemattrtext(itemtype,
124: itemkey,
125: 'SUP_NAME',
126: L_sup_name);
127:
126: L_sup_name);
127:
128: --dbms_output.put_line('Sup Name ' || l_sup_name);
129:
130: wf_engine.setitemattrtext(itemtype,
131: itemkey,
132: 'EMP_LOGIN',
133: l_emp_login);
134:
133: l_emp_login);
134:
135: --dbms_output.put_line('Emp Login ' || l_emp_login);
136:
137: wf_engine.setitemattrtext(itemtype,
138: itemkey,
139: 'ORG_NAME',
140: L_orig_login);
141:
141:
142: --dbms_output.put_line('Orig Login ' || l_orig_login);
143:
144:
145: wf_engine.setitemattrtext(itemtype,
146: itemkey,
147: 'BEGIN_DT',
148: L_bgn_perd);
149:
148: L_bgn_perd);
149:
150: --dbms_output.put_line('Begin Dt ' || to_char(l_bgn_perd));
151:
152: wf_engine.setitemattrtext(itemtype,
153: itemkey,
154: 'END_DT',
155: L_end_perd);
156:
155: L_end_perd);
156:
157: --dbms_output.put_line('End Dt ' || to_char(l_end_perd));
158:
159: /* wf_engine.setitemattrtext(itemtype,
160: itemkey,
161: 'RESULT',
162: l_result);
163: */
282: LOOP
283: FETCH get_supervisor_csr INTO L_sup_name, l_supervisor_id;
284: EXIT WHEN get_supervisor_csr%NOTFOUND;
285:
286: l_action := wf_engine.GetItemAttrText (
287: itemtype,
288: itemkey,
289: aname => 'RESULT');
290: l_no_sup := wf_engine.GetItemAttrNumber (
286: l_action := wf_engine.GetItemAttrText (
287: itemtype,
288: itemkey,
289: aname => 'RESULT');
290: l_no_sup := wf_engine.GetItemAttrNumber (
291: itemtype,
292: itemkey,
293: aname => 'L_COUNTER');
294:
291: itemtype,
292: itemkey,
293: aname => 'L_COUNTER');
294:
295: l_total_sup := wf_engine.GetItemAttrNumber (
296: itemtype,
297: itemkey,
298: aname => 'NO_SUP');
299:
307: OPEN get_supervisor_login_csr;
308: FETCH get_supervisor_login_csr INTO l_supervisor_login;
309: if get_supervisor_login_csr%NOTFOUND then
310: if l_action = 'Accepted' then
311: l_tmp := wf_engine.eng_completed||':'||'NOSUP_ACC';
312: else
313: l_tmp := wf_engine.eng_completed||':'||'NOSUP_RET';
314: end if;
315: else
309: if get_supervisor_login_csr%NOTFOUND then
310: if l_action = 'Accepted' then
311: l_tmp := wf_engine.eng_completed||':'||'NOSUP_ACC';
312: else
313: l_tmp := wf_engine.eng_completed||':'||'NOSUP_RET';
314: end if;
315: else
316: if l_action = 'Accepted' then
317: l_tmp := wf_engine.eng_completed||':'||'SUP_ACC';
313: l_tmp := wf_engine.eng_completed||':'||'NOSUP_RET';
314: end if;
315: else
316: if l_action = 'Accepted' then
317: l_tmp := wf_engine.eng_completed||':'||'SUP_ACC';
318: else
319: l_tmp := wf_engine.eng_completed||':'||'SUP_RET';
320: end if;
321: end if;
315: else
316: if l_action = 'Accepted' then
317: l_tmp := wf_engine.eng_completed||':'||'SUP_ACC';
318: else
319: l_tmp := wf_engine.eng_completed||':'||'SUP_RET';
320: end if;
321: end if;
322: close get_supervisor_login_csr;
323:
324: --dbms_output.put_line('Result ' || l_tmp);
325: result := l_tmp;
326:
327:
328: wf_engine.SetItemAttrNumber (
329: itemtype,
330: itemkey,
331: 'L_COUNTER',
332: l_no_sup);
330: itemkey,
331: 'L_COUNTER',
332: l_no_sup);
333:
334: wf_engine.setitemattrtext(itemtype,
335: itemkey,
336: 'EMP_NAME',
337: L_emp_name);
338:
337: L_emp_name);
338:
339: --dbms_output.put_line('Emp Name ' || l_emp_name);
340:
341: wf_engine.setitemattrtext(itemtype,
342: itemkey,
343: 'EMP_NO',
344: L_emp_num);
345:
344: L_emp_num);
345:
346: --dbms_output.put_line('Emp Num ' || l_emp_num);
347:
348: wf_engine.setitemattrtext(itemtype,
349: itemkey,
350: 'SUP_NAME',
351: L_sup_name);
352:
351: L_sup_name);
352:
353: --dbms_output.put_line('Sup Name ' || l_sup_name);
354:
355: wf_engine.setitemattrtext(itemtype,
356: itemkey,
357: 'EMP_LOGIN',
358: l_emp_login);
359:
358: l_emp_login);
359:
360: --dbms_output.put_line('Emp Login ' || l_emp_login);
361:
362: wf_engine.setitemattrtext(itemtype,
363: itemkey,
364: 'BEGIN_DT',
365: L_bgn_perd);
366:
365: L_bgn_perd);
366:
367: --dbms_output.put_line('Begin Period ' || to_date(l_bgn_perd));
368:
369: wf_engine.setitemattrtext(itemtype,
370: itemkey,
371: 'END_DT',
372: L_end_perd);
373:
372: L_end_perd);
373:
374: --dbms_output.put_line('End Period ' || to_date(l_end_perd));
375:
376: wf_engine.setitemattrtext(itemtype,
377: itemkey,
378: 'SUP_LOGIN',
379: l_supervisor_login);
380: --dbms_output.put_line('Supervisor Login ' || l_supervisor_login);