eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GDA_UPD dependencies on HR_API

Line 90: When hr_api.check_integrity_violated Then

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

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

90: When hr_api.check_integrity_violated Then
91: -- A check constraint has been violated
92: --
93: pqp_gda_shd.constraint_error
94: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: pqp_gda_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

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

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

95: When hr_api.parent_integrity_violated Then
96: -- Parent integrity has been violated
97: --
98: pqp_gda_shd.constraint_error
99: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqp_gda_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

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

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

100: When hr_api.unique_integrity_violated Then
101: -- Unique integrity has been violated
102: --
103: pqp_gda_shd.constraint_error
104: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
105: When Others Then
106: --
107: Raise;
108: End update_dml;

Line 245: when hr_api.cannot_find_prog_unit then

241: );
242: --
243: exception
244: --
245: when hr_api.cannot_find_prog_unit then
246: --
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'PQP_GAP_DAILY_ABSENCES'
249: ,p_hook_type => 'AU');

Line 247: hr_api.cannot_find_prog_unit_error

243: exception
244: --
245: when hr_api.cannot_find_prog_unit then
246: --
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'PQP_GAP_DAILY_ABSENCES'
249: ,p_hook_type => 'AU');
250: --
251: end;

Line 310: If (p_rec.gap_absence_plan_id = hr_api.g_number) then

306: -- p_rec plsql record structure
307: -- to see if a system default is being used. If a system default
308: -- is being used then we must set to the 'current' argument value.
309: --
310: If (p_rec.gap_absence_plan_id = hr_api.g_number) then
311: p_rec.gap_absence_plan_id :=
312: pqp_gda_shd.g_old_rec.gap_absence_plan_id;
313: End If;
314: If (p_rec.absence_date = hr_api.g_date) then

Line 314: If (p_rec.absence_date = hr_api.g_date) then

310: If (p_rec.gap_absence_plan_id = hr_api.g_number) then
311: p_rec.gap_absence_plan_id :=
312: pqp_gda_shd.g_old_rec.gap_absence_plan_id;
313: End If;
314: If (p_rec.absence_date = hr_api.g_date) then
315: p_rec.absence_date :=
316: pqp_gda_shd.g_old_rec.absence_date;
317: End If;
318: If (p_rec.work_pattern_day_type = hr_api.g_varchar2) then

Line 318: If (p_rec.work_pattern_day_type = hr_api.g_varchar2) then

314: If (p_rec.absence_date = hr_api.g_date) then
315: p_rec.absence_date :=
316: pqp_gda_shd.g_old_rec.absence_date;
317: End If;
318: If (p_rec.work_pattern_day_type = hr_api.g_varchar2) then
319: p_rec.work_pattern_day_type :=
320: pqp_gda_shd.g_old_rec.work_pattern_day_type;
321: End If;
322: If (p_rec.level_of_entitlement = hr_api.g_varchar2) then

Line 322: If (p_rec.level_of_entitlement = hr_api.g_varchar2) then

318: If (p_rec.work_pattern_day_type = hr_api.g_varchar2) then
319: p_rec.work_pattern_day_type :=
320: pqp_gda_shd.g_old_rec.work_pattern_day_type;
321: End If;
322: If (p_rec.level_of_entitlement = hr_api.g_varchar2) then
323: p_rec.level_of_entitlement :=
324: pqp_gda_shd.g_old_rec.level_of_entitlement;
325: End If;
326: If (p_rec.level_of_pay = hr_api.g_varchar2) then

Line 326: If (p_rec.level_of_pay = hr_api.g_varchar2) then

322: If (p_rec.level_of_entitlement = hr_api.g_varchar2) then
323: p_rec.level_of_entitlement :=
324: pqp_gda_shd.g_old_rec.level_of_entitlement;
325: End If;
326: If (p_rec.level_of_pay = hr_api.g_varchar2) then
327: p_rec.level_of_pay :=
328: pqp_gda_shd.g_old_rec.level_of_pay;
329: End If;
330: If (p_rec.duration = hr_api.g_number) then

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

326: If (p_rec.level_of_pay = hr_api.g_varchar2) then
327: p_rec.level_of_pay :=
328: pqp_gda_shd.g_old_rec.level_of_pay;
329: End If;
330: If (p_rec.duration = hr_api.g_number) then
331: p_rec.duration :=
332: pqp_gda_shd.g_old_rec.duration;
333: End If;
334: If (p_rec.duration_in_hours = hr_api.g_number) then

