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 680: wf_engine.CreateProcess

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

Line 686: wf_engine.setItemOwner(itemtype => p_itemType

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

Line 690: wf_engine.SetItemUserKey(itemtype => p_itemType

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

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

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

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

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

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

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

Line 713: wf_engine.startprocess

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

Line 761: wf_engine.setitemattrtext(lv_item_type,

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

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

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

Line 772: wf_engine.setitemattrtext(lv_item_type,

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

Line 779: wf_engine.setitemattrtext(lv_item_type,

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

Line 784: wf_engine.completeactivity(lv_item_type,lv_item_key,

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

Line 785: wf_engine.getactivitylabel(ln_sfl_block_activity_id),

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

Line 786: wf_engine.eng_trans_default);

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

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

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

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

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

Line 817: result := wf_engine.eng_trans_default;

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

Line 953: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type

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

Line 958: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type

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

Line 1008: wf_engine.setitemattrtext(lr_hr_api_transaction_rec.item_type

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

Line 1016: wf_engine.CompleteActivity(

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

Line 1019: , wf_engine.getactivitylabel(ln_activity_id)

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

Line 1024: wf_engine.CompleteActivity(

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

Line 1027: , wf_engine.getactivitylabel(ln_activity_id)

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

Line 1028: , wf_engine.eng_trans_default) ;

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

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

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

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

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

Line 1087: wf_engine.completeactivity(lv_sfl_item_type,lv_sfl_item_key,

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

Line 1088: wf_engine.getactivitylabel(ln_sfl_block_activity_id),

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

Line 1089: wf_engine.eng_trans_default);

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

Line 1141: wf_engine.getitemattrnumber(lv_sfl_item_type,

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