DBA Data[Home] [Help]

APPS.FND_REQUEST dependencies on FND_PROFILE

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

202: program_priority number;
203: profile_priority_char varchar2(3);
204: profile_priority_number number;
205: begin
206: FND_PROFILE.GET ('CONC_PRIORITY', profile_priority_char);
207: profile_priority_number := to_number(profile_priority_char);
208:
209: Select min(nvl(request_priority, profile_priority_number))
210: Into program_priority

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

652: if (resp_appl_id is null) then
653: resp_appl_id := -1;
654: end if;
655:
656: FND_PROFILE.GET ('CONC_HOLD', hold_flag);
657: if (hold_flag is null) then
658: hold_flag := 'N';
659: end if;
660:

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

657: if (hold_flag is null) then
658: hold_flag := 'N';
659: end if;
660:
661: FND_PROFILE.GET ('CONC_SINGLE_THREAD', st_flag);
662: if (st_flag is null) then
663: st_flag := 'N';
664: else
665: st_flag := substr (st_flag, 1, 1);

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

665: st_flag := substr (st_flag, 1, 1);
666: end if;
667:
668: profile_buffer := NULL;
669: FND_PROFILE.GET ('CONC_REQUEST_THRESHOLD_LEVEL', profile_buffer);
670: if ( profile_buffer is null) then
671: request_threshold := -1;
672: else
673: request_threshold := To_Number (profile_buffer);

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

673: request_threshold := To_Number (profile_buffer);
674: end if;
675:
676: profile_buffer := NULL;
677: FND_PROFILE.GET ('CONC_REQUEST_LIMIT', profile_buffer);
678: if ( profile_buffer is null) then
679: req_limit := 'N';
680: elsif (To_Number(profile_buffer) >= 0 and (P_REQUEST_TYPE IS NULL or P_REQUEST_TYPE <> 'S')) then
681: req_limit := 'Y';

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

682: else
683: req_limit := 'N';
684: end if;
685:
686: FND_PROFILE.GET ('CONC_STATUS', req_status);
687: if (req_status = 'HOLD') then
688: status := 'A';
689: elsif (sub_request) then
690: status := 'Z';

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

690: status := 'Z';
691: end if;
692:
693: profile_buffer := NULL;
694: FND_PROFILE.GET('CONC_MULTI_TZ', profile_buffer);
695:
696: if (profile_buffer in ('Y', 'y')) then
697: tz_offset := 1;
698: else

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

700: end if;
701:
702: profile_buffer := NULL;
703: if (start_time is null) then
704: FND_PROFILE.GET ('CONC_REQ_START', profile_buffer);
705: else
706: profile_buffer := start_time;
707: end if;
708:

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

796: end;
797: end if;
798:
799: if (P_PRINT_TOGETHER is NULL) then
800: FND_PROFILE.GET ('CONC_PRINT_TOGETHER', profile_buffer);
801: if (substr (profile_buffer, 1, 1) = 'Y') then
802: P_PRINT_TOGETHER := 'Y';
803: else
804: P_PRINT_TOGETHER := 'N';

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

888: -- NLS Project : Default NLS Numeric Characters
889: -- VENKAT: indicates we want it to be NULL to start and it will be set
890: -- by the Terrirtory default.
891: -- if (P_NUMERIC_CHARACTERS is NULL) then
892: -- fnd_profile.get('ICX_NUMERIC_CHARACTERS', P_NUMERIC_CHARACTERS);
893: -- end if;
894:
895: -- Get program's application ID, Concurrent Program Id, cd_param, Printer, Print Style,
896: -- Get program's application ID, Concurrent Program Id, cd_param, Printer, Print Style,

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

960: end if;
961:
962: if (program_priority is null) then
963: profile_buffer := NULL;
964: FND_PROFILE.GET ('CONC_PRIORITY', profile_buffer);
965: priority := to_number(profile_buffer);
966: else
967: priority := program_priority;
968: end if;

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

973: if (P_SAVE_OUTPUT in ('Y', 'N')) then
974: saveout := P_SAVE_OUTPUT;
975: else
976: if (not saveout in ('Y', 'N')) then
977: FND_PROFILE.GET ('CONC_SAVE_OUTPUT', profile_buffer);
978: if (not profile_buffer in ('Y', 'N')) then
979: saveout := 'Y';
980: else
981: saveout := profile_buffer;

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

989:
990: -- Printer logic
991:
992: -- Get default for # of copies
993: FND_PROFILE.GET ('CONC_COPIES', profile_buffer);
994: if (profile_buffer is not null) then
995: default_copies := To_Number (profile_buffer);
996: if (default_copies < 0) then
997: default_copies := 0;

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

1001: end if;
1002:
1003: -- Is printer specified in FCP?
1004: if (fcp_printer is null) then
1005: FND_PROFILE.GET ('PRINTER', default_printer);
1006: else
1007: default_printer := fcp_printer;
1008: end if;
1009:

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

1123: -- (don't print on failure, print on warning only if
1124: -- CONC_PRINT_WARNING is set to 'Y')
1125:
1126: profile_buffer := NULL;
1127: FND_PROFILE.GET ('CONC_PRINT_WARNING', profile_buffer);
1128: if (profile_buffer is not null and
1129: profile_buffer in ('y', 'Y')) then
1130: print_warning := 'Y';
1131: end if;

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

1663:
1664: -- Next try profile
1665: if (cd_id = -1) then
1666: profile_buffer := NULL;
1667: FND_PROFILE.GET ('CONC_CD_ID', profile_buffer);
1668: if (profile_buffer is not null) then
1669: cd_id := To_Number (profile_buffer);
1670: else
1671: cd_id := 0;

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

2508:
2509:
2510: -- Insert Printers
2511: if (FCP_PRINTER is null) then
2512: FND_PROFILE.GET ('PRINTER', default_printer);
2513: else
2514: default_printer := fcp_printer;
2515: end if;
2516:

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

2513: else
2514: default_printer := fcp_printer;
2515: end if;
2516:
2517: FND_PROFILE.GET ('CONC_COPIES', profile_buffer);
2518: if (profile_buffer is not null) then
2519: default_copies := To_Number (profile_buffer);
2520: if (default_copies < 0) then
2521: default_copies := 0;