1 PACKAGE hxc_approval_wf_pkg AUTHID CURRENT_USER AS
2 /* $Header: hxcapprwf.pkh 120.4.12020000.1 2012/06/28 05:06:29 appldev ship $ */
3 --
4 --
5 -- global PL/SQL records and tables
6 --
7 g_source_name VARCHAR2(100) := 'OTL Timecard';
8 g_process_name VARCHAR2(100) := 'OTL Deposit Process';
9 g_resource_type VARCHAR2(100) := 'PERSON';
10 g_template_start DATE := to_date('01/01/1900','DD/MM/YYYY');
11 g_package VARCHAR2(33) := 'HXC_APPROVAL_WF_PKG.'; -- Global package name
12
13 g_error_table hxc_self_service_time_deposit.message_table;
14 g_error_count NUMBER := 0;
15
16 g_time_building_blocks hxc_self_service_time_deposit.timecard_info;
17 g_time_attributes hxc_self_service_time_deposit.building_block_attribute_info;
18 g_time_app_attributes hxc_self_service_time_deposit.app_attributes_info;
19
20 --
21 --
22 -- This overloaded of start_approval_wf_process added by A.Rundell
23 -- 2003/01/03 for the second generation deposit wrapper.
24 -- (hxcapprwf.pkh 115.16)
25 --
26 PROCEDURE start_approval_wf_process
27 (p_item_type IN varchar2
28 ,p_item_key IN varchar2
29 ,p_process_name IN varchar2
30 ,p_tc_bb_id IN number
31 ,p_tc_ovn IN number
32 ,p_tc_resubmitted IN varchar2
33 ,p_bb_new IN varchar2
34 );
35 --
36 PROCEDURE start_approval_wf_process
37 (p_item_type IN varchar2
38 ,p_item_key IN varchar2
39 ,p_tc_bb_id IN number
40 ,p_tc_ovn IN number
41 ,p_tc_resubmitted IN varchar2
42 ,p_error_table OUT NOCOPY hxc_self_service_time_deposit.message_table
43 ,p_time_building_blocks IN hxc_self_service_time_deposit.timecard_info
44 ,p_time_attributes IN hxc_self_service_time_deposit.building_block_attribute_info
45 ,p_bb_new IN varchar2
46 );
47 --
48 PROCEDURE create_appl_period_info
49 (itemtype IN varchar2
50 ,itemkey IN varchar2
51 ,actid IN number
52 ,funcmode IN varchar2
53 ,result IN OUT NOCOPY varchar2
54 );
55 --
56 PROCEDURE process_appl_periods(itemtype IN varchar2,
57 itemkey IN varchar2,
58 actid IN number,
59 funcmode IN varchar2,
60 result IN OUT NOCOPY varchar2);
61
62 --
63 PROCEDURE is_appr_required
64 (itemtype IN varchar2
65 ,itemkey IN varchar2
66 ,actid IN number
67 ,funcmode IN varchar2
68 ,result IN OUT NOCOPY varchar2
69 );
70 --
71 PROCEDURE chk_appr_rules
72 (itemtype IN varchar2
73 ,itemkey IN varchar2
74 ,actid IN number
75 ,funcmode IN varchar2
76 ,result IN OUT NOCOPY varchar2
77 );
78 --
79 PROCEDURE find_approval_rule
80 (itemtype IN varchar2
81 ,itemkey IN varchar2
82 ,actid IN number
83 ,funcmode IN varchar2
84 ,result IN OUT NOCOPY varchar2
85 );
86 --
87 PROCEDURE execute_appr_rule
88 (itemtype IN varchar2
89 ,itemkey IN varchar2
90 ,actid IN number
91 ,funcmode IN varchar2
92 ,result IN OUT NOCOPY varchar2
93 );
94 --
95 PROCEDURE chk_approval_req
96 (itemtype IN varchar2
97 ,itemkey IN varchar2
98 ,actid IN number
99 ,funcmode IN varchar2
100 ,result IN OUT NOCOPY varchar2
101 );
102
103 --
104 PROCEDURE upd_apr_details
105 (p_app_bb_id IN number
106 ,p_app_bb_ovn IN number
107 ,p_approver_id IN number
108 ,p_approved_time IN date
109 ,p_approval_comment IN varchar2
110 ,p_approval_status IN varchar2
111 ,p_delegated_for IN varchar2
112 );
113 --
114 FUNCTION get_override ( p_timecard_bb_id NUMBER
115 , p_timecard_ovn NUMBER ) RETURN NUMBER;
116 --
117 FUNCTION code_chk (p_code IN VARCHAR2) RETURN BOOLEAN;
118
119 PROCEDURE update_app_period(
120 itemtype IN varchar2,
121 itemkey IN varchar2,
122 actid IN number,
123 funcmode IN varchar2,
124 result IN OUT NOCOPY varchar2
125 );
126
127 PROCEDURE create_next_period(
128 itemtype IN varchar2,
129 itemkey IN varchar2,
130 actid IN number,
131 funcmode IN varchar2,
132 result IN OUT NOCOPY varchar2
133 );
134
135
136 Function find_mysterious_approver(
137 p_item_type in wf_items.item_type%type
138 ,p_item_key in wf_item_activity_statuses.item_key%type
139 ) return number;
140
141 --OIT Change
142 FUNCTION get_approval_style_id(p_period_start_date date,
143 p_period_end_date date,
144 p_resource_id number)
145 RETURN NUMBER;
146
147 PROCEDURE is_different_time_category (itemtype IN varchar2,
148 itemkey IN varchar2,
149 actid IN number,
150 funcmode IN varchar2,
151 result IN OUT NOCOPY varchar2);
152
153 FUNCTION item_attribute_exists
154 (p_item_type in wf_items.item_type%type,
155 p_item_key in wf_item_activity_statuses.item_key%type,
156 p_name in wf_item_attribute_values.name%type)
157 RETURN BOOLEAN;
158
159 --
160 end hxc_approval_wf_pkg;