eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SFLUTIL_SS dependencies on WF_ENGINE

Line 48: if HR_SFLUTIL_SS.OpenNotificationsExist(wf_engine.getitemattrnumber(p_item_type,p_item_key,'HR_LAST_SFL_NTF_ID_ATTR',true))=false then

44: --hr_utility.trace_off();
45: return result;
46: end;
47:
48: if HR_SFLUTIL_SS.OpenNotificationsExist(wf_engine.getitemattrnumber(p_item_type,p_item_key,'HR_LAST_SFL_NTF_ID_ATTR',true))=false then
49: if g_debug then
50: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 4);
51: end if;
52: result := 'TRUE';

Line 89: if (funmode <> wf_engine.eng_run) then

85: if g_debug then
86: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
87: end if;
88: -- Do nothing in cancel or timeout mode
89: if (funmode <> wf_engine.eng_run) then
90: result := wf_engine.eng_null;
91: return;
92: end if;
93: -- set the item attribute value with the current activity id

Line 90: result := wf_engine.eng_null;

86: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
87: end if;
88: -- Do nothing in cancel or timeout mode
89: if (funmode <> wf_engine.eng_run) then
90: result := wf_engine.eng_null;
91: return;
92: end if;
93: -- set the item attribute value with the current activity id
94: -- this will be used when the recpients notification is sent.

Line 97: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_SFL_BLOCK_ID_ATTR',actid);

93: -- set the item attribute value with the current activity id
94: -- this will be used when the recpients notification is sent.
95: -- and to complete the blocked thread.
96: -- HR_SFL_BLOCK_ID_ATTR
97: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_SFL_BLOCK_ID_ATTR',actid);
98: wf_standard.block(itemtype,itemkey,actid,funmode,result);
99:
100: if g_debug then
101: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

Line 149: if (funmode = wf_engine.eng_run) then

145: if g_debug then
146: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 10);
147: end if;
148:
149: if (funmode = wf_engine.eng_run) then
150: -- check if we need to send notification or end the SFL process
151: -- HR_SEND_SFL_NTF_ATTR
152: lv_sendNtf := NVL(wf_engine.GetItemAttrText(itemtype => itemtype,
153: itemkey => itemkey,

Line 152: lv_sendNtf := NVL(wf_engine.GetItemAttrText(itemtype => itemtype,

148:
149: if (funmode = wf_engine.eng_run) then
150: -- check if we need to send notification or end the SFL process
151: -- HR_SEND_SFL_NTF_ATTR
152: lv_sendNtf := NVL(wf_engine.GetItemAttrText(itemtype => itemtype,
153: itemkey => itemkey,
154: aname => 'HR_SEND_SFL_NTF_ATTR',
155: ignore_notfound=>true),'N');
156: result := 'COMPLETE:'|| lv_sendNtf;

Line 247: if (funcmode <> wf_engine.eng_run) then

243: document_type varchar2(240);
244: ln_notification_id number;
245: begin
246: -- Do nothing in cancel or timeout mode
247: if (funcmode <> wf_engine.eng_run) then
248: resultout := wf_engine.eng_null;
249: return;
250: end if;
251:

Line 248: resultout := wf_engine.eng_null;

244: ln_notification_id number;
245: begin
246: -- Do nothing in cancel or timeout mode
247: if (funcmode <> wf_engine.eng_run) then
248: resultout := wf_engine.eng_null;
249: return;
250: end if;
251:
252: -- close the existing ntf id if any for this transaction

Line 253: ln_notification_id :=wf_engine.getitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',true);

249: return;
250: end if;
251:
252: -- close the existing ntf id if any for this transaction
253: ln_notification_id :=wf_engine.getitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',true);
254: if(ln_notification_id is not null and OpenNotificationsExist(ln_notification_id))then
255: wf_notification.close(ln_notification_id,'SYSADMIN');
256: end if;
257:

Line 260: prole := wf_engine.GetActivityAttrText(

256: end if;
257:
258:
259: --PERFORMER
260: prole := wf_engine.GetActivityAttrText(
261: itemtype => itemtype,
262: itemkey => itemkey,
263: actid => actid,
264: aname => 'PERFORMER');

Line 274: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

270: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
271: end if;
272:
273: -- message name and expand roles will be null. Get these from attributes
274: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
275: actid, 'MESSAGE'));
276:
277: -- let notification_send catch a missing message name.
278: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

Line 278: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

274: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
275: actid, 'MESSAGE'));
276:
277: -- let notification_send catch a missing message name.
278: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
279: actid, 'EXPANDROLES'),'N');
280:
281: -- parse out the message type if given
282: colon := instr(avalue, ':');

