22: return boolean is
23:
24: l_value_set_id number := -1;
25: l_seg_value_set_id number := -2;
26: l_flexfield fnd_flex_key_api.flexfield_type;
27: l_new_flexfield fnd_flex_key_api.flexfield_type;
28: l_structure fnd_flex_key_api.structure_type;
29: l_new_segment fnd_flex_key_api.segment_type;
30:
23:
24: l_value_set_id number := -1;
25: l_seg_value_set_id number := -2;
26: l_flexfield fnd_flex_key_api.flexfield_type;
27: l_new_flexfield fnd_flex_key_api.flexfield_type;
28: l_structure fnd_flex_key_api.structure_type;
29: l_new_segment fnd_flex_key_api.segment_type;
30:
31: begin
24: l_value_set_id number := -1;
25: l_seg_value_set_id number := -2;
26: l_flexfield fnd_flex_key_api.flexfield_type;
27: l_new_flexfield fnd_flex_key_api.flexfield_type;
28: l_structure fnd_flex_key_api.structure_type;
29: l_new_segment fnd_flex_key_api.segment_type;
30:
31: begin
32: select flex_value_set_id
25: l_seg_value_set_id number := -2;
26: l_flexfield fnd_flex_key_api.flexfield_type;
27: l_new_flexfield fnd_flex_key_api.flexfield_type;
28: l_structure fnd_flex_key_api.structure_type;
29: l_new_segment fnd_flex_key_api.segment_type;
30:
31: begin
32: select flex_value_set_id
33: into l_value_set_id
83:
84: --
85: -- Make sure flexfield allows ID valuesets
86: --
87: fnd_flex_key_api.set_session_mode('seed_data');
88: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');
89: l_new_flexfield := l_flexfield;
90: l_new_flexfield.allow_id_value_sets := 'Y';
91: fnd_flex_key_api.modify_flexfield(l_flexfield, l_new_flexfield);
84: --
85: -- Make sure flexfield allows ID valuesets
86: --
87: fnd_flex_key_api.set_session_mode('seed_data');
88: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');
89: l_new_flexfield := l_flexfield;
90: l_new_flexfield.allow_id_value_sets := 'Y';
91: fnd_flex_key_api.modify_flexfield(l_flexfield, l_new_flexfield);
92:
87: fnd_flex_key_api.set_session_mode('seed_data');
88: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');
89: l_new_flexfield := l_flexfield;
90: l_new_flexfield.allow_id_value_sets := 'Y';
91: fnd_flex_key_api.modify_flexfield(l_flexfield, l_new_flexfield);
92:
93: --
94: -- Creating Locator Flexfield Segment
95: --
92:
93: --
94: -- Creating Locator Flexfield Segment
95: --
96: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');
97: l_structure := fnd_flex_key_api.find_structure(l_flexfield,101);
98: l_new_segment := fnd_flex_key_api.new_segment(
99: flexfield => l_flexfield,
100: structure => l_structure,
93: --
94: -- Creating Locator Flexfield Segment
95: --
96: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');
97: l_structure := fnd_flex_key_api.find_structure(l_flexfield,101);
98: l_new_segment := fnd_flex_key_api.new_segment(
99: flexfield => l_flexfield,
100: structure => l_structure,
101: segment_name => p_segment_name,
94: -- Creating Locator Flexfield Segment
95: --
96: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');
97: l_structure := fnd_flex_key_api.find_structure(l_flexfield,101);
98: l_new_segment := fnd_flex_key_api.new_segment(
99: flexfield => l_flexfield,
100: structure => l_structure,
101: segment_name => p_segment_name,
102: description => p_segment_name,
117: lov_prompt => p_segment_name,
118: window_prompt => p_segment_name
119: );
120:
121: fnd_flex_key_api.add_segment(
122: flexfield => l_flexfield,
123: structure => l_structure,
124: segment => l_new_segment
125: );
123: structure => l_structure,
124: segment => l_new_segment
125: );
126:
127: fnd_flex_key_api.assign_qualifier(
128: flexfield => l_flexfield,
129: structure => l_structure,
130: segment => l_new_segment,
131: flexfield_qualifier => p_qualifier,