1 Package pqh_routing_history_api as
2 /* $Header: pqrhtapi.pkh 120.0 2005/05/29 02:29:01 appldev noship $ */
3 --
4 --
5 TYPE t_rha_tab IS TABLE OF pqh_routing_hist_attribs%ROWTYPE
6 INDEX BY BINARY_INTEGER;
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_routing_history >------------------------|
10 -- ----------------------------------------------------------------------------
11 -- {Start Of Comments}
12 --
13 -- Description:
14 --
15 -- Prerequisites:
16 --
17 --
18 -- In Parameters:
19 -- Name Reqd Type Description
20 -- p_validate Yes boolean Commit or Rollback.
21 -- p_approval_cd No varchar2
22 -- p_comments No varchar2
23 -- p_forwarded_by_assignment_id No number
24 -- p_forwarded_by_member_id No number
25 -- p_forwarded_by_position_id No number
26 -- p_forwarded_by_user_id No number
27 -- p_forwarded_by_role_id No number
28 -- p_forwarded_to_assignment_id No number
29 -- p_forwarded_to_member_id No number
30 -- p_forwarded_to_position_id No number
31 -- p_forwarded_to_user_id No number
32 -- p_forwarded_to_role_id No number
33 -- p_notification_date Yes date
34 -- p_pos_structure_version_id No number
35 -- p_routing_category_id Yes number
36 -- p_transaction_category_id Yes number
37 -- p_transaction_id Yes number
38 -- p_user_action_cd Yes varchar2
39 -- p_from_range_name No varchar2
40 -- p_to_range_name No varchar2
41 -- p_list_range_name No varchar2
42 -- p_effective_date Yes date Session Date.
43 --
44 -- Post Success:
45 --
46 -- Out Parameters:
47 -- Name Type Description
48 -- p_routing_history_id Yes number PK of record
49 -- p_object_version_number Yes number OVN of record
50 --
51 -- Post Failure:
52 --
53 -- Access Status:
54 -- Public.
55 --
56 -- {End Of Comments}
57 --
58 procedure create_routing_history
59 (
60 p_validate in boolean default false
61 ,p_routing_history_id out nocopy number
62 ,p_approval_cd in varchar2 default null
63 ,p_comments in varchar2 default null
64 ,p_forwarded_by_assignment_id in number default null
65 ,p_forwarded_by_member_id in number default null
66 ,p_forwarded_by_position_id in number default null
67 ,p_forwarded_by_user_id in number default null
68 ,p_forwarded_by_role_id in number default null
69 ,p_forwarded_to_assignment_id in number default null
70 ,p_forwarded_to_member_id in number default null
71 ,p_forwarded_to_position_id in number default null
72 ,p_forwarded_to_user_id in number default null
73 ,p_forwarded_to_role_id in number default null
74 ,p_notification_date in date default null
75 ,p_pos_structure_version_id in number default null
76 ,p_routing_category_id in number default null
77 ,p_transaction_category_id in number default null
78 ,p_transaction_id in number default null
79 ,p_user_action_cd in varchar2 default null
80 ,p_object_version_number out nocopy number
81 ,p_from_range_name in varchar2 default null
82 ,p_to_range_name in varchar2 default null
83 ,p_list_range_name in varchar2 default null
84 ,p_effective_date in date
85 );
86 -- ----------------------------------------------------------------------------
87 -- |------------------------< update_routing_history >------------------------|
88 -- ----------------------------------------------------------------------------
89 -- {Start Of Comments}
90 --
91 -- Description:
92 --
93 -- Prerequisites:
94 --
95 --
96 -- In Parameters:
97 -- Name Reqd Type Description
98 -- p_validate Yes boolean Commit or Rollback.
99 -- p_routing_history_id Yes number PK of record
100 -- p_approval_cd No varchar2
101 -- p_comments No varchar2
102 -- p_forwarded_by_assignment_id No number
103 -- p_forwarded_by_member_id No number
104 -- p_forwarded_by_position_id No number
105 -- p_forwarded_by_user_id No number
106 -- p_forwarded_by_role_id No number
107 -- p_forwarded_to_assignment_id No number
108 -- p_forwarded_to_member_id No number
109 -- p_forwarded_to_position_id No number
110 -- p_forwarded_to_user_id No number
111 -- p_forwarded_to_role_id No number
112 -- p_notification_date Yes date
113 -- p_pos_structure_version_id No number
114 -- p_routing_category_id Yes number
115 -- p_transaction_category_id Yes number
116 -- p_transaction_id Yes number
117 -- p_user_action_cd Yes varchar2
118 -- p_from_range_name No varchar2
119 -- p_to_range_name No varchar2
120 -- p_list_range_name No varchar2
121 -- p_effective_date Yes date Session Date.
122 --
123 -- Post Success:
124 --
125 -- Name Type Description
126 -- p_object_version_number Yes number OVN of record
127 --
128 -- Post Failure:
129 --
130 -- Access Status:
131 -- Public.
132 --
133 -- {End Of Comments}
134 --
135 procedure update_routing_history
136 (
137 p_validate in boolean default false
138 ,p_routing_history_id in number
139 ,p_approval_cd in varchar2 default hr_api.g_varchar2
140 ,p_comments in varchar2 default hr_api.g_varchar2
141 ,p_forwarded_by_assignment_id in number default hr_api.g_number
142 ,p_forwarded_by_member_id in number default hr_api.g_number
143 ,p_forwarded_by_position_id in number default hr_api.g_number
144 ,p_forwarded_by_user_id in number default hr_api.g_number
145 ,p_forwarded_by_role_id in number default hr_api.g_number
146 ,p_forwarded_to_assignment_id in number default hr_api.g_number
147 ,p_forwarded_to_member_id in number default hr_api.g_number
148 ,p_forwarded_to_position_id in number default hr_api.g_number
149 ,p_forwarded_to_user_id in number default hr_api.g_number
150 ,p_forwarded_to_role_id in number default hr_api.g_number
151 ,p_notification_date in date default hr_api.g_date
152 ,p_pos_structure_version_id in number default hr_api.g_number
153 ,p_routing_category_id in number default hr_api.g_number
154 ,p_transaction_category_id in number default hr_api.g_number
155 ,p_transaction_id in number default hr_api.g_number
156 ,p_user_action_cd in varchar2 default hr_api.g_varchar2
157 ,p_object_version_number in out nocopy number
158 ,p_from_range_name in varchar2 default hr_api.g_varchar2
159 ,p_to_range_name in varchar2 default hr_api.g_varchar2
160 ,p_list_range_name in varchar2 default hr_api.g_varchar2
161 ,p_effective_date in date
162 );
163 --
164 -- ----------------------------------------------------------------------------
165 -- |------------------------< delete_routing_history >------------------------|
166 -- ----------------------------------------------------------------------------
167 -- {Start Of Comments}
168 --
169 -- Description:
170 --
171 -- Prerequisites:
172 --
173 --
174 -- In Parameters:
175 -- Name Reqd Type Description
176 -- p_validate Yes boolean Commit or Rollback.
177 -- p_routing_history_id Yes number PK of record
178 -- p_effective_date Yes date Session Date.
179 --
180 -- Post Success:
181 --
182 -- Name Type Description
183 -- p_object_version_number Yes number OVN of record
184 --
185 -- Post Failure:
186 --
187 -- Access Status:
188 -- Public.
189 --
190 -- {End Of Comments}
191 --
192 procedure delete_routing_history
193 (
194 p_validate in boolean default false
195 ,p_routing_history_id in number
196 ,p_object_version_number in out nocopy number
197 ,p_effective_date in date
198 );
199 --
200 -- ----------------------------------------------------------------------------
201 -- ----------------------------------------------------------------------------
202 -- ----------------------------------------------------------------------------
203 procedure create_routing_history_bp
204 (
205 p_validate in boolean default false
206 ,p_routing_history_id out nocopy number
207 ,p_approval_cd in varchar2 default null
208 ,p_comments in varchar2 default null
209 ,p_forwarded_by_assignment_id in number default null
210 ,p_forwarded_by_member_id in number default null
211 ,p_forwarded_by_position_id in number default null
212 ,p_forwarded_by_user_id in number default null
213 ,p_forwarded_by_role_id in number default null
214 ,p_forwarded_to_assignment_id in number default null
215 ,p_forwarded_to_member_id in number default null
216 ,p_forwarded_to_position_id in number default null
217 ,p_forwarded_to_user_id in number default null
218 ,p_forwarded_to_role_id in number default null
219 ,p_notification_date in date default null
220 ,p_pos_structure_version_id in number default null
221 ,p_routing_category_id in number default null
222 ,p_transaction_category_id in number default null
223 ,p_transaction_id in number default null
224 ,p_user_action_cd in varchar2 default null
225 ,p_object_version_number out nocopy number
226 ,p_from_range_name in varchar2 default null
227 ,p_to_range_name in varchar2 default null
228 ,p_list_range_name in varchar2 default null
229 ,p_effective_date in date
230 ,p_rha_tab in t_rha_tab
231 );
232
233
234 --
235 end pqh_routing_history_api;