APPS.PQH_TAH_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: pqh_tah_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: pqh_tah_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: pqh_tah_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

91: -- A check constraint has been violated
92: --
93: pqh_tah_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: pqh_tah_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: pqh_tah_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: pqh_tah_shd.constraint_error

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: --
98: pqh_tah_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: pqh_tah_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: pqh_tah_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 200: when hr_api.cannot_find_prog_unit then

196: null;
197: --
198: exception
199: --
200: when hr_api.cannot_find_prog_unit then
201: --
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'PQH_SS_APPROVAL_HISTORY'
204: ,p_hook_type => 'AU');

Line 202: hr_api.cannot_find_prog_unit_error

198: exception
199: --
200: when hr_api.cannot_find_prog_unit then
201: --
202: hr_api.cannot_find_prog_unit_error
203: (p_module_name => 'PQH_SS_APPROVAL_HISTORY'
204: ,p_hook_type => 'AU');
205: --
206: end;

Line 265: If (p_rec.transaction_effective_date = hr_api.g_date) then

261: -- p_rec plsql record structure
262: -- to see if a system default is being used. If a system default
263: -- is being used then we must set to the 'current' argument value.
264: --
265: If (p_rec.transaction_effective_date = hr_api.g_date) then
266: p_rec.transaction_effective_date :=
267: pqh_tah_shd.g_old_rec.transaction_effective_date;
268: End If;
269: If (p_rec.action = hr_api.g_varchar2) then

Line 269: If (p_rec.action = hr_api.g_varchar2) then

265: If (p_rec.transaction_effective_date = hr_api.g_date) then
266: p_rec.transaction_effective_date :=
267: pqh_tah_shd.g_old_rec.transaction_effective_date;
268: End If;
269: If (p_rec.action = hr_api.g_varchar2) then
270: p_rec.action :=
271: pqh_tah_shd.g_old_rec.action;
272: End If;
273: If (p_rec.user_name = hr_api.g_varchar2) then

Line 273: If (p_rec.user_name = hr_api.g_varchar2) then

269: If (p_rec.action = hr_api.g_varchar2) then
270: p_rec.action :=
271: pqh_tah_shd.g_old_rec.action;
272: End If;
273: If (p_rec.user_name = hr_api.g_varchar2) then
274: p_rec.user_name :=
275: pqh_tah_shd.g_old_rec.user_name;
276: End If;
277: If (p_rec.transaction_item_type = hr_api.g_varchar2) then

Line 277: If (p_rec.transaction_item_type = hr_api.g_varchar2) then

273: If (p_rec.user_name = hr_api.g_varchar2) then
274: p_rec.user_name :=
275: pqh_tah_shd.g_old_rec.user_name;
276: End If;
277: If (p_rec.transaction_item_type = hr_api.g_varchar2) then
278: p_rec.transaction_item_type :=
279: pqh_tah_shd.g_old_rec.transaction_item_type;
280: End If;
281: If (p_rec.transaction_item_key = hr_api.g_varchar2) then

Line 281: If (p_rec.transaction_item_key = hr_api.g_varchar2) then

277: If (p_rec.transaction_item_type = hr_api.g_varchar2) then
278: p_rec.transaction_item_type :=
279: pqh_tah_shd.g_old_rec.transaction_item_type;
280: End If;
281: If (p_rec.transaction_item_key = hr_api.g_varchar2) then
282: p_rec.transaction_item_key :=
283: pqh_tah_shd.g_old_rec.transaction_item_key;
284: End If;
285: If (p_rec.effective_date_option = hr_api.g_varchar2) then

Line 285: If (p_rec.effective_date_option = hr_api.g_varchar2) then

281: If (p_rec.transaction_item_key = hr_api.g_varchar2) then
282: p_rec.transaction_item_key :=
283: pqh_tah_shd.g_old_rec.transaction_item_key;
284: End If;
285: If (p_rec.effective_date_option = hr_api.g_varchar2) then
286: p_rec.effective_date_option :=
287: pqh_tah_shd.g_old_rec.effective_date_option;
288: End If;
289: If (p_rec.orig_system = hr_api.g_varchar2) then

Line 289: If (p_rec.orig_system = hr_api.g_varchar2) then

285: If (p_rec.effective_date_option = hr_api.g_varchar2) then
286: p_rec.effective_date_option :=
287: pqh_tah_shd.g_old_rec.effective_date_option;
288: End If;
289: If (p_rec.orig_system = hr_api.g_varchar2) then
290: p_rec.orig_system :=
291: pqh_tah_shd.g_old_rec.orig_system;
292: End If;
293: If (p_rec.orig_system_id = hr_api.g_number) then

