eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CERT_MBR_ENROLLMENT_SWI dependencies on HR_API

Line 13: ,p_validate in number default hr_api.g_false_num

9: -- |----------------------< create_cert_mbr_enrollment >----------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_cert_mbr_enrollment
12: (p_effective_date in date
13: ,p_validate in number default hr_api.g_false_num
14: ,p_cert_prd_enrollment_id in number
15: ,p_cert_member_id in number
16: ,p_member_status_code in varchar2
17: ,p_completion_date in date default null

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 172: ,p_completion_date in date default hr_api.g_date

168: ,p_object_version_number in out nocopy number
169: ,p_cert_prd_enrollment_id in number
170: ,p_cert_member_id in number
171: ,p_member_status_code in varchar2
172: ,p_completion_date in date default hr_api.g_date
173: ,p_business_group_id in number default hr_api.g_number
174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 173: ,p_business_group_id in number default hr_api.g_number

169: ,p_cert_prd_enrollment_id in number
170: ,p_cert_member_id in number
171: ,p_member_status_code in varchar2
172: ,p_completion_date in date default hr_api.g_date
173: ,p_business_group_id in number default hr_api.g_number
174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 174: ,p_attribute_category in varchar2 default hr_api.g_varchar2

170: ,p_cert_member_id in number
171: ,p_member_status_code in varchar2
172: ,p_completion_date in date default hr_api.g_date
173: ,p_business_group_id in number default hr_api.g_number
174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 175: ,p_attribute1 in varchar2 default hr_api.g_varchar2

171: ,p_member_status_code in varchar2
172: ,p_completion_date in date default hr_api.g_date
173: ,p_business_group_id in number default hr_api.g_number
174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 176: ,p_attribute2 in varchar2 default hr_api.g_varchar2

172: ,p_completion_date in date default hr_api.g_date
173: ,p_business_group_id in number default hr_api.g_number
174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 177: ,p_attribute3 in varchar2 default hr_api.g_varchar2

173: ,p_business_group_id in number default hr_api.g_number
174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 178: ,p_attribute4 in varchar2 default hr_api.g_varchar2

174: ,p_attribute_category in varchar2 default hr_api.g_varchar2
175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 179: ,p_attribute5 in varchar2 default hr_api.g_varchar2

175: ,p_attribute1 in varchar2 default hr_api.g_varchar2
176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 180: ,p_attribute6 in varchar2 default hr_api.g_varchar2

176: ,p_attribute2 in varchar2 default hr_api.g_varchar2
177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 181: ,p_attribute7 in varchar2 default hr_api.g_varchar2

177: ,p_attribute3 in varchar2 default hr_api.g_varchar2
178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 182: ,p_attribute8 in varchar2 default hr_api.g_varchar2

178: ,p_attribute4 in varchar2 default hr_api.g_varchar2
179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 183: ,p_attribute9 in varchar2 default hr_api.g_varchar2

179: ,p_attribute5 in varchar2 default hr_api.g_varchar2
180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 184: ,p_attribute10 in varchar2 default hr_api.g_varchar2

180: ,p_attribute6 in varchar2 default hr_api.g_varchar2
181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 185: ,p_attribute11 in varchar2 default hr_api.g_varchar2

181: ,p_attribute7 in varchar2 default hr_api.g_varchar2
182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 186: ,p_attribute12 in varchar2 default hr_api.g_varchar2

182: ,p_attribute8 in varchar2 default hr_api.g_varchar2
183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 187: ,p_attribute13 in varchar2 default hr_api.g_varchar2

183: ,p_attribute9 in varchar2 default hr_api.g_varchar2
184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 188: ,p_attribute14 in varchar2 default hr_api.g_varchar2

184: ,p_attribute10 in varchar2 default hr_api.g_varchar2
185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 189: ,p_attribute15 in varchar2 default hr_api.g_varchar2

185: ,p_attribute11 in varchar2 default hr_api.g_varchar2
186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 190: ,p_attribute16 in varchar2 default hr_api.g_varchar2

186: ,p_attribute12 in varchar2 default hr_api.g_varchar2
187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 191: ,p_attribute17 in varchar2 default hr_api.g_varchar2

187: ,p_attribute13 in varchar2 default hr_api.g_varchar2
188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_validate in number default hr_api.g_false_num

Line 192: ,p_attribute18 in varchar2 default hr_api.g_varchar2

188: ,p_attribute14 in varchar2 default hr_api.g_varchar2
189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_validate in number default hr_api.g_false_num
196: ,p_return_status out nocopy varchar2

Line 193: ,p_attribute19 in varchar2 default hr_api.g_varchar2

189: ,p_attribute15 in varchar2 default hr_api.g_varchar2
190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_validate in number default hr_api.g_false_num
196: ,p_return_status out nocopy varchar2
197: ) is

Line 194: ,p_attribute20 in varchar2 default hr_api.g_varchar2

190: ,p_attribute16 in varchar2 default hr_api.g_varchar2
191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_validate in number default hr_api.g_false_num
196: ,p_return_status out nocopy varchar2
197: ) is
198: --

Line 195: ,p_validate in number default hr_api.g_false_num

191: ,p_attribute17 in varchar2 default hr_api.g_varchar2
192: ,p_attribute18 in varchar2 default hr_api.g_varchar2
193: ,p_attribute19 in varchar2 default hr_api.g_varchar2
194: ,p_attribute20 in varchar2 default hr_api.g_varchar2
195: ,p_validate in number default hr_api.g_false_num
196: ,p_return_status out nocopy varchar2
197: ) is
198: --
199: -- Variables for API Boolean parameters

Line 225: hr_api.constant_to_boolean

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

Line 320: ,p_validate in number default hr_api.g_false_num

316: -- ----------------------------------------------------------------------------
317: PROCEDURE delete_cert_mbr_enrollment
318: (p_cert_mbr_enrollment_id in number
319: ,p_object_version_number in number
320: ,p_validate in number default hr_api.g_false_num
321: ,p_return_status out nocopy varchar2
322: ) is
323: --
324: -- Variables for API Boolean parameters

Line 348: hr_api.constant_to_boolean

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