Line 293: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,

289: end if;
290:
291:
292: -- Actually send the notification
293: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,
294: msg, msgtype, prole, expand_role,
295: resultout);
296:
297: notid:= Wf_Engine.g_nid ;

Line 297: notid:= Wf_Engine.g_nid ;

293: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,
294: msg, msgtype, prole, expand_role,
295: resultout);
296:
297: notid:= Wf_Engine.g_nid ;
298:
299: exception
300: when others then
301: Wf_Core.Context('HR_SFLUTIL_SS.Notify', itemtype,

Line 681: wf_engine.CreateProcess

677: into p_itemKey
678: from sys.dual;
679:
680: -- Create the Workflow Process
681: wf_engine.CreateProcess
682: (itemtype => p_itemType
683: ,itemkey => p_itemKey
684: ,process => p_process_name);
685:

Line 687: wf_engine.setItemOwner(itemtype => p_itemType

683: ,itemkey => p_itemKey
684: ,process => p_process_name);
685:
686: -- set owner role
687: wf_engine.setItemOwner(itemtype => p_itemType
688: ,itemkey => p_itemKey
689: ,owner => fnd_global.user_name);
690: -- set the user key
691: wf_engine.SetItemUserKey(itemtype => p_itemType

Line 691: wf_engine.SetItemUserKey(itemtype => p_itemType

687: wf_engine.setItemOwner(itemtype => p_itemType
688: ,itemkey => p_itemKey
689: ,owner => fnd_global.user_name);
690: -- set the user key
691: wf_engine.SetItemUserKey(itemtype => p_itemType
692: ,itemkey => p_itemKey
693: ,userkey => p_transaction_id);
694:
695: -- set the SFL transaction reference id, HR_SFL_TRANSACTION_REF_ID_ATTR

Line 696: wf_engine.setitemattrnumber(p_itemType,p_itemKey,'HR_SFL_TRANSACTION_REF_ID_ATTR',p_transaction_id);

692: ,itemkey => p_itemKey
693: ,userkey => p_transaction_id);
694:
695: -- set the SFL transaction reference id, HR_SFL_TRANSACTION_REF_ID_ATTR
696: wf_engine.setitemattrnumber(p_itemType,p_itemKey,'HR_SFL_TRANSACTION_REF_ID_ATTR',p_transaction_id);
697:
698: -- HR_SFL_TRANS_REF_TABLE_ATTR
699: wf_engine.setitemattrtext(p_itemType,p_itemKey,'HR_SFL_TRANS_REF_TABLE_ATTR',p_transaction_ref_table);
700: -- set the parent item type and item key ,if any for this SFL

Line 699: wf_engine.setitemattrtext(p_itemType,p_itemKey,'HR_SFL_TRANS_REF_TABLE_ATTR',p_transaction_ref_table);

695: -- set the SFL transaction reference id, HR_SFL_TRANSACTION_REF_ID_ATTR
696: wf_engine.setitemattrnumber(p_itemType,p_itemKey,'HR_SFL_TRANSACTION_REF_ID_ATTR',p_transaction_id);
697:
698: -- HR_SFL_TRANS_REF_TABLE_ATTR
699: wf_engine.setitemattrtext(p_itemType,p_itemKey,'HR_SFL_TRANS_REF_TABLE_ATTR',p_transaction_ref_table);
700: -- set the parent item type and item key ,if any for this SFL
701: begin
702: if(p_transaction_id is not null) then
703: select * into lr_hr_api_transaction_rec from hr_api_transactions

Line 706: wf_engine.setitemparent(p_itemType,p_itemKey,lr_hr_api_transaction_rec.item_type,lr_hr_api_transaction_rec.item_key,'SFL');

702: if(p_transaction_id is not null) then
703: select * into lr_hr_api_transaction_rec from hr_api_transactions
704: where transaction_id=p_transaction_id;
705:
706: wf_engine.setitemparent(p_itemType,p_itemKey,lr_hr_api_transaction_rec.item_type,lr_hr_api_transaction_rec.item_key,'SFL');
707: end if;
708: exception
709: when others then
710: null;

Line 714: wf_engine.startprocess

710: null;
711: end;
712:
713: -- Start the WF runtime process
714: wf_engine.startprocess
715: (itemtype => p_itemType
716: ,itemkey => p_itemKey);
717:
718: commit;

Line 762: wf_engine.setitemattrtext(lv_item_type,

758: end if;
759:
760: -- finally check one more time
761: if(lv_item_key is not null) then
762: wf_engine.setitemattrtext(lv_item_type,
763: lv_item_key,
764: 'HR_SFL_USERNAME_ATTR',
765: nvl(p_userName,fnd_global.user_name));
766: -- HR_SFL_BLOCK_ID_ATTR

Line 767: ln_sfl_block_activity_id :=wf_engine.GetItemAttrNumber(lv_item_type ,

763: lv_item_key,
764: 'HR_SFL_USERNAME_ATTR',
765: nvl(p_userName,fnd_global.user_name));
766: -- HR_SFL_BLOCK_ID_ATTR
767: ln_sfl_block_activity_id :=wf_engine.GetItemAttrNumber(lv_item_type ,
768: lv_item_key,
769: 'HR_SFL_BLOCK_ID_ATTR');
770: -- set the relaunch pagefunction
771: -- syntax JSP:/OA_HTML/OA.jsp?OAFunc=HR_WF_RELATED_APPS NtfId=-&#NID-

Line 773: wf_engine.setitemattrtext(lv_item_type,

769: 'HR_SFL_BLOCK_ID_ATTR');
770: -- set the relaunch pagefunction
771: -- syntax JSP:/OA_HTML/OA.jsp?OAFunc=HR_WF_RELATED_APPS NtfId=-&#NID-
772: lv_relaunchSFLLink := 'JSP:/OA_HTML/OA.jsp?OAFunc='||nvl(p_reentryPageFunction,'')||'&'||'NtfId=-'||'&'||'#NID-';
773: wf_engine.setitemattrtext(lv_item_type,
774: lv_item_key,
775: 'HR_SFL_RESURRECT_LINK_ATTR',
776: lv_relaunchSFLLink);
777:

Line 780: wf_engine.setitemattrtext(lv_item_type,

776: lv_relaunchSFLLink);
777:
778: -- set the delete/reject link
779: -- HR_SFL_DELETE_LINK_ATTR
780: wf_engine.setitemattrtext(lv_item_type,
781: lv_item_key,
782: 'HR_SFL_DELETE_LINK_ATTR',
783: lv_relaunchSFLLink||'&'||'pAction=DELETE');
784: -- now send the notification

Line 785: wf_engine.completeactivity(lv_item_type,lv_item_key,

781: lv_item_key,
782: 'HR_SFL_DELETE_LINK_ATTR',
783: lv_relaunchSFLLink||'&'||'pAction=DELETE');
784: -- now send the notification
785: wf_engine.completeactivity(lv_item_type,lv_item_key,
786: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
787: wf_engine.eng_trans_default);
788:
789: -- set the hr api transactions with the new notification id ??

Line 786: wf_engine.getactivitylabel(ln_sfl_block_activity_id),

782: 'HR_SFL_DELETE_LINK_ATTR',
783: lv_relaunchSFLLink||'&'||'pAction=DELETE');
784: -- now send the notification
785: wf_engine.completeactivity(lv_item_type,lv_item_key,
786: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
787: wf_engine.eng_trans_default);
788:
789: -- set the hr api transactions with the new notification id ??
790: p_notification_id := wf_engine.getitemattrnumber(lv_item_type,lv_item_key,'HR_LAST_SFL_NTF_ID_ATTR');

Line 787: wf_engine.eng_trans_default);

783: lv_relaunchSFLLink||'&'||'pAction=DELETE');
784: -- now send the notification
785: wf_engine.completeactivity(lv_item_type,lv_item_key,
786: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
787: wf_engine.eng_trans_default);
788:
789: -- set the hr api transactions with the new notification id ??
790: p_notification_id := wf_engine.getitemattrnumber(lv_item_type,lv_item_key,'HR_LAST_SFL_NTF_ID_ATTR');
791:

