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

Line 86: l_save_thresh := wf_engine.threshold ;

82:
83: END IF;
84:
85: -- Setting thresold value to run the process in background
86: l_save_thresh := wf_engine.threshold ;
87:
88: IF wf_engine.threshold < 0 THEN
89: wf_engine.threshold := l_save_thresh ;
90: END IF;

Line 88: IF wf_engine.threshold < 0 THEN

84:
85: -- Setting thresold value to run the process in background
86: l_save_thresh := wf_engine.threshold ;
87:
88: IF wf_engine.threshold < 0 THEN
89: wf_engine.threshold := l_save_thresh ;
90: END IF;
91: wf_engine.threshold := -1 ;
92: IF p_assignment_id IS NOT NULL AND p_resource_id IS NULL THEN

Line 89: wf_engine.threshold := l_save_thresh ;

85: -- Setting thresold value to run the process in background
86: l_save_thresh := wf_engine.threshold ;
87:
88: IF wf_engine.threshold < 0 THEN
89: wf_engine.threshold := l_save_thresh ;
90: END IF;
91: wf_engine.threshold := -1 ;
92: IF p_assignment_id IS NOT NULL AND p_resource_id IS NULL THEN
93: -- Selecting orgnization name to initialize the work flow attribute

Line 91: wf_engine.threshold := -1 ;

87:
88: IF wf_engine.threshold < 0 THEN
89: wf_engine.threshold := l_save_thresh ;
90: END IF;
91: wf_engine.threshold := -1 ;
92: IF p_assignment_id IS NOT NULL AND p_resource_id IS NULL THEN
93: -- Selecting orgnization name to initialize the work flow attribute
94:
95: BEGIN

Line 178: WF_ENGINE.CreateProcess( itemtype => l_item_type,

174:
175: -- dbms_output.put_line('Create the process ');
176:
177: -- Creating the work flow process
178: WF_ENGINE.CreateProcess( itemtype => l_item_type,
179: itemkey => l_item_key,
180: process => 'PA_FORECAST_ITEM_GEN') ;
181:
182: -- dbms_output.put_line('Set the attribute 1');

Line 185: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,

181:
182: -- dbms_output.put_line('Set the attribute 1');
183:
184: -- Setting the attribute value for assignment id
185: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,
186: itemkey => l_item_key,
187: aname => 'ASSIGNMENT_ID',
188: avalue => p_assignment_id);
189:

Line 192: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,

188: avalue => p_assignment_id);
189:
190: -- Setting the attribute value for resource id
191: -- dbms_output.put_line('Set the attribute 2');
192: WF_ENGINE.SetItemAttrNumber( itemtype => l_item_type,
193: itemkey => l_item_key,
194: aname => 'RESOURCE_ID',
195: avalue => p_resource_id);
196:

Line 199: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,

195: avalue => p_resource_id);
196:
197: -- Setting the attribute value for asignment start date
198: -- dbms_output.put_line('Set the attribute 3');
199: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,
200: itemkey => l_item_key,
201: aname => 'ASGMT_START_DATE',
202: avalue => p_start_date);
203:

Line 206: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,

202: avalue => p_start_date);
203:
204: -- Setting the attribute value for assignment end date
205: -- dbms_output.put_line('Set the attribute 4');
206: WF_ENGINE.SetItemAttrDate( itemtype => l_item_type,
207: itemkey => l_item_key,
208: aname => 'ASGMT_END_DATE',
209: avalue => p_end_date);
210:

Line 213: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

209: avalue => p_end_date);
210:
211: -- Setting the attribute value for process mode
212: -- dbms_output.put_line('Set the attribute 5');
213: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
214: itemkey => l_item_key,
215: aname => 'PROCESS_MODE',
216: avalue => p_process_mode);
217:

Line 220: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,

216: avalue => p_process_mode);
217:
218: -- Setting the attribute value for orgnization name
219: -- dbms_output.put_line('Set the attribute 6');
220: WF_ENGINE.SetItemAttrText( itemtype => l_item_type,
221: itemkey => l_item_key,
222: aname => 'ORGANIZATION_NAME',
223: avalue => l_name );
224:

Line 227: WF_ENGINE.SetItemAttrText ( itemtype => l_item_type,

223: avalue => l_name );
224:
225: -- Setting the attribute value for Project Resource Administrator
226: -- dbms_output.put_line('Set the attribute 7');
227: WF_ENGINE.SetItemAttrText ( itemtype => l_item_type,
228: itemkey => l_item_key,
229: aname => 'PROJECT_RESOURCE_ADMINISTRATOR',
230: avalue => 'PASYSADMIN');
231:

Line 236: WF_ENGINE.StartProcess( itemtype => l_item_type,

232: -- dbms_output.put_line('Start the process ');
233:
234: -- Starting the work flow process and calling work flow api internaly
235: -- dbms_output.put_line('Set the attribute 8');
236: WF_ENGINE.StartProcess( itemtype => l_item_type,
237: itemkey => l_item_key);
238:
239:
240: IF p_assignment_id IS NOT NULL THEN

Line 269: wf_engine.threshold := l_save_thresh;

265: );
266:
267: END IF;
268: --Setting the original value
269: wf_engine.threshold := l_save_thresh;
270: EXCEPTION
271: WHEN l_cannot_acquire_lock THEN
272: PA_FORECAST_ITEMS_UTILS.log_message('Unable to set lock for ' || to_char(p_assignment_id));
273: x_return_status := FND_API.G_RET_STS_ERROR;

