[Home] [Help]
971: RETURN t_attributes;
972:
973: END get_empty_attribute;
974: Function find_mysterious_approver
975: (p_item_type in wf_items.item_type%type
976: ,p_item_key in wf_item_activity_statuses.item_key%type
977: ) return number is
978:
979: cursor c_find_approver_role
976: ,p_item_key in wf_item_activity_statuses.item_key%type
977: ) return number is
978:
979: cursor c_find_approver_role
980: (itemType in wf_items.item_type%type
981: ,itemKey in wf_item_activity_statuses.item_key%type) is
982: select wlr.orig_system, wlr.orig_system_id
983: from wf_notifications wn, wf_process_activities pa, wf_item_activity_statuses wias, wf_local_roles wlr
984: where pa.activity_name in('TC_APR_NOTIFICATION', 'TC_APR_NOTIFICATION_ABS')
2006:
2007: End create_removed_links;
2008:
2009: FUNCTION item_attribute_exists
2010: (p_item_type in wf_items.item_type%type,
2011: p_item_key in wf_item_activity_statuses.item_key%type,
2012: p_name in wf_item_attribute_values.name%type)
2013: return boolean is
2014:
2405:
2406: -- Added for bug 9076079
2407: select count(*)
2408: into l_item_key_exists
2409: from wf_items
2410: where item_key = to_char(l_item_key)
2411: and item_type = 'HXCEMP'
2412: and rownum < 2;
2413:
2529: If l_item_key is not null then
2530:
2531: select count(*)
2532: into l_item_key_exists
2533: from wf_items
2534: where item_key = to_char(l_item_key)
2535: and item_type = 'HXCEMP'
2536: and rownum < 2;
2537:
2971: l_cnt number;
2972: --
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: --
4088: l_exists varchar2(1);
4089: l_chk_days varchar2(1);
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:
4096:
4097: l_recipient_sequence hxc_approval_comps.approval_order%TYPE;
4098: l_time_category_id hxc_time_categories.time_category_id%TYPE;
4099: l_category_sequence hxc_approval_comps.approval_order%TYPE;
4100: l_approval_item_key wf_items.item_key%type;
4101: l_is_blank varchar2(1) := NULL;
4102: l_process varchar2(1) := 'Y';
4103:
4104: BEGIN
4729: ,p_bb_new IN varchar2)
4730: is
4731: --
4732: --
4733: -- l_item_key wf_items.item_key%type;
4734: -- l_process_name varchar2(30);
4735: --
4736: l_process_name wf_process_activities.process_name%type;
4737: --
5371: l_tc_stop_time date;
5372: l_data_appr_rule_id hxc_time_entry_rules.time_entry_rule_id%type;
5373: --
5374: l_cnt number;
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';
5546: --
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;
5834: l_resubmit varchar2(10);
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;
6238: l_all_rules varchar2(1000);
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;