APPS.OTA_CERT_MEMBER_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |----------------------< create_certification_member >---------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_certification_member
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_object_id in number
16: ,p_object_type in varchar2

Line 72: hr_api.constant_to_boolean

68: --
69: -- Convert constant values to their corresponding boolean value
70: --
71: l_validate :=
72: hr_api.constant_to_boolean
73: (p_constant_value => p_validate);
74: --
75: -- Register Surrogate ID or user key values
76: --

Line 170: (p_validate in number default hr_api.g_false_num

166: -- ----------------------------------------------------------------------------
167: -- |----------------------< update_certification_member >---------------------|
168: -- ----------------------------------------------------------------------------
169: PROCEDURE update_certification_member
170: (p_validate in number default hr_api.g_false_num
171: ,p_effective_date in date
172: ,p_certification_member_id in number
173: ,p_object_version_number in out nocopy number
174: ,p_object_id in number

Line 177: ,p_start_date_active in date default hr_api.g_date

173: ,p_object_version_number in out nocopy number
174: ,p_object_id in number
175: ,p_object_type in varchar2
176: ,p_member_sequence in number
177: ,p_start_date_active in date default hr_api.g_date
178: ,p_end_date_active in date default hr_api.g_date
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 178: ,p_end_date_active in date default hr_api.g_date

174: ,p_object_id in number
175: ,p_object_type in varchar2
176: ,p_member_sequence in number
177: ,p_start_date_active in date default hr_api.g_date
178: ,p_end_date_active in date default hr_api.g_date
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 179: ,p_attribute_category in varchar2 default hr_api.g_varchar2

175: ,p_object_type in varchar2
176: ,p_member_sequence in number
177: ,p_start_date_active in date default hr_api.g_date
178: ,p_end_date_active in date default hr_api.g_date
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 180: ,p_attribute1 in varchar2 default hr_api.g_varchar2

176: ,p_member_sequence in number
177: ,p_start_date_active in date default hr_api.g_date
178: ,p_end_date_active in date default hr_api.g_date
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 181: ,p_attribute2 in varchar2 default hr_api.g_varchar2

177: ,p_start_date_active in date default hr_api.g_date
178: ,p_end_date_active in date default hr_api.g_date
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 182: ,p_attribute3 in varchar2 default hr_api.g_varchar2

178: ,p_end_date_active in date default hr_api.g_date
179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 183: ,p_attribute4 in varchar2 default hr_api.g_varchar2

179: ,p_attribute_category in varchar2 default hr_api.g_varchar2
180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 184: ,p_attribute5 in varchar2 default hr_api.g_varchar2

180: ,p_attribute1 in varchar2 default hr_api.g_varchar2
181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 185: ,p_attribute6 in varchar2 default hr_api.g_varchar2

181: ,p_attribute2 in varchar2 default hr_api.g_varchar2
182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 186: ,p_attribute7 in varchar2 default hr_api.g_varchar2

182: ,p_attribute3 in varchar2 default hr_api.g_varchar2
183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 187: ,p_attribute8 in varchar2 default hr_api.g_varchar2

183: ,p_attribute4 in varchar2 default hr_api.g_varchar2
184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 188: ,p_attribute9 in varchar2 default hr_api.g_varchar2

184: ,p_attribute5 in varchar2 default hr_api.g_varchar2
185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 189: ,p_attribute10 in varchar2 default hr_api.g_varchar2

185: ,p_attribute6 in varchar2 default hr_api.g_varchar2
186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 190: ,p_attribute11 in varchar2 default hr_api.g_varchar2

186: ,p_attribute7 in varchar2 default hr_api.g_varchar2
187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 191: ,p_attribute12 in varchar2 default hr_api.g_varchar2

187: ,p_attribute8 in varchar2 default hr_api.g_varchar2
188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 192: ,p_attribute13 in varchar2 default hr_api.g_varchar2

188: ,p_attribute9 in varchar2 default hr_api.g_varchar2
189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 193: ,p_attribute14 in varchar2 default hr_api.g_varchar2

189: ,p_attribute10 in varchar2 default hr_api.g_varchar2
190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 194: ,p_attribute15 in varchar2 default hr_api.g_varchar2

190: ,p_attribute11 in varchar2 default hr_api.g_varchar2
191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 195: ,p_attribute16 in varchar2 default hr_api.g_varchar2

191: ,p_attribute12 in varchar2 default hr_api.g_varchar2
192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 196: ,p_attribute17 in varchar2 default hr_api.g_varchar2

192: ,p_attribute13 in varchar2 default hr_api.g_varchar2
193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_return_status out nocopy varchar2

Line 197: ,p_attribute18 in varchar2 default hr_api.g_varchar2

193: ,p_attribute14 in varchar2 default hr_api.g_varchar2
194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_return_status out nocopy varchar2
201: ) is

Line 198: ,p_attribute19 in varchar2 default hr_api.g_varchar2

194: ,p_attribute15 in varchar2 default hr_api.g_varchar2
195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_return_status out nocopy varchar2
201: ) is
202: --

Line 199: ,p_attribute20 in varchar2 default hr_api.g_varchar2

195: ,p_attribute16 in varchar2 default hr_api.g_varchar2
196: ,p_attribute17 in varchar2 default hr_api.g_varchar2
197: ,p_attribute18 in varchar2 default hr_api.g_varchar2
198: ,p_attribute19 in varchar2 default hr_api.g_varchar2
199: ,p_attribute20 in varchar2 default hr_api.g_varchar2
200: ,p_return_status out nocopy varchar2
201: ) is
202: --
203: -- Variables for API Boolean parameters

Line 229: hr_api.constant_to_boolean

225: --
226: -- Convert constant values to their corresponding boolean value
227: --
228: l_validate :=
229: hr_api.constant_to_boolean
230: (p_constant_value => p_validate);
231: --
232: -- Register Surrogate ID or user key values
233: --

Line 322: (p_validate in number default hr_api.g_false_num

318: -- ----------------------------------------------------------------------------
319: -- |----------------------< delete_certification_member >---------------------|
320: -- ----------------------------------------------------------------------------
321: PROCEDURE delete_certification_member
322: (p_validate in number default hr_api.g_false_num
323: ,p_certification_member_id in number
324: ,p_object_version_number in number
325: ,p_return_status out nocopy varchar2
326: ) is

Line 352: hr_api.constant_to_boolean

348: --
349: -- Convert constant values to their corresponding boolean value
350: --
351: l_validate :=
352: hr_api.constant_to_boolean
353: (p_constant_value => p_validate);
354: --
355: -- Register Surrogate ID or user key values
356: --