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_LP_SECTION_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |---------------------< create_lp_section >---------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_lp_section
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_business_group_id in number
15: ,p_section_name in varchar2 default null
16: ,p_description in varchar2 default null

Line 84: hr_api.constant_to_boolean

80: --
81: -- Convert constant values to their corresponding boolean value
82: --
83: l_validate :=
84: hr_api.constant_to_boolean
85: (p_constant_value => p_validate);
86: --
87: -- Register Surrogate ID or user key values
88: --

Line 199: (p_validate in number default hr_api.g_false_num

195: -- ----------------------------------------------------------------------------
196: -- |---------------------< update_lp_section >---------------------|
197: -- ----------------------------------------------------------------------------
198: PROCEDURE update_lp_section
199: (p_validate in number default hr_api.g_false_num
200: ,p_effective_date in date
201: ,p_learning_path_section_id in number
202: ,p_section_name in varchar2 default hr_api.g_varchar2
203: ,p_description in varchar2 default hr_api.g_varchar2

Line 202: ,p_section_name in varchar2 default hr_api.g_varchar2

198: PROCEDURE update_lp_section
199: (p_validate in number default hr_api.g_false_num
200: ,p_effective_date in date
201: ,p_learning_path_section_id in number
202: ,p_section_name in varchar2 default hr_api.g_varchar2
203: ,p_description in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2

Line 203: ,p_description in varchar2 default hr_api.g_varchar2

199: (p_validate in number default hr_api.g_false_num
200: ,p_effective_date in date
201: ,p_learning_path_section_id in number
202: ,p_section_name in varchar2 default hr_api.g_varchar2
203: ,p_description in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number

Line 205: ,p_section_sequence in number default hr_api.g_number

201: ,p_learning_path_section_id in number
202: ,p_section_name in varchar2 default hr_api.g_varchar2
203: ,p_description in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2

202: ,p_section_name in varchar2 default hr_api.g_varchar2
203: ,p_description in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 207: ,p_no_of_mandatory_courses in number default hr_api.g_number

203: ,p_description in varchar2 default hr_api.g_varchar2
204: ,p_object_version_number in out nocopy number
205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 208: ,p_attribute_category in varchar2 default hr_api.g_varchar2

204: ,p_object_version_number in out nocopy number
205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 209: ,p_attribute1 in varchar2 default hr_api.g_varchar2

205: ,p_section_sequence in number default hr_api.g_number
206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 210: ,p_attribute2 in varchar2 default hr_api.g_varchar2

206: ,p_completion_type_code in varchar2 default hr_api.g_varchar2
207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 211: ,p_attribute3 in varchar2 default hr_api.g_varchar2

207: ,p_no_of_mandatory_courses in number default hr_api.g_number
208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 212: ,p_attribute4 in varchar2 default hr_api.g_varchar2

208: ,p_attribute_category in varchar2 default hr_api.g_varchar2
209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 213: ,p_attribute5 in varchar2 default hr_api.g_varchar2

209: ,p_attribute1 in varchar2 default hr_api.g_varchar2
210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 214: ,p_attribute6 in varchar2 default hr_api.g_varchar2

210: ,p_attribute2 in varchar2 default hr_api.g_varchar2
211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 215: ,p_attribute7 in varchar2 default hr_api.g_varchar2

211: ,p_attribute3 in varchar2 default hr_api.g_varchar2
212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 216: ,p_attribute8 in varchar2 default hr_api.g_varchar2

212: ,p_attribute4 in varchar2 default hr_api.g_varchar2
213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 217: ,p_attribute9 in varchar2 default hr_api.g_varchar2

213: ,p_attribute5 in varchar2 default hr_api.g_varchar2
214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 218: ,p_attribute10 in varchar2 default hr_api.g_varchar2

214: ,p_attribute6 in varchar2 default hr_api.g_varchar2
215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 219: ,p_attribute11 in varchar2 default hr_api.g_varchar2

215: ,p_attribute7 in varchar2 default hr_api.g_varchar2
216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 220: ,p_attribute12 in varchar2 default hr_api.g_varchar2

216: ,p_attribute8 in varchar2 default hr_api.g_varchar2
217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 221: ,p_attribute13 in varchar2 default hr_api.g_varchar2

217: ,p_attribute9 in varchar2 default hr_api.g_varchar2
218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 222: ,p_attribute14 in varchar2 default hr_api.g_varchar2

218: ,p_attribute10 in varchar2 default hr_api.g_varchar2
219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 223: ,p_attribute15 in varchar2 default hr_api.g_varchar2

219: ,p_attribute11 in varchar2 default hr_api.g_varchar2
220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 224: ,p_attribute16 in varchar2 default hr_api.g_varchar2

220: ,p_attribute12 in varchar2 default hr_api.g_varchar2
221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 225: ,p_attribute17 in varchar2 default hr_api.g_varchar2

221: ,p_attribute13 in varchar2 default hr_api.g_varchar2
222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_return_status out nocopy varchar2

Line 226: ,p_attribute18 in varchar2 default hr_api.g_varchar2

222: ,p_attribute14 in varchar2 default hr_api.g_varchar2
223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_return_status out nocopy varchar2
230: ) is

Line 227: ,p_attribute19 in varchar2 default hr_api.g_varchar2

223: ,p_attribute15 in varchar2 default hr_api.g_varchar2
224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_return_status out nocopy varchar2
230: ) is
231: --

Line 228: ,p_attribute20 in varchar2 default hr_api.g_varchar2

224: ,p_attribute16 in varchar2 default hr_api.g_varchar2
225: ,p_attribute17 in varchar2 default hr_api.g_varchar2
226: ,p_attribute18 in varchar2 default hr_api.g_varchar2
227: ,p_attribute19 in varchar2 default hr_api.g_varchar2
228: ,p_attribute20 in varchar2 default hr_api.g_varchar2
229: ,p_return_status out nocopy varchar2
230: ) is
231: --
232: -- Variables for API Boolean parameters

Line 258: hr_api.constant_to_boolean

254: --
255: -- Convert constant values to their corresponding boolean value
256: --
257: l_validate :=
258: hr_api.constant_to_boolean
259: (p_constant_value => p_validate);
260: --
261: -- Register Surrogate ID or user key values
262: --

Line 351: (p_validate in number default hr_api.g_false_num

347: -- ----------------------------------------------------------------------------
348: -- |---------------------< delete_lp_section >---------------------|
349: -- ----------------------------------------------------------------------------
350: PROCEDURE delete_lp_section
351: (p_validate in number default hr_api.g_false_num
352: ,p_learning_path_section_id in number
353: ,p_object_version_number in number
354: ,p_return_status out nocopy varchar2
355: ) is

Line 381: hr_api.constant_to_boolean

377: --
378: -- Convert constant values to their corresponding boolean value
379: --
380: l_validate :=
381: hr_api.constant_to_boolean
382: (p_constant_value => p_validate);
383: --
384: -- Register Surrogate ID or user key values
385: --