[Home] [Help]
49: if csr_wiav%notfound then
50: --
51: -- item attribute does not exist so create it
52: if g_debug then
53: hr_utility.set_location('calling wf_engine.additemattr for aname:'||aname,2);
54: end if;
55: wf_engine.additemattr
56: (itemtype => itemtype
57: ,itemkey => itemkey
51: -- item attribute does not exist so create it
52: if g_debug then
53: hr_utility.set_location('calling wf_engine.additemattr for aname:'||aname,2);
54: end if;
55: wf_engine.additemattr
56: (itemtype => itemtype
57: ,itemkey => itemkey
58: ,aname => aname
59: ,text_value=>text_value
65: if csr_wiav%found then
66: -- set the values as per the type
67: if(text_value is not null) then
68: if g_debug then
69: hr_utility.set_location('calling wf_engine.setitemattrtext for text_value:'|| text_value,3);
70: end if;
71: wf_engine.setitemattrtext(itemtype,itemkey,aname,text_value);
72: end if;
73:
67: if(text_value is not null) then
68: if g_debug then
69: hr_utility.set_location('calling wf_engine.setitemattrtext for text_value:'|| text_value,3);
70: end if;
71: wf_engine.setitemattrtext(itemtype,itemkey,aname,text_value);
72: end if;
73:
74: if(number_value is not null) then
75: if g_debug then
72: end if;
73:
74: if(number_value is not null) then
75: if g_debug then
76: hr_utility.set_location('calling wf_engine.setitemattrnumber for text_value:'|| number_value,4);
77: end if;
78: wf_engine.setitemattrnumber(itemtype,itemkey,aname,number_value);
79: end if;
80:
74: if(number_value is not null) then
75: if g_debug then
76: hr_utility.set_location('calling wf_engine.setitemattrnumber for text_value:'|| number_value,4);
77: end if;
78: wf_engine.setitemattrnumber(itemtype,itemkey,aname,number_value);
79: end if;
80:
81: if(date_value is not null) then
82: if g_debug then
79: end if;
80:
81: if(date_value is not null) then
82: if g_debug then
83: hr_utility.set_location('calling wf_engine.setitemattrDate for text_value:'|| date_value,5);
84: end if;
85: wf_engine.setitemattrDate(itemtype,itemkey,aname,date_value);
86: end if;
87:
81: if(date_value is not null) then
82: if g_debug then
83: hr_utility.set_location('calling wf_engine.setitemattrDate for text_value:'|| date_value,5);
84: end if;
85: wf_engine.setitemattrDate(itemtype,itemkey,aname,date_value);
86: end if;
87:
88: end if;
89:
208: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
209: end if;
210:
211: -- get the transaction id of the sshr transaction
212: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
213: itemkey => p_item_key,
214: aname => 'TRANSACTION_ID',
215: ignore_notfound=>true);
216:
217: if ( funmode = 'RESPOND' ) then
218: select text_value
219: into lv_result_code
220: from wf_notification_attributes
221: where notification_id=wf_engine.context_nid
222: and name='RESULT';
223:
224: begin
225: hr_sflutil_ss.closeopensflnotification(c_transaction_id);
234: begin
235: select text_value
236: into lv_comments
237: from wf_notification_attributes
238: where notification_id=wf_engine.context_nid
239: and name='WF_NOTE';
240: exception
241: when others then
242: null;
242: null;
243: end;
244:
245: if g_debug then
246: hr_utility.set_location('processing notification response, notification_id:'||wf_engine.context_nid,2);
247: hr_utility.set_location('lv_result_code:'||lv_result_code,3);
248: end if;
249:
250: -- possible actions
265: hr_utility.set_location('calling hr_trans_history_api.archive_approve',4);
266: end if;
267: -- use the new routing api's to handle archive
268: hr_trans_history_api.archive_approve(c_transaction_id,
269: wf_engine.context_nid,
270: wf_engine.context_user,
271: lv_comments);
272:
273: elsif(lv_result_code='RESUBMIT') then
266: end if;
267: -- use the new routing api's to handle archive
268: hr_trans_history_api.archive_approve(c_transaction_id,
269: wf_engine.context_nid,
270: wf_engine.context_user,
271: lv_comments);
272:
273: elsif(lv_result_code='RESUBMIT') then
274: if g_debug then
275: hr_utility.set_location('calling hr_trans_history_api.archive_approve',4);
276: end if;
277: -- use the new routing api's to handle archive
278: hr_trans_history_api.archive_resubmit(c_transaction_id,
279: wf_engine.context_nid,
280: wf_engine.context_user,
281: wf_engine.GetItemAttrText(
282: p_item_type
283: ,p_item_key
276: end if;
277: -- use the new routing api's to handle archive
278: hr_trans_history_api.archive_resubmit(c_transaction_id,
279: wf_engine.context_nid,
280: wf_engine.context_user,
281: wf_engine.GetItemAttrText(
282: p_item_type
283: ,p_item_key
284: ,'APPROVAL_COMMENT_COPY'));
277: -- use the new routing api's to handle archive
278: hr_trans_history_api.archive_resubmit(c_transaction_id,
279: wf_engine.context_nid,
280: wf_engine.context_user,
281: wf_engine.GetItemAttrText(
282: p_item_type
283: ,p_item_key
284: ,'APPROVAL_COMMENT_COPY'));
285: elsif(lv_result_code='REJECTED') then
288: hr_utility.set_location('calling hr_trans_history_api.archive_reject',5);
289: end if;
290: -- archive the action to history
291: hr_trans_history_api.archive_reject(c_transaction_id,
292: wf_engine.context_nid,
293: wf_engine.context_user,
294: lv_comments);
295: elsif(lv_result_code='RETURNEDFORCORRECTION') then
296: if g_debug then
289: end if;
290: -- archive the action to history
291: hr_trans_history_api.archive_reject(c_transaction_id,
292: wf_engine.context_nid,
293: wf_engine.context_user,
294: lv_comments);
295: elsif(lv_result_code='RETURNEDFORCORRECTION') then
296: if g_debug then
297: hr_utility.set_location('calling hr_trans_history_api.archive_rfc',6);
297: hr_utility.set_location('calling hr_trans_history_api.archive_rfc',6);
298: end if;
299: -- archive the action to history
300: hr_trans_history_api.archive_rfc(c_transaction_id,
301: wf_engine.context_nid,
302: wf_engine.context_user,
303: lv_comments);
304: --wf_engine.context_user_comment);
305: elsif(lv_result_code='DEL') then
298: end if;
299: -- archive the action to history
300: hr_trans_history_api.archive_rfc(c_transaction_id,
301: wf_engine.context_nid,
302: wf_engine.context_user,
303: lv_comments);
304: --wf_engine.context_user_comment);
305: elsif(lv_result_code='DEL') then
306: if g_debug then
300: hr_trans_history_api.archive_rfc(c_transaction_id,
301: wf_engine.context_nid,
302: wf_engine.context_user,
303: lv_comments);
304: --wf_engine.context_user_comment);
305: elsif(lv_result_code='DEL') then
306: if g_debug then
307: hr_utility.set_location('calling hr_trans_history_api.archive_delete',7);
308: end if;
307: hr_utility.set_location('calling hr_trans_history_api.archive_delete',7);
308: end if;
309: -- archive the action to history
310: hr_trans_history_api.archive_delete(c_transaction_id,
311: wf_engine.context_nid,
312: wf_engine.context_user,
313: lv_comments);
314: end if;
315: exception
308: end if;
309: -- archive the action to history
310: hr_trans_history_api.archive_delete(c_transaction_id,
311: wf_engine.context_nid,
312: wf_engine.context_user,
313: lv_comments);
314: end if;
315: exception
316: when others then
318: end;
319: elsif( funmode = 'FORWARD' ) then
320: -- FORWARD - When a notification recipient forwards the notification.
321: hr_trans_history_api.archive_forward(c_transaction_id,
322: wf_engine.context_nid,
323: wf_engine.context_user,
324: wf_engine.context_user_comment);
325: null;
326: elsif( funmode = 'TRANSFER' ) then
319: elsif( funmode = 'FORWARD' ) then
320: -- FORWARD - When a notification recipient forwards the notification.
321: hr_trans_history_api.archive_forward(c_transaction_id,
322: wf_engine.context_nid,
323: wf_engine.context_user,
324: wf_engine.context_user_comment);
325: null;
326: elsif( funmode = 'TRANSFER' ) then
327: -- TRANSFER - When a notification recipient transfers the notification.
320: -- FORWARD - When a notification recipient forwards the notification.
321: hr_trans_history_api.archive_forward(c_transaction_id,
322: wf_engine.context_nid,
323: wf_engine.context_user,
324: wf_engine.context_user_comment);
325: null;
326: elsif( funmode = 'TRANSFER' ) then
327: -- TRANSFER - When a notification recipient transfers the notification.
328: hr_trans_history_api.archive_transfer(c_transaction_id,
325: null;
326: elsif( funmode = 'TRANSFER' ) then
327: -- TRANSFER - When a notification recipient transfers the notification.
328: hr_trans_history_api.archive_transfer(c_transaction_id,
329: wf_engine.context_nid,
330: wf_engine.context_user,
331: wf_engine.context_user_comment);
332: -- QUESTION
333: elsif( funmode = 'QUESTION' ) then
326: elsif( funmode = 'TRANSFER' ) then
327: -- TRANSFER - When a notification recipient transfers the notification.
328: hr_trans_history_api.archive_transfer(c_transaction_id,
329: wf_engine.context_nid,
330: wf_engine.context_user,
331: wf_engine.context_user_comment);
332: -- QUESTION
333: elsif( funmode = 'QUESTION' ) then
334: hr_trans_history_api.archive_req_moreinfo(c_transaction_id,
327: -- TRANSFER - When a notification recipient transfers the notification.
328: hr_trans_history_api.archive_transfer(c_transaction_id,
329: wf_engine.context_nid,
330: wf_engine.context_user,
331: wf_engine.context_user_comment);
332: -- QUESTION
333: elsif( funmode = 'QUESTION' ) then
334: hr_trans_history_api.archive_req_moreinfo(c_transaction_id,
335: wf_engine.context_nid,
331: wf_engine.context_user_comment);
332: -- QUESTION
333: elsif( funmode = 'QUESTION' ) then
334: hr_trans_history_api.archive_req_moreinfo(c_transaction_id,
335: wf_engine.context_nid,
336: wf_engine.context_user,
337: wf_engine.context_user_comment);
338:
339: elsif( funmode = 'ANSWER' ) then
332: -- QUESTION
333: elsif( funmode = 'QUESTION' ) then
334: hr_trans_history_api.archive_req_moreinfo(c_transaction_id,
335: wf_engine.context_nid,
336: wf_engine.context_user,
337: wf_engine.context_user_comment);
338:
339: elsif( funmode = 'ANSWER' ) then
340: hr_trans_history_api.archive_answer_moreinfo(c_transaction_id,
333: elsif( funmode = 'QUESTION' ) then
334: hr_trans_history_api.archive_req_moreinfo(c_transaction_id,
335: wf_engine.context_nid,
336: wf_engine.context_user,
337: wf_engine.context_user_comment);
338:
339: elsif( funmode = 'ANSWER' ) then
340: hr_trans_history_api.archive_answer_moreinfo(c_transaction_id,
341: wf_engine.context_nid,
337: wf_engine.context_user_comment);
338:
339: elsif( funmode = 'ANSWER' ) then
340: hr_trans_history_api.archive_answer_moreinfo(c_transaction_id,
341: wf_engine.context_nid,
342: wf_engine.context_user,
343: wf_engine.context_user_comment);
344: elsif( funmode = 'TIMEOUT' ) then
345: if hr_multi_tenancy_pkg.is_multi_tenant_system then
338:
339: elsif( funmode = 'ANSWER' ) then
340: hr_trans_history_api.archive_answer_moreinfo(c_transaction_id,
341: wf_engine.context_nid,
342: wf_engine.context_user,
343: wf_engine.context_user_comment);
344: elsif( funmode = 'TIMEOUT' ) then
345: if hr_multi_tenancy_pkg.is_multi_tenant_system then
346: l_cpersonId := NVL( wf_engine.getItemAttrText (
339: elsif( funmode = 'ANSWER' ) then
340: hr_trans_history_api.archive_answer_moreinfo(c_transaction_id,
341: wf_engine.context_nid,
342: wf_engine.context_user,
343: wf_engine.context_user_comment);
344: elsif( funmode = 'TIMEOUT' ) then
345: if hr_multi_tenancy_pkg.is_multi_tenant_system then
346: l_cpersonId := NVL( wf_engine.getItemAttrText (
347: itemtype => p_item_type
342: wf_engine.context_user,
343: wf_engine.context_user_comment);
344: elsif( funmode = 'TIMEOUT' ) then
345: if hr_multi_tenancy_pkg.is_multi_tenant_system then
346: l_cpersonId := NVL( wf_engine.getItemAttrText (
347: itemtype => p_item_type
348: ,itemkey => p_item_key
349: ,aname => 'CREATOR_PERSON_ID'),-1);
350:
352: end if;
353: if g_debug then
354: hr_utility.set_location('calling hr_trans_history_api.archive_timeout',7);
355: end if;
356: lv_new_transaction := wf_engine.getitemattrtext(p_item_type,
357: p_item_key,
358: 'HR_NEW_TRANSACTION',true);
359:
360: if( INSTR(lv_new_transaction,'TIMEOUT') > 0) then
363: begin
364: select RECIPIENT_ROLE
365: into lv_recipient
366: from wf_notifications
367: where notification_id=wf_engine.context_nid;
368: exception
369: when others then
370: null;
371: end;
370: null;
371: end;
372: -- archive the action to history
373: hr_trans_history_api.archive_timeout(c_transaction_id,
374: wf_engine.context_nid,
375: lv_recipient,
376: lv_comments);
377: end if;
378: end if;
377: end if;
378: end if;
379:
380: if(lv_result_code is null) then
381: result := wf_engine.eng_null;
382: else
383: result:= 'COMPLETE:'||lv_result_code;
384: end if;
385:
414: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
415: end if;
416: -- get the current forward to approver details
417: l_current_forward_to_id :=
418: nvl(wf_engine.GetItemAttrNumber
419: (itemtype => p_item_type
420: ,itemkey => p_item_key
421: ,aname => 'FORWARD_TO_PERSON_ID'),
422: wf_engine.GetItemAttrNumber
418: nvl(wf_engine.GetItemAttrNumber
419: (itemtype => p_item_type
420: ,itemkey => p_item_key
421: ,aname => 'FORWARD_TO_PERSON_ID'),
422: wf_engine.GetItemAttrNumber
423: (itemtype => p_item_type
424: ,itemkey => p_item_key
425: ,aname => 'CREATOR_PERSON_ID'));
426:
439: ,number_value=>null,
440: date_value=>null
441: );
442:
443: l_current_forward_to_origSys := nvl( wf_engine.GetItemAttrText
444: (itemtype => p_item_type
445: ,itemkey => p_item_key
446: ,aname => 'FORWARD_TO_ORIG_SYS_ATTR'
447: ,ignore_notfound=>true),'PER');
458: ,p_name => l_current_forward_to_username
459: ,p_display_name => l_current_forward_to_disp_name);
460:
461: -- set the passed approver values to the forward to item attributes
462: wf_engine.SetItemAttrText
463: (itemtype => p_item_type
464: ,itemkey => p_item_key
465: ,aname => 'FORWARD_TO_ORIG_SYS_ATTR'
466: ,avalue =>wf_engine.getItemAttrText
462: wf_engine.SetItemAttrText
463: (itemtype => p_item_type
464: ,itemkey => p_item_key
465: ,aname => 'FORWARD_TO_ORIG_SYS_ATTR'
466: ,avalue =>wf_engine.getItemAttrText
467: (itemtype => p_item_type
468: ,itemkey => p_item_key
469: ,aname =>'HR_APR_ORIG_SYSTEM_ATTR'));
470:
467: (itemtype => p_item_type
468: ,itemkey => p_item_key
469: ,aname =>'HR_APR_ORIG_SYSTEM_ATTR'));
470:
471: wf_engine.SetItemAttrNumber
472: (itemtype => p_item_type
473: ,itemkey => p_item_key
474: ,aname => 'FORWARD_TO_PERSON_ID'
475: ,avalue =>wf_engine.getItemAttrNumber
471: wf_engine.SetItemAttrNumber
472: (itemtype => p_item_type
473: ,itemkey => p_item_key
474: ,aname => 'FORWARD_TO_PERSON_ID'
475: ,avalue =>wf_engine.getItemAttrNumber
476: (itemtype => p_item_type
477: ,itemkey => p_item_key
478: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR'));
479: --
476: (itemtype => p_item_type
477: ,itemkey => p_item_key
478: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR'));
479: --
480: wf_engine.SetItemAttrText
481: (itemtype => p_item_type
482: ,itemkey => p_item_key
483: ,aname => 'FORWARD_TO_USERNAME'
484: ,avalue => wf_engine.getItemAttrText
480: wf_engine.SetItemAttrText
481: (itemtype => p_item_type
482: ,itemkey => p_item_key
483: ,aname => 'FORWARD_TO_USERNAME'
484: ,avalue => wf_engine.getItemAttrText
485: (itemtype => p_item_type
486: ,itemkey => p_item_key
487: ,aname => 'HR_APR_NAME_ATTR'));
488:
486: ,itemkey => p_item_key
487: ,aname => 'HR_APR_NAME_ATTR'));
488:
489: --
490: Wf_engine.SetItemAttrText
491: (itemtype => p_item_type
492: ,itemkey => p_item_key
493: ,aname => 'FORWARD_TO_DISPLAY_NAME'
494: ,avalue => wf_engine.getItemAttrText
490: Wf_engine.SetItemAttrText
491: (itemtype => p_item_type
492: ,itemkey => p_item_key
493: ,aname => 'FORWARD_TO_DISPLAY_NAME'
494: ,avalue => wf_engine.getItemAttrText
495: (itemtype => p_item_type
496: ,itemkey => p_item_key
497: ,aname => 'HR_APR_DISPLAY_NAME_ATTR'));
498: --
497: ,aname => 'HR_APR_DISPLAY_NAME_ATTR'));
498: --
499: -- set forward from to old forward to
500: --
501: wf_engine.SetItemAttrNumber
502: (itemtype => p_item_type
503: ,itemkey => p_item_key
504: ,aname => 'FORWARD_FROM_PERSON_ID'
505: ,avalue => l_current_forward_to_id);
504: ,aname => 'FORWARD_FROM_PERSON_ID'
505: ,avalue => l_current_forward_to_id);
506:
507: -- FORWARD_FROM_ORIG_SYS_ATTR
508: wf_engine.SetItemAttrText
509: (itemtype => p_item_type
510: ,itemkey => p_item_key
511: ,aname => 'FORWARD_FROM_ORIG_SYS_ATTR'
512: ,avalue => l_current_forward_to_origSys);
524: ,p_orig_system_id => l_current_forward_to_id
525: ,p_name => l_current_forward_to_username
526: ,p_display_name => l_current_forward_to_disp_name);
527: --
528: wf_engine.SetItemAttrText
529: (itemtype => p_item_type
530: ,itemkey => p_item_key
531: ,aname => 'FORWARD_FROM_USERNAME'
532: ,avalue => l_current_forward_to_username);
530: ,itemkey => p_item_key
531: ,aname => 'FORWARD_FROM_USERNAME'
532: ,avalue => l_current_forward_to_username);
533: --
534: wf_engine.SetItemAttrText
535: (itemtype => p_item_type
536: ,itemkey => p_item_key
537: ,aname => 'FORWARD_FROM_DISPLAY_NAME'
538: ,avalue => l_current_forward_to_disp_name);
542: -- FORWARD_TO_ITEM_CLASS_ATTR
543: create_item_attrib_if_notexist(itemtype => p_item_type
544: ,itemkey => p_item_key
545: ,aname => 'FORWARD_TO_ITEM_CLASS_ATTR'
546: ,text_value=>wf_engine.getItemAttrText
547: (itemtype => p_item_type
548: ,itemkey => p_item_key
549: ,aname => 'HR_APR_ITEM_CLASS_ATTR')
550: ,number_value=>null,
555: -- FORWARD_TO_ITEM_ID_ATTR
556: create_item_attrib_if_notexist(itemtype => p_item_type
557: ,itemkey => p_item_key
558: ,aname => 'FORWARD_TO_ITEM_ID_ATTR'
559: ,text_value=>wf_engine.getItemAttrText
560: (itemtype => p_item_type
561: ,itemkey => p_item_key
562: ,aname => 'HR_APR_ITEM_ID_ATTR')
563: ,number_value=>null,
569: create_item_attrib_if_notexist(itemtype => p_item_type
570: ,itemkey => p_item_key
571: ,aname => 'FORWARD_TO_GROUPORCHAINID'
572: ,text_value=>null
573: ,number_value=>wf_engine.getItemAttrNumber
574: (itemtype => p_item_type
575: ,itemkey => p_item_key
576: ,aname => 'HR_APR_GRPORCHN_ID_ATTR'),
577: date_value=>null
581: -- FORWARD_TO_ACTIONTYPEID_ATTR
582: create_item_attrib_if_notexist(itemtype => p_item_type
583: ,itemkey => p_item_key
584: ,aname => 'FORWARD_TO_ACTIONTYPEID_ATTR'
585: ,text_value=>wf_engine.getItemAttrText
586: (itemtype => p_item_type
587: ,itemkey => p_item_key
588: ,aname => 'HR_APR_ACTION_TYPE_ID_ATTR')
589: ,number_value=>null,
634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
635: end if;
636:
637: --
638: l_creator_person_id := wf_engine.GetItemAttrNumber
639: (itemtype => p_item_type
640: ,itemkey => p_item_key
641: ,aname => 'CREATOR_PERSON_ID');
642: --
639: (itemtype => p_item_type
640: ,itemkey => p_item_key
641: ,aname => 'CREATOR_PERSON_ID');
642: --
643: l_forward_to_person_id := wf_engine.GetItemAttrNumber
644: (itemtype => p_item_type
645: ,itemkey => p_item_key
646: ,aname =>'FORWARD_TO_PERSON_ID');
647:
646: ,aname =>'FORWARD_TO_PERSON_ID');
647:
648: -- get the current forward to person
649: l_current_forward_to_id :=
650: nvl(wf_engine.GetItemAttrNumber
651: (itemtype => p_item_type
652: ,itemkey => p_item_key
653: ,aname => 'FORWARD_TO_PERSON_ID'),
654: wf_engine.GetItemAttrNumber
650: nvl(wf_engine.GetItemAttrNumber
651: (itemtype => p_item_type
652: ,itemkey => p_item_key
653: ,aname => 'FORWARD_TO_PERSON_ID'),
654: wf_engine.GetItemAttrNumber
655: (itemtype => p_item_type
656: ,itemkey => p_item_key
657: ,aname => 'CREATOR_PERSON_ID'));
658:
668: (p_item_type => p_item_type
669: ,p_item_key => p_item_key
670: ,p_name => 'LAST_DEFAULT_APPROVER');
671:
672: wf_engine.SetItemAttrNumber
673: (itemtype => p_item_type,
674: itemkey => p_item_key,
675: aname => 'LAST_DEFAULT_APPROVER',
676: avalue => NULL);
679: CLOSE csr_wiav;
680:
681:
682: -- 'LAST_DEFAULT_APPROVER'
683: ln_last_def_approver:= wf_engine.GetItemAttrNumber
684: (itemtype => p_item_type,
685: itemkey => p_item_key,
686: aname => 'LAST_DEFAULT_APPROVER'
687: );
710: FETCH csr_wiav into l_dummy;
711: IF csr_wiav%notfound THEN
712: ln_approval_level := 0;
713: ELSE
714: ln_approval_level := wf_engine.GetItemAttrNumber
715: (itemtype => p_item_type,
716: itemkey => p_item_key,
717: aname => 'APPROVAL_LEVEL');
718: END IF; -- for csr_wiav%notfound
728: FETCH csr_wiav into l_dummy;
729: IF csr_wiav%notfound THEN
730: NULL;
731: ELSE
732: ln_curr_def_appr_index := wf_engine.GetItemAttrNumber
733: (itemtype => p_item_type,
734: itemkey => p_item_key,
735: aname => 'CURRENT_DEF_APPR_INDEX');
736: END IF;-- for csr_wiav%notfound
769: ln_addntl_approvers:= null;
770: ln_current_approver_index:=null;
771: -- get the current forward from person
772: l_current_forward_from_id :=
773: nvl(wf_engine.GetItemAttrNumber
774: (itemtype => p_item_type
775: ,itemkey => p_item_key
776: ,aname => 'FORWARD_FROM_PERSON_ID'),
777: wf_engine.GetItemAttrNumber
773: nvl(wf_engine.GetItemAttrNumber
774: (itemtype => p_item_type
775: ,itemkey => p_item_key
776: ,aname => 'FORWARD_FROM_PERSON_ID'),
777: wf_engine.GetItemAttrNumber
778: (itemtype => p_item_type
779: ,itemkey => p_item_key
780: ,aname => 'CREATOR_PERSON_ID'));
781: -- get the current forward to person
779: ,itemkey => p_item_key
780: ,aname => 'CREATOR_PERSON_ID'));
781: -- get the current forward to person
782: l_current_forward_to_id :=
783: nvl(wf_engine.GetItemAttrNumber
784: (itemtype => p_item_type
785: ,itemkey => p_item_key
786: ,aname => 'FORWARD_TO_PERSON_ID'),
787: wf_engine.GetItemAttrNumber
783: nvl(wf_engine.GetItemAttrNumber
784: (itemtype => p_item_type
785: ,itemkey => p_item_key
786: ,aname => 'FORWARD_TO_PERSON_ID'),
787: wf_engine.GetItemAttrNumber
788: (itemtype => p_item_type
789: ,itemkey => p_item_key
790: ,aname => 'CREATOR_PERSON_ID'));
791:
790: ,aname => 'CREATOR_PERSON_ID'));
791:
792:
793: -- get the total number of additional approvers for this transaction
794: ln_addntl_approvers := NVL(wf_engine.GetItemAttrNumber
795: (itemtype => p_item_type
796: ,itemkey => p_item_key
797: ,aname => 'ADDITIONAL_APPROVERS_NUMBER'),
798: 0);
808: (p_item_type => p_item_type
809: ,p_item_key => p_item_key
810: ,p_name => 'CURRENT_APPROVER_INDEX');
811:
812: wf_engine.SetItemAttrNumber
813: (itemtype => p_item_type,
814: itemkey => p_item_key,
815: aname => 'CURRENT_APPROVER_INDEX',
816: avalue => NULL);
822:
823:
824:
825: -- get the current_approver_index
826: ln_current_approver_index := NVL(wf_engine.GetItemAttrNumber
827: (itemtype => p_item_type
828: ,itemkey => p_item_key
829: ,aname => 'CURRENT_APPROVER_INDEX'),
830: 0);
840: IF csr_wiav%notfound THEN
841: lv_exists := 'N';
842: ELSE
843: lv_exists := 'Y';
844: lv_isvalid := wf_engine.GetItemAttrText
845: (itemtype => p_item_type,
846: itemkey => p_item_key,
847: aname => lv_item_name);
848: lv_isvalid := NVL(lv_isvalid,' ');
855:
856:
857: IF lv_exists <>'N' AND lv_isvalid <>'DELETED' THEN
858: l_forward_to_person_id :=
859: wf_engine.GetItemAttrNumber
860: (itemtype => p_item_type,
861: itemkey => p_item_key,
862: aname => lv_item_name
863: );
864:
865: ELSE
866: -- get the last default approver index
867:
868: ln_last_default_approver_id := wf_engine.GetItemAttrNumber
869: (itemtype => p_item_type,
870: itemkey => p_item_key,
871: aname => 'LAST_DEFAULT_APPROVER');
872:
878: -- now the from column will show the last approver approved.
879: l_forward_to_person_id :=
880: hr_approval_custom.Get_Next_Approver
881: (p_person_id => NVL(ln_last_default_approver_id,
882: wf_engine.GetItemAttrNumber
883: (itemtype => p_item_type
884: ,itemkey => p_item_key
885: ,aname => 'CREATOR_PERSON_ID')));
886: -- set the last default approver id
884: ,itemkey => p_item_key
885: ,aname => 'CREATOR_PERSON_ID')));
886: -- set the last default approver id
887: -- 'LAST_DEFAULT_APPROVER'
888: wf_engine.SetItemAttrNumber
889: (itemtype => p_item_type,
890: itemkey => p_item_key,
891: aname => 'LAST_DEFAULT_APPROVER',
892: avalue => l_forward_to_person_id);
899: (p_item_type => p_item_type
900: ,p_item_key => p_item_key
901: ,p_name => 'CURRENT_DEF_APPR_INDEX');
902:
903: wf_engine.SetItemAttrNumber
904: (itemtype => p_item_type,
905: itemkey => p_item_key,
906: aname => 'CURRENT_DEF_APPR_INDEX',
907: avalue => 0);
906: aname => 'CURRENT_DEF_APPR_INDEX',
907: avalue => 0);
908: ELSE
909: ln_curr_def_appr_index :=
910: wf_engine.GetItemAttrNumber
911: (itemtype => p_item_type,
912: itemkey => p_item_key,
913: aname => 'CURRENT_DEF_APPR_INDEX'
914: );
913: aname => 'CURRENT_DEF_APPR_INDEX'
914: );
915: -- increment it and update the item attribute value
916: ln_curr_def_appr_index := ln_curr_def_appr_index + 1;
917: wf_engine.SetItemAttrNumber
918: (itemtype => p_item_type,
919: itemkey => p_item_key,
920: aname => 'CURRENT_DEF_APPR_INDEX',
921: avalue => ln_curr_def_appr_index);
924:
925: END IF;
926:
927: -- set the current_approver_index
928: wf_engine.SetItemAttrNumber (itemtype => p_item_type
929: ,itemkey => p_item_key
930: ,aname => 'CURRENT_APPROVER_INDEX'
931: ,avalue => (ln_current_approver_index + 1));
932:
1183:
1184: if g_debug then
1185: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1186: end if;
1187: if ( funmode = wf_engine.eng_run ) then
1188: -- HR_APR_CATEGORY_ATTR
1189: lv_current_approver_category :=wf_engine.GetItemAttrText(itemtype => p_item_type ,
1190: itemkey => p_item_key,
1191: aname => 'HR_APR_CATEGORY_ATTR',
1185: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1186: end if;
1187: if ( funmode = wf_engine.eng_run ) then
1188: -- HR_APR_CATEGORY_ATTR
1189: lv_current_approver_category :=wf_engine.GetItemAttrText(itemtype => p_item_type ,
1190: itemkey => p_item_key,
1191: aname => 'HR_APR_CATEGORY_ATTR',
1192: ignore_notfound=>true);
1193: -- default approvals
1221: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1222: end if;
1223:
1224: -- call the initialize code
1225: --HR_DYNAMIC_APPROVAL_WEB.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1226:
1227:
1228: -- check if we need to go through this cycle or completed
1229: HR_DYNAMIC_APPROVAL_WEB.CHECK_ONSUBMIT_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1225: --HR_DYNAMIC_APPROVAL_WEB.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1226:
1227:
1228: -- check if we need to go through this cycle or completed
1229: HR_DYNAMIC_APPROVAL_WEB.CHECK_ONSUBMIT_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1230:
1231: if(lv_result='COMPLETE:N') then
1232: HR_DYNAMIC_APPROVAL_WEB.GET_ONSUBMIT_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1233:
1228: -- check if we need to go through this cycle or completed
1229: HR_DYNAMIC_APPROVAL_WEB.CHECK_ONSUBMIT_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1230:
1231: if(lv_result='COMPLETE:N') then
1232: HR_DYNAMIC_APPROVAL_WEB.GET_ONSUBMIT_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1233:
1234: -- ONSUB_FWD_TO_USERNAME
1235: create_item_attrib_if_notexist(itemtype=>p_item_type,
1236: itemkey=>p_item_key,
1234: -- ONSUB_FWD_TO_USERNAME
1235: create_item_attrib_if_notexist(itemtype=>p_item_type,
1236: itemkey=>p_item_key,
1237: aname=>'HR_APR_NAME_ATTR',
1238: text_value=>wf_engine.GetItemAttrText(itemtype => p_item_type ,
1239: itemkey => p_item_key,
1240: aname => 'ONSUB_FWD_TO_USERNAME',
1241: ignore_notfound=>true),
1242: number_value=>null,
1268: ,text_value=>null
1269: ,number_value=>null,
1270: date_value=>null
1271: );
1272: wf_engine.SetItemAttrNumber
1273: (itemtype => p_item_type
1274: ,itemkey => p_item_key
1275: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR'
1276: ,avalue=>null);
1305: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1306: end if;
1307:
1308: -- fyiApproverCategory
1309: HR_DYNAMIC_APPROVAL_WEB.CHECK_ONAPPROVAL_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1310:
1311: if(lv_result='COMPLETE:N') then
1312:
1313: HR_DYNAMIC_APPROVAL_WEB.GET_ONAPPROVAL_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1309: HR_DYNAMIC_APPROVAL_WEB.CHECK_ONAPPROVAL_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1310:
1311: if(lv_result='COMPLETE:N') then
1312:
1313: HR_DYNAMIC_APPROVAL_WEB.GET_ONAPPROVAL_NOTIFIER(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
1314:
1315: -- ONAPPR_FWD_TO_USERNAME
1316:
1317: create_item_attrib_if_notexist(itemtype=>p_item_type,
1316:
1317: create_item_attrib_if_notexist(itemtype=>p_item_type,
1318: itemkey=>p_item_key,
1319: aname=>'HR_APR_NAME_ATTR',
1320: text_value=>wf_engine.GetItemAttrText(itemtype => p_item_type ,
1321: itemkey => p_item_key,
1322: aname => 'ONAPPR_FWD_TO_USERNAME',
1323: ignore_notfound=>true),
1324: number_value=>null,
1349: ,text_value=>null
1350: ,number_value=>null,
1351: date_value=>null
1352: );
1353: wf_engine.SetItemAttrNumber
1354: (itemtype => p_item_type
1355: ,itemkey => p_item_key
1356: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR'
1357: ,avalue=>null);
1405: if g_debug then
1406: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1407: end if;
1408:
1409: error_message_text := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1410: itemkey => p_item_key,
1411: aname => 'ERROR_MESSAGE_TEXT',
1412: ignore_notfound=>true);
1413:
1413:
1414:
1415: if(error_message_text is not null) then
1416:
1417: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',null);
1418: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',null);
1419: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',null);
1420:
1421: end if;
1414:
1415: if(error_message_text is not null) then
1416:
1417: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',null);
1418: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',null);
1419: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',null);
1420:
1421: end if;
1422:
1415: if(error_message_text is not null) then
1416:
1417: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',null);
1418: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',null);
1419: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',null);
1420:
1421: end if;
1422:
1423: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1419: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',null);
1420:
1421: end if;
1422:
1423: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1424: itemkey => p_item_key,
1425: aname => 'HR_AME_TRAN_TYPE_ATTR');
1426:
1427: if ( funmode = 'RUN' ) then
1459: result := 'COMPLETE:'||'N';
1460: return;
1461: end if;
1462:
1463: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1464: itemkey => p_item_key,
1465: aname => 'HR_AME_APP_ID_ATTR');
1466: c_application_id := nvl(c_application_id,800);
1467: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1463: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1464: itemkey => p_item_key,
1465: aname => 'HR_AME_APP_ID_ATTR');
1466: c_application_id := nvl(c_application_id,800);
1467: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1468: itemkey => p_item_key,
1469: aname => 'TRANSACTION_ID');
1470: if(c_transaction_type is not null) then
1471: begin
1585:
1586: if g_debug then
1587: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1588: end if;
1589: if ( funmode = wf_engine.eng_run ) then
1590: -- call PQH_SS_HISTORY.transfer_approval_to_history
1591: if g_debug then
1592: hr_utility.set_location('calling PQH_SS_HISTORY.transfer_approval_to_history ',2);
1593: hr_utility.set_location('p_item_type:'|| p_item_type,3);
1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;
1623: begin
1624:
1625: -- FORWARD_TO_PERSON_ID
1626: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',true);
1627:
1628: if(lv_role_orig_sys_id is not null) then
1629: -- need to revisit with role based support in SSHR transaction
1630: lv_role_orig_system := nvl( wf_engine.GetItemAttrText
1626: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',true);
1627:
1628: if(lv_role_orig_sys_id is not null) then
1629: -- need to revisit with role based support in SSHR transaction
1630: lv_role_orig_system := nvl( wf_engine.GetItemAttrText
1631: (itemtype => p_item_type
1632: ,itemkey => p_item_key
1633: ,aname => 'FORWARD_TO_ORIG_SYS_ATTR'
1634: ,ignore_notfound=>true),'PER');
1675:
1676: if g_debug then
1677: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1678: end if;
1679: if ( funmode = wf_engine.eng_run ) then
1680: -- check if it is AME or custom approvals
1681: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1682: itemkey => p_item_key,
1683: aname => 'HR_AME_APP_ID_ATTR'),800);
1677: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1678: end if;
1679: if ( funmode = wf_engine.eng_run ) then
1680: -- check if it is AME or custom approvals
1681: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1682: itemkey => p_item_key,
1683: aname => 'HR_AME_APP_ID_ATTR'),800);
1684:
1685: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1681: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1682: itemkey => p_item_key,
1683: aname => 'HR_AME_APP_ID_ATTR'),800);
1684:
1685: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1686: itemkey => p_item_key,
1687: aname => 'TRANSACTION_ID');
1688:
1689: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1685: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1686: itemkey => p_item_key,
1687: aname => 'TRANSACTION_ID');
1688:
1689: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1690: itemkey => p_item_key,
1691: aname => 'HR_AME_TRAN_TYPE_ATTR');
1692: forwardToRoleReInit(p_item_type,p_item_key);
1693: if(c_transaction_type is not null) then
1691: aname => 'HR_AME_TRAN_TYPE_ATTR');
1692: forwardToRoleReInit(p_item_type,p_item_key);
1693: if(c_transaction_type is not null) then
1694: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
1695: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
1696: ,itemkey => p_item_key
1697: ,aname => 'FORWARD_TO_USERNAME');
1698: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => p_item_type ,
1699: itemkey => p_item_key,
1694: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
1695: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
1696: ,itemkey => p_item_key
1697: ,aname => 'FORWARD_TO_USERNAME');
1698: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => p_item_type ,
1699: itemkey => p_item_key,
1700: aname => 'RETURN_TO_USERNAME'));
1701: if g_debug then
1702: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
1724: if g_debug then
1725: hr_utility.set_location('Error in updateApproveStatus SQLERRM' ||' '||to_char(SQLCODE),10);
1726: end if;
1727: hr_utility.trace('ORCL error '||SQLERRM);
1728: result := wf_engine.eng_trans_default;
1729: return;
1730: end;
1731:
1732: if g_debug then
1732: if g_debug then
1733: hr_utility.set_location('returned from calling ame_api2.updateApprovalStatus2', 8);
1734: end if;
1735:
1736: result := wf_engine.eng_trans_default;
1737: else
1738: null;
1739: end if;
1740: pqh_ss_workflow.set_txn_approve_status(p_item_type,p_item_key,p_act_id,funmode,result);
1779: end if;
1780:
1781: -- get the current approver category
1782: -- HR_APR_CATEGORY_ATTR
1783: lv_current_approver_category:= wf_engine.GetItemAttrText(itemtype => p_item_type ,
1784: itemkey => p_item_key,
1785: aname => 'HR_APR_CATEGORY_ATTR',
1786: ignore_notfound=>true);
1787: --HR_APR_SUB_LST_ORD_NUM_ATTR
1784: itemkey => p_item_key,
1785: aname => 'HR_APR_CATEGORY_ATTR',
1786: ignore_notfound=>true);
1787: --HR_APR_SUB_LST_ORD_NUM_ATTR
1788: ln_sublist_order_number:=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1789: itemkey => p_item_key,
1790: aname => 'HR_APR_SUB_LST_ORD_NUM_ATTR',
1791: ignore_notfound=>true);
1792: -- default approvals
1837:
1838: if g_debug then
1839: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1840: end if;
1841: if ( funmode = wf_engine.eng_run ) then
1842: -- check if it is AME or custom approvals
1843: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1844: itemkey => p_item_key,
1845: aname => 'HR_AME_APP_ID_ATTR'),800);
1839: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1840: end if;
1841: if ( funmode = wf_engine.eng_run ) then
1842: -- check if it is AME or custom approvals
1843: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1844: itemkey => p_item_key,
1845: aname => 'HR_AME_APP_ID_ATTR'),800);
1846:
1847: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1843: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1844: itemkey => p_item_key,
1845: aname => 'HR_AME_APP_ID_ATTR'),800);
1846:
1847: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1848: itemkey => p_item_key,
1849: aname => 'TRANSACTION_ID');
1850:
1851: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1847: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1848: itemkey => p_item_key,
1849: aname => 'TRANSACTION_ID');
1850:
1851: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1852: itemkey => p_item_key,
1853: aname => 'HR_AME_TRAN_TYPE_ATTR');
1854: if(c_transaction_type is not null) then
1855: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
1852: itemkey => p_item_key,
1853: aname => 'HR_AME_TRAN_TYPE_ATTR');
1854: if(c_transaction_type is not null) then
1855: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
1856: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
1857: ,itemkey => p_item_key
1858: ,aname => 'HR_APR_NAME_ATTR');
1859: l_curr_fwd_to_orig_system_id :=wf_engine.getItemAttrNumber
1860: (itemtype => p_item_type
1855: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
1856: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
1857: ,itemkey => p_item_key
1858: ,aname => 'HR_APR_NAME_ATTR');
1859: l_curr_fwd_to_orig_system_id :=wf_engine.getItemAttrNumber
1860: (itemtype => p_item_type
1861: ,itemkey => p_item_key
1862: ,aname => 'HR_APR_ORIG_SYSTEM_ID_ATTR');
1863: if(l_curr_fwd_to_orig_system_id is not null) then
1875: transactionTypeIn =>c_transaction_type,
1876: transactionIdIn=>c_transaction_id,
1877: approvalStatusIn =>ame_util.notifiedStatus,
1878: approverNameIn =>l_current_forward_to_username,
1879: itemClassIn => wf_engine.GetItemAttrText(itemtype => p_item_type ,
1880: itemkey => p_item_key,
1881: aname => 'HR_APR_ITEM_CLASS_ATTR'),
1882: -- HR_APR_ITEM_ID_ATTR
1883: itemIdIn =>wf_engine.GetItemAttrText(itemtype => p_item_type ,
1879: itemClassIn => wf_engine.GetItemAttrText(itemtype => p_item_type ,
1880: itemkey => p_item_key,
1881: aname => 'HR_APR_ITEM_CLASS_ATTR'),
1882: -- HR_APR_ITEM_ID_ATTR
1883: itemIdIn =>wf_engine.GetItemAttrText(itemtype => p_item_type ,
1884: itemkey => p_item_key,
1885: aname => 'HR_APR_ITEM_ID_ATTR'),
1886: -- HR_APR_ACTION_TYPE_ID_ATTR
1887: actionTypeIdIn=> wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1883: itemIdIn =>wf_engine.GetItemAttrText(itemtype => p_item_type ,
1884: itemkey => p_item_key,
1885: aname => 'HR_APR_ITEM_ID_ATTR'),
1886: -- HR_APR_ACTION_TYPE_ID_ATTR
1887: actionTypeIdIn=> wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1888: itemkey => p_item_key,
1889: aname => 'HR_APR_ACTION_TYPE_ID_ATTR'),
1890: -- HR_APR_GRPORCHN_ID_ATTR
1891: groupOrChainIdIn =>wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1887: actionTypeIdIn=> wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1888: itemkey => p_item_key,
1889: aname => 'HR_APR_ACTION_TYPE_ID_ATTR'),
1890: -- HR_APR_GRPORCHN_ID_ATTR
1891: groupOrChainIdIn =>wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1892: itemkey => p_item_key,
1893: aname => 'HR_APR_GRPORCHN_ID_ATTR'),
1894: occurrenceIn =>null,
1895: forwardeeIn =>ame_util.emptyApproverRecord2,
1894: occurrenceIn =>null,
1895: forwardeeIn =>ame_util.emptyApproverRecord2,
1896: updateItemIn =>false);
1897: end if;
1898: result := wf_engine.eng_trans_default;
1899: else
1900: null;
1901: end if;
1902: end if;
1936:
1937: if g_debug then
1938: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1939: end if;
1940: if ( funmode = wf_engine.eng_run ) then
1941: -- check if it is AME or custom approvals
1942: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1943: itemkey => p_item_key,
1944: aname => 'HR_AME_APP_ID_ATTR'),800);
1938: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
1939: end if;
1940: if ( funmode = wf_engine.eng_run ) then
1941: -- check if it is AME or custom approvals
1942: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1943: itemkey => p_item_key,
1944: aname => 'HR_AME_APP_ID_ATTR'),800);
1945:
1946: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1942: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1943: itemkey => p_item_key,
1944: aname => 'HR_AME_APP_ID_ATTR'),800);
1945:
1946: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1947: itemkey => p_item_key,
1948: aname => 'TRANSACTION_ID');
1949:
1950: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1946: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
1947: itemkey => p_item_key,
1948: aname => 'TRANSACTION_ID');
1949:
1950: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
1951: itemkey => p_item_key,
1952: aname => 'HR_AME_TRAN_TYPE_ATTR');
1953: if(c_transaction_type is not null) then
1954: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
1951: itemkey => p_item_key,
1952: aname => 'HR_AME_TRAN_TYPE_ATTR');
1953: if(c_transaction_type is not null) then
1954: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,15);
1955: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
1956: ,itemkey => p_item_key
1957: ,aname => 'FORWARD_TO_USERNAME');
1958: if g_debug then
1959: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 2);
1976: occurrenceIn =>null,
1977: forwardeeIn =>ame_util.emptyApproverRecord2,
1978: updateItemIn =>false);
1979:
1980: result := wf_engine.eng_trans_default;
1981: else
1982: result := wf_engine.eng_trans_default;
1983: end if;
1984: end if;
1978: updateItemIn =>false);
1979:
1980: result := wf_engine.eng_trans_default;
1981: else
1982: result := wf_engine.eng_trans_default;
1983: end if;
1984: end if;
1985:
1986: if (g_debug ) then
1987: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
1988: end if;
1989: exception
1990: when others then
1991: result := wf_engine.eng_trans_default;
1992: return;
1993: end updateNoResponseStatus;
1994:
1995: procedure setRespondedUserContext( p_item_type in varchar2,
2013: create_item_attrib_if_notexist(itemtype=>p_item_type,
2014: itemkey=>p_item_key,
2015: aname=>'HR_CONTEXT_NID_ATTR',
2016: text_value=>null,
2017: number_value=>wf_engine.context_nid,
2018: date_value=>null);
2019: create_item_attrib_if_notexist(itemtype=>p_item_type,
2020: itemkey=>p_item_key,
2021: aname=>'HR_CONTEXT_USER_ATTR',
2018: date_value=>null);
2019: create_item_attrib_if_notexist(itemtype=>p_item_type,
2020: itemkey=>p_item_key,
2021: aname=>'HR_CONTEXT_USER_ATTR',
2022: text_value=>wf_engine.context_user,
2023: number_value=>null,
2024: date_value=>null);
2025: create_item_attrib_if_notexist(itemtype=>p_item_type,
2026: itemkey=>p_item_key,
2024: date_value=>null);
2025: create_item_attrib_if_notexist(itemtype=>p_item_type,
2026: itemkey=>p_item_key,
2027: aname=>'HR_CONTEXT_RECIPIENT_ROLE_ATTR',
2028: text_value=>wf_engine.context_recipient_role,
2029: number_value=>null,
2030: date_value=>null);
2031:
2032: create_item_attrib_if_notexist(itemtype=>p_item_type,
2031:
2032: create_item_attrib_if_notexist(itemtype=>p_item_type,
2033: itemkey=>p_item_key,
2034: aname=>'HR_CONTEXT_ORIG_RECIPIENT_ATTR',
2035: text_value=>wf_engine.context_original_recipient,
2036: number_value=>null,
2037: date_value=>null);
2038:
2039: create_item_attrib_if_notexist(itemtype=>p_item_type,
2038:
2039: create_item_attrib_if_notexist(itemtype=>p_item_type,
2040: itemkey=>p_item_key,
2041: aname=>'HR_CONTEXT_FROM_ROLE_ATTR',
2042: text_value=>wf_engine.context_from_role,
2043: number_value=>null,
2044: date_value=>null);
2045: create_item_attrib_if_notexist(itemtype=>p_item_type,
2046: itemkey=>p_item_key,
2044: date_value=>null);
2045: create_item_attrib_if_notexist(itemtype=>p_item_type,
2046: itemkey=>p_item_key,
2047: aname=>'HR_CONTEXT_NEW_ROLE_ATTR',
2048: text_value=>wf_engine.context_new_role,
2049: number_value=>null,
2050: date_value=>null);
2051: create_item_attrib_if_notexist(itemtype=>p_item_type,
2052: itemkey=>p_item_key,
2050: date_value=>null);
2051: create_item_attrib_if_notexist(itemtype=>p_item_type,
2052: itemkey=>p_item_key,
2053: aname=>'HR_CONTEXT_MORE_INFO_ROLE_ATTR',
2054: text_value=>wf_engine.context_more_info_role,
2055: number_value=>null,
2056: date_value=>null);
2057: create_item_attrib_if_notexist(itemtype=>p_item_type,
2058: itemkey=>p_item_key,
2056: date_value=>null);
2057: create_item_attrib_if_notexist(itemtype=>p_item_type,
2058: itemkey=>p_item_key,
2059: aname=>'HR_CONTEXT_USER_KEY_ATTR',
2060: text_value=>wf_engine.context_user_key,
2061: number_value=>null,
2062: date_value=>null);
2063:
2064: create_item_attrib_if_notexist(itemtype=>p_item_type,
2063:
2064: create_item_attrib_if_notexist(itemtype=>p_item_type,
2065: itemkey=>p_item_key,
2066: aname=>'HR_CONTEXT_PROXY_ATTR',
2067: text_value=>wf_engine.context_proxy,
2068: number_value=>null,
2069: date_value=>null);
2070:
2071: result := 'COMPLETE';
2112:
2113: if g_debug then
2114: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2115: end if;
2116: if ( funmode = wf_engine.eng_run ) then
2117: -- Creating attribute to check the new transaction
2118: create_item_attrib_if_notexist(itemtype => p_item_type
2119: ,itemkey => p_item_key
2120: ,aname => 'HR_NEW_TRANSACTION'
2123: date_value=>null
2124: );
2125: -- check if the transaction needs to be submitted for approval
2126: -- get the transaction status
2127: lv_transaction_status:=wf_engine.getItemAttrText(itemtype=> p_item_type,
2128: itemkey => p_item_key,
2129: aname => 'TRAN_SUBMIT');
2130: if(lv_transaction_status<>'Y') then
2131: -- result := 'COMPLETE:'||'E';
2132: --return;
2133: raise g_transaction_status_invalid;
2134: end if;
2135: if(lv_transaction_status='Y') then
2136: lv_approval_required:= wf_engine.GetItemAttrText(itemtype => p_item_type,
2137: itemkey => p_item_key,
2138: aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
2139: lv_approval_required := nvl(lv_approval_required,'N0');
2140: if(lv_approval_required in ('YES_DYNAMIC','YES','Y','YD')) then
2149: end if;
2150: -- PQH_SS_HISTORY.transfer_submit_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2151: -- use the new history API's
2152: -- add the code plugin transfer history
2153: c_transaction_id := wf_engine.getitemattrnumber(p_item_type,p_item_key,'TRANSACTION_ID');
2154: lv_comments := wf_engine.getitemattrtext(p_item_type,p_item_key,'APPROVAL_COMMENT_COPY');
2155: hr_trans_history_api.archive_submit(c_transaction_id,
2156: null,
2157: fnd_global.user_name,
2150: -- PQH_SS_HISTORY.transfer_submit_to_history(p_item_type,p_item_key,p_act_id,funmode,result);
2151: -- use the new history API's
2152: -- add the code plugin transfer history
2153: c_transaction_id := wf_engine.getitemattrnumber(p_item_type,p_item_key,'TRANSACTION_ID');
2154: lv_comments := wf_engine.getitemattrtext(p_item_type,p_item_key,'APPROVAL_COMMENT_COPY');
2155: hr_trans_history_api.archive_submit(c_transaction_id,
2156: null,
2157: fnd_global.user_name,
2158: lv_comments);
2163: hr_utility.set_location('p_item_type:'|| p_item_type, 6);
2164: hr_utility.set_location('p_item_key:'|| p_item_key, 7);
2165: end if;
2166:
2167: HR_DYNAMIC_APPROVAL_WEB.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,null,wf_engine.eng_run,lv_result);
2168: HR_APPROVAL_WF.INITIALIZE_ITEM_ATTRIBUTES(p_item_type,p_item_key,p_act_id,funmode,result);
2169:
2170: -- PQH_SS_WORKFLOW.set_image_source
2171: if g_debug then
2276: begin
2277: select text_value
2278: into lv_result_code
2279: from wf_notification_attributes
2280: where notification_id=wf_engine.context_nid
2281: and name='RESULT';
2282:
2283: if(funmode='RESPOND' and lv_result_code='RESUBMIT') Then
2284:
2281: and name='RESULT';
2282:
2283: if(funmode='RESPOND' and lv_result_code='RESUBMIT') Then
2284:
2285: WF_ENGINE.SetItemAttrText(p_item_type,p_item_key,'WF_NOTE',wf_engine.GetItemAttrText( p_item_type
2286: ,p_item_key
2287: ,'APPROVAL_COMMENT_COPY'));
2288:
2289: end if;
2343: l_new_orig_system varchar2(30);
2344: l_new_fwd_display_name varchar2(360);
2345:
2346: cursor get_person_info is
2347: select orig_system,orig_system_id,display_name from wf_roles where name = wf_engine.context_new_role;
2348:
2349: /* cursor get_name_info is
2350: select last_name,first_name from per_all_people_f where
2351: person_id = l_new_fwd_person_id;*/
2356:
2357: if ( funmode = 'TRANSFER' ) then
2358: -- TRANSFER - When a notification recipient transfers the notification.
2359: -- check if it is AME or custom approvals
2360: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2361: itemkey => p_item_key,
2362: aname => 'HR_AME_APP_ID_ATTR'),800);
2363:
2364: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2360: c_application_id :=nvl(wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2361: itemkey => p_item_key,
2362: aname => 'HR_AME_APP_ID_ATTR'),800);
2363:
2364: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2365: itemkey => p_item_key,
2366: aname => 'TRANSACTION_ID');
2367:
2368: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2364: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2365: itemkey => p_item_key,
2366: aname => 'TRANSACTION_ID');
2367:
2368: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2369: itemkey => p_item_key,
2370: aname => 'HR_AME_TRAN_TYPE_ATTR');
2371:
2372: if(c_transaction_type is not null) then
2370: aname => 'HR_AME_TRAN_TYPE_ATTR');
2371:
2372: if(c_transaction_type is not null) then
2373: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
2374: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
2375: ,itemkey => p_item_key
2376: ,aname => 'FORWARD_TO_USERNAME');
2377: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => p_item_type ,
2378: itemkey => p_item_key,
2373: hr_utility.set_location('In(if ( if(c_transaction_type is not null))): '|| c_proc,2);
2374: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => p_item_type
2375: ,itemkey => p_item_key
2376: ,aname => 'FORWARD_TO_USERNAME');
2377: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => p_item_type ,
2378: itemkey => p_item_key,
2379: aname => 'RETURN_TO_USERNAME'));
2380: if g_debug then
2381: hr_utility.set_location('calling ame_api2.updateApprovalStatus2', 3);
2382: hr_utility.set_location('c_application_id:'|| c_application_id, 4);
2383: hr_utility.set_location('c_transaction_type:'|| c_transaction_type, 5);
2384: hr_utility.set_location('approvalStatusIn:'|| ame_util.approvedStatus, 6);
2385: hr_utility.set_location('approverNameIn:'|| l_current_forward_to_username, 7);
2386: hr_utility.set_location('new approver:'|| wf_engine.context_new_role, 7);
2387: end if;
2388:
2389: begin
2390:
2391: open get_person_info;
2392: fetch get_person_info into l_new_orig_system,l_new_fwd_person_id,l_new_fwd_display_name;
2393: CLOSe get_person_info;
2394:
2395: rec_forwardee.name:= wf_engine.context_new_role;
2396: rec_forwardee.orig_system :=l_new_orig_system;
2397: rec_forwardee.orig_system_id :=l_new_fwd_person_id;
2398: rec_forwardee.display_name :=l_new_fwd_display_name;
2399: --rec_forwardee.api_insertion:='Y';
2416: updateItemIn =>false);
2417:
2418: --reset wf attributes
2419:
2420: wf_engine.setItemAttrNumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',rec_forwardee.orig_system_id);
2421: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USERNAME',wf_engine.context_new_role);
2422: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
2423:
2424: if g_debug then
2417:
2418: --reset wf attributes
2419:
2420: wf_engine.setItemAttrNumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',rec_forwardee.orig_system_id);
2421: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USERNAME',wf_engine.context_new_role);
2422: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
2423:
2424: if g_debug then
2425: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
2418: --reset wf attributes
2419:
2420: wf_engine.setItemAttrNumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',rec_forwardee.orig_system_id);
2421: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_USERNAME',wf_engine.context_new_role);
2422: wf_engine.setItemAttrText(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',wf_directory.GetRoleDisplayName(wf_engine.context_new_role));
2423:
2424: if g_debug then
2425: hr_utility.set_location('calling ame_api2.getNextApprovers4 ',4);
2426: hr_utility.set_location('c_application_id:'||c_application_id,5);
2453: end if;
2454:
2455:
2456:
2457: result := wf_engine.eng_trans_default;
2458: else
2459: null;
2460: end if;
2461:
2510:
2511: -- bug 5414392
2512:
2513: if ( funmode = 'TRANSFER' ) then
2514: lv_new_transaction := wf_engine.getitemattrtext(p_item_type,
2515: p_item_key,
2516: 'HR_NEW_TRANSACTION',true);
2517:
2518: if( INSTR(lv_new_transaction,'APPROVETWICE') > 0) then
2563:
2564: IF g_debug THEN
2565: hr_utility.set_location('Entering:'||l_proc, 1);
2566: END IF;
2567: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2568: itemkey => p_item_key,
2569: aname => 'TRANSACTION_ID',
2570: ignore_notfound=>true);
2571: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2567: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2568: itemkey => p_item_key,
2569: aname => 'TRANSACTION_ID',
2570: ignore_notfound=>true);
2571: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2572: itemkey => p_item_key,
2573: aname => 'HR_AME_TRAN_TYPE_ATTR',
2574: ignore_notfound=>true);
2575: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2571: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2572: itemkey => p_item_key,
2573: aname => 'HR_AME_TRAN_TYPE_ATTR',
2574: ignore_notfound=>true);
2575: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2576: itemkey => p_item_key,
2577: aname => 'HR_AME_APP_ID_ATTR',
2578: ignore_notfound=>true);
2579: c_application_id := nvl(c_application_id,800);
2590: transactionTypeIn =>c_transaction_type,
2591: transactionIdIn => c_transaction_id,
2592: approvalProcessCompleteYNOut =>c_approvalprocesscompleteynout,
2593: approversOut =>c_all_approvers);
2594: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2595: itemkey => p_item_key,
2596: aname => 'CREATOR_PERSON_USERNAME');
2597: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2598: itemkey => p_item_key,
2593: approversOut =>c_all_approvers);
2594: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2595: itemkey => p_item_key,
2596: aname => 'CREATOR_PERSON_USERNAME');
2597: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2598: itemkey => p_item_key,
2599: aname => 'RETURN_TO_USERNAME',
2600: ignore_notfound=>true);
2601: IF ( c_return_user IS NULL OR c_creator_user = c_return_user ) THEN
2675: -- reset the AME approval state
2676: reset_ame_to_rfc_state(p_item_type,p_item_key);
2677:
2678: -- reset the item attrtibutes
2679: c_return_user:= wf_engine.GetItemAttrText(itemtype => p_item_type ,
2680: itemkey => p_item_key,
2681: aname => 'RETURN_TO_USERNAME',
2682: ignore_notfound=>true);
2683: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2679: c_return_user:= wf_engine.GetItemAttrText(itemtype => p_item_type ,
2680: itemkey => p_item_key,
2681: aname => 'RETURN_TO_USERNAME',
2682: ignore_notfound=>true);
2683: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2684: itemkey => p_item_key,
2685: aname => 'CREATOR_PERSON_USERNAME');
2686:
2687: c_return_user := nvl(c_return_user,c_creator_user);
2688:
2689: -- get the return to user orig system and sys id
2690: wf_directory.GetRoleInfo2(c_return_user,c_return_user_role_info_tbl);
2691:
2692: l_curr_approver_role :=wf_engine.GetItemAttrText(itemtype => p_item_type ,
2693: itemkey => p_item_key,
2694: aname => 'FORWARD_TO_USERNAME',
2695: ignore_notfound=>true);
2696: ---- get the current approver orig system and sys id
2775: * CAUTION: IF this procedure is invoked from somewhere else (apart from RFC) then this needs
2776: * to be checked for that condition too.
2777: */
2778:
2779: l_approvalProcessVersion := wf_engine.GetItemAttrText(
2780: itemtype => p_item_Type,
2781: itemkey => p_item_Key,
2782: aname => 'HR_APPROVAL_PRC_VERSION',
2783: ignore_notfound=>true);
2782: aname => 'HR_APPROVAL_PRC_VERSION',
2783: ignore_notfound=>true);
2784:
2785: IF ( NVL(l_approvalProcessversion,'X') <> 'V5' OR
2786: wf_engine.GetItemAttrText(
2787: itemtype => p_item_Type, itemkey => p_item_Key,
2788: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NOT NULL) THEN
2789:
2790: -- CURRENT_APPROVER_INDEX
2853: g_debug := hr_utility.debug_enabled;
2854: if g_debug then
2855: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2856: end if;
2857: if ( funmode = wf_engine.eng_run ) then
2858:
2859: PQH_SS_WORKFLOW.set_txn_rfc_status(p_item_type,p_item_key,p_act_id,funmode,result);
2860: -- fix for bug 4454439
2861: begin
2874: -- HR_CUSTOM_RETURN_FOR_CORR
2875: if g_debug then
2876: hr_utility.set_location('checking product specific custom RFC',2);
2877: end if;
2878: lv_customRFC:=wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CUSTOM_RETURN_FOR_CORR',true);
2879: lv_customRFC:= nvl(lv_customRFC,'N');
2880: if g_debug then
2881: hr_utility.set_location('lv_customRFC:'||lv_customRFC,3);
2882: end if;
2882: end if;
2883:
2884: if(lv_customRFC='Y') then
2885: -- no more processing return to delete the transaction
2886: result := wf_engine.eng_completed||':N';
2887: return;
2888: end if;
2889:
2890: -- call PQH_SS_HISTORY.transfer_approval_to_history
2918: --
2919: begin
2920: -- finally see if we have any module specific call backs
2921: -- 'HR_RFC_CB_ATTR'
2922: lv_queryProcedure := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_RFC_CB_ATTR',true);
2923:
2924: if(lv_queryProcedure is not null or lv_queryProcedure<>'') then
2925:
2926: if g_debug then
2953: end;
2954:
2955: -- check if the RFC is to Initiator or Approver
2956: -- CREATOR_PERSON_USERNAME
2957: lv_creatorUserName:=wf_engine.getitemattrtext(p_item_type,p_item_key,'CREATOR_PERSON_USERNAME',true);
2958: -- RETURN_TO_USERNAME
2959: lv_rfcUserName:=wf_engine.getitemattrtext(p_item_type,p_item_key,'RETURN_TO_USERNAME',true);
2960: -- Compare
2961:
2955: -- check if the RFC is to Initiator or Approver
2956: -- CREATOR_PERSON_USERNAME
2957: lv_creatorUserName:=wf_engine.getitemattrtext(p_item_type,p_item_key,'CREATOR_PERSON_USERNAME',true);
2958: -- RETURN_TO_USERNAME
2959: lv_rfcUserName:=wf_engine.getitemattrtext(p_item_type,p_item_key,'RETURN_TO_USERNAME',true);
2960: -- Compare
2961:
2962: if (lv_creatorUserName is null or lv_rfcUserName is null) then
2963: result := wf_engine.eng_completed||':YES_APPROVER';
2959: lv_rfcUserName:=wf_engine.getitemattrtext(p_item_type,p_item_key,'RETURN_TO_USERNAME',true);
2960: -- Compare
2961:
2962: if (lv_creatorUserName is null or lv_rfcUserName is null) then
2963: result := wf_engine.eng_completed||':YES_APPROVER';
2964: elsif (lv_creatorUserName < lv_rfcUserName) then
2965: result := wf_engine.eng_completed||':YES_APPROVER';
2966: elsif (lv_creatorUserName > lv_rfcUserName) then
2967: result := wf_engine.eng_completed||':YES_APPROVER';
2961:
2962: if (lv_creatorUserName is null or lv_rfcUserName is null) then
2963: result := wf_engine.eng_completed||':YES_APPROVER';
2964: elsif (lv_creatorUserName < lv_rfcUserName) then
2965: result := wf_engine.eng_completed||':YES_APPROVER';
2966: elsif (lv_creatorUserName > lv_rfcUserName) then
2967: result := wf_engine.eng_completed||':YES_APPROVER';
2968: elsif (lv_creatorUserName = lv_rfcUserName) then
2969: result := wf_engine.eng_completed||':YES_INIT';
2963: result := wf_engine.eng_completed||':YES_APPROVER';
2964: elsif (lv_creatorUserName < lv_rfcUserName) then
2965: result := wf_engine.eng_completed||':YES_APPROVER';
2966: elsif (lv_creatorUserName > lv_rfcUserName) then
2967: result := wf_engine.eng_completed||':YES_APPROVER';
2968: elsif (lv_creatorUserName = lv_rfcUserName) then
2969: result := wf_engine.eng_completed||':YES_INIT';
2970: end if;
2971:
2965: result := wf_engine.eng_completed||':YES_APPROVER';
2966: elsif (lv_creatorUserName > lv_rfcUserName) then
2967: result := wf_engine.eng_completed||':YES_APPROVER';
2968: elsif (lv_creatorUserName = lv_rfcUserName) then
2969: result := wf_engine.eng_completed||':YES_INIT';
2970: end if;
2971:
2972: if g_debug then
2973: hr_utility.set_location('leaving with resultcode :'|| result,9);
3280: date_value =>null );
3281:
3282: -- Set the notes for RFC notification.
3283: -- NOTE_FROM_APPR
3284: wf_engine.setItemAttrText (
3285: itemtype => p_item_type
3286: ,itemkey => p_item_Key
3287: ,aname => 'NOTE_FROM_APPR'
3288: ,avalue => p_rfc_comments );
3285: itemtype => p_item_type
3286: ,itemkey => p_item_Key
3287: ,aname => 'NOTE_FROM_APPR'
3288: ,avalue => p_rfc_comments );
3289: wf_engine.setItemAttrText (
3290: itemtype => p_item_type
3291: ,itemkey => p_item_Key
3292: ,aname => 'WF_NOTE'
3293: ,avalue => null );
3353: ,aname => '#FROM_ROLE'
3354: ,avalue => fnd_global.user_name );
3355: -- processing logic for non AME
3356: begin
3357: IF (wf_engine.GetItemAttrText(itemtype => p_item_Type ,
3358: itemkey => p_item_key,
3359: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NULL) THEN
3360: --
3361: -- set the attribute value to null
3358: itemkey => p_item_key,
3359: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NULL) THEN
3360: --
3361: -- set the attribute value to null
3362: wf_engine.SetItemAttrNumber(
3363: itemtype => p_item_Type ,
3364: itemkey => p_item_key,
3365: aname => 'CURRENT_APPROVER_INDEX',
3366: avalue => p_approverIndex);
3412:
3413: CLOSE cur_add_appr;
3414:
3415: IF ( l_lastDefaultApprover IS NOT NULL ) THEN
3416: wf_engine.SetItemAttrNumber(
3417: itemtype => p_item_Type ,
3418: itemkey => p_item_key,
3419: aname => 'LAST_DEFAULT_APPROVER',
3420: avalue => l_lastDefaultApprover);
3459: null;
3460: end;
3461:
3462:
3463: lv_creator_role := wf_engine.getitemattrtext(lv_item_type,
3464: lv_item_key,
3465: 'CREATOR_PERSON_USERNAME');
3466: -- get the orig sys info
3467: wf_directory.getroleorigsysinfo(lv_creator_role,
3468: lv_creator_orig_system,
3469: lv_creator_orig_sys_id);
3470:
3471: handleRFCAction(p_approval_notification_id =>p_approval_notification_id,
3472: p_transaction_id =>wf_engine.getitemattrnumber
3473: (lv_item_type,
3474: lv_item_key,
3475: 'TRANSACTION_ID'),
3476: p_item_type =>lv_item_type,
3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3493: begin
3494:
3495: -- CREATOR_PERSON_ID
3496: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);
3497:
3498: if(lv_role_orig_sys_id is not null) then
3499: -- need to revisit with role based support in SSHR transaction
3500: lv_role_orig_system := 'PER';
3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3537: begin
3538:
3539: -- CURRENT_PERSON_ID
3540: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);
3541:
3542: if(lv_role_orig_sys_id is not null) then
3543: -- need to revisit with role based support in SSHR transaction
3544: lv_role_orig_system := 'PER';
3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3569: begin
3570:
3571: -- FORWARD_FROM_PERSON_ID
3572: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_FROM_PERSON_ID',true);
3573:
3574: if(lv_role_orig_sys_id is not null) then
3575: -- need to revisit with role based support in SSHR transaction
3576: lv_role_orig_system := nvl( wf_engine.GetItemAttrText
3572: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_FROM_PERSON_ID',true);
3573:
3574: if(lv_role_orig_sys_id is not null) then
3575: -- need to revisit with role based support in SSHR transaction
3576: lv_role_orig_system := nvl( wf_engine.GetItemAttrText
3577: (itemtype => p_item_type
3578: ,itemkey => p_item_key
3579: ,aname => 'FORWARD_FROM_ORIG_SYS_ATTR'
3580: ,ignore_notfound=>true),'PER');
3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3607: begin
3608:
3609: -- RETURN_TO_USER_ORIG_SYS_ID
3610: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'RETURN_TO_USER_ORIG_SYS_ID',true);
3611:
3612: if(lv_role_orig_sys_id is not null) then
3613: -- need to revisit with role based support in SSHR transaction
3614: lv_role_orig_system := wf_engine.GetItemAttrText
3610: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'RETURN_TO_USER_ORIG_SYS_ID',true);
3611:
3612: if(lv_role_orig_sys_id is not null) then
3613: -- need to revisit with role based support in SSHR transaction
3614: lv_role_orig_system := wf_engine.GetItemAttrText
3615: (itemtype => p_item_type
3616: ,itemkey => p_item_key
3617: ,aname => 'RETURN_TO_USER_ORIG_SYS'
3618: ,ignore_notfound=>true);
3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;
3649: begin
3650:
3651: -- get the appraisal id
3652: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_item_type ,
3653: itemkey => p_item_key ,
3654: aname => 'APPRAISAL_ID',
3655: ignore_notfound=>true);
3656:
3807: --local variables
3808:
3809: begin
3810: -- Do nothing in cancel or timeout mode
3811: if (funmode <> wf_engine.eng_run) then
3812: result := wf_engine.eng_null;
3813: return;
3814: end if;
3815: -- set the item attribute value with the current activity id
3808:
3809: begin
3810: -- Do nothing in cancel or timeout mode
3811: if (funmode <> wf_engine.eng_run) then
3812: result := wf_engine.eng_null;
3813: return;
3814: end if;
3815: -- set the item attribute value with the current activity id
3816: -- this will be used when the notification is sent.
4080: end;
4081: end if;
4082:
4083: -- Create the Workflow Process
4084: wf_engine.CreateProcess
4085: (itemtype => lr_transaction_rec.item_type
4086: ,itemkey => p_item_key
4087: ,process => lr_transaction_rec.process_name);
4088:
4089: -- check the process status before setting
4090: -- other mandatory attributes
4091: -- check the state of the workflow
4092: -- we need to check if the flow is in error state or not
4093: wf_engine.iteminfo(lr_transaction_rec.item_type,
4094: p_item_key,
4095: p_status,
4096: lv_result,
4097: lv_errorActid,
4148: l_current_person_name := getpersonnamefromid(lr_transaction_rec.creator_person_id);
4149: end if;
4150: l_current_person_name := l_current_person_name||'('||lr_transaction_rec.api_addtnl_info||')';
4151:
4152: wf_engine.setItemattrtext(lr_transaction_rec.item_type,p_item_key,'CURRENT_PERSON_DISPLAY_NAME',l_current_person_name);
4153: end if;
4154:
4155: -- Get Applicant name if the transaction is related to offers
4156:
4155: -- Get Applicant name if the transaction is related to offers
4156:
4157: if lr_transaction_rec.transaction_ref_table ='IRC_OFFERS' then
4158: l_current_person_name := lr_transaction_rec.api_addtnl_info;
4159: wf_engine.setItemattrtext(lr_transaction_rec.item_type,p_item_key,'CURRENT_PERSON_DISPLAY_NAME',l_current_person_name);
4160: end if;
4161: -- Create Item Attributes for those passed in
4162: --
4163: l_index := 1;
4200: END IF;
4201: -- ---------------------------------------------------
4202: -- Set the Item Owner
4203: -- ---------------------------------------------------
4204: wf_engine.setItemOwner
4205: (itemtype => lr_transaction_rec.item_type
4206: ,itemkey => p_item_key
4207: ,owner => l_role_name);
4208:
4240: );
4241:
4242: -- now start the process
4243: -- Start the WF runtime process
4244: wf_engine.startprocess
4245: (itemtype => lr_transaction_rec.item_type
4246: ,itemkey => p_item_key);
4247:
4248: -- check the wf status before returning the status back to caller
4246: ,itemkey => p_item_key);
4247:
4248: -- check the wf status before returning the status back to caller
4249: -- we need to check if the flow is in error state or not
4250: wf_engine.iteminfo(lr_transaction_rec.item_type,
4251: p_item_key,
4252: p_status,
4253: lv_result,
4254: lv_errorActid,
4311: ,p_orig_system_id => fnd_global.employee_id
4312: ,p_name => lv_loginPersonUserName
4313: ,p_display_name => lv_loginPersonDispName);
4314: --HR_APPRAISAL_FROM_USER_ATTR
4315: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type
4316: ,lr_hr_api_transaction_rec.item_key
4317: ,'HR_APPRAISAL_FROM_USER_ATTR',
4318: fnd_global.user_name);
4319: -- HR_APPRAISAL_FROM_NAME_ATTR
4316: ,lr_hr_api_transaction_rec.item_key
4317: ,'HR_APPRAISAL_FROM_USER_ATTR',
4318: fnd_global.user_name);
4319: -- HR_APPRAISAL_FROM_NAME_ATTR
4320: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type
4321: ,lr_hr_api_transaction_rec.item_key
4322: ,'HR_APPRAISAL_FROM_NAME_ATTR'
4323: ,lv_loginPersonDispName);
4324:
4332: ln_activity_id);
4333: else
4334: -- generic approval process initial block id attribute
4335: --HR_APPROVAL_BLOCK_ID_ATTR
4336: ln_activity_id:=wf_engine.getitemattrnumber(lr_hr_api_transaction_rec.item_type,
4337: lr_hr_api_transaction_rec.item_key,
4338: 'HR_APPROVAL_BLOCK_ID_ATTR',true);
4339: end if;
4340: end if;
4409: if(ln_activity_id is null) then
4410: null; -- raise error
4411: end if;
4412: -- set the workflow status TRAN_SUBMIT to Y
4413: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type
4414: ,lr_hr_api_transaction_rec.item_key
4415: ,'TRAN_SUBMIT'
4416: ,'Y');
4417:
4421:
4422: -- now transition the workflow to process approval notifications
4423: if(lr_hr_api_transaction_rec.status in('YS','RI','RIS','RO','RIS')) then
4424: -- complete the flow in resubmit mode
4425: wf_engine.CompleteActivity(
4426: lr_hr_api_transaction_rec.item_type
4427: , lr_hr_api_transaction_rec.item_key
4428: , wf_engine.getactivitylabel(ln_activity_id)
4429: , 'RESUBMIT') ;
4424: -- complete the flow in resubmit mode
4425: wf_engine.CompleteActivity(
4426: lr_hr_api_transaction_rec.item_type
4427: , lr_hr_api_transaction_rec.item_key
4428: , wf_engine.getactivitylabel(ln_activity_id)
4429: , 'RESUBMIT') ;
4430:
4431:
4432: else
4430:
4431:
4432: else
4433: -- else intial submit
4434: wf_engine.CompleteActivity(
4435: lr_hr_api_transaction_rec.item_type
4436: , lr_hr_api_transaction_rec.item_key
4437: , wf_engine.getactivitylabel(ln_activity_id)
4438: , wf_engine.eng_trans_default) ;
4433: -- else intial submit
4434: wf_engine.CompleteActivity(
4435: lr_hr_api_transaction_rec.item_type
4436: , lr_hr_api_transaction_rec.item_key
4437: , wf_engine.getactivitylabel(ln_activity_id)
4438: , wf_engine.eng_trans_default) ;
4439: end if;
4440: end if;
4441:
4434: wf_engine.CompleteActivity(
4435: lr_hr_api_transaction_rec.item_type
4436: , lr_hr_api_transaction_rec.item_key
4437: , wf_engine.getactivitylabel(ln_activity_id)
4438: , wf_engine.eng_trans_default) ;
4439: end if;
4440: end if;
4441:
4442: if (g_debug ) then
4594: date_value=>null
4595: );
4596:
4597: -- else intial submit
4598: wf_engine.CompleteActivity(
4599: lr_hr_api_transaction_rec.item_type
4600: , lr_hr_api_transaction_rec.item_key
4601: , wf_engine.getactivitylabel(ln_activity_id)
4602: , wf_engine.eng_trans_default) ;
4597: -- else intial submit
4598: wf_engine.CompleteActivity(
4599: lr_hr_api_transaction_rec.item_type
4600: , lr_hr_api_transaction_rec.item_key
4601: , wf_engine.getactivitylabel(ln_activity_id)
4602: , wf_engine.eng_trans_default) ;
4603:
4604: end if;
4605: end;
4598: wf_engine.CompleteActivity(
4599: lr_hr_api_transaction_rec.item_type
4600: , lr_hr_api_transaction_rec.item_key
4601: , wf_engine.getactivitylabel(ln_activity_id)
4602: , wf_engine.eng_trans_default) ;
4603:
4604: end if;
4605: end;
4606:
4662: raise g_wf_not_initialzed;
4663: end if;
4664: -- check if the flow is used for page navigation
4665: -- HR_OAF_NAVIGATION_ATTR
4666: lv_oaf_nav_attr := wf_engine.getitemattrtext(lv_item_type,lv_item_key,'HR_OAF_NAVIGATION_ATTR',true);
4667: if(lv_oaf_nav_attr='Y') then
4668: -- process page navigation based wf approval submit
4669: processPageNavWFSubmit(p_transaction_id,p_approval_comments );
4670: else
4732: if(lr_hr_api_transaction_rec.status<>'W') then
4733: if(lr_hr_api_transaction_rec.item_key is not null) then
4734: -- check if the flow uses wf for page navigation
4735: -- HR_OAF_NAVIGATION_ATTR
4736: lv_oaf_nav_attr := wf_engine.getitemattrtext(lr_hr_api_transaction_rec.item_type,
4737: lr_hr_api_transaction_rec.item_key,
4738: 'HR_OAF_NAVIGATION_ATTR',
4739: true);
4740: if(lv_oaf_nav_attr='Y') then
4741: -- for wf page navigation need to reset the wf state
4742: -- S, RIS,ROS,YS reset the state to saved page actid
4743: -- Y,RO,RI reset to first page activity id
4744: if(lr_hr_api_transaction_rec.status in ('S','RIS','ROS','YS')) then
4745: ln_activity_id := wf_engine.getitemattrnumber(lr_hr_api_transaction_rec.item_type,
4746: lr_hr_api_transaction_rec.item_key,
4747: 'SAVED_ACTIVITY_ID',
4748: true);
4749: elsif(lr_hr_api_transaction_rec.status in ('RI','RO','Y')) then
4746: lr_hr_api_transaction_rec.item_key,
4747: 'SAVED_ACTIVITY_ID',
4748: true);
4749: elsif(lr_hr_api_transaction_rec.status in ('RI','RO','Y')) then
4750: ln_activity_id := wf_engine.getitemattrnumber(lr_hr_api_transaction_rec.item_type,
4751: lr_hr_api_transaction_rec.item_key,
4752: 'HR_FIRST_ACTIVITY_ID',
4753: true);
4754:
4753: true);
4754:
4755: end if;
4756:
4757: -- finally call wf engine handle to reset the state
4758: -- need to do only if the current activity id is not
4759: -- same as the ln_activity_id
4760: ln_oaf_page_act_id := hr_approval_ss.getoafpageactid(
4761: lr_hr_api_transaction_rec.item_type,
4760: ln_oaf_page_act_id := hr_approval_ss.getoafpageactid(
4761: lr_hr_api_transaction_rec.item_type,
4762: lr_hr_api_transaction_rec.item_key);
4763: if(ln_activity_id is not null and ln_activity_id<>ln_oaf_page_act_id ) then
4764: WF_ENGINE.handleError(
4765: itemType => lr_hr_api_transaction_rec.item_type
4766: ,itemKey => lr_hr_api_transaction_rec.item_type
4767: ,activity => WF_ENGINE.GetActivityLabel(ln_activity_id)
4768: ,command => 'RETRY' ) ;
4763: if(ln_activity_id is not null and ln_activity_id<>ln_oaf_page_act_id ) then
4764: WF_ENGINE.handleError(
4765: itemType => lr_hr_api_transaction_rec.item_type
4766: ,itemKey => lr_hr_api_transaction_rec.item_type
4767: ,activity => WF_ENGINE.GetActivityLabel(ln_activity_id)
4768: ,command => 'RETRY' ) ;
4769: end if;
4770: end if;
4771: end if;
4849:
4850:
4851: begin
4852:
4853: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
4854: itemkey => p_item_key,
4855: aname => 'HR_AME_APP_ID_ATTR');
4856: c_application_id := nvl(c_application_id,800);
4857: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
4853: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
4854: itemkey => p_item_key,
4855: aname => 'HR_AME_APP_ID_ATTR');
4856: c_application_id := nvl(c_application_id,800);
4857: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
4858: itemkey => p_item_key,
4859: aname => 'TRANSACTION_ID');
4860: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4861: itemkey => p_item_key,
4856: c_application_id := nvl(c_application_id,800);
4857: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
4858: itemkey => p_item_key,
4859: aname => 'TRANSACTION_ID');
4860: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4861: itemkey => p_item_key,
4862: aname => 'HR_AME_TRAN_TYPE_ATTR');
4863:
4864: ame_api2.getadminapprover(applicationidin => c_application_id
4867:
4868: l_aprv_routing_username := c_approver_to_notify_rec.name;
4869:
4870: if(l_aprv_routing_username is null) then
4871: l_aprv_routing_username := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4872: itemkey => p_item_key,
4873: aname => 'CREATOR_PERSON_USERNAME');
4874: end if;
4875: wf_engine.setitemattrtext(p_item_type,p_item_key,'APPROVAL_ROUTING_USERNAME1',l_aprv_routing_username);
4871: l_aprv_routing_username := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4872: itemkey => p_item_key,
4873: aname => 'CREATOR_PERSON_USERNAME');
4874: end if;
4875: wf_engine.setitemattrtext(p_item_type,p_item_key,'APPROVAL_ROUTING_USERNAME1',l_aprv_routing_username);
4876:
4877: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4878: itemkey => p_item_key,
4879: aname => 'FORWARD_FROM_DISPLAY_NAME');
4873: aname => 'CREATOR_PERSON_USERNAME');
4874: end if;
4875: wf_engine.setitemattrtext(p_item_type,p_item_key,'APPROVAL_ROUTING_USERNAME1',l_aprv_routing_username);
4876:
4877: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4878: itemkey => p_item_key,
4879: aname => 'FORWARD_FROM_DISPLAY_NAME');
4880: if(l_forward_from_display_name is null) then
4881: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4877: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4878: itemkey => p_item_key,
4879: aname => 'FORWARD_FROM_DISPLAY_NAME');
4880: if(l_forward_from_display_name is null) then
4881: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4882: itemkey => p_item_key,
4883: aname => 'CREATOR_PERSON_DISPLAY_NAME');
4884: end if;
4885: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_FROM_DISPLAY_NAME',l_forward_from_display_name);
4881: l_forward_from_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4882: itemkey => p_item_key,
4883: aname => 'CREATOR_PERSON_DISPLAY_NAME');
4884: end if;
4885: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_FROM_DISPLAY_NAME',l_forward_from_display_name);
4886:
4887: l_forward_to_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4888: itemkey => p_item_key,
4889: aname => 'FORWARD_TO_DISPLAY_NAME');
4883: aname => 'CREATOR_PERSON_DISPLAY_NAME');
4884: end if;
4885: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_FROM_DISPLAY_NAME',l_forward_from_display_name);
4886:
4887: l_forward_to_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4888: itemkey => p_item_key,
4889: aname => 'FORWARD_TO_DISPLAY_NAME');
4890: if(l_forward_to_display_name is null) then
4891: l_forward_to_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4887: l_forward_to_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4888: itemkey => p_item_key,
4889: aname => 'FORWARD_TO_DISPLAY_NAME');
4890: if(l_forward_to_display_name is null) then
4891: l_forward_to_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4892: itemkey => p_item_key,
4893: aname => 'CREATOR_PERSON_DISPLAY_NAME');
4894: end if;
4895: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',l_forward_to_display_name);
4891: l_forward_to_display_name := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4892: itemkey => p_item_key,
4893: aname => 'CREATOR_PERSON_DISPLAY_NAME');
4894: end if;
4895: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',l_forward_to_display_name);
4896:
4897:
4898: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',error_message_text);
4899: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',p_item_type);
4894: end if;
4895: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',l_forward_to_display_name);
4896:
4897:
4898: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',error_message_text);
4899: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',p_item_type);
4900: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',p_item_key);
4901:
4902:
4895: wf_engine.setitemattrtext(p_item_type,p_item_key,'FORWARD_TO_DISPLAY_NAME',l_forward_to_display_name);
4896:
4897:
4898: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',error_message_text);
4899: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',p_item_type);
4900: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',p_item_key);
4901:
4902:
4903: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4896:
4897:
4898: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_MESSAGE_TEXT',error_message_text);
4899: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',p_item_type);
4900: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',p_item_key);
4901:
4902:
4903: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4904: itemkey => p_item_key,
4899: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_TYPE',p_item_type);
4900: wf_engine.setitemattrtext(p_item_type,p_item_key,'ERROR_ITEM_KEY',p_item_key);
4901:
4902:
4903: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => p_item_type ,
4904: itemkey => p_item_key,
4905: aname => 'HR_NTF_SUB_FND_MSG_ATTR',
4906: ignore_notfound=>true);
4907: