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.PER_SP_PLAN_API dependencies on HR_API

Line 114: when hr_api.cannot_find_prog_unit then

110: ,p_attribute18 => p_attribute18
111: ,p_attribute19 => p_attribute19
112: ,p_attribute20 => p_attribute20 );
113: exception
114: when hr_api.cannot_find_prog_unit then
115: hr_api.cannot_find_prog_unit_error
116: (p_module_name => 'create_sp_plan_b'
117: ,p_hook_type => 'BP'
118: );

Line 115: hr_api.cannot_find_prog_unit_error

111: ,p_attribute19 => p_attribute19
112: ,p_attribute20 => p_attribute20 );
113: exception
114: when hr_api.cannot_find_prog_unit then
115: hr_api.cannot_find_prog_unit_error
116: (p_module_name => 'create_sp_plan_b'
117: ,p_hook_type => 'BP'
118: );
119: end;

Line 214: when hr_api.cannot_find_prog_unit then

210: ,p_attribute18 => p_attribute18
211: ,p_attribute19 => p_attribute19
212: ,p_attribute20 => p_attribute20 );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'create_sp_plan_b'
217: ,p_hook_type => 'AP'
218: );

Line 215: hr_api.cannot_find_prog_unit_error

211: ,p_attribute19 => p_attribute19
212: ,p_attribute20 => p_attribute20 );
213: exception
214: when hr_api.cannot_find_prog_unit then
215: hr_api.cannot_find_prog_unit_error
216: (p_module_name => 'create_sp_plan_b'
217: ,p_hook_type => 'AP'
218: );
219: end;

Line 226: raise hr_api.validate_enabled;

222: --
223: -- When in validation only mode raise the Validate_Enabled exception
224: --
225: if p_validate then
226: raise hr_api.validate_enabled;
227: end if;
228: --
229: -- Set all IN OUT and OUT parameters with out values
230: --

Line 236: when hr_api.validate_enabled then

232: p_object_version_number := l_object_version_number;
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: exception
236: when hr_api.validate_enabled then
237: --
238: -- As the Validate_Enabled exception has been raised
239: -- we must rollback to the savepoint
240: --

Line 275: ,p_plan_type in varchar2 default hr_api.g_varchar2

271: (p_validate in boolean default false
272: ,p_effective_date in date
273: ,p_plan_id in number
274: ,p_object_version_number in out nocopy number
275: ,p_plan_type in varchar2 default hr_api.g_varchar2
276: ,p_plan_name in varchar2 default hr_api.g_varchar2
277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2

Line 276: ,p_plan_name in varchar2 default hr_api.g_varchar2

272: ,p_effective_date in date
273: ,p_plan_id in number
274: ,p_object_version_number in out nocopy number
275: ,p_plan_type in varchar2 default hr_api.g_varchar2
276: ,p_plan_name in varchar2 default hr_api.g_varchar2
277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number

Line 277: ,p_successee_id in number default hr_api.g_number

273: ,p_plan_id in number
274: ,p_object_version_number in out nocopy number
275: ,p_plan_type in varchar2 default hr_api.g_varchar2
276: ,p_plan_name in varchar2 default hr_api.g_varchar2
277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date

Line 278: ,p_business_group_id in number default hr_api.g_number

274: ,p_object_version_number in out nocopy number
275: ,p_plan_type in varchar2 default hr_api.g_varchar2
276: ,p_plan_name in varchar2 default hr_api.g_varchar2
277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date

Line 279: ,p_status in varchar2 default hr_api.g_varchar2

275: ,p_plan_type in varchar2 default hr_api.g_varchar2
276: ,p_plan_name in varchar2 default hr_api.g_varchar2
277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2

Line 280: ,p_plan_owner in number default hr_api.g_number

276: ,p_plan_name in varchar2 default hr_api.g_varchar2
277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2

Line 281: ,p_start_date in date default hr_api.g_date

277: ,p_successee_id in number default hr_api.g_number
278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number

Line 282: ,p_end_date in date default hr_api.g_date

278: ,p_business_group_id in number default hr_api.g_number
279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date

Line 283: ,p_description in varchar2 default hr_api.g_varchar2

279: ,p_status in varchar2 default hr_api.g_varchar2
280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date

Line 284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2

280: ,p_plan_owner in number default hr_api.g_number
281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number

Line 285: ,p_filled_by in number default hr_api.g_number

281: ,p_start_date in date default hr_api.g_date
282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 286: ,p_filled_on in date default hr_api.g_date

282: ,p_end_date in date default hr_api.g_date
283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 287: ,p_next_review_date in date default hr_api.g_date

283: ,p_description in varchar2 default hr_api.g_varchar2
284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 288: ,p_criteria_set_id in number default hr_api.g_number

284: ,p_filled_from_plan in varchar2 default hr_api.g_varchar2
285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 289: ,p_attribute_category in varchar2 default hr_api.g_varchar2

285: ,p_filled_by in number default hr_api.g_number
286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 290: ,p_attribute1 in varchar2 default hr_api.g_varchar2

286: ,p_filled_on in date default hr_api.g_date
287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 291: ,p_attribute2 in varchar2 default hr_api.g_varchar2

287: ,p_next_review_date in date default hr_api.g_date
288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 292: ,p_attribute3 in varchar2 default hr_api.g_varchar2

288: ,p_criteria_set_id in number default hr_api.g_number
289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 293: ,p_attribute4 in varchar2 default hr_api.g_varchar2

289: ,p_attribute_category in varchar2 default hr_api.g_varchar2
290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 294: ,p_attribute5 in varchar2 default hr_api.g_varchar2

290: ,p_attribute1 in varchar2 default hr_api.g_varchar2
291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 295: ,p_attribute6 in varchar2 default hr_api.g_varchar2

291: ,p_attribute2 in varchar2 default hr_api.g_varchar2
292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 296: ,p_attribute7 in varchar2 default hr_api.g_varchar2

292: ,p_attribute3 in varchar2 default hr_api.g_varchar2
293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 297: ,p_attribute8 in varchar2 default hr_api.g_varchar2

293: ,p_attribute4 in varchar2 default hr_api.g_varchar2
294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 298: ,p_attribute9 in varchar2 default hr_api.g_varchar2

294: ,p_attribute5 in varchar2 default hr_api.g_varchar2
295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 299: ,p_attribute10 in varchar2 default hr_api.g_varchar2

295: ,p_attribute6 in varchar2 default hr_api.g_varchar2
296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 300: ,p_attribute11 in varchar2 default hr_api.g_varchar2

296: ,p_attribute7 in varchar2 default hr_api.g_varchar2
297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 301: ,p_attribute12 in varchar2 default hr_api.g_varchar2

297: ,p_attribute8 in varchar2 default hr_api.g_varchar2
298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 302: ,p_attribute13 in varchar2 default hr_api.g_varchar2

298: ,p_attribute9 in varchar2 default hr_api.g_varchar2
299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 303: ,p_attribute14 in varchar2 default hr_api.g_varchar2

299: ,p_attribute10 in varchar2 default hr_api.g_varchar2
300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 304: ,p_attribute15 in varchar2 default hr_api.g_varchar2

300: ,p_attribute11 in varchar2 default hr_api.g_varchar2
301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 305: ,p_attribute16 in varchar2 default hr_api.g_varchar2

301: ,p_attribute12 in varchar2 default hr_api.g_varchar2
302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_attribute20 in varchar2 default hr_api.g_varchar2) is

