APPS.IEX_GAR_PUB dependencies on FND_PROFILE

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

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

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

320: --px_terr_globals.prev_request_id := p_prev_request_id;
321:
322: px_terr_globals.sequence := p_seq_num;
323:
324: px_terr_globals.bulk_size:= nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
325:
326: /*** Not needed now
327: if px_terr_globals.bulk_size < 10000 then
328: px_terr_globals.bulk_size:= 10000;

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

335: EXECUTE IMMEDIATE l_temp;
336: END IF;
337:
338: begin
339: px_terr_globals.cursor_limit := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,G_CURSOR_LIMIT);
340: if px_terr_globals.cursor_limit < 1 then
341: px_terr_globals.cursor_limit := G_CURSOR_LIMIT;
342: end if;
343: exception

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

346: end;
347:
348:
349: -- get profile option - USER_ID
350: px_terr_globals.user_id := to_number(fnd_profile.value('USER_ID'));
351:
352: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
353:
354: -- get profile option -- CONC_PROGRAM_ID

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

351:
352: px_terr_globals.prog_appl_id := FND_GLOBAL.PROG_APPL_ID;
353:
354: -- get profile option -- CONC_PROGRAM_ID
355: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
356:
357: -- get profile option -- CONC_LOGIN_ID
358: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
359:

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

354: -- get profile option -- CONC_PROGRAM_ID
355: px_terr_globals.prog_id := to_number(fnd_profile.value('CONC_PROGRAM_ID'));
356:
357: -- get profile option -- CONC_LOGIN_ID
358: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
359:
360: -- get profile option -- CONC_REQUEST_ID
361: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
362:

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

357: -- get profile option -- CONC_LOGIN_ID
358: px_terr_globals.last_update_login := to_number(fnd_profile.value('CONC_LOGIN_ID'));
359:
360: -- get profile option -- CONC_REQUEST_ID
361: px_terr_globals.request_id := to_number(fnd_profile.value('CONC_REQUEST_ID'));
362:
363: -- If request_id = 0, select directly from sequence
364: IF px_terr_globals.request_id = 0 OR px_terr_globals.request_id IS NULL
365: THEN

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

371: -- Get the profile option for AS_ENABLE_DUPS_RS_DELETION
372: -- OS: Enable Duplicate Resource Deletion
373: -- For Now this is asssumed to be 'Y'
374: px_terr_globals.enable_dups_rs_del := 'Y';
375: px_terr_globals.disable_lead_processing := FND_PROFILE.Value('AS_DISABLE_BATCH_LEAD_TERR_ASSIGNMENT') ;
376:
377: IF p_run_mode = 'RESTART' THEN
378: --Fetch the p_prev_request_id from JTF_TAE_1001_ACCOUNT_TRANS
379: begin