[Home] [Help]
PACKAGE: APPS.JA_CN_FA_EXPORT_PROG
Source
1 PACKAGE JA_CN_FA_EXPORT_PROG AUTHID CURRENT_USER AS
2 --$Header: JACNFAES.pls 120.0 2010/05/17 08:40:28 choli noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNFAES.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export fixed assets |
13 --| |
14 --| PROCEDURE LIST |
15 --| PROCEDURE Export_Fixed_Assets |
16 --| Submit_Request |
17 --| |
18 --| |
19 --| HISTORY |
20 --| 04/06/2010 Chongwu Li Created |
21 --+======================================================================*/
22
23
24 --==========================================================================
25 -- PROCEDURE NAME:
26 --
27 -- Export_Fixed_Assets Public
28 --
29 -- DESCRIPTION:
30 --
31 -- This procedure is to export fixed assets
32 --
33 -- PARAMETERS:
34 -- Out: pv_errbuf NOCOPY VARCHAR2
35 -- pv_retcode NOCOPY VARCHAR2
36 -- In: pn_coa_id NUMBER identifier of chart of account
37 -- pn_legal_entity_id NUMBER identifier of legal entity
38 -- pn_ledger_id NUMBER identifier of ledger
39 -- pv_accounting_year VARCHAR2 accounting year
40 -- pv_period_from VARCHAR2 period from
41 -- pv_period_to VARCHAR2 period to
42 --
43 --
44 --
45 -- DESIGN REFERENCES:
46 -- CNAO_V2_FA_TD.doc
47 --
48 -- CHANGE HISTORY:
49 --
50 -- 6-Apr-2010 Chongwu Li created
51 --==========================================================================
52
53 PROCEDURE Export_Fixed_Assets
54 ( pv_errbuf OUT NOCOPY VARCHAR2
55 , pv_retcode OUT NOCOPY VARCHAR2
56 , pn_legal_entity_id IN NUMBER
57 , pn_ledger_id IN NUMBER
58 , pv_accounting_year IN VARCHAR2
59 , pv_period_from IN VARCHAR2
60 , pv_period_to IN VARCHAR2
61 , pn_coa_id IN NUMBER
62 );
63
64 --==========================================================================
65 -- PROCEDURE NAME:
66 --
67 -- Submit_Request Public
68 --
69 -- DESCRIPTION:
70 --
71 -- This procedure is to export report for shared information
72 --
73 -- PARAMETERS:
74 -- Out: pv_errbuf NOCOPY VARCHAR2
75 -- pv_retcode NOCOPY VARCHAR2
76 -- In: pn_coa_id NUMBER identifier of chart of account
77 -- pn_legal_entity_id NUMBER identifier of legal entity
78 -- pn_ledger_id NUMBER identifier of ledger
79 -- pv_accounting_year VARCHAR2 accounting year
80 -- pv_period_from VARCHAR2 period from
81 -- pv_period_to VARCHAR2 period to
82 -- pv_source_char_set VARCHAR2 source character set
83 -- pv_dest_char_set VARCHAR2 destination character set
84 --
85 -- DESIGN REFERENCES:
86 -- CNAO_V2_FA_TD.doc
87 --
88 -- CHANGE HISTORY:
89 -- 06-Apr-2010 Chongwu Li created
90 --==========================================================================
91
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 --==========================================================================
106 -- FUNCTION NAME:
107 --
108 -- Check_kff Public
109 --
110 -- DESCRIPTION:
111 --
112 -- This function is to check the flexfield assignment form, if any of the fields
113 -- has no value, the error message will be displayed.
114 --
115 -- PARAMETERS:
116 -- In: pn_coa_id coa ID
117 -- DESIGN REFERENCES:
118 -- CNAO_V2_FA_TD.doc
119 --
120 -- CHANGE HISTORY:
121 --
122 -- 20-Apr-2010 Chongwu Li created
123 FUNCTION Check_kff(pn_coa_id NUMBER)
124 RETURN BOOLEAN;
125
126 --==========================================================================
127 -- FUNCTION NAME:
128 --
129 -- Check_Depreciation_Assignment Public
130 --
131 -- DESCRIPTION:
132 --
133 -- This function is to check depreciation method assignment form, if there
134 -- is not depreciation method assignment for the legal entity, the error
135 -- message will be displayed.
136 --
137 -- PARAMETERS:
138 -- In: pn_legal_entity_id legal_entity ID
139 -- DESIGN REFERENCES:
140 -- CNAO_V2_FA_TD.doc
141 --
142 -- CHANGE HISTORY:
143 --
144 -- 12-MAY-2010 Qingyi Wang created
145 FUNCTION Check_Depreciation_Assignment(pn_legal_entity_id NUMBER)
146 RETURN BOOLEAN;
147
148 END JA_CN_FA_EXPORT_PROG;
149
150