Line 790: p_notification_id := wf_engine.getitemattrnumber(lv_item_type,lv_item_key,'HR_LAST_SFL_NTF_ID_ATTR');

786: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
787: wf_engine.eng_trans_default);
788:
789: -- set the hr api transactions with the new notification id ??
790: p_notification_id := wf_engine.getitemattrnumber(lv_item_type,lv_item_key,'HR_LAST_SFL_NTF_ID_ATTR');
791:
792: else
793: -- raise exception.
794: null;

Line 815: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',Wf_Engine.g_nid);

811: -- local variables
812: ln_notification_id number;
813: begin
814: -- set the ntf id value to HR_LAST_SFL_NTF_ID_ATTR
815: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',Wf_Engine.g_nid);
816: -- set the hr_api_transactions_table
817:
818: result := wf_engine.eng_trans_default;
819: EXCEPTION

Line 818: result := wf_engine.eng_trans_default;

814: -- set the ntf id value to HR_LAST_SFL_NTF_ID_ATTR
815: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_LAST_SFL_NTF_ID_ATTR',Wf_Engine.g_nid);
816: -- set the hr_api_transactions_table
817:
818: result := wf_engine.eng_trans_default;
819: EXCEPTION
820: WHEN others THEN
821: raise;
822: end setSFLNtfDetails;

