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.PQH_FR_WF_NTF dependencies on WF_ENGINE

Line 110: wf_engine.createProcess( ItemType => l_itemtype,

106: hr_utility.set_location(l_proc || ' Params - l_process name '|| l_process_name,15);
107: select PQH_FR_WF_NOTIFICATION_S.NEXTVAL into l_itemkey from dual;
108: hr_utility.set_location(l_proc || ' Params - l_itemkey '|| l_itemkey,35);
109:
110: wf_engine.createProcess( ItemType => l_itemtype,
111: ItemKey => l_ItemKey,
112: process => l_process_name );
113:
114: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

Line 114: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

110: wf_engine.createProcess( ItemType => l_itemtype,
111: ItemKey => l_ItemKey,
112: process => l_process_name );
113:
114: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
115: , itemkey => l_itemkey
116: , aname => 'VALIDATION_ID'
117: , avalue => p_validation_id);
118:

Line 119: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

115: , itemkey => l_itemkey
116: , aname => 'VALIDATION_ID'
117: , avalue => p_validation_id);
118:
119: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
120: , itemkey => l_itemkey
121: , aname => 'PERSON_ID'
122: , avalue => p_person_id);
123:

Line 126: wf_engine.SetItemAttrText( itemtype => l_itemtype

122: , avalue => p_person_id);
123:
124: l_person_name := get_person_name(p_person_id);
125:
126: wf_engine.SetItemAttrText( itemtype => l_itemtype
127: , itemkey => l_itemkey
128: , aname => 'PSV_PERSON_NAME'
129: , avalue => l_person_name);
130:

