1 PACKAGE hxc_find_notify_aprs_pkg as
2 /* $Header: hxcafnawf.pkh 120.6.12010000.1 2008/07/28 11:02:16 appldev 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 procedure formula_selects_mechanism(
88 p_itemtype in varchar2,
89 p_itemkey in varchar2,
90 p_actid in number,
91 p_funcmode in varchar2,
92 p_result in out nocopy varchar2);
93
94 procedure launch_wf_process(
95 p_itemtype in varchar2,
96 p_itemkey in varchar2,
97 p_actid in number,
98 p_funcmode in varchar2,
99 p_result in out nocopy varchar2);
100
101 procedure test_wf_result(
102 p_itemtype in varchar2,
103 p_itemkey in varchar2,
104 p_actid in number,
105 p_funcmode in varchar2,
106 p_result in out nocopy varchar2);
107
108 procedure set_next_app_period(
109 p_itemtype in varchar2,
110 p_itemkey in varchar2,
111 p_actid in number,
112 p_funcmode in varchar2,
113 p_result in out nocopy varchar2);
114
115
116
117 procedure cancel_previous_notifications
118 (p_app_bb_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
119 ,p_app_bb_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
120 );
121
122 -- Bug 3390666 ,3855544
123 function get_login(
124 p_person_id in number,
125 p_user_id IN NUMBER DEFAULT NULL)
126 return varchar2;
127
128 PROCEDURE cancel_previous_notifications(
129 p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
130 );
131
132 PROCEDURE find_project_manager(
133 p_itemtype in varchar2,
134 p_itemkey in varchar2,
135 p_actid in number,
136 p_funcmode in varchar2,
137 p_result in out nocopy varchar2
138 );
139
140 function validate_person(
141 p_person_id in number,
142 p_effective_date in date)
143 return boolean;
144
145 procedure cancel_notifications(
146 p_app_bb_id IN NUMBER,
147 p_archived IN VARCHAR DEFAULT NULL);
148
149 -- Added as part of OIT
150
151 FUNCTION category_timecard_hrs (
152 p_app_per_id IN NUMBER
153 , p_time_category_name IN VARCHAR2 )
154 RETURN NUMBER;
155
156 FUNCTION category_timecard_hrs (
157 p_start_date IN date,
158 p_end_date IN date,
159 p_resource_id IN NUMBER,
160 p_time_category_name IN VARCHAR2 )
161 RETURN NUMBER;
162 function get_supervisor(
163 p_person_id in number,
164 p_effective_date in date)
165 return number;
166
167 function get_name(
168 p_person_id in number,
169 p_effective_date in DATE)
170 return varchar2;
171
172 FUNCTION apply_round_rule(p_rounding_rule in varchar2,
173 p_decimal_precision in varchar2,
174 p_value in number)
175 return number;
176
177 end hxc_find_notify_aprs_pkg;