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_ADJ_PKG dependencies on WF_ENGINE

Line 140: wf_engine.CreateProcess( itemtype => ItemType,

136: -- dbms_output.put_line('batch Name '||p_batch_name);
137:
138: l_creator_username := FND_GLOBAL.user_name;
139:
140: wf_engine.CreateProcess( itemtype => ItemType,
141: itemkey => ItemKey,
142: process => 'PSP_DISTRIBUTION_ADJUSTMENT');
143:
144: /*Added for bug 7004679 */

Line 145: wf_engine.setitemowner(itemtype => ItemType,

141: itemkey => ItemKey,
142: process => 'PSP_DISTRIBUTION_ADJUSTMENT');
143:
144: /*Added for bug 7004679 */
145: wf_engine.setitemowner(itemtype => ItemType,
146: itemkey => ItemKey,
147: owner => l_creator_username);
148:
149:

Line 164: wf_engine.SetItemAttrText(itemtype => ItemType,

160: /* (9) CREATOR_DISPLAY_NAME */
161: /* (10) Comments */
162: /* (11) Time Out */
163: /*---------------------------------------------------------------*/
164: wf_engine.SetItemAttrText(itemtype => ItemType,
165: itemkey => ItemKey,
166: aname => 'BATCH',
167: avalue => p_batch_name);
168:

Line 169: wf_engine.SetItemAttrNUMBER(itemtype => ItemType,

165: itemkey => ItemKey,
166: aname => 'BATCH',
167: avalue => p_batch_name);
168:
169: wf_engine.SetItemAttrNUMBER(itemtype => ItemType,
170: itemkey => ItemKey,
171: aname => 'EMPLOYEE_PERSON_ID',
172: avalue => p_person_id);
173:

Line 174: wf_engine.SetItemAttrText(itemtype => ItemType,

170: itemkey => ItemKey,
171: aname => 'EMPLOYEE_PERSON_ID',
172: avalue => p_person_id);
173:
174: wf_engine.SetItemAttrText(itemtype => ItemType,
175: itemkey => ItemKey,
176: aname => 'EMPLOYEE_DISPLAY_NAME',
177: avalue => p_display_name);
178:

Line 179: wf_engine.SetItemAttrText(itemtype => ItemType,

175: itemkey => ItemKey,
176: aname => 'EMPLOYEE_DISPLAY_NAME',
177: avalue => p_display_name);
178:
179: wf_engine.SetItemAttrText(itemtype => ItemType,
180: itemkey => ItemKey,
181: aname => 'ASSIGNMENT',
182: avalue => p_assignment);
183: /*

Line 184: wf_engine.SetItemAttrText(itemtype => ItemType,

180: itemkey => ItemKey,
181: aname => 'ASSIGNMENT',
182: avalue => p_assignment);
183: /*
184: wf_engine.SetItemAttrText(itemtype => ItemType,
185: itemkey => ItemKey,
186: aname => 'EARNINGS_ELEMENT',
187: avalue => p_earnings_element); */
188:

Line 189: wf_engine.SetItemAttrDATE(itemtype => ItemType,

185: itemkey => ItemKey,
186: aname => 'EARNINGS_ELEMENT',
187: avalue => p_earnings_element); */
188:
189: wf_engine.SetItemAttrDATE(itemtype => ItemType,
190: itemkey => ItemKey,
191: aname => 'BEGIN_DATE',
192: avalue => p_begin_date);
193:

Line 194: wf_engine.SetItemAttrDATE(itemtype => ItemType,

190: itemkey => ItemKey,
191: aname => 'BEGIN_DATE',
192: avalue => p_begin_date);
193:
194: wf_engine.SetItemAttrDATE(itemtype => ItemType,
195: itemkey => ItemKey,
196: aname => 'END_DATE',
197: avalue => p_end_date);
198:

Line 200: wf_engine.SetItemAttrText(itemtype => ItemType,

196: aname => 'END_DATE',
197: avalue => p_end_date);
198:
199: -- Introduced the following for bug fix 2916848
200: wf_engine.SetItemAttrText(itemtype => ItemType,
201: itemkey => ItemKey,
202: aname => 'CURRENCY_CODE',
203: avalue => p_currency_code);
204: -- End of bug fix 2916848

Line 207: wf_engine.SetItemAttrText(itemtype => ItemType,

203: avalue => p_currency_code);
204: -- End of bug fix 2916848
205:
206:
207: wf_engine.SetItemAttrText(itemtype => ItemType,
208: itemkey => ItemKey,
209: aname => 'CREATOR_USERNAME',
210: avalue => l_creator_username);
211:

Line 212: wf_engine.SetItemAttrText(itemtype => ItemType,

208: itemkey => ItemKey,
209: aname => 'CREATOR_USERNAME',
210: avalue => l_creator_username);
211:
212: wf_engine.SetItemAttrText(itemtype => ItemType,
213: itemkey => ItemKey,
214: aname => 'CREATOR_DISPLAY_NAME',
215: avalue => wf_directory.GetRoleDisplayName(l_creator_username));
216:

Line 217: wf_engine.SetItemAttrText(itemtype => ItemType,

213: itemkey => ItemKey,
214: aname => 'CREATOR_DISPLAY_NAME',
215: avalue => wf_directory.GetRoleDisplayName(l_creator_username));
216:
217: wf_engine.SetItemAttrText(itemtype => ItemType,
218: itemkey => ItemKey,
219: aname => 'NOTE',
220: avalue => p_comments);
221:

Line 223: wf_engine.SetItemAttrNUMBER(itemtype => ItemType,

219: aname => 'NOTE',
220: avalue => p_comments);
221:
222:
223: wf_engine.SetItemAttrNUMBER(itemtype => ItemType,
224: itemkey => ItemKey,
225: aname => 'TIME_OUT',
226: avalue => p_time_out);
227:

Line 232: wf_engine.StartProcess(itemtype => ItemType,

228: -- dbms_output.put_line('After setting the attribute');
229: /*---------------------------------------------------------------*/
230: /*3. Start the workflow process "psp_distribution_adjustment" */
231: /*---------------------------------------------------------------*/
232: wf_engine.StartProcess(itemtype => ItemType,
233: itemkey => ItemKey);
234: -- dbms_output.put_line('After starting process');
235:
236: return_code := 0;

Line 264: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

260: l_approver_display_name VARCHAR2(240);
261: BEGIN
262:
263: IF (funcmode = 'RUN') THEN
264: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'EMPLOYEE_PERSON_ID');
267: l_assignment_number := wf_engine.GetItemAttrText(itemtype => itemtype,
268: itemkey => itemkey,

Line 267: l_assignment_number := wf_engine.GetItemAttrText(itemtype => itemtype,

263: IF (funcmode = 'RUN') THEN
264: l_person_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'EMPLOYEE_PERSON_ID');
267: l_assignment_number := wf_engine.GetItemAttrText(itemtype => itemtype,
268: itemkey => itemkey,
269: aname => 'ASSIGNMENT');
270:
271: /*------------------------------------------------------------------

Line 309: wf_engine.setitemowner(itemtype => ItemType,

305:
306: wf_directory.GetUserName('PER', l_supervisor_id, l_approver_username, l_approver_display_name);
307:
308: /*Added for bug 7004679 */
309: wf_engine.setitemowner(itemtype => ItemType,
310: itemkey => ItemKey,
311: owner => l_approver_username);
312:
313: -- Bug : 1994421

Line 320: wf_engine.SetItemAttrText(itemtype => itemtype,

316: IF l_approver_status=-1 or l_supervisor_id=-1 THEN
317: result := 'COMPLETE:NOT_FOUND';
318: ELSE
319: IF (wf_directory.UserActive(l_approver_username)) THEN
320: wf_engine.SetItemAttrText(itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'APPROVER_USERNAME',
323: avalue => l_approver_username);
324: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 324: wf_engine.SetItemAttrText(itemtype => itemtype,

320: wf_engine.SetItemAttrText(itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'APPROVER_USERNAME',
323: avalue => l_approver_username);
324: wf_engine.SetItemAttrText(itemtype => itemtype,
325: itemkey => itemkey,
326: aname => 'APPROVER_DISPLAY_NAME',
327: avalue => l_approver_display_name);
328: result := 'COMPLETE:FOUND';

Line 363: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,

359: l_set_of_books_id NUMBER;
360: BEGIN
361:
362: IF (funcmode = 'RUN') THEN
363: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'BATCH');
366:
367: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 367: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,

363: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'BATCH');
366:
367: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,
368: itemkey => itemkey,
369: aname => 'NOTE');
370:
371: l_business_group_id := to_number(psp_general.get_specific_profile('PER_BUSINESS_GROUP_ID'));

Line 451: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);

447: CLOSE get_approval_responder_csr;
448:
449: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
450:
451: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);
452: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);
453:
454: result := 'COMPLETE';
455: END IF;

