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_ATA_NEW_PUB dependencies on FND_PROFILE

Line 149: FROM FND_PROFILE_OPTION_VALUES VAL,

145: PARTY_ID,
146: TERR_ID)
147: ( SELECT DISTINCT USERS.EMPLOYEE_ID,
148: VAL.PROFILE_OPTION_VALUE,-1,-1
149: FROM FND_PROFILE_OPTION_VALUES VAL,
150: FND_PROFILE_OPTIONS OPTIONS,
151: FND_USER USERS
152: WHERE VAL.LEVEL_ID = 10004
153: AND USERS.EMPLOYEE_ID is not null

Line 150: FND_PROFILE_OPTIONS OPTIONS,

146: TERR_ID)
147: ( SELECT DISTINCT USERS.EMPLOYEE_ID,
148: VAL.PROFILE_OPTION_VALUE,-1,-1
149: FROM FND_PROFILE_OPTION_VALUES VAL,
150: FND_PROFILE_OPTIONS OPTIONS,
151: FND_USER USERS
152: WHERE VAL.LEVEL_ID = 10004
153: AND USERS.EMPLOYEE_ID is not null
154: AND VAL.PROFILE_OPTION_VALUE is not null

Line 449: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');

445: IF p_trans_id = -1002 THEN
446: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);
447: l_program_name := 'SALES/ACCOUNT PROGRAM';
448: l_con_req_name :='ASXGARAC';
449: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
450: l_entity := ': ACCOUNT :';
451: ELSIF p_trans_id = -1003 THEN
452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
453: l_program_name := 'SALES/LEAD PROGRAM';

Line 455: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');

451: ELSIF p_trans_id = -1003 THEN
452: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
453: l_program_name := 'SALES/LEAD PROGRAM';
454: l_con_req_name :='ASXGARLD';
455: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
456: l_entity := ' : LEAD : ';
457: ELSIF p_trans_id = -1004 THEN
458: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
459: l_program_name := 'SALES/OPPORTUNITY PROGRAM';

Line 461: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');

457: ELSIF p_trans_id = -1004 THEN
458: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
459: l_program_name := 'SALES/OPPORTUNITY PROGRAM';
460: l_con_req_name :='ASXGAROP';
461: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
462: l_entity := ' : OPPORTUNITY : ';
463: ELSIF p_trans_id = -1105 THEN
464: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
465: l_program_name := 'SALES/QUOTE PROGRAM';

Line 467: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');

463: ELSIF p_trans_id = -1105 THEN
464: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
465: l_program_name := 'SALES/QUOTE PROGRAM';
466: l_con_req_name :='ASXGARQT';
467: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
468: l_entity := ' : QUOTE : ';
469: ELSIF p_trans_id = -1106 THEN
470: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
471: l_program_name := 'SALES/PROPOSAL PROGRAM';

Line 473: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');

469: ELSIF p_trans_id = -1106 THEN
470: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
471: l_program_name := 'SALES/PROPOSAL PROGRAM';
472: l_con_req_name :='ASXGARPR';
473: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');
474: l_entity := ' : PROPOSAL : ';
475: END IF;
476: IF l_prof_no_of_workers >10 then
477: l_prof_no_of_workers := 10;

Line 646: l_var := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);

642: DEADLOCK_DETECTED EXCEPTION;
643: PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
644:
645: BEGIN
646: l_var := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
647: l_MAX_fetches := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
648: LOOP --{L1
649: IF (l_limit_flag) THEN EXIT; END IF;
650: l_loop_count := l_loop_count + 1;

Line 647: l_MAX_fetches := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);

643: PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
644:
645: BEGIN
646: l_var := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
647: l_MAX_fetches := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
648: LOOP --{L1
649: IF (l_limit_flag) THEN EXIT; END IF;
650: l_loop_count := l_loop_count + 1;
651: BEGIN