APPS.PQP_GDS_UPD dependencies on HR_API

Line 89: When hr_api.check_integrity_violated Then

85: --
86: hr_utility.set_location(' Leaving:'||l_proc, 10);
87: --
88: Exception
89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
92: pqp_gds_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

89: When hr_api.check_integrity_violated Then
90: -- A check constraint has been violated
91: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
92: pqp_gds_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
97: pqp_gds_shd.constraint_error

Line 94: When hr_api.parent_integrity_violated Then

90: -- A check constraint has been violated
91: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
92: pqp_gds_shd.constraint_error
93: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
94: When hr_api.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
97: pqp_gds_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.parent_integrity_violated Then
95: -- Parent integrity has been violated
96: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
97: pqp_gds_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_gds_shd.constraint_error

Line 99: When hr_api.unique_integrity_violated Then

95: -- Parent integrity has been violated
96: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
97: pqp_gds_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_gds_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.unique_integrity_violated Then
100: -- Unique integrity has been violated
101: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
102: pqp_gds_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When Others Then
105: pqp_gds_shd.g_api_dml := false; -- Unset the api dml status
106: Raise;
107: End update_dml;

Line 238: when hr_api.cannot_find_prog_unit then

234: );
235: --
236: exception
237: --
238: when hr_api.cannot_find_prog_unit then
239: --
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'PQP_GAP_DURATION_SUMMARY'
242: ,p_hook_type => 'AU');

Line 240: hr_api.cannot_find_prog_unit_error

236: exception
237: --
238: when hr_api.cannot_find_prog_unit then
239: --
240: hr_api.cannot_find_prog_unit_error
241: (p_module_name => 'PQP_GAP_DURATION_SUMMARY'
242: ,p_hook_type => 'AU');
243: --
244: end;

Line 303: If (p_rec.assignment_id = hr_api.g_number) then

299: -- p_rec plsql record structure
300: -- to see if a system default is being used. If a system default
301: -- is being used then we must set to the 'current' argument value.
302: --
303: If (p_rec.assignment_id = hr_api.g_number) then
304: p_rec.assignment_id :=
305: pqp_gds_shd.g_old_rec.assignment_id;
306: End If;
307: If (p_rec.gap_absence_plan_id = hr_api.g_number) then

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

303: If (p_rec.assignment_id = hr_api.g_number) then
304: p_rec.assignment_id :=
305: pqp_gds_shd.g_old_rec.assignment_id;
306: End If;
307: If (p_rec.gap_absence_plan_id = hr_api.g_number) then
308: p_rec.gap_absence_plan_id :=
309: pqp_gds_shd.g_old_rec.gap_absence_plan_id;
310: End If;
311: If (p_rec.summary_type = hr_api.g_varchar2) then

Line 311: If (p_rec.summary_type = hr_api.g_varchar2) then

307: If (p_rec.gap_absence_plan_id = hr_api.g_number) then
308: p_rec.gap_absence_plan_id :=
309: pqp_gds_shd.g_old_rec.gap_absence_plan_id;
310: End If;
311: If (p_rec.summary_type = hr_api.g_varchar2) then
312: p_rec.summary_type :=
313: pqp_gds_shd.g_old_rec.summary_type;
314: End If;
315: If (p_rec.gap_level = hr_api.g_varchar2) then

Line 315: If (p_rec.gap_level = hr_api.g_varchar2) then

311: If (p_rec.summary_type = hr_api.g_varchar2) then
312: p_rec.summary_type :=
313: pqp_gds_shd.g_old_rec.summary_type;
314: End If;
315: If (p_rec.gap_level = hr_api.g_varchar2) then
316: p_rec.gap_level :=
317: pqp_gds_shd.g_old_rec.gap_level;
318: End If;
319: If (p_rec.duration_in_days = hr_api.g_number) then

Line 319: If (p_rec.duration_in_days = hr_api.g_number) then

315: If (p_rec.gap_level = hr_api.g_varchar2) then
316: p_rec.gap_level :=
317: pqp_gds_shd.g_old_rec.gap_level;
318: End If;
319: If (p_rec.duration_in_days = hr_api.g_number) then
320: p_rec.duration_in_days :=
321: pqp_gds_shd.g_old_rec.duration_in_days;
322: End If;
323: If (p_rec.duration_in_hours = hr_api.g_number) then

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