Line 293: If (p_rec.orig_system_id = hr_api.g_number) then

289: If (p_rec.orig_system = hr_api.g_varchar2) then
290: p_rec.orig_system :=
291: pqh_tah_shd.g_old_rec.orig_system;
292: End If;
293: If (p_rec.orig_system_id = hr_api.g_number) then
294: p_rec.orig_system_id :=
295: pqh_tah_shd.g_old_rec.orig_system_id;
296: End If;
297: If (p_rec.notification_id = hr_api.g_number) then

Line 297: If (p_rec.notification_id = hr_api.g_number) then

293: If (p_rec.orig_system_id = hr_api.g_number) then
294: p_rec.orig_system_id :=
295: pqh_tah_shd.g_old_rec.orig_system_id;
296: End If;
297: If (p_rec.notification_id = hr_api.g_number) then
298: p_rec.notification_id :=
299: pqh_tah_shd.g_old_rec.notification_id;
300: End If;
301: If (p_rec.user_comment = hr_api.g_varchar2) then

Line 301: If (p_rec.user_comment = hr_api.g_varchar2) then

297: If (p_rec.notification_id = hr_api.g_number) then
298: p_rec.notification_id :=
299: pqh_tah_shd.g_old_rec.notification_id;
300: End If;
301: If (p_rec.user_comment = hr_api.g_varchar2) then
302: p_rec.user_comment :=
303: pqh_tah_shd.g_old_rec.user_comment;
304: End If;
305: --

Line 365: ,p_transaction_effective_date in date default hr_api.g_date

361: -- ----------------------------------------------------------------------------
362: Procedure upd
363: (p_approval_history_id in number
364: ,p_transaction_history_id in number
365: ,p_transaction_effective_date in date default hr_api.g_date
366: ,p_action in varchar2 default hr_api.g_varchar2
367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2

Line 366: ,p_action in varchar2 default hr_api.g_varchar2

362: Procedure upd
363: (p_approval_history_id in number
364: ,p_transaction_history_id in number
365: ,p_transaction_effective_date in date default hr_api.g_date
366: ,p_action in varchar2 default hr_api.g_varchar2
367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

Line 367: ,p_user_name in varchar2 default hr_api.g_varchar2

363: (p_approval_history_id in number
364: ,p_transaction_history_id in number
365: ,p_transaction_effective_date in date default hr_api.g_date
366: ,p_action in varchar2 default hr_api.g_varchar2
367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2

Line 368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2

364: ,p_transaction_history_id in number
365: ,p_transaction_effective_date in date default hr_api.g_date
366: ,p_action in varchar2 default hr_api.g_varchar2
367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number

Line 369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2

365: ,p_transaction_effective_date in date default hr_api.g_date
366: ,p_action in varchar2 default hr_api.g_varchar2
367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number
373: ,p_notification_id in number default hr_api.g_number

Line 370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

366: ,p_action in varchar2 default hr_api.g_varchar2
367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number
373: ,p_notification_id in number default hr_api.g_number
374: ,p_user_comment in varchar2 default hr_api.g_varchar2

Line 371: ,p_orig_system in varchar2 default hr_api.g_varchar2

367: ,p_user_name in varchar2 default hr_api.g_varchar2
368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number
373: ,p_notification_id in number default hr_api.g_number
374: ,p_user_comment in varchar2 default hr_api.g_varchar2
375: ) is

Line 372: ,p_orig_system_id in number default hr_api.g_number

368: ,p_transaction_item_type in varchar2 default hr_api.g_varchar2
369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number
373: ,p_notification_id in number default hr_api.g_number
374: ,p_user_comment in varchar2 default hr_api.g_varchar2
375: ) is
376: --

Line 373: ,p_notification_id in number default hr_api.g_number

369: ,p_transaction_item_key in varchar2 default hr_api.g_varchar2
370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number
373: ,p_notification_id in number default hr_api.g_number
374: ,p_user_comment in varchar2 default hr_api.g_varchar2
375: ) is
376: --
377: l_rec pqh_tah_shd.g_rec_type;

Line 374: ,p_user_comment in varchar2 default hr_api.g_varchar2

370: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
371: ,p_orig_system in varchar2 default hr_api.g_varchar2
372: ,p_orig_system_id in number default hr_api.g_number
373: ,p_notification_id in number default hr_api.g_number
374: ,p_user_comment in varchar2 default hr_api.g_varchar2
375: ) is
376: --
377: l_rec pqh_tah_shd.g_rec_type;
378: l_proc varchar2(72) := g_package||'upd';