Line 141: wf_engine.SetItemAttrText( itemtype => l_itemtype

137: hr_utility.set_location(l_proc || 'User /Role Not Entered for PSV',40);
138: RETURN;
139: END IF;
140: hr_utility.set_location(l_proc || 'User /Role '||l_user_role,40);
141: wf_engine.SetItemAttrText( itemtype => l_itemtype
142: , itemkey => l_itemkey
143: , aname => 'PSV_USER_ROLE'
144: , avalue => l_user_role);
145:

Line 146: wf_engine.SetItemAttrText( itemtype => l_itemtype

142: , itemkey => l_itemkey
143: , aname => 'PSV_USER_ROLE'
144: , avalue => l_user_role);
145:
146: wf_engine.SetItemAttrText( itemtype => l_itemtype
147: , itemkey => l_itemkey
148: , aname => 'COMMENTS'
149: , avalue => p_comments);
150:

Line 151: wf_engine.SetItemAttrText( itemtype => l_itemtype

147: , itemkey => l_itemkey
148: , aname => 'COMMENTS'
149: , avalue => p_comments);
150:
151: wf_engine.SetItemAttrText( itemtype => l_itemtype
152: , itemkey => l_itemkey
153: , aname => 'ROUTED_BY_USER'
154: , avalue => fnd_global.user_name);
155:

Line 160: wf_engine.SetItemAttrText( itemtype => l_itemtype

156: /* begin ns - 26-mar-2004: This is no longer needed as the url for embedded region is
157: specified in the the message attribute itself.
158: l_url := 'JSP:/'||'OA_HTML'||'/'||'OA.jsp?akRegionCode=FR_PQH_PSV_VIEW_TOP'||'&'||'akRegionApplicationId=8302'||'&'||'pPersonId='||p_person_id||'&'||'pValidationId='||p_validation_id||'&'||'pNotification=Y';
159:
160: wf_engine.SetItemAttrText( itemtype => l_itemtype
161: , itemkey => l_itemkey
162: , aname => 'PSV_URL'
163: , avalue => l_url);
164:

Line 171: wf_engine.SetItemAttrText( itemtype => l_itemtype

167: -- Setting the parameter name and values only if they are not null
168: -- for performance reasons
169:
170: if ( p_param1_name is not null) then
171: wf_engine.SetItemAttrText( itemtype => l_itemtype
172: , itemkey => l_itemkey
173: , aname => 'PARAMETER1_NAME'
174: , avalue => p_param1_name);
175: end if;

Line 178: wf_engine.SetItemAttrText( itemtype => l_itemtype

174: , avalue => p_param1_name);
175: end if;
176:
177: if ( p_param2_name is not null) then
178: wf_engine.SetItemAttrText( itemtype => l_itemtype
179: , itemkey => l_itemkey
180: , aname => 'PARAMETER2_NAME'
181: , avalue => p_param2_name);
182: end if;

Line 185: wf_engine.SetItemAttrText( itemtype => l_itemtype

181: , avalue => p_param2_name);
182: end if;
183:
184: if ( p_param3_name is not null) then
185: wf_engine.SetItemAttrText( itemtype => l_itemtype
186: , itemkey => l_itemkey
187: , aname => 'PARAMETER3_NAME'
188: , avalue => p_param3_name);
189: end if;

Line 192: wf_engine.SetItemAttrText( itemtype => l_itemtype

188: , avalue => p_param3_name);
189: end if;
190:
191: if ( p_param4_name is not null) then
192: wf_engine.SetItemAttrText( itemtype => l_itemtype
193: , itemkey => l_itemkey
194: , aname => 'PARAMETER4_NAME'
195: , avalue => p_param4_name);
196: end if;

Line 199: wf_engine.SetItemAttrText( itemtype => l_itemtype

195: , avalue => p_param4_name);
196: end if;
197:
198: if ( p_param5_name is not null) then
199: wf_engine.SetItemAttrText( itemtype => l_itemtype
200: , itemkey => l_itemkey
201: , aname => 'PARAMETER5_NAME'
202: , avalue => p_param5_name);
203: end if;

Line 206: wf_engine.SetItemAttrText( itemtype => l_itemtype

202: , avalue => p_param5_name);
203: end if;
204:
205: if ( p_param6_name is not null) then
206: wf_engine.SetItemAttrText( itemtype => l_itemtype
207: , itemkey => l_itemkey
208: , aname => 'PARAMETER6_NAME'
209: , avalue => p_param6_name);
210: end if;

Line 213: wf_engine.SetItemAttrText( itemtype => l_itemtype

209: , avalue => p_param6_name);
210: end if;
211:
212: if ( p_param7_name is not null) then
213: wf_engine.SetItemAttrText( itemtype => l_itemtype
214: , itemkey => l_itemkey
215: , aname => 'PARAMETER7_NAME'
216: , avalue => p_param7_name);
217: end if;

Line 220: wf_engine.SetItemAttrText( itemtype => l_itemtype

216: , avalue => p_param7_name);
217: end if;
218:
219: if ( p_param8_name is not null) then
220: wf_engine.SetItemAttrText( itemtype => l_itemtype
221: , itemkey => l_itemkey
222: , aname => 'PARAMETER8_NAME'
223: , avalue => p_param8_name);
224: end if;

Line 227: wf_engine.SetItemAttrText( itemtype => l_itemtype

223: , avalue => p_param8_name);
224: end if;
225:
226: if ( p_param9_name is not null) then
227: wf_engine.SetItemAttrText( itemtype => l_itemtype
228: , itemkey => l_itemkey
229: , aname => 'PARAMETER9_NAME'
230: , avalue => p_param9_name);
231: end if;

Line 234: wf_engine.SetItemAttrText( itemtype => l_itemtype

230: , avalue => p_param9_name);
231: end if;
232:
233: if ( p_param10_name is not null) then
234: wf_engine.SetItemAttrText( itemtype => l_itemtype
235: , itemkey => l_itemkey
236: , aname => 'PARAMETER10_NAME'
237: , avalue => p_param10_name);
238: end if;

Line 242: wf_engine.SetItemAttrText( itemtype => l_itemtype

238: end if;
239:
240:
241: if ( p_param1_value is not null) then
242: wf_engine.SetItemAttrText( itemtype => l_itemtype
243: , itemkey => l_itemkey
244: , aname => 'PARAMETER1_VALUE'
245: , avalue => p_param1_value);
246:

Line 250: wf_engine.SetItemAttrText( itemtype => l_itemtype

246:
247: end if;
248:
249: if ( p_param2_value is not null) then
250: wf_engine.SetItemAttrText( itemtype => l_itemtype
251: , itemkey => l_itemkey
252: , aname => 'PARAMETER2_VALUE'
253: , avalue => p_param2_value);
254: end if;

Line 257: wf_engine.SetItemAttrText( itemtype => l_itemtype

253: , avalue => p_param2_value);
254: end if;
255:
256: if ( p_param3_value is not null) then
257: wf_engine.SetItemAttrText( itemtype => l_itemtype
258: , itemkey => l_itemkey
259: , aname => 'PARAMETER3_VALUE'
260: , avalue => p_param3_value);
261: end if;

Line 264: wf_engine.SetItemAttrText( itemtype => l_itemtype

260: , avalue => p_param3_value);
261: end if;
262:
263: if ( p_param4_value is not null) then
264: wf_engine.SetItemAttrText( itemtype => l_itemtype
265: , itemkey => l_itemkey
266: , aname => 'PARAMETER4_VALUE'
267: , avalue => p_param4_value);
268: end if;

Line 271: wf_engine.SetItemAttrText( itemtype => l_itemtype

267: , avalue => p_param4_value);
268: end if;
269:
270: if ( p_param5_value is not null) then
271: wf_engine.SetItemAttrText( itemtype => l_itemtype
272: , itemkey => l_itemkey
273: , aname => 'PARAMETER5_VALUE'
274: , avalue => p_param5_value);
275: end if;

Line 278: wf_engine.SetItemAttrText( itemtype => l_itemtype

274: , avalue => p_param5_value);
275: end if;
276:
277: if ( p_param6_value is not null) then
278: wf_engine.SetItemAttrText( itemtype => l_itemtype
279: , itemkey => l_itemkey
280: , aname => 'PARAMETER6_VALUE'
281: , avalue => p_param6_value);
282: end if;

Line 285: wf_engine.SetItemAttrText( itemtype => l_itemtype

281: , avalue => p_param6_value);
282: end if;
283:
284: if ( p_param7_value is not null) then
285: wf_engine.SetItemAttrText( itemtype => l_itemtype
286: , itemkey => l_itemkey
287: , aname => 'PARAMETER7_VALUE'
288: , avalue => p_param7_value);
289: end if;

Line 292: wf_engine.SetItemAttrText( itemtype => l_itemtype

288: , avalue => p_param7_value);
289: end if;
290:
291: if ( p_param8_value is not null) then
292: wf_engine.SetItemAttrText( itemtype => l_itemtype
293: , itemkey => l_itemkey
294: , aname => 'PARAMETER8_VALUE'
295: , avalue => p_param8_value);
296: end if;

Line 299: wf_engine.SetItemAttrText( itemtype => l_itemtype

295: , avalue => p_param8_value);
296: end if;
297:
298: if ( p_param9_value is not null) then
299: wf_engine.SetItemAttrText( itemtype => l_itemtype
300: , itemkey => l_itemkey
301: , aname => 'PARAMETER9_VALUE'
302: , avalue => p_param9_value);
303: end if;

Line 306: wf_engine.SetItemAttrText( itemtype => l_itemtype

302: , avalue => p_param9_value);
303: end if;
304:
305: if ( p_param10_value is not null) then
306: wf_engine.SetItemAttrText( itemtype => l_itemtype
307: , itemkey => l_itemkey
308: , aname => 'PARAMETER10_VALUE'
309: , avalue => p_param10_value);
310: end if;

Line 314: wf_engine.StartProcess ( ItemType => l_itemtype,

310: end if;
311:
312: hr_utility.set_location(l_proc || ' Start Process',15);
313:
314: wf_engine.StartProcess ( ItemType => l_itemtype,
315: ItemKey => l_ItemKey );
316: hr_utility.set_location(l_proc || ' Exiting ',100);
317: End psv_ntf_api;
318:

Line 336: l_validation_id := wf_engine.GetItemAttrText(

332: ORDER BY creation_date DESC;
333: l_event_code pqh_fr_validation_events.event_code%TYPE;
334: l_validation_id Number;
335: BEGIN
336: l_validation_id := wf_engine.GetItemAttrText(
337: itemtype => itemtype,
338: itemkey => ItemKey,
339: aname => 'VALIDATION_ID');
340: