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

Line 51: hr_utility.set_location('calling wf_engine.additemattr for aname:'||aname,2);

47: if csr_wiav%notfound then
48: --
49: -- item attribute does not exist so create it
50: if g_debug then
51: hr_utility.set_location('calling wf_engine.additemattr for aname:'||aname,2);
52: end if;
53: wf_engine.additemattr
54: (itemtype => itemtype
55: ,itemkey => itemkey

Line 53: wf_engine.additemattr

49: -- item attribute does not exist so create it
50: if g_debug then
51: hr_utility.set_location('calling wf_engine.additemattr for aname:'||aname,2);
52: end if;
53: wf_engine.additemattr
54: (itemtype => itemtype
55: ,itemkey => itemkey
56: ,aname => aname
57: ,text_value=>text_value

Line 67: hr_utility.set_location('calling wf_engine.setitemattrtext for text_value:'|| text_value,3);

63: if csr_wiav%found then
64: -- set the values as per the type
65: if(text_value is not null) then
66: if g_debug then
67: hr_utility.set_location('calling wf_engine.setitemattrtext for text_value:'|| text_value,3);
68: end if;
69: wf_engine.setitemattrtext(itemtype,itemkey,aname,text_value);
70: end if;
71:

Line 69: wf_engine.setitemattrtext(itemtype,itemkey,aname,text_value);

65: if(text_value is not null) then
66: if g_debug then
67: hr_utility.set_location('calling wf_engine.setitemattrtext for text_value:'|| text_value,3);
68: end if;
69: wf_engine.setitemattrtext(itemtype,itemkey,aname,text_value);
70: end if;
71:
72: if(number_value is not null) then
73: if g_debug then

Line 74: hr_utility.set_location('calling wf_engine.setitemattrnumber for text_value:'|| number_value,4);

70: end if;
71:
72: if(number_value is not null) then
73: if g_debug then
74: hr_utility.set_location('calling wf_engine.setitemattrnumber for text_value:'|| number_value,4);
75: end if;
76: wf_engine.setitemattrnumber(itemtype,itemkey,aname,number_value);
77: end if;
78:

Line 76: wf_engine.setitemattrnumber(itemtype,itemkey,aname,number_value);

72: if(number_value is not null) then
73: if g_debug then
74: hr_utility.set_location('calling wf_engine.setitemattrnumber for text_value:'|| number_value,4);
75: end if;
76: wf_engine.setitemattrnumber(itemtype,itemkey,aname,number_value);
77: end if;
78:
79: if(date_value is not null) then
80: if g_debug then

Line 81: hr_utility.set_location('calling wf_engine.setitemattrDate for text_value:'|| date_value,5);

77: end if;
78:
79: if(date_value is not null) then
80: if g_debug then
81: hr_utility.set_location('calling wf_engine.setitemattrDate for text_value:'|| date_value,5);
82: end if;
83: wf_engine.setitemattrDate(itemtype,itemkey,aname,date_value);
84: end if;
85:

Line 83: wf_engine.setitemattrDate(itemtype,itemkey,aname,date_value);

79: if(date_value is not null) then
80: if g_debug then
81: hr_utility.set_location('calling wf_engine.setitemattrDate for text_value:'|| date_value,5);
82: end if;
83: wf_engine.setitemattrDate(itemtype,itemkey,aname,date_value);
84: end if;
85:
86: end if;
87:

Line 117: l_transaction_id := wf_engine.GetItemAttrNumber(

113: l_performer_id number(10);
114: l_proc varchar2(100) := g_package||'GET_TRANSACTION_ID';
115: BEGIN
116: hr_utility.set_location('Entering ... '||l_proc,10);
117: l_transaction_id := wf_engine.GetItemAttrNumber(
118: itemtype => itemtype
119: ,itemkey => itemkey
120: ,aname => 'TRANSACTION_ID'
121: ,ignore_notfound => false

Line 126: l_performer_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'PERFORMER_PERSON_ID');

122: );
123: /*If no transaction exists, start a transaction.*/
124: IF L_TRANSACTION_ID IS NULL THEN
125: hr_utility.set_location(l_proc || '....Step1',20);
126: l_performer_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'PERFORMER_PERSON_ID');
127:
128: hr_utility.set_location(l_proc , 30);
129:
130: hr_transaction_ss.start_transaction

Line 143: wf_engine.SetItemAttrNumber(itemtype,itemkey,'TRANSACTION_ID',l_transaction_id);

139: /*Gett the newly created transaction and set as workflow attribute*/
140: l_transaction_id:= hr_transaction_ss.get_transaction_id
141: (p_item_type => itemtype
142: ,p_item_key => itemkey);
143: wf_engine.SetItemAttrNumber(itemtype,itemkey,'TRANSACTION_ID',l_transaction_id);
144: hr_utility.set_location(l_proc ,50);
145:
146: END IF;
147: hr_utility.set_location('Leaving....'||l_proc ,60);

Line 208: wf_engine.setItemAttrText(itemtype, itemkey,'AME_EXCEPTION',SQLERRM(SQLCODE));

204: /*This is to catch the exception when there is no approver etc.
205: Once the exception raises, then the AME/workflow admin will get
206: the notification with the exception message raised.*/
207: when OTHERS then
208: wf_engine.setItemAttrText(itemtype, itemkey,'AME_EXCEPTION',SQLERRM(SQLCODE));
209: resultout:='F';
210: end;
211: if resultout <> 'F' and l_apprvl_process_complete <> ame_util.booleanTrue then
212: /*First clear all approvers, then get the approver again. This is to by-pass

Line 227: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);

223: transactionIdIn => l_transaction_id,
224: approvalProcessCompleteYNOut => l_apprvl_process_complete,
225: nextApproversOut => g_approver);
226: if (l_apprvl_process_complete <> ame_util.booleanTrue) then
227: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
228: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
229: ,p_orig_system_id => g_approver(1).orig_system_id
230: ,p_name => l_role_name
231: ,p_display_name => l_role_display_name);

Line 232: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_NAME',l_role_display_name);

228: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
229: ,p_orig_system_id => g_approver(1).orig_system_id
230: ,p_name => l_role_name
231: ,p_display_name => l_role_display_name);
232: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_NAME',l_role_display_name);
233: resultout:='T';
234: end if;
235: end if;
236: EXCEPTION

Line 281: approverNameIn => wf_engine.getItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME'),

277: applicationIdIn =>801,
278: transactionTypeIn =>'PAY_ASSIGNMENT_COSTING',
279: transactionIdIn =>l_transaction_id,
280: approvalStatusIn => ame_util.approvedStatus,
281: approverNameIn => wf_engine.getItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME'),
282: updateItemIn => true);
283:
284: /*Now get the next approver.*/
285: hr_utility.set_location(l_proc,30);

Line 301: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',

297: APIs*/
298: hr_utility.set_location(l_proc, 40);
299: if l_apprvl_process_complete = ame_util.booleanFalse then
300: /*Set the previous approver attributes.*/
301: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
302: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
304: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
305:

Line 302: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));

