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_APPROVAL_WF_PKG dependencies on HXC_APPROVAL_WF_PKG

Line 1: PACKAGE BODY hxc_approval_wf_pkg AS

1: PACKAGE BODY hxc_approval_wf_pkg AS
2: /* $Header: hxcapprwf.pkb 120.50.12020000.5 2012/12/13 12:53:29 asrajago ship $ */
3: --
4: -- Possible Notification Status Constants.
5: --

Line 614: l_proc varchar2(50) := 'HXC_APPROVAL_WF_PKG.changed';

610: l_block_index NUMBER;
611: l_count number := 0;
612: l_same boolean := true;
613:
614: l_proc varchar2(50) := 'HXC_APPROVAL_WF_PKG.changed';
615: BEGIN
616: g_debug:=hr_utility.debug_enabled;
617: if g_debug then
618: hr_utility.set_location(l_proc, 10);

Line 1116: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.update_appl_period';

1112: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
1113: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
1114: l_wf_item_type varchar2(500) := NULL;
1115: l_is_blank varchar2(10);
1116: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.update_appl_period';
1117:
1118:
1119: BEGIN
1120: g_debug:=hr_utility.debug_enabled;

Line 1345: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.update_appl_period',

1341: hr_utility.set_location(l_proc, 999);
1342: hr_utility.trace('IN EXCEPTION IN update_appl_period');
1343: end if;
1344: --
1345: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.update_appl_period',
1346: itemtype, itemkey, to_char(actid), funcmode);
1347: raise;
1348: result := '';
1349: return;

Line 1597: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.create_next_period',

1593: --
1594: hr_utility.trace('IN EXCEPTION IN create_next_period');
1595: --
1596: end if;
1597: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.create_next_period',
1598: itemtype, itemkey, to_char(actid), funcmode);
1599: raise;
1600: result := '';
1601: return;

Line 2818: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.get_approval_style_id';

2814: AND timecard.date_to = hr_general.end_of_time
2815: ORDER BY day1.start_time desc;
2816: --
2817: l_approval_style_id number;
2818: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.get_approval_style_id';
2819: --
2820: BEGIN
2821: --
2822: if g_debug then

Line 2977: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.create_appl_period_info';

2973: l_exists varchar2(1);
2974: l_chk_days varchar2(1);
2975: l_item_key wf_items.item_key%type;
2976: l_process_name varchar2(30);
2977: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.create_appl_period_info';
2978:
2979: --
2980: l_detail_blocks block_table;
2981: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;

Line 3792: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.create_appl_period_info',

3788: --
3789: hr_utility.trace('IN EXCEPTION IN create_appl_period_info');
3790: --
3791: end if;
3792: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.create_appl_period_info',
3793: itemtype, itemkey, to_char(actid), funcmode, g_trace);
3794:
3795: raise;
3796: result := '';

Line 3855: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_app_approved';

3851: l_days number := p_period_end_date - p_period_start_date + 1;
3852: l_date date;
3853: l_approved varchar2(1);
3854: l_approval_status varchar2(30);
3855: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_app_approved';
3856:
3857: BEGIN
3858:
3859: if g_debug then

Line 3975: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_submitted_days';

3971:
3972:
3973: l_assignment_periods hxc_timecard_utilities.periods;
3974: l_day DATE;
3975: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_submitted_days';
3976: --
3977: BEGIN
3978: --
3979: if g_debug then

Line 4094: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.process_appl_periods';

4090: l_approved varchar2(1);
4091: l_not_notified varchar2(1);
4092: l_item_key wf_items.item_key%type;
4093: l_process_name varchar2(30);
4094: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.process_appl_periods';
4095: l_last_updated_by number;
4096:
4097: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
4098: l_time_category_id hxc_time_categories.time_category_id%TYPE;

Line 4550: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.process_appl_periods',

4546: --
4547: hr_utility.trace('IN EXCEPTION IN process_appl_periods');
4548: end if;
4549: --
4550: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.process_appl_periods',
4551: itemtype, itemkey, to_char(actid), funcmode);
4552: raise;
4553: result := '';
4554: return;

Line 4643: l_proc varchar2(70) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';

