[Home] [Help]
PACKAGE: APPS.JA_CN_HISDATA_MIG_PKG
Source
1 PACKAGE JA_CN_HISDATA_MIG_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNHDMS.pls 120.6 2011/04/13 05:17:18 choli noship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNHDMS.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This package is to provide CNAO V1 to V2 data migration procedures.
14 --|
15 --| PROCEDURE LIST
16 --|
17 --| PROCEDURE UpdateGLCashlines
18 --| PROCEDURE UpdateGLItemizationlines
19 --| PROCEDURE UpdateItemizationlines
20 --| PROCEDURE MigrateHisData
21 --| PROCEDURE MigrateHisDataCFS
22 --| PROCEDURE MigrateHisDataDE
23 --|
24 --| HISTORY
25 --| 05-Jan-2011 Chongwu Li Created
26 --| 28-Jan-2011 Jianchao Chi Updated, fix bug 11691910
27 --| 11-Feb-2011 Jianchao Chi Updated, fix bug 11683977
28 --| 22-Mar-2011 Chongwu Li Updated, fix bug 11904408
29 --| 13-Apr-2011 Chongwu Li Updated, fix bug 12349159
30 --+======================================================================*/
31
32 --==========================================================================
33 -- FUNCTION NAME:
34 --
35 -- UpdateGLCashlines Public
36 --
37 -- DESCRIPTION:
38 --
39 -- This procedure is used to migrate the cash flow related lines data
40 -- in GL_JE_LINES. copy values from DFF column AttributeN to column
41 -- Global_Attribute6.
42 --
43 --
44 -- PARAMETERS:
45 -- In: pn_chart_account_id Chart of account ID
46 -- In: pn_legal_entitliy_id Legal entity ID
47 -- In : pn_ledger_id Leger Id
48 -- In : P_LEDGER_NAME Leger Name
49 -- In : P_LEGAL_ENTITY Legal Entity Name
50 -- In : pv_period_name Period Name
51 -- DESIGN REFERENCES:
52 --
53 --
54 -- CHANGE HISTORY:
55 --
56 -- 05-Jan-2011 Chongwu Li Created
57 -- 28-Jan-2011 Jianchao Chi Updated, fix bug 11691910
58 --
59 --===========================================================================
60 FUNCTION UpdateGLCashlines(pn_chart_account_id NUMBER,
61 pn_legal_entitliy_id NUMBER,
62 pn_ledger_id NUMBER,
63 P_LEDGER_NAME VARCHAR2,
64 P_LEGAL_ENTITY VARCHAR2,
65 pv_period_name VARCHAR2) RETURN NUMBER;
66
67 --==========================================================================
68 -- FUNCTION NAME:
69 --
70 -- UpdateGLItemizationlines Public
71 --
72 -- DESCRIPTION:
73 --
74 -- This procedure is used to migrate the Itemazation lines data
75 -- in GL_JE_LINES. copy values from column Global_Attribute2 to
76 -- column Global_Attribute7, and set Global_Attribute2 to null.
77 --
78 --
79 -- PARAMETERS:
80 -- In: pn_legal_entitliy_id Legal entity ID
81 -- In : pn_ledger_id Leger Id
82 -- In : pv_period_name Period Name
83 -- DESIGN REFERENCES:
84 --
85 --
86 -- CHANGE HISTORY:
87 --
88 -- 05-Jan-2011 Chongwu Li Created
89 --
90 --===========================================================================
91 PROCEDURE UpdateGLItemizationlines(pn_legal_entitliy_id NUMBER,
92 pn_ledger_id NUMBER,
93 pv_period_name VARCHAR2);
94
95 --==========================================================================
96 -- FUNCTION NAME:
97 --
98 -- UpdateItemizationlines Public
99 --
100 -- DESCRIPTION:
101 --
102 -- This procedure is used to migrate the Itemazation lines data
103 -- in ja_cn_journal_lines.
104 --
105 --
106 -- PARAMETERS:
107 -- In: pn_chart_account_id Chart of account ID
108 -- In: pn_legal_entitliy_id Legal entity ID
109 -- In : pn_ledger_id Leger Id
110 -- In : pv_period_name Period Name
111 -- DESIGN REFERENCES:
112 --
113 --
114 -- CHANGE HISTORY:
115 --
116 -- 05-Jan-2011 Chongwu Li Created
117 -- 11-Feb-2011 Jianchao Chi update for bug 11683977
118 -- 13-Apr-2011 Chongwu Li fix bug 12349159
119 --
120 --===========================================================================
121 PROCEDURE UpdateItemizationlines(pn_chart_account_id NUMBER,
122 pn_legal_entitliy_id NUMBER,
123 pn_ledger_id NUMBER,
124 pv_period_name VARCHAR2,
125 -- pb_msg_tag BOOLEAN, --Add a parameter by Jianchao Chi for bug 11683977
126 lb_need_Update BOOLEAN,
127 lv_prject_seg VARCHAR2);
128 --==========================================================================
129 -- FUNCTION NAME:
130 --
131 -- MigrateHisData Public
132 --
133 -- DESCRIPTION:
134 --
135 -- This procedure is main program, used to migrate all the historic data
136 -- by invoking above sub programs, as well as the voucher number migration
137 -- program.
138 --
139 --
140 -- PARAMETERS:
141 -- Out: Errbuf Error buffer
142 -- Out: Retcode Error code
143 -- In : P_COA_ID Chart of account ID
144 -- In: P_RESP_APPLICATION_ID Application ID
145 -- In: P_LEGAL_ENTITY_TEMP Legal entity temp
146 -- In : P_PROFILE_OPTION_VALUE Profile Option Value
147 -- In: P_LEDGER_ID Leger Id
148 -- In: P_LEDGER_NAME Leger Name
149 -- In : P_LEGAL_ENTITY_ID Legal entity ID
150 -- In: P_LEGAL_ENTITY Legal entity Name
151 --
152 -- DESIGN REFERENCES:
153 --
154 --
155 -- CHANGE HISTORY:
156 --
157 -- 05-Jan-2011 Chongwu Li Created
158 --
159 --===========================================================================
160 /* PROCEDURE MigrateHisData(Errbuf OUT NOCOPY VARCHAR2,
161 Retcode OUT NOCOPY VARCHAR2,
162 P_COA_ID IN NUMBER,
163 P_RESP_APPLICATION_ID IN NUMBER,
164 P_LEGAL_ENTITY_TEMP IN NUMBER,
165 P_PROFILE_OPTION_VALUE IN NUMBER,
166 P_LEDGER_ID IN NUMBER,
167 P_LEDGER_NAME IN VARCHAR2,
168 P_LEGAL_ENTITY_ID IN NUMBER,
169 P_LEGAL_ENTITY IN VARCHAR2);*/
170
171 --==========================================================================
172 -- FUNCTION NAME:
173 --
174 -- MigrateHisDataCFS Public
175 --
176 -- DESCRIPTION:
177 --
178 -- This procedure is main program, used to migrate all the historic data
179 -- by invoking above sub programs, as well as the voucher number migration
180 -- program.
181 --
182 --
183 -- PARAMETERS:
184 -- Out: Errbuf Error buffer
185 -- Out: Retcode Error code
186 -- In : P_COA_ID Chart of account ID
187 -- In: P_RESP_APPLICATION_ID Application ID
188 -- In: P_LEGAL_ENTITY_TEMP Legal entity temp
189 -- In : P_PROFILE_OPTION_VALUE Profile Option Value
190 -- In: P_LEDGER_ID Leger Id
191 -- In: P_LEDGER_NAME Leger Name
192 -- In : P_LEGAL_ENTITY_ID Legal entity ID
193 -- In: P_LEGAL_ENTITY Legal entity Name
194 --
195 -- DESIGN REFERENCES:
196 --
197 --
198 -- CHANGE HISTORY:
199 --
200 -- Mar-22-2011 Chongwu Li Created
201 --
202 --===========================================================================
203 PROCEDURE MigrateHisDataCFS(Errbuf OUT NOCOPY VARCHAR2,
204 Retcode OUT NOCOPY VARCHAR2,
205 P_COA_ID IN NUMBER,
206 P_RESP_APPLICATION_ID IN NUMBER,
207 P_LEGAL_ENTITY_TEMP IN NUMBER,
208 P_PROFILE_OPTION_VALUE IN NUMBER,
209 P_LEDGER_ID IN NUMBER,
210 P_LEDGER_NAME IN VARCHAR2,
211 P_LEGAL_ENTITY_ID IN NUMBER,
212 P_LEGAL_ENTITY IN VARCHAR2);
213
214 --==========================================================================
215 -- FUNCTION NAME:
216 --
217 -- MigrateHisDataDE Public
218 --
219 -- DESCRIPTION:
220 --
221 -- This procedure is main program, used to migrate all the historic data
222 -- by invoking above sub programs, as well as the voucher number migration
223 -- program.
224 --
225 --
226 -- PARAMETERS:
227 -- Out: Errbuf Error buffer
228 -- Out: Retcode Error code
229 -- In : P_COA_ID Chart of account ID
230 -- In: P_RESP_APPLICATION_ID Application ID
231 -- In: P_LEGAL_ENTITY_TEMP Legal entity temp
232 -- In : P_PROFILE_OPTION_VALUE Profile Option Value
233 -- In: P_LEDGER_ID Leger Id
234 -- In: P_LEDGER_NAME Leger Name
235 -- In : P_LEGAL_ENTITY_ID Legal entity ID
236 -- In: P_LEGAL_ENTITY Legal entity Name
237 --
238 -- DESIGN REFERENCES:
239 --
240 --
241 -- CHANGE HISTORY:
242 --
243 -- Mar-22-2011 Chongwu Li Created
244 --
245 --===========================================================================
246 PROCEDURE MigrateHisDataDE(Errbuf OUT NOCOPY VARCHAR2,
247 Retcode OUT NOCOPY VARCHAR2,
248 P_COA_ID IN NUMBER,
249 P_RESP_APPLICATION_ID IN NUMBER,
250 P_LEGAL_ENTITY_TEMP IN NUMBER,
251 P_PROFILE_OPTION_VALUE IN NUMBER,
252 P_LEDGER_ID IN NUMBER,
253 P_LEDGER_NAME IN VARCHAR2,
254 P_LEGAL_ENTITY_ID IN NUMBER,
255 P_LEGAL_ENTITY IN VARCHAR2);
256
257 END JA_CN_HISDATA_MIG_PKG;
258