DBA Data[Home] [Help]

APPS.PAY_ASSG_COST_WF dependencies on WF_ENGINE

Line 24: l_transaction_id := wf_engine.GetItemAttrNumber(

20: l_performer_id number(10);
21: l_proc varchar2(100) := g_package||'GET_TRANSACTION_ID';
22: BEGIN
23: hr_utility.set_location('Entering ... '||l_proc,10);
24: l_transaction_id := wf_engine.GetItemAttrNumber(
25: itemtype => itemtype
26: ,itemkey => itemkey
27: ,aname => 'TRANSACTION_ID'
28: ,ignore_notfound => false

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

29: );
30: /*If no transaction exists, start a transaction.*/
31: IF L_TRANSACTION_ID IS NULL THEN
32: hr_utility.set_location(l_proc || '....Step1',20);
33: l_performer_id := wf_engine.GetItemAttrNumber(itemtype, itemkey, 'PERFORMER_PERSON_ID');
34:
35: hr_utility.set_location(l_proc , 30);
36:
37: hr_transaction_ss.start_transaction

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

46: /*Gett the newly created transaction and set as workflow attribute*/
47: l_transaction_id:= hr_transaction_ss.get_transaction_id
48: (p_item_type => itemtype
49: ,p_item_key => itemkey);
50: wf_engine.SetItemAttrNumber(itemtype,itemkey,'TRANSACTION_ID',l_transaction_id);
51: hr_utility.set_location(l_proc ,50);
52:
53: END IF;
54: hr_utility.set_location('Leaving....'||l_proc ,60);

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

108: /*This is to catch the exception when there is no approver etc.
109: Once the exception raises, then the AME/workflow admin will get
110: the notification with the exception message raised.*/
111: when OTHERS then
112: wf_engine.setItemAttrText(itemtype, itemkey,'AME_EXCEPTION',SQLERRM(SQLCODE));
113: resultout:='F';
114: end;
115: if resultout <> 'F' and l_apprvl_process_complete <> ame_util.booleanTrue then
116: /*First clear all approvers, then get the approver again. This is to by-pass

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

127: transactionIdIn => l_transaction_id,
128: approvalProcessCompleteYNOut => l_apprvl_process_complete,
129: nextApproversOut => g_approver);
130: if (l_apprvl_process_complete <> ame_util.booleanTrue) then
131: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
132: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
133: ,p_orig_system_id => g_approver(1).orig_system_id
134: ,p_name => l_role_name
135: ,p_display_name => l_role_display_name);

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

132: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
133: ,p_orig_system_id => g_approver(1).orig_system_id
134: ,p_name => l_role_name
135: ,p_display_name => l_role_display_name);
136: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_NAME',l_role_display_name);
137: resultout:='T';
138: end if;
139: end if;
140: EXCEPTION

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

181: applicationIdIn =>801,
182: transactionTypeIn =>'PAY_ASSIGNMENT_COSTING',
183: transactionIdIn =>l_transaction_id,
184: approvalStatusIn => ame_util.approvedStatus,
185: approverNameIn => wf_engine.getItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME'),
186: updateItemIn => true);
187:
188: /*Now get the next approver.*/
189: hr_utility.set_location(l_proc,30);

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

201: APIs*/
202: hr_utility.set_location(l_proc, 40);
203: if l_apprvl_process_complete = ame_util.booleanFalse then
204: /*Set the previous approver attributes.*/
205: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
206: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
207: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
208: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
209:

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

202: hr_utility.set_location(l_proc, 40);
203: if l_apprvl_process_complete = ame_util.booleanFalse then
204: /*Set the previous approver attributes.*/
205: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
206: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
207: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
208: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
209:
210: /*Set the current approver attributes.*/

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

203: if l_apprvl_process_complete = ame_util.booleanFalse then
204: /*Set the previous approver attributes.*/
205: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
206: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
207: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
208: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
209:
210: /*Set the current approver attributes.*/
211: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);

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

204: /*Set the previous approver attributes.*/
205: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
206: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
207: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
208: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
209:
210: /*Set the current approver attributes.*/
211: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
212: /*Get the approver name from wf_roles.*/

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

207: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
208: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
209:
210: /*Set the current approver attributes.*/
211: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME',g_approver(1).name);
212: /*Get the approver name from wf_roles.*/
213: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
214: ,p_orig_system_id => g_approver(1).orig_system_id
215: ,p_name => l_role_name

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

213: wf_directory.GetRoleName(p_orig_system => NVL(g_approver(1).orig_system,'PER')
214: ,p_orig_system_id => g_approver(1).orig_system_id
215: ,p_name => l_role_name
216: ,p_display_name => l_role_display_name);
217: wf_engine.setItemAttrText(itemtype, itemkey,'APPROVER_NAME',l_role_display_name);
218:
219: resultout := 'T';
220: else
221: resultout := 'F';

Line 262: wf_engine.CreateProcess (ItemType => l_Item_Type

258: and trunc(sysdate) between effective_start_date and effective_end_date;
259: BEGIN
260: hr_utility.set_location('Entering....'||l_proc,10);
261: /*Create the workflow process.*/
262: wf_engine.CreateProcess (ItemType => l_Item_Type
263: ,ItemKey => p_Item_Key
264: ,process => l_process
265: ,User_Key => l_user_key
266: ,Owner_Role => 'COREPAY'

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

277: ,p_display_name => l_requestor_name);
278:
279: --
280: /*Set Workflow attributes.*/
281: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
282: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);

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

