APPS.PER_CPN_UPD dependencies on HR_API

Line 50: -- by raising and handling the exception hr_api.validate_enabled. We use

46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- process and is rollbacked at the end of the process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --

Line 125: p_name in varchar2 default hr_api.g_varchar2,

121: -- ----------------------------------------------------------------------------
122: Procedure upd
123: (
124: p_competence_id in number,
125: p_name in varchar2 default hr_api.g_varchar2,
126: p_object_version_number in out nocopy number,
127: p_description in varchar2 default hr_api.g_varchar2,
128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,

Line 127: p_description in varchar2 default hr_api.g_varchar2,

123: (
124: p_competence_id in number,
125: p_name in varchar2 default hr_api.g_varchar2,
126: p_object_version_number in out nocopy number,
127: p_description in varchar2 default hr_api.g_varchar2,
128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,

Line 128: p_date_from in date default hr_api.g_date,

124: p_competence_id in number,
125: p_name in varchar2 default hr_api.g_varchar2,
126: p_object_version_number in out nocopy number,
127: p_description in varchar2 default hr_api.g_varchar2,
128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,

Line 129: p_date_to in date default hr_api.g_date,

125: p_name in varchar2 default hr_api.g_varchar2,
126: p_object_version_number in out nocopy number,
127: p_description in varchar2 default hr_api.g_varchar2,
128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,

Line 130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,

126: p_object_version_number in out nocopy number,
127: p_description in varchar2 default hr_api.g_varchar2,
128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,

Line 131: p_certification_required in varchar2 default hr_api.g_varchar2,

127: p_description in varchar2 default hr_api.g_varchar2,
128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,

Line 132: p_evaluation_method in varchar2 default hr_api.g_varchar2,

128: p_date_from in date default hr_api.g_date,
129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,

Line 133: p_renewal_period_frequency in number default hr_api.g_number,

129: p_date_to in date default hr_api.g_date,
130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,

Line 134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,

130: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 135: p_min_level in number default hr_api.g_number,

131: p_certification_required in varchar2 default hr_api.g_varchar2,
132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 136: p_max_level in number default hr_api.g_number,

132: p_evaluation_method in varchar2 default hr_api.g_varchar2,
133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 137: p_rating_scale_id in number default hr_api.g_number,

133: p_renewal_period_frequency in number default hr_api.g_number,
134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 138: p_attribute_category in varchar2 default hr_api.g_varchar2,

134: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 139: p_attribute1 in varchar2 default hr_api.g_varchar2,

135: p_min_level in number default hr_api.g_number,
136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 140: p_attribute2 in varchar2 default hr_api.g_varchar2,

136: p_max_level in number default hr_api.g_number,
137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 141: p_attribute3 in varchar2 default hr_api.g_varchar2,

137: p_rating_scale_id in number default hr_api.g_number,
138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 142: p_attribute4 in varchar2 default hr_api.g_varchar2,

138: p_attribute_category in varchar2 default hr_api.g_varchar2,
139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 143: p_attribute5 in varchar2 default hr_api.g_varchar2,

139: p_attribute1 in varchar2 default hr_api.g_varchar2,
140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 144: p_attribute6 in varchar2 default hr_api.g_varchar2,

140: p_attribute2 in varchar2 default hr_api.g_varchar2,
141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 145: p_attribute7 in varchar2 default hr_api.g_varchar2,

141: p_attribute3 in varchar2 default hr_api.g_varchar2,
142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 146: p_attribute8 in varchar2 default hr_api.g_varchar2,

142: p_attribute4 in varchar2 default hr_api.g_varchar2,
143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 147: p_attribute9 in varchar2 default hr_api.g_varchar2,

143: p_attribute5 in varchar2 default hr_api.g_varchar2,
144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 148: p_attribute10 in varchar2 default hr_api.g_varchar2,

144: p_attribute6 in varchar2 default hr_api.g_varchar2,
145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 149: p_attribute11 in varchar2 default hr_api.g_varchar2,

145: p_attribute7 in varchar2 default hr_api.g_varchar2,
146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 150: p_attribute12 in varchar2 default hr_api.g_varchar2,

146: p_attribute8 in varchar2 default hr_api.g_varchar2,
147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 151: p_attribute13 in varchar2 default hr_api.g_varchar2,

147: p_attribute9 in varchar2 default hr_api.g_varchar2,
148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 152: p_attribute14 in varchar2 default hr_api.g_varchar2,

148: p_attribute10 in varchar2 default hr_api.g_varchar2,
149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 153: p_attribute15 in varchar2 default hr_api.g_varchar2,

149: p_attribute11 in varchar2 default hr_api.g_varchar2,
150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,
157: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 154: p_attribute16 in varchar2 default hr_api.g_varchar2,

150: p_attribute12 in varchar2 default hr_api.g_varchar2,
151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,
157: p_attribute19 in varchar2 default hr_api.g_varchar2,
158: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 155: p_attribute17 in varchar2 default hr_api.g_varchar2,

151: p_attribute13 in varchar2 default hr_api.g_varchar2,
152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,
157: p_attribute19 in varchar2 default hr_api.g_varchar2,
158: p_attribute20 in varchar2 default hr_api.g_varchar2,
159: p_effective_date in date ,

Line 156: p_attribute18 in varchar2 default hr_api.g_varchar2,

152: p_attribute14 in varchar2 default hr_api.g_varchar2,
153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,
157: p_attribute19 in varchar2 default hr_api.g_varchar2,
158: p_attribute20 in varchar2 default hr_api.g_varchar2,
159: p_effective_date in date ,
160: p_validate in boolean default false,

Line 157: p_attribute19 in varchar2 default hr_api.g_varchar2,

153: p_attribute15 in varchar2 default hr_api.g_varchar2,
154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,
157: p_attribute19 in varchar2 default hr_api.g_varchar2,
158: p_attribute20 in varchar2 default hr_api.g_varchar2,
159: p_effective_date in date ,
160: p_validate in boolean default false,
161: p_competence_alias in varchar2 default hr_api.g_varchar2,

Line 158: p_attribute20 in varchar2 default hr_api.g_varchar2,

154: p_attribute16 in varchar2 default hr_api.g_varchar2,
155: p_attribute17 in varchar2 default hr_api.g_varchar2,
156: p_attribute18 in varchar2 default hr_api.g_varchar2,
157: p_attribute19 in varchar2 default hr_api.g_varchar2,
158: p_attribute20 in varchar2 default hr_api.g_varchar2,
159: p_effective_date in date ,
160: p_validate in boolean default false,
161: p_competence_alias in varchar2 default hr_api.g_varchar2,
162: p_competence_definition_id in number default hr_api.g_number

Line 161: p_competence_alias in varchar2 default hr_api.g_varchar2,

157: p_attribute19 in varchar2 default hr_api.g_varchar2,
158: p_attribute20 in varchar2 default hr_api.g_varchar2,
159: p_effective_date in date ,
160: p_validate in boolean default false,
161: p_competence_alias in varchar2 default hr_api.g_varchar2,
162: p_competence_definition_id in number default hr_api.g_number
163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2

Line 162: p_competence_definition_id in number default hr_api.g_number

158: p_attribute20 in varchar2 default hr_api.g_varchar2,
159: p_effective_date in date ,
160: p_validate in boolean default false,
161: p_competence_alias in varchar2 default hr_api.g_varchar2,
162: p_competence_definition_id in number default hr_api.g_number
163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number

Line 163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2

159: p_effective_date in date ,
160: p_validate in boolean default false,
161: p_competence_alias in varchar2 default hr_api.g_varchar2,
162: p_competence_definition_id in number default hr_api.g_number
163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2

Line 164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2

160: p_validate in boolean default false,
161: p_competence_alias in varchar2 default hr_api.g_varchar2,
162: p_competence_definition_id in number default hr_api.g_number
163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number

Line 165: ,p_credit_type in varchar2 default hr_api.g_varchar2

161: p_competence_alias in varchar2 default hr_api.g_varchar2,
162: p_competence_definition_id in number default hr_api.g_number
163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2

Line 166: ,p_credits in number default hr_api.g_number

162: p_competence_definition_id in number default hr_api.g_number
163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2

Line 167: ,p_level_type in varchar2 default hr_api.g_varchar2

163: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2

Line 168: ,p_level_number in number default hr_api.g_number

164: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2

Line 169: ,p_field in varchar2 default hr_api.g_varchar2

165: ,p_credit_type in varchar2 default hr_api.g_varchar2
166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 170: ,p_sub_field in varchar2 default hr_api.g_varchar2

166: ,p_credits in number default hr_api.g_number
167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 171: ,p_provider in varchar2 default hr_api.g_varchar2

167: ,p_level_type in varchar2 default hr_api.g_varchar2
168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 172: ,p_qa_organization in varchar2 default hr_api.g_varchar2

168: ,p_level_number in number default hr_api.g_number
169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 173: ,p_information_category in varchar2 default hr_api.g_varchar2

169: ,p_field in varchar2 default hr_api.g_varchar2
170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 174: ,p_information1 in varchar2 default hr_api.g_varchar2

170: ,p_sub_field in varchar2 default hr_api.g_varchar2
171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 175: ,p_information2 in varchar2 default hr_api.g_varchar2

171: ,p_provider in varchar2 default hr_api.g_varchar2
172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 176: ,p_information3 in varchar2 default hr_api.g_varchar2

172: ,p_qa_organization in varchar2 default hr_api.g_varchar2
173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 177: ,p_information4 in varchar2 default hr_api.g_varchar2

173: ,p_information_category in varchar2 default hr_api.g_varchar2
174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 178: ,p_information5 in varchar2 default hr_api.g_varchar2

174: ,p_information1 in varchar2 default hr_api.g_varchar2
175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 179: ,p_information6 in varchar2 default hr_api.g_varchar2

175: ,p_information2 in varchar2 default hr_api.g_varchar2
176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 180: ,p_information7 in varchar2 default hr_api.g_varchar2

176: ,p_information3 in varchar2 default hr_api.g_varchar2
177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 181: ,p_information8 in varchar2 default hr_api.g_varchar2

177: ,p_information4 in varchar2 default hr_api.g_varchar2
178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 182: ,p_information9 in varchar2 default hr_api.g_varchar2

178: ,p_information5 in varchar2 default hr_api.g_varchar2
179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 183: ,p_information10 in varchar2 default hr_api.g_varchar2

179: ,p_information6 in varchar2 default hr_api.g_varchar2
180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 184: ,p_information11 in varchar2 default hr_api.g_varchar2

180: ,p_information7 in varchar2 default hr_api.g_varchar2
181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 185: ,p_information12 in varchar2 default hr_api.g_varchar2

181: ,p_information8 in varchar2 default hr_api.g_varchar2
182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 186: ,p_information13 in varchar2 default hr_api.g_varchar2

182: ,p_information9 in varchar2 default hr_api.g_varchar2
183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 187: ,p_information14 in varchar2 default hr_api.g_varchar2

183: ,p_information10 in varchar2 default hr_api.g_varchar2
184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 188: ,p_information15 in varchar2 default hr_api.g_varchar2

184: ,p_information11 in varchar2 default hr_api.g_varchar2
185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2
192: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 189: ,p_information16 in varchar2 default hr_api.g_varchar2

185: ,p_information12 in varchar2 default hr_api.g_varchar2
186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2
192: ,p_information19 in varchar2 default hr_api.g_varchar2
193: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 190: ,p_information17 in varchar2 default hr_api.g_varchar2

186: ,p_information13 in varchar2 default hr_api.g_varchar2
187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2
192: ,p_information19 in varchar2 default hr_api.g_varchar2
193: ,p_information20 in varchar2 default hr_api.g_varchar2
194: );

Line 191: ,p_information18 in varchar2 default hr_api.g_varchar2

187: ,p_information14 in varchar2 default hr_api.g_varchar2
188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2
192: ,p_information19 in varchar2 default hr_api.g_varchar2
193: ,p_information20 in varchar2 default hr_api.g_varchar2
194: );
195: --

Line 192: ,p_information19 in varchar2 default hr_api.g_varchar2

188: ,p_information15 in varchar2 default hr_api.g_varchar2
189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2
192: ,p_information19 in varchar2 default hr_api.g_varchar2
193: ,p_information20 in varchar2 default hr_api.g_varchar2
194: );
195: --
196: end per_cpn_upd;

Line 193: ,p_information20 in varchar2 default hr_api.g_varchar2

189: ,p_information16 in varchar2 default hr_api.g_varchar2
190: ,p_information17 in varchar2 default hr_api.g_varchar2
191: ,p_information18 in varchar2 default hr_api.g_varchar2
192: ,p_information19 in varchar2 default hr_api.g_varchar2
193: ,p_information20 in varchar2 default hr_api.g_varchar2
194: );
195: --
196: end per_cpn_upd;