DBA Data[Home] [Help]

APPS.BEN_ICD_FLEX_FIELD_SETUP dependencies on FND_FLEX_VAL_API

Line 48: fnd_flex_val_api.set_session_mode('customer_data');

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

Line 60: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then

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,

Line 62: fnd_flex_val_api.create_valueset_table(

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

Line 111: fnd_flex_val_api.set_session_mode('customer_data');

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

Line 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,

Line 117: fnd_flex_val_api.create_valueset_none(

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',

Line 153: fnd_flex_val_api.set_session_mode('customer_data');

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

Line 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,

Line 159: fnd_flex_val_api.create_valueset_none(

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',