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

Line 42: if (p_desired_datetrack_mode = hr_api.g_update and l_update) then

38: ,p_update_override => l_update_override
39: ,p_update_change_insert => l_update_change_insert
40: );
41:
42: if (p_desired_datetrack_mode = hr_api.g_update and l_update) then
43: p_datetrack_allow := hr_api.g_update;
44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then
45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override

Line 43: p_datetrack_allow := hr_api.g_update;

39: ,p_update_change_insert => l_update_change_insert
40: );
41:
42: if (p_desired_datetrack_mode = hr_api.g_update and l_update) then
43: p_datetrack_allow := hr_api.g_update;
44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then
45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override
47: and l_update_override) then

Line 44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then

40: );
41:
42: if (p_desired_datetrack_mode = hr_api.g_update and l_update) then
43: p_datetrack_allow := hr_api.g_update;
44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then
45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override
47: and l_update_override) then
48: p_datetrack_allow := hr_api.g_update_override;

Line 45: p_datetrack_allow := hr_api.g_correction;

41:
42: if (p_desired_datetrack_mode = hr_api.g_update and l_update) then
43: p_datetrack_allow := hr_api.g_update;
44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then
45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override
47: and l_update_override) then
48: p_datetrack_allow := hr_api.g_update_override;
49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert

Line 46: elsif(p_desired_datetrack_mode = hr_api.g_update_override

42: if (p_desired_datetrack_mode = hr_api.g_update and l_update) then
43: p_datetrack_allow := hr_api.g_update;
44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then
45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override
47: and l_update_override) then
48: p_datetrack_allow := hr_api.g_update_override;
49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert
50: and l_update_change_insert) then

Line 48: p_datetrack_allow := hr_api.g_update_override;

44: elsif(p_desired_datetrack_mode = hr_api.g_correction and l_correction)then
45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override
47: and l_update_override) then
48: p_datetrack_allow := hr_api.g_update_override;
49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert
50: and l_update_change_insert) then
51: p_datetrack_allow := hr_api.g_update_change_insert;
52: elsif(l_update) then

Line 49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert

45: p_datetrack_allow := hr_api.g_correction;
46: elsif(p_desired_datetrack_mode = hr_api.g_update_override
47: and l_update_override) then
48: p_datetrack_allow := hr_api.g_update_override;
49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert
50: and l_update_change_insert) then
51: p_datetrack_allow := hr_api.g_update_change_insert;
52: elsif(l_update) then
53: p_datetrack_allow := hr_api.g_update;

Line 51: p_datetrack_allow := hr_api.g_update_change_insert;

47: and l_update_override) then
48: p_datetrack_allow := hr_api.g_update_override;
49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert
50: and l_update_change_insert) then
51: p_datetrack_allow := hr_api.g_update_change_insert;
52: elsif(l_update) then
53: p_datetrack_allow := hr_api.g_update;
54: elsif(l_correction) then
55: p_datetrack_allow := hr_api.g_correction;

Line 53: p_datetrack_allow := hr_api.g_update;

49: elsif(p_desired_datetrack_mode = hr_api.g_update_change_insert
50: and l_update_change_insert) then
51: p_datetrack_allow := hr_api.g_update_change_insert;
52: elsif(l_update) then
53: p_datetrack_allow := hr_api.g_update;
54: elsif(l_correction) then
55: p_datetrack_allow := hr_api.g_correction;
56: else
57: fnd_message.set_name('BEN', 'BEN_91700_DATETRACK_NOT_ALWD');

Line 55: p_datetrack_allow := hr_api.g_correction;

51: p_datetrack_allow := hr_api.g_update_change_insert;
52: elsif(l_update) then
53: p_datetrack_allow := hr_api.g_update;
54: elsif(l_correction) then
55: p_datetrack_allow := hr_api.g_correction;
56: else
57: fnd_message.set_name('BEN', 'BEN_91700_DATETRACK_NOT_ALWD');
58: fnd_message.set_token('MODE',p_desired_datetrack_mode);
59: fnd_message.raise_error;

