1 PACKAGE JA_CN_PS_FA_EXP_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNFPAS.pls 120.0 2010/08/30 05:12:22 wuliu noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNFPAS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export Fixed Asset Information |
13 --| for Public Sector |
14 --| |
15 --| PROCEDURE LIST |
16 --| PROCEDURE Export_Fixed_Asset |
17 --| PROCEDURE Submit_Request |
18 --| |
19 --| HISTORY |
20 --| 16/AUG/2010 Wuhua Liu Created |
21 --+======================================================================*/
22 GV_MODULE_PREFIX VARCHAR2(30) := 'JA_CN_PS_FA_EXPORT_PKG';
23 --==========================================================================
24 -- PROCEDURE NAME:
25 --
26 -- Export_Fixed_Asset Public
27 --
28 -- DESCRIPTION:
29 --
30 -- This procedure is to export Fixed Asset Information
31 -- for public sector
32 --
33 -- PARAMETERS:
34 -- Out: pv_errbuf standard out parameter
35 -- for concurrent program
36 -- pv_retcode standard out parameter
37 -- for concurrent program
38 -- In: pn_legal_entity_id Legal entity ID
39 -- pn_ledger_id Ledeger ID
40 -- pv_accounting_year accounting year
41 -- pv_period_from The from period
42 -- pv_period_to The to period
43 -- pn_coa_id Chart of Account ID
44 --
45 --
46 -- DESIGN REFERENCES:
47 -- TDD_1213_FIN_GL_P_CNAOV2_FA.doc
48 --
49 -- CHANGE HISTORY:
50 --
51 -- 16-AUG-2010 Wuhua Liu created
52 PROCEDURE Export_Fixed_Asset
53 ( pv_errbuf OUT NOCOPY VARCHAR2
54 , pv_retcode OUT NOCOPY VARCHAR2
55 , pn_legal_entity_id IN NUMBER
56 , pn_ledger_id IN NUMBER
57 , pv_accounting_year IN VARCHAR2
58 , pv_period_from IN VARCHAR2
59 , pv_period_to IN VARCHAR2
60 , pn_coa_id IN NUMBER
61 );
62 --==========================================================================
63 -- PROCEDURE NAME:
64 --
65 -- Submit_Request Public
66 --
67 -- DESCRIPTION:
68 --
69 -- This procedure is to export report of Fixed Asset Information
70 -- for public sector
71 --
72 -- PARAMETERS:
73 -- Out: pv_errbuf standard out parameter for
74 -- concurrent program
75 -- pv_retcode standard out parameter for
76 -- concurrent program
77 -- In: pn_legal_entity_id Legal entity id
78 -- pn_ledger_id Leder ID
79 -- pv_accounting_year accounting year
80 -- pv_period_from The From Period
81 -- pv_period_to The To period
82 -- pn_coa_id Chart of Accounts
83 -- pv_source_char_set source character set
84 -- pv_dest_char_set destiniation character set.
85 --
86 -- DESIGN REFERENCES:
87 -- TDD_1213_FIN_GL_P_CNAOV2_FA.doc
88 --
89 -- CHANGE HISTORY:
90 --
91 -- 16-AUG-2010 Wuhua Liu created
92 PROCEDURE Submit_Request
93 ( pv_errbuf OUT NOCOPY VARCHAR2
94 , pv_retcode OUT NOCOPY VARCHAR2
95 , pn_legal_entity_id IN NUMBER
96 , pn_ledger_id IN NUMBER
97 , pv_accounting_year IN VARCHAR2
98 , pv_period_from IN VARCHAR2
99 , pv_period_to IN VARCHAR2
100 , pn_coa_id IN NUMBER
101 , pv_source_char_set IN VARCHAR2
102 , pv_dest_char_set IN VARCHAR2
103 );
104 --==========================================================================
105 -- FUNCTION NAME:
106 --
107 -- Check_kff Public
108 --
109 -- DESCRIPTION:
110 --
111 -- This function is to check the Key flex field config.
112 -- for public sector
113 --
114 -- PARAMETERS:
115 -- In: pn_coa_id NUMBER Identifier of Chart of Account.
116 --
117 -- DESIGN REFERENCES:
118 -- TDD_1213_FIN_GL_P_CNAOV2_FA.doc
119 --
120 -- CHANGE HISTORY:
121 --
122 -- 16-AUG-2010 Wuhua Liu created
123 FUNCTION Check_kff
124 ( pn_coa_id NUMBER
125 )
126 RETURN BOOLEAN;
127 --==========================================================================
128 -- FUNCTION NAME:
129 --
130 -- Check_Depreciation_Assignment Public
131 --
132 -- DESCRIPTION:
133 --
134 -- This function is to check the Depreciation Assignment .
135 -- for public sector
136 --
137 -- PARAMETERS:
138 -- In: pn_legal_entity_id NUMBER Identifier of Legal Entity.
139 --
140 -- DESIGN REFERENCES:
141 -- TDD_1213_FIN_GL_P_CNAOV2_FA.doc
142 --
143 -- CHANGE HISTORY:
144 --
145 -- 16-AUG-2010 Wuhua Liu created
146 FUNCTION Check_Depreciation_Assignment
147 ( pn_legal_entity_id NUMBER
148 )
149 RETURN BOOLEAN;
150 END JA_CN_PS_FA_EXP_PKG;
151