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

Line 48: px_terr_globals.bulk_size := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);

44: -- Set the Global variables
45:
46: px_terr_globals.run_mode := p_run_mode;
47: px_terr_globals.worker_id :=p_worker_id;
48: px_terr_globals.bulk_size := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
49: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
51: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));

Line 49: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);

45:
46: px_terr_globals.run_mode := p_run_mode;
47: px_terr_globals.worker_id :=p_worker_id;
48: px_terr_globals.bulk_size := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
49: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
51: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
53: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));

Line 50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));

46: px_terr_globals.run_mode := p_run_mode;
47: px_terr_globals.worker_id :=p_worker_id;
48: px_terr_globals.bulk_size := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
49: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
51: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
53: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
54: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));

Line 52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));

48: px_terr_globals.bulk_size := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
49: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
51: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
53: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
54: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
55:
56: -- If request_id = 0, select directly from sequence

Line 53: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));

49: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
51: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
53: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
54: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
55:
56: -- If request_id = 0, select directly from sequence
57: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL

Line 54: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));

50: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
51: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
52: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
53: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
54: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
55:
56: -- If request_id = 0, select directly from sequence
57: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
58: THEN

Line 228: sort_size := fnd_profile.value('AS_SORT_AREA_SIZE_FOR_TAP');

224: s number;
225:
226: BEGIN
227: -- Alter session to set sort area size and hash area size
228: sort_size := fnd_profile.value('AS_SORT_AREA_SIZE_FOR_TAP');
229: IF sort_size is not NULL and sort_size > 0 THEN
230: st := 'ALTER SESSION SET SORT_AREA_SIZE = ' || sort_size;
231: EXECUTE IMMEDIATE st;
232: select value into s from V$PARAMETER where name = 'sort_area_size';

Line 236: hash_size := fnd_profile.value('AS_HASH_AREA_SIZE_FOR_TAP');

232: select value into s from V$PARAMETER where name = 'sort_area_size';
233: AS_GAR.LOG( AS_GAR.G_SETAREASIZE || AS_GAR.G_PROCESS ||' Sort Area Size' || s);
234: END IF;
235:
236: hash_size := fnd_profile.value('AS_HASH_AREA_SIZE_FOR_TAP');
237: IF hash_size is not NULL and hash_size > 0 THEN
238: st := 'ALTER SESSION SET HASH_AREA_SIZE = ' || hash_size;
239: EXECUTE IMMEDIATE st;
240: select value into s from V$PARAMETER where name = 'hash_area_size';