[Home] [Help]
PACKAGE: APPS.GMF_SUBLEDGER_PKG
Source
1 PACKAGE gmf_subledger_pkg AUTHID CURRENT_USER AS
2 /* $Header: gmfslups.pls 120.2.12020000.3 2013/02/14 10:33:40 pmarada ship $ */
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 * 01-feb-2013 bug15954309, added post_txn_cmpt_cost,num_of_process parameters
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_post_txn_cmpt_cost IN NUMBER
141 , p_process_category IN VARCHAR2
142 , p_num_of_process IN NUMBER
143 , p_crev_curr_calendar IN VARCHAR2
144 , p_crev_curr_period IN VARCHAR2
145 , p_crev_prev_cost_type_id IN VARCHAR2
146 , p_crev_prev_calendar IN VARCHAR2
147 , p_crev_prev_period IN VARCHAR2
148 , p_crev_gl_trans_date IN VARCHAR2
149 /* start invconv umoogala
150 p_co_code in varchar2
151 p_post_cm IN VARCHAR2,
152 p_post_ic IN VARCHAR2,
153 p_post_om IN VARCHAR2,
154 p_post_op IN VARCHAR2,
155 p_post_pm IN VARCHAR2,
156 p_post_po IN VARCHAR2,
157 p_post_pur IN VARCHAR2
158 */
159 );
160
161 PROCEDURE validate_parameters(
162 p_gl_fiscal_year IN VARCHAR2,
163 p_gl_period IN VARCHAR2,
164 p_test_posting IN VARCHAR2,
165 p_open_gl_date IN VARCHAR2,
166 p_posting_start_date IN VARCHAR2,
167 p_posting_end_date IN VARCHAR2,
168 /* Start INVCONV umoogala
169 p_co_code IN VARCHAR2,
170 p_post_cm IN VARCHAR2,
171 p_post_ic IN VARCHAR2,
172 p_post_om IN VARCHAR2,
173 p_post_op IN VARCHAR2,
174 p_post_pm IN VARCHAR2,
175 p_post_po IN VARCHAR2,
176 p_post_pur IN VARCHAR2,
177 */
178 x_closed_per_ind OUT NOCOPY NUMBER,
179 x_crev_gl_trans_date OUT NOCOPY DATE,
180 x_open_gl_fiscal_year OUT NOCOPY NUMBER,
181 x_open_gl_period OUT NOCOPY NUMBER,
182 /* Start INVCONV umoogala
183 x_crev_curr_mthd OUT NOCOPY VARCHAR2,
184 x_crev_curr_calendar OUT NOCOPY VARCHAR2,
185 x_crev_curr_period OUT NOCOPY VARCHAR2,
186 x_crev_prev_mthd OUT NOCOPY VARCHAR2,
187 x_crev_prev_calendar OUT NOCOPY VARCHAR2,
188 x_crev_prev_period OUT NOCOPY VARCHAR2,
189 */
190 x_inv_fiscal_year OUT NOCOPY NUMBER,
191 x_inv_period OUT NOCOPY NUMBER,
192 x_retstatus OUT NOCOPY VARCHAR2,
193 x_errbuf OUT NOCOPY VARCHAR2
194 );
195
196 PROCEDURE insert_control_record(
197 p_user_id IN NUMBER,
198 p_gl_fiscal_year IN NUMBER,
199 p_gl_period IN NUMBER,
200 p_posting_start_date IN DATE,
201 p_posting_end_date IN DATE,
202 p_test_posting IN VARCHAR2,
203 /* Start INVCONV umoogala
204 p_post_cm IN VARCHAR2,
205 p_post_ic IN VARCHAR2,
206 p_post_om IN VARCHAR2,
207 p_post_op IN VARCHAR2,
208 p_post_pm IN VARCHAR2,
209 p_post_po IN VARCHAR2,
210 p_post_pur IN VARCHAR2,
211 */
212 p_closed_per_ind IN NUMBER,
213 p_open_gl_date IN DATE,
214 p_crev_gl_trans_date IN DATE,
215 p_open_gl_fiscal_year IN NUMBER,
216 p_open_gl_period IN NUMBER,
217 p_post_if_no_cost IN VARCHAR2,
218 p_default_language IN VARCHAR2,
219 /* Start INVCONV umoogala
220 p_crev_curr_mthd IN VARCHAR2,
221 p_crev_curr_calendar IN VARCHAR2,
222 p_crev_curr_period IN VARCHAR2,
223 p_crev_prev_mthd IN VARCHAR2,
224 p_crev_prev_calendar IN VARCHAR2,
225 p_crev_prev_period IN VARCHAR2,
226 */
227 p_inv_fiscal_year IN VARCHAR2,
228 p_inv_period IN NUMBER,
229 x_subledger_ref_no OUT NOCOPY NUMBER,
230 x_retstatus OUT NOCOPY VARCHAR2,
231 x_errbuf OUT NOCOPY VARCHAR2
232 );
233
234 PROCEDURE check_costing(
235 p_test_posting IN VARCHAR2,
236 p_period_start_date IN DATE,
237 p_period_end_date IN DATE,
238 p_closed_period_ind IN NUMBER,
239 p_open_gl_date IN DATE,
240 x_crev_gl_trans_date OUT NOCOPY DATE,
241 /* Start INVCONV umoogala
242 x_crev_curr_mthd OUT NOCOPY VARCHAR2,
243 x_crev_curr_calendar OUT NOCOPY VARCHAR2,
244 x_crev_curr_period OUT NOCOPY VARCHAR2,
245 x_crev_prev_mthd OUT NOCOPY VARCHAR2,
246 x_crev_prev_calendar OUT NOCOPY VARCHAR2,
247 x_crev_prev_period OUT NOCOPY VARCHAR2,
248 */
249 x_inv_fiscal_year OUT NOCOPY NUMBER,
250 x_inv_period OUT NOCOPY NUMBER,
251 x_retstatus OUT NOCOPY VARCHAR2,
252 x_errbuf OUT NOCOPY VARCHAR2
253 );
254
255 PROCEDURE populate_global (
256 p_legal_entity_id IN VARCHAR2
257 , p_ledger_id IN VARCHAR2
258 , p_cost_type_id IN VARCHAR2
259 , p_post_cm IN VARCHAR2
260 , p_crev_curr_calendar IN VARCHAR2
261 , p_crev_curr_period IN VARCHAR2
262 , p_crev_prev_cost_type_id IN VARCHAR2
263 , p_crev_prev_calendar IN VARCHAR2
264 , p_crev_prev_period IN VARCHAR2
265 , p_crev_gl_trans_date IN VARCHAR2
266 )
267 ;
268
269 END gmf_subledger_pkg;