278:
279: --
280: /*Set Workflow attributes.*/
281: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
282: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);

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

279: --
280: /*Set Workflow attributes.*/
281: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
282: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);

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

280: /*Set Workflow attributes.*/
281: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
282: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
288: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);

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

281: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_PERSON_ID', P_PERSON_ID);
282: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
288: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
289: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);

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

282: wf_engine.setItemAttrNumber(l_item_type, p_item_key, 'CURRENT_ASSIGNMENT_ID',P_ASSIGNMENT_ID);
283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
288: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
289: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
290:

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

283: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PROCESS_NAME','PYASGWF_PROCESS');
284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
288: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
289: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
290:
291: /*As the control comes here only for the first time. At this time only requestor would be there.

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

284: wf_engine.setItemAttrDate(l_item_type, p_item_key,'CURRENT_EFFECTIVE_DATE',SYSDATE);
285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
288: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
289: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
290:
291: /*As the control comes here only for the first time. At this time only requestor would be there.
292: So for the time being we are setting the previous approver details as the requestor.*/

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

285: wf_engine.setItemAttrNumber(l_item_type, p_item_key,'PERFORMER_PERSON_ID',P_PERFORMER_ID);
286: wf_engine.setItemAttrDate(l_item_type, p_item_key,'EFFECTIVE_DATE',P_EFFECTIVE_DATE);
287: wf_engine.setItemAttrText(l_item_type, p_item_key, 'EMP_NAME', l_employee_name);
288: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
289: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
290:
291: /*As the control comes here only for the first time. At this time only requestor would be there.
292: So for the time being we are setting the previous approver details as the requestor.*/
293: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);

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

289: wf_engine.setItemAttrText(l_item_type, p_item_key, 'REQUESTOR_NAME', l_requestor_name);
290:
291: /*As the control comes here only for the first time. At this time only requestor would be there.
292: So for the time being we are setting the previous approver details as the requestor.*/
293: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
294: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_NAME', l_requestor_name);
295:
296: /*Get the AME/workflow admin details and populate the attributes.*/
297: ame_api2.getAdminApprover(applicationIdIn => 801,

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

290:
291: /*As the control comes here only for the first time. At this time only requestor would be there.
292: So for the time being we are setting the previous approver details as the requestor.*/
293: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_LOGIN_NAME', P_PERFORMER_LOGIN_NAME);
294: wf_engine.setItemAttrText(l_item_type, p_item_key, 'PREVIOUS_APPROVER_NAME', l_requestor_name);
295:
296: /*Get the AME/workflow admin details and populate the attributes.*/
297: ame_api2.getAdminApprover(applicationIdIn => 801,
298: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',

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

296: /*Get the AME/workflow admin details and populate the attributes.*/
297: ame_api2.getAdminApprover(applicationIdIn => 801,
298: transactionTypeIn => 'PAY_ASSIGNMENT_COSTING',
299: adminApproverOut => l_wf_admin);
300: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_LOGIN_NAME',l_wf_admin.name);
301: wf_directory.GetRoleName(p_orig_system => NVL(l_wf_admin.orig_system,'PER')
302: ,p_orig_system_id => l_wf_admin.orig_system_id
303: ,p_name => l_admin_name
304: ,p_display_name => l_admin_display_name);

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

301: wf_directory.GetRoleName(p_orig_system => NVL(l_wf_admin.orig_system,'PER')
302: ,p_orig_system_id => l_wf_admin.orig_system_id
303: ,p_name => l_admin_name
304: ,p_display_name => l_admin_display_name);
305: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_NAME',l_admin_display_name);
306:
307: /*Start the created workflow process.*/
308: wf_engine.StartProcess (itemtype => l_Item_Type
309: ,itemkey => p_Item_Key

Line 308: wf_engine.StartProcess (itemtype => l_Item_Type

304: ,p_display_name => l_admin_display_name);
305: wf_engine.setItemAttrText(l_item_type, p_item_key,'WF_ADMIN_NAME',l_admin_display_name);
306:
307: /*Start the created workflow process.*/
308: wf_engine.StartProcess (itemtype => l_Item_Type
309: ,itemkey => p_Item_Key
310: );
311: END START_WF_PROCESS;
312: -- ------------------------------------------------------------------------

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

328: l_effective_date DATE;
329: begin
330:
331: /*Set the previous approver attributes.*/
332: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
333: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
334: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
335: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
336:

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

329: begin
330:
331: /*Set the previous approver attributes.*/
332: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
333: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
334: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
335: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
336:
337: /* Get the transaction step id pertaining to the work flow process

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

330:
331: /*Set the previous approver attributes.*/
332: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
333: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
334: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
335: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
336:
337: /* Get the transaction step id pertaining to the work flow process
338: identified by the itemkey, itemkey and actid.*/

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

331: /*Set the previous approver attributes.*/
332: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_LOGIN_NAME',
333: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_LOGIN_NAME'));
334: wf_engine.setItemAttrText(itemtype, itemkey,'PREVIOUS_APPROVER_NAME',
335: wf_engine.getItemAttrText(itemtype, itemkey, 'APPROVER_NAME'));
336:
337: /* Get the transaction step id pertaining to the work flow process
338: identified by the itemkey, itemkey and actid.*/
339: hr_transaction_api.get_transaction_step_info(p_item_type => itemtype