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));
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
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));
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
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));
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;
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');
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;
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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
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
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
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
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
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
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
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
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
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
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: --
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;
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';