APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on DBMS_SESSION

Line 1201: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_seeker_lang_pref);

1197: fetch get_nls_lang into l_current_lang;
1198: close get_nls_lang;
1199:
1200: if (l_current_lang <> seeker_rec.lang_pref) then
1201: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_seeker_lang_pref);
1202: end if;
1203: l_posting_details_tab.delete;
1204: l_counter := 0;
1205: --dbms_output.put_line('Processing Person:'||seeker_rec.person_id);

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

1498: exception
1499: when others then
1500: -- Catch the exception so that an error doens't cause total failure.
1501: hr_utility.set_location('Problem sending notification to person:'||seeker_rec.person_id,60);
1502: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1503: end;
1504: END LOOP;
1505: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1506: DBMS_SQL.CLOSE_CURSOR (c => l_cursor);--All done, so clean up!

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

1501: hr_utility.set_location('Problem sending notification to person:'||seeker_rec.person_id,60);
1502: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1503: end;
1504: END LOOP;
1505: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1506: DBMS_SQL.CLOSE_CURSOR (c => l_cursor);--All done, so clean up!
1507:
1508: --
1509: hr_utility.set_location('Leaving'||l_proc, 80);

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

1508: --
1509: hr_utility.set_location('Leaving'||l_proc, 80);
1510: EXCEPTION
1511: WHEN others THEN
1512: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
1513: ERRBUF := SQLERRM||' '||fnd_message.get;
1514: RETCODE := 2;
1515: END email_suitable_vacs_to_seekers;
1516: