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

Line 91: When hr_api.check_integrity_violated Then

87: --
88: hr_utility.set_location(' Leaving:'||l_proc, 10);
89: --
90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: pqh_txh_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: pqh_txh_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pqh_txh_shd.constraint_error

Line 96: When hr_api.parent_integrity_violated Then

92: -- A check constraint has been violated
93: --
94: pqh_txh_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pqh_txh_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: pqh_txh_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pqh_txh_shd.constraint_error

Line 101: When hr_api.unique_integrity_violated Then

97: -- Parent integrity has been violated
98: --
99: pqh_txh_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pqh_txh_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: pqh_txh_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;
109: End update_dml;

Line 201: when hr_api.cannot_find_prog_unit then

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

Line 203: hr_api.cannot_find_prog_unit_error

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

Line 266: If (p_rec.creator_person_id = hr_api.g_number) then

262: -- p_rec plsql record structure
263: -- to see if a system default is being used. If a system default
264: -- is being used then we must set to the 'current' argument value.
265: --
266: If (p_rec.creator_person_id = hr_api.g_number) then
267: p_rec.creator_person_id :=
268: pqh_txh_shd.g_old_rec.creator_person_id;
269: End If;
270: If (p_rec.assignment_id = hr_api.g_number) then

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

266: If (p_rec.creator_person_id = hr_api.g_number) then
267: p_rec.creator_person_id :=
268: pqh_txh_shd.g_old_rec.creator_person_id;
269: End If;
270: If (p_rec.assignment_id = hr_api.g_number) then
271: p_rec.assignment_id :=
272: pqh_txh_shd.g_old_rec.assignment_id;
273: End If;
274: If (p_rec.selected_person_id = hr_api.g_number) then

Line 274: If (p_rec.selected_person_id = hr_api.g_number) then

270: If (p_rec.assignment_id = hr_api.g_number) then
271: p_rec.assignment_id :=
272: pqh_txh_shd.g_old_rec.assignment_id;
273: End If;
274: If (p_rec.selected_person_id = hr_api.g_number) then
275: p_rec.selected_person_id :=
276: pqh_txh_shd.g_old_rec.selected_person_id;
277: End If;
278: If (p_rec.item_type = hr_api.g_varchar2) then

Line 278: If (p_rec.item_type = hr_api.g_varchar2) then

274: If (p_rec.selected_person_id = hr_api.g_number) then
275: p_rec.selected_person_id :=
276: pqh_txh_shd.g_old_rec.selected_person_id;
277: End If;
278: If (p_rec.item_type = hr_api.g_varchar2) then
279: p_rec.item_type :=
280: pqh_txh_shd.g_old_rec.item_type;
281: End If;
282: If (p_rec.item_key = hr_api.g_varchar2) then

Line 282: If (p_rec.item_key = hr_api.g_varchar2) then

278: If (p_rec.item_type = hr_api.g_varchar2) then
279: p_rec.item_type :=
280: pqh_txh_shd.g_old_rec.item_type;
281: End If;
282: If (p_rec.item_key = hr_api.g_varchar2) then
283: p_rec.item_key :=
284: pqh_txh_shd.g_old_rec.item_key;
285: End If;
286: If (p_rec.process_name = hr_api.g_varchar2) then

Line 286: If (p_rec.process_name = hr_api.g_varchar2) then

282: If (p_rec.item_key = hr_api.g_varchar2) then
283: p_rec.item_key :=
284: pqh_txh_shd.g_old_rec.item_key;
285: End If;
286: If (p_rec.process_name = hr_api.g_varchar2) then
287: p_rec.process_name :=
288: pqh_txh_shd.g_old_rec.process_name;
289: End If;
290: If (p_rec.approval_item_type = hr_api.g_varchar2) then

Line 290: If (p_rec.approval_item_type = hr_api.g_varchar2) then

286: If (p_rec.process_name = hr_api.g_varchar2) then
287: p_rec.process_name :=
288: pqh_txh_shd.g_old_rec.process_name;
289: End If;
290: If (p_rec.approval_item_type = hr_api.g_varchar2) then
291: p_rec.approval_item_type :=
292: pqh_txh_shd.g_old_rec.approval_item_type;
293: End If;
294: If (p_rec.approval_item_key = hr_api.g_varchar2) then

Line 294: If (p_rec.approval_item_key = hr_api.g_varchar2) then

290: If (p_rec.approval_item_type = hr_api.g_varchar2) then
291: p_rec.approval_item_type :=
292: pqh_txh_shd.g_old_rec.approval_item_type;
293: End If;
294: If (p_rec.approval_item_key = hr_api.g_varchar2) then
295: p_rec.approval_item_key :=
296: pqh_txh_shd.g_old_rec.approval_item_key;
297: End If;
298: If (p_rec.function_id = hr_api.g_number) then

Line 298: If (p_rec.function_id = hr_api.g_number) then

294: If (p_rec.approval_item_key = hr_api.g_varchar2) then
295: p_rec.approval_item_key :=
296: pqh_txh_shd.g_old_rec.approval_item_key;
297: End If;
298: If (p_rec.function_id = hr_api.g_number) then
299: p_rec.function_id :=
300: pqh_txh_shd.g_old_rec.function_id;
301: End If;
302: If (p_rec.rptg_grp_id = hr_api.g_number) then

Line 302: If (p_rec.rptg_grp_id = hr_api.g_number) then