Line 334: If (p_rec.duration_in_hours = hr_api.g_number) then

330: If (p_rec.duration = hr_api.g_number) then
331: p_rec.duration :=
332: pqp_gda_shd.g_old_rec.duration;
333: End If;
334: If (p_rec.duration_in_hours = hr_api.g_number) then
335: p_rec.duration_in_hours :=
336: pqp_gda_shd.g_old_rec.duration_in_hours;
337: End If;
338: If (p_rec.working_days_per_week = hr_api.g_number) then

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

334: If (p_rec.duration_in_hours = hr_api.g_number) then
335: p_rec.duration_in_hours :=
336: pqp_gda_shd.g_old_rec.duration_in_hours;
337: End If;
338: If (p_rec.working_days_per_week = hr_api.g_number) then
339: p_rec.working_days_per_week :=
340: pqp_gda_shd.g_old_rec.working_days_per_week;
341: End If;
342: -- LG added below if block

Line 343: If (p_rec.fte = hr_api.g_number) then

339: p_rec.working_days_per_week :=
340: pqp_gda_shd.g_old_rec.working_days_per_week;
341: End If;
342: -- LG added below if block
343: If (p_rec.fte = hr_api.g_number) then
344: p_rec.fte :=
345: pqp_gda_shd.g_old_rec.fte;
346: End If;
347: --

Line 411: ,p_gap_absence_plan_id in number default hr_api.g_number

407: Procedure upd
408: (p_effective_date in date
409: ,p_gap_daily_absence_id in number
410: ,p_object_version_number in out nocopy number
411: ,p_gap_absence_plan_id in number default hr_api.g_number
412: ,p_absence_date in date default hr_api.g_date
413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2

Line 412: ,p_absence_date in date default hr_api.g_date

408: (p_effective_date in date
409: ,p_gap_daily_absence_id in number
410: ,p_object_version_number in out nocopy number
411: ,p_gap_absence_plan_id in number default hr_api.g_number
412: ,p_absence_date in date default hr_api.g_date
413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number

Line 413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2

409: ,p_gap_daily_absence_id in number
410: ,p_object_version_number in out nocopy number
411: ,p_gap_absence_plan_id in number default hr_api.g_number
412: ,p_absence_date in date default hr_api.g_date
413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number

Line 414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2

410: ,p_object_version_number in out nocopy number
411: ,p_gap_absence_plan_id in number default hr_api.g_number
412: ,p_absence_date in date default hr_api.g_date
413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number
418: ,p_working_days_per_week in number default hr_api.g_number

Line 415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2

411: ,p_gap_absence_plan_id in number default hr_api.g_number
412: ,p_absence_date in date default hr_api.g_date
413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number
418: ,p_working_days_per_week in number default hr_api.g_number
419: ,p_fte in number default hr_api.g_number -- LG

Line 416: ,p_duration in number default hr_api.g_number

412: ,p_absence_date in date default hr_api.g_date
413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number
418: ,p_working_days_per_week in number default hr_api.g_number
419: ,p_fte in number default hr_api.g_number -- LG
420: ) is

Line 417: ,p_duration_in_hours in number default hr_api.g_number

413: ,p_work_pattern_day_type in varchar2 default hr_api.g_varchar2
414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number
418: ,p_working_days_per_week in number default hr_api.g_number
419: ,p_fte in number default hr_api.g_number -- LG
420: ) is
421: --

Line 418: ,p_working_days_per_week in number default hr_api.g_number

414: ,p_level_of_entitlement in varchar2 default hr_api.g_varchar2
415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number
418: ,p_working_days_per_week in number default hr_api.g_number
419: ,p_fte in number default hr_api.g_number -- LG
420: ) is
421: --
422: l_rec pqp_gda_shd.g_rec_type;

Line 419: ,p_fte in number default hr_api.g_number -- LG

415: ,p_level_of_pay in varchar2 default hr_api.g_varchar2
416: ,p_duration in number default hr_api.g_number
417: ,p_duration_in_hours in number default hr_api.g_number
418: ,p_working_days_per_week in number default hr_api.g_number
419: ,p_fte in number default hr_api.g_number -- LG
420: ) is
421: --
422: l_rec pqp_gda_shd.g_rec_type;
423: l_proc varchar2(72) := g_package||'upd';