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.CSR_SCHEDULER_PVT dependencies on FND_PROFILE

Line 7: g_likelihood CONSTANT NUMBER := fnd_profile.VALUE('CSF_DEFAULT_SPARES_AVAIL');

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSR_SCHEDULER_PVT';
5: g_csr_appl_id CONSTANT NUMBER := 698;
6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7: g_likelihood CONSTANT NUMBER := fnd_profile.VALUE('CSF_DEFAULT_SPARES_AVAIL');
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_CONTRACTS'), 'N');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_INSTALLED_BASE'), 'N');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_SKILLS'), 'Y');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_TERRITORIES'), 'Y');

Line 8: g_auto_contract_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_CONTRACTS'), 'N');

4: g_pkg_name CONSTANT VARCHAR2(30) := 'CSR_SCHEDULER_PVT';
5: g_csr_appl_id CONSTANT NUMBER := 698;
6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7: g_likelihood CONSTANT NUMBER := fnd_profile.VALUE('CSF_DEFAULT_SPARES_AVAIL');
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_CONTRACTS'), 'N');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_INSTALLED_BASE'), 'N');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_SKILLS'), 'Y');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_TERRITORIES'), 'Y');
12:

Line 9: g_auto_ib_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_INSTALLED_BASE'), 'N');

5: g_csr_appl_id CONSTANT NUMBER := 698;
6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7: g_likelihood CONSTANT NUMBER := fnd_profile.VALUE('CSF_DEFAULT_SPARES_AVAIL');
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_CONTRACTS'), 'N');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_INSTALLED_BASE'), 'N');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_SKILLS'), 'Y');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_TERRITORIES'), 'Y');
12:
13: TYPE ref_cursor_type IS REF CURSOR;

Line 10: g_auto_skills_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_SKILLS'), 'Y');

6: g_conc_program_name CONSTANT VARCHAR2(30) := 'SEARCH_AND_SCHEDULE_AUTO';
7: g_likelihood CONSTANT NUMBER := fnd_profile.VALUE('CSF_DEFAULT_SPARES_AVAIL');
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_CONTRACTS'), 'N');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_INSTALLED_BASE'), 'N');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_SKILLS'), 'Y');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_TERRITORIES'), 'Y');
12:
13: TYPE ref_cursor_type IS REF CURSOR;
14:

Line 11: g_auto_terr_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_TERRITORIES'), 'Y');

7: g_likelihood CONSTANT NUMBER := fnd_profile.VALUE('CSF_DEFAULT_SPARES_AVAIL');
8: g_auto_contract_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_CONTRACTS'), 'N');
9: g_auto_ib_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_INSTALLED_BASE'), 'N');
10: g_auto_skills_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_SKILLS'), 'Y');
11: g_auto_terr_flag CONSTANT VARCHAR2(1) := NVL(fnd_profile.value('CSR:CSR_AUTO_TERRITORIES'), 'Y');
12:
13: TYPE ref_cursor_type IS REF CURSOR;
14:
15:

Line 206: fnd_profile.get('SERVER_TIMEZONE', l_timezone_id);

202: */
203: FUNCTION get_server_timezone RETURN NUMBER IS
204: l_timezone_id NUMBER;
205: BEGIN
206: fnd_profile.get('SERVER_TIMEZONE', l_timezone_id);
207: IF l_timezone_id IS NULL THEN
208: fnd_profile.get('SERVER_TIMEZONE_ID', l_timezone_id);
209: END IF;
210:

Line 208: fnd_profile.get('SERVER_TIMEZONE_ID', l_timezone_id);

204: l_timezone_id NUMBER;
205: BEGIN
206: fnd_profile.get('SERVER_TIMEZONE', l_timezone_id);
207: IF l_timezone_id IS NULL THEN
208: fnd_profile.get('SERVER_TIMEZONE_ID', l_timezone_id);
209: END IF;
210:
211: IF l_timezone_id IS NULL THEN
212: SELECT MIN(timezone_id)