8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< create_cert_cat_inclusion >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_cert_cat_inclusion
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_certification_id in number
15: ,p_category_usage_id in number
16: ,p_object_version_number out nocopy number
66: --
67: -- Convert constant values to their corresponding boolean value
68: --
69: l_validate :=
70: hr_api.constant_to_boolean
71: (p_constant_value => p_validate);
72: --
73: -- Register Surrogate ID or user key values
74: --
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------< update_cert_cat_inclusion >----------------------|
164: -- ----------------------------------------------------------------------------
165: PROCEDURE update_cert_cat_inclusion
166: (p_validate in number default hr_api.g_false_num
167: ,p_effective_date in date
168: ,p_certification_id in number
169: ,p_object_version_number in out nocopy number
170: ,p_attribute_category in varchar2 default hr_api.g_varchar2
166: (p_validate in number default hr_api.g_false_num
167: ,p_effective_date in date
168: ,p_certification_id in number
169: ,p_object_version_number in out nocopy number
170: ,p_attribute_category in varchar2 default hr_api.g_varchar2
171: ,p_attribute1 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
167: ,p_effective_date in date
168: ,p_certification_id in number
169: ,p_object_version_number in out nocopy number
170: ,p_attribute_category in varchar2 default hr_api.g_varchar2
171: ,p_attribute1 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
168: ,p_certification_id in number
169: ,p_object_version_number in out nocopy number
170: ,p_attribute_category in varchar2 default hr_api.g_varchar2
171: ,p_attribute1 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
169: ,p_object_version_number in out nocopy number
170: ,p_attribute_category in varchar2 default hr_api.g_varchar2
171: ,p_attribute1 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
170: ,p_attribute_category in varchar2 default hr_api.g_varchar2
171: ,p_attribute1 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
171: ,p_attribute1 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
172: ,p_attribute2 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
173: ,p_attribute3 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
174: ,p_attribute4 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
175: ,p_attribute5 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
176: ,p_attribute6 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
177: ,p_attribute7 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
178: ,p_attribute8 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
179: ,p_attribute9 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
180: ,p_attribute10 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
181: ,p_attribute11 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
182: ,p_attribute12 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
183: ,p_attribute13 in varchar2 default hr_api.g_varchar2
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
184: ,p_attribute14 in varchar2 default hr_api.g_varchar2
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
192: ,p_end_date_active in date default hr_api.g_date
185: ,p_attribute15 in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
192: ,p_end_date_active in date default hr_api.g_date
193: ,p_primary_flag in varchar2 default hr_api.g_varchar2
186: ,p_attribute16 in varchar2 default hr_api.g_varchar2
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
192: ,p_end_date_active in date default hr_api.g_date
193: ,p_primary_flag in varchar2 default hr_api.g_varchar2
194: ,p_category_usage_id in number
187: ,p_attribute17 in varchar2 default hr_api.g_varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
192: ,p_end_date_active in date default hr_api.g_date
193: ,p_primary_flag in varchar2 default hr_api.g_varchar2
194: ,p_category_usage_id in number
195: ,p_return_status out nocopy varchar2
188: ,p_attribute18 in varchar2 default hr_api.g_varchar2
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
192: ,p_end_date_active in date default hr_api.g_date
193: ,p_primary_flag in varchar2 default hr_api.g_varchar2
194: ,p_category_usage_id in number
195: ,p_return_status out nocopy varchar2
196: ) is
189: ,p_attribute19 in varchar2 default hr_api.g_varchar2
190: ,p_attribute20 in varchar2 default hr_api.g_varchar2
191: ,p_start_date_active in date default hr_api.g_date
192: ,p_end_date_active in date default hr_api.g_date
193: ,p_primary_flag in varchar2 default hr_api.g_varchar2
194: ,p_category_usage_id in number
195: ,p_return_status out nocopy varchar2
196: ) is
197: --
220: --
221: -- Convert constant values to their corresponding boolean value
222: --
223: l_validate :=
224: hr_api.constant_to_boolean
225: (p_constant_value => p_validate);
226: --
227: -- Register Surrogate ID or user key values
228: --
315: PROCEDURE delete_cert_cat_inclusion
316: (p_certification_id in number
317: ,p_category_usage_id in varchar2
318: ,p_object_version_number in number
319: ,p_validate in number default hr_api.g_false_num
320: ,p_return_status out nocopy varchar2
321: ) is
322: --
323: -- Variables for API Boolean parameters
343: --
344: -- Convert constant values to their corresponding boolean value
345: --
346: l_validate :=
347: hr_api.constant_to_boolean
348: (p_constant_value => p_validate);
349: --
350: -- Register Surrogate ID or user key values
351: --