APPS.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on DBMS_SESSION

Line 737: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_user_lang||'''');

733: open get_user_lang(l_nextApprovers(1).name);
734: fetch get_user_lang into l_user_lang;
735: close get_user_lang;
736: if l_dft_lang <> l_user_lang then
737: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_user_lang||'''');
738: end if;
739:
740: l_textMessageName := CONCAT(SUBSTR(l_htmlMessageName, 1, LENGTH(l_htmlMessageName)-4), 'BTXT');
741: open get_message_name(l_textMessageName, l_user_lang);

Line 820: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);

816: attachDocument(l_notificationId,l_candidatePersonId,l_eventName,p_itemKey,l_person_type);
817: end if;
818: wf_notification.denormalize_notification(l_notificationId);
819: if l_dft_lang <> l_user_lang then
820: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
821: end if;
822: result := 'COMPLETE:IRC_E';
823: hr_utility.set_location('Recipients Exist - Exiting:'|| g_package||'.'||l_proc, 200);
824: end if;

Line 845: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);

841: result := 'COMPLETE:IRC_E';
842: when others then
843: hr_utility.set_location('Error - Skipping:'|| g_package||'.'||l_proc, 350);
844: hr_utility.set_location('Error Message:'|| SQLERRM, 360);
845: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
846: result := 'COMPLETE:IRC_E';
847: end getNextRecipient;
848: --+
849: --+ getWFAttrValue