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

Line 159: when hr_api.cannot_find_prog_unit then

155: ,p_shp_information19 => p_shp_information19
156: ,p_shp_information20 => p_shp_information20
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_service_history_period'
162: ,p_hook_type => 'BP'
163: );

Line 160: hr_api.cannot_find_prog_unit_error

156: ,p_shp_information20 => p_shp_information20
157: );
158: exception
159: when hr_api.cannot_find_prog_unit then
160: hr_api.cannot_find_prog_unit_error
161: (p_module_name => 'create_service_history_period'
162: ,p_hook_type => 'BP'
163: );
164: end;

Line 303: when hr_api.cannot_find_prog_unit then

299: ,p_shp_information19 => p_shp_information19
300: ,p_shp_information20 => p_shp_information20
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'create_service_history_period'
306: ,p_hook_type => 'AP'
307: );

Line 304: hr_api.cannot_find_prog_unit_error

300: ,p_shp_information20 => p_shp_information20
301: );
302: exception
303: when hr_api.cannot_find_prog_unit then
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'create_service_history_period'
306: ,p_hook_type => 'AP'
307: );
308: end;

Line 314: raise hr_api.validate_enabled;

310: --
311: -- When in validation only mode raise the Validate_Enabled exception
312: --
313: if p_validate then
314: raise hr_api.validate_enabled;
315: end if;
316: --
317: -- Set all output arguments
318: --

Line 324: when hr_api.validate_enabled then

320: p_object_version_number := l_object_version_number;
321: --
322: hr_utility.set_location(' Leaving:'||l_proc, 70);
323: exception
324: when hr_api.validate_enabled then
325: --
326: -- As the Validate_Enabled exception has been raised
327: -- we must rollback to the savepoint
328: --

Line 356: ,p_assignment_id in number default hr_api.g_number

