70: BEGIN
71: hr_utility.set_location('Entering:' || l_proc,10);
72: FOR v_rec IN csr_org_info LOOP
73: hr_utility.trace('Context : ' || v_rec.context);
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
71: hr_utility.set_location('Entering:' || l_proc,10);
72: FOR v_rec IN csr_org_info LOOP
73: hr_utility.trace('Context : ' || v_rec.context);
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
72: FOR v_rec IN csr_org_info LOOP
73: hr_utility.trace('Context : ' || v_rec.context);
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
73: hr_utility.trace('Context : ' || v_rec.context);
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
95:
88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
95:
96: hr_utility.set_location(l_proc,10);
89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
95:
96: hr_utility.set_location(l_proc,10);
97: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);
91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);
92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
95:
96: hr_utility.set_location(l_proc,10);
97: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
98: (
93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);
94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);
95:
96: hr_utility.set_location(l_proc,10);
97: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS
98: (
99: appl_short_name => 'PER',
100: desc_flex_name => 'Org Developer DF',
101: values_or_ids => 'V'
111: END IF;
112: i:=i+1;
113: END LOOP;
114:
115: select fnd_flex_descval.segment_id(idx+1),
116: fnd_flex_descval.segment_value(idx+1),
117: fnd_flex_descval.segment_description(idx+1)
118: into l_seg_id,
119: l_seg_value,
112: i:=i+1;
113: END LOOP;
114:
115: select fnd_flex_descval.segment_id(idx+1),
116: fnd_flex_descval.segment_value(idx+1),
117: fnd_flex_descval.segment_description(idx+1)
118: into l_seg_id,
119: l_seg_value,
120: l_seg_desc
113: END LOOP;
114:
115: select fnd_flex_descval.segment_id(idx+1),
116: fnd_flex_descval.segment_value(idx+1),
117: fnd_flex_descval.segment_description(idx+1)
118: into l_seg_id,
119: l_seg_value,
120: l_seg_desc
121: from dual;
120: l_seg_desc
121: from dual;
122:
123: hr_utility.trace(l_seg_id || ':' || l_seg_value);
124: hr_utility.trace(fnd_flex_descval.error_message());
125: return(l_seg_id);
126: END LOOP;
127: hr_utility.set_location('Leaving:' || l_proc,90);
128: END;