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.29.12010000.2 2008/08/12 06:03:08 bbayragi ship $ */
3: --
4: -- Possible Notification Status Constants.
5: --

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

458: l_block_index NUMBER;
459: l_count number := 0;
460: l_same boolean := true;
461:
462: l_proc varchar2(50) := 'HXC_APPROVAL_WF_PKG.changed';
463: BEGIN
464: g_debug:=hr_utility.debug_enabled;
465: if g_debug then
466: hr_utility.set_location(l_proc, 10);

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

945: l_approver_comment hxc_time_building_blocks.comment_text%TYPE;
946: l_creation_date hxc_time_building_blocks.creation_date%TYPE;
947: l_wf_item_type varchar2(500) := NULL;
948: l_is_blank varchar2(10);
949: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.update_appl_period';
950:
951:
952: BEGIN
953: g_debug:=hr_utility.debug_enabled;

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

1162: hr_utility.set_location(l_proc, 999);
1163: hr_utility.trace('IN EXCEPTION IN update_appl_period');
1164: end if;
1165: --
1166: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.update_appl_period',
1167: itemtype, itemkey, to_char(actid), funcmode);
1168: raise;
1169: result := '';
1170: return;

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

1414: --
1415: hr_utility.trace('IN EXCEPTION IN create_next_period');
1416: --
1417: end if;
1418: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.create_next_period',
1419: itemtype, itemkey, to_char(actid), funcmode);
1420: raise;
1421: result := '';
1422: return;

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

2466: AND timecard.date_to = hr_general.end_of_time
2467: ORDER BY day1.start_time desc;
2468: --
2469: l_approval_style_id number;
2470: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.get_approval_style_id';
2471: --
2472: BEGIN
2473: --
2474: if g_debug then

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

2625: l_exists varchar2(1);
2626: l_chk_days varchar2(1);
2627: l_item_key wf_items.item_key%type;
2628: l_process_name varchar2(30);
2629: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.create_appl_period_info';
2630:
2631: --
2632: l_detail_blocks block_table;
2633: l_detail_attributes hxc_self_service_time_deposit.building_block_attribute_info;

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

3157: --
3158: hr_utility.trace('IN EXCEPTION IN create_appl_period_info');
3159: --
3160: end if;
3161: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.create_appl_period_info',
3162: itemtype, itemkey, to_char(actid), funcmode, g_trace);
3163:
3164: raise;
3165: result := '';

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

3220: l_days number := p_period_end_date - p_period_start_date + 1;
3221: l_date date;
3222: l_approved varchar2(1);
3223: l_approval_status varchar2(30);
3224: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_app_approved';
3225:
3226: BEGIN
3227:
3228: if g_debug then

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

3340:
3341:
3342: l_assignment_periods hxc_timecard_utilities.periods;
3343: l_day DATE;
3344: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_submitted_days';
3345: --
3346: BEGIN
3347: --
3348: if g_debug then

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

3458: l_approved varchar2(1);
3459: l_not_notified varchar2(1);
3460: l_item_key wf_items.item_key%type;
3461: l_process_name varchar2(30);
3462: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.process_appl_periods';
3463: l_last_updated_by number;
3464: l_process varchar2(1) := 'Y';
3465:
3466: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;

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

3894: --
3895: hr_utility.trace('IN EXCEPTION IN process_appl_periods');
3896: end if;
3897: --
3898: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.process_appl_periods',
3899: itemtype, itemkey, to_char(actid), funcmode);
3900: raise;
3901: result := '';
3902: return;

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

3987: ,p_tc_resubmitted IN varchar2
3988: ,p_bb_new IN varchar2
3989: )is
3990:
3991: l_proc varchar2(70) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';
3992: l_defer FND_PROFILE_OPTION_VALUES.PROFILE_OPTION_VALUE%type;
3993:
3994: Begin
3995: --

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

