APPS.IEX_GAR_PUB dependencies on FND_PROFILE

Line 144: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);

140: END IF;
141: --Bug5043777. Fix By LKKUMAR. End.
142:
143:
144: l_percent_analysed :=nvl(TO_NUMBER(fnd_profile.value('IEX_TAP_PERCENT_ANALYSED')),20);
145: IF p_run_mode = IEX_ATA_PUB.G_TOTAL_MODE THEN
146: l_target_type := 'TOTAL';
147: ELSIF p_run_mode = IEX_ATA_PUB.G_NEW_MODE THEN
148: l_target_type := 'INCREMENTAL';

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

332: --px_terr_globals.prev_request_id := p_prev_request_id;
333:
334: px_terr_globals.sequence := p_seq_num;
335:
336: px_terr_globals.bulk_size:= nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
337:
338: /*** Not needed now
339: if px_terr_globals.bulk_size < 10000 then
340: px_terr_globals.bulk_size:= 10000;

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

347: EXECUTE IMMEDIATE l_temp;
348: END IF;
349:
350: begin
351: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,G_CURSOR_LIMIT);
352: if px_terr_globals.cursor_limit < 1 then
353: px_terr_globals.cursor_limit := G_CURSOR_LIMIT;
354: end if;
355: exception

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

358: end;
359:
360:
361: -- get profile option - USER_ID
362: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
363:
364: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
365:
366: -- get profile option -- CONC_PROGRAM_ID

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

363:
364: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
365:
366: -- get profile option -- CONC_PROGRAM_ID
367: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
368:
369: -- get profile option -- CONC_LOGIN_ID
370: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
371:

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

366: -- get profile option -- CONC_PROGRAM_ID
367: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
368:
369: -- get profile option -- CONC_LOGIN_ID
370: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
371:
372: -- get profile option -- CONC_REQUEST_ID
373: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
374:

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

369: -- get profile option -- CONC_LOGIN_ID
370: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
371:
372: -- get profile option -- CONC_REQUEST_ID
373: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
374:
375: -- If request_id = 0, select directly from sequence
376: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
377: THEN

Line 387: px_terr_globals.disable_lead_processing := FND_PROFILE.Value('AS_DISABLE_BATCH_LEAD_TERR_ASSIGNMENT') ;

383: -- Get the profile option for AS_ENABLE_DUPS_RS_DELETION
384: -- OS: Enable Duplicate Resource Deletion
385: -- For Now this is asssumed to be 'Y'
386: px_terr_globals.enable_dups_rs_del := 'Y';
387: px_terr_globals.disable_lead_processing := FND_PROFILE.Value('AS_DISABLE_BATCH_LEAD_TERR_ASSIGNMENT') ;
388:
389: IF p_run_mode = 'RESTART' THEN
390: --Fetch the p_prev_request_id from JTF_TAE_1001_ACCOUNT_TRANS
391: begin