[Home] [Help]
PACKAGE: APPS.JA_CN_GL_BANK_EXP_PKG
Source
1 PACKAGE JA_CN_GL_BANK_EXP_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNGBES.pls 120.0.12020000.2 2013/02/06 08:59:02 chongwan noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNGBES.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export non-FSG report for general ledger |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Export_GL |
16 --| Add_GL_BALANCE |
17 --| Add_GL_AVG_BAL |
18 --| Add_GL_JOURNAL |
19 --| |
20 --| |
21 --| DESIGN REFERENCES: |
22 --| China General Ledger Data Export (Banking)_TD |
23 --| HISTORY |
24 --| 19-Oct-2012 Jar Wang Created |
25 --+======================================================================*/
26
27 --==========================================================================
28 -- PROCEDURE NAME:
29 --
30 -- Export_GL Public
31 --
32 -- DESCRIPTION:
33 --
34 -- This procedure is to export non-FSG report for general ledger
35 --
36 -- PARAMETERS:
37 -- Out: pv_errbuf NOCOPY VARCHAR2
38 -- pv_retcode NOCOPY VARCHAR2
39 -- In: pn_legal_entity_id NUMBER identifier of legal entity
40 -- pn_chart_of_account_id NUMBER identifier of chart of account
41 -- pn_ledger_id NUMBER identifier of ledger
42 -- pv_bsv VARCHAR2 balance segment value
43 -- pv_adhoc_prefix VARCHAR2 adhoc prefix
44 -- pv_industry VARCHAR2 industry
45 -- pv_accounting_year VARCHAR2 accounting year
46 -- pv_period_from VARCHAR2 period from
47 -- pv_period_to VARCHAR2 period to
48 -- pn_cfs_report_id NUMBER identifier of cfs report
49 -- pv_xml_template_language VARCHAR2 xml template language
50 -- pv_xml_template_territory VARCHAR2 xml template territory
51 -- pv_xml_output_format VARCHAR2 xml output format
52 --
53 --
54 -- CHANGE HISTORY:
55 -- 19-Oct-2012 Jar Wang created
56 --==========================================================================
57
58 PROCEDURE Export_GL(pv_errbuf OUT NOCOPY VARCHAR2,
59 pv_retcode OUT NOCOPY VARCHAR2,
60 pn_chart_of_account_id IN NUMBER,
61 pn_ledger_id IN NUMBER,
62 pn_legal_entity_id IN NUMBER,
63 pv_bsv IN VARCHAR2,
64 pv_adhoc_prefix IN VARCHAR2,
65 pv_industry IN VARCHAR2,
66 pv_accounting_year IN VARCHAR2,
67 pv_period_from IN VARCHAR2,
68 pv_period_to IN VARCHAR2,
69 pn_cfs_report_id IN NUMBER,
70 pv_xml_template_language IN VARCHAR2,
71 pv_xml_template_territory IN VARCHAR2,
72 pv_xml_output_format IN VARCHAR2);
73
74 --==========================================================================
75 -- PROCEDURE NAME:
76 --
77 -- Add_GL_BALANCE Public
78 --
79 -- DESCRIPTION:
80 --
81 -- This procedure is to export non-FSG report for general ledger balance
82 --
83 -- PARAMETERS:
84 -- Out: pv_errbuf NOCOPY VARCHAR2
85 -- pv_retcode NOCOPY VARCHAR2
86 -- In: pn_legal_entity_id NUMBER identifier of legal entity
87 -- pn_chart_of_account_id NUMBER identifier of chart of account
88 -- pn_ledger_id NUMBER identifier of ledger
89 -- pv_bsv VARCHAR2 balance segment value
90 -- pv_accounting_year VARCHAR2 accounting year
91 -- pv_start VARCHAR2 period from
92 -- pv_end VARCHAR2 period to
93 --
94 --
95 -- CHANGE HISTORY:
96 -- 25-Oct-2012 Jar Wang created
97 --==========================================================================
98 PROCEDURE Print_GL_BALANCE;
99 PROCEDURE Add_GL_BALANCE(pn_chart_of_account_id IN NUMBER,
100 pn_ledger_id IN NUMBER,
101 pn_legal_entity_id IN NUMBER,
102 pv_bsv IN VARCHAR2,
103 pv_accounting_year IN VARCHAR2,
104 pv_start IN VARCHAR2,
105 pv_end IN VARCHAR2);
106
107 --==========================================================================
108 -- PROCEDURE NAME:
109 --
110 -- Add_GL_AVG_BAL Public
111 --
112 -- DESCRIPTION:
113 --
114 -- This procedure is to export non-FSG report for general ledger average balance
115 --
116 -- PARAMETERS:
117 -- Out: pv_errbuf NOCOPY VARCHAR2
118 -- pv_retcode NOCOPY VARCHAR2
119 -- In: pn_legal_entity_id NUMBER identifier of legal entity
120 -- pn_chart_of_account_id NUMBER identifier of chart of account
121 -- pn_ledger_id NUMBER identifier of ledger
122 -- pv_bsv VARCHAR2 balance segment value
123 -- pv_accounting_year VARCHAR2 accounting year
124 -- pv_start VARCHAR2 period from
125 -- pv_end VARCHAR2 period to
126 --
127 --
128 -- CHANGE HISTORY:
129 -- 25-Oct-2012 Jar Wang created
130 --==========================================================================
131 PROCEDURE Print_GL_AVG_BAL;
132 PROCEDURE Add_GL_AVG_BAL(pn_chart_of_account_id IN NUMBER,
133 pn_ledger_id IN NUMBER,
134 pn_legal_entity_id IN NUMBER,
135 pv_bsv IN VARCHAR2,
136 pv_accounting_year IN VARCHAR2,
137 pv_start IN VARCHAR2,
138 pv_end IN VARCHAR2);
139
140
141 --==========================================================================
142 -- PROCEDURE NAME:
143 --
144 -- Add_GL_JOURNAL Public
145 --
146 -- DESCRIPTION:
147 --
148 -- This procedure is to export non-FSG report for general ledger journal
149 --
150 -- PARAMETERS:
151 -- Out: pv_errbuf NOCOPY VARCHAR2
152 -- pv_retcode NOCOPY VARCHAR2
153 -- In: pn_legal_entity_id NUMBER identifier of legal entity
154 -- pn_chart_of_account_id NUMBER identifier of chart of account
155 -- pn_ledger_id NUMBER identifier of ledger
156 -- pv_bsv VARCHAR2 balance segment value
157 -- pv_accounting_year VARCHAR2 accounting year
158 -- pv_start VARCHAR2 period from
159 -- pv_end VARCHAR2 period to
160 --
161 --
162 -- CHANGE HISTORY:
163 -- 25-Oct-2012 Jar Wang created
164 --==========================================================================
168 pv_bsv IN VARCHAR2,
165 PROCEDURE Add_GL_JOURNAL(pn_chart_of_account_id IN NUMBER,
166 pn_ledger_id IN NUMBER,
167 pn_legal_entity_id IN NUMBER,
169 pv_accounting_year IN VARCHAR2,
170 pv_start IN VARCHAR2,
171 pv_end IN VARCHAR2);
172
173 FUNCTION Get_FullName(p_username VARCHAR2) return varchar2;
174
175 FUNCTION Get_Approver(p_je_header pls_integer,p_fnd_user varchar2) return varchar2;
176
177 END JA_CN_GL_BANK_EXP_PKG;
178
179