[Home] [Help]
PACKAGE: APPS.JA_CN_FA_AC_EXPORT_PKG
Source
1 PACKAGE JA_CN_FA_AC_EXPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNACES.pls 120.1 2011/03/09 09:25:56 jiachi noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNACES.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Use this package to export fixed asset card. |
13 --| |
14 --| PROCEDURE LIST |
15 --| Add_FA_Asset_Card Export asset Usage Information |
16 --| Add_FA_Asset_Card_Monthly Export asset Usage Information monthly |
17 --| |
18 --| |
19 --| HISTORY |
20 --| 04/08/2010 Qingyi Wang created |
21 --| 04/27/2010 Qingyi Wang add the method Add_FA_Asset_Card_Monthly |
22 --| 09-Mar-2011 Jianchao Chi Updated for bug 11847991 |
23 --+======================================================================*/
24
25 --==========================================================================
26 -- PROCEDURE NAME:
27 --
28 -- Add_FA_Asset_Card Public
29 --
30 -- DESCRIPTION:
31 --
32 -- This procedure is used to export asset card in Fixed Asset.
33 --
34 -- PARAMETERS:
35 -- In: pn_legal_entity_id LEGAL_ENTITY_ID
36 -- pn_ledger_id Ledger ID
37 -- pv_accounting_year Accounting Year
38 -- pv_period_from Period From
39 -- pv_period_to Period To
40 -- pn_coa_id Identifier of chart of account
41 -- DESIGN REFERENCES:
42 -- CNAO_V2_FA_TD.doc
43 --
44 -- CHANGE HISTORY:
45 --| 04/08/2010 Qingyi Wang created
46 --==========================================================================
47 PROCEDURE Add_FA_Asset_Card(pn_legal_entity_id IN NUMBER,
48 pn_ledger_id IN NUMBER,
49 pv_accounting_year IN VARCHAR2,
50 pv_period_from IN VARCHAR2,
51 pv_period_to IN VARCHAR2,
52 pn_coa_id NUMBER);
53
54 --==========================================================================
55 -- PROCEDURE NAME:
56 --
57 -- Add_FA_Asset_Card_Monthly Public
58 --
59 -- DESCRIPTION:
60 --
61 -- This procedure is used to export asset card in Fixed Asset monthly.
62 --
63 -- PARAMETERS:
64 -- In: pn_legal_entity_id LEGAL_ENTITY_ID
65 -- pn_ledger_id Ledger ID
66 -- pv_accounting_year Accounting Year
67 -- pv_period_from Period From
68 -- pv_period_to Period To
69 -- pn_coa_id Identifier of chart of account
70 -- DESIGN REFERENCES:
71 -- CNAO_V2_FA_TD.doc
72 --
73 -- CHANGE HISTORY:
74 --| 04/27/2010 Qingyi Wang created
75 -- 09-Mar-2011 Jianchao Chi Updated for bug 11847991
76 --==========================================================================
77 --Changed from procdure to function, and add a return value by Jianchao Chi
78 FUNCTION Add_FA_Asset_Card_Monthly(pn_legal_entity_id IN NUMBER,
79 pn_ledger_id IN NUMBER,
80 pv_accounting_year IN VARCHAR2,
81 pv_period_from IN VARCHAR2,
82 pv_period_to IN VARCHAR2,
83 pn_coa_id NUMBER) RETURN NUMBER;
84
85 END JA_CN_FA_AC_EXPORT_PKG;