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

Line 22: wf_engine.setItemAttrText( itemtype => p_itemType

18: l_temp := substr(l_temp, instr(l_temp, ':') + 1);
19: l_value := substr(l_temp, 1, instr(l_temp, ';') - 1);
20: l_temp := substr(l_temp, instr(l_temp, ';') + 1);
21: begin
22: wf_engine.setItemAttrText( itemtype => p_itemType
23: , itemkey => p_itemKey
24: , aname => l_key
25: , avalue => l_value);
26: exception

Line 257: wf_engine.CreateProcess(l_itemType

253: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
254: hr_utility.set_location('Item Type : '||l_itemType, 130);
255: if l_itemType is not NULL then
256: l_itemKey := p_event.event_key;
257: wf_engine.CreateProcess(l_itemType
258: ,l_itemKey
259: ,'IRC_NOTIFICATION_PRC');
260: loadWorkflowAttributes ( p_eventData => l_eventData
261: , p_itemType => l_itemType

Line 263: wf_engine.startprocess( l_itemType

259: ,'IRC_NOTIFICATION_PRC');
260: loadWorkflowAttributes ( p_eventData => l_eventData
261: , p_itemType => l_itemType
262: , p_itemKey => l_itemKey );
263: wf_engine.startprocess( l_itemType
264: , l_itemKey);
265: else
266: hr_utility.set_location('Workflow Item Type not set', 160);
267: end if;

Line 304: l_eventName := wf_engine.getItemAttrText ( itemtype => p_itemType

300: select function_id from fnd_form_functions
301: where function_name = p_function_name;
302: begin
303: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
304: l_eventName := wf_engine.getItemAttrText ( itemtype => p_itemType
305: , itemkey => p_itemKey
306: , aname => 'IRC_EVENT_NAME');
307: hr_utility.set_location('Event name : '||l_eventName,20);
308: l_isInternalPerson := irc_utilities_pkg.is_internal_person

Line 323: l_assignmentId := wf_engine.getItemAttrText ( itemtype => p_itemType

319: end if;
320:
321: l_apps_fwk_agent := l_apps_fwk_agent ||'/OA_HTML';
322:
323: l_assignmentId := wf_engine.getItemAttrText ( itemtype => p_itemType
324: , itemkey => p_itemKey
325: , aname => 'IRC_ASSIGNMENT_ID');
326: l_candidatePersonId := wf_engine.getItemAttrText ( itemtype => p_itemType
327: , itemkey => p_itemKey

Line 326: l_candidatePersonId := wf_engine.getItemAttrText ( itemtype => p_itemType

322:
323: l_assignmentId := wf_engine.getItemAttrText ( itemtype => p_itemType
324: , itemkey => p_itemKey
325: , aname => 'IRC_ASSIGNMENT_ID');
326: l_candidatePersonId := wf_engine.getItemAttrText ( itemtype => p_itemType
327: , itemkey => p_itemKey
328: , aname => 'IRC_CAND_PER_ID');
329:
330: hr_utility.set_location('Assignment Id : '||l_assignmentId,30);

Line 364: l_managerId := wf_engine.getItemAttrText ( itemtype => p_itemType

360: l_params := 'IrcAction=CommunicationDetails'
361: || '&p_aplid=' || l_assignmentId
362: || '&p_sprty=' || l_candidatePersonId;
363: elsif l_eventName like 'INTV%' then
364: l_managerId := wf_engine.getItemAttrText ( itemtype => p_itemType
365: , itemkey => p_itemKey
366: , aname => 'IRC_MGR_PER_ID');
367: l_recruiterId := wf_engine.getItemAttrText ( itemtype => p_itemType
368: , itemkey => p_itemKey

Line 367: l_recruiterId := wf_engine.getItemAttrText ( itemtype => p_itemType

363: elsif l_eventName like 'INTV%' then
364: l_managerId := wf_engine.getItemAttrText ( itemtype => p_itemType
365: , itemkey => p_itemKey
366: , aname => 'IRC_MGR_PER_ID');
367: l_recruiterId := wf_engine.getItemAttrText ( itemtype => p_itemType
368: , itemkey => p_itemKey
369: , aname => 'IRC_REC_PER_ID');
370: l_params := 'IrcAction=InterviewDetails'
371: || '&p_aplid=' || l_assignmentId

Line 395: wf_engine.setItemAttrText( itemtype => p_itemType

391: p_parameters =>l_params,
392: p_encryptParameters =>true ) ;
393:
394: hr_utility.set_location('Generated URL : '||l_url,60);
395: wf_engine.setItemAttrText( itemtype => p_itemType
396: , itemkey => p_itemKey
397: , aname => p_urlAttribute
398: , avalue => l_url);
399: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 70);

Line 470: l_value := wf_engine.GetItemAttrText( itemtype => p_itemType

466: , p_recipientPersonId =>p_personId
467: , p_personType => p_personType);
468: end if;
469: begin
470: l_value := wf_engine.GetItemAttrText( itemtype => p_itemType
471: , itemkey => p_itemKey
472: , aname => l_token);
473: exception
474: when others then

Line 674: l_oldExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_JOB_APPL_OLD_STATUS');

670: where nls_language = c_language );
671: BEGIN
672: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
673: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
674: l_oldExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_JOB_APPL_OLD_STATUS');
675: l_newExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_APPL_NEW_EXTERNAL_STATUS');
676:
677: l_ameTransactionType := fnd_profile.value('IRC_NTF_AME_TX_TYPE');
678: l_person_type := null;

Line 675: l_newExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_APPL_NEW_EXTERNAL_STATUS');

671: BEGIN
672: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
673: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
674: l_oldExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_JOB_APPL_OLD_STATUS');
675: l_newExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_APPL_NEW_EXTERNAL_STATUS');
676:
677: l_ameTransactionType := fnd_profile.value('IRC_NTF_AME_TX_TYPE');
678: l_person_type := null;
679: if l_ameTransactionType is not NULL then

Line 702: wf_engine.setItemAttrText ( itemtype => p_itemType

698: hr_utility.set_location('AME Transaction Complete : ' || l_approvalprocesscompleteynout,30);
699: if l_approvalProcessCompleteYNOut = 'N' then
700: hr_utility.set_location('Recipient : ' || l_nextApprovers(1).name,60);
701:
702: wf_engine.setItemAttrText ( itemtype => p_itemType
703: , itemkey => p_itemKey
704: , aname => 'IRC_APPROVER'
705: , avalue => l_nextApprovers(1).name );
706: l_eventName := wf_engine.GetItemAttrText( itemtype => p_itemType

Line 706: l_eventName := wf_engine.GetItemAttrText( itemtype => p_itemType

702: wf_engine.setItemAttrText ( itemtype => p_itemType
703: , itemkey => p_itemKey
704: , aname => 'IRC_APPROVER'
705: , avalue => l_nextApprovers(1).name );
706: l_eventName := wf_engine.GetItemAttrText( itemtype => p_itemType
707: , itemkey => p_itemKey
708: , aname => 'IRC_EVENT_NAME');
709: l_messageSubjectName := null;
710: l_htmlMessageName := null;

Line 754: wf_engine.setItemAttrText ( itemtype => p_itemType

750: l_messageSubject := parseAndReplaceFNDMessage( p_itemType => p_itemType
751: , p_itemKey => p_itemKey
752: , p_message => fnd_message.get);
753: hr_utility.set_location('Message Subject sent to Recipient: '||l_messageSubject,120);
754: wf_engine.setItemAttrText ( itemtype => p_itemType
755: , itemkey => p_itemKey
756: , aname => 'IRC_MESSAGE_SUBJECT'
757: , avalue => l_messageSubject);
758:

Line 784: wf_engine.setitemattrtext( itemtype => p_itemType

780: , p_message => fnd_message.get
781: , p_personId => l_nextApprovers(1).orig_system_id
782: , p_personType => l_person_type);
783: hr_utility.set_location('Message HTML Body sent to recipient: '|| l_htmlMessageBody, 150);
784: wf_engine.setitemattrtext( itemtype => p_itemType
785: , itemkey => p_itemKey
786: , aname => 'IRC_MESSAGE_BODY'
787: , avalue => l_htmlMessageBody);
788: l_message_type :=fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');

Line 813: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType

809: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);
811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);
812: if l_ntf_message_type = 'IRC_MESSAGE_WITH_ATTACHMENT' then
813: l_candidatePersonId := wf_engine.GetItemAttrText( itemtype => p_itemType
814: , itemkey => p_itemKey
815: , aname => 'IRC_CAND_PER_ID');
816: attachDocument(l_notificationId,l_candidatePersonId,l_eventName,p_itemKey,l_person_type);
817: end if;

Line 859: l_value := wf_engine.getitemattrtext( itemtype => g_WFItemType

855: begin
856: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
857: g_WFItemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
858: hr_utility.set_location('Workflow Attribute : '|| p_WFAttr, 20);
859: l_value := wf_engine.getitemattrtext( itemtype => g_WFItemType
860: , itemkey => p_itemKey
861: , aname => p_WFAttr);
862: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 60);
863: return l_value;

Line 988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');

984: l_item_key := substr(document_id,1,l_position-1);
985: l_notification_id := to_number(substr(document_id,l_position+1,length(document_id)));
986: end if;
987: hr_utility.set_location('getting the interview details', 20);
988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');
989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);
992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);

Line 989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');

985: l_notification_id := to_number(substr(document_id,l_position+1,length(document_id)));
986: end if;
987: hr_utility.set_location('getting the interview details', 20);
988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');
989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);
992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);
993: l_loc_description := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_LOC_DETAILS',ignore_notfound=>true);

Line 990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);

986: end if;
987: hr_utility.set_location('getting the interview details', 20);
988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');
989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);
992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);
993: l_loc_description := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_LOC_DETAILS',ignore_notfound=>true);
994: if l_time_zone is null then

Line 991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);

987: hr_utility.set_location('getting the interview details', 20);
988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');
989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);
992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);
993: l_loc_description := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_LOC_DETAILS',ignore_notfound=>true);
994: if l_time_zone is null then
995: l_ignore_time_zone := true;

Line 992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);

988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');
989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);
992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);
993: l_loc_description := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_LOC_DETAILS',ignore_notfound=>true);
994: if l_time_zone is null then
995: l_ignore_time_zone := true;
996: else

Line 993: l_loc_description := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_LOC_DETAILS',ignore_notfound=>true);

989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);
992: l_time_zone := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_ZONE',ignore_notfound=>true);
993: l_loc_description := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_LOC_DETAILS',ignore_notfound=>true);
994: if l_time_zone is null then
995: l_ignore_time_zone := true;
996: else
997: open getTimezoneCode(l_time_zone);