44:
45: begin
46: hr_utility.set_location('Entering: '||l_proc,10);
47:
48: fnd_flex_val_api.set_session_mode('customer_data');
49: l_value_set_name := 'ICD_'||p_lookup_type;
50: l_description := 'ICD Value set for lookup type '||p_lookup_type;
51:
52: /* When creating a value set for a Lookup, always enable "POPLIST" option for Valueset
56: l_where_clause1 := 'where lookup_type = '''||P_LOOKUP_TYPE||''' and language = USERENV(''LANG'') AND view_application_id = '|| P_VIEW_APPLICATION_ID ||' AND security_group_id = ';
57: l_where_clause2 := ' fnd_global.lookup_security_group('''|| P_LOOKUP_TYPE ||''','||P_VIEW_APPLICATION_ID||') ORDER BY meaning';
58: l_where_clause := l_where_clause1 || l_where_clause2;
59:
60: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
61: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);
62: fnd_flex_val_api.create_valueset_table(
63: /* basic parameters */
64: value_set_name => l_value_set_name,
58: l_where_clause := l_where_clause1 || l_where_clause2;
59:
60: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
61: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);
62: fnd_flex_val_api.create_valueset_table(
63: /* basic parameters */
64: value_set_name => l_value_set_name,
65: description => l_description,
66: security_available => 'N', -- FLEX_VST_SECURITY_ENABLED_FLAG
107:
108: begin
109: hr_utility.set_location('Entering: '||l_proc,10);
110:
111: fnd_flex_val_api.set_session_mode('customer_data');
112: l_value_set_name := 'ICD_'||P_MIN_VALUE||P_MAX_VALUE;
113: l_description := 'ICD Value set for Min Max Input Value: '||l_value_set_name;
114:
115: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
111: fnd_flex_val_api.set_session_mode('customer_data');
112: l_value_set_name := 'ICD_'||P_MIN_VALUE||P_MAX_VALUE;
113: l_description := 'ICD Value set for Min Max Input Value: '||l_value_set_name;
114:
115: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
116: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);
117: fnd_flex_val_api.create_valueset_none(
118: /* basic parameters */
119: value_set_name => l_value_set_name,
113: l_description := 'ICD Value set for Min Max Input Value: '||l_value_set_name;
114:
115: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
116: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);
117: fnd_flex_val_api.create_valueset_none(
118: /* basic parameters */
119: value_set_name => l_value_set_name,
120: description => l_description,
121: security_available => 'N',
149: l_format_type_name varchar2(100);
150: l_format_type varchar2(10);
151: begin
152: hr_utility.set_location('Entering: '||l_proc,10);
153: fnd_flex_val_api.set_session_mode('customer_data');
154: l_value_set_name := 'ICD_DFF_'||P_INPUT_VALUE_UOM;
155: l_description := 'Only for internal use within ICD Developer Descriptive Flex Field';
156:
157: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
153: fnd_flex_val_api.set_session_mode('customer_data');
154: l_value_set_name := 'ICD_DFF_'||P_INPUT_VALUE_UOM;
155: l_description := 'Only for internal use within ICD Developer Descriptive Flex Field';
156:
157: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
158: hr_utility.set_location('Creating Valueset: '||l_value_set_name,20);
159: fnd_flex_val_api.create_valueset_none(
160: /* basic parameters */
161: value_set_name => l_value_set_name,
155: l_description := 'Only for internal use within ICD Developer Descriptive Flex Field';
156:
157: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
158: hr_utility.set_location('Creating Valueset: '||l_value_set_name,20);
159: fnd_flex_val_api.create_valueset_none(
160: /* basic parameters */
161: value_set_name => l_value_set_name,
162: description => l_description,
163: security_available => 'N',