Line 70: if (p_desired_datetrack_mode = hr_api.g_delete and l_delete) then

66: ,p_delete => l_delete
67: ,p_future_change => l_future_change
68: ,p_delete_next_change => l_delete_next_change);
69:
70: if (p_desired_datetrack_mode = hr_api.g_delete and l_delete) then
71: p_datetrack_allow := hr_api.g_delete;
72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then

Line 71: p_datetrack_allow := hr_api.g_delete;

67: ,p_future_change => l_future_change
68: ,p_delete_next_change => l_delete_next_change);
69:
70: if (p_desired_datetrack_mode = hr_api.g_delete and l_delete) then
71: p_datetrack_allow := hr_api.g_delete;
72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;

Line 72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then

68: ,p_delete_next_change => l_delete_next_change);
69:
70: if (p_desired_datetrack_mode = hr_api.g_delete and l_delete) then
71: p_datetrack_allow := hr_api.g_delete;
72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;
76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change

Line 73: p_datetrack_allow := hr_api.g_zap;

69:
70: if (p_desired_datetrack_mode = hr_api.g_delete and l_delete) then
71: p_datetrack_allow := hr_api.g_delete;
72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;
76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change
77: and l_delete_next_change) then

Line 74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then

70: if (p_desired_datetrack_mode = hr_api.g_delete and l_delete) then
71: p_datetrack_allow := hr_api.g_delete;
72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;
76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change
77: and l_delete_next_change) then
78: p_datetrack_allow := hr_api.g_delete_next_change;

Line 75: p_datetrack_allow := hr_api.g_future_change;

71: p_datetrack_allow := hr_api.g_delete;
72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;
76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change
77: and l_delete_next_change) then
78: p_datetrack_allow := hr_api.g_delete_next_change;
79: elsif (l_delete) then

Line 76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change

72: elsif(p_desired_datetrack_mode = hr_api.g_zap and l_zap)then
73: p_datetrack_allow := hr_api.g_zap;
74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;
76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change
77: and l_delete_next_change) then
78: p_datetrack_allow := hr_api.g_delete_next_change;
79: elsif (l_delete) then
80: p_datetrack_allow := hr_api.g_delete;

Line 78: p_datetrack_allow := hr_api.g_delete_next_change;

74: elsif(p_desired_datetrack_mode = hr_api.g_future_change and l_future_change) then
75: p_datetrack_allow := hr_api.g_future_change;
76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change
77: and l_delete_next_change) then
78: p_datetrack_allow := hr_api.g_delete_next_change;
79: elsif (l_delete) then
80: p_datetrack_allow := hr_api.g_delete;
81: elsif (l_zap) then
82: p_datetrack_allow := hr_api.g_zap;

Line 80: p_datetrack_allow := hr_api.g_delete;

76: elsif(p_desired_datetrack_mode = hr_api.g_delete_next_change
77: and l_delete_next_change) then
78: p_datetrack_allow := hr_api.g_delete_next_change;
79: elsif (l_delete) then
80: p_datetrack_allow := hr_api.g_delete;
81: elsif (l_zap) then
82: p_datetrack_allow := hr_api.g_zap;
83: else
84: fnd_message.set_name('BEN', 'BEN_91700_DATETRACK_NOT_ALWD');

Line 82: p_datetrack_allow := hr_api.g_zap;

78: p_datetrack_allow := hr_api.g_delete_next_change;
79: elsif (l_delete) then
80: p_datetrack_allow := hr_api.g_delete;
81: elsif (l_zap) then
82: p_datetrack_allow := hr_api.g_zap;
83: else
84: fnd_message.set_name('BEN', 'BEN_91700_DATETRACK_NOT_ALWD');
85: fnd_message.set_token('MODE',p_desired_datetrack_mode);
86: fnd_message.raise_error;

