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.HXC_HAC_UPD dependencies on HR_API

Line 119: When hr_api.check_integrity_violated Then

115: hr_utility.set_location(' Leaving:'||l_proc, 10);
116: end if;
117: --
118: Exception
119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
122: hxc_hac_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

119: When hr_api.check_integrity_violated Then
120: -- A check constraint has been violated
121: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
122: hxc_hac_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
127: hxc_hac_shd.constraint_error

Line 124: When hr_api.parent_integrity_violated Then

120: -- A check constraint has been violated
121: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
122: hxc_hac_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
127: hxc_hac_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

124: When hr_api.parent_integrity_violated Then
125: -- Parent integrity has been violated
126: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
127: hxc_hac_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
132: hxc_hac_shd.constraint_error

Line 129: When hr_api.unique_integrity_violated Then

125: -- Parent integrity has been violated
126: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
127: hxc_hac_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
132: hxc_hac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

129: When hr_api.unique_integrity_violated Then
130: -- Unique integrity has been violated
131: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
132: hxc_hac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When Others Then
135: hxc_hac_shd.g_api_dml := false; -- Unset the api dml status
136: Raise;
137: End update_dml;

Line 302: when hr_api.cannot_find_prog_unit then

298: );
299: --
300: exception
301: --
302: when hr_api.cannot_find_prog_unit then
303: --
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'HXC_APPROVAL_COMPS'
306: ,p_hook_type => 'AU');

Line 304: hr_api.cannot_find_prog_unit_error

300: exception
301: --
302: when hr_api.cannot_find_prog_unit then
303: --
304: hr_api.cannot_find_prog_unit_error
305: (p_module_name => 'HXC_APPROVAL_COMPS'
306: ,p_hook_type => 'AU');
307: --
308: end;

Line 369: If (p_rec.approval_style_id = hr_api.g_number) then

365: -- p_rec plsql record structure
366: -- to see if a system default is being used. If a system default
367: -- is being used then we must set to the 'current' argument value.
368: --
369: If (p_rec.approval_style_id = hr_api.g_number) then
370: p_rec.approval_style_id :=
371: hxc_hac_shd.g_old_rec.approval_style_id;
372: End If;
373: If (p_rec.time_recipient_id = hr_api.g_number) then

Line 373: If (p_rec.time_recipient_id = hr_api.g_number) then

369: If (p_rec.approval_style_id = hr_api.g_number) then
370: p_rec.approval_style_id :=
371: hxc_hac_shd.g_old_rec.approval_style_id;
372: End If;
373: If (p_rec.time_recipient_id = hr_api.g_number) then
374: p_rec.time_recipient_id :=
375: hxc_hac_shd.g_old_rec.time_recipient_id;
376: End If;
377: If (p_rec.approval_mechanism = hr_api.g_varchar2) then

Line 377: If (p_rec.approval_mechanism = hr_api.g_varchar2) then

373: If (p_rec.time_recipient_id = hr_api.g_number) then
374: p_rec.time_recipient_id :=
375: hxc_hac_shd.g_old_rec.time_recipient_id;
376: End If;
377: If (p_rec.approval_mechanism = hr_api.g_varchar2) then
378: p_rec.approval_mechanism :=
379: hxc_hac_shd.g_old_rec.approval_mechanism;
380: End If;
381: If (p_rec.approval_mechanism_id = hr_api.g_number) then

Line 381: If (p_rec.approval_mechanism_id = hr_api.g_number) then

377: If (p_rec.approval_mechanism = hr_api.g_varchar2) then
378: p_rec.approval_mechanism :=
379: hxc_hac_shd.g_old_rec.approval_mechanism;
380: End If;
381: If (p_rec.approval_mechanism_id = hr_api.g_number) then
382: p_rec.approval_mechanism_id :=
383: hxc_hac_shd.g_old_rec.approval_mechanism_id;
384: End If;
385: If (p_rec.wf_item_type = hr_api.g_varchar2) then