4639: ,p_tc_resubmitted IN varchar2
4640: ,p_bb_new IN varchar2
4641: )is
4642:
4643: l_proc varchar2(70) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';
4644: l_defer FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%type;
4645:
4646: Begin
4647: --

Line 4738: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';

4734: -- l_process_name varchar2(30);
4735: --
4736: l_process_name wf_process_activities.process_name%type;
4737: --
4738: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';
4739: --
4740: BEGIN
4741: g_debug:=hr_utility.debug_enabled;
4742: --

Line 4877: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.upd_apr_details';

4873: --
4874: l_time_attribute_id number;
4875: l_ovn number;
4876: --
4877: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.upd_apr_details';
4878: --
4879: BEGIN
4880: g_debug:=hr_utility.debug_enabled;
4881: --

Line 5035: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.is_appr_required';

5031: l_token_table hxc_deposit_wrapper_utilities.t_simple_table;
5032: l_exception varchar2(10000);
5033: l_approval_component_id number;
5034: --
5035: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.is_appr_required';
5036:
5037: --
5038: BEGIN
5039: g_debug:=hr_utility.debug_enabled;

Line 5313: 'hxc_approval_wf_pkg.is_appr_required',

5309: hr_utility.trace('IN EXCEPTION IN is_appr_required');
5310: --
5311: end if;
5312: wf_core.context('HCAPPRWF',
5313: 'hxc_approval_wf_pkg.is_appr_required',
5314: itemtype, itemkey, to_char(actid), funcmode);
5315: raise;
5316: result := '';
5317: return;

Line 5379: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_appr_rules';

5375: -- l_item_key wf_items.item_key%type;
5376: l_current_rule varchar2(1000);
5377: l_all_rules varchar2(1000);
5378: --
5379: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_appr_rules';
5380: --
5381: BEGIN
5382: g_debug:=hr_utility.debug_enabled;
5383: --

Line 5526: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.chk_appr_rules',

5522: --
5523: hr_utility.trace('IN EXCEPTION IN chk_appr_rules');
5524: --
5525: end if;
5526: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.chk_appr_rules',
5527: itemtype, itemkey, to_char(actid), funcmode);
5528: raise;
5529: result := '';
5530: return;

Line 5551: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.find_approval_rule';

5547: l_app_bld_blk_id number;
5548: l_app_ovn number;
5549: l_cnt number;
5550: -- l_item_key wf_items.item_key%type;
5551: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.find_approval_rule';
5552: --
5553: BEGIN
5554: g_debug:=hr_utility.debug_enabled;
5555: --

Line 5658: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.find_approval_rule',

5654: --
5655: hr_utility.trace('IN EXCEPTION IN find_approval_rule');
5656: --
5657: end if;
5658: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.find_approval_rule',
5659: itemtype, itemkey, to_char(actid), funcmode);
5660: raise;
5661: result := '';
5662: return;

Line 5839: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.execute_appr_rule';

5835: l_bb_new varchar2(10);
5836: l_appl_period_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
5837: l_appl_period_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
5838: -- l_item_key wf_items.item_key%type;
5839: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.execute_appr_rule';
5840: --
5841: BEGIN
5842: g_debug:=hr_utility.debug_enabled;
5843: --

Line 6219: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.execute_appr_rule',

6215: --
6216: hr_utility.trace('IN EXCEPTION IN execute_appr_rule');
6217: end if;
6218: --
6219: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.execute_appr_rule',
6220: itemtype, itemkey, to_char(actid), funcmode);
6221: raise;
6222: result := '';
6223: return;

Line 6243: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_approval_req';

6239: l_to_approve varchar2(1000);
6240: --
6241: l_cnt number;
6242: -- l_item_key wf_items.item_key%type;
6243: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_approval_req';
6244: --
6245: BEGIN
6246: g_debug:=hr_utility.debug_enabled;
6247: --

Line 6297: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.chk_approval_req',

6293: --
6294: hr_utility.trace('IN EXCEPTION IN chk_approval_req');
6295: end if;
6296: --
6297: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.chk_approval_req',
6298: itemtype, itemkey, to_char(actid), funcmode);
6299: raise;
6300: --
6301: result := '';

Line 6385: end hxc_approval_wf_pkg;

6381:
6382: end is_different_time_category;
6383: --
6384: --
6385: end hxc_approval_wf_pkg;