298: hr_utility.set_location(l_proc, 40);
299: if l_apprvl_process_complete = ame_util.booleanFalse then
300: /*Set the previous approver attributes.*/
301: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
302: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
304: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
305:
306: /*Set the current approver attributes.*/

Line 303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',

299: if l_apprvl_process_complete = ame_util.booleanFalse then
300: /*Set the previous approver attributes.*/
301: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
302: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
304: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
305:
306: /*Set the current approver attributes.*/
307: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);

Line 304: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));

300: /*Set the previous approver attributes.*/
301: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
302: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
304: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
305:
306: /*Set the current approver attributes.*/
307: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
308: /*Get the approver name from wf_roles.*/

Line 307: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);

303: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
304: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
305:
306: /*Set the current approver attributes.*/
307: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
308: /*Get the approver name from wf_roles.*/
309: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
310: ,p_orig_system_id => g_approver(1).orig_system_id
311: ,p_name => l_role_name

Line 313: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_NAME',l_role_display_name);

309: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
310: ,p_orig_system_id => g_approver(1).orig_system_id
311: ,p_name => l_role_name
312: ,p_display_name => l_role_display_name);
313: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_NAME',l_role_display_name);
314:
315: resultout := 'T';
316: else
317: resultout := 'F';

Line 361: wf_engine.CreateProcess (ItemType => l_Item_Type

357: BEGIN
358: hr_utility.set_location('Entering....'||l_proc,10);
359:
360: /*Create the workflow process.*/
361: wf_engine.CreateProcess (ItemType => l_Item_Type
362: ,ItemKey => p_Item_Key
363: ,process => l_process
364: ,User_Key => l_user_key
365: ,Owner_Role => 'COREPAY'

Line 380: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);

376: ,p_display_name => l_requestor_name);
377:
378: --
379: /*Set Workflow attributes.*/
380: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);

Line 381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);

377:
378: --
379: /*Set Workflow attributes.*/
380: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);