Line 385: If (p_rec.wf_item_type = hr_api.g_varchar2) then

381: If (p_rec.approval_mechanism_id = hr_api.g_number) then
382: p_rec.approval_mechanism_id :=
383: hxc_hac_shd.g_old_rec.approval_mechanism_id;
384: End If;
385: If (p_rec.wf_item_type = hr_api.g_varchar2) then
386: p_rec.wf_item_type :=
387: hxc_hac_shd.g_old_rec.wf_item_type;
388: End If;
389: If (p_rec.wf_name = hr_api.g_varchar2) then

Line 389: If (p_rec.wf_name = hr_api.g_varchar2) then

385: If (p_rec.wf_item_type = hr_api.g_varchar2) then
386: p_rec.wf_item_type :=
387: hxc_hac_shd.g_old_rec.wf_item_type;
388: End If;
389: If (p_rec.wf_name = hr_api.g_varchar2) then
390: p_rec.wf_name :=
391: hxc_hac_shd.g_old_rec.wf_name;
392: End If;
393: If (p_rec.start_date = hr_api.g_date) then

Line 393: If (p_rec.start_date = hr_api.g_date) then

389: If (p_rec.wf_name = hr_api.g_varchar2) then
390: p_rec.wf_name :=
391: hxc_hac_shd.g_old_rec.wf_name;
392: End If;
393: If (p_rec.start_date = hr_api.g_date) then
394: p_rec.start_date :=
395: hxc_hac_shd.g_old_rec.start_date;
396: End If;
397: If (p_rec.end_date = hr_api.g_date) then

Line 397: If (p_rec.end_date = hr_api.g_date) then

393: If (p_rec.start_date = hr_api.g_date) then
394: p_rec.start_date :=
395: hxc_hac_shd.g_old_rec.start_date;
396: End If;
397: If (p_rec.end_date = hr_api.g_date) then
398: p_rec.end_date :=
399: hxc_hac_shd.g_old_rec.end_date;
400: End If;
401: If (p_rec.approval_order = hr_api.g_number) then

Line 401: If (p_rec.approval_order = hr_api.g_number) then

397: If (p_rec.end_date = hr_api.g_date) then
398: p_rec.end_date :=
399: hxc_hac_shd.g_old_rec.end_date;
400: End If;
401: If (p_rec.approval_order = hr_api.g_number) then
402: p_rec.approval_order :=
403: hxc_hac_shd.g_old_rec.approval_order;
404: End If;
405: If (p_rec.time_category_id = hr_api.g_number) then

Line 405: If (p_rec.time_category_id = hr_api.g_number) then

401: If (p_rec.approval_order = hr_api.g_number) then
402: p_rec.approval_order :=
403: hxc_hac_shd.g_old_rec.approval_order;
404: End If;
405: If (p_rec.time_category_id = hr_api.g_number) then
406: p_rec.time_category_id :=
407: hxc_hac_shd.g_old_rec.time_category_id;
408: End If;
409: If (p_rec.parent_comp_id = hr_api.g_number) then

Line 409: If (p_rec.parent_comp_id = hr_api.g_number) then

405: If (p_rec.time_category_id = hr_api.g_number) then
406: p_rec.time_category_id :=
407: hxc_hac_shd.g_old_rec.time_category_id;
408: End If;
409: If (p_rec.parent_comp_id = hr_api.g_number) then
410: p_rec.parent_comp_id :=
411: hxc_hac_shd.g_old_rec.parent_comp_id;
412: End If;
413: If (p_rec.parent_comp_ovn = hr_api.g_number) then

Line 413: If (p_rec.parent_comp_ovn = hr_api.g_number) then

