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

Line 84: ,p_language_code in varchar2 default hr_api.userenv_lang

80: ,p_business_group_id in number default null
81: ,p_shared_type_name in varchar2 default null
82: ,p_shared_type_code in varchar2 default null
83: ,p_system_type_cd in varchar2 default null
84: ,p_language_code in varchar2 default hr_api.userenv_lang
85: ,p_information1 in varchar2 default null
86: ,p_information2 in varchar2 default null
87: ,p_information3 in varchar2 default null
88: ,p_information4 in varchar2 default null

Line 138: hr_api.validate_language_code(p_language_code => l_language_code);

134: savepoint create_shared_type;
135: --
136: --
137: l_language_code := p_language_code;
138: hr_api.validate_language_code(p_language_code => l_language_code);
139: --
140: hr_utility.set_location(l_proc, 20);
141: --
142: -- Process Logic

Line 189: when hr_api.cannot_find_prog_unit then

185: ,p_lookup_type => p_lookup_type
186: ,p_effective_date => trunc(p_effective_date)
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (
192: p_module_name => 'CREATE_shared_types'
193: ,p_hook_type => 'BP'

Line 190: hr_api.cannot_find_prog_unit_error

186: ,p_effective_date => trunc(p_effective_date)
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (
192: p_module_name => 'CREATE_shared_types'
193: ,p_hook_type => 'BP'
194: );

Line 295: when hr_api.cannot_find_prog_unit then

291: ,p_lookup_type => p_lookup_type
292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_shared_types'
298: ,p_hook_type => 'AP'
299: );

Line 296: hr_api.cannot_find_prog_unit_error

292: ,p_effective_date => trunc(p_effective_date)
293: );
294: exception
295: when hr_api.cannot_find_prog_unit then
296: hr_api.cannot_find_prog_unit_error
297: (p_module_name => 'CREATE_shared_types'
298: ,p_hook_type => 'AP'
299: );
300: --

Line 310: raise hr_api.validate_enabled;

306: --
307: -- When in validation only mode raise the Validate_Enabled exception
308: --
309: if p_validate then
310: raise hr_api.validate_enabled;
311: end if;
312: --
313: -- Set all output arguments
314: --

Line 322: when hr_api.validate_enabled then

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

Line 354: ,p_business_group_id in number default hr_api.g_number

