1 Package HXC_APPROVAL_WF_HELPER AUTHID CURRENT_USER as
2 /* $Header: hxcaprwfhelper.pkh 120.0.12010000.2 2008/08/05 12:00:40 ubhat ship $ */
3
4 C_ACTION_CODE_ATTRIBUTE constant varchar2(25) := 'NOTIFICATION_ACTION_CODE';
5
6 C_RECIPIENT_CODE_ATTRIBUTE constant varchar2(30) :='NOTIFICATION_RECIPIENT_CODE';
7
8 TYPE t_time_building_block_id IS TABLE OF hxc_transaction_details.time_building_block_id%TYPE INDEX BY BINARY_INTEGER;
9 TYPE t_time_building_block_ovn IS TABLE OF hxc_transaction_details.time_building_block_ovn%TYPE INDEX BY BINARY_INTEGER;
10
11
12 procedure prepare_notification(
13 itemtype IN varchar2,
14 itemkey IN varchar2,
15 actid IN number,
16 funcmode IN varchar2,
17 result IN OUT NOCOPY varchar2);
18
19 Procedure set_notif_attribute_values
20 (p_item_type in wf_items.item_type%type,
21 p_item_key in wf_item_activity_statuses.item_key%type,
22 p_notif_action_code in wf_item_attribute_values.text_value%type,
23 p_notif_recipient_code in wf_item_attribute_values.text_value%type);
24
25
26 Procedure get_notif_attribute_values
27 (p_item_type in wf_items.item_type%type,
28 p_item_key in wf_item_activity_statuses.item_key%type,
29 p_app_bb_id in number,
30 p_notif_action_code out nocopy varchar2,
31 p_notif_recipient_code out nocopy varchar2,
32 p_approval_comp_id out nocopy number,
33 p_can_notify out nocopy boolean);
34
35 Function is_approver_supervisor
36 (p_approver_resource_id in number,
37 p_resource_id in number)
38 Return Boolean;
39
40 Function find_preparer_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
41 ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
42 return wf_local_roles.name%type;
43
44 Function item_attribute_value_exists
45 (p_item_type in wf_items.item_type%type,
46 p_item_key in wf_item_activity_statuses.item_key%type,
47 p_name in wf_item_attribute_values.name%type)
48 return boolean;
49
50 Function find_role_for_recipient
51 (p_recipient_code in wf_item_attribute_values.text_value%type,
52 p_timecard_id in number,
53 p_timecard_ovn in number)
54 Return wf_local_roles.name%type;
55
56 procedure cleanup(itemtype IN varchar2,
57 itemkey IN varchar2,
58 actid IN number,
59 funcmode IN varchar2,
60 result IN OUT NOCOPY varchar2);
61
62 function find_full_name_from_role(p_role_name in wf_local_roles.name%type,
63 p_effective_date in date)
64 return varchar2;
65
66 end hxc_approval_wf_helper;