DBA Data[Home] [Help]

PACKAGE: APPS.JA_CN_FA_RAI_EXPORT_PKG

Source


1 PACKAGE JA_CN_FA_RAI_EXPORT_PKG AUTHID CURRENT_USER AS
2   --$Header: JACNRAIS.pls 120.1 2011/03/09 09:31:02 jiachi noship $
3   --+=======================================================================+
4   --|               Copyright (c) 1998 Oracle Corporation                   |
5   --|                       Redwood Shores, CA, USA                         |
6   --|                         All rights reserved.                          |
7   --+=======================================================================+
8   --| FILENAME                                                              |
9   --|     JACNRAIS.pls                                                      |
10   --|                                                                       |
11   --| DESCRIPTION                                                           |
12   --|     Use this package to export real fixed asset information           |
13   --|                                                                       |
14   --| PROCEDURE LIST                                                        |
15   --|       Add_FA_Real_Asset_Info          Export real fixed asset   |
16   --|                                       information                     |
17   --|       Add_FA_Real_Asset_Info_Monthly  Export real fixed asset         |
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_Real_Asset_Info_Monthly|
24   --|     09-Mar-2011 Jianchao Chi Updated for bug 11847991                 |
25   --+======================================================================*/
26 
27   --==========================================================================
28   --  PROCEDURE NAME:
29   --
30   --    Add_FA_Real_Asset_Info                       Public
31   --
32   --  DESCRIPTION:
33   --
34   --    This procedure is used to export real fixed asset 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_Real_Asset_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_Real_Asset_Info_Monthly                       Public
59   --
60   --  DESCRIPTION:
61   --
62   --    This procedure is used to export real fixed asset 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_Real_Asset_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_RAI_EXPORT_PKG;