eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_WF_EFT_PKG dependencies on WF_ENGINE

Line 105: result := wf_engine.eng_completed||':'||'N';

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;

Line 107: result := wf_engine.eng_completed||':'||'Y';

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,

Line 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);

Line 117: wf_engine.setitemattrtext(itemtype,

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);

Line 123: wf_engine.setitemattrtext(itemtype,

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:

Line 130: wf_engine.setitemattrtext(itemtype,

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:

Line 137: wf_engine.setitemattrtext(itemtype,

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:

Line 145: wf_engine.setitemattrtext(itemtype,

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:

Line 152: wf_engine.setitemattrtext(itemtype,

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:

Line 159: /* wf_engine.setitemattrtext(itemtype,

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: */

Line 286: l_action := wf_engine.GetItemAttrText (

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 (

Line 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:

Line 295: l_total_sup := wf_engine.GetItemAttrNumber (

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:

Line 311: l_tmp := wf_engine.eng_completed||':'||'NOSUP_ACC';

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

Line 313: l_tmp := wf_engine.eng_completed||':'||'NOSUP_RET';

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';

Line 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;

Line 319: l_tmp := wf_engine.eng_completed||':'||'SUP_RET';

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:

Line 328: wf_engine.SetItemAttrNumber (

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);

Line 334: wf_engine.setitemattrtext(itemtype,

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:

Line 341: wf_engine.setitemattrtext(itemtype,

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:

Line 348: wf_engine.setitemattrtext(itemtype,

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:

Line 355: wf_engine.setitemattrtext(itemtype,

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:

Line 362: wf_engine.setitemattrtext(itemtype,

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:

Line 369: wf_engine.setitemattrtext(itemtype,

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:

Line 376: wf_engine.setitemattrtext(itemtype,

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);