Line 382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');

378: --
379: /*Set Workflow attributes.*/
380: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);

Line 383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);

379: /*Set Workflow attributes.*/
380: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);

Line 384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);

380: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
388: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);

Line 385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);

381: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
388: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
389: -- Start of bug 13474562

Line 386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);

382: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
388: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
389: -- Start of bug 13474562
390: create_item_attrib_if_notexist(itemtype =>l_item_type,itemkey =>p_item_key,aname => 'P_CALLED_FROM',text_value =>P_CALLED_FROM );

Line 387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);

383: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
388: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
389: -- Start of bug 13474562
390: create_item_attrib_if_notexist(itemtype =>l_item_type,itemkey =>p_item_key,aname => 'P_CALLED_FROM',text_value =>P_CALLED_FROM );
391: -- End of bug 13474562

Line 388: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);

384: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
385: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
386: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
387: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
388: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
389: -- Start of bug 13474562
390: create_item_attrib_if_notexist(itemtype =>l_item_type,itemkey =>p_item_key,aname => 'P_CALLED_FROM',text_value =>P_CALLED_FROM );
391: -- End of bug 13474562
392:

Line 395: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);

391: -- End of bug 13474562
392:
393: /*As the control comes here only for the first time. At this time only requestor would be there.
394: So for the time being we are setting the previous approver details as the requestor.*/
395: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
396: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_NAME', l_requestor_name);
397:
398: /*Get the AME/workflow admin details and populate the attributes.*/
399: ame_api2.getAdminApprover(applicationIdIn => 801,

Line 396: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_NAME', l_requestor_name);

392:
393: /*As the control comes here only for the first time. At this time only requestor would be there.
394: So for the time being we are setting the previous approver details as the requestor.*/
395: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
396: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_NAME', l_requestor_name);
397:
398: /*Get the AME/workflow admin details and populate the attributes.*/
399: ame_api2.getAdminApprover(applicationIdIn => 801,
400: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',

Line 402: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_LOGIN_NAME',l_wf_admin.name);

398: /*Get the AME/workflow admin details and populate the attributes.*/
399: ame_api2.getAdminApprover(applicationIdIn => 801,
400: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',
401: adminApproverOut => l_wf_admin);
402: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_LOGIN_NAME',l_wf_admin.name);
403: wf_directory.GetRoleName(p_orig_system => NVL(l_wf_admin.orig_system,'PER')
404: ,p_orig_system_id => l_wf_admin.orig_system_id
405: ,p_name => l_admin_name
406: ,p_display_name => l_admin_display_name);

Line 407: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_NAME',l_admin_display_name);

403: wf_directory.GetRoleName(p_orig_system => NVL(l_wf_admin.orig_system,'PER')
404: ,p_orig_system_id => l_wf_admin.orig_system_id
405: ,p_name => l_admin_name
406: ,p_display_name => l_admin_display_name);
407: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_NAME',l_admin_display_name);
408:
409: /*Start the created workflow process.*/
410: wf_engine.StartProcess (itemtype => l_Item_Type
411: ,itemkey => p_Item_Key

Line 410: wf_engine.StartProcess (itemtype => l_Item_Type

406: ,p_display_name => l_admin_display_name);
407: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_NAME',l_admin_display_name);
408:
409: /*Start the created workflow process.*/
410: wf_engine.StartProcess (itemtype => l_Item_Type
411: ,itemkey => p_Item_Key
412: );
413: EXCEPTION
414: WHEN OTHERS THEN

Line 441: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',

437: if g_debug then
438: hr_utility.set_location('Entering ..'||l_proc,10);
439: end if;
440: /*Set the previous approver attributes.*/
441: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
442: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
443: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
444: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
445:

Line 442: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));

438: hr_utility.set_location('Entering ..'||l_proc,10);
439: end if;
440: /*Set the previous approver attributes.*/
441: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
442: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
443: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
444: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
445:
446: /* Get the transaction step id pertaining to the work flow process

Line 443: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',

439: end if;
440: /*Set the previous approver attributes.*/
441: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
442: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
443: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
444: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
445:
446: /* Get the transaction step id pertaining to the work flow process
447: identified by the itemkey, itemkey and actid.*/

Line 444: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));

440: /*Set the previous approver attributes.*/
441: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
442: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
443: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
444: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
445:
446: /* Get the transaction step id pertaining to the work flow process
447: identified by the itemkey, itemkey and actid.*/
448: hr_transaction_api.get_transaction_step_info(p_item_type => itemtype