Line 306: ,p_attribute17 in varchar2 default hr_api.g_varchar2

302: ,p_attribute13 in varchar2 default hr_api.g_varchar2
303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_attribute20 in varchar2 default hr_api.g_varchar2) is
310: --

Line 307: ,p_attribute18 in varchar2 default hr_api.g_varchar2

303: ,p_attribute14 in varchar2 default hr_api.g_varchar2
304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_attribute20 in varchar2 default hr_api.g_varchar2) is
310: --
311: -- Declare cursors and local variables

Line 308: ,p_attribute19 in varchar2 default hr_api.g_varchar2

304: ,p_attribute15 in varchar2 default hr_api.g_varchar2
305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_attribute20 in varchar2 default hr_api.g_varchar2) is
310: --
311: -- Declare cursors and local variables
312: --

Line 309: ,p_attribute20 in varchar2 default hr_api.g_varchar2) is

305: ,p_attribute16 in varchar2 default hr_api.g_varchar2
306: ,p_attribute17 in varchar2 default hr_api.g_varchar2
307: ,p_attribute18 in varchar2 default hr_api.g_varchar2
308: ,p_attribute19 in varchar2 default hr_api.g_varchar2
309: ,p_attribute20 in varchar2 default hr_api.g_varchar2) is
310: --
311: -- Declare cursors and local variables
312: --
313: l_effective_date date;

Line 374: when hr_api.cannot_find_prog_unit then

370: ,p_attribute18 => p_attribute18
371: ,p_attribute19 => p_attribute19
372: ,p_attribute20 => p_attribute20 );
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'update_sp_plan_b'
377: ,p_hook_type => 'BP'
378: );

Line 375: hr_api.cannot_find_prog_unit_error

371: ,p_attribute19 => p_attribute19
372: ,p_attribute20 => p_attribute20 );
373: exception
374: when hr_api.cannot_find_prog_unit then
375: hr_api.cannot_find_prog_unit_error
376: (p_module_name => 'update_sp_plan_b'
377: ,p_hook_type => 'BP'
378: );
379: end;

Line 474: when hr_api.cannot_find_prog_unit then

470: ,p_attribute18 => p_attribute18
471: ,p_attribute19 => p_attribute19
472: ,p_attribute20 => p_attribute20 );
473: exception
474: when hr_api.cannot_find_prog_unit then
475: hr_api.cannot_find_prog_unit_error
476: (p_module_name => 'update_sp_plan_b'
477: ,p_hook_type => 'AP'
478: );

Line 475: hr_api.cannot_find_prog_unit_error

471: ,p_attribute19 => p_attribute19
472: ,p_attribute20 => p_attribute20 );
473: exception
474: when hr_api.cannot_find_prog_unit then
475: hr_api.cannot_find_prog_unit_error
476: (p_module_name => 'update_sp_plan_b'
477: ,p_hook_type => 'AP'
478: );
479: end;

Line 486: raise hr_api.validate_enabled;

482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --
485: if p_validate then
486: raise hr_api.validate_enabled;
487: end if;
488: --
489: -- Set all IN OUT and OUT parameters with out values
490: --

Line 495: when hr_api.validate_enabled then

491: p_object_version_number := l_object_version_number;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 70);
494: exception
495: when hr_api.validate_enabled then
496: --
497: -- As the Validate_Enabled exception has been raised
498: -- we must rollback to the savepoint
499: --

Line 549: raise hr_api.validate_enabled;

545: --
546: -- When in validation only mode raise the Validate_Enabled exception
547: --
548: if p_validate then
549: raise hr_api.validate_enabled;
550: end if;
551: --
552: -- Set all IN OUT and OUT parameters with out values
553: --

Line 557: when hr_api.validate_enabled then

553: --
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 70);
556: exception
557: when hr_api.validate_enabled then
558: --
559: -- As the Validate_Enabled exception has been raised
560: -- we must rollback to the savepoint
561: --