[Home] [Help]
PACKAGE: APPS.JA_CN_SI_BANK_DET_PKG
Source
1 PACKAGE JA_CN_SI_BANK_DET_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNSBDS.pls 120.0.12020000.2 2013/02/06 09:00:39 chongwan noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNSBDS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export Electronic Accounting Book |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Add_Accounting_Unit_Info |
16 --| PROCEDURE Add_Merchant_Bank_Info |
17 --| PROCEDURE Add_Parent_BSV |
18 --| PROCEDURE Add_Accounting_Currency |
19 --| PROCEDURE List_Accounting_Currency |
20 --| PROCEDURE Add_Accounting_Periods |
21 --| PROCEDURE Add_Accounting_Code_Rule |
22 --| PROCEDURE Add_Inner_Sheet_Account |
23 --| PROCEDURE Add_Extra_Sheet_Account |
24 --| FUNCTION Get_Level |
25 --| |
26 --| HISTORY |
27 --| Oct-18-2012 Jar Wang Created |
28 --+======================================================================*/
29
30 --==========================================================================
31 -- PROCEDURE NAME:
32 -- Add_Accounting_Unit_Info public
33 --
34 -- DESCRIPTION:
35 -- This procedure returns accountint unit information
36 --
37 -- PARAMETERS:
38 -- In: pn_legal_entity_id NUMBER
39 -- In: pn_ledger_id NUMBER
40 -- In: pv_bsv NUMBER
41 -- In: pn_accounting_year NUMBER
42 --
43 -- CHANGE HISTORY:
44 -- Nov-15-2012 Jar Wang Created
45 --===========================================================================
46 PROCEDURE Add_Accounting_Unit_Info(pn_legal_entity_id NUMBER,
47 pn_ledger_id NUMBER,
48 pv_bsv VARCHAR2,
49 pn_accounting_year NUMBER);
50
51
52 --==========================================================================
53 -- PROCEDURE NAME:
54 -- Add_Merchant_Bank_Info public
55 --
56 -- DESCRIPTION:
57 -- This procedure returns accountint unit information
58 --
59 -- PARAMETERS:
60 -- In: pn_legal_entity_id NUMBER
61 -- In: pn_ledger_id NUMBER
62 -- In: pv_bsv NUMBER
63 -- In: pn_accounting_year NUMBER
64 --
65 -- CHANGE HISTORY:
66 -- Nov-15-2012 Jar Wang Created
67 --===========================================================================
68 PROCEDURE Add_Merchant_Bank_Info(pn_legal_entity_id NUMBER,
69 pn_ledger_id NUMBER,
70 pv_bsv VARCHAR2,
71 pn_accounting_year NUMBER);
72
73 --==========================================================================
74 -- PROCEDURE NAME:
75 -- Add_Parent_BSV public
76 --
77 -- DESCRIPTION:
78 -- This procedure returns accountint unit information with parent flag
79 --
80 -- PARAMETERS:
81 -- In: pn_legal_entity_id NUMBER
82 -- In: pn_ledger_id NUMBER
83 -- In: pv_bsv NUMBER
84 -- In: pn_accounting_year NUMBER
85 --
86 -- CHANGE HISTORY:
87 -- Nov-15-2012 Jar Wang Created
88 --===========================================================================
89 PROCEDURE Add_Parent_BSV(pn_legal_entity_id NUMBER,
90 pn_ledger_id NUMBER,
91 pv_bsv VARCHAR2,
92 pn_accounting_year NUMBER,
93 pn_branch PLS_INTEGER);
94
95 --==========================================================================
96 -- PROCEDURE NAME:
97 -- Add_Accounting_Currency public
98 --
99 -- DESCRIPTION:
100 -- This procedure returns accounting currency in the GL journal
101 --
102 -- PARAMETERS:None
103 --
104 -- CHANGE HISTORY:
105 -- Nov-28-2012 Jar Wang Created
106 --===========================================================================
107 PROCEDURE Add_Accounting_Currency;
108
109 --==========================================================================
110 -- PROCEDURE NAME:
111 -- List_Accounting_Currency public
112 --
113 -- DESCRIPTION:
114 -- This procedure returns accounting currency in the GL journal
115 --
116 -- PARAMETERS:
117 -- In: pn_legal_entity_id NUMBER
118 -- In: pn_ledger_id NUMBER
119 -- In: pv_bsv NUMBER
120 -- In: pn_accounting_year NUMBER
121 --
122 -- CHANGE HISTORY:
123 -- Nov-17-2012 Jar Wang Created
124 --===========================================================================
125 PROCEDURE List_Accounting_Currency(pn_legal_entity_id NUMBER,
126 pn_ledger_id NUMBER,
127 pv_bsv VARCHAR2,
128 pn_accounting_year NUMBER);
129 --==========================================================================
130 -- PROCEDURE NAME:
131 -- Add_Accounting_Currency public
132 --
133 -- DESCRIPTION:
134 -- This procedure returns accounting periods in the ledger
135 --
136 -- PARAMETERS:
137 -- In: pn_legal_entity_id NUMBER
138 -- In: pn_ledger_id NUMBER
139 -- In: pn_accounting_year NUMBER
140 --
141 -- CHANGE HISTORY:
142 -- Nov-17-2012 Jar Wang Created
143 --===========================================================================
144 PROCEDURE Add_Accounting_Periods(pn_legal_entity_id NUMBER,
145 pn_ledger_id NUMBER,
146 pn_accounting_year NUMBER);
147
148 --==========================================================================
149 -- PROCEDURE NAME:
150 -- Add_Accounting_Code_Rule public
151 --
152 -- DESCRIPTION:
153 -- This procedure returns accounting cod rule as per bsv
154 --
155 -- PARAMETERS:
156 -- In: pn_legal_entity_id NUMBER
157 -- In: pn_ledger_id NUMBER
158 -- In: pv_bsv NUMBER
159 -- In: pn_accounting_year NUMBER
160 --
161 -- CHANGE HISTORY:
162 -- Nov-17-2012 Jar Wang Created
163 --===========================================================================
164 PROCEDURE Add_Accounting_Code_Rule(pn_legal_entity_id NUMBER,
165 pn_ledger_id NUMBER,
166 pv_bsv VARCHAR2,
167 pn_accounting_year NUMBER);
168
169 --==========================================================================
170 -- PROCEDURE NAME:
171 -- Add_Inner_Sheet_Account public
172 --
173 -- DESCRIPTION:
174 -- This procedure returns inner sheet account
175 --
176 -- PARAMETERS:
177 -- In: pn_legal_entity_id NUMBER
178 -- In: pn_ledger_id NUMBER
179 -- In: pv_bsv NUMBER
180 -- In: pn_accounting_year NUMBER
181 --
182 -- CHANGE HISTORY:
183 -- Nov-17-2012 Jar Wang Created
184 --===========================================================================
185 PROCEDURE Add_Inner_Sheet_Account(pn_legal_entity_id NUMBER,
186 pn_ledger_id NUMBER,
187 pv_bsv VARCHAR2,
188 pn_accounting_year NUMBER);
189
190 --==========================================================================
191 -- PROCEDURE NAME:
192 -- Add_Extra_Sheet_Account public
193 --
194 -- DESCRIPTION:
195 -- This procedure returns extra sheet account
196 --
197 -- PARAMETERS:
198 -- In: pn_legal_entity_id NUMBER
199 -- In: pn_ledger_id NUMBER
200 -- In: pv_bsv NUMBER
201 -- In: pn_accounting_year NUMBER
202 --
203 -- CHANGE HISTORY:
204 -- Nov-17-2012 Jar Wang Created
205 --===========================================================================
206 PROCEDURE Add_Extra_Sheet_Account(pn_legal_entity_id NUMBER,
207 pn_ledger_id NUMBER,
208 pv_bsv VARCHAR2,
209 pn_accounting_year NUMBER);
210 --==========================================================================
211 -- FUNCTION NAME:
212 -- Get_Level public
213 --
214 -- DESCRIPTION:
215 -- This procedure returns the level of account in the account hierarchy.
216 --
217 -- PARAMETERS:
218 -- In: p_valueset NUMBER
219 -- In: p_parent NUMBER
220 --
221 -- CHANGE HISTORY:
222 -- Nov-10-2012 Jar Wang Created
223 --===========================================================================
224
225 FUNCTION Get_Level(p_valueset pls_integer, p_parent varchar2) RETURN NUMBER;
226
227 END JA_CN_SI_BANK_DET_PKG;
228