1 Package pqh_budget_pools_swi AUTHID CURRENT_USER As
2 /* $Header: pqbplswi.pkh 115.1 2003/03/03 12:16:03 ggnanagu noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_reallocation_folder >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_budget_pools_api.create_reallocation_folder
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_reallocation_folder
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_folder_id out nocopy number
30 ,p_name in varchar2
31 ,p_budget_version_id in number
32 ,p_budget_unit_id in number
33 ,p_entity_type in varchar2
34 ,p_approval_status in varchar2
35 ,p_object_version_number out nocopy number
36 ,p_business_group_id in number
37 ,p_wf_transaction_category_id in number
38 ,p_return_status out nocopy varchar2
39 );
40 -- ----------------------------------------------------------------------------
41 -- |------------------------< create_reallocation_txn >-----------------------|
42 -- ----------------------------------------------------------------------------
43 -- {Start of comments}
44 --
45 -- Description:
46 -- This procedure is the self-service wrapper procedure to the following
47 -- API: pqh_budget_pools_api.create_reallocation_txn
48 --
49 -- Pre-requisites
50 -- All 'IN' parameters to this procedure have been appropriately derived.
51 --
52 -- Post Success:
53 -- p_return_status will return value indicating success.
54 --
55 -- Post Failure:
56 -- p_return_status will return value indication failure.
57 --
58 -- Access Status:
59 -- Internal Development use only.
60 --
61 -- {End of comments}
62 -- ----------------------------------------------------------------------------
63 PROCEDURE create_reallocation_txn
64 (p_validate in number default hr_api.g_false_num
65 ,p_effective_date in date
66 ,p_transaction_id out nocopy number
67 ,p_name in varchar2
68 ,p_parent_folder_id in number
69 ,p_object_version_number out nocopy number
70 ,p_business_group_id in number
71 ,p_return_status out nocopy varchar2
72 );
73 -- ----------------------------------------------------------------------------
74 -- |----------------------< delete_reallocation_folder >----------------------|
75 -- ----------------------------------------------------------------------------
76 -- {Start of comments}
77 --
78 -- Description:
79 -- This procedure is the self-service wrapper procedure to the following
80 -- API: pqh_budget_pools_api.delete_reallocation_folder
81 --
82 -- Pre-requisites
83 -- All 'IN' parameters to this procedure have been appropriately derived.
84 --
85 -- Post Success:
86 -- p_return_status will return value indicating success.
87 --
88 -- Post Failure:
89 -- p_return_status will return value indication failure.
90 --
91 -- Access Status:
92 -- Internal Development use only.
93 --
94 -- {End of comments}
95 -- ----------------------------------------------------------------------------
96 PROCEDURE delete_reallocation_folder
97 (p_validate in number default hr_api.g_false_num
98 ,p_folder_id in number
99 ,p_object_version_number in number
100 ,p_effective_date in date
101 ,p_return_status out nocopy varchar2
102 );
103 -- ----------------------------------------------------------------------------
104 -- |------------------------< delete_reallocation_txn >-----------------------|
105 -- ----------------------------------------------------------------------------
106 -- {Start of comments}
107 --
108 -- Description:
109 -- This procedure is the self-service wrapper procedure to the following
110 -- API: pqh_budget_pools_api.delete_reallocation_txn
111 --
112 -- Pre-requisites
113 -- All 'IN' parameters to this procedure have been appropriately derived.
114 --
115 -- Post Success:
116 -- p_return_status will return value indicating success.
117 --
118 -- Post Failure:
119 -- p_return_status will return value indication failure.
120 --
121 -- Access Status:
122 -- Internal Development use only.
123 --
124 -- {End of comments}
125 -- ----------------------------------------------------------------------------
126 PROCEDURE delete_reallocation_txn
127 (p_validate in number default hr_api.g_false_num
128 ,p_transaction_id in number
129 ,p_object_version_number in number
130 ,p_effective_date in date
131 ,p_return_status out nocopy varchar2
132 );
133 -- ----------------------------------------------------------------------------
134 -- |----------------------< update_reallocation_folder >----------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start of comments}
137 --
138 -- Description:
139 -- This procedure is the self-service wrapper procedure to the following
140 -- API: pqh_budget_pools_api.update_reallocation_folder
141 --
142 -- Pre-requisites
143 -- All 'IN' parameters to this procedure have been appropriately derived.
144 --
145 -- Post Success:
146 -- p_return_status will return value indicating success.
147 --
148 -- Post Failure:
149 -- p_return_status will return value indication failure.
150 --
151 -- Access Status:
152 -- Internal Development use only.
153 --
154 -- {End of comments}
155 -- ----------------------------------------------------------------------------
156 PROCEDURE update_reallocation_folder
157 (p_validate in number default hr_api.g_false_num
158 ,p_effective_date in date
159 ,p_folder_id in number
160 ,p_name in varchar2 default hr_api.g_varchar2
161 ,p_budget_version_id in number default hr_api.g_number
162 ,p_budget_unit_id in number default hr_api.g_number
163 ,p_entity_type in varchar2 default hr_api.g_varchar2
164 ,p_approval_status in varchar2 default hr_api.g_varchar2
165 ,p_object_version_number in out nocopy number
166 ,p_business_group_id in number
167 ,p_wf_transaction_category_id in number
168 ,p_return_status out nocopy varchar2
169 );
170 -- ----------------------------------------------------------------------------
171 -- |------------------------< update_reallocation_txn >-----------------------|
172 -- ----------------------------------------------------------------------------
173 -- {Start of comments}
174 --
175 -- Description:
176 -- This procedure is the self-service wrapper procedure to the following
177 -- API: pqh_budget_pools_api.update_reallocation_txn
178 --
179 -- Pre-requisites
180 -- All 'IN' parameters to this procedure have been appropriately derived.
181 --
182 -- Post Success:
183 -- p_return_status will return value indicating success.
184 --
185 -- Post Failure:
186 -- p_return_status will return value indication failure.
187 --
188 -- Access Status:
189 -- Internal Development use only.
190 --
191 -- {End of comments}
192 -- ----------------------------------------------------------------------------
193 PROCEDURE update_reallocation_txn
194 (p_validate in number default hr_api.g_false_num
195 ,p_effective_date in date
196 ,p_transaction_id in number
197 ,p_name in varchar2 default hr_api.g_varchar2
198 ,p_parent_folder_id in number default hr_api.g_number
199 ,p_object_version_number in out nocopy number
200 ,p_business_group_id in number default hr_api.g_number
201 ,p_return_status out nocopy varchar2
202 );
203 -- ----------------------------------------------------------------------------
204 -- |--------------------------< bgt_realloc_delete >-------------------------|
205 -- ----------------------------------------------------------------------------
206 -- {Start of comments}
207 --
208 -- Description:
209 -- This procedure deletes data for a given node_type and node_id
210 --
211 -- Pre-requisites
212 --
213 --
214 -- Post Success:
215 --
216 --
217 -- Post Failure:
218 --
219 --
220 -- Access Status:
221 --
222 --
223 -- {End of comments}
224 -- ----------------------------------------------------------------------------
225 PROCEDURE bgt_realloc_delete(p_node_type in varchar2, p_node_id in number);
226 end pqh_budget_pools_swi;