1 PACKAGE ozf_fund_reconcile_pvt AUTHID CURRENT_USER AS
2 /*$Header: ozfvrecs.pls 120.0 2005/06/01 01:06:54 appldev noship $*/
3 ---------------------------------------------------------------------
4 -- PROCEDURE
5 -- Release fund concurrent program
6 --
7 -- PURPOSE
8 --
9 -- PARAMETERS
10 -- p_object_type IN VARCHAR2
11 -- p_object_status IN VARCHAR2 :=FND_API.G_MISS_CHAR
12 -- p_object_code IN VARCHAR2 :=fnd_api.G_MISS_CHAR
13 -- p_object_end_date IN DATE := FND_API.G_MISS_DATE
14 -- x_errbuf OUT VARCHAR2 STANDARD OUT PARAMETER
15 -- x_retcode OUT NUMBER STANDARD OUT PARAMETER
16 -- NOTES
17 -- This API will release the un-paid and committed amounts.
18
19 -- HISTORY
20 -- 10/16/2002 feliu Create.
21
22 ----------------------------------------------------------------------
23 PROCEDURE release_fund_conc(
24 x_errbuf OUT NOCOPY VARCHAR2
25 ,x_retcode OUT NOCOPY NUMBER
26 ,p_object_type IN VARCHAR2
27 ,p_object_status IN VARCHAR2 :=null
28 ,p_object_code IN VARCHAR2 :=null
29 ,p_object_end_date IN VARCHAR2 := null
30 ,p_util_paid IN VARCHAR2 := null
31 /* ,p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
33 ,p_commit IN VARCHAR2 := fnd_api.g_false
34 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
35 ,x_return_status OUT NOCOPY VARCHAR2
36 ,x_msg_count OUT NOCOPY NUMBER
37 ,x_msg_data OUT NOCOPY VARCHAR2 */
38 );
39
40
41 /*****************************************************************************************/
42 -- Start of Comments
43 -- NAME
44 -- Reconcile_line
45 -- PURPOSE
46 -- This API is called from the java layer from the reconcile button on budget_sourcing screen or from
47 -- release_fund_concurrent program.
48 -- It releases all th budget that was requested from a fund to the respective fund by creating transfer records
49 -- and negative committment.
50 -- HISTORY
51 -- 10/08/2002 feliu CREATED
52 ---------------------------------------------------------------------
53
54 PROCEDURE reconcile_line (
55 p_budget_used_by_id IN NUMBER
56 ,p_budget_used_by_type IN VARCHAR2
57 ,p_object_currency IN VARCHAR2
58 ,p_from_paid IN VARCHAR2
59 ,p_api_version IN NUMBER
60 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
61 ,p_commit IN VARCHAR2 := fnd_api.g_false
62 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68
69 /*****************************************************************************************/
70 -- Start of Comments
71 -- NAME
72 -- Reconcile_budget_line
73 -- PURPOSE
74 -- This API is called from the java layer from the reconcile button on budget_sourcing screen
75 -- It releases all th ebudget that was requested from a fund to the respective fund by creating transfer records
76 -- and negative committment.
77 -- HISTORY
78 -- 04/30/2001 mpande CREATED
79
80 PROCEDURE reconcile_budget_line(
81 p_budget_used_by_id IN NUMBER
82 ,p_budget_used_by_type IN VARCHAR2
83 ,p_object_currency IN VARCHAR2
84 ,p_api_version IN NUMBER
85 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
86 ,p_commit IN VARCHAR2 := fnd_api.g_false
87 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_msg_count OUT NOCOPY NUMBER
90 ,x_msg_data OUT NOCOPY VARCHAR2);
91
92 ---------------------------------------------------------------------
93 -- PROCEDURE
94 -- reconcile_budget_utilized
95 --
96 -- PURPOSE
97 --This API will be reconcile un_paid amount. it is called by concurrent program.
98
99 -- PARAMETERS
100 -- p_budget_used_by_id IN object id,
101 -- p_budget_used_by_type IN object type,
102 -- p_object_currency IN object currency,
103
104 -- NOTES
105 -- HISTORY
106 -- 09/24/2002 feliu Create.
107 ----------------------------------------------------------------------
108
109 PROCEDURE reconcile_budget_utilized (
110 p_budget_used_by_id IN NUMBER
111 ,p_budget_used_by_type IN VARCHAR2
112 ,p_object_currency IN VARCHAR2
113 ,p_api_version IN NUMBER
114 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
115 ,p_commit IN VARCHAR2 := fnd_api.g_false
116 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
117 ,x_return_status OUT NOCOPY VARCHAR2
118 ,x_msg_count OUT NOCOPY NUMBER
119 ,x_msg_data OUT NOCOPY VARCHAR2
120 );
121
122
123 ---------------------------------------------------------------------
124 -- PROCEDURE
125 -- post_utilized_budget_conc
126 --
127 -- PURPOSE
128 --This API will be called by claim to automatic increase committed and utilized budget
129 --when automatic adjustment is allowed for scan data offer.
130 --It will increase both committed and utilized amount.
131
132 -- PARAMETERS
133 -- x_errbuf OUT VARCHAR2
134 -- ,x_retcode OUT NUMBER
135
136 -- NOTES
137 -- HISTORY
138 -- 09/24/2002 feliu Create.
139 ----------------------------------------------------------------------
140
141 PROCEDURE Post_utilized_budget_conc
142 (
143 x_errbuf OUT NOCOPY VARCHAR2
144 ,x_retcode OUT NOCOPY NUMBER
145 /*
146 p_api_version IN NUMBER
147 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
148 ,p_commit IN VARCHAR2 := fnd_api.g_false
149 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150 ,x_return_status OUT NOCOPY VARCHAR2
151 ,x_msg_count OUT NOCOPY NUMBER
152 ,x_msg_data OUT NOCOPY VARCHAR2 */
153 );
154
155 /* ---------------------------------------------------------------------
156 -- PROCEDURE
157 -- Recalculating-recalculate_committed_fund_conc
158 -- PURPOSE
159 -- This API is called from the concurrent program manager.
160 -- It recalculats committed amount base on fund utilization
161 ---during certain period
162 -- and creating request or transfer records.
163 -- PARAMETERS
164 p_api_version IN NUMBER
165 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
166 ,p_commit IN VARCHAR2 := fnd_api.g_false
167 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
168 ,x_return_status OUT NOCOPY VARCHAR2
169 ,x_msg_count OUT NOCOPY NUMBER
170 ,x_msg_data OUT NOCOPY VARCHAR2
171
172 -- HISTORY
173 -- 10/05/2001 feliu CREATED
174 */----------------------------------------------------------------------------
175 PROCEDURE recal_comm_fund_conc
176 (
177 x_errbuf OUT NOCOPY VARCHAR2
178 ,x_retcode OUT NOCOPY NUMBER
179 );
180
181 ---------------------------------------------------------------------
182 -- PROCEDURE
183 -- open_next_years_budget
184 --
185 -- PURPOSE
186 -- This API creates new budgets corresponding to old budgets. The unutilized committed
187 -- amount is transferred to new Budgets
188
189 -- PARAMETERS
190 -- p_query_id IN NUMBER
191 -- p_fund_id IN NUMBER
192 -- p_hierarchy_flag IN VARCHAR2
193 -- p_amount_flag IN VARCHAR2
194
195 -- NOTES
196 -- HISTORY
197 -- 09/10/2003 niprakas Create.
198 ----------------------------------------------------------------------
199
200
201
202
203 procedure open_next_years_budget (
204 x_errbuf OUT NOCOPY VARCHAR2,
205 x_retcode OUT NOCOPY NUMBER,
206 p_query_id IN NUMBER,
207 p_fund_id IN NUMBER,
208 p_hierarchy_flag IN VARCHAR2,
209 p_amount_flag IN VARCHAR2
210 );
211
212 END ozf_fund_reconcile_pvt;
213