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

Line 79: When hr_api.check_integrity_violated Then

75: --
76: hr_utility.set_location(' Leaving:'||l_proc, 10);
77: --
78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: pqh_fyn_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then

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

78: Exception
79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: pqh_fyn_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_fyn_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 83: When hr_api.parent_integrity_violated Then

79: When hr_api.check_integrity_violated Then
80: -- A check constraint has been violated
81: pqh_fyn_shd.constraint_error
82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_fyn_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then

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

82: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_fyn_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: pqh_fyn_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 87: When hr_api.unique_integrity_violated Then

83: When hr_api.parent_integrity_violated Then
84: -- Parent integrity has been violated
85: pqh_fyn_shd.constraint_error
86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: pqh_fyn_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then

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

86: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
87: When hr_api.unique_integrity_violated Then
88: -- Unique integrity has been violated
89: pqh_fyn_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When Others Then
92: Raise;
93: End update_dml;
94: --

Line 206: when hr_api.cannot_find_prog_unit then

202: );
203: --
204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'pqh_fyi_notify'
210: ,p_hook_type => 'AU');

Line 208: hr_api.cannot_find_prog_unit_error

204: exception
205: --
206: when hr_api.cannot_find_prog_unit then
207: --
208: hr_api.cannot_find_prog_unit_error
209: (p_module_name => 'pqh_fyi_notify'
210: ,p_hook_type => 'AU');
211: --
212: end;

Line 276: If (p_rec.transaction_category_id = hr_api.g_number) then

272: -- p_rec plsql record structure
273: -- to see if a system default is being used. If a system default
274: -- is being used then we must set to the 'current' argument value.
275: --
276: If (p_rec.transaction_category_id = hr_api.g_number) then
277: p_rec.transaction_category_id :=
278: pqh_fyn_shd.g_old_rec.transaction_category_id;
279: End If;
280: If (p_rec.transaction_id = hr_api.g_number) then

Line 280: If (p_rec.transaction_id = hr_api.g_number) then

276: If (p_rec.transaction_category_id = hr_api.g_number) then
277: p_rec.transaction_category_id :=
278: pqh_fyn_shd.g_old_rec.transaction_category_id;
279: End If;
280: If (p_rec.transaction_id = hr_api.g_number) then
281: p_rec.transaction_id :=
282: pqh_fyn_shd.g_old_rec.transaction_id;
283: End If;
284: If (p_rec.notification_event_cd = hr_api.g_varchar2) then

Line 284: If (p_rec.notification_event_cd = hr_api.g_varchar2) then

280: If (p_rec.transaction_id = hr_api.g_number) then
281: p_rec.transaction_id :=
282: pqh_fyn_shd.g_old_rec.transaction_id;
283: End If;
284: If (p_rec.notification_event_cd = hr_api.g_varchar2) then
285: p_rec.notification_event_cd :=
286: pqh_fyn_shd.g_old_rec.notification_event_cd;
287: End If;
288: If (p_rec.notified_type_cd = hr_api.g_varchar2) then

Line 288: If (p_rec.notified_type_cd = hr_api.g_varchar2) then

284: If (p_rec.notification_event_cd = hr_api.g_varchar2) then
285: p_rec.notification_event_cd :=
286: pqh_fyn_shd.g_old_rec.notification_event_cd;
287: End If;
288: If (p_rec.notified_type_cd = hr_api.g_varchar2) then
289: p_rec.notified_type_cd :=
290: pqh_fyn_shd.g_old_rec.notified_type_cd;
291: End If;
292: If (p_rec.notified_name = hr_api.g_varchar2) then

Line 292: If (p_rec.notified_name = hr_api.g_varchar2) then

288: If (p_rec.notified_type_cd = hr_api.g_varchar2) then
289: p_rec.notified_type_cd :=
290: pqh_fyn_shd.g_old_rec.notified_type_cd;
291: End If;
292: If (p_rec.notified_name = hr_api.g_varchar2) then
293: p_rec.notified_name :=
294: pqh_fyn_shd.g_old_rec.notified_name;
295: End If;
296: If (p_rec.notification_date = hr_api.g_date) then

Line 296: If (p_rec.notification_date = hr_api.g_date) then

292: If (p_rec.notified_name = hr_api.g_varchar2) then
293: p_rec.notified_name :=
294: pqh_fyn_shd.g_old_rec.notified_name;
295: End If;
296: If (p_rec.notification_date = hr_api.g_date) then
297: p_rec.notification_date :=
298: pqh_fyn_shd.g_old_rec.notification_date;
299: End If;
300: If (p_rec.status = hr_api.g_varchar2) then

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

296: If (p_rec.notification_date = hr_api.g_date) then
297: p_rec.notification_date :=
298: pqh_fyn_shd.g_old_rec.notification_date;
299: End If;
300: If (p_rec.status = hr_api.g_varchar2) then
301: p_rec.status :=
302: pqh_fyn_shd.g_old_rec.status;
303: End If;
304:

Line 363: p_transaction_category_id in number default hr_api.g_number,

359: Procedure upd
360: (
361: p_effective_date in date,
362: p_fyi_notified_id in number,
363: p_transaction_category_id in number default hr_api.g_number,
364: p_transaction_id in number default hr_api.g_number,
365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,

Line 364: p_transaction_id in number default hr_api.g_number,

360: (
361: p_effective_date in date,
362: p_fyi_notified_id in number,
363: p_transaction_category_id in number default hr_api.g_number,
364: p_transaction_id in number default hr_api.g_number,
365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,
368: p_notification_date in date default hr_api.g_date,

Line 365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,

361: p_effective_date in date,
362: p_fyi_notified_id in number,
363: p_transaction_category_id in number default hr_api.g_number,
364: p_transaction_id in number default hr_api.g_number,
365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,
368: p_notification_date in date default hr_api.g_date,
369: p_status in varchar2 default hr_api.g_varchar2,

Line 366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,

362: p_fyi_notified_id in number,
363: p_transaction_category_id in number default hr_api.g_number,
364: p_transaction_id in number default hr_api.g_number,
365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,
368: p_notification_date in date default hr_api.g_date,
369: p_status in varchar2 default hr_api.g_varchar2,
370: p_object_version_number in out nocopy number

Line 367: p_notified_name in varchar2 default hr_api.g_varchar2,

363: p_transaction_category_id in number default hr_api.g_number,
364: p_transaction_id in number default hr_api.g_number,
365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,
368: p_notification_date in date default hr_api.g_date,
369: p_status in varchar2 default hr_api.g_varchar2,
370: p_object_version_number in out nocopy number
371: ) is

Line 368: p_notification_date in date default hr_api.g_date,

364: p_transaction_id in number default hr_api.g_number,
365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,
368: p_notification_date in date default hr_api.g_date,
369: p_status in varchar2 default hr_api.g_varchar2,
370: p_object_version_number in out nocopy number
371: ) is
372: --

Line 369: p_status in varchar2 default hr_api.g_varchar2,

365: p_notification_event_cd in varchar2 default hr_api.g_varchar2,
366: p_notified_type_cd in varchar2 default hr_api.g_varchar2,
367: p_notified_name in varchar2 default hr_api.g_varchar2,
368: p_notification_date in date default hr_api.g_date,
369: p_status in varchar2 default hr_api.g_varchar2,
370: p_object_version_number in out nocopy number
371: ) is
372: --
373: l_rec pqh_fyn_shd.g_rec_type;