Line 221: when hr_api.cannot_find_prog_unit then

217: ,p_program_update_date => p_program_update_date
218: ,p_effective_date => trunc(p_effective_date)
219: );
220: exception
221: when hr_api.cannot_find_prog_unit then
222: hr_api.cannot_find_prog_unit_error
223: (
224: p_module_name => 'CREATE_PRMRY_CARE_PRVDR'
225: ,p_hook_type => 'BP'

Line 222: hr_api.cannot_find_prog_unit_error

218: ,p_effective_date => trunc(p_effective_date)
219: );
220: exception
221: when hr_api.cannot_find_prog_unit then
222: hr_api.cannot_find_prog_unit_error
223: (
224: p_module_name => 'CREATE_PRMRY_CARE_PRVDR'
225: ,p_hook_type => 'BP'
226: );

Line 358: when hr_api.cannot_find_prog_unit then

354: ,p_object_version_number => l_object_version_number
355: ,p_effective_date => trunc(p_effective_date)
356: );
357: exception
358: when hr_api.cannot_find_prog_unit then
359: hr_api.cannot_find_prog_unit_error
360: (p_module_name => 'CREATE_PRMRY_CARE_PRVDR'
361: ,p_hook_type => 'AP'
362: );

Line 359: hr_api.cannot_find_prog_unit_error

355: ,p_effective_date => trunc(p_effective_date)
356: );
357: exception
358: when hr_api.cannot_find_prog_unit then
359: hr_api.cannot_find_prog_unit_error
360: (p_module_name => 'CREATE_PRMRY_CARE_PRVDR'
361: ,p_hook_type => 'AP'
362: );
363: --

Line 373: raise hr_api.validate_enabled;

369: --
370: -- When in validation only mode raise the Validate_Enabled exception
371: --
372: if p_validate then
373: raise hr_api.validate_enabled;
374: end if;
375: --
376: -- Set all output arguments
377: --

Line 387: when hr_api.validate_enabled then

383: hr_utility.set_location(' Leaving:'||l_proc, 70);
384: --
385: exception
386: --
387: when hr_api.validate_enabled then
388: --
389: -- As the Validate_Enabled exception has been raised
390: -- we must rollback to the savepoint
391: --

Line 498: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2

