151:
152: BEGIN
153: hr_utility.set_location('Entering:' || l_proc,10);
154: FOR v_rec IN csr_org_info LOOP
155: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
152: BEGIN
153: hr_utility.set_location('Entering:' || l_proc,10);
154: FOR v_rec IN csr_org_info LOOP
155: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
153: hr_utility.set_location('Entering:' || l_proc,10);
154: FOR v_rec IN csr_org_info LOOP
155: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
154: FOR v_rec IN csr_org_info LOOP
155: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
155: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
156: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
157: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
158: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
159: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
160: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
161: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
162: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
163: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
164: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
165: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
166: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
167: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
175: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
168: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
175: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
176:
169: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
175: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
176:
177: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
170: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
175: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
176:
177: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
178: (
171: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
172: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
175: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
176:
177: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
178: (
179: appl_short_name => 'PER',
173: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
174: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
175: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
176:
177: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
178: (
179: appl_short_name => 'PER',
180: desc_flex_name => 'Org Developer DF',
181: values_or_ids => 'I'
190: END IF;
191: i:=i+1;
192: END LOOP;
193:
194: select fnd_flex_descval.segment_id(idx+1),
195: fnd_flex_descval.segment_value(idx+1),
196: fnd_flex_descval.segment_description(idx+1)
197: into l_seg_id,
198: l_seg_value,
191: i:=i+1;
192: END LOOP;
193:
194: select fnd_flex_descval.segment_id(idx+1),
195: fnd_flex_descval.segment_value(idx+1),
196: fnd_flex_descval.segment_description(idx+1)
197: into l_seg_id,
198: l_seg_value,
199: l_seg_desc
192: END LOOP;
193:
194: select fnd_flex_descval.segment_id(idx+1),
195: fnd_flex_descval.segment_value(idx+1),
196: fnd_flex_descval.segment_description(idx+1)
197: into l_seg_id,
198: l_seg_value,
199: l_seg_desc
200: from dual;