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

Line 113: FROM FND_PROFILE_OPTION_VALUES VAL,

109: PARTY_ID,
110: TERR_ID)
111: ( SELECT DISTINCT USERS.EMPLOYEE_ID,
112: VAL.PROFILE_OPTION_VALUE,-1,-1
113: FROM FND_PROFILE_OPTION_VALUES VAL,
114: FND_PROFILE_OPTIONS OPTIONS,
115: FND_USER USERS
116: WHERE VAL.LEVEL_ID = 10004
117: AND USERS.EMPLOYEE_ID is not null

Line 114: FND_PROFILE_OPTIONS OPTIONS,

110: TERR_ID)
111: ( SELECT DISTINCT USERS.EMPLOYEE_ID,
112: VAL.PROFILE_OPTION_VALUE,-1,-1
113: FROM FND_PROFILE_OPTION_VALUES VAL,
114: FND_PROFILE_OPTIONS OPTIONS,
115: FND_USER USERS
116: WHERE VAL.LEVEL_ID = 10004
117: AND USERS.EMPLOYEE_ID is not null
118: AND VAL.PROFILE_OPTION_VALUE is not null

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

417: IF p_trans_id = -1002 THEN
418: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_ACCOUNT || AS_GAR.G_START);
419: l_program_name := 'SALES/ACCOUNT PROGRAM';
420: l_con_req_name :='ASXGARAC';
421: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_ACCOUNT_WORKERS');
422: l_entity := ': ACCOUNT :';
423: ELSIF p_trans_id = -1003 THEN
424: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
425: l_program_name := 'SALES/LEAD PROGRAM';

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

423: ELSIF p_trans_id = -1003 THEN
424: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_LEAD || AS_GAR.G_START);
425: l_program_name := 'SALES/LEAD PROGRAM';
426: l_con_req_name :='ASXGARLD';
427: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_LEAD_WORKERS');
428: l_entity := ' : LEAD : ';
429: ELSIF p_trans_id = -1004 THEN
430: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
431: l_program_name := 'SALES/OPPORTUNITY PROGRAM';

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

429: ELSIF p_trans_id = -1004 THEN
430: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_OPPTY || AS_GAR.G_START);
431: l_program_name := 'SALES/OPPORTUNITY PROGRAM';
432: l_con_req_name :='ASXGAROP';
433: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_OPPOR_WORKERS');
434: l_entity := ' : OPPORTUNITY : ';
435: ELSIF p_trans_id = -1105 THEN
436: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
437: l_program_name := 'SALES/QUOTE PROGRAM';

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

435: ELSIF p_trans_id = -1105 THEN
436: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_QUOTE || AS_GAR.G_START);
437: l_program_name := 'SALES/QUOTE PROGRAM';
438: l_con_req_name :='ASXGARQT';
439: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_QUOTE_WORKERS');
440: l_entity := ' : QUOTE : ';
441: ELSIF p_trans_id = -1106 THEN
442: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
443: l_program_name := 'SALES/PROPOSAL PROGRAM';

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

441: ELSIF p_trans_id = -1106 THEN
442: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || G_PR_PROPOSAL || AS_GAR.G_START);
443: l_program_name := 'SALES/PROPOSAL PROGRAM';
444: l_con_req_name :='ASXGARPR';
445: l_prof_no_of_workers := fnd_profile.value('AS_TAP_NUM_CHILD_PROPOSAL_WORKERS');
446: l_entity := ' : PROPOSAL : ';
447: END IF;
448: IF l_prof_no_of_workers >10 then
449: l_prof_no_of_workers := 10;

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

555: G_DEL_REC CONSTANT NUMBER:=10001;
556: l_status BOOLEAN;
557:
558: BEGIN
559: l_var := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
560: l_MAX_fetches := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
561: LOOP --{L1
562: IF (l_limit_flag) THEN EXIT; END IF;
563: l_loop_count := l_loop_count + 1;

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

556: l_status BOOLEAN;
557:
558: BEGIN
559: l_var := nvl(to_number(fnd_profile.value('AS_BULK_COMMIT_SIZE')),10000);
560: l_MAX_fetches := nvl(to_number(fnd_profile.value('AS_TERR_RECORDS_TO_OPEN')) ,10000);
561: LOOP --{L1
562: IF (l_limit_flag) THEN EXIT; END IF;
563: l_loop_count := l_loop_count + 1;
564: BEGIN