1 Package pqh_bdgt_pool_realloctions_swi AUTHID CURRENT_USER As
2 /* $Header: pqbreswi.pkh 115.0 2003/02/06 15:20:03 kgowripe noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_realloc_txn_dtl >------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqh_bdgt_pool_realloctions_api.create_realloc_txn_dtl
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_realloc_txn_dtl
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_transaction_id in number
30 ,p_transaction_type in varchar2
31 ,p_entity_id in number default null
32 ,p_budget_detail_id in number default null
33 ,p_txn_detail_id out nocopy number
34 ,p_object_version_number out nocopy number
35 ,p_return_status out nocopy varchar2
36 );
37 -- ----------------------------------------------------------------------------
38 -- |-----------------------< create_realloc_txn_period >----------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start of comments}
41 --
42 -- Description:
43 -- This procedure is the self-service wrapper procedure to the following
44 -- API: pqh_bdgt_pool_realloctions_api.create_realloc_txn_period
45 --
46 -- Pre-requisites
47 -- All 'IN' parameters to this procedure have been appropriately derived.
48 --
49 -- Post Success:
50 -- p_return_status will return value indicating success.
51 --
52 -- Post Failure:
53 -- p_return_status will return value indication failure.
54 --
55 -- Access Status:
56 -- Internal Development use only.
57 --
58 -- {End of comments}
59 -- ----------------------------------------------------------------------------
60 PROCEDURE create_realloc_txn_period
61 (p_validate in number default hr_api.g_false_num
62 ,p_effective_date in date
63 ,p_txn_detail_id in number
64 ,p_transaction_type in varchar2
65 ,p_entity_id in number default null
66 ,p_budget_period_id in number default null
67 ,p_start_date in date default null
68 ,p_end_date in date default null
69 ,p_reallocation_amt in number
70 ,p_reserved_amt in number default null
71 ,p_reallocation_period_id out nocopy number
72 ,p_object_version_number out nocopy number
73 ,p_return_status out nocopy varchar2
74 );
75 -- ----------------------------------------------------------------------------
76 -- |------------------------< delete_realloc_txn_dtl >------------------------|
77 -- ----------------------------------------------------------------------------
78 -- {Start of comments}
79 --
80 -- Description:
81 -- This procedure is the self-service wrapper procedure to the following
82 -- API: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_dtl
83 --
84 -- Pre-requisites
85 -- All 'IN' parameters to this procedure have been appropriately derived.
86 --
87 -- Post Success:
88 -- p_return_status will return value indicating success.
89 --
90 -- Post Failure:
91 -- p_return_status will return value indication failure.
92 --
93 -- Access Status:
94 -- Internal Development use only.
95 --
96 -- {End of comments}
97 -- ----------------------------------------------------------------------------
98 PROCEDURE delete_realloc_txn_dtl
99 (p_validate in number default hr_api.g_false_num
100 ,p_txn_detail_id in number
101 ,p_object_version_number in number
102 ,p_return_status out nocopy varchar2
103 );
104 -- ----------------------------------------------------------------------------
105 -- |-----------------------< delete_realloc_txn_period >----------------------|
106 -- ----------------------------------------------------------------------------
107 -- {Start of comments}
108 --
109 -- Description:
110 -- This procedure is the self-service wrapper procedure to the following
111 -- API: pqh_bdgt_pool_realloctions_api.delete_realloc_txn_period
112 --
113 -- Pre-requisites
114 -- All 'IN' parameters to this procedure have been appropriately derived.
115 --
116 -- Post Success:
117 -- p_return_status will return value indicating success.
118 --
119 -- Post Failure:
120 -- p_return_status will return value indication failure.
121 --
122 -- Access Status:
123 -- Internal Development use only.
124 --
125 -- {End of comments}
126 -- ----------------------------------------------------------------------------
127 PROCEDURE delete_realloc_txn_period
128 (p_validate in number default hr_api.g_false_num
129 ,p_reallocation_period_id in number
130 ,p_object_version_number in number
131 ,p_return_status out nocopy varchar2
132 );
133 -- ----------------------------------------------------------------------------
134 -- |------------------------< update_realloc_txn_dtl >------------------------|
135 -- ----------------------------------------------------------------------------
136 -- {Start of comments}
137 --
138 -- Description:
139 -- This procedure is the self-service wrapper procedure to the following
140 -- API: pqh_bdgt_pool_realloctions_api.update_realloc_txn_dtl
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.
153 --
150 --
151 -- Access Status:
152 -- Internal Development use only.
154 -- {End of comments}
155 -- ----------------------------------------------------------------------------
156 PROCEDURE update_realloc_txn_dtl
157 (p_validate in number default hr_api.g_false_num
158 ,p_effective_date in date
159 ,p_transaction_id in number default hr_api.g_number
160 ,p_transaction_type in varchar2 default hr_api.g_varchar2
161 ,p_entity_id in number default hr_api.g_number
162 ,p_budget_detail_id in number default hr_api.g_number
163 ,p_txn_detail_id in number
164 ,p_object_version_number in out nocopy number
165 ,p_return_status out nocopy varchar2
166 );
167 -- ----------------------------------------------------------------------------
168 -- |-----------------------< update_realloc_txn_period >----------------------|
169 -- ----------------------------------------------------------------------------
170 -- {Start of comments}
171 --
172 -- Description:
173 -- This procedure is the self-service wrapper procedure to the following
174 -- API: pqh_bdgt_pool_realloctions_api.update_realloc_txn_period
175 --
176 -- Pre-requisites
177 -- All 'IN' parameters to this procedure have been appropriately derived.
178 --
179 -- Post Success:
180 -- p_return_status will return value indicating success.
181 --
182 -- Post Failure:
183 -- p_return_status will return value indication failure.
184 --
185 -- Access Status:
186 -- Internal Development use only.
187 --
188 -- {End of comments}
189 -- ----------------------------------------------------------------------------
190 PROCEDURE update_realloc_txn_period
191 (p_validate in number default hr_api.g_false_num
192 ,p_effective_date in date
193 ,p_txn_detail_id in number default hr_api.g_number
194 ,p_transaction_type in varchar2 default hr_api.g_varchar2
195 ,p_entity_id in number default hr_api.g_number
196 ,p_budget_period_id in number default hr_api.g_number
197 ,p_start_date in date default hr_api.g_date
198 ,p_end_date in date default hr_api.g_date
199 ,p_reallocation_amt in number default hr_api.g_number
200 ,p_reserved_amt in number default hr_api.g_number
201 ,p_reallocation_period_id in number
202 ,p_object_version_number in out nocopy number
203 ,p_return_status out nocopy varchar2
204 );
205 end pqh_bdgt_pool_realloctions_swi;