350: --
351: procedure update_shared_type
352: (p_validate in boolean default false
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang

Line 355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2

351: procedure update_shared_type
352: (p_validate in boolean default false
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2

352: (p_validate in boolean default false
353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2

353: ,p_shared_type_id in number
354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 358: ,p_language_code in varchar2 default hr_api.userenv_lang

354: ,p_business_group_id in number default hr_api.g_number
355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 359: ,p_information1 in varchar2 default hr_api.g_varchar2

355: ,p_shared_type_name in varchar2 default hr_api.g_varchar2
356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 360: ,p_information2 in varchar2 default hr_api.g_varchar2

356: ,p_shared_type_code in varchar2 default hr_api.g_varchar2
357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 361: ,p_information3 in varchar2 default hr_api.g_varchar2

357: ,p_system_type_cd in varchar2 default hr_api.g_varchar2
358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 362: ,p_information4 in varchar2 default hr_api.g_varchar2

358: ,p_language_code in varchar2 default hr_api.userenv_lang
359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 363: ,p_information5 in varchar2 default hr_api.g_varchar2

359: ,p_information1 in varchar2 default hr_api.g_varchar2
360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 364: ,p_information6 in varchar2 default hr_api.g_varchar2

360: ,p_information2 in varchar2 default hr_api.g_varchar2
361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 365: ,p_information7 in varchar2 default hr_api.g_varchar2

361: ,p_information3 in varchar2 default hr_api.g_varchar2
362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 366: ,p_information8 in varchar2 default hr_api.g_varchar2

362: ,p_information4 in varchar2 default hr_api.g_varchar2
363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 367: ,p_information9 in varchar2 default hr_api.g_varchar2

363: ,p_information5 in varchar2 default hr_api.g_varchar2
364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 368: ,p_information10 in varchar2 default hr_api.g_varchar2

364: ,p_information6 in varchar2 default hr_api.g_varchar2
365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 369: ,p_information11 in varchar2 default hr_api.g_varchar2

365: ,p_information7 in varchar2 default hr_api.g_varchar2
366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 370: ,p_information12 in varchar2 default hr_api.g_varchar2

366: ,p_information8 in varchar2 default hr_api.g_varchar2
367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 371: ,p_information13 in varchar2 default hr_api.g_varchar2

367: ,p_information9 in varchar2 default hr_api.g_varchar2
368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 372: ,p_information14 in varchar2 default hr_api.g_varchar2

368: ,p_information10 in varchar2 default hr_api.g_varchar2
369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 373: ,p_information15 in varchar2 default hr_api.g_varchar2

369: ,p_information11 in varchar2 default hr_api.g_varchar2
370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 374: ,p_information16 in varchar2 default hr_api.g_varchar2

370: ,p_information12 in varchar2 default hr_api.g_varchar2
371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 375: ,p_information17 in varchar2 default hr_api.g_varchar2

371: ,p_information13 in varchar2 default hr_api.g_varchar2
372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 376: ,p_information18 in varchar2 default hr_api.g_varchar2

372: ,p_information14 in varchar2 default hr_api.g_varchar2
373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 377: ,p_information19 in varchar2 default hr_api.g_varchar2

373: ,p_information15 in varchar2 default hr_api.g_varchar2
374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 378: ,p_information20 in varchar2 default hr_api.g_varchar2

374: ,p_information16 in varchar2 default hr_api.g_varchar2
375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 379: ,p_information21 in varchar2 default hr_api.g_varchar2

375: ,p_information17 in varchar2 default hr_api.g_varchar2
376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 380: ,p_information22 in varchar2 default hr_api.g_varchar2

376: ,p_information18 in varchar2 default hr_api.g_varchar2
377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 381: ,p_information23 in varchar2 default hr_api.g_varchar2

377: ,p_information19 in varchar2 default hr_api.g_varchar2
378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 382: ,p_information24 in varchar2 default hr_api.g_varchar2

378: ,p_information20 in varchar2 default hr_api.g_varchar2
379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 383: ,p_information25 in varchar2 default hr_api.g_varchar2

379: ,p_information21 in varchar2 default hr_api.g_varchar2
380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 384: ,p_information26 in varchar2 default hr_api.g_varchar2

380: ,p_information22 in varchar2 default hr_api.g_varchar2
381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 385: ,p_information27 in varchar2 default hr_api.g_varchar2

381: ,p_information23 in varchar2 default hr_api.g_varchar2
382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 386: ,p_information28 in varchar2 default hr_api.g_varchar2

382: ,p_information24 in varchar2 default hr_api.g_varchar2
383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number

Line 387: ,p_information29 in varchar2 default hr_api.g_varchar2

383: ,p_information25 in varchar2 default hr_api.g_varchar2
384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2

Line 388: ,p_information30 in varchar2 default hr_api.g_varchar2

384: ,p_information26 in varchar2 default hr_api.g_varchar2
385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
392: ,p_effective_date in date

Line 389: ,p_information_category in varchar2 default hr_api.g_varchar2

385: ,p_information27 in varchar2 default hr_api.g_varchar2
386: ,p_information28 in varchar2 default hr_api.g_varchar2
387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
392: ,p_effective_date in date
393: ) is

Line 391: ,p_lookup_type in varchar2 default hr_api.g_varchar2

387: ,p_information29 in varchar2 default hr_api.g_varchar2
388: ,p_information30 in varchar2 default hr_api.g_varchar2
389: ,p_information_category in varchar2 default hr_api.g_varchar2
390: ,p_object_version_number in out nocopy number
391: ,p_lookup_type in varchar2 default hr_api.g_varchar2
392: ,p_effective_date in date
393: ) is
394: --
395: -- Declare cursors and local variables

Line 412: hr_api.validate_language_code(p_language_code => l_language_code);

408: savepoint update_shared_type;
409: --
410: --
411: l_language_code := p_language_code;
412: hr_api.validate_language_code(p_language_code => l_language_code);
413: --
414: hr_utility.set_location(l_proc, 20);
415: --
416: -- Process Logic

Line 467: when hr_api.cannot_find_prog_unit then

463: ,p_lookup_type => p_lookup_type
464: ,p_effective_date => trunc(p_effective_date)
465: );
466: exception
467: when hr_api.cannot_find_prog_unit then
468: hr_api.cannot_find_prog_unit_error
469: (p_module_name => 'UPDATE_shared_types'
470: ,p_hook_type => 'BP'
471: );

