[Home] [Help]
PACKAGE: APPS.JA_CN_VOUCHER_NUM_MIG_PKG
Source
1 PACKAGE JA_CN_VOUCHER_NUM_MIG_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNVNMS.pls 120.2 2011/02/11 10:28:40 choli noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNVNMB.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to migrate the history data |
13 --| |
14 --| PROCEDURE LIST |
15 --| Procedure Migration |
16 --| Procedure Migrate_voucher_number |
17 --| Procedure Migrate_voucher_num_periods |
18 --| |
19 --| HISTORY |
20 --| 29-Sep-2010 Jianchao Chi Created |
21 --+======================================================================*/
22
23 P_LEDGER_ID NUMBER;
24 P_LEDGER_NAME VARCHAR2(300);
25 P_CURRENCY VARCHAR2(300);
26 P_LEGAL_ENTITY_ID NUMBER;
27 P_LEGAL_ENTITY VARCHAR2(300);
28 P_COA_ID NUMBER;
29 P_PERIOD_FROM VARCHAR2(15);
30 P_PERIOD_TO VARCHAR2(15);
31 P_GL_DATE_FROM DATE;
32 P_GL_DATE_TO DATE;
33 P_PROFILE_OPTION_VALUE NUMBER;
34 P_REGENERATE_FLAG VARCHAR2(15);
35
36 --==========================================================================
37 -- PROCEDURE NAME:
38 --
39 -- Migrate_voucher_number Public
40 --
41 -- DESCRIPTION:
42 --
43 -- This function is to migrate the voucher number from gl_je_journal_lines
44 --
45 -- PARAMETERS:
46 -- In: pn_ledger_id Ledger ID
47 -- pn_legal_entity_id Legal Entity ID
48 -- pv_period_name Period Name
49 -- Out:
50 --
51 -- DESIGN REFERENCES:
52 --
53 --
54 -- CHANGE HISTORY:
55 -- 27-Sep-2010 Chongwu Li Created
56 -- 22-Oct-2010 Jianchao Chi Updated
57 --
58 --===========================================================================
59 PROCEDURE Migrate_voucher_number(pn_ledger_id IN NUMBER,
60 pn_legal_entity_id IN NUMBER,
61 pv_period_name IN VARCHAR2);
62
63 --==========================================================================
64 -- PROCEDURE NAME:
65 --
66 -- Migrate_voucher_num_periods Public
67 --
68 -- DESCRIPTION:
69 --
70 -- This function is to migrate the voucher number for the period range
71 --
72 -- PARAMETERS:
73 -- In: pn_ledger_id Ledger ID
74 -- pn_legal_entity_id Legal Entity ID
75 -- Out:
76 --
77 -- DESIGN REFERENCES:
78 --
79 --
80 -- CHANGE HISTORY:
81 -- 27-Sep-2010 Chongwu Li Created
82 -- 22-Oct-2010 Jianchao Chi Updated
83 --
84 --===========================================================================
85 PROCEDURE Migrate_voucher_num_periods(pn_ledger_id IN NUMBER,
86 pn_legal_entity_id IN NUMBER);
87 --==========================================================================
88 -- PROCEDURE NAME:
89 --
90 -- beforeReport Public
91 --
92 -- DESCRIPTION:
93 --
94 -- This procedure is used to deal with the parameters and invoke the
95 -- "Migrate_voucher_num_periods" function to process the data.
96 --
97 -- PARAMETERS:
98 -- In: N/A
99 -- Out: TRUE/FALSE
100 --
101 -- DESIGN REFERENCES:
102 --
103 --
104 -- CHANGE HISTORY:
105 -- 18-Oct-2010 Jianchao Chi Created
106 --
107 --===========================================================================
108 PROCEDURE Migration(Errbuf OUT NOCOPY VARCHAR2,
109 Retcode OUT NOCOPY VARCHAR2,
110 P_RESP_APPLICATION_ID IN NUMBER,
111 P_LEGAL_ENTITY_TEMP IN NUMBER,
112 P_PROFILE_OPTION_VALUE IN NUMBER,
113 P_LEDGER_ID IN NUMBER,
114 P_LEDGER_NAME IN VARCHAR2,
115 P_LEGAL_ENTITY_ID IN NUMBER,
116 P_LEGAL_ENTITY IN VARCHAR2);
117
118 END JA_CN_VOUCHER_NUM_MIG_PKG;
119
120