1 PACKAGE JA_CN_PS_GL_EXPORT_PROG AUTHID CURRENT_USER AS
2 --$Header: JACNPGLS.pls 120.1 2010/09/02 07:37:19 wuwu noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNPGLS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export report for General Ledger (Public |
13 --| Sector) |
14 --| |
15 --| PROCEDURE LIST |
16 --| PROCEDURE Export_GL |
17 --| PROCEDURE Submit_Request |
18 --| |
19 --| |
20 --| HISTORY |
21 --| 06-Aug-2010 Chaoqun Wu Created |
22 --+======================================================================*/
23
24 --==========================================================================
25 -- PROCEDURE NAME:
26 --
27 -- Export_GL Public
28 --
29 -- DESCRIPTION:
30 --
31 -- This procedure is to export non-FSG report for general ledger (public sector)
32 --
33 -- PARAMETERS:
34 -- Out: pv_errbuf NOCOPY VARCHAR2
35 -- pv_retcode NOCOPY VARCHAR2
36 -- In: pn_legal_entity_id NUMBER identifier of legal entity
37 -- pn_chart_of_account_id NUMBER identifier of chart of account
38 -- pn_ledger_id NUMBER identifier of ledger
39 -- pv_accounting_year VARCHAR2 accounting year
40 -- pv_period_from VARCHAR2 period from
41 -- pv_period_to VARCHAR2 period to
42 -- pv_xml_template_language VARCHAR2 xml template language
43 -- pv_xml_template_territory VARCHAR2 xml template territory
44 -- pv_xml_output_format VARCHAR2 xml output format
45 --
46 -- DESIGN REFERENCES:
47 -- TDD_1213_FIN_GL_P_CNAOV2_GL.doc
48 --
49 -- CHANGE HISTORY:
50 -- 06-Aug-2010 Chaoqun Wu created
51 --==========================================================================
52 PROCEDURE Export_GL
53 (pv_errbuf OUT NOCOPY VARCHAR2
54 ,pv_retcode OUT NOCOPY VARCHAR2
55 ,pn_legal_entity_id IN NUMBER
56 ,pn_chart_of_account_id IN NUMBER
57 ,pn_ledger_id IN NUMBER
58 ,pv_accounting_year IN VARCHAR2
59 ,pv_period_from IN VARCHAR2
60 ,pv_period_to IN VARCHAR2
61 ,pv_xml_template_language IN VARCHAR2
62 ,pv_xml_template_territory IN VARCHAR2
63 ,pv_xml_output_format IN VARCHAR2
64 );
65
66 --==========================================================================
67 -- PROCEDURE NAME:
68 --
69 -- Submit_Request Public
70 --
71 -- DESCRIPTION:
72 --
73 -- This procedure is to export report for general ledger
74 --
75 -- PARAMETERS:
76 -- Out: pv_errbuf NOCOPY VARCHAR2
77 -- pv_retcode NOCOPY VARCHAR2
78 -- In: pn_legal_entity_id NUMBER identifier of legal entity
79 -- pn_chart_of_account_id NUMBER identifier of chart of account
80 -- pn_ledger_id NUMBER identifier of ledger
81 -- pv_adhoc_prefix VARCHAR2 adhoc prefix
82 -- pv_industry VARCHAR2 industry
83 -- pv_accounting_year VARCHAR2 accounting year
84 -- pv_period_from VARCHAR2 period from
85 -- pv_period_to VARCHAR2 period to
86 -- pn_bs_report_id NUMBER identifier of balance sheet report
87 -- pn_re_report_id NUMBER identifier of revenue and expenditure report
88 -- pn_ed_report_id NUMBER identifier of expenditure detail report
89 -- pv_currency_unit VARCHAR2 currency unit
90 -- pv_dest_char_set VARCHAR2 destination character set
91 -- pv_source_separator VARCHAR2 source separator
92 -- pn_data_access_set_id NUMBER identifier of data access set
93 -- pv_flex_code VARCHAR2 flex code
94 -- pv_default_ledger_short_name VARCHAR2 defualt ledger short name
95 -- pv_output_option VARCHAR2 output option
96 -- pv_exceptions_flag VARCHAR2 exceptions flag
97 -- pn_page_length NUMBER page length
98 -- pn_subrequest_id NUMBER identifier of subrequest
99 -- pv_appl_deflt_name VARCHAR2 application default name
100 -- pv_xml_template_language VARCHAR2 xml template language
101 -- pv_xml_template_territory VARCHAR2 xml template territory
102 -- pv_xml_output_format VARCHAR2 xml output format
103 -- pn_balance_sheet_num NUMBER balance sheet number
104 -- pn_revenue_exp_num NUMBER revenue and expenditure number
105 -- pn_exp_detail_num NUMBER number of expenditure detail report
106 --
107 -- DESIGN REFERENCES:
108 -- TDD_1213_FIN_GL_P_CNAOV2_GL.doc
109 --
110 -- CHANGE HISTORY:
111 -- 06-Aug-2010 Chaoqun Wu created
112 --==========================================================================
113 PROCEDURE Submit_Request
114 (pv_errbuf OUT NOCOPY VARCHAR2
115 ,pv_retcode OUT NOCOPY VARCHAR2
116 ,pn_legal_entity_id IN NUMBER
117 ,pn_coa_id IN NUMBER
118 ,pn_ledger_id IN NUMBER
119 ,pv_adhoc_prefix IN VARCHAR2
120 ,pv_industry IN VARCHAR2
121 ,pv_accounting_year IN VARCHAR2
122 ,pv_period_from IN VARCHAR2
123 ,pv_period_to IN VARCHAR2
124 ,pn_bs_report_id IN NUMBER
125 ,pn_re_report_id IN NUMBER
126 ,pn_ed_report_id IN NUMBER
127 ,pv_currency_unit IN VARCHAR2
128 ,pv_dest_char_set IN VARCHAR2
129 ,pv_source_separator IN VARCHAR2
130 ,pn_data_access_set_id IN NUMBER
131 ,pv_flex_code IN VARCHAR2
132 ,pv_default_ledger_short_name IN VARCHAR2
133 ,pv_output_option IN VARCHAR2
134 ,pv_exceptions_flag IN VARCHAR2
135 ,pn_page_length IN NUMBER
136 ,pn_subrequest_id IN NUMBER
137 ,pv_appl_deflt_name IN VARCHAR2
138 ,pv_xml_template_language IN VARCHAR2
139 ,pv_xml_template_territory IN VARCHAR2
140 ,pv_xml_output_format IN VARCHAR2
141 ,pn_balance_sheet_num IN NUMBER
142 ,pn_revenue_exp_num IN NUMBER
143 ,pn_exp_detail_num IN NUMBER
144 );
145
146 END JA_CN_PS_GL_EXPORT_PROG;