494: (p_validate in boolean default false
495: ,p_prmry_care_prvdr_id in number
496: ,p_effective_start_date out nocopy date
497: ,p_effective_end_date out nocopy date
498: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
499: ,p_name in varchar2 default hr_api.g_varchar2
500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

Line 499: ,p_name in varchar2 default hr_api.g_varchar2

495: ,p_prmry_care_prvdr_id in number
496: ,p_effective_start_date out nocopy date
497: ,p_effective_end_date out nocopy date
498: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
499: ,p_name in varchar2 default hr_api.g_varchar2
500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number

Line 500: ,p_ext_ident in varchar2 default hr_api.g_varchar2

496: ,p_effective_start_date out nocopy date
497: ,p_effective_end_date out nocopy date
498: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
499: ,p_name in varchar2 default hr_api.g_varchar2
500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2

Line 501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

497: ,p_effective_end_date out nocopy date
498: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
499: ,p_name in varchar2 default hr_api.g_varchar2
500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2

Line 502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

498: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
499: ,p_name in varchar2 default hr_api.g_varchar2
500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2

Line 503: ,p_business_group_id in number default hr_api.g_number

499: ,p_name in varchar2 default hr_api.g_varchar2
500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2

Line 504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2

500: ,p_ext_ident in varchar2 default hr_api.g_varchar2
501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2

Line 505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2

501: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2

Line 506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2

502: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2

Line 507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2

503: ,p_business_group_id in number default hr_api.g_number
504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2

Line 508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2

504: ,p_ppr_attribute_category in varchar2 default hr_api.g_varchar2
505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2

Line 509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2

505: ,p_ppr_attribute1 in varchar2 default hr_api.g_varchar2
506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2

Line 510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2

506: ,p_ppr_attribute2 in varchar2 default hr_api.g_varchar2
507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2

Line 511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2

507: ,p_ppr_attribute3 in varchar2 default hr_api.g_varchar2
508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2

Line 512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2

508: ,p_ppr_attribute4 in varchar2 default hr_api.g_varchar2
509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2

Line 513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2

509: ,p_ppr_attribute5 in varchar2 default hr_api.g_varchar2
510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2

Line 514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2

510: ,p_ppr_attribute6 in varchar2 default hr_api.g_varchar2
511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2

Line 515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2

511: ,p_ppr_attribute7 in varchar2 default hr_api.g_varchar2
512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2

Line 516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2

512: ,p_ppr_attribute8 in varchar2 default hr_api.g_varchar2
513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2

Line 517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2

513: ,p_ppr_attribute9 in varchar2 default hr_api.g_varchar2
514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2

Line 518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2

514: ,p_ppr_attribute10 in varchar2 default hr_api.g_varchar2
515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2

Line 519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2

515: ,p_ppr_attribute11 in varchar2 default hr_api.g_varchar2
516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2

Line 520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2

516: ,p_ppr_attribute12 in varchar2 default hr_api.g_varchar2
517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2

Line 521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2

517: ,p_ppr_attribute13 in varchar2 default hr_api.g_varchar2
518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2

Line 522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2

518: ,p_ppr_attribute14 in varchar2 default hr_api.g_varchar2
519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2

Line 523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2

519: ,p_ppr_attribute15 in varchar2 default hr_api.g_varchar2
520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2

Line 524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2

520: ,p_ppr_attribute16 in varchar2 default hr_api.g_varchar2
521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2

Line 525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2

521: ,p_ppr_attribute17 in varchar2 default hr_api.g_varchar2
522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2

Line 526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2

522: ,p_ppr_attribute18 in varchar2 default hr_api.g_varchar2
523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2

Line 527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2

523: ,p_ppr_attribute19 in varchar2 default hr_api.g_varchar2
524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2

Line 528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2

524: ,p_ppr_attribute20 in varchar2 default hr_api.g_varchar2
525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2

Line 529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2

525: ,p_ppr_attribute21 in varchar2 default hr_api.g_varchar2
526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2

Line 530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2

526: ,p_ppr_attribute22 in varchar2 default hr_api.g_varchar2
527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2

Line 531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2

527: ,p_ppr_attribute23 in varchar2 default hr_api.g_varchar2
528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number

Line 532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2

528: ,p_ppr_attribute24 in varchar2 default hr_api.g_varchar2
529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number

Line 533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2

529: ,p_ppr_attribute25 in varchar2 default hr_api.g_varchar2
530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number
537: ,p_program_id in number default hr_api.g_number

Line 534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2

530: ,p_ppr_attribute26 in varchar2 default hr_api.g_varchar2
531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number
537: ,p_program_id in number default hr_api.g_number
538: ,p_program_update_date in date default hr_api.g_date

Line 535: ,p_request_id in number default hr_api.g_number

531: ,p_ppr_attribute27 in varchar2 default hr_api.g_varchar2
532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number
537: ,p_program_id in number default hr_api.g_number
538: ,p_program_update_date in date default hr_api.g_date
539: ,p_object_version_number in out nocopy number

Line 536: ,p_program_application_id in number default hr_api.g_number

532: ,p_ppr_attribute28 in varchar2 default hr_api.g_varchar2
533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number
537: ,p_program_id in number default hr_api.g_number
538: ,p_program_update_date in date default hr_api.g_date
539: ,p_object_version_number in out nocopy number
540: ,p_effective_date in date

Line 537: ,p_program_id in number default hr_api.g_number

533: ,p_ppr_attribute29 in varchar2 default hr_api.g_varchar2
534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number
537: ,p_program_id in number default hr_api.g_number
538: ,p_program_update_date in date default hr_api.g_date
539: ,p_object_version_number in out nocopy number
540: ,p_effective_date in date
541: ,p_datetrack_mode in varchar2

Line 538: ,p_program_update_date in date default hr_api.g_date

534: ,p_ppr_attribute30 in varchar2 default hr_api.g_varchar2
535: ,p_request_id in number default hr_api.g_number
536: ,p_program_application_id in number default hr_api.g_number
537: ,p_program_id in number default hr_api.g_number
538: ,p_program_update_date in date default hr_api.g_date
539: ,p_object_version_number in out nocopy number
540: ,p_effective_date in date
541: ,p_datetrack_mode in varchar2
542: ) is

