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 FND_PROFILE

Line 253: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');

249: , p_effectivedate => l_effectiveDate);
250: end if;
251: hr_utility.set_location('Populated all data:Create Workflow', 110);
252: hr_utility.set_location('Event Data : '||l_eventData, 120);
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

Line 313: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')

309: (p_person_id=> p_recipientPersonId,
310: p_eff_date => trunc(sysdate)
311: );
312: if (p_personType <> 'CAND' OR l_isInternalPerson ='TRUE') then
313: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
314: || fnd_profile.value('ICX_PREFIX'),'/');
315: else
316: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
317: fnd_profile.value('APPS_FRAMEWORK_AGENT'))

Line 314: || fnd_profile.value('ICX_PREFIX'),'/');

310: p_eff_date => trunc(sysdate)
311: );
312: if (p_personType <> 'CAND' OR l_isInternalPerson ='TRUE') then
313: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
314: || fnd_profile.value('ICX_PREFIX'),'/');
315: else
316: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
317: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
318: ||fnd_profile.value('ICX_PREFIX'),'/');

Line 316: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),

312: if (p_personType <> 'CAND' OR l_isInternalPerson ='TRUE') then
313: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
314: || fnd_profile.value('ICX_PREFIX'),'/');
315: else
316: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
317: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
318: ||fnd_profile.value('ICX_PREFIX'),'/');
319: end if;
320:

Line 317: fnd_profile.value('APPS_FRAMEWORK_AGENT'))

313: l_apps_fwk_agent := rtrim(fnd_profile.value_specific('APPS_FRAMEWORK_AGENT')
314: || fnd_profile.value('ICX_PREFIX'),'/');
315: else
316: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
317: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
318: ||fnd_profile.value('ICX_PREFIX'),'/');
319: end if;
320:
321: l_apps_fwk_agent := l_apps_fwk_agent ||'/OA_HTML';

Line 318: ||fnd_profile.value('ICX_PREFIX'),'/');

314: || fnd_profile.value('ICX_PREFIX'),'/');
315: else
316: l_apps_fwk_agent := rtrim(nvl(fnd_profile.value('IRC_FRAMEWORK_AGENT'),
317: fnd_profile.value('APPS_FRAMEWORK_AGENT'))
318: ||fnd_profile.value('ICX_PREFIX'),'/');
319: end if;
320:
321: l_apps_fwk_agent := l_apps_fwk_agent ||'/OA_HTML';
322:

Line 661: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)

657: select NLS_LANGUAGE
658: from fnd_languages_vl
659: where language_code = p_dft_lang;
660: cursor get_user_lang(p_user_name varchar2) is
661: select FND_PROFILE.value_specific('ICX_LANGUAGE',usr.user_id)
662: from fnd_user usr
663: where user_name = p_user_name;
664: cursor get_message_name( c_messageName in varchar2 , c_language in varchar2) is
665: select message_name

Line 673: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');

669: from fnd_languages_vl
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');

Line 677: l_ameTransactionType := fnd_profile.value('IRC_NTF_AME_TX_TYPE');

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
680: hr_utility.set_location('AME Transaction Type : ' || l_ameTransactionType, 20);
681: begin

Line 788: l_message_type :=fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');

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');
789: if l_eventName in ('INTVCRE','INTVUPD') and l_person_type <> 'DLINT' then
790: l_ntf_message_type := 'IRC_MESSAGE_WITH_ATTACHMENT';
791: elsif l_person_type <> 'CAND' and l_eventName = 'APLFORJOB' then
792: l_ntf_message_type := 'IRC_MESSAGE_WITH_ATTACHMENT';

Line 857: g_WFItemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');

853: l_value varchar2(1000);
854: l_proc constant varchar2(50) := 'getWFAttrValue';
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);

Line 978: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');

974: where name = c_timezoneNameIn
975: and rownum < 2;
976: begin
977: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
978: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
979: l_position := instrb(document_id,':',1,1);
980: -- heredocumentid represent the item key and notification_id, which is used to get the required values
981: if l_position is null then
982: return;