1 PACKAGE PQH_PSB_INTERFACE_API AUTHID CURRENT_USER AS
2 /* $Header: pqhpqps.pkh 115.3 2002/12/06 18:06:39 rpasapul noship $ */
3
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_budget_version >------------------------|
6 -- ----------------------------------------------------------------------------
7 procedure create_budget_version
8 (
9 p_validate in boolean default false
10 ,p_budget_version_id out nocopy number
11 ,p_budget_id in number default null
12 ,p_version_number in number default null
13 ,p_date_from in date default null
14 ,p_date_to in date default null
15 ,p_transfered_to_gl_flag in varchar2 default null
16 ,p_gl_status in varchar2 default null
17 ,p_xfer_to_other_apps_cd in varchar2 default null
18 ,p_object_version_number out nocopy number
19 ,p_budget_unit1_value in number default null
20 ,p_budget_unit2_value in number default null
21 ,p_budget_unit3_value in number default null
22 ,p_budget_unit1_available in number default null
23 ,p_budget_unit2_available in number default null
24 ,p_budget_unit3_available in number default null
25 ,p_effective_date in date
26 );
27 -- ----------------------------------------------------------------------------
28 -- |------------------------< update_budget_version >------------------------|
29 -- ----------------------------------------------------------------------------
30 procedure update_budget_version
31 (
32 p_validate in boolean default false
33 ,p_budget_version_id in number
34 ,p_budget_id in number default hr_api.g_number
35 ,p_version_number in number default hr_api.g_number
36 ,p_date_from in date default hr_api.g_date
37 ,p_date_to in date default hr_api.g_date
38 ,p_transfered_to_gl_flag in varchar2 default hr_api.g_varchar2
39 ,p_gl_status in varchar2 default hr_api.g_varchar2
40 ,p_xfer_to_other_apps_cd in varchar2 default hr_api.g_varchar2
41 ,p_object_version_number in out nocopy number
42 ,p_budget_unit1_value in number default hr_api.g_number
43 ,p_budget_unit2_value in number default hr_api.g_number
44 ,p_budget_unit3_value in number default hr_api.g_number
45 ,p_budget_unit1_available in number default hr_api.g_number
46 ,p_budget_unit2_available in number default hr_api.g_number
47 ,p_budget_unit3_available in number default hr_api.g_number
48 ,p_effective_date in date
49 );
50 -- ----------------------------------------------------------------------------
51 -- |------------------------< create_budget_element >------------------------|
52 -- ----------------------------------------------------------------------------
53 procedure create_budget_element
54 (
55 p_validate in boolean default false
56 ,p_budget_element_id out nocopy number
57 ,p_budget_set_id in number default null
58 ,p_element_type_id in number default null
59 ,p_distribution_percentage in number default null
60 ,p_object_version_number out nocopy number
61 );
62 -- ----------------------------------------------------------------------------
63 -- |------------------------< update_budget_element >------------------------|
64 -- ----------------------------------------------------------------------------
65 procedure update_budget_element
66 (
67 p_validate in boolean default false
68 ,p_budget_element_id in number
69 ,p_budget_set_id in number default hr_api.g_number
70 ,p_element_type_id in number default hr_api.g_number
71 ,p_distribution_percentage in number default hr_api.g_number
72 ,p_object_version_number in out nocopy number
73 );
74 -- ----------------------------------------------------------------------------
75 -- |------------------------< create_budget_fund_src >------------------------|
76 -- ----------------------------------------------------------------------------
77 procedure create_budget_fund_src
78 (
79 p_validate in boolean default false
80 ,p_budget_fund_src_id out nocopy number
81 ,p_budget_element_id in number default null
82 ,p_cost_allocation_keyflex_id in number default null
83 ,p_project_id in number default null
84 ,p_award_id in number default null
85 ,p_task_id in number default null
86 ,p_expenditure_type in varchar2 default null
87 ,p_organization_id in number default null
88 ,p_distribution_percentage in number default null
89 ,p_object_version_number out nocopy number
90 );
91 -- ----------------------------------------------------------------------------
92 -- |------------------------< update_budget_fund_src >------------------------|
93 -- ----------------------------------------------------------------------------
94 procedure update_budget_fund_src
95 (
96 p_validate in boolean default false
97 ,p_budget_fund_src_id in number
98 ,p_budget_element_id in number default hr_api.g_number
99 ,p_cost_allocation_keyflex_id in number default hr_api.g_number
100 ,p_project_id in number default hr_api.g_number
101 ,p_award_id in number default hr_api.g_number
102 ,p_task_id in number default hr_api.g_number
103 ,p_expenditure_type in varchar2 default hr_api.g_varchar2
104 ,p_organization_id in number default hr_api.g_number
105 ,p_distribution_percentage in number default hr_api.g_number
106 ,p_object_version_number in out nocopy number
107 );
108 -- ----------------------------------------------------------------------------
109 -- |------------------------< create_budget_period >------------------------|
110 -- ----------------------------------------------------------------------------
111 procedure create_budget_period
112 (
113 p_validate in boolean default false
114 ,p_budget_period_id out nocopy number
115 ,p_budget_detail_id in number default null
116 ,p_start_time_period_id in number default null
117 ,p_end_time_period_id in number default null
118 ,p_budget_unit1_percent in number default null
119 ,p_budget_unit2_percent in number default null
120 ,p_budget_unit3_percent in number default null
121 ,p_budget_unit1_value in number default null
122 ,p_budget_unit2_value in number default null
123 ,p_budget_unit3_value in number default null
124 ,p_budget_unit1_value_type_cd in varchar2 default null
125 ,p_budget_unit2_value_type_cd in varchar2 default null
126 ,p_budget_unit3_value_type_cd in varchar2 default null
127 ,p_budget_unit1_available in number default null
128 ,p_budget_unit2_available in number default null
129 ,p_budget_unit3_available in number default null
130 ,p_object_version_number out nocopy number
131 );
132 -- ----------------------------------------------------------------------------
133 -- |------------------------< update_budget_period >------------------------|
134 -- ----------------------------------------------------------------------------
135 procedure update_budget_period
136 (
137 p_validate in boolean default false
138 ,p_budget_period_id in number
139 ,p_budget_detail_id in number default hr_api.g_number
140 ,p_start_time_period_id in number default hr_api.g_number
141 ,p_end_time_period_id in number default hr_api.g_number
142 ,p_budget_unit1_percent in number default hr_api.g_number
143 ,p_budget_unit2_percent in number default hr_api.g_number
144 ,p_budget_unit3_percent in number default hr_api.g_number
145 ,p_budget_unit1_value in number default hr_api.g_number
146 ,p_budget_unit2_value in number default hr_api.g_number
147 ,p_budget_unit3_value in number default hr_api.g_number
148 ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
149 ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
150 ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
151 ,p_budget_unit1_available in number default hr_api.g_number
152 ,p_budget_unit2_available in number default hr_api.g_number
153 ,p_budget_unit3_available in number default hr_api.g_number
154 ,p_object_version_number in out nocopy number
155 );
156 -- ----------------------------------------------------------------------------
157 -- |------------------------< create_budget_set >------------------------|
158 -- ----------------------------------------------------------------------------
159 procedure create_budget_set
160 (
161 p_validate in boolean default false
162 ,p_budget_set_id out nocopy number
163 ,p_dflt_budget_set_id in number default null
164 ,p_budget_period_id in number default null
165 ,p_budget_unit1_percent in number default null
166 ,p_budget_unit2_percent in number default null
167 ,p_budget_unit3_percent in number default null
168 ,p_budget_unit1_value in number default null
169 ,p_budget_unit2_value in number default null
170 ,p_budget_unit3_value in number default null
171 ,p_budget_unit1_available in number default null
172 ,p_budget_unit2_available in number default null
173 ,p_budget_unit3_available in number default null
174 ,p_object_version_number out nocopy number
175 ,p_budget_unit1_value_type_cd in varchar2 default null
176 ,p_budget_unit2_value_type_cd in varchar2 default null
177 ,p_budget_unit3_value_type_cd in varchar2 default null
178 ,p_effective_date in date
179 );
180 -- ----------------------------------------------------------------------------
181 -- |------------------------< update_budget_set >------------------------|
182 -- ----------------------------------------------------------------------------
183 procedure update_budget_set
184 (
185 p_validate in boolean default false
186 ,p_budget_set_id in number
187 ,p_dflt_budget_set_id in number default hr_api.g_number
188 ,p_budget_period_id in number default hr_api.g_number
189 ,p_budget_unit1_percent in number default hr_api.g_number
190 ,p_budget_unit2_percent in number default hr_api.g_number
191 ,p_budget_unit3_percent in number default hr_api.g_number
192 ,p_budget_unit1_value in number default hr_api.g_number
193 ,p_budget_unit2_value in number default hr_api.g_number
194 ,p_budget_unit3_value in number default hr_api.g_number
195 ,p_budget_unit1_available in number default hr_api.g_number
196 ,p_budget_unit2_available in number default hr_api.g_number
197 ,p_budget_unit3_available in number default hr_api.g_number
198 ,p_object_version_number in out nocopy number
199 ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
200 ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
201 ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
202 ,p_effective_date in date
203 );
204 -- ----------------------------------------------------------------------------
205 -- |------------------------< create_budget_detail >------------------------|
206 -- ----------------------------------------------------------------------------
207 procedure create_budget_detail
208 (
209 p_validate in boolean default false
210 ,p_budget_detail_id out nocopy number
211 ,p_organization_id in number default null
212 ,p_job_id in number default null
213 ,p_position_id in number default null
214 ,p_grade_id in number default null
215 ,p_budget_version_id in number default null
216 ,p_budget_unit1_percent in number default null
217 ,p_budget_unit1_value_type_cd in varchar2 default null
218 ,p_budget_unit1_value in number default null
219 ,p_budget_unit1_available in number default null
220 ,p_budget_unit2_percent in number default null
221 ,p_budget_unit2_value_type_cd in varchar2 default null
222 ,p_budget_unit2_value in number default null
223 ,p_budget_unit2_available in number default null
224 ,p_budget_unit3_percent in number default null
225 ,p_budget_unit3_value_type_cd in varchar2 default null
226 ,p_budget_unit3_value in number default null
227 ,p_budget_unit3_available in number default null
228 ,p_gl_status in varchar2 default null
229 ,p_object_version_number out nocopy number
230 );
231 -- ----------------------------------------------------------------------------
232 -- |------------------------< update_budget_detail >------------------------|
233 -- ----------------------------------------------------------------------------
234 procedure update_budget_detail
235 (
236 p_validate in boolean default false
237 ,p_budget_detail_id in number
238 ,p_organization_id in number default hr_api.g_number
239 ,p_job_id in number default hr_api.g_number
240 ,p_position_id in number default hr_api.g_number
241 ,p_grade_id in number default hr_api.g_number
242 ,p_budget_version_id in number default hr_api.g_number
243 ,p_budget_unit1_percent in number default hr_api.g_number
244 ,p_budget_unit1_value_type_cd in varchar2 default hr_api.g_varchar2
245 ,p_budget_unit1_value in number default hr_api.g_number
246 ,p_budget_unit1_available in number default hr_api.g_number
247 ,p_budget_unit2_percent in number default hr_api.g_number
248 ,p_budget_unit2_value_type_cd in varchar2 default hr_api.g_varchar2
249 ,p_budget_unit2_value in number default hr_api.g_number
250 ,p_budget_unit2_available in number default hr_api.g_number
251 ,p_budget_unit3_percent in number default hr_api.g_number
252 ,p_budget_unit3_value_type_cd in varchar2 default hr_api.g_varchar2
253 ,p_budget_unit3_value in number default hr_api.g_number
254 ,p_budget_unit3_available in number default hr_api.g_number
255 ,p_gl_status in varchar2 default hr_api.g_varchar2
256 ,p_object_version_number in out nocopy number
257 );
258 -- ---------------------------------------------------------------------------
259 -- |-----------------< POSITION_CONTROL_ENABLED >---------------------|
260 -- ---------------------------------------------------------------------------
261 function position_control_enabled(p_organization_id number default null,
262 p_effective_date in date default sysdate,
263 p_assignment_id number default null
264 )RETURN VARCHAR2;
265 -- ---------------------------------------------------------------------------
266 -- |---------------------< create_app_api_hook_call >-------------------------|
267 -- ---------------------------------------------------------------------------
268 procedure create_app_api_hook_call
269 (p_validate in boolean default false,
270 p_effective_date in date,
271 p_api_hook_id in number,
272 p_api_hook_call_type in varchar2,
273 p_sequence in number,
274 p_application_id in number,
275 p_app_install_status in varchar2,
276 p_enabled_flag in varchar2 default 'N',
277 p_call_package in varchar2 default null,
278 p_call_procedure in varchar2 default null,
279 p_api_hook_call_id out nocopy number,
280 p_object_version_number out nocopy number
281 );
282 END PQH_PSB_INTERFACE_API;