Line 643: when hr_api.cannot_find_prog_unit then

639: ,p_effective_date => trunc(p_effective_date)
640: ,p_datetrack_mode => l_datetrack_mode
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'UPDATE_PRMRY_CARE_PRVDR'
646: ,p_hook_type => 'BP'
647: );

Line 644: hr_api.cannot_find_prog_unit_error

640: ,p_datetrack_mode => l_datetrack_mode
641: );
642: exception
643: when hr_api.cannot_find_prog_unit then
644: hr_api.cannot_find_prog_unit_error
645: (p_module_name => 'UPDATE_PRMRY_CARE_PRVDR'
646: ,p_hook_type => 'BP'
647: );
648: --

Line 773: when hr_api.cannot_find_prog_unit then

769: ,p_effective_date => trunc(p_effective_date)
770: ,p_datetrack_mode => l_datetrack_mode
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'UPDATE_PRMRY_CARE_PRVDR'
776: ,p_hook_type => 'AP' );
777: --

Line 774: hr_api.cannot_find_prog_unit_error

770: ,p_datetrack_mode => l_datetrack_mode
771: );
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'UPDATE_PRMRY_CARE_PRVDR'
776: ,p_hook_type => 'AP' );
777: --
778: -- End of API User Hook for the after hook of update_PRMRY_CARE_PRVDR

Line 787: raise hr_api.validate_enabled;

783: --
784: -- When in validation only mode raise the Validate_Enabled exception
785: --
786: if p_validate then
787: raise hr_api.validate_enabled;
788: end if;
789: --
790: -- Set all output arguments
791: --

Line 800: when hr_api.validate_enabled then

796: hr_utility.set_location(' Leaving:'||l_proc, 70);
797: --
798: exception
799: --
800: when hr_api.validate_enabled then
801: --
802: -- As the Validate_Enabled exception has been raised
803: -- we must rollback to the savepoint
804: --

Line 831: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2

