[Home] [Help]
PACKAGE: APPS.GMF_SUBLEDGER_PKG
Source
1 PACKAGE gmf_subledger_pkg AS
2 /* $Header: gmfslups.pls 120.2 2005/10/30 20:31:32 umoogala noship $ */
3
4 /*****************************************************************************
5 * PACKAGE
6 * gmf_subledger_pkg
7 *
8 * DESCRIPTION
9 * Subledger Update Process pkg
10 *
11 * CONTENTS
12 * PROCEDURE test_update ( ... )
13 *
14 * HISTORY
15 * 24-Dec-2002 Rajesh Seshadri - Created
16 *
17 ******************************************************************************/
18
19 /* Start INVCONV umoogala
20 PROCEDURE update_process(
21 x_errbuf OUT NOCOPY VARCHAR2,
22 x_retcode OUT NOCOPY VARCHAR2,
23 p_co_code IN VARCHAR2,
24 p_gl_fiscal_year IN VARCHAR2,
25 p_gl_period IN VARCHAR2,
26 p_test_posting IN VARCHAR2,
27 p_open_gl_date IN VARCHAR2,
28 p_posting_start_date IN VARCHAR2,
29 p_posting_end_date IN VARCHAR2,
30 p_post_if_no_cost IN VARCHAR2,
31 p_post_cm IN VARCHAR2,
32 p_post_ic IN VARCHAR2,
33 p_post_om IN VARCHAR2,
34 p_post_op IN VARCHAR2,
35 p_post_pm IN VARCHAR2,
36 p_post_po IN VARCHAR2,
37 p_post_pur IN VARCHAR2
38 );
39
40 PROCEDURE validate_parameters(
41 p_co_code IN VARCHAR2,
42 p_gl_fiscal_year IN VARCHAR2,
43 p_gl_period IN VARCHAR2,
44 p_test_posting IN VARCHAR2,
45 p_open_gl_date IN VARCHAR2,
46 p_posting_start_date IN VARCHAR2,
47 p_posting_end_date IN VARCHAR2,
48 p_post_cm IN VARCHAR2,
49 p_post_ic IN VARCHAR2,
50 p_post_om IN VARCHAR2,
51 p_post_op IN VARCHAR2,
52 p_post_pm IN VARCHAR2,
53 p_post_po IN VARCHAR2,
54 p_post_pur IN VARCHAR2,
55 x_closed_per_ind OUT NOCOPY NUMBER,
56 x_crev_gl_trans_date OUT NOCOPY DATE,
57 x_open_gl_fiscal_year OUT NOCOPY NUMBER,
58 x_open_gl_period OUT NOCOPY NUMBER,
59 x_crev_curr_mthd OUT NOCOPY VARCHAR2,
60 x_crev_curr_calendar OUT NOCOPY VARCHAR2,
61 x_crev_curr_period OUT NOCOPY VARCHAR2,
62 x_crev_prev_mthd OUT NOCOPY VARCHAR2,
63 x_crev_prev_calendar OUT NOCOPY VARCHAR2,
64 x_crev_prev_period OUT NOCOPY VARCHAR2,
65 x_inv_fiscal_year OUT NOCOPY VARCHAR2,
66 x_inv_period OUT NOCOPY NUMBER,
67 x_retstatus OUT NOCOPY VARCHAR2,
68 x_errbuf OUT NOCOPY VARCHAR2
69 );
70
71 PROCEDURE insert_control_record(
72 p_co_code IN VARCHAR2,
73 p_user_id IN NUMBER,
74 p_gl_fiscal_year IN NUMBER,
75 p_gl_period IN NUMBER,
76 p_posting_start_date IN DATE,
77 p_posting_end_date IN DATE,
78 p_test_posting IN VARCHAR2,
79 p_post_cm IN VARCHAR2,
80 p_post_ic IN VARCHAR2,
81 p_post_om IN VARCHAR2,
82 p_post_op IN VARCHAR2,
83 p_post_pm IN VARCHAR2,
84 p_post_po IN VARCHAR2,
85 p_post_pur IN VARCHAR2,
86 p_closed_per_ind IN NUMBER,
87 p_open_gl_date IN DATE,
88 p_crev_gl_trans_date IN DATE,
89 p_open_gl_fiscal_year IN NUMBER,
90 p_open_gl_period IN NUMBER,
91 p_post_if_no_cost IN VARCHAR2,
92 p_default_language IN VARCHAR2,
93 p_crev_curr_mthd IN VARCHAR2,
94 p_crev_curr_calendar IN VARCHAR2,
95 p_crev_curr_period IN VARCHAR2,
96 p_crev_prev_mthd IN VARCHAR2,
97 p_crev_prev_calendar IN VARCHAR2,
98 p_crev_prev_period IN VARCHAR2,
99 p_inv_fiscal_year IN VARCHAR2,
100 p_inv_period IN NUMBER,
101 x_subledger_ref_no OUT NOCOPY NUMBER,
102 x_retstatus OUT NOCOPY VARCHAR2,
103 x_errbuf OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE check_costing(
107 p_co_code IN VARCHAR2,
108 p_test_posting IN VARCHAR2,
109 p_period_start_date IN DATE,
110 p_period_end_date IN DATE,
111 p_closed_period_ind IN NUMBER,
112 p_open_gl_date IN DATE,
113 x_crev_gl_trans_date OUT NOCOPY DATE,
114 x_crev_curr_mthd OUT NOCOPY VARCHAR2,
115 x_crev_curr_calendar OUT NOCOPY VARCHAR2,
116 x_crev_curr_period OUT NOCOPY VARCHAR2,
117 x_crev_prev_mthd OUT NOCOPY VARCHAR2,
118 x_crev_prev_calendar OUT NOCOPY VARCHAR2,
119 x_crev_prev_period OUT NOCOPY VARCHAR2,
120 x_inv_fiscal_year OUT NOCOPY VARCHAR2,
121 x_inv_period OUT NOCOPY NUMBER,
122 x_retstatus OUT NOCOPY VARCHAR2,
123 x_errbuf OUT NOCOPY VARCHAR2
124 );
125 */
126
127 PROCEDURE update_process(
128 x_errbuf OUT NOCOPY VARCHAR2
129 , x_retcode OUT NOCOPY VARCHAR2
130 , p_legal_entity_id IN VARCHAR2
131 , p_ledger_id IN VARCHAR2
132 , p_cost_type_id IN VARCHAR2
133 , p_gl_fiscal_year IN VARCHAR2
134 , p_gl_period IN VARCHAR2
135 , p_test_posting IN VARCHAR2
136 , p_open_gl_date IN VARCHAR2
137 , p_posting_start_date IN VARCHAR2
138 , p_posting_end_date IN VARCHAR2
139 , p_post_if_no_cost IN VARCHAR2
140 , p_process_category IN VARCHAR2
141 , p_crev_curr_calendar IN VARCHAR2
142 , p_crev_curr_period IN VARCHAR2
143 , p_crev_prev_cost_type_id IN VARCHAR2
144 , p_crev_prev_calendar IN VARCHAR2
145 , p_crev_prev_period IN VARCHAR2
146 , p_crev_gl_trans_date IN VARCHAR2
147 /* start invconv umoogala
148 p_co_code in varchar2
149 p_post_cm IN VARCHAR2,
150 p_post_ic IN VARCHAR2,
151 p_post_om IN VARCHAR2,
152 p_post_op IN VARCHAR2,
153 p_post_pm IN VARCHAR2,
154 p_post_po IN VARCHAR2,
155 p_post_pur IN VARCHAR2
156 */
157 );
158
159 PROCEDURE validate_parameters(
160 p_gl_fiscal_year IN VARCHAR2,
161 p_gl_period IN VARCHAR2,
162 p_test_posting IN VARCHAR2,
163 p_open_gl_date IN VARCHAR2,
164 p_posting_start_date IN VARCHAR2,
165 p_posting_end_date IN VARCHAR2,
166 /* Start INVCONV umoogala
167 p_co_code IN VARCHAR2,
168 p_post_cm IN VARCHAR2,
169 p_post_ic IN VARCHAR2,
170 p_post_om IN VARCHAR2,
171 p_post_op IN VARCHAR2,
172 p_post_pm IN VARCHAR2,
173 p_post_po IN VARCHAR2,
174 p_post_pur IN VARCHAR2,
175 */
176 x_closed_per_ind OUT NOCOPY NUMBER,
177 x_crev_gl_trans_date OUT NOCOPY DATE,
178 x_open_gl_fiscal_year OUT NOCOPY NUMBER,
179 x_open_gl_period OUT NOCOPY NUMBER,
180 /* Start INVCONV umoogala
181 x_crev_curr_mthd OUT NOCOPY VARCHAR2,
182 x_crev_curr_calendar OUT NOCOPY VARCHAR2,
183 x_crev_curr_period OUT NOCOPY VARCHAR2,
184 x_crev_prev_mthd OUT NOCOPY VARCHAR2,
185 x_crev_prev_calendar OUT NOCOPY VARCHAR2,
186 x_crev_prev_period OUT NOCOPY VARCHAR2,
187 */
188 x_inv_fiscal_year OUT NOCOPY NUMBER,
189 x_inv_period OUT NOCOPY NUMBER,
190 x_retstatus OUT NOCOPY VARCHAR2,
191 x_errbuf OUT NOCOPY VARCHAR2
192 );
193
194 PROCEDURE insert_control_record(
195 p_user_id IN NUMBER,
196 p_gl_fiscal_year IN NUMBER,
197 p_gl_period IN NUMBER,
198 p_posting_start_date IN DATE,
199 p_posting_end_date IN DATE,
200 p_test_posting IN VARCHAR2,
201 /* Start INVCONV umoogala
202 p_post_cm IN VARCHAR2,
203 p_post_ic IN VARCHAR2,
204 p_post_om IN VARCHAR2,
205 p_post_op IN VARCHAR2,
206 p_post_pm IN VARCHAR2,
207 p_post_po IN VARCHAR2,
208 p_post_pur IN VARCHAR2,
209 */
210 p_closed_per_ind IN NUMBER,
211 p_open_gl_date IN DATE,
212 p_crev_gl_trans_date IN DATE,
213 p_open_gl_fiscal_year IN NUMBER,
214 p_open_gl_period IN NUMBER,
215 p_post_if_no_cost IN VARCHAR2,
216 p_default_language IN VARCHAR2,
217 /* Start INVCONV umoogala
218 p_crev_curr_mthd IN VARCHAR2,
219 p_crev_curr_calendar IN VARCHAR2,
220 p_crev_curr_period IN VARCHAR2,
221 p_crev_prev_mthd IN VARCHAR2,
222 p_crev_prev_calendar IN VARCHAR2,
223 p_crev_prev_period IN VARCHAR2,
224 */
225 p_inv_fiscal_year IN VARCHAR2,
226 p_inv_period IN NUMBER,
227 x_subledger_ref_no OUT NOCOPY NUMBER,
228 x_retstatus OUT NOCOPY VARCHAR2,
229 x_errbuf OUT NOCOPY VARCHAR2
230 );
231
232 PROCEDURE check_costing(
233 p_test_posting IN VARCHAR2,
234 p_period_start_date IN DATE,
235 p_period_end_date IN DATE,
236 p_closed_period_ind IN NUMBER,
237 p_open_gl_date IN DATE,
238 x_crev_gl_trans_date OUT NOCOPY DATE,
239 /* Start INVCONV umoogala
240 x_crev_curr_mthd OUT NOCOPY VARCHAR2,
241 x_crev_curr_calendar OUT NOCOPY VARCHAR2,
242 x_crev_curr_period OUT NOCOPY VARCHAR2,
243 x_crev_prev_mthd OUT NOCOPY VARCHAR2,
244 x_crev_prev_calendar OUT NOCOPY VARCHAR2,
245 x_crev_prev_period OUT NOCOPY VARCHAR2,
246 */
247 x_inv_fiscal_year OUT NOCOPY NUMBER,
248 x_inv_period OUT NOCOPY NUMBER,
249 x_retstatus OUT NOCOPY VARCHAR2,
250 x_errbuf OUT NOCOPY VARCHAR2
251 );
252
253 PROCEDURE populate_global (
254 p_legal_entity_id IN VARCHAR2
255 , p_ledger_id IN VARCHAR2
256 , p_cost_type_id IN VARCHAR2
257 , p_post_cm IN VARCHAR2
258 , p_crev_curr_calendar IN VARCHAR2
259 , p_crev_curr_period IN VARCHAR2
260 , p_crev_prev_cost_type_id IN VARCHAR2
261 , p_crev_prev_calendar IN VARCHAR2
262 , p_crev_prev_period IN VARCHAR2
263 , p_crev_gl_trans_date IN VARCHAR2
264 )
265 ;
266
267 END gmf_subledger_pkg;