298: If (p_rec.function_id = hr_api.g_number) then
299: p_rec.function_id :=
300: pqh_txh_shd.g_old_rec.function_id;
301: End If;
302: If (p_rec.rptg_grp_id = hr_api.g_number) then
303: p_rec.rptg_grp_id :=
304: pqh_txh_shd.g_old_rec.rptg_grp_id;
305: End If;
306: If (p_rec.plan_id = hr_api.g_number) then

Line 306: If (p_rec.plan_id = hr_api.g_number) then

302: If (p_rec.rptg_grp_id = hr_api.g_number) then
303: p_rec.rptg_grp_id :=
304: pqh_txh_shd.g_old_rec.rptg_grp_id;
305: End If;
306: If (p_rec.plan_id = hr_api.g_number) then
307: p_rec.plan_id :=
308: pqh_txh_shd.g_old_rec.plan_id;
309: End If;
310: If (p_rec.transaction_group = hr_api.g_varchar2) then

Line 310: If (p_rec.transaction_group = hr_api.g_varchar2) then

306: If (p_rec.plan_id = hr_api.g_number) then
307: p_rec.plan_id :=
308: pqh_txh_shd.g_old_rec.plan_id;
309: End If;
310: If (p_rec.transaction_group = hr_api.g_varchar2) then
311: p_rec.transaction_group :=
312: pqh_txh_shd.g_old_rec.transaction_group;
313: End If;
314: If (p_rec.transaction_identifier = hr_api.g_varchar2) then

Line 314: If (p_rec.transaction_identifier = hr_api.g_varchar2) then

310: If (p_rec.transaction_group = hr_api.g_varchar2) then
311: p_rec.transaction_group :=
312: pqh_txh_shd.g_old_rec.transaction_group;
313: End If;
314: If (p_rec.transaction_identifier = hr_api.g_varchar2) then
315: p_rec.transaction_identifier :=
316: pqh_txh_shd.g_old_rec.transaction_identifier;
317: End If;
318: --

Line 376: ,p_creator_person_id in number default hr_api.g_number

372: -- |---------------------------------< upd >----------------------------------|
373: -- ----------------------------------------------------------------------------
374: Procedure upd
375: (p_transaction_history_id in number
376: ,p_creator_person_id in number default hr_api.g_number
377: ,p_assignment_id in number default hr_api.g_number
378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2

Line 377: ,p_assignment_id in number default hr_api.g_number

373: -- ----------------------------------------------------------------------------
374: Procedure upd
375: (p_transaction_history_id in number
376: ,p_creator_person_id in number default hr_api.g_number
377: ,p_assignment_id in number default hr_api.g_number
378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2

Line 378: ,p_selected_person_id in number default hr_api.g_number

374: Procedure upd
375: (p_transaction_history_id in number
376: ,p_creator_person_id in number default hr_api.g_number
377: ,p_assignment_id in number default hr_api.g_number
378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2

Line 379: ,p_item_type in varchar2 default hr_api.g_varchar2

375: (p_transaction_history_id in number
376: ,p_creator_person_id in number default hr_api.g_number
377: ,p_assignment_id in number default hr_api.g_number
378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2

Line 380: ,p_item_key in varchar2 default hr_api.g_varchar2

376: ,p_creator_person_id in number default hr_api.g_number
377: ,p_assignment_id in number default hr_api.g_number
378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number

Line 381: ,p_process_name in varchar2 default hr_api.g_varchar2

377: ,p_assignment_id in number default hr_api.g_number
378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number

Line 382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2

378: ,p_selected_person_id in number default hr_api.g_number
379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number

Line 383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2

379: ,p_item_type in varchar2 default hr_api.g_varchar2
380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number
387: ,p_transaction_group in varchar2 default hr_api.g_varchar2

Line 384: ,p_function_id in number default hr_api.g_number

380: ,p_item_key in varchar2 default hr_api.g_varchar2
381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number
387: ,p_transaction_group in varchar2 default hr_api.g_varchar2
388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2

Line 385: ,p_rptg_grp_id in number default hr_api.g_number

381: ,p_process_name in varchar2 default hr_api.g_varchar2
382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number
387: ,p_transaction_group in varchar2 default hr_api.g_varchar2
388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2
389: ) is

Line 386: ,p_plan_id in number default hr_api.g_number

382: ,p_approval_item_type in varchar2 default hr_api.g_varchar2
383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number
387: ,p_transaction_group in varchar2 default hr_api.g_varchar2
388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2
389: ) is
390: --

Line 387: ,p_transaction_group in varchar2 default hr_api.g_varchar2

383: ,p_approval_item_key in varchar2 default hr_api.g_varchar2
384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number
387: ,p_transaction_group in varchar2 default hr_api.g_varchar2
388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2
389: ) is
390: --
391: l_rec pqh_txh_shd.g_rec_type;

Line 388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2

384: ,p_function_id in number default hr_api.g_number
385: ,p_rptg_grp_id in number default hr_api.g_number
386: ,p_plan_id in number default hr_api.g_number
387: ,p_transaction_group in varchar2 default hr_api.g_varchar2
388: ,p_transaction_identifier in varchar2 default hr_api.g_varchar2
389: ) is
390: --
391: l_rec pqh_txh_shd.g_rec_type;
392: l_proc varchar2(72) := g_package||'upd';