Line 954: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type

950: ,p_orig_system_id => fnd_global.employee_id
951: ,p_name => lv_loginPersonUserName
952: ,p_display_name => lv_loginPersonDispName);
953: --HR_APPRAISAL_FROM_USER_ATTR
954: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type
955: ,lr_hr_api_transaction_rec.item_key
956: ,'HR_APPRAISAL_FROM_USER_ATTR',
957: fnd_global.user_name);
958: -- HR_APPRAISAL_FROM_NAME_ATTR

Line 959: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type

955: ,lr_hr_api_transaction_rec.item_key
956: ,'HR_APPRAISAL_FROM_USER_ATTR',
957: fnd_global.user_name);
958: -- HR_APPRAISAL_FROM_NAME_ATTR
959: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type
960: ,lr_hr_api_transaction_rec.item_key
961: ,'HR_APPRAISAL_FROM_NAME_ATTR'
962: ,lv_loginPersonDispName);
963:

Line 1009: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type

1005:
1006: end if;
1007:
1008: -- set the workflow status TRAN_SUBMIT to Y
1009: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type
1010: ,lr_hr_api_transaction_rec.item_key
1011: ,'TRAN_SUBMIT'
1012: ,'Y');
1013:

Line 1017: wf_engine.CompleteActivity(

1013:
1014: -- now transition the workflow to process approval notifications
1015: if(lr_hr_api_transaction_rec.status in('YS','RI','RIS','RO','RIS')) then
1016: -- complete the flow in resubmit mode
1017: wf_engine.CompleteActivity(
1018: lr_hr_api_transaction_rec.item_type
1019: , lr_hr_api_transaction_rec.item_key
1020: , wf_engine.getactivitylabel(ln_activity_id)
1021: , 'RESUBMIT') ;

Line 1020: , wf_engine.getactivitylabel(ln_activity_id)

1016: -- complete the flow in resubmit mode
1017: wf_engine.CompleteActivity(
1018: lr_hr_api_transaction_rec.item_type
1019: , lr_hr_api_transaction_rec.item_key
1020: , wf_engine.getactivitylabel(ln_activity_id)
1021: , 'RESUBMIT') ;
1022:
1023: else
1024: -- else intial submit

Line 1025: wf_engine.CompleteActivity(

1021: , 'RESUBMIT') ;
1022:
1023: else
1024: -- else intial submit
1025: wf_engine.CompleteActivity(
1026: lr_hr_api_transaction_rec.item_type
1027: , lr_hr_api_transaction_rec.item_key
1028: , wf_engine.getactivitylabel(ln_activity_id)
1029: , wf_engine.eng_trans_default) ;

Line 1028: , wf_engine.getactivitylabel(ln_activity_id)

1024: -- else intial submit
1025: wf_engine.CompleteActivity(
1026: lr_hr_api_transaction_rec.item_type
1027: , lr_hr_api_transaction_rec.item_key
1028: , wf_engine.getactivitylabel(ln_activity_id)
1029: , wf_engine.eng_trans_default) ;
1030: end if;
1031: else
1032: -- raise error

Line 1029: , wf_engine.eng_trans_default) ;

