APPS.HXC_APPROVAL_WF_PKG dependencies on WF_ITEMS

Line 823: (p_item_type in wf_items.item_type%type

819: RETURN t_attributes;
820:
821: END get_empty_attribute;
822: Function find_mysterious_approver
823: (p_item_type in wf_items.item_type%type
824: ,p_item_key in wf_item_activity_statuses.item_key%type
825: ) return number is
826:
827: cursor c_find_approver_role

Line 828: (itemType in wf_items.item_type%type

824: ,p_item_key in wf_item_activity_statuses.item_key%type
825: ) return number is
826:
827: cursor c_find_approver_role
828: (itemType in wf_items.item_type%type
829: ,itemKey in wf_item_activity_statuses.item_key%type) is
830: select wlr.orig_system, wlr.orig_system_id
831: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
832: where pa.activity_name = 'TC_APR_NOTIFICATION'

Line 1831: (p_item_type in wf_items.item_type%type,

1827:
1828: End create_removed_links;
1829:
1830: FUNCTION item_attribute_exists
1831: (p_item_type in wf_items.item_type%type,
1832: p_item_key in wf_item_activity_statuses.item_key%type,
1833: p_name in wf_item_attribute_values.name%type)
1834: return boolean is
1835:

Line 2627: l_item_key wf_items.item_key%type;

2623: l_cnt number;
2624: --
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: --

Line 3460: l_item_key wf_items.item_key%type;

3456: l_exists varchar2(1);
3457: l_chk_days varchar2(1);
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';

Line 3469: l_approval_item_key wf_items.item_key%type;

3465:
3466: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
3467: l_time_category_id hxc_time_categories.time_category_id%TYPE;
3468: l_category_sequence hxc_approval_comps.approval_order%TYPE;
3469: l_approval_item_key wf_items.item_key%type;
3470: l_is_blank varchar2(1) := NULL;
3471:
3472: BEGIN
3473: l_approval_item_key := null;

Line 4081: -- l_item_key wf_items.item_key%type;

4077: ,p_bb_new IN varchar2)
4078: is
4079: --
4080: --
4081: -- l_item_key wf_items.item_key%type;
4082: -- l_process_name varchar2(30);
4083: --
4084: l_process_name wf_process_activities.process_name%type;
4085: --

Line 4688: -- l_item_key wf_items.item_key%type;

4684: l_tc_stop_time date;
4685: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
4686: --
4687: l_cnt number;
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';

Line 4863: -- l_item_key wf_items.item_key%type;

4859: --
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;

Line 5151: -- l_item_key wf_items.item_key%type;

5147: l_resubmit varchar2(10);
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;

Line 5555: -- l_item_key wf_items.item_key%type;

5551: l_all_rules varchar2(1000);
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;