APPS.OTA_CERT_CATEGORY_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

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

Line 70: hr_api.constant_to_boolean

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

Line 166: (p_validate in number default hr_api.g_false_num

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

Line 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

Line 171: ,p_attribute1 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

Line 172: ,p_attribute2 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

Line 173: ,p_attribute3 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

Line 174: ,p_attribute4 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

Line 175: ,p_attribute5 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

Line 176: ,p_attribute6 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

Line 177: ,p_attribute7 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

Line 178: ,p_attribute8 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

Line 179: ,p_attribute9 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

Line 180: ,p_attribute10 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

Line 181: ,p_attribute11 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

Line 182: ,p_attribute12 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

Line 183: ,p_attribute13 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

Line 184: ,p_attribute14 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

Line 185: ,p_attribute15 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

Line 186: ,p_attribute16 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

Line 187: ,p_attribute17 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

Line 188: ,p_attribute18 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
192: ,p_end_date_active in date default hr_api.g_date

Line 189: ,p_attribute19 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
193: ,p_primary_flag in varchar2 default hr_api.g_varchar2

Line 190: ,p_attribute20 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

Line 191: ,p_start_date_active in date default hr_api.g_date

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

Line 192: ,p_end_date_active in date default hr_api.g_date

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

Line 193: ,p_primary_flag 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
197: --

Line 224: hr_api.constant_to_boolean

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

Line 319: ,p_validate in number default hr_api.g_false_num

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

Line 347: hr_api.constant_to_boolean

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