1 PACKAGE hxc_find_notify_aprs_pkg AUTHID CURRENT_USER as
2 /* $Header: hxcafnawf.pkh 120.6.12010000.2 2009/06/15 13:57:14 amakrish ship $ */
3
4 function get_description
5 (p_application_period_id in hxc_app_period_summary.application_period_id%type)
6 return varchar2;
7 function get_description_tc
8 (p_timecard_id in hxc_timecard_summary.timecard_id%type,
9 p_timecard_ovn in hxc_timecard_summary.timecard_ovn%type)
10 return varchar2;
11 function get_description_date
12 (p_start_date in date,
13 p_end_date in date,
14 p_resource_id in number)
15 return varchar2;
16
17 procedure find_apr_style(
18 p_itemtype in varchar2,
19 p_itemkey in varchar2,
20 p_actid in number,
21 p_funcmode in varchar2,
22 p_result in out nocopy varchar2);
23
24 procedure auto_approval(
25 p_itemtype in varchar2,
26 p_itemkey in varchar2,
27 p_actid in number,
28 p_funcmode in varchar2,
29 p_result in out nocopy varchar2);
30
31 procedure person_approval(
32 p_itemtype in varchar2,
33 p_itemkey in varchar2,
34 p_actid in number,
35 p_funcmode in varchar2,
36 p_result in out nocopy varchar2);
37
38 procedure hr_supervisor_approval(
39 p_itemtype in varchar2,
40 p_itemkey in varchar2,
41 p_actid in number,
42 p_funcmode in varchar2,
43 p_result in out nocopy varchar2);
44
45 procedure capture_approved_status(
46 p_itemtype in varchar2,
47 p_itemkey in varchar2,
48 p_actid in number,
49 p_funcmode in varchar2,
50 p_result in out nocopy varchar2);
51
52 procedure capture_rejected_status(
53 p_itemtype in varchar2,
54 p_itemkey in varchar2,
55 p_actid in number,
56 p_funcmode in varchar2,
57 p_result in out nocopy varchar2);
58
59 procedure capture_timeout_status(
60 p_itemtype in varchar2,
61 p_itemkey in varchar2,
62 p_actid in number,
63 p_funcmode in varchar2,
64 p_result in out nocopy varchar2);
65
66 procedure capture_apr_comment(
67 p_itemtype in varchar2,
68 p_itemkey in varchar2,
69 p_actid in number,
70 p_funcmode in varchar2,
71 p_result in out nocopy varchar2);
72
73 procedure capture_reject_comment(
74 p_itemtype in varchar2,
75 p_itemkey in varchar2,
76 p_actid in number,
77 p_funcmode in varchar2,
78 p_result in out nocopy varchar2);
79
80 procedure is_final_apr(
81 p_itemtype in varchar2,
82 p_itemkey in varchar2,
83 p_actid in number,
84 p_funcmode in varchar2,
85 p_result in out nocopy varchar2);
86
87 -- Added for bug 8594271
88 procedure check_user_exists(
89 p_itemtype in varchar2,
90 p_itemkey in varchar2,
91 p_actid in number,
92 p_funcmode in varchar2,
93 p_result in out nocopy varchar2);
94
95
96 procedure formula_selects_mechanism(
97 p_itemtype in varchar2,
98 p_itemkey in varchar2,
99 p_actid in number,
100 p_funcmode in varchar2,
101 p_result in out nocopy varchar2);
102
103 procedure launch_wf_process(
104 p_itemtype in varchar2,
105 p_itemkey in varchar2,
106 p_actid in number,
107 p_funcmode in varchar2,
108 p_result in out nocopy varchar2);
109
110 procedure test_wf_result(
111 p_itemtype in varchar2,
112 p_itemkey in varchar2,
113 p_actid in number,
114 p_funcmode in varchar2,
115 p_result in out nocopy varchar2);
116
117 procedure set_next_app_period(
118 p_itemtype in varchar2,
119 p_itemkey in varchar2,
120 p_actid in number,
121 p_funcmode in varchar2,
122 p_result in out nocopy varchar2);
123
124
125
126 procedure cancel_previous_notifications
127 (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
128 ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
129 );
130
131 -- Bug 3390666 ,3855544
132 function get_login(
133 p_person_id in number,
134 p_user_id IN NUMBER DEFAULT NULL)
135 return varchar2;
136
137 PROCEDURE cancel_previous_notifications(
138 p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
139 );
140
141 PROCEDURE find_project_manager(
142 p_itemtype in varchar2,
143 p_itemkey in varchar2,
144 p_actid in number,
145 p_funcmode in varchar2,
146 p_result in out nocopy varchar2
147 );
148
149 function validate_person(
150 p_person_id in number,
151 p_effective_date in date)
152 return boolean;
153
154 procedure cancel_notifications(
155 p_app_bb_id IN NUMBER,
156 p_archived IN VARCHAR DEFAULT NULL);
157
158 -- Added as part of OIT
159
160 FUNCTION category_timecard_hrs (
161 p_app_per_id IN NUMBER
162 , p_time_category_name IN VARCHAR2 )
163 RETURN NUMBER;
164
165 FUNCTION category_timecard_hrs (
166 p_start_date IN date,
167 p_end_date IN date,
168 p_resource_id IN NUMBER,
169 p_time_category_name IN VARCHAR2 )
170 RETURN NUMBER;
171 function get_supervisor(
172 p_person_id in number,
173 p_effective_date in date)
174 return number;
175
176 function get_name(
177 p_person_id in number,
178 p_effective_date in DATE)
179 return varchar2;
180
181 FUNCTION apply_round_rule(p_rounding_rule in varchar2,
182 p_decimal_precision in varchar2,
183 p_value in number)
184 return number;
185
186 end hxc_find_notify_aprs_pkg;