352: --
353: procedure update_service_history_period
354: (p_validate in boolean default false
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2

Line 357: ,p_start_date in date default hr_api.g_date

353: procedure update_service_history_period
354: (p_validate in boolean default false
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2

Line 358: ,p_end_date in date default hr_api.g_date

354: (p_validate in boolean default false
355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2

Line 359: ,p_employer_name in varchar2 default hr_api.g_varchar2

355: ,p_service_history_period_id in number
356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2

Line 360: ,p_employer_address in varchar2 default hr_api.g_varchar2

356: ,p_assignment_id in number default hr_api.g_number
357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2

Line 361: ,p_employer_type in varchar2 default hr_api.g_varchar2

357: ,p_start_date in date default hr_api.g_date
358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2

Line 362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2

358: ,p_end_date in date default hr_api.g_date
359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number

Line 363: ,p_description in varchar2 default hr_api.g_varchar2

359: ,p_employer_name in varchar2 default hr_api.g_varchar2
360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number

Line 364: ,p_continuous_service in varchar2 default hr_api.g_varchar2

360: ,p_employer_address in varchar2 default hr_api.g_varchar2
361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2

Line 365: ,p_all_assignments in varchar2 default hr_api.g_varchar2

361: ,p_employer_type in varchar2 default hr_api.g_varchar2
362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2

Line 366: ,p_period_years in number default hr_api.g_number

362: ,p_employer_subtype in varchar2 default hr_api.g_varchar2
363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2

Line 367: ,p_period_days in number default hr_api.g_number

363: ,p_description in varchar2 default hr_api.g_varchar2
364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2

Line 368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2

364: ,p_continuous_service in varchar2 default hr_api.g_varchar2
365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2

Line 369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2

365: ,p_all_assignments in varchar2 default hr_api.g_varchar2
366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2

Line 370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2

366: ,p_period_years in number default hr_api.g_number
367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2

Line 371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2

367: ,p_period_days in number default hr_api.g_number
368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2

Line 372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2

368: ,p_shp_attribute_category in varchar2 default hr_api.g_varchar2
369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2

Line 373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2

369: ,p_shp_attribute1 in varchar2 default hr_api.g_varchar2
370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2

Line 374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2

370: ,p_shp_attribute2 in varchar2 default hr_api.g_varchar2
371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2

Line 375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2

371: ,p_shp_attribute3 in varchar2 default hr_api.g_varchar2
372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2

Line 376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2

372: ,p_shp_attribute4 in varchar2 default hr_api.g_varchar2
373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2

Line 377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2

373: ,p_shp_attribute5 in varchar2 default hr_api.g_varchar2
374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2

Line 378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2

374: ,p_shp_attribute6 in varchar2 default hr_api.g_varchar2
375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2

Line 379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2

375: ,p_shp_attribute7 in varchar2 default hr_api.g_varchar2
376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2

Line 380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2

376: ,p_shp_attribute8 in varchar2 default hr_api.g_varchar2
377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2

Line 381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2

377: ,p_shp_attribute9 in varchar2 default hr_api.g_varchar2
378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2

Line 382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2

378: ,p_shp_attribute10 in varchar2 default hr_api.g_varchar2
379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2

Line 383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2

379: ,p_shp_attribute11 in varchar2 default hr_api.g_varchar2
380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2

Line 384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2

380: ,p_shp_attribute12 in varchar2 default hr_api.g_varchar2
381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2

Line 385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2

381: ,p_shp_attribute13 in varchar2 default hr_api.g_varchar2
382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2

Line 386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2

382: ,p_shp_attribute14 in varchar2 default hr_api.g_varchar2
383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2

Line 387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2

383: ,p_shp_attribute15 in varchar2 default hr_api.g_varchar2
384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2

Line 388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2

384: ,p_shp_attribute16 in varchar2 default hr_api.g_varchar2
385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2

Line 389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2

385: ,p_shp_attribute17 in varchar2 default hr_api.g_varchar2
386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2

Line 390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2

386: ,p_shp_attribute18 in varchar2 default hr_api.g_varchar2
387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2

Line 391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2

387: ,p_shp_attribute19 in varchar2 default hr_api.g_varchar2
388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2

Line 392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2

388: ,p_shp_attribute20 in varchar2 default hr_api.g_varchar2
389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2

Line 393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2

389: ,p_shp_information_category in varchar2 default hr_api.g_varchar2
390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2

Line 394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2

390: ,p_shp_information1 in varchar2 default hr_api.g_varchar2
391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2

Line 395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2

391: ,p_shp_information2 in varchar2 default hr_api.g_varchar2
392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2

Line 396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2

392: ,p_shp_information3 in varchar2 default hr_api.g_varchar2
393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2

Line 397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2

393: ,p_shp_information4 in varchar2 default hr_api.g_varchar2
394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2

Line 398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2

394: ,p_shp_information5 in varchar2 default hr_api.g_varchar2
395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2

Line 399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2

395: ,p_shp_information6 in varchar2 default hr_api.g_varchar2
396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2

Line 400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2

396: ,p_shp_information7 in varchar2 default hr_api.g_varchar2
397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2

Line 401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2

397: ,p_shp_information8 in varchar2 default hr_api.g_varchar2
398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2

Line 402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2

398: ,p_shp_information9 in varchar2 default hr_api.g_varchar2
399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2

Line 403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2

399: ,p_shp_information10 in varchar2 default hr_api.g_varchar2
400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2

Line 404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2

400: ,p_shp_information11 in varchar2 default hr_api.g_varchar2
401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2

Line 405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2

401: ,p_shp_information12 in varchar2 default hr_api.g_varchar2
402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2

Line 406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2

402: ,p_shp_information13 in varchar2 default hr_api.g_varchar2
403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number

Line 407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2

403: ,p_shp_information14 in varchar2 default hr_api.g_varchar2
404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
411: ) is

Line 408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2

404: ,p_shp_information15 in varchar2 default hr_api.g_varchar2
405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
411: ) is
412:

Line 409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2

405: ,p_shp_information16 in varchar2 default hr_api.g_varchar2
406: ,p_shp_information17 in varchar2 default hr_api.g_varchar2
407: ,p_shp_information18 in varchar2 default hr_api.g_varchar2
408: ,p_shp_information19 in varchar2 default hr_api.g_varchar2
409: ,p_shp_information20 in varchar2 default hr_api.g_varchar2
410: ,p_object_version_number in out nocopy number
411: ) is
412:
413: --