319: If (p_rec.duration_in_days = hr_api.g_number) then
320: p_rec.duration_in_days :=
321: pqp_gds_shd.g_old_rec.duration_in_days;
322: End If;
323: If (p_rec.duration_in_hours = hr_api.g_number) then
324: p_rec.duration_in_hours :=
325: pqp_gds_shd.g_old_rec.duration_in_hours;
326: End If;
327: If (p_rec.date_start = hr_api.g_date) then

Line 327: If (p_rec.date_start = hr_api.g_date) then

323: If (p_rec.duration_in_hours = hr_api.g_number) then
324: p_rec.duration_in_hours :=
325: pqp_gds_shd.g_old_rec.duration_in_hours;
326: End If;
327: If (p_rec.date_start = hr_api.g_date) then
328: p_rec.date_start :=
329: pqp_gds_shd.g_old_rec.date_start;
330: End If;
331: If (p_rec.date_end = hr_api.g_date) then

Line 331: If (p_rec.date_end = hr_api.g_date) then

327: If (p_rec.date_start = hr_api.g_date) then
328: p_rec.date_start :=
329: pqp_gds_shd.g_old_rec.date_start;
330: End If;
331: If (p_rec.date_end = hr_api.g_date) then
332: p_rec.date_end :=
333: pqp_gds_shd.g_old_rec.date_end;
334: End If;
335: --

Line 395: ,p_assignment_id in number default hr_api.g_number

391: -- ----------------------------------------------------------------------------
392: Procedure upd
393: (p_gap_duration_summary_id in number
394: ,p_object_version_number in out nocopy number
395: ,p_assignment_id in number default hr_api.g_number
396: ,p_gap_absence_plan_id in number default hr_api.g_number
397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number

Line 396: ,p_gap_absence_plan_id in number default hr_api.g_number

392: Procedure upd
393: (p_gap_duration_summary_id in number
394: ,p_object_version_number in out nocopy number
395: ,p_assignment_id in number default hr_api.g_number
396: ,p_gap_absence_plan_id in number default hr_api.g_number
397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number

Line 397: ,p_summary_type in varchar2 default hr_api.g_varchar2

393: (p_gap_duration_summary_id in number
394: ,p_object_version_number in out nocopy number
395: ,p_assignment_id in number default hr_api.g_number
396: ,p_gap_absence_plan_id in number default hr_api.g_number
397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number
401: ,p_date_start in date default hr_api.g_date

Line 398: ,p_gap_level in varchar2 default hr_api.g_varchar2

394: ,p_object_version_number in out nocopy number
395: ,p_assignment_id in number default hr_api.g_number
396: ,p_gap_absence_plan_id in number default hr_api.g_number
397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number
401: ,p_date_start in date default hr_api.g_date
402: ,p_date_end in date default hr_api.g_date

Line 399: ,p_duration_in_days in number default hr_api.g_number

395: ,p_assignment_id in number default hr_api.g_number
396: ,p_gap_absence_plan_id in number default hr_api.g_number
397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number
401: ,p_date_start in date default hr_api.g_date
402: ,p_date_end in date default hr_api.g_date
403: ) is

Line 400: ,p_duration_in_hours in number default hr_api.g_number

396: ,p_gap_absence_plan_id in number default hr_api.g_number
397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number
401: ,p_date_start in date default hr_api.g_date
402: ,p_date_end in date default hr_api.g_date
403: ) is
404: --

Line 401: ,p_date_start in date default hr_api.g_date

397: ,p_summary_type in varchar2 default hr_api.g_varchar2
398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number
401: ,p_date_start in date default hr_api.g_date
402: ,p_date_end in date default hr_api.g_date
403: ) is
404: --
405: l_rec pqp_gds_shd.g_rec_type;

Line 402: ,p_date_end in date default hr_api.g_date

398: ,p_gap_level in varchar2 default hr_api.g_varchar2
399: ,p_duration_in_days in number default hr_api.g_number
400: ,p_duration_in_hours in number default hr_api.g_number
401: ,p_date_start in date default hr_api.g_date
402: ,p_date_end in date default hr_api.g_date
403: ) is
404: --
405: l_rec pqp_gds_shd.g_rec_type;
406: l_proc varchar2(72) := g_package||'upd';