Line 468: hr_api.cannot_find_prog_unit_error

464: ,p_effective_date => trunc(p_effective_date)
465: );
466: exception
467: when hr_api.cannot_find_prog_unit then
468: hr_api.cannot_find_prog_unit_error
469: (p_module_name => 'UPDATE_shared_types'
470: ,p_hook_type => 'BP'
471: );
472: --

Line 571: when hr_api.cannot_find_prog_unit then

567: ,p_lookup_type => p_lookup_type
568: ,p_effective_date => trunc(p_effective_date)
569: );
570: exception
571: when hr_api.cannot_find_prog_unit then
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'UPDATE_shared_types'
574: ,p_hook_type => 'AP'
575: );

Line 572: hr_api.cannot_find_prog_unit_error

568: ,p_effective_date => trunc(p_effective_date)
569: );
570: exception
571: when hr_api.cannot_find_prog_unit then
572: hr_api.cannot_find_prog_unit_error
573: (p_module_name => 'UPDATE_shared_types'
574: ,p_hook_type => 'AP'
575: );
576: --

Line 586: raise hr_api.validate_enabled;

582: --
583: -- When in validation only mode raise the Validate_Enabled exception
584: --
585: if p_validate then
586: raise hr_api.validate_enabled;
587: end if;
588: --
589: -- Set all output arguments
590: --

Line 597: when hr_api.validate_enabled then

593: hr_utility.set_location(' Leaving:'||l_proc, 70);
594: --
595: exception
596: --
597: when hr_api.validate_enabled then
598: --
599: -- As the Validate_Enabled exception has been raised
600: -- we must rollback to the savepoint
601: --

Line 661: when hr_api.cannot_find_prog_unit then

657: ,p_object_version_number => p_object_version_number
658: ,p_effective_date => trunc(p_effective_date)
659: );
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'DELETE_shared_types'
664: ,p_hook_type => 'BP'
665: );

Line 662: hr_api.cannot_find_prog_unit_error

658: ,p_effective_date => trunc(p_effective_date)
659: );
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'DELETE_shared_types'
664: ,p_hook_type => 'BP'
665: );
666: --

Line 699: when hr_api.cannot_find_prog_unit then

695: ,p_object_version_number => l_object_version_number
696: ,p_effective_date => trunc(p_effective_date)
697: );
698: exception
699: when hr_api.cannot_find_prog_unit then
700: hr_api.cannot_find_prog_unit_error
701: (p_module_name => 'DELETE_shared_types'
702: ,p_hook_type => 'AP'
703: );

Line 700: hr_api.cannot_find_prog_unit_error

696: ,p_effective_date => trunc(p_effective_date)
697: );
698: exception
699: when hr_api.cannot_find_prog_unit then
700: hr_api.cannot_find_prog_unit_error
701: (p_module_name => 'DELETE_shared_types'
702: ,p_hook_type => 'AP'
703: );
704: --

Line 714: raise hr_api.validate_enabled;

710: --
711: -- When in validation only mode raise the Validate_Enabled exception
712: --
713: if p_validate then
714: raise hr_api.validate_enabled;
715: end if;
716: --
717: hr_utility.set_location(' Leaving:'||l_proc, 70);
718: --

Line 721: when hr_api.validate_enabled then

717: hr_utility.set_location(' Leaving:'||l_proc, 70);
718: --
719: exception
720: --
721: when hr_api.validate_enabled then
722: --
723: -- As the Validate_Enabled exception has been raised
724: -- we must rollback to the savepoint
725: --