Line 497: when hr_api.cannot_find_prog_unit then

493: ,p_shp_information19 => p_shp_information19
494: ,p_shp_information20 => p_shp_information20
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'update_service_history_period'
500: ,p_hook_type => 'BP'
501: );

Line 498: hr_api.cannot_find_prog_unit_error

494: ,p_shp_information20 => p_shp_information20
495: );
496: exception
497: when hr_api.cannot_find_prog_unit then
498: hr_api.cannot_find_prog_unit_error
499: (p_module_name => 'update_service_history_period'
500: ,p_hook_type => 'BP'
501: );
502: end;

Line 640: when hr_api.cannot_find_prog_unit then

636: ,p_shp_information19 => p_shp_information19
637: ,p_shp_information20 => p_shp_information20
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'update_service_history_period'
643: ,p_hook_type => 'AP'
644: );

Line 641: hr_api.cannot_find_prog_unit_error

637: ,p_shp_information20 => p_shp_information20
638: );
639: exception
640: when hr_api.cannot_find_prog_unit then
641: hr_api.cannot_find_prog_unit_error
642: (p_module_name => 'update_service_history_period'
643: ,p_hook_type => 'AP'
644: );
645: end;

Line 651: raise hr_api.validate_enabled;

647: --
648: -- When in validation only mode raise the Validate_Enabled exception
649: --
650: if p_validate then
651: raise hr_api.validate_enabled;
652: end if;
653: --
654: -- Set all output arguments
655: --

Line 660: when hr_api.validate_enabled then

656: p_object_version_number := l_object_version_number;
657: --
658: hr_utility.set_location(' Leaving:'||l_proc, 70);
659: exception
660: when hr_api.validate_enabled then
661: --
662: -- As the Validate_Enabled exception has been raised
663: -- we must rollback to the savepoint
664: --

Line 716: when hr_api.cannot_find_prog_unit then

712: (p_service_history_period_id => p_service_history_period_id
713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'delete_service_history_period'
719: ,p_hook_type => 'BP'
720: );

Line 717: hr_api.cannot_find_prog_unit_error

713: ,p_object_version_number => p_object_version_number
714: );
715: exception
716: when hr_api.cannot_find_prog_unit then
717: hr_api.cannot_find_prog_unit_error
718: (p_module_name => 'delete_service_history_period'
719: ,p_hook_type => 'BP'
720: );
721: end;

Line 750: when hr_api.cannot_find_prog_unit then

746: (p_service_history_period_id => p_service_history_period_id
747: ,p_object_version_number => p_object_version_number
748: );
749: exception
750: when hr_api.cannot_find_prog_unit then
751: hr_api.cannot_find_prog_unit_error
752: (p_module_name => 'delete_service_history_period'
753: ,p_hook_type => 'AP'
754: );

Line 751: hr_api.cannot_find_prog_unit_error

747: ,p_object_version_number => p_object_version_number
748: );
749: exception
750: when hr_api.cannot_find_prog_unit then
751: hr_api.cannot_find_prog_unit_error
752: (p_module_name => 'delete_service_history_period'
753: ,p_hook_type => 'AP'
754: );
755: end;

Line 761: raise hr_api.validate_enabled;

757: --
758: -- When in validation only mode raise the Validate_Enabled exception
759: --
760: if p_validate then
761: raise hr_api.validate_enabled;
762: end if;
763: --
764: -- Set all output arguments
765: --

Line 769: when hr_api.validate_enabled then

765: --
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 70);
768: exception
769: when hr_api.validate_enabled then
770: --
771: -- As the Validate_Enabled exception has been raised
772: -- we must rollback to the savepoint
773: --