DBA Data[Home] [Help]

APPS.HR_H2PI_BG_UPLOAD dependencies on FND_FLEX_DESCVAL

Line 74: fnd_flex_descval.set_column_value('ORG_INFORMATION_CONTEXT', v_rec.context);

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

Line 75: fnd_flex_descval.set_column_value('ORG_INFORMATION1', v_rec.ogi1 );

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

Line 76: fnd_flex_descval.set_column_value('ORG_INFORMATION2', v_rec.ogi2 );

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

Line 77: fnd_flex_descval.set_column_value('ORG_INFORMATION3', v_rec.ogi3 );

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

Line 78: fnd_flex_descval.set_column_value('ORG_INFORMATION4', v_rec.ogi4 );

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

Line 79: fnd_flex_descval.set_column_value('ORG_INFORMATION5', v_rec.ogi5 );

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

Line 80: fnd_flex_descval.set_column_value('ORG_INFORMATION6', v_rec.ogi6 );

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

Line 81: fnd_flex_descval.set_column_value('ORG_INFORMATION7', v_rec.ogi7 );

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

Line 82: fnd_flex_descval.set_column_value('ORG_INFORMATION8', v_rec.ogi8 );

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

Line 83: fnd_flex_descval.set_column_value('ORG_INFORMATION9', v_rec.ogi9 );

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

Line 84: fnd_flex_descval.set_column_value('ORG_INFORMATION10', v_rec.ogi10);

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

Line 85: fnd_flex_descval.set_column_value('ORG_INFORMATION11', v_rec.ogi11);

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

Line 86: fnd_flex_descval.set_column_value('ORG_INFORMATION12', v_rec.ogi12);

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

Line 87: fnd_flex_descval.set_column_value('ORG_INFORMATION13', v_rec.ogi13);

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

Line 88: fnd_flex_descval.set_column_value('ORG_INFORMATION14', v_rec.ogi14);

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

Line 89: fnd_flex_descval.set_column_value('ORG_INFORMATION15', v_rec.ogi15);

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

Line 90: fnd_flex_descval.set_column_value('ORG_INFORMATION16', v_rec.ogi16);

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

Line 91: fnd_flex_descval.set_column_value('ORG_INFORMATION17', v_rec.ogi17);

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:

Line 92: fnd_flex_descval.set_column_value('ORG_INFORMATION18', v_rec.ogi18);

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

Line 93: fnd_flex_descval.set_column_value('ORG_INFORMATION19', v_rec.ogi19);

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

Line 94: fnd_flex_descval.set_column_value('ORG_INFORMATION20', v_rec.ogi20);

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

Line 97: l_return_status := fnd_flex_descval.VALIDATE_DESCCOLS

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'

Line 115: select fnd_flex_descval.segment_id(idx+1),

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,

Line 116: fnd_flex_descval.segment_value(idx+1),

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

Line 117: fnd_flex_descval.segment_description(idx+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
121: from dual;

Line 124: hr_utility.trace(fnd_flex_descval.error_message());

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;