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_TSH_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_tsh_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_tsh_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_tsh_shd.constraint_error

Line 95: When hr_api.parent_integrity_violated Then

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

Line 100: When hr_api.unique_integrity_violated Then

96: -- Parent integrity has been violated
97: --
98: pqh_tsh_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_tsh_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_tsh_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_TRANS_STATE_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_TRANS_STATE_HISTORY'
204: ,p_hook_type => 'AU');
205: --
206: end;

Line 265: If (p_rec.creator_person_id = hr_api.g_number) 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.creator_person_id = hr_api.g_number) then
266: p_rec.creator_person_id :=
267: pqh_tsh_shd.g_old_rec.creator_person_id;
268: End If;
269: If (p_rec.creator_role = hr_api.g_varchar2) then

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

265: If (p_rec.creator_person_id = hr_api.g_number) then
266: p_rec.creator_person_id :=
267: pqh_tsh_shd.g_old_rec.creator_person_id;
268: End If;
269: If (p_rec.creator_role = hr_api.g_varchar2) then
270: p_rec.creator_role :=
271: pqh_tsh_shd.g_old_rec.creator_role;
272: End If;
273: If (p_rec.status = hr_api.g_varchar2) then

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

269: If (p_rec.creator_role = hr_api.g_varchar2) then
270: p_rec.creator_role :=
271: pqh_tsh_shd.g_old_rec.creator_role;
272: End If;
273: If (p_rec.status = hr_api.g_varchar2) then
274: p_rec.status :=
275: pqh_tsh_shd.g_old_rec.status;
276: End If;
277: If (p_rec.transaction_state = hr_api.g_varchar2) then

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

273: If (p_rec.status = hr_api.g_varchar2) then
274: p_rec.status :=
275: pqh_tsh_shd.g_old_rec.status;
276: End If;
277: If (p_rec.transaction_state = hr_api.g_varchar2) then
278: p_rec.transaction_state :=
279: pqh_tsh_shd.g_old_rec.transaction_state;
280: End If;
281: If (p_rec.effective_date = hr_api.g_date) then

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

277: If (p_rec.transaction_state = hr_api.g_varchar2) then
278: p_rec.transaction_state :=
279: pqh_tsh_shd.g_old_rec.transaction_state;
280: End If;
281: If (p_rec.effective_date = hr_api.g_date) then
282: p_rec.effective_date :=
283: pqh_tsh_shd.g_old_rec.effective_date;
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.effective_date = hr_api.g_date) then
282: p_rec.effective_date :=
283: pqh_tsh_shd.g_old_rec.effective_date;
284: End If;
285: If (p_rec.effective_date_option = hr_api.g_varchar2) then
286: p_rec.effective_date_option :=
287: pqh_tsh_shd.g_old_rec.effective_date_option;
288: End If;
289: If (p_rec.last_update_role = hr_api.g_varchar2) then

Line 289: If (p_rec.last_update_role = 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_tsh_shd.g_old_rec.effective_date_option;
288: End If;
289: If (p_rec.last_update_role = hr_api.g_varchar2) then
290: p_rec.last_update_role :=
291: pqh_tsh_shd.g_old_rec.last_update_role;
292: End If;
293: If (p_rec.parent_transaction_id = hr_api.g_number) then

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

289: If (p_rec.last_update_role = hr_api.g_varchar2) then
290: p_rec.last_update_role :=
291: pqh_tsh_shd.g_old_rec.last_update_role;
292: End If;
293: If (p_rec.parent_transaction_id = hr_api.g_number) then
294: p_rec.parent_transaction_id :=
295: pqh_tsh_shd.g_old_rec.parent_transaction_id;
296: End If;
297: If (p_rec.relaunch_function = hr_api.g_varchar2) then

Line 297: If (p_rec.relaunch_function = hr_api.g_varchar2) then

293: If (p_rec.parent_transaction_id = hr_api.g_number) then
294: p_rec.parent_transaction_id :=
295: pqh_tsh_shd.g_old_rec.parent_transaction_id;
296: End If;
297: If (p_rec.relaunch_function = hr_api.g_varchar2) then
298: p_rec.relaunch_function :=
299: pqh_tsh_shd.g_old_rec.relaunch_function;
300: End If;
301: If (p_rec.transaction_document IS NULL) then

Line 364: ,p_creator_person_id in number default hr_api.g_number

360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (p_transaction_history_id in number
363: ,p_approval_history_id in number
364: ,p_creator_person_id in number default hr_api.g_number
365: ,p_creator_role in varchar2 default hr_api.g_varchar2
366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date

Line 365: ,p_creator_role in varchar2 default hr_api.g_varchar2

361: Procedure upd
362: (p_transaction_history_id in number
363: ,p_approval_history_id in number
364: ,p_creator_person_id in number default hr_api.g_number
365: ,p_creator_role in varchar2 default hr_api.g_varchar2
366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

Line 366: ,p_status in varchar2 default hr_api.g_varchar2

362: (p_transaction_history_id in number
363: ,p_approval_history_id in number
364: ,p_creator_person_id in number default hr_api.g_number
365: ,p_creator_role in varchar2 default hr_api.g_varchar2
366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2

Line 367: ,p_transaction_state in varchar2 default hr_api.g_varchar2

363: ,p_approval_history_id in number
364: ,p_creator_person_id in number default hr_api.g_number
365: ,p_creator_role in varchar2 default hr_api.g_varchar2
366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2
371: ,p_parent_transaction_id in number default hr_api.g_number

Line 368: ,p_effective_date in date default hr_api.g_date

364: ,p_creator_person_id in number default hr_api.g_number
365: ,p_creator_role in varchar2 default hr_api.g_varchar2
366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2
371: ,p_parent_transaction_id in number default hr_api.g_number
372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2

Line 369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2

365: ,p_creator_role in varchar2 default hr_api.g_varchar2
366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2
371: ,p_parent_transaction_id in number default hr_api.g_number
372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2
373: ,p_transaction_document in CLOB default NULL

Line 370: ,p_last_update_role in varchar2 default hr_api.g_varchar2

366: ,p_status in varchar2 default hr_api.g_varchar2
367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2
371: ,p_parent_transaction_id in number default hr_api.g_number
372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2
373: ,p_transaction_document in CLOB default NULL
374: ) is

Line 371: ,p_parent_transaction_id in number default hr_api.g_number

367: ,p_transaction_state in varchar2 default hr_api.g_varchar2
368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2
371: ,p_parent_transaction_id in number default hr_api.g_number
372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2
373: ,p_transaction_document in CLOB default NULL
374: ) is
375: --

Line 372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2

368: ,p_effective_date in date default hr_api.g_date
369: ,p_effective_date_option in varchar2 default hr_api.g_varchar2
370: ,p_last_update_role in varchar2 default hr_api.g_varchar2
371: ,p_parent_transaction_id in number default hr_api.g_number
372: ,p_relaunch_function in varchar2 default hr_api.g_varchar2
373: ,p_transaction_document in CLOB default NULL
374: ) is
375: --
376: l_rec pqh_tsh_shd.g_rec_type;