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

Line 94: When hr_api.check_integrity_violated Then

90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
97: per_ssd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
97: per_ssd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
102: per_ssd_shd.constraint_error

Line 99: When hr_api.parent_integrity_violated Then

95: -- A check constraint has been violated
96: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
97: per_ssd_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
102: per_ssd_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
102: per_ssd_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
107: per_ssd_shd.constraint_error

Line 104: When hr_api.unique_integrity_violated Then

100: -- Parent integrity has been violated
101: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
102: per_ssd_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
107: per_ssd_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
107: per_ssd_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: per_ssd_shd.g_api_dml := false; -- Unset the api dml status
111: Raise;
112: End update_dml;

Line 265: when hr_api.cannot_find_prog_unit then

261: );
262: --
263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'PER_SP_SUCCESSEE_DETAILS'
269: ,p_hook_type => 'AU');

Line 267: hr_api.cannot_find_prog_unit_error

263: exception
264: --
265: when hr_api.cannot_find_prog_unit then
266: --
267: hr_api.cannot_find_prog_unit_error
268: (p_module_name => 'PER_SP_SUCCESSEE_DETAILS'
269: ,p_hook_type => 'AU');
270: --
271: end;

Line 330: If (p_rec.business_group_id = hr_api.g_number) then

326: -- p_rec plsql record structure
327: -- to see if a system default is being used. If a system default
328: -- is being used then we must set to the 'current' argument value.
329: --
330: If (p_rec.business_group_id = hr_api.g_number) then
331: p_rec.business_group_id :=
332: per_ssd_shd.g_old_rec.business_group_id;
333: End If;
334: If (p_rec.successee_type = hr_api.g_varchar2) then

Line 334: If (p_rec.successee_type = hr_api.g_varchar2) then

330: If (p_rec.business_group_id = hr_api.g_number) then
331: p_rec.business_group_id :=
332: per_ssd_shd.g_old_rec.business_group_id;
333: End If;
334: If (p_rec.successee_type = hr_api.g_varchar2) then
335: p_rec.successee_type :=
336: per_ssd_shd.g_old_rec.successee_type;
337: End If;
338: If (p_rec.successee_id = hr_api.g_number) then

Line 338: If (p_rec.successee_id = hr_api.g_number) then

334: If (p_rec.successee_type = hr_api.g_varchar2) then
335: p_rec.successee_type :=
336: per_ssd_shd.g_old_rec.successee_type;
337: End If;
338: If (p_rec.successee_id = hr_api.g_number) then
339: p_rec.successee_id :=
340: per_ssd_shd.g_old_rec.successee_id;
341: End If;
342: If (p_rec.display_permissions = hr_api.g_varchar2) then

Line 342: If (p_rec.display_permissions = hr_api.g_varchar2) then

338: If (p_rec.successee_id = hr_api.g_number) then
339: p_rec.successee_id :=
340: per_ssd_shd.g_old_rec.successee_id;
341: End If;
342: If (p_rec.display_permissions = hr_api.g_varchar2) then
343: p_rec.display_permissions :=
344: per_ssd_shd.g_old_rec.display_permissions;
345: End If;
346: If (p_rec.max_plans = hr_api.g_number) then

Line 346: If (p_rec.max_plans = hr_api.g_number) then

342: If (p_rec.display_permissions = hr_api.g_varchar2) then
343: p_rec.display_permissions :=
344: per_ssd_shd.g_old_rec.display_permissions;
345: End If;
346: If (p_rec.max_plans = hr_api.g_number) then
347: p_rec.max_plans :=
348: per_ssd_shd.g_old_rec.max_plans;
349: End If;
350: If (p_rec.allow_npws = hr_api.g_varchar2) then

Line 350: If (p_rec.allow_npws = hr_api.g_varchar2) then

346: If (p_rec.max_plans = hr_api.g_number) then
347: p_rec.max_plans :=
348: per_ssd_shd.g_old_rec.max_plans;
349: End If;
350: If (p_rec.allow_npws = hr_api.g_varchar2) then
351: p_rec.allow_npws :=
352: per_ssd_shd.g_old_rec.allow_npws;
353: End If;
354: If (p_rec.allow_applicants = hr_api.g_varchar2) then

Line 354: If (p_rec.allow_applicants = hr_api.g_varchar2) then

350: If (p_rec.allow_npws = hr_api.g_varchar2) then
351: p_rec.allow_npws :=
352: per_ssd_shd.g_old_rec.allow_npws;
353: End If;
354: If (p_rec.allow_applicants = hr_api.g_varchar2) then
355: p_rec.allow_applicants :=
356: per_ssd_shd.g_old_rec.allow_applicants;
357: End If;
358: If (p_rec.allow_override_search = hr_api.g_varchar2) then

Line 358: If (p_rec.allow_override_search = hr_api.g_varchar2) then

354: If (p_rec.allow_applicants = hr_api.g_varchar2) then
355: p_rec.allow_applicants :=
356: per_ssd_shd.g_old_rec.allow_applicants;
357: End If;
358: If (p_rec.allow_override_search = hr_api.g_varchar2) then
359: p_rec.allow_override_search :=
360: per_ssd_shd.g_old_rec.allow_override_search;
361: End If;
362: If (p_rec.key_entity = hr_api.g_varchar2) then

Line 362: If (p_rec.key_entity = hr_api.g_varchar2) then

