DBA Data[Home] [Help]

APPS.PAY_PEV_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
96: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
96: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
101: pay_pev_shd.constraint_error

Line 98: When hr_api.parent_integrity_violated Then

94: -- A check constraint has been violated
95: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
96: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
101: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
101: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
106: pay_pev_shd.constraint_error

Line 103: When hr_api.unique_integrity_violated Then

99: -- Parent integrity has been violated
100: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
101: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
106: pay_pev_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: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
106: pay_pev_shd.constraint_error
107: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
108: When Others Then
109: pay_pev_shd.g_api_dml := false; -- Unset the api dml status
110: Raise;
111: End update_dml;

Line 258: when hr_api.cannot_find_prog_unit then

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

Line 260: hr_api.cannot_find_prog_unit_error

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

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

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

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

323: If (p_rec.assignment_id = hr_api.g_number) then
324: p_rec.assignment_id :=
325: pay_pev_shd.g_old_rec.assignment_id;
326: End If;
327: If (p_rec.effective_date = hr_api.g_date) then
328: p_rec.effective_date :=
329: pay_pev_shd.g_old_rec.effective_date;
330: End If;
331: If (p_rec.change_type = hr_api.g_varchar2) then

Line 331: If (p_rec.change_type = hr_api.g_varchar2) then

327: If (p_rec.effective_date = hr_api.g_date) then
328: p_rec.effective_date :=
329: pay_pev_shd.g_old_rec.effective_date;
330: End If;
331: If (p_rec.change_type = hr_api.g_varchar2) then
332: p_rec.change_type :=
333: pay_pev_shd.g_old_rec.change_type;
334: End If;
335: If (p_rec.status = hr_api.g_varchar2) then

Line 335: If (p_rec.status = hr_api.g_varchar2) then

331: If (p_rec.change_type = hr_api.g_varchar2) then
332: p_rec.change_type :=
333: pay_pev_shd.g_old_rec.change_type;
334: End If;
335: If (p_rec.status = hr_api.g_varchar2) then
336: p_rec.status :=
337: pay_pev_shd.g_old_rec.status;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then

Line 339: If (p_rec.description = hr_api.g_varchar2) then

335: If (p_rec.status = hr_api.g_varchar2) then
336: p_rec.status :=
337: pay_pev_shd.g_old_rec.status;
338: End If;
339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: pay_pev_shd.g_old_rec.description;
342: End If;
343: If (p_rec.event_update_id = hr_api.g_number) then

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

339: If (p_rec.description = hr_api.g_varchar2) then
340: p_rec.description :=
341: pay_pev_shd.g_old_rec.description;
342: End If;
343: If (p_rec.event_update_id = hr_api.g_number) then
344: p_rec.event_update_id :=
345: pay_pev_shd.g_old_rec.event_update_id;
346: End If;
347: If (p_rec.business_group_id = hr_api.g_number) then

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

343: If (p_rec.event_update_id = hr_api.g_number) then
344: p_rec.event_update_id :=
345: pay_pev_shd.g_old_rec.event_update_id;
346: End If;
347: If (p_rec.business_group_id = hr_api.g_number) then
348: p_rec.business_group_id :=
349: pay_pev_shd.g_old_rec.business_group_id;
350: End If;
351: If (p_rec.org_process_event_group_id = hr_api.g_number) then

Line 351: If (p_rec.org_process_event_group_id = hr_api.g_number) then

347: If (p_rec.business_group_id = hr_api.g_number) then
348: p_rec.business_group_id :=
349: pay_pev_shd.g_old_rec.business_group_id;
350: End If;
351: If (p_rec.org_process_event_group_id = hr_api.g_number) then
352: p_rec.org_process_event_group_id :=
353: pay_pev_shd.g_old_rec.org_process_event_group_id;
354: End If;
355: If (p_rec.surrogate_key = hr_api.g_varchar2) then

Line 355: If (p_rec.surrogate_key = hr_api.g_varchar2) then

351: If (p_rec.org_process_event_group_id = hr_api.g_number) then
352: p_rec.org_process_event_group_id :=
353: pay_pev_shd.g_old_rec.org_process_event_group_id;
354: End If;
355: If (p_rec.surrogate_key = hr_api.g_varchar2) then
356: p_rec.surrogate_key :=
357: pay_pev_shd.g_old_rec.surrogate_key;
358: End If;
359: If (p_rec.calculation_date = hr_api.g_date) then

Line 359: If (p_rec.calculation_date = hr_api.g_date) then