827: (
828: p_prmry_care_prvdr_id in number
829: ,p_effective_start_date out nocopy date
830: ,p_effective_end_date out nocopy date
831: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
832: ,p_name in varchar2 default hr_api.g_varchar2
833: ,p_ext_ident in varchar2 default hr_api.g_varchar2
834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

Line 832: ,p_name in varchar2 default hr_api.g_varchar2

828: p_prmry_care_prvdr_id in number
829: ,p_effective_start_date out nocopy date
830: ,p_effective_end_date out nocopy date
831: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
832: ,p_name in varchar2 default hr_api.g_varchar2
833: ,p_ext_ident in varchar2 default hr_api.g_varchar2
834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
836: ,p_business_group_id in number default hr_api.g_number

Line 833: ,p_ext_ident in varchar2 default hr_api.g_varchar2

829: ,p_effective_start_date out nocopy date
830: ,p_effective_end_date out nocopy date
831: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
832: ,p_name in varchar2 default hr_api.g_varchar2
833: ,p_ext_ident in varchar2 default hr_api.g_varchar2
834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
836: ,p_business_group_id in number default hr_api.g_number
837: ,p_object_version_number in out nocopy number

Line 834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number

830: ,p_effective_end_date out nocopy date
831: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
832: ,p_name in varchar2 default hr_api.g_varchar2
833: ,p_ext_ident in varchar2 default hr_api.g_varchar2
834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
836: ,p_business_group_id in number default hr_api.g_number
837: ,p_object_version_number in out nocopy number
838: ,p_effective_date in date

Line 835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number

831: ,p_prmry_care_prvdr_typ_cd in varchar2 default hr_api.g_varchar2
832: ,p_name in varchar2 default hr_api.g_varchar2
833: ,p_ext_ident in varchar2 default hr_api.g_varchar2
834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
836: ,p_business_group_id in number default hr_api.g_number
837: ,p_object_version_number in out nocopy number
838: ,p_effective_date in date
839: ,p_datetrack_mode in varchar2

Line 836: ,p_business_group_id in number default hr_api.g_number

832: ,p_name in varchar2 default hr_api.g_varchar2
833: ,p_ext_ident in varchar2 default hr_api.g_varchar2
834: ,p_prtt_enrt_rslt_id in number default hr_api.g_number
835: ,p_elig_cvrd_dpnt_id in number default hr_api.g_number
836: ,p_business_group_id in number default hr_api.g_number
837: ,p_object_version_number in out nocopy number
838: ,p_effective_date in date
839: ,p_datetrack_mode in varchar2
840: ,p_return_status out nocopy varchar2

Line 981: when hr_api.cannot_find_prog_unit then

977: ,p_effective_date => trunc(l_effective_date)
978: ,p_datetrack_mode => l_datetrack_mode
979: );
980: exception
981: when hr_api.cannot_find_prog_unit then
982: hr_api.cannot_find_prog_unit_error
983: (p_module_name => 'DELETE_PRMRY_CARE_PRVDR'
984: ,p_hook_type => 'BP' );
985: --

Line 982: hr_api.cannot_find_prog_unit_error

978: ,p_datetrack_mode => l_datetrack_mode
979: );
980: exception
981: when hr_api.cannot_find_prog_unit then
982: hr_api.cannot_find_prog_unit_error
983: (p_module_name => 'DELETE_PRMRY_CARE_PRVDR'
984: ,p_hook_type => 'BP' );
985: --
986: -- End of API User Hook for the before hook of delete_PRMRY_CARE_PRVDR

Line 1044: when hr_api.cannot_find_prog_unit then

1040: ,p_effective_date => trunc(l_effective_date)
1041: ,p_datetrack_mode => l_datetrack_mode
1042: );
1043: exception
1044: when hr_api.cannot_find_prog_unit then
1045: hr_api.cannot_find_prog_unit_error
1046: (p_module_name => 'DELETE_PRMRY_CARE_PRVDR'
1047: ,p_hook_type => 'AP'
1048: );

Line 1045: hr_api.cannot_find_prog_unit_error

1041: ,p_datetrack_mode => l_datetrack_mode
1042: );
1043: exception
1044: when hr_api.cannot_find_prog_unit then
1045: hr_api.cannot_find_prog_unit_error
1046: (p_module_name => 'DELETE_PRMRY_CARE_PRVDR'
1047: ,p_hook_type => 'AP'
1048: );
1049: --

Line 1059: raise hr_api.validate_enabled;

1055: --
1056: -- When in validation only mode raise the Validate_Enabled exception
1057: --
1058: if p_validate then
1059: raise hr_api.validate_enabled;
1060: end if;
1061: --
1062: hr_utility.set_location(' Leaving:'||l_proc, 70);
1063: --

Line 1066: when hr_api.validate_enabled then

1062: hr_utility.set_location(' Leaving:'||l_proc, 70);
1063: --
1064: exception
1065: --
1066: when hr_api.validate_enabled then
1067: --
1068: -- As the Validate_Enabled exception has been raised
1069: -- we must rollback to the savepoint
1070: --