358: If (p_rec.allow_override_search = hr_api.g_varchar2) then
359: p_rec.allow_override_search :=
360: per_ssd_shd.g_old_rec.allow_override_search;
361: End If;
362: If (p_rec.key_entity = hr_api.g_varchar2) then
363: p_rec.key_entity :=
364: per_ssd_shd.g_old_rec.key_entity;
365: End If;
366: If (p_rec.risk_of_loss = hr_api.g_varchar2) then

Line 366: If (p_rec.risk_of_loss = hr_api.g_varchar2) then

362: If (p_rec.key_entity = hr_api.g_varchar2) then
363: p_rec.key_entity :=
364: per_ssd_shd.g_old_rec.key_entity;
365: End If;
366: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
367: p_rec.risk_of_loss :=
368: per_ssd_shd.g_old_rec.risk_of_loss;
369: End If;
370: If (p_rec.impact_of_loss = hr_api.g_varchar2) then

Line 370: If (p_rec.impact_of_loss = hr_api.g_varchar2) then

366: If (p_rec.risk_of_loss = hr_api.g_varchar2) then
367: p_rec.risk_of_loss :=
368: per_ssd_shd.g_old_rec.risk_of_loss;
369: End If;
370: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
371: p_rec.impact_of_loss :=
372: per_ssd_shd.g_old_rec.impact_of_loss;
373: End If;
374: If (p_rec.plan_readiness_rule = hr_api.g_varchar2) then

Line 374: If (p_rec.plan_readiness_rule = hr_api.g_varchar2) then

370: If (p_rec.impact_of_loss = hr_api.g_varchar2) then
371: p_rec.impact_of_loss :=
372: per_ssd_shd.g_old_rec.impact_of_loss;
373: End If;
374: If (p_rec.plan_readiness_rule = hr_api.g_varchar2) then
375: p_rec.plan_readiness_rule :=
376: per_ssd_shd.g_old_rec.plan_readiness_rule;
377: End If;
378: If (p_rec.max_successors = hr_api.g_number) then

Line 378: If (p_rec.max_successors = hr_api.g_number) then

374: If (p_rec.plan_readiness_rule = hr_api.g_varchar2) then
375: p_rec.plan_readiness_rule :=
376: per_ssd_shd.g_old_rec.plan_readiness_rule;
377: End If;
378: If (p_rec.max_successors = hr_api.g_number) then
379: p_rec.max_successors :=
380: per_ssd_shd.g_old_rec.max_successors;
381: End If;
382: --

Line 446: ,p_business_group_id in number default hr_api.g_number

442: Procedure upd
443: (p_effective_date in date
444: ,p_successee_detail_id in number
445: ,p_object_version_number in out nocopy number
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_successee_type in varchar2 default hr_api.g_varchar2
448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2

Line 447: ,p_successee_type in varchar2 default hr_api.g_varchar2

443: (p_effective_date in date
444: ,p_successee_detail_id in number
445: ,p_object_version_number in out nocopy number
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_successee_type in varchar2 default hr_api.g_varchar2
448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2

Line 448: ,p_successee_id in number default hr_api.g_number

444: ,p_successee_detail_id in number
445: ,p_object_version_number in out nocopy number
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_successee_type in varchar2 default hr_api.g_varchar2
448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2

Line 449: ,p_display_permissions in varchar2 default hr_api.g_varchar2

445: ,p_object_version_number in out nocopy number
446: ,p_business_group_id in number default hr_api.g_number
447: ,p_successee_type in varchar2 default hr_api.g_varchar2
448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number

Line 450: ,p_allow_npws in varchar2 default hr_api.g_varchar2

446: ,p_business_group_id in number default hr_api.g_number
447: ,p_successee_type in varchar2 default hr_api.g_varchar2
448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2

Line 451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2

447: ,p_successee_type in varchar2 default hr_api.g_varchar2
448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2

Line 452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2

448: ,p_successee_id in number default hr_api.g_number
449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2

Line 453: ,p_max_plans in number default hr_api.g_number

449: ,p_display_permissions in varchar2 default hr_api.g_varchar2
450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2

Line 454: ,p_key_entity in varchar2 default hr_api.g_varchar2

450: ,p_allow_npws in varchar2 default hr_api.g_varchar2
451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
458: ,p_max_successors in number default hr_api.g_number

Line 455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2

451: ,p_allow_applicants in varchar2 default hr_api.g_varchar2
452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
458: ,p_max_successors in number default hr_api.g_number
459: ) is

Line 456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2

452: ,p_allow_override_search in varchar2 default hr_api.g_varchar2
453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
458: ,p_max_successors in number default hr_api.g_number
459: ) is
460: --

Line 457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2

453: ,p_max_plans in number default hr_api.g_number
454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
458: ,p_max_successors in number default hr_api.g_number
459: ) is
460: --
461: l_rec per_ssd_shd.g_rec_type;

Line 458: ,p_max_successors in number default hr_api.g_number

454: ,p_key_entity in varchar2 default hr_api.g_varchar2
455: ,p_risk_of_loss in varchar2 default hr_api.g_varchar2
456: ,p_impact_of_loss in varchar2 default hr_api.g_varchar2
457: ,p_plan_readiness_rule in varchar2 default hr_api.g_varchar2
458: ,p_max_successors in number default hr_api.g_number
459: ) is
460: --
461: l_rec per_ssd_shd.g_rec_type;
462: l_proc varchar2(72) := g_package||'upd';