[Home] [Help]
PACKAGE: APPS.JA_CN_ETC_CONC_PROG
Source
1 PACKAGE Ja_Cn_Etc_Conc_Prog AUTHID CURRENT_USER AS
2 --$Header: JACNETCS.pls 120.0.12000000.1 2007/08/13 14:09:33 qzhao noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNETCS.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This is a wrapper package for submission of export
14 --| statement related concurrent programs
15 --|
16 --|
17 --| PROCEDURE LIST
18 --| itemize_ap_journals;
19 --| itemize_ar_journals;
20 --| itemize_pa_journals;
21 --| itemize_po_journals;
22 --| itemize_inv_journals;
23 --| itemize_fa_journals;
24 --| transfer_gl_journals;
25 --| get_description_from_gis;
26 --| post_journal_itemized;
27 --| EAB_Export;
28 --| MultiOrg_Maintain;
29 --| Export_Coa
30 --| Ent_GSSM_Export
31 --| Pub_GSSM_Export
32 --| JOURNAL_ENTRY_EXPORT
33 --| ACCOUNT_BALANCE_EXPORT
34 --| JOURNAL_ENTRY_GENERATION
35 --| ACCOUNT_BALANCE_GENERATION
36 --|
37 --| HISTORY
38 --| 29-Mar-2006 Qingjun Zhao Created
39 -- 29-Mar-2006 Jackey Li Added two procedures
40 --| EAB_Export and MultiOrg_Maintain
41 --| 29-Mar-2006 Andrew Liu Added Export_Coa
42 --| 17-May-2006 Andrew Liu Added Ent_GSSM_Export and Pub_GSSM_Export
43 --| 19-Jun-2006 Joseph Wang added JOURNAL_ENTRY_EXPORT and ACCOUNT_BALANCE_EXPORT
44 --| 20-Jun-2006 Jackey Li added one procedure EAB_Export_Wrapper
45 --| 21-Jun-2006 Joseph Wang added JOURNAL_ENTRY_GENERATION and ACCOUNT_BALANCE_GENERATION
46 --+======================================================================*/
47
48 --==========================================================================
49 -- PROCEDURE NAME:
50 --
51 -- transfer_gl_sla_to_cnao Public
52 --
53 -- DESCRIPTION:
54 --
55 -- The 'transfer_gl_sla_to_cnao' procedure accepts parameters from
56 -- concurrent program 'Account and Journal Itemization Program' and
57 -- calls another procedure
58 -- 'JA_CN_ACC_JE_ITEMIZATION_PKG.transfer_gl_sla_to_cnao'
59 -- with parameters after processing.
60 --
61 -- PARAMETERS:
62 -- In: p_legal_entity_id Identifier of legal entity
63 -- parameter for FSG report
64 -- p_period_name GL period Name
65 --
66 -- Out: errbuf
67 -- retcode
68 --
69 --
70 -- DESIGN REFERENCES:
71 --
72 --
73 -- CHANGE HISTORY:
74 --
75 -- 29-Mar-2006 Qingjun Zhao Created
76 --
77 --===========================================================================
78
79 PROCEDURE Transfer_Gl_Sla_To_Cnao(Errbuf OUT NOCOPY VARCHAR2,
80 Retcode OUT NOCOPY VARCHAR2,
81 p_Chart_Of_Accounts_Id IN NUMBER,
82 p_Ledger_Id IN NUMBER,
83 p_Legal_Entity_Id IN NUMBER,
84 p_Period_Name IN VARCHAR2);
85
86 --==========================================================================
87 -- PROCEDURE NAME:
88 -- itemize_ap_journals Public
89 --
90 -- -- DESCRIPTION:
91 --
92 -- The 'itemize_ap_journals' procedure accepts parameters from
93 -- concurrent program 'Itemization program - Journals from Payables' and
94 -- calls another procedure
95 -- 'ja_cn_itemize_ap_journals_pkg.itemize_ap_journals'
96 -- with parameters after processing.
97 --
98 -- PARAMETERS:
99 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
100 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
101 -- In: p_project_option project source which is defined in
102 -- GDF of SOB
103 -- In: p_request_id identifier of Current request
104 -- DESIGN REFERENCES:
105 -- None
106 --
107 -- CHANGE HISTORY:
108 -- 29-Mar-2006 Qingjun Zhao Created
109 --===========================================================================
110 --==========================================================================
111 -- PROCEDURE NAME:
112 -- transfer_gl_journals Public
113 --
114 -- -- DESCRIPTION:
115 --
116 -- The 'transfer_gl_journals' procedure accepts parameters from
117 -- concurrent program 'Itemization program - Journals from General Ledger'
118 -- and calls another procedure
119 -- 'JA_CN_ACC_JE_ITEMIZATION_PKG.transfer_gl_journals'
120 -- with parameters after processing.
121 --
122 -- PARAMETERS:
123 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
124 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
125 -- In: p_project_option project source which is defined in
126 -- GDF of SOB
127 -- In: p_request_id identifier of Current request
128 -- DESIGN REFERENCES:
129 -- None
130 --
131 -- CHANGE HISTORY:
132 -- 29-Mar-2006 Qingjun Zhao Created
133 --===========================================================================
134 /*
135 PROCEDURE transfer_gl_journals (
136 errbuf OUT NOCOPY VARCHAR2
137 ,retcode OUT NOCOPY VARCHAR2
138 ,p_project_option IN VARCHAR2
139 ,p_request_id IN NUMBER
140 );
141 */
142 --==========================================================================
143 -- PROCEDURE NAME:
144 -- get_description_from_gis Public
145 --
146 -- -- DESCRIPTION:
147 --
148 -- The 'get_description_from_gis' procedure accepts parameters from
149 -- concurrent program 'Itemization program - Journals from Inter-company'
150 -- and calls another procedure
151 -- 'JA_CN_ACC_JE_ITEMIZATION_PKG.get_description_from_gis'
152 -- with parameters after processing.
153 --
154 -- PARAMETERS:
155 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
156 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
157 -- In: p_project_option project source which is defined in
158 -- GDF of SOB
159 -- In: p_request_id identifier of Current request
160 -- DESIGN REFERENCES:
161 -- None
162 --
163 -- CHANGE HISTORY:
164 -- 29-Mar-2006 Qingjun Zhao Created
165 --===========================================================================
166 /*
170 ,p_project_option IN VARCHAR2
167 PROCEDURE get_description_from_gis (
168 errbuf OUT NOCOPY VARCHAR2
169 ,retcode OUT NOCOPY VARCHAR2
171 ,p_request_id IN NUMBER
172 );
173 */
174 --==========================================================================
175 -- PROCEDURE NAME:
176 -- post_journal_itemized Public
177 --
178 -- DESCRIPTION:
179 -- The ' post_journal_itemized' procedure accepts parameters from
180 -- concurrent program 'Post itemized journals'
181 -- and calls another procedure
182 -- 'JA_CN_POST_UTILITY_PK.post_journal_itemized'
183 -- with parameters after processing.
184 --
185 -- PARAMETERS:
186 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
187 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
188 -- In: p_period_name the end period name in which
189 -- the CNAO journal should be processed
190 -- p_ledger_id ledger ID
191 -- p_legal_entity_ID Legal entity id
192
193 --
194 -- DESIGN REFERENCES:
195 -- None
196 --
197 -- CHANGE HISTORY:
198 -- 29-Mar-2006 Qingjun Zhao Created
199 -- 28-Apr-2007 Qingjun Zhao Change SOB to Ledger for upgrade
200 -- from 11i to R12
201 --===========================================================================
202
203 PROCEDURE Post_Journal_Itemized(Errbuf OUT NOCOPY VARCHAR2,
204 Retcode OUT NOCOPY VARCHAR2,
205 p_Period_Name IN VARCHAR2,
206 p_ledger_Id IN NUMBER,
207 p_Legal_Entity_Id IN NUMBER);
208
209 --==========================================================================
210 -- PROCEDURE NAME:
211 -- EAB_Export Public
212 --
213 -- DESCRIPTION:
214 -- This procedure accepts parameters from concurrent program
215 -- 'Electronic Accounting Book Export'
216 -- and calls another procedure 'JA_CN_EAB_EXPORT_PKG.Execute_Export'
217 -- with parameters after processing.
218 --
219 -- PARAMETERS:
220 -- In: P_COA_ID Current chart of accounts ID
221 -- p_le_id current legal entity ID
222 -- P_LEDGER_ID Current ledger ID
223 -- p_fiscal_year fiscal year under current sob
224 --
225 -- Out: errbuf
226 -- retcode
227 --
228 -- DESIGN REFERENCES:
229 -- CNAO_Electronic_Accounting_Book_Export.doc
230 --
231 -- CHANGE HISTORY:
232 -- 03/29/2006 Jackey Li Created
233 -- 05/09/2007 Yucheng Sun Updated
234 --===========================================================================
235
236 PROCEDURE EAB_Export(ERRBUF OUT NOCOPY VARCHAR2
237 ,RETCODE OUT NOCOPY VARCHAR2
238 ,P_COA_ID IN NUMBER
239 ,P_LE_ID IN NUMBER
240 ,P_LEDGER_ID IN NUMBER
241 ,p_fiscal_year VARCHAR2);
242
243 --==========================================================================
244 -- PROCEDURE NAME:
245 -- EAB_Export_Wrapper Public
246 --
247 -- DESCRIPTION:
248 --
249 --
250 -- PARAMETERS:
251 -- In: P_COA_ID current chart of accounts ID
252 -- p_ledger_id current ledger ID
253 -- p_le_id current legal entity ID
254 -- p_fiscal_year fiscal year under current sob
255 -- p_src_charset
256 -- p_dest_charset
257 -- p_separator
258 -- p_file_name
259 --
260 -- Out: errbuf
261 -- retcode
262 --
263 -- DESIGN REFERENCES:
264 -- CNAO_Electronic_Accounting_Book_Export.doc
265 --
266 -- CHANGE HISTORY:
267 -- 03/29/2006 Jackey Li Created
268 -- 05/09/2007 Yucheng Sun Updated
269 --===========================================================================
270 PROCEDURE Eab_Export_Wrapper(Errbuf OUT NOCOPY VARCHAR2,
271 Retcode OUT NOCOPY VARCHAR2,
272 P_COA_Id IN NUMBER,
273 p_Le_Id IN NUMBER,
274 p_ledger_id IN NUMBER,
275 p_Fiscal_Year IN VARCHAR2,
276 p_Src_Charset IN VARCHAR2,
277 p_Dest_Charset IN VARCHAR2,
278 p_Separator IN VARCHAR2,
279 p_File_Name IN VARCHAR2);
280
281 --==========================================================================
282 -- PROCEDURE NAME:
283 -- MultiOrg_Maintain Public
284 --
285 -- DESCRIPTION:
286 -- This procedure accepts parameters from concurrent program
287 -- 'Multi-Tiers Organization Maintenance'
288 -- and calls another procedure 'JA_CN_MAINTAIN_MULTIORG_PKG.Execute_Maintenance'
289 -- with parameters after processing.
290 --
291 -- PARAMETERS:
295 -- retcode
292 -- In: p_le_id current legal entity ID
293 --
294 -- Out: errbuf
296 --
297 -- DESIGN REFERENCES:
298 -- CNAO_Multi-Tiers_Organization_Maintenance_TD.doc
299 --
300 -- CHANGE HISTORY:
301 -- 03/29/2006 Jackey Li Created
302 --===========================================================================
303 /*
304 PROCEDURE MultiOrg_Maintain(ERRBUF OUT NOCOPY VARCHAR2
305 ,RETCODE OUT NOCOPY VARCHAR2
306 ,p_le_id NUMBER);
307 */
308 --==========================================================================
309 -- PROCEDURE NAME:
310 -- Export_Coa Public
311 --
312 -- DESCRIPTION:
313 -- This procedure checks profile and General Information of
314 -- System Options Form, then calls program of COA Export, including
315 -- Natural Account and 4 Subsidiary Account of "Project", "Third Party",
316 -- "Cost Center" and "Personnel".
317 --
318 -- PARAMETERS:
319 -- Out: errbuf NOCOPY VARCHAR2
320 -- Out: retcode NOCOPY VARCHAR2
321 -- In: P_COA_ID NUMBER Chart of account ID
322 -- In: P_LE_ID NUMBER ID of Legal Entity
323 -- In: p_Ledger_Id NUMBER ID of ledger
324 -- In: P_ACCOUNT_TYPE VARCHAR2 Type of the account
325 -- In: P_XML_TEMPLATE_LANGUAGE VARCHAR2 template language of NA exception report
326 -- In: P_XML_TEMPLATE_TERRITORY VARCHAR2 template territory of NA exception report
327 -- In: P_XML_OUTPUT_FORMAT VARCHAR2 output format of NA exception report
328 --
329 -- DESIGN REFERENCES:
330 -- None
331 --
332 -- CHANGE HISTORY:
333 -- 03/03/2006 Andrew Liu Created
334 -- 04/24/2007 Yucheng Sun Updated: add ledger id
335 --===========================================================================
336 PROCEDURE Export_Coa(errbuf OUT NOCOPY VARCHAR2,
337 retcode OUT NOCOPY VARCHAR2,
338 P_COA_ID IN NUMBER,
339 P_LE_ID IN NUMBER,
340 p_Ledger_Id IN NUMBER,
341 P_ACCOUNT_TYPE IN VARCHAR2,
342 P_XML_TEMPLATE_LANGUAGE IN VARCHAR2 default 'zh',
343 P_XML_TEMPLATE_TERRITORY IN VARCHAR2 default '00',
344 P_XML_OUTPUT_FORMAT IN VARCHAR2 default 'RTF');
345
346 --==========================================================================
347 -- PROCEDURE NAME:
348 -- Export_Coa_Entry Public
349 --
350 -- DESCRIPTION:
351 -- This procedure submits the program of COA Exports, and then changes
352 -- the output file's CharSet and file name.
353 --
354 -- PARAMETERS:
355 -- Out: errbuf NOCOPY VARCHAR2
356 -- Out: retcode NOCOPY VARCHAR2
357 -- In: P_COA_ID NUMBER Chart of accounts ID
358 -- In: P_LE_ID NUMBER ID of Legal Entity
359 -- In: P_ACCOUNT_TYPE VARCHAR2 Type of the account
360 -- In: P_SOURCE_CHARSET VARCHAR2 source charset for convert
361 -- In: P_DESTINATION_CHARSET VARCHAR2 destination charset for convert
362 -- In: P_SOURCE_SEPARATOR VARCHAR2 source separator for replacement
363 -- In: P_DESTINATION_FILENAME VARCHAR2 output file name
364 -- In: P_XML_TEMPLATE_LANGUAGE VARCHAR2 template language of NA exception report
365 -- In: P_XML_TEMPLATE_TERRITORY VARCHAR2 template territory of NA exception report
366 -- In: P_XML_OUTPUT_FORMAT VARCHAR2 output format of NA exception report
367 --
368 -- DESIGN REFERENCES:
369 -- None
370 --
371 -- CHANGE HISTORY:
372 -- 03/03/2006 Andrew Liu Created
373 --===========================================================================
374 PROCEDURE Export_Coa_Entry(Errbuf OUT NOCOPY VARCHAR2,
375 Retcode OUT NOCOPY VARCHAR2,
376 P_COA_ID IN NUMBER,
377 p_Le_Id IN NUMBER,
378 p_Ledger_Id IN NUMBER,
379 p_Account_Type IN VARCHAR2,
380 p_Source_Charset IN VARCHAR2,
381 p_Destination_Charset IN VARCHAR2,
382 p_Source_Separator IN VARCHAR2,
383 p_Destination_Filename IN VARCHAR2,
384 p_Xml_Template_Language IN VARCHAR2 DEFAULT 'zh',
385 p_Xml_Template_Territory IN VARCHAR2 DEFAULT '00',
386 p_Xml_Output_Format IN VARCHAR2 DEFAULT 'RTF');
387
388 --==========================================================================
389 -- PROCEDURE NAME:
390 -- Ent_GSSM_Export Public
391 --
392 -- DESCRIPTION:
393 -- This procedure calls GSSM Export program to export GSSM for
394 -- Enterprise.
395 --
396 -- PARAMETERS:
397 -- Out: errbuf NOCOPY VARCHAR2
398 -- Out: retcode NOCOPY VARCHAR2
399 --
400 -- DESIGN REFERENCES:
401 -- None
402 --
403 -- CHANGE HISTORY:
404 -- 05/17/2006 Andrew Liu Created
405 --===========================================================================
406 PROCEDURE Ent_Gssm_Export(Errbuf OUT NOCOPY VARCHAR2,
410 -- PROCEDURE NAME:
407 Retcode OUT NOCOPY VARCHAR2);
408
409 --==========================================================================
411 -- Ent_GSSM_Export_Entry Public
412 --
413 -- DESCRIPTION:
414 -- This procedure submits the program of Enterprise's GSSM Export, and
415 -- then changes the output file's CharSet and file name.
416 --
417 -- PARAMETERS:
418 -- Out: errbuf NOCOPY VARCHAR2
419 -- Out: retcode NOCOPY VARCHAR2
420 -- In: P_SOURCE_CHARSET VARCHAR2 source charset for convert
421 -- In: P_DESTINATION_CHARSET VARCHAR2 destination charset for convert
422 -- In: P_SOURCE_SEPARATOR VARCHAR2 source separator for replacement
423 -- In: P_DESTINATION_FILENAME VARCHAR2 output file name
424 --
425 -- DESIGN REFERENCES:
426 -- None
427 --
428 -- CHANGE HISTORY:
429 -- 03/03/2006 Andrew Liu Created
430 --===========================================================================
431 PROCEDURE Ent_Gssm_Export_Entry(Errbuf OUT NOCOPY VARCHAR2,
432 Retcode OUT NOCOPY VARCHAR2,
433 p_Source_Charset IN VARCHAR2,
434 p_Destination_Charset IN VARCHAR2,
435 p_Source_Separator IN VARCHAR2,
436 p_Destination_Filename IN VARCHAR2);
437
438 --==========================================================================
439 -- PROCEDURE NAME:
440 -- Pub_GSSM_Export Public
441 --
442 -- DESCRIPTION:
443 -- This procedure calls GSSM Export program to export GSSM for
444 -- Public Sector.
445 --
446 -- PARAMETERS:
447 -- Out: errbuf NOCOPY VARCHAR2
448 -- Out: retcode NOCOPY VARCHAR2
449 --
450 -- DESIGN REFERENCES:
451 -- None
452 --
453 -- CHANGE HISTORY:
454 -- 05/17/2006 Andrew Liu Created
455 --===========================================================================
456 PROCEDURE Pub_Gssm_Export(Errbuf OUT NOCOPY VARCHAR2,
457 Retcode OUT NOCOPY VARCHAR2);
458
459 --==========================================================================
460 -- PROCEDURE NAME:
461 -- Pub_GSSM_Export_Entry Public
462 --
463 -- DESCRIPTION:
464 -- This procedure submits the program of Public Sector's GSSM Export, and
465 -- then changes the output file's CharSet and file name.
466 --
467 -- PARAMETERS:
468 -- Out: errbuf NOCOPY VARCHAR2
469 -- Out: retcode NOCOPY VARCHAR2
470 -- In: P_SOURCE_CHARSET VARCHAR2 source charset for convert
471 -- In: P_DESTINATION_CHARSET VARCHAR2 destination charset for convert
472 -- In: P_SOURCE_SEPARATOR VARCHAR2 source separator for replacement
473 -- In: P_DESTINATION_FILENAME VARCHAR2 output file name
474 --
475 -- DESIGN REFERENCES:
476 -- None
477 --
478 -- CHANGE HISTORY:
479 -- 03/03/2006 Andrew Liu Created
480 --===========================================================================
481 PROCEDURE Pub_Gssm_Export_Entry(Errbuf OUT NOCOPY VARCHAR2,
482 Retcode OUT NOCOPY VARCHAR2,
483 p_Source_Charset IN VARCHAR2,
484 p_Destination_Charset IN VARCHAR2,
485 p_Source_Separator IN VARCHAR2,
486 p_Destination_Filename IN VARCHAR2);
487
488 --==========================================================================
489 -- PROCEDURE NAME:
490 --
491 -- ACCOUNT_BALANCE_EXPORT Public
492 --
493 -- DESCRIPTION:
494 --
495 -- This procedure is used to export the account balances.
496 --
497 --
498 -- PARAMETERS:
499 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
500 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
501 -- In: p_legal_entity Legal entity ID
502 -- In: p_start_period start period name
503 -- In: P_end_period end period name
504 -- In: P_XML_TEMPLATE_LANGUAGE template language of exception report
505 -- In: P_XML_TEMPLATE_TERRITORY template territory of exception report
506 -- In: P_XML_OUTPUT_FORMAT output format of exception report
507 -- In: P_SOURCE_CHARSET source charset for convert
508 -- In: P_DESTINATION_CHARSET destination charset for convert
509 -- In: P_SOURCE_SEPARATOR source separator for replacement
510 -- In: P_DESTINATION_FILENAME output file name
511 --
512 -- DESIGN REFERENCES:
513 --
514 --
515 -- CHANGE HISTORY:
516 --
517 -- 19-Jun-2006 Joseph Wang Created
518 -- 05-July-2006 Add parameters p_start_period and P_end_period
519 -- remove the parameter p_period
520 --===========================================================================
521 PROCEDURE Account_Balance_Export(Errbuf OUT NOCOPY VARCHAR2,
522 Retcode OUT NOCOPY VARCHAR2,
523 p_coa_id IN NUMBER, --added by lyb
524 p_ledger_id IN NUMBER, --added by lyb
525 p_Legal_Entity IN NUMBER,
526 p_Start_Period IN VARCHAR2,
527 p_End_Period IN VARCHAR2,
528 p_Xml_Template_Language IN VARCHAR2,
529 p_Xml_Template_Territory IN VARCHAR2,
530 p_Xml_Output_Format IN VARCHAR2,
531 p_Source_Charset VARCHAR2,
532 p_Destination_Charset VARCHAR2,
533 p_Source_Separator VARCHAR2,
534 p_Destination_Filename VARCHAR2);
535
536 --==========================================================================
537 -- PROCEDURE NAME:
538 --
539 -- ACCOUNT_BALANCE_GENERATION Public
540 --
541 -- DESCRIPTION:
542 --
543 -- This procedure is used to generate the account balances.
544 --
545 --
546 -- PARAMETERS:
547 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
548 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
549 -- In: p_legal_entity Legal entity ID
550 -- In: p_start_period start period name
551 -- In: P_end_period end period name
552 -- In: P_XML_TEMPLATE_LANGUAGE template language of exception report
553 -- In: P_XML_TEMPLATE_TERRITORY template territory of exception report
554 -- In: P_XML_OUTPUT_FORMAT output format of exception report
555 --
556 -- DESIGN REFERENCES:
557 --
558 --
559 -- CHANGE HISTORY:
560 --
561 -- 19-Jun-2006 Joseph Wang Created
562 -- 05-July-2006 Add parameters p_start_period and P_end_period
563 -- remove the parameter p_period
564 --===========================================================================
565
566 PROCEDURE Account_Balance_Generation(Errbuf OUT NOCOPY VARCHAR2,
567 Retcode OUT NOCOPY VARCHAR2,
568 p_coa_id IN NUMBER, --added by lyb
569 p_ledger_id IN NUMBER, --added by lyb
570 p_Legal_Entity IN NUMBER,
571 p_Start_Period IN VARCHAR2,
572 p_End_Period IN VARCHAR2,
573 p_Xml_Template_Language IN VARCHAR2,
574 p_Xml_Template_Territory IN VARCHAR2,
575 p_Xml_Output_Format IN VARCHAR2);
576
577 --==========================================================================
578 -- PROCEDURE NAME:
579 --
580 -- JOURNAL_ENTRY_EXPORT Public
581 --
582 -- DESCRIPTION:
583 --
584 -- This procedure is used to export the journal entries.
585 --
586 --
587 -- PARAMETERS:
588 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
589 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
590 -- In: p_legal_entity Legal entity ID
591 -- In: p_start_period start period name
592 -- In: P_end_period end period name
593 -- In: P_SOURCE_CHARSET source charset for convert
594 -- In: P_DESTINATION_CHARSET destination charset for convert
595 -- In: P_SOURCE_SEPARATOR source separator for replacement
596 -- In: P_DESTINATION_FILENAME output file name
597 --
598 -- DESIGN REFERENCES:
599 --
600 --
601 -- CHANGE HISTORY:
602 --
603 -- 01-Mar-2006 Joseph Wang Created
604 -- 15-Jun-2006 Add parameters P_XML_TEMPLATE_LANGUAGE, P_XML_TEMPLATE_TERRITORY, P_XML_OUTPUT_FORMAT
605 -- 19-Jun-2006 Add parameters P_SOURCE_CHARSET, P_DESTINATION_CHARSET,P_SOURCE_SEPARATOR,
606 -- P_DESTINATION_FILENAME
607 -- 05-July-2006 Add parameters p_start_period and P_end_period
608 -- remove the parameter p_period
609 --
610 --===========================================================================
611
612 PROCEDURE Journal_Entry_Export(Errbuf OUT NOCOPY VARCHAR2,
613 Retcode OUT NOCOPY VARCHAR2,
614 p_coa_id IN NUMBER, --added by lyb
615 p_ledger_id IN NUMBER, --added by lyb
616 p_Legal_Entity IN NUMBER,
617 p_Start_Period IN VARCHAR2,
618 p_End_Period IN VARCHAR2,
619 p_Source_Charset VARCHAR2,
620 p_Destination_Charset VARCHAR2,
621 p_Source_Separator VARCHAR2,
622 p_Destination_Filename VARCHAR2);
623
624 --==========================================================================
625 -- PROCEDURE NAME:
626 --
627 -- JOURNAL_ENTRY_GENERATION Public
628 --
629 -- DESCRIPTION:
630 --
631 -- This procedure is used to generate the journal entries.
632 --
633 --
634 -- PARAMETERS:
635 -- Out: errbuf Mandatory parameter for PL/SQL concurrent programs
636 -- Out: retcode Mandatory parameter for PL/SQL concurrent programs
637 -- In: p_legal_entity Legal entity ID
638 -- In: p_start_period start period name
639 -- In: P_end_period end period name
640 --
641 -- DESIGN REFERENCES:
642 --
643 --
644 -- CHANGE HISTORY:
645 --
646 -- 01-Mar-2006 Joseph Wang Created
647 -- 15-Jun-2006 Add parameters P_XML_TEMPLATE_LANGUAGE, P_XML_TEMPLATE_TERRITORY, P_XML_OUTPUT_FORMAT
648 -- 19-Jun-2006 Add parameters P_SOURCE_CHARSET, P_DESTINATION_CHARSET,P_SOURCE_SEPARATOR,
649 -- P_DESTINATION_FILENAME
650 -- 05-July-2006 Add parameters p_start_period and P_end_period
651 -- remove the parameter p_period
652 --
656 p_coa_id IN NUMBER,
653 --===========================================================================
654 PROCEDURE JOURNAL_ENTRY_GENERATION(errbuf OUT NOCOPY VARCHAR2,
655 retcode OUT NOCOPY VARCHAR2,
657 p_ledger_id IN NUMBER ,
658 p_legal_entity IN NUMBER,
659 p_start_period IN VARCHAR2,
660 p_end_period IN VARCHAR2) ;
661
662 END Ja_Cn_Etc_Conc_Prog;
663