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