Line 318: l_assignment_id := WF_ENGINE.GetItemAttrNumber( p_item_type,

314:
315: IF ( p_funcmode = 'RUN' ) THEN
316:
317: BEGIN
318: l_assignment_id := WF_ENGINE.GetItemAttrNumber( p_item_type,
319: p_item_key,
320: 'ASSIGNMENT_ID');
321:
322: l_resource_id := WF_ENGINE.GetItemAttrNumber( p_item_type,

Line 322: l_resource_id := WF_ENGINE.GetItemAttrNumber( p_item_type,

318: l_assignment_id := WF_ENGINE.GetItemAttrNumber( p_item_type,
319: p_item_key,
320: 'ASSIGNMENT_ID');
321:
322: l_resource_id := WF_ENGINE.GetItemAttrNumber( p_item_type,
323: p_item_key,
324: 'RESOURCE_ID');
325:
326: l_asgmt_start_date := WF_ENGINE.GetItemAttrDate ( p_item_type,

Line 326: l_asgmt_start_date := WF_ENGINE.GetItemAttrDate ( p_item_type,

322: l_resource_id := WF_ENGINE.GetItemAttrNumber( p_item_type,
323: p_item_key,
324: 'RESOURCE_ID');
325:
326: l_asgmt_start_date := WF_ENGINE.GetItemAttrDate ( p_item_type,
327: p_item_key,
328: 'ASGMT_START_DATE');
329:
330: l_asgmt_end_date := WF_ENGINE.GetItemAttrDate ( p_item_type,

Line 330: l_asgmt_end_date := WF_ENGINE.GetItemAttrDate ( p_item_type,

326: l_asgmt_start_date := WF_ENGINE.GetItemAttrDate ( p_item_type,
327: p_item_key,
328: 'ASGMT_START_DATE');
329:
330: l_asgmt_end_date := WF_ENGINE.GetItemAttrDate ( p_item_type,
331: p_item_key,
332: 'ASGMT_END_DATE');
333:
334: l_process_mode := WF_ENGINE.GetItemAttrText ( p_item_type,

Line 334: l_process_mode := WF_ENGINE.GetItemAttrText ( p_item_type,

330: l_asgmt_end_date := WF_ENGINE.GetItemAttrDate ( p_item_type,
331: p_item_key,
332: 'ASGMT_END_DATE');
333:
334: l_process_mode := WF_ENGINE.GetItemAttrText ( p_item_type,
335: p_item_key,
336: 'PROCESS_MODE');
337:
338: l_orgz_name := WF_ENGINE.GetItemAttrText ( p_item_type,

Line 338: l_orgz_name := WF_ENGINE.GetItemAttrText ( p_item_type,

334: l_process_mode := WF_ENGINE.GetItemAttrText ( p_item_type,
335: p_item_key,
336: 'PROCESS_MODE');
337:
338: l_orgz_name := WF_ENGINE.GetItemAttrText ( p_item_type,
339: p_item_key,
340: 'ORGANIZATION_NAME');
341:
342: -- User lock for the given assignment id

Line 387: WF_ENGINE.SetItemAttrText

383: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
384: p_result := 'COMPLETE:S';
385: ELSIF (l_x_return_status = FND_API.G_RET_STS_ERROR ) THEN
386: ROLLBACK to l_forecast_item_gen ;
387: WF_ENGINE.SetItemAttrText
388: ( itemtype => p_item_type
389: , itemkey => p_item_key
390: , aname => 'ERROR_MSG'
391: , avalue => l_x_msg_data

Line 397: WF_ENGINE.SetItemAttrText

393:
394: p_result := 'COMPLETE:F';
395: ELSIF (l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
396: ROLLBACK to l_forecast_item_gen ;
397: WF_ENGINE.SetItemAttrText
398: ( itemtype => p_item_type
399: , itemkey => p_item_key
400: , aname => 'ERROR_MSG'
401: , avalue => l_x_msg_data

Line 425: WF_ENGINE.SetItemAttrText

421:
422: EXCEPTION
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: -- Setting the attribute value for Error
425: WF_ENGINE.SetItemAttrText
426: ( itemtype => p_item_type
427: , itemkey => p_item_key
428: , aname => 'ERROR_MSG'
429: , avalue => SQLCODE||SQLERRM

Line 435: WF_ENGINE.SetItemAttrText

431: p_result := 'COMPLETE:F';
432: -- RAISE;
433: WHEN OTHERS THEN
434: -- Setting the attribute value for Error
435: WF_ENGINE.SetItemAttrText
436: ( itemtype => p_item_type
437: , itemkey => p_item_key
438: , aname => 'ERROR_MSG'
439: , avalue => SQLCODE||SQLERRM