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_OFFER_NOTIFICATIONS_PKG dependencies on DBMS_SESSION

Line 541: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');

537:
538: --set the applicant pref language to the session
539:
540: if l_current_set_lang <> l_apl_lang then
541: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');
542: l_current_set_lang := l_apl_lang;
543: end if;
544:
545: -- build subject message

Line 631: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');

627:
628: -- set the pref language of Manager to the session */
629:
630: if l_current_set_lang <> l_mgr_lang then
631: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');
632: l_current_set_lang := l_mgr_lang;
633: end if;
634:
635: -- build subject message

Line 801: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_apl_lang);

797:
798: --set the applicant pref language to the session
799:
800: if l_current_set_lang <> l_apl_lang then
801: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_apl_lang);
802: l_current_set_lang := l_apl_lang;
803: end if;
804:
805: -- build subject message

Line 914: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_mgr_lang);

910:
911: -- set the pref language of Manager to the session */
912:
913: if l_current_set_lang <> l_mgr_lang then
914: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_mgr_lang);
915: l_current_set_lang := l_mgr_lang;
916: end if;
917:
918: -- build subject message

Line 1021: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);

1017: end if;
1018: end loop;
1019: --Reset applicantion's current session Language
1020: if l_intial_set_lang <> l_current_set_lang then
1021: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1022: end if;
1023: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1024: fnd_file.put_line
1025: (which => fnd_file.log

Line 1034: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);

1030: hr_utility.set_location(' Leaving:'||l_proc, 130);
1031:
1032: exception
1033: when others then
1034: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1035: --
1036: END send_expiry_notification;
1037: --
1038: --

Line 1130: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_apl_lang);

1126: fetch get_user_lang into l_apl_lang;
1127: close get_user_lang;
1128: --set the applicant pref language to the session
1129: if l_current_set_lang <> l_apl_lang then
1130: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_apl_lang);
1131: l_current_set_lang := l_apl_lang;
1132: end if;
1133:
1134: -- build subject message

Line 1215: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_mgr_lang);

1211: close get_user_lang;
1212:
1213: -- set the pref language of Manager to the session */
1214: if l_current_set_lang <> l_mgr_lang then
1215: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_mgr_lang);
1216: l_current_set_lang := l_mgr_lang;
1217: end if;
1218:
1219: -- build subject message

Line 1337: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);

1333:
1334: end loop;
1335: --Reset applicantion's current session Language
1336: if l_intial_set_lang <> l_current_set_lang then
1337: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1338: end if;
1339: fnd_file.NEW_LINE(WHICH => fnd_file.log );
1340: fnd_file.put_line
1341: (which => fnd_file.log

Line 1349: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);

1345: );
1346: hr_utility.set_location(' Leaving:'||l_proc, 120);
1347: exception
1348: when others then
1349: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_intial_set_lang);
1350: --
1351: END send_expired_notification;
1352: --
1353: -- ----------------------------------------------------------------------------

Line 1513: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');

1509:
1510: --set the applicant pref language to the session
1511:
1512: if l_current_set_lang <> l_apl_lang then
1513: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');
1514: l_current_set_lang := l_apl_lang;
1515: end if;
1516:
1517: -- build subject message for applicant

Line 1598: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');

1594:
1595: -- set the pref language of Manager to the session */
1596:
1597: if l_current_set_lang <> l_mgr_lang then
1598: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');
1599: l_current_set_lang := l_mgr_lang;
1600: end if;
1601:
1602: -- build subject message for manager

Line 1719: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_ref_lang||'''');

1715:
1716: -- set the pref language of referrer to the session
1717:
1718: if l_current_set_lang <> l_mgr_lang then
1719: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_ref_lang||'''');
1720: l_current_set_lang := l_ref_lang;
1721: end if;
1722: -- build subject message for referrer
1723: fnd_message.set_name('PER','IRC_412441_OFR_ACCEPT_REF_SUB');

Line 1760: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

1756: resultout:='COMPLETE';
1757: hr_utility.set_location(' Leaving:'||l_proc, 160);
1758: --Reset applicantion's current session Language
1759: if l_intial_set_lang <> l_current_set_lang then
1760: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
1761: end if;
1762:
1763: exception
1764: when others then

Line 1765: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

1761: end if;
1762:
1763: exception
1764: when others then
1765: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
1766: --
1767: END send_applicant_response;
1768: --
1769: -- ----------------------------------------------------------------------------

Line 1861: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');

1857:
1858: -- set the pref language of Manager to the session
1859:
1860: if l_current_set_lang <> l_mgr_lang then
1861: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');
1862: l_current_set_lang := l_mgr_lang;
1863: end if;
1864:
1865: -- build subject message for manager

Line 1906: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

1902: resultout:='COMPLETE';
1903: hr_utility.set_location(' Leaving:'||l_proc, 90);
1904: --Reset applicantion's current session Language
1905: if l_intial_set_lang <> l_current_set_lang then
1906: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
1907: end if;
1908:
1909: exception
1910: when others then

Line 1911: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

1907: end if;
1908:
1909: exception
1910: when others then
1911: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
1912: --
1913: END send_onhold_notification;
1914: -- ----------------------------------------------------------------------------
1915: -- send_withdrawal_notification --

Line 2102: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');

2098: close get_user_lang;
2099:
2100: --set the applicant pref language to the session
2101: if l_current_set_lang <> l_apl_lang then
2102: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');
2103: l_current_set_lang := l_apl_lang;
2104: end if;
2105:
2106: -- build subject message for applicant

Line 2159: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');

2155: close get_user_lang;
2156:
2157: -- set the pref language of Manager to the session */
2158: if l_current_set_lang <> l_mgr_lang then
2159: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');
2160: l_current_set_lang := l_mgr_lang;
2161: end if;
2162:
2163: hr_utility.set_location('l_last_updated_by' || l_last_updated_by, 20);

Line 2283: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

2279: resultout:='COMPLETE';
2280: hr_utility.set_location(' Leaving:'||l_proc, 160);
2281: --Reset applicantion's current session Language
2282: if l_intial_set_lang <> l_current_set_lang then
2283: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
2284: end if;
2285:
2286: exception
2287: when others then

Line 2288: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

2284: end if;
2285:
2286: exception
2287: when others then
2288: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
2289:
2290: --
2291: END send_withdrawal_notification;
2292: --

Line 2478: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');

2474: close get_user_lang;
2475:
2476: --set the applicant pref language to the session
2477: if l_current_set_lang <> l_apl_lang then
2478: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_apl_lang||'''');
2479: l_current_set_lang := l_apl_lang;
2480: end if;
2481:
2482:

Line 2536: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');

2532: close get_user_lang;
2533:
2534: -- set the pref language of Manager to the session */
2535: if l_current_set_lang <> l_mgr_lang then
2536: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_mgr_lang||'''');
2537: l_current_set_lang := l_mgr_lang;
2538: end if;
2539:
2540: -- build subject message for manager

Line 2632: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

2628: hr_utility.set_location(' Leaving:'||l_proc, 160);
2629:
2630: --Reset applicantion's current session Language
2631: if l_intial_set_lang <> l_current_set_lang then
2632: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
2633: end if;
2634:
2635: --- before end of proc
2636: exception

Line 2638: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');

2634:
2635: --- before end of proc
2636: exception
2637: when others then
2638: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',''''||l_intial_set_lang||'''');
2639:
2640: --
2641: END send_dcln_acptd_offer_notif;
2642: