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

Line 93: When hr_api.check_integrity_violated Then

89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 10);
91: --
92: Exception
93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: pqh_vlp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

93: When hr_api.check_integrity_violated Then
94: -- A check constraint has been violated
95: --
96: pqh_vlp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: pqh_vlp_shd.constraint_error

Line 98: When hr_api.parent_integrity_violated Then

94: -- A check constraint has been violated
95: --
96: pqh_vlp_shd.constraint_error
97: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: pqh_vlp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

98: When hr_api.parent_integrity_violated Then
99: -- Parent integrity has been violated
100: --
101: pqh_vlp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: pqh_vlp_shd.constraint_error

Line 103: When hr_api.unique_integrity_violated Then

99: -- Parent integrity has been violated
100: --
101: pqh_vlp_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: pqh_vlp_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

103: When hr_api.unique_integrity_violated Then
104: -- Unique integrity has been violated
105: --
106: pqh_vlp_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: --
110: Raise;
111: End update_dml;

Line 260: when hr_api.cannot_find_prog_unit then

256: );
257: --
258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'PQH_FR_VALIDATION_PERIODS'
264: ,p_hook_type => 'AU');

Line 262: hr_api.cannot_find_prog_unit_error

258: exception
259: --
260: when hr_api.cannot_find_prog_unit then
261: --
262: hr_api.cannot_find_prog_unit_error
263: (p_module_name => 'PQH_FR_VALIDATION_PERIODS'
264: ,p_hook_type => 'AU');
265: --
266: end;

Line 325: If (p_rec.validation_id = hr_api.g_number) then

321: -- p_rec plsql record structure
322: -- to see if a system default is being used. If a system default
323: -- is being used then we must set to the 'current' argument value.
324: --
325: If (p_rec.validation_id = hr_api.g_number) then
326: p_rec.validation_id :=
327: pqh_vlp_shd.g_old_rec.validation_id;
328: End If;
329: If (p_rec.start_date = hr_api.g_date) then

Line 329: If (p_rec.start_date = hr_api.g_date) then

325: If (p_rec.validation_id = hr_api.g_number) then
326: p_rec.validation_id :=
327: pqh_vlp_shd.g_old_rec.validation_id;
328: End If;
329: If (p_rec.start_date = hr_api.g_date) then
330: p_rec.start_date :=
331: pqh_vlp_shd.g_old_rec.start_date;
332: End If;
333: If (p_rec.end_date = hr_api.g_date) then

Line 333: If (p_rec.end_date = hr_api.g_date) then

329: If (p_rec.start_date = hr_api.g_date) then
330: p_rec.start_date :=
331: pqh_vlp_shd.g_old_rec.start_date;
332: End If;
333: If (p_rec.end_date = hr_api.g_date) then
334: p_rec.end_date :=
335: pqh_vlp_shd.g_old_rec.end_date;
336: End If;
337: If (p_rec.previous_employer_id = hr_api.g_number) then

Line 337: If (p_rec.previous_employer_id = hr_api.g_number) then

333: If (p_rec.end_date = hr_api.g_date) then
334: p_rec.end_date :=
335: pqh_vlp_shd.g_old_rec.end_date;
336: End If;
337: If (p_rec.previous_employer_id = hr_api.g_number) then
338: p_rec.previous_employer_id :=
339: pqh_vlp_shd.g_old_rec.previous_employer_id;
340: End If;
341: If (p_rec.assignment_category = hr_api.g_varchar2) then

Line 341: If (p_rec.assignment_category = hr_api.g_varchar2) then

337: If (p_rec.previous_employer_id = hr_api.g_number) then
338: p_rec.previous_employer_id :=
339: pqh_vlp_shd.g_old_rec.previous_employer_id;
340: End If;
341: If (p_rec.assignment_category = hr_api.g_varchar2) then
342: p_rec.assignment_category :=
343: pqh_vlp_shd.g_old_rec.assignment_category;
344: End If;
345:

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

342: p_rec.assignment_category :=
343: pqh_vlp_shd.g_old_rec.assignment_category;
344: End If;
345:
346: If (p_rec.normal_hours = hr_api.g_number) then
347: p_rec.normal_hours :=
348: pqh_vlp_shd.g_old_rec.normal_hours;
349: End If;
350: If (p_rec.frequency = hr_api.g_varchar2) then

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

346: If (p_rec.normal_hours = hr_api.g_number) then
347: p_rec.normal_hours :=
348: pqh_vlp_shd.g_old_rec.normal_hours;
349: End If;
350: If (p_rec.frequency = hr_api.g_varchar2) then
351: p_rec.frequency :=
352: pqh_vlp_shd.g_old_rec.frequency;
353: End If;
354: If (p_rec.period_years = hr_api.g_number) then

Line 354: If (p_rec.period_years = hr_api.g_number) then

350: If (p_rec.frequency = hr_api.g_varchar2) then
351: p_rec.frequency :=
352: pqh_vlp_shd.g_old_rec.frequency;
353: End If;
354: If (p_rec.period_years = hr_api.g_number) then
355: p_rec.period_years :=
356: pqh_vlp_shd.g_old_rec.period_years;
357: End If;
358: If (p_rec.period_months = hr_api.g_number) then

Line 358: If (p_rec.period_months = hr_api.g_number) then

354: If (p_rec.period_years = hr_api.g_number) then
355: p_rec.period_years :=
356: pqh_vlp_shd.g_old_rec.period_years;
357: End If;
358: If (p_rec.period_months = hr_api.g_number) then
359: p_rec.period_months :=
360: pqh_vlp_shd.g_old_rec.period_months;
361: End If;
362: If (p_rec.period_days = hr_api.g_number) then

Line 362: If (p_rec.period_days = hr_api.g_number) then

358: If (p_rec.period_months = hr_api.g_number) then
359: p_rec.period_months :=
360: pqh_vlp_shd.g_old_rec.period_months;
361: End If;
362: If (p_rec.period_days = hr_api.g_number) then
363: p_rec.period_days :=
364: pqh_vlp_shd.g_old_rec.period_days;
365: End If;
366: If (p_rec.comments = hr_api.g_varchar2) then

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

362: If (p_rec.period_days = hr_api.g_number) then
363: p_rec.period_days :=
364: pqh_vlp_shd.g_old_rec.period_days;
365: End If;
366: If (p_rec.comments = hr_api.g_varchar2) then
367: p_rec.comments :=
368: pqh_vlp_shd.g_old_rec.comments;
369: End If;
370: If (p_rec.validation_status = hr_api.g_varchar2) then

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

366: If (p_rec.comments = hr_api.g_varchar2) then
367: p_rec.comments :=
368: pqh_vlp_shd.g_old_rec.comments;
369: End If;
370: If (p_rec.validation_status = hr_api.g_varchar2) then
371: p_rec.validation_status :=
372: pqh_vlp_shd.g_old_rec.validation_status;
373: End If;
374: --

Line 438: ,p_validation_id in number default hr_api.g_number

434: Procedure upd
435: (p_effective_date in date
436: ,p_validation_period_id in number
437: ,p_object_version_number in out nocopy number
438: ,p_validation_id in number default hr_api.g_number
439: ,p_start_date in date default hr_api.g_date
440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2

Line 439: ,p_start_date in date default hr_api.g_date

435: (p_effective_date in date
436: ,p_validation_period_id in number
437: ,p_object_version_number in out nocopy number
438: ,p_validation_id in number default hr_api.g_number
439: ,p_start_date in date default hr_api.g_date
440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number

Line 440: ,p_end_date in date default hr_api.g_date

436: ,p_validation_period_id in number
437: ,p_object_version_number in out nocopy number
438: ,p_validation_id in number default hr_api.g_number
439: ,p_start_date in date default hr_api.g_date
440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2

Line 441: ,p_previous_employer_id in number default hr_api.g_number

437: ,p_object_version_number in out nocopy number
438: ,p_validation_id in number default hr_api.g_number
439: ,p_start_date in date default hr_api.g_date
440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number

Line 442: ,p_assignment_category in varchar2 default hr_api.g_varchar2

438: ,p_validation_id in number default hr_api.g_number
439: ,p_start_date in date default hr_api.g_date
440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number

Line 443: ,p_normal_hours in number default hr_api.g_number

439: ,p_start_date in date default hr_api.g_date
440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number

Line 444: ,p_frequency in varchar2 default hr_api.g_varchar2

440: ,p_end_date in date default hr_api.g_date
441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number
448: ,p_comments in varchar2 default hr_api.g_varchar2

Line 445: ,p_period_years in number default hr_api.g_number

441: ,p_previous_employer_id in number default hr_api.g_number
442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number
448: ,p_comments in varchar2 default hr_api.g_varchar2
449: ,p_validation_status in varchar2 default hr_api.g_varchar2

Line 446: ,p_period_months in number default hr_api.g_number

442: ,p_assignment_category in varchar2 default hr_api.g_varchar2
443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number
448: ,p_comments in varchar2 default hr_api.g_varchar2
449: ,p_validation_status in varchar2 default hr_api.g_varchar2
450: ) is

Line 447: ,p_period_days in number default hr_api.g_number

443: ,p_normal_hours in number default hr_api.g_number
444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number
448: ,p_comments in varchar2 default hr_api.g_varchar2
449: ,p_validation_status in varchar2 default hr_api.g_varchar2
450: ) is
451: --

Line 448: ,p_comments in varchar2 default hr_api.g_varchar2

444: ,p_frequency in varchar2 default hr_api.g_varchar2
445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number
448: ,p_comments in varchar2 default hr_api.g_varchar2
449: ,p_validation_status in varchar2 default hr_api.g_varchar2
450: ) is
451: --
452: l_rec pqh_vlp_shd.g_rec_type;

Line 449: ,p_validation_status in varchar2 default hr_api.g_varchar2

445: ,p_period_years in number default hr_api.g_number
446: ,p_period_months in number default hr_api.g_number
447: ,p_period_days in number default hr_api.g_number
448: ,p_comments in varchar2 default hr_api.g_varchar2
449: ,p_validation_status in varchar2 default hr_api.g_varchar2
450: ) is
451: --
452: l_rec pqh_vlp_shd.g_rec_type;
453: l_proc varchar2(72) := g_package||'upd';