409: If (p_rec.parent_comp_id = hr_api.g_number) then
410: p_rec.parent_comp_id :=
411: hxc_hac_shd.g_old_rec.parent_comp_id;
412: End If;
413: If (p_rec.parent_comp_ovn = hr_api.g_number) then
414: p_rec.parent_comp_ovn :=
415: hxc_hac_shd.g_old_rec.parent_comp_ovn;
416: End If;
417: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then

Line 417: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then

413: If (p_rec.parent_comp_ovn = hr_api.g_number) then
414: p_rec.parent_comp_ovn :=
415: hxc_hac_shd.g_old_rec.parent_comp_ovn;
416: End If;
417: If (p_rec.run_recipient_extensions = hr_api.g_varchar2) then
418: p_rec.run_recipient_extensions :=
419: hxc_hac_shd.g_old_rec.run_recipient_extensions;
420: End If;
421: --

Line 483: ,p_approval_style_id in number default hr_api.g_number

479: Procedure upd
480: (p_effective_date in date
481: ,p_approval_comp_id in number
482: ,p_object_version_number in out nocopy number
483: ,p_approval_style_id in number default hr_api.g_number
484: ,p_time_recipient_id in number default hr_api.g_number
485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date

Line 484: ,p_time_recipient_id in number default hr_api.g_number

480: (p_effective_date in date
481: ,p_approval_comp_id in number
482: ,p_object_version_number in out nocopy number
483: ,p_approval_style_id in number default hr_api.g_number
484: ,p_time_recipient_id in number default hr_api.g_number
485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number

Line 485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2

481: ,p_approval_comp_id in number
482: ,p_object_version_number in out nocopy number
483: ,p_approval_style_id in number default hr_api.g_number
484: ,p_time_recipient_id in number default hr_api.g_number
485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2

Line 486: ,p_start_date in date default hr_api.g_date

482: ,p_object_version_number in out nocopy number
483: ,p_approval_style_id in number default hr_api.g_number
484: ,p_time_recipient_id in number default hr_api.g_number
485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2

Line 487: ,p_end_date in date default hr_api.g_date

483: ,p_approval_style_id in number default hr_api.g_number
484: ,p_time_recipient_id in number default hr_api.g_number
485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number

Line 488: ,p_approval_mechanism_id in number default hr_api.g_number

484: ,p_time_recipient_id in number default hr_api.g_number
485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number

Line 489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2

485: ,p_approval_mechanism in varchar2 default hr_api.g_varchar2
486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number

Line 490: ,p_wf_name in varchar2 default hr_api.g_varchar2

486: ,p_start_date in date default hr_api.g_date
487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number
494: ,p_parent_comp_ovn in number default hr_api.g_number

Line 491: ,p_approval_order in number default hr_api.g_number

487: ,p_end_date in date default hr_api.g_date
488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number
494: ,p_parent_comp_ovn in number default hr_api.g_number
495: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2

Line 492: ,p_time_category_id in number default hr_api.g_number

488: ,p_approval_mechanism_id in number default hr_api.g_number
489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number
494: ,p_parent_comp_ovn in number default hr_api.g_number
495: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
496:

Line 493: ,p_parent_comp_id in number default hr_api.g_number

489: ,p_wf_item_type in varchar2 default hr_api.g_varchar2
490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number
494: ,p_parent_comp_ovn in number default hr_api.g_number
495: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
496:
497: ) is

Line 494: ,p_parent_comp_ovn in number default hr_api.g_number

490: ,p_wf_name in varchar2 default hr_api.g_varchar2
491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number
494: ,p_parent_comp_ovn in number default hr_api.g_number
495: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
496:
497: ) is
498: --

Line 495: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2

491: ,p_approval_order in number default hr_api.g_number
492: ,p_time_category_id in number default hr_api.g_number
493: ,p_parent_comp_id in number default hr_api.g_number
494: ,p_parent_comp_ovn in number default hr_api.g_number
495: ,p_run_recipient_extensions in varchar2 default hr_api.g_varchar2
496:
497: ) is
498: --
499: l_rec hxc_hac_shd.g_rec_type;