DBA Data[Home] [Help]

APPS.PJM_INSTALL dependencies on FND_FLEX_KEY_API

Line 26: l_flexfield fnd_flex_key_api.flexfield_type;

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:

Line 27: l_new_flexfield fnd_flex_key_api.flexfield_type;

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

Line 28: l_structure fnd_flex_key_api.structure_type;

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

Line 29: l_new_segment fnd_flex_key_api.segment_type;

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

Line 87: fnd_flex_key_api.set_session_mode('seed_data');

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);

Line 88: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');

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:

Line 91: fnd_flex_key_api.modify_flexfield(l_flexfield, l_new_flexfield);

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: --

Line 96: l_flexfield := fnd_flex_key_api.find_flexfield('INV','MTLL');

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,

Line 97: l_structure := fnd_flex_key_api.find_structure(l_flexfield,101);

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,

Line 98: l_new_segment := fnd_flex_key_api.new_segment(

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,

Line 121: fnd_flex_key_api.add_segment(

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: );

Line 127: fnd_flex_key_api.assign_qualifier(

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,