Line 452: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);

448:
449: l_responder_display_name := wf_directory.GetRoleDisplayName(l_responder_username);
450:
451: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_USERNAME', l_responder_username);
452: wf_engine.SetItemAttrText(itemtype, itemkey, 'APPROVER_DISPLAY_NAME', l_responder_display_name);
453:
454: result := 'COMPLETE';
455: END IF;
456:

Line 488: l_approver_username := wf_engine.GetItemAttrText(itemtype => itemtype,

484: WHERE user_name = l_approver_username;
485: BEGIN
486:
487: IF (funcmode = 'RUN') THEN
488: l_approver_username := wf_engine.GetItemAttrText(itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'APPROVER_USERNAME');
491:
492: OPEN get_user_id_csr;

Line 499: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,

495:
496: IF l_approver_userID IS NULL THEN
497: result := 'ERROR';
498: ELSE
499: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'BATCH');
502: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,
503: itemkey => itemkey,

Line 502: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,

498: ELSE
499: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'BATCH');
502: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,
503: itemkey => itemkey,
504: aname => 'NOTE');
505: update_adj_ctrl_table(l_batch_name, l_approver_userID,l_comments, l_return_code);
506: IF l_return_code = -1 THEN

Line 572: l_creator_username := wf_engine.GetItemAttrText(itemtype => itemtype,

568: l_comments VARCHAR2(2000);
569: l_return_code NUMBER;
570: BEGIN
571: IF (funcmode = 'RUN') THEN
572: l_creator_username := wf_engine.GetItemAttrText(itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'CREATOR_USERNAME');
575: BEGIN
576: SELECT user_id

Line 588: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,

584:
585: IF l_creator_user_id IS NULL THEN
586: result := 'ERROR';
587: ELSE
588: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,
589: itemkey => itemkey,
590: aname => 'BATCH');
591: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,
592: itemkey => itemkey,

Line 591: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,

587: ELSE
588: l_batch_name := wf_engine.GetItemAttrText(itemtype => itemtype,
589: itemkey => itemkey,
590: aname => 'BATCH');
591: l_comments := wf_engine.GetItemAttrText(itemtype => itemtype,
592: itemkey => itemkey,
593: aname => 'NOTE');
594:
595: psp_wf_adj_custom.record_creator_custom(