4082: -- l_process_name varchar2(30);
4083: --
4084: l_process_name wf_process_activities.process_name%type;
4085: --
4086: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.start_approval_wf_process';
4087: --
4088: BEGIN
4089: g_debug:=hr_utility.debug_enabled;
4090: --

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

4221: --
4222: l_time_attribute_id number;
4223: l_ovn number;
4224: --
4225: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.upd_apr_details';
4226: --
4227: BEGIN
4228: g_debug:=hr_utility.debug_enabled;
4229: --

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

4344: l_token_table hxc_deposit_wrapper_utilities.t_simple_table;
4345: l_exception varchar2(10000);
4346: l_approval_component_id number;
4347: --
4348: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.is_appr_required';
4349:
4350: --
4351: BEGIN
4352: g_debug:=hr_utility.debug_enabled;

Line 4626: 'hxc_approval_wf_pkg.is_appr_required',

4622: hr_utility.trace('IN EXCEPTION IN is_appr_required');
4623: --
4624: end if;
4625: wf_core.context('HCAPPRWF',
4626: 'hxc_approval_wf_pkg.is_appr_required',
4627: itemtype, itemkey, to_char(actid), funcmode);
4628: raise;
4629: result := '';
4630: return;

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

4688: -- l_item_key wf_items.item_key%type;
4689: l_current_rule varchar2(1000);
4690: l_all_rules varchar2(1000);
4691: --
4692: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_appr_rules';
4693: --
4694: BEGIN
4695: g_debug:=hr_utility.debug_enabled;
4696: --

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

4835: --
4836: hr_utility.trace('IN EXCEPTION IN chk_appr_rules');
4837: --
4838: end if;
4839: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.chk_appr_rules',
4840: itemtype, itemkey, to_char(actid), funcmode);
4841: raise;
4842: result := '';
4843: return;

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

4860: l_app_bld_blk_id number;
4861: l_app_ovn number;
4862: l_cnt number;
4863: -- l_item_key wf_items.item_key%type;
4864: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.find_approval_rule';
4865: --
4866: BEGIN
4867: g_debug:=hr_utility.debug_enabled;
4868: --

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

4967: --
4968: hr_utility.trace('IN EXCEPTION IN find_approval_rule');
4969: --
4970: end if;
4971: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.find_approval_rule',
4972: itemtype, itemkey, to_char(actid), funcmode);
4973: raise;
4974: result := '';
4975: return;

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

5148: l_bb_new varchar2(10);
5149: l_appl_period_bb_id hxc_time_building_blocks.time_building_block_id%TYPE;
5150: l_appl_period_bb_ovn hxc_time_building_blocks.object_version_number%TYPE;
5151: -- l_item_key wf_items.item_key%type;
5152: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.execute_appr_rule';
5153: --
5154: BEGIN
5155: g_debug:=hr_utility.debug_enabled;
5156: --

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

5528: --
5529: hr_utility.trace('IN EXCEPTION IN execute_appr_rule');
5530: end if;
5531: --
5532: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.execute_appr_rule',
5533: itemtype, itemkey, to_char(actid), funcmode);
5534: raise;
5535: result := '';
5536: return;

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

5552: l_to_approve varchar2(1000);
5553: --
5554: l_cnt number;
5555: -- l_item_key wf_items.item_key%type;
5556: l_proc varchar2(100) := 'HXC_APPROVAL_WF_PKG.chk_approval_req';
5557: --
5558: BEGIN
5559: g_debug:=hr_utility.debug_enabled;
5560: --

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

5606: --
5607: hr_utility.trace('IN EXCEPTION IN chk_approval_req');
5608: end if;
5609: --
5610: wf_core.context('HCAPPRWF', 'hxc_approval_wf_pkg.chk_approval_req',
5611: itemtype, itemkey, to_char(actid), funcmode);
5612: raise;
5613: --
5614: result := '';

Line 5693: end hxc_approval_wf_pkg;

5689:
5690: end is_different_time_category;
5691: --
5692: --
5693: end hxc_approval_wf_pkg;