355: If (p_rec.surrogate_key = hr_api.g_varchar2) then
356: p_rec.surrogate_key :=
357: pay_pev_shd.g_old_rec.surrogate_key;
358: End If;
359: If (p_rec.calculation_date = hr_api.g_date) then
360: p_rec.calculation_date :=
361: pay_pev_shd.g_old_rec.calculation_date;
362: End If;
363: If (p_rec.retroactive_status = hr_api.g_varchar2) then

Line 363: If (p_rec.retroactive_status = hr_api.g_varchar2) then

359: If (p_rec.calculation_date = hr_api.g_date) then
360: p_rec.calculation_date :=
361: pay_pev_shd.g_old_rec.calculation_date;
362: End If;
363: If (p_rec.retroactive_status = hr_api.g_varchar2) then
364: p_rec.retroactive_status :=
365: pay_pev_shd.g_old_rec.retroactive_status;
366: End If;
367: If (p_rec.noted_value = hr_api.g_varchar2) then

Line 367: If (p_rec.noted_value = hr_api.g_varchar2) then

363: If (p_rec.retroactive_status = hr_api.g_varchar2) then
364: p_rec.retroactive_status :=
365: pay_pev_shd.g_old_rec.retroactive_status;
366: End If;
367: If (p_rec.noted_value = hr_api.g_varchar2) then
368: p_rec.noted_value :=
369: pay_pev_shd.g_old_rec.noted_value;
370: End If;
371: --

Line 425: ,p_assignment_id in number default hr_api.g_number

421: -- ----------------------------------------------------------------------------
422: Procedure upd
423: (p_process_event_id in number
424: ,p_object_version_number in out nocopy number
425: ,p_assignment_id in number default hr_api.g_number
426: ,p_effective_date in date default hr_api.g_date
427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2

Line 426: ,p_effective_date in date default hr_api.g_date

422: Procedure upd
423: (p_process_event_id in number
424: ,p_object_version_number in out nocopy number
425: ,p_assignment_id in number default hr_api.g_number
426: ,p_effective_date in date default hr_api.g_date
427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number

Line 427: ,p_change_type in varchar2 default hr_api.g_varchar2

423: (p_process_event_id in number
424: ,p_object_version_number in out nocopy number
425: ,p_assignment_id in number default hr_api.g_number
426: ,p_effective_date in date default hr_api.g_date
427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number

Line 428: ,p_status in varchar2 default hr_api.g_varchar2

424: ,p_object_version_number in out nocopy number
425: ,p_assignment_id in number default hr_api.g_number
426: ,p_effective_date in date default hr_api.g_date
427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number

Line 429: ,p_description in varchar2 default hr_api.g_varchar2

425: ,p_assignment_id in number default hr_api.g_number
426: ,p_effective_date in date default hr_api.g_date
427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2

Line 430: ,p_event_update_id in number default hr_api.g_number

426: ,p_effective_date in date default hr_api.g_date
427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date

Line 431: ,p_business_group_id in number default hr_api.g_number

427: ,p_change_type in varchar2 default hr_api.g_varchar2
428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date
435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2

Line 432: ,p_org_process_event_group_id in number default hr_api.g_number

428: ,p_status in varchar2 default hr_api.g_varchar2
429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date
435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
436: ,p_noted_value in varchar2 default hr_api.g_varchar2

Line 433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2

429: ,p_description in varchar2 default hr_api.g_varchar2
430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date
435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
436: ,p_noted_value in varchar2 default hr_api.g_varchar2
437: ) is

Line 434: ,p_calculation_date in date default hr_api.g_date

430: ,p_event_update_id in number default hr_api.g_number
431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date
435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
436: ,p_noted_value in varchar2 default hr_api.g_varchar2
437: ) is
438: --

Line 435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2

431: ,p_business_group_id in number default hr_api.g_number
432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date
435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
436: ,p_noted_value in varchar2 default hr_api.g_varchar2
437: ) is
438: --
439: l_rec pay_pev_shd.g_rec_type;

Line 436: ,p_noted_value in varchar2 default hr_api.g_varchar2

432: ,p_org_process_event_group_id in number default hr_api.g_number
433: ,p_surrogate_key in varchar2 default hr_api.g_varchar2
434: ,p_calculation_date in date default hr_api.g_date
435: ,p_retroactive_status in varchar2 default hr_api.g_varchar2
436: ,p_noted_value in varchar2 default hr_api.g_varchar2
437: ) is
438: --
439: l_rec pay_pev_shd.g_rec_type;
440: l_proc varchar2(72) := g_package||'upd';