1 PACKAGE JA_CN_GL_EXPORT_REPORT_PROG AUTHID CURRENT_USER AS
2 --$Header: JACNGLPS.pls 120.1 2010/03/31 02:20:58 wuwu noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNGLPS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export report for general ledger |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Submit_Request |
16 --| |
17 --| |
18 --| HISTORY |
19 --| 01-Mar-2010 Chaoqun Wu Created |
20 --+======================================================================*/
21
22 --==========================================================================
23 -- PROCEDURE NAME:
24 --
25 -- Submit_Request Public
26 --
27 -- DESCRIPTION:
28 --
29 -- This procedure is to export report for general ledger
30 --
31 -- PARAMETERS:
32 -- Out: pv_errbuf NOCOPY VARCHAR2
33 -- pv_retcode NOCOPY VARCHAR2
34 -- In: pn_legal_entity_id NUMBER identifier of legal entity
35 -- pn_chart_of_account_id NUMBER identifier of chart of account
36 -- pn_ledger_id NUMBER identifier of ledger
37 -- pv_adhoc_prefix VARCHAR2 adhoc prefix
38 -- pv_industry VARCHAR2 industry
39 -- pv_accounting_year VARCHAR2 accounting year
40 -- pv_period_from VARCHAR2 period from
41 -- pv_period_to VARCHAR2 period to
42 -- pn_cfs_report_id NUMBER identifier of cfs report
43 -- pn_ps_report_id NUMBER identifier of profit statment report
44 -- pn_oe_report_id NUMBER identifier of Statement of changes in owners' equity Report
45 -- pv_currency_unit VARCHAR2 currency unit
46 -- pv_source_char_set VARCHAR2 source character set
47 -- pv_dest_char_set VARCHAR2 destination character set
48 -- pv_source_separator VARCHAR2 source separator
49 -- pn_data_access_set_id NUMBER identifier of data access set
50 -- pv_flex_code VARCHAR2 flex code
51 -- pv_default_ledger_short_name VARCHAR2 defualt ledger short name
52 -- pv_output_option VARCHAR2 output option
53 -- pv_exceptions_flag VARCHAR2 exceptions flag
54 -- pn_page_length NUMBER page length
55 -- pn_subrequest_id NUMBER identifier of subrequest
56 -- pv_appl_deflt_name VARCHAR2 application default name
57 -- pv_balance_type VARCHAR2 balance type
58 -- pv_xml_template_language VARCHAR2 xml template language
59 -- pv_xml_template_territory VARCHAR2 xml template territory
60 -- pv_xml_output_format VARCHAR2 xml output format
61 -- pn_csf_report_num NUMBER cfs report number
62 -- pn_balance_sheet_num NUMBER balance sheet number
63 -- pn_profit_statement_num NUMBER profit statement number
64 -- pn_owners_equity_num NUMBER number of Statement of changes in owners' equity Report
65 -- pv_accounting_date VARCHAR2 accounting date
66 --
67 -- DESIGN REFERENCES:
68 -- GL_Chaoqun.doc
69 --
70 -- CHANGE HISTORY:
71 -- 01-Mar-2010 Chaoqun Wu created
72 --==========================================================================
73
74 PROCEDURE Submit_Request
75 (pv_errbuf OUT NOCOPY VARCHAR2
76 ,pv_retcode OUT NOCOPY VARCHAR2
77 ,pn_legal_entity_id IN NUMBER
78 ,pn_chart_of_account_id IN NUMBER
79 ,pn_ledger_id IN NUMBER
80 ,pv_adhoc_prefix IN VARCHAR2
81 ,pv_industry IN VARCHAR2
82 ,pv_accounting_year IN VARCHAR2
83 ,pv_period_from IN VARCHAR2
84 ,pv_period_to IN VARCHAR2
85 ,pn_cfs_report_id IN NUMBER
86 ,pn_bs_report_id IN NUMBER
87 ,pn_ps_report_id IN NUMBER
88 ,pn_oe_report_id IN NUMBER
89 ,pv_currency_unit IN VARCHAR2
90 ,pv_source_char_set IN VARCHAR2
91 ,pv_dest_char_set IN VARCHAR2
92 ,pv_source_separator IN VARCHAR2
93 ,pn_data_access_set_id IN NUMBER
94 ,pv_flex_code IN VARCHAR2
95 ,pv_default_ledger_short_name IN VARCHAR2
96 ,pv_output_option IN VARCHAR2
97 ,pv_exceptions_flag IN VARCHAR2
98 ,pn_page_length IN NUMBER
99 ,pn_subrequest_id IN NUMBER
100 ,pv_appl_deflt_name IN VARCHAR2
101 ,pv_balance_type IN VARCHAR2
102 ,pv_xml_template_language IN VARCHAR2
103 ,pv_xml_template_territory IN VARCHAR2
104 ,pv_xml_output_format IN VARCHAR2
105 ,pn_csf_report_num IN NUMBER
106 ,pn_balance_sheet_num IN NUMBER
107 ,pn_profit_statement_num IN NUMBER
108 ,pn_owners_equity_num IN NUMBER
109 ,pv_accounting_date IN VARCHAR2
110 );
111
112 END JA_CN_GL_EXPORT_REPORT_PROG;