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

Line 10: from fnd_profile_options

6:
7: FUNCTION get_value_at_site_level(pname IN VARCHAR2) RETURN VARCHAR2 IS
8: CURSOR c_profile_info(pname VARCHAR2) IS
9: select profile_option_id, application_id
10: from fnd_profile_options
11: where profile_option_name = upper(pname)
12: and start_date_active <= sysdate
13: and nvl(end_date_active, sysdate) >= sysdate;
14:

Line 17: from fnd_profile_option_values

13: and nvl(end_date_active, sysdate) >= sysdate;
14:
15: CURSOR c_profile_value(pid number, aid number, lid number, lval number) IS
16: select profile_option_value
17: from fnd_profile_option_values
18: where profile_option_id = pid
19: and application_id = aid
20: and level_id = lid
21: and level_value = lval;

Line 59: return nvl(to_number(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_HIGH'),'999999999999999.9999999999999'), 0.5);

55:
56: FUNCTION HIGH return number IS
57: BEGIN
58: BIS_COLLECTION_UTILITIES.put_line('within HIGH');
59: return nvl(to_number(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_HIGH'),'999999999999999.9999999999999'), 0.5);
60: END;
61:
62: FUNCTION MEDIUM return number IS
63: BEGIN

Line 65: return nvl(to_number(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_MEDIUM'),'999999999999999.9999999999999'),1.0);

61:
62: FUNCTION MEDIUM return number IS
63: BEGIN
64: BIS_COLLECTION_UTILITIES.put_line('within MEDIUM');
65: return nvl(to_number(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_MEDIUM'),'999999999999999.9999999999999'),1.0);
66: END;
67:
68: FUNCTION LOW return number IS
69: BEGIN

Line 71: return nvl(to_number(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_LOW'),'999999999999999.9999999999999'), 2.0);

67:
68: FUNCTION LOW return number IS
69: BEGIN
70: BIS_COLLECTION_UTILITIES.put_line('within LOW');
71: return nvl(to_number(FND_PROFILE.VALUE('BIS_TXN_COMPLEXITY_LOW'),'999999999999999.9999999999999'), 2.0);
72: END;
73:
74:
75:

Line 79: ---l_rate_type:=fnd_profile.value('BIS_PRIMARY_RATE_TYPE');

75:
76: FUNCTION get_rate_type RETURN varchar2 is
77: l_rate_type varchar2(30);
78: begin
79: ---l_rate_type:=fnd_profile.value('BIS_PRIMARY_RATE_TYPE');
80: l_rate_type:=get_value_at_site_level('BIS_PRIMARY_RATE_TYPE');
81: return l_rate_type;
82: exception
83: when no_data_found then

Line 93: ---l_second_rate_type:=fnd_profile.value('BIS_SECONDARY_RATE_TYPE');

89:
90: FUNCTION get_secondary_rate_type return varchar2 is
91: l_second_rate_type varchar2(30);
92: begin
93: ---l_second_rate_type:=fnd_profile.value('BIS_SECONDARY_RATE_TYPE');
94: l_second_rate_type:=get_value_at_site_level('BIS_SECONDARY_RATE_TYPE');
95: return l_second_rate_type;
96: exception
97: when no_data_found then

Line 107: --l_currency_code:=fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');

103:
104: function get_currency_code return varchar2 is
105: l_currency_code varchar2(15);
106: begin
107: --l_currency_code:=fnd_profile.value('BIS_PRIMARY_CURRENCY_CODE');
108: l_currency_code:=get_value_at_site_level('BIS_PRIMARY_CURRENCY_CODE');
109: return l_currency_code;
110: exception
111: when no_data_found then

Line 121: --- l_second_curr_code:=fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');

117:
118: function get_secondary_currency_code return varchar2 is
119: l_second_curr_code varchar2(15);
120: begin
121: --- l_second_curr_code:=fnd_profile.value('BIS_SECONDARY_CURRENCY_CODE');
122: l_second_curr_code:=get_value_at_site_level('BIS_SECONDARY_CURRENCY_CODE');
123: return l_second_curr_code;
124: exception
125: when no_data_found then

Line 136: --- l_period_set_name:=fnd_profile.value('BIS_ENTERPRISE_CALENDAR');

132:
133: function get_period_set_name return varchar2 is
134: l_period_set_name varchar2(15);
135: begin
136: --- l_period_set_name:=fnd_profile.value('BIS_ENTERPRISE_CALENDAR');
137: l_period_set_name:=get_value_at_site_level('BIS_ENTERPRISE_CALENDAR');
138: return l_period_set_name;
139: exception
140: when no_data_found then

Line 151: ---l_start_dayofweek:=fnd_profile.value('BIS_START_DAY_OF_WEEK');

147:
148: function get_START_DAY_OF_WEEK_ID return varchar2 is
149: l_start_dayofweek varchar2(30);
150: begin
151: ---l_start_dayofweek:=fnd_profile.value('BIS_START_DAY_OF_WEEK');
152: l_start_dayofweek:=get_value_at_site_level('BIS_START_DAY_OF_WEEK');
153: return l_start_dayofweek;
154: exception
155: when no_data_found then

Line 165: ---l_period_type:=fnd_profile.value('BIS_PERIOD_TYPE');

161:
162: function get_period_type return varchar2 is
163: l_period_type varchar2(15);
164: begin
165: ---l_period_type:=fnd_profile.value('BIS_PERIOD_TYPE');
166: l_period_type:=get_value_at_site_level('BIS_PERIOD_TYPE');
167: return l_period_type;
168: exception
169: when no_data_found then

Line 179: -- l_workforce_mes_type_id:=fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');

175:
176: function get_workforce_mes_type_id return varchar2 is
177: l_workforce_mes_type_id varchar2(30);
178: begin
179: -- l_workforce_mes_type_id:=fnd_profile.value('BIS_WORKFORCE_MEASUREMENT_TYPE');
180: l_workforce_mes_type_id:=get_value_at_site_level('BIS_WORKFORCE_MEASUREMENT_TYPE');
181: return l_workforce_mes_type_id;
182: exception
183: when no_data_found then

Line 193: ---l_get_auto_factor_mode:=fnd_profile.value('BIS_AUTO_FACTOR');

189:
190: function get_auto_factor_mode return varchar2 is
191: l_get_auto_factor_mode varchar2(30);
192: begin
193: ---l_get_auto_factor_mode:=fnd_profile.value('BIS_AUTO_FACTOR');
194: l_get_auto_factor_mode:=get_value_at_site_level('BIS_AUTO_FACTOR');
195: return l_get_auto_factor_mode;
196: exception
197: when no_data_found then

Line 208: ---l_ITM_HRCHY3_VBH_TOP_NODE:=fnd_profile.value('BIS_ITEM_HIERARCHY3_VBH_TOP_NODE');

204:
205: function get_ITM_HRCHY3_VBH_TOP_NODE return varchar2 is
206: l_ITM_HRCHY3_VBH_TOP_NODE varchar2(150);
207: begin
208: ---l_ITM_HRCHY3_VBH_TOP_NODE:=fnd_profile.value('BIS_ITEM_HIERARCHY3_VBH_TOP_NODE');
209: l_ITM_HRCHY3_VBH_TOP_NODE:=get_value_at_site_level('BIS_ITEM_HIERARCHY3_VBH_TOP_NODE');
210: return l_ITM_HRCHY3_VBH_TOP_NODE;
211: exception
212: when no_data_found then

Line 222: -- l_global_start_date:=fnd_profile.value('BIS_GLOBAL_START_DATE');

218:
219: function get_GLOBAL_START_DATE return date is
220: l_global_start_date varchar2(30);
221: begin
222: -- l_global_start_date:=fnd_profile.value('BIS_GLOBAL_START_DATE');
223: l_global_start_date:=get_value_at_site_level('BIS_GLOBAL_START_DATE');
224: return to_date(l_global_start_date, 'mm/dd/yyyy');
225: exception
226: when no_data_found then

Line 235: --- l_implementation_type:=fnd_profile.value('BIS_IMPLEMENTATION_TYPE');

231:
232: function get_implementation_type return varchar2 is
233: l_implementation_type varchar2(30);
234: begin
235: --- l_implementation_type:=fnd_profile.value('BIS_IMPLEMENTATION_TYPE');
236: l_implementation_type:=get_value_at_site_level('BIS_IMPLEMENTATION_TYPE');
237: return l_implementation_type;
238: exception
239: when no_data_found then

Line 248: --l_item_category_set:=fnd_profile.value('BIS_ITEM_CATEGORY_SET_1');

244:
245: function get_item_category_set_1 return varchar2 is
246: l_item_category_set varchar2(30);
247: begin
248: --l_item_category_set:=fnd_profile.value('BIS_ITEM_CATEGORY_SET_1');
249: l_item_category_set:=get_value_at_site_level('BIS_ITEM_CATEGORY_SET_1');
250: return l_item_category_set;
251: exception
252: when no_data_found then

Line 262: --l_item_category_set:=fnd_profile.value('BIS_ITEM_CATEGORY_SET_2');

258:
259: function get_item_category_set_2 return varchar2 is
260: l_item_category_set varchar2(30);
261: begin
262: --l_item_category_set:=fnd_profile.value('BIS_ITEM_CATEGORY_SET_2');
263: l_item_category_set:=get_value_at_site_level('BIS_ITEM_CATEGORY_SET_2');
264: return l_item_category_set;
265: exception
266: when no_data_found then

Line 276: --l_item_category_set:=fnd_profile.value('BIS_ITEM_CATEGORY_SET_3');

272:
273: function get_item_category_set_3 return varchar2 is
274: l_item_category_set varchar2(30);
275: begin
276: --l_item_category_set:=fnd_profile.value('BIS_ITEM_CATEGORY_SET_3');
277: l_item_category_set:=get_value_at_site_level('BIS_ITEM_CATEGORY_SET_3');
278: return l_item_category_set;
279: exception
280: when no_data_found then

Line 290: --- l_item_org_catset:=fnd_profile.value('BIS_ITEM_ORG_CATEGORY_SET_1');

286:
287: function get_item_org_catset_1 return varchar2 is
288: l_item_org_catset varchar2(30);
289: begin
290: --- l_item_org_catset:=fnd_profile.value('BIS_ITEM_ORG_CATEGORY_SET_1');
291: l_item_org_catset:=get_value_at_site_level('BIS_ITEM_ORG_CATEGORY_SET_1');
292: return l_item_org_catset;
293: exception
294: when no_data_found then

Line 303: -- l_item_hierarchy3_type:=fnd_profile.value('BIS_ITEM_HIERARCHY3_TYPE');

299:
300: function get_item_hierarchy3_type return varchar2 is
301: l_item_hierarchy3_type varchar2(30);
302: begin
303: -- l_item_hierarchy3_type:=fnd_profile.value('BIS_ITEM_HIERARCHY3_TYPE');
304: l_item_hierarchy3_type:=get_value_at_site_level('BIS_ITEM_HIERARCHY3_TYPE');
305: return l_item_hierarchy3_type;
306: exception
307: when no_data_found then

Line 316: -- l_master_instance:=fnd_profile.value('BIS_MASTER_INSTANCE');

312:
313: function get_master_instance return varchar2 is
314: l_master_instance varchar2(30);
315: begin
316: -- l_master_instance:=fnd_profile.value('BIS_MASTER_INSTANCE');
317: l_master_instance:=get_value_at_site_level('BIS_MASTER_INSTANCE');
318: return l_master_instance;
319: exception
320: when no_data_found then

Line 379: l_temp := 'select upper(sql_validation) from fnd_profile_options where profile_option_name = UPPER(:name)';

375: return '';
376: end if;
377:
378: --get sqlvalidation
379: l_temp := 'select upper(sql_validation) from fnd_profile_options where profile_option_name = UPPER(:name)';
380: execute immediate l_temp into sqlvalidation using name;
381:
382: --if there is no sql validation, display value is same as internal value.
383: if (sqlvalidation is null) then

Line 448: p_attribute_values(l_count) := fnd_profile.value(l_profile_name);

444: ELSIF (l_profile_name = 'EDW_TRACE') THEN
445: l_profile_name := 'BIS_SQL_TRACE';
446: END IF;
447:
448: p_attribute_values(l_count) := fnd_profile.value(l_profile_name);
449:
450: EXIT WHEN l_count = p_parameter_list.last;
451: l_count := p_parameter_list.next(l_count);
452: END LOOP;

Line 488: IF (fnd_profile.value(l_profile_name) IS NULL) THEN

484: ELSIF (l_profile_name = 'EDW_TRACE') THEN
485: l_profile_name := 'BIS_SQL_TRACE';
486: END IF;
487:
488: IF (fnd_profile.value(l_profile_name) IS NULL) THEN
489:
490: l_profile_list := l_profile_list || l_profile_name;
491: l_return_value := false;
492: END IF;

Line 522: l_batch_size := nvl(FND_PROFILE.value('EDW_PUSH_SIZE'), 10000) * p_complexity_level;

518:
519: BEGIN
520: BIS_COLLECTION_UTILITIES.put_line('within get_batch_size');
521: IF (p_complexity_level > 0) THEN
522: l_batch_size := nvl(FND_PROFILE.value('EDW_PUSH_SIZE'), 10000) * p_complexity_level;
523: BIS_COLLECTION_UTILITIES.put_line('l_batch_size: '||l_batch_size);
524: ELSE
525: return 10000;
526: END IF;

Line 541: l_parallel := floor(fnd_profile.value('EDW_PARALLEL_SRC')); -- gets value of profile option

537: l_parallel number;
538: BEGIN
539:
540: l_parallel := null;
541: l_parallel := floor(fnd_profile.value('EDW_PARALLEL_SRC')); -- gets value of profile option
542:
543: /* Set by the customer, return this value */
544:
545: IF (l_parallel IS NOT NULL and l_parallel > 0) THEN

Line 580: --l_name := fnd_profile.value('BIS_PRIMARY_CURDISP_NAME'); -- gets value of profile option

576: function GET_PRIMARY_CURDIS_NAME return varchar2
577: is
578: l_name VARCHAR2(300) := null;
579: begin
580: --l_name := fnd_profile.value('BIS_PRIMARY_CURDISP_NAME'); -- gets value of profile option
581: l_name:=get_value_at_site_level('BIS_PRIMARY_CURDISP_NAME');
582: return l_name;
583: end;
584:

Line 589: --- l_name := fnd_profile.value('BIS_SECONDARY_CURDISP_NAME'); -- gets value of profile option

585: function GET_SECONDARY_CURDIS_NAME return varchar2
586: is
587: l_name VARCHAR2(300) := null;
588: begin
589: --- l_name := fnd_profile.value('BIS_SECONDARY_CURDISP_NAME'); -- gets value of profile option
590: l_name:=get_value_at_site_level('BIS_SECONDARY_CURDISP_NAME');
591: return l_name;
592: end;
593:

Line 615: ---l_annual_rate_type:=fnd_profile.value('BIS_ANNUALIZED_RATE_TYPE');

611:
612: FUNCTION get_annualized_rate_type return varchar2 is
613: l_annual_rate_type varchar2(30);
614: begin
615: ---l_annual_rate_type:=fnd_profile.value('BIS_ANNUALIZED_RATE_TYPE');
616: l_annual_rate_type:=get_value_at_site_level('BIS_ANNUALIZED_RATE_TYPE');
617: return l_annual_rate_type;
618: exception
619: when no_data_found then

Line 629: --- l_annual_curr_code:=fnd_profile.value('BIS_ANNUALIZED_CURRENCY_CODE');

625:
626: function get_annualized_currency_code return varchar2 is
627: l_annual_curr_code varchar2(15);
628: begin
629: --- l_annual_curr_code:=fnd_profile.value('BIS_ANNUALIZED_CURRENCY_CODE');
630: l_annual_curr_code:=get_value_at_site_level('BIS_ANNUALIZED_CURRENCY_CODE');
631: return l_annual_curr_code;
632: exception
633: when no_data_found then

Line 643: ---l__disp_name := fnd_profile.value('BIS_ANNUALIZED_CURDISP_NAME'); -- gets value of profile option

639: function GET_ANNUALIZED_CURDIS_NAME return varchar2
640: is
641: l__disp_name VARCHAR2(300);
642: begin
643: ---l__disp_name := fnd_profile.value('BIS_ANNUALIZED_CURDISP_NAME'); -- gets value of profile option
644: l__disp_name:=get_value_at_site_level('BIS_ANNUALIZED_CURDISP_NAME');
645: return l__disp_name;
646: exception
647: when no_data_found then

Line 691: ---l_treasury_rate_type := fnd_profile.value('BIS_TREASURY_RATE_TYPE'); -- gets value of profile option

687: RETURN VARCHAR2
688: IS
689: l_treasury_rate_type VARCHAR2(300);
690: BEGIN
691: ---l_treasury_rate_type := fnd_profile.value('BIS_TREASURY_RATE_TYPE'); -- gets value of profile option
692: l_treasury_rate_type:=get_value_at_site_level('BIS_TREASURY_RATE_TYPE');
693: RETURN l_treasury_rate_type;
694: EXCEPTION
695: when no_data_found then

Line 706: -- l_cust_class_type := fnd_profile.value('BIS_CUST_CLASS_TYPE'); -- gets value of profile option

702: RETURN VARCHAR2
703: IS
704: l_cust_class_type VARCHAR2(300);
705: BEGIN
706: -- l_cust_class_type := fnd_profile.value('BIS_CUST_CLASS_TYPE'); -- gets value of profile option
707: l_cust_class_type:= get_value_at_site_level('BIS_CUST_CLASS_TYPE'); -- gets value of profile option
708: RETURN l_cust_class_type;
709: EXCEPTION
710: when no_data_found then