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

Line 156: FND_PROFILE.GET ('CONC_PRIORITY', profile_priority_char);

152: program_priority number;
153: profile_priority_char varchar2(3);
154: profile_priority_number number;
155: begin
156: FND_PROFILE.GET ('CONC_PRIORITY', profile_priority_char);
157: profile_priority_number := to_number(profile_priority_char);
158:
159: Select min(nvl(request_priority, profile_priority_number))
160: Into program_priority

Line 607: FND_PROFILE.GET ('CONC_OPS_REQ_MODE', ops_req_mode);

603: if (resp_appl_id is null) then
604: resp_appl_id := -1;
605: end if;
606:
607: FND_PROFILE.GET ('CONC_OPS_REQ_MODE', ops_req_mode);
608: if (ops_req_mode is null) then
609: ops_req_mode:= 'EXPLICIT';
610: end if;
611:

Line 612: FND_PROFILE.GET ('CONC_HOLD', hold_flag);

608: if (ops_req_mode is null) then
609: ops_req_mode:= 'EXPLICIT';
610: end if;
611:
612: FND_PROFILE.GET ('CONC_HOLD', hold_flag);
613: if (hold_flag is null) then
614: hold_flag := 'N';
615: end if;
616:

Line 617: FND_PROFILE.GET ('CONC_SINGLE_THREAD', st_flag);

613: if (hold_flag is null) then
614: hold_flag := 'N';
615: end if;
616:
617: FND_PROFILE.GET ('CONC_SINGLE_THREAD', st_flag);
618: if (st_flag is null) then
619: st_flag := 'N';
620: else
621: st_flag := substr (st_flag, 1, 1);

Line 625: FND_PROFILE.GET ('CONC_REQUEST_THRESHOLD_LEVEL', profile_buffer);

621: st_flag := substr (st_flag, 1, 1);
622: end if;
623:
624: profile_buffer := NULL;
625: FND_PROFILE.GET ('CONC_REQUEST_THRESHOLD_LEVEL', profile_buffer);
626: if ( profile_buffer is null) then
627: request_threshold := -1;
628: else
629: request_threshold := To_Number (profile_buffer);

Line 633: FND_PROFILE.GET ('CONC_REQUEST_LIMIT', profile_buffer);

629: request_threshold := To_Number (profile_buffer);
630: end if;
631:
632: profile_buffer := NULL;
633: FND_PROFILE.GET ('CONC_REQUEST_LIMIT', profile_buffer);
634: if ( profile_buffer is null) then
635: req_limit := 'N';
636: elsif (To_Number(profile_buffer) >= 0 and (P_REQUEST_TYPE IS NULL or P_REQUEST_TYPE <> 'S')) then
637: req_limit := 'Y';

Line 642: FND_PROFILE.GET ('CONC_STATUS', req_status);

638: else
639: req_limit := 'N';
640: end if;
641:
642: FND_PROFILE.GET ('CONC_STATUS', req_status);
643: if (req_status = 'HOLD') then
644: status := 'A';
645: elsif (sub_request) then
646: status := 'Z';

Line 650: FND_PROFILE.GET('CONC_MULTI_TZ', profile_buffer);

646: status := 'Z';
647: end if;
648:
649: profile_buffer := NULL;
650: FND_PROFILE.GET('CONC_MULTI_TZ', profile_buffer);
651:
652: if (profile_buffer in ('Y', 'y')) then
653: tz_offset := 1;
654: else

Line 660: FND_PROFILE.GET ('CONC_REQ_START', profile_buffer);

656: end if;
657:
658: profile_buffer := NULL;
659: if (start_time is null) then
660: FND_PROFILE.GET ('CONC_REQ_START', profile_buffer);
661: else
662: profile_buffer := start_time;
663: end if;
664:

Line 756: FND_PROFILE.GET ('CONC_PRINT_TOGETHER', profile_buffer);

752: end;
753: end if;
754:
755: if (P_PRINT_TOGETHER is NULL) then
756: FND_PROFILE.GET ('CONC_PRINT_TOGETHER', profile_buffer);
757: if (substr (profile_buffer, 1, 1) = 'Y') then
758: P_PRINT_TOGETHER := 'Y';
759: else
760: P_PRINT_TOGETHER := 'N';

Line 832: -- fnd_profile.get('ICX_NUMERIC_CHARACTERS', P_NUMERIC_CHARACTERS);

828: -- NLS Project : Default NLS Numeric Characters
829: -- VENKAT: indicates we want it to be NULL to start and it will be set
830: -- by the Terrirtory default.
831: -- if (P_NUMERIC_CHARACTERS is NULL) then
832: -- fnd_profile.get('ICX_NUMERIC_CHARACTERS', P_NUMERIC_CHARACTERS);
833: -- end if;
834:
835: -- Get program's application ID, Concurrent Program Id, cd_param, Printer, Print Style,
836: -- Get program's application ID, Concurrent Program Id, cd_param, Printer, Print Style,

Line 905: FND_PROFILE.GET ('CONC_PRIORITY', profile_buffer);

901: end if;
902:
903: if (program_priority is null) then
904: profile_buffer := NULL;
905: FND_PROFILE.GET ('CONC_PRIORITY', profile_buffer);
906: priority := to_number(profile_buffer);
907: else
908: priority := program_priority;
909: end if;

Line 918: FND_PROFILE.GET ('CONC_SAVE_OUTPUT', profile_buffer);

914: if (P_SAVE_OUTPUT in ('Y', 'N')) then
915: saveout := P_SAVE_OUTPUT;
916: else
917: if (not saveout in ('Y', 'N')) then
918: FND_PROFILE.GET ('CONC_SAVE_OUTPUT', profile_buffer);
919: if (not profile_buffer in ('Y', 'N')) then
920: saveout := 'Y';
921: else
922: saveout := profile_buffer;

Line 931: FND_PROFILE.GET ('CONC_COPIES', profile_buffer);

927:
928: -- Printer logic
929:
930: -- Get default for # of copies
931: FND_PROFILE.GET ('CONC_COPIES', profile_buffer);
932: if (profile_buffer is not null) then
933: default_copies := To_Number (profile_buffer);
934: if (default_copies < 0) then
935: default_copies := 0;

Line 943: FND_PROFILE.GET ('PRINTER', default_printer);

939: end if;
940:
941: -- Is printer specified in FCP?
942: if (fcp_printer is null) then
943: FND_PROFILE.GET ('PRINTER', default_printer);
944: else
945: default_printer := fcp_printer;
946: end if;
947:

Line 1065: FND_PROFILE.GET ('CONC_PRINT_WARNING', profile_buffer);

1061: -- (don't print on failure, print on warning only if
1062: -- CONC_PRINT_WARNING is set to 'Y')
1063:
1064: profile_buffer := NULL;
1065: FND_PROFILE.GET ('CONC_PRINT_WARNING', profile_buffer);
1066: if (profile_buffer is not null and
1067: profile_buffer in ('y', 'Y')) then
1068: print_warning := 'Y';
1069: end if;

Line 1564: FND_PROFILE.GET ('CONC_CD_ID', profile_buffer);

1560:
1561: -- Next try profile
1562: if (cd_id = -1) then
1563: profile_buffer := NULL;
1564: FND_PROFILE.GET ('CONC_CD_ID', profile_buffer);
1565: if (profile_buffer is not null) then
1566: cd_id := To_Number (profile_buffer);
1567: else
1568: cd_id := 0;