1025: wf_engine.CompleteActivity(
1026: lr_hr_api_transaction_rec.item_type
1027: , lr_hr_api_transaction_rec.item_key
1028: , wf_engine.getactivitylabel(ln_activity_id)
1029: , wf_engine.eng_trans_default) ;
1030: end if;
1031: else
1032: -- raise error
1033: null;

Line 1081: ln_sfl_block_activity_id :=wf_engine.GetItemAttrNumber(lv_sfl_item_type ,

1077: and rownum<2;
1078:
1079: if(lv_sfl_item_key is not null) then
1080: -- HR_SFL_BLOCK_ID_ATTR
1081: ln_sfl_block_activity_id :=wf_engine.GetItemAttrNumber(lv_sfl_item_type ,
1082: lv_sfl_item_key,
1083: 'HR_SFL_BLOCK_ID_ATTR',true);
1084: if(ln_sfl_block_activity_id is not null) then
1085: -- set the item attribute for SFL transaction

Line 1086: wf_engine.setitemattrtext(lv_sfl_item_type,lv_sfl_item_key,'HR_SEND_SFL_NTF_ATTR','N');

1082: lv_sfl_item_key,
1083: 'HR_SFL_BLOCK_ID_ATTR',true);
1084: if(ln_sfl_block_activity_id is not null) then
1085: -- set the item attribute for SFL transaction
1086: wf_engine.setitemattrtext(lv_sfl_item_type,lv_sfl_item_key,'HR_SEND_SFL_NTF_ATTR','N');
1087:
1088: wf_engine.completeactivity(lv_sfl_item_type,lv_sfl_item_key,
1089: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
1090: wf_engine.eng_trans_default);

Line 1088: wf_engine.completeactivity(lv_sfl_item_type,lv_sfl_item_key,

1084: if(ln_sfl_block_activity_id is not null) then
1085: -- set the item attribute for SFL transaction
1086: wf_engine.setitemattrtext(lv_sfl_item_type,lv_sfl_item_key,'HR_SEND_SFL_NTF_ATTR','N');
1087:
1088: wf_engine.completeactivity(lv_sfl_item_type,lv_sfl_item_key,
1089: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
1090: wf_engine.eng_trans_default);
1091: end if;
1092:

Line 1089: wf_engine.getactivitylabel(ln_sfl_block_activity_id),

1085: -- set the item attribute for SFL transaction
1086: wf_engine.setitemattrtext(lv_sfl_item_type,lv_sfl_item_key,'HR_SEND_SFL_NTF_ATTR','N');
1087:
1088: wf_engine.completeactivity(lv_sfl_item_type,lv_sfl_item_key,
1089: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
1090: wf_engine.eng_trans_default);
1091: end if;
1092:
1093: end if;

Line 1090: wf_engine.eng_trans_default);

1086: wf_engine.setitemattrtext(lv_sfl_item_type,lv_sfl_item_key,'HR_SEND_SFL_NTF_ATTR','N');
1087:
1088: wf_engine.completeactivity(lv_sfl_item_type,lv_sfl_item_key,
1089: wf_engine.getactivitylabel(ln_sfl_block_activity_id),
1090: wf_engine.eng_trans_default);
1091: end if;
1092:
1093: end if;
1094: exception

Line 1142: wf_engine.getitemattrnumber(lv_sfl_item_type,

1138:
1139: if(lv_sfl_item_key is not null) then
1140: -- get the ntf id value to HR_LAST_SFL_NTF_ID_ATTR
1141: ln_notification_id:=
1142: wf_engine.getitemattrnumber(lv_sfl_item_type,
1143: lv_sfl_item_key,
1144: 'HR_LAST_SFL_NTF_ID_ATTR',
1145: true);
1146: hr_utility.set_location('sfl ln_notification_id:'||ln_notification_id, 4);