1 PACKAGE Ja_Cn_Cfs_Report_Pkg AS
2 --$Header: JACNCFDS.pls 120.6.12010000.2 2008/10/28 06:17:34 shyan ship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNCFDS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used to generate the CFS detail report. |
13 --| |
14 --| PROCEDURE LIST |
15 --| |
16 --| PROCEDURE Cfs_Detail_Report PUBLIC |
17 --| |
18 --| HISTORY |
19 --| 30/12/2006 Shujuan Yan Created
20 --| 08/09/2008 Yao Zhang Fix bug#7334017 |
21 --| |
22 --+======================================================================*/
23 l_Module_Prefix VARCHAR2(100) := 'JA_CN_CFS_REPORT_PKG';
24 --==========================================================================
25 -- PROCEDURE NAME:
26 -- Cfs_Detail_Report Public
27 --
28 -- DESCRIPTION:
29 -- This procedure is to generate the cfs detail report.
30 --
31 -- PARAMETERS:
32 -- Out: errbuf
33 -- Out: retcode
34 -- In: P_LEGAL_ENTITY_ID ID of Legal Entity
35 -- In: P_LEDGER_ID ID of Set Of Book
36 -- In: P_Chart_of_Accounts_ID Identifier of gl chart of account
37 -- In: P_ADHOC_PREFIX Ad hoc prefix for FSG report, a required
38 -- parameter for FSG report
39 -- In: P_INDUSTRY Industry with constant value 'C' for
40 -- now, a required parameter for FSG report
41 -- In: P_ID_FLEX_CODE ID flex code, a required parameter for
42 -- FSG report
43 -- In: P_REPORT_ID Identifier of FSG report
44 -- In: P_GL_PERIOD_FROM Start period
45 -- In: P_GL_PERIOD_TO End period
46 -- In: P_SOURCE Source of the collection
47 -- In: P_INTERNAL_TRX To indicate if intercompany transactions
48 -- should be involved in amount calculation
49 -- of cash flow statement.
50 --
51 -- DESIGN REFERENCES:
52 -- None
53 --
54 -- CHANGE HISTORY:
55 -- 04/27/2007 Qingjun Zhao Created
56 -- 28/02/2008 Arming Fix bug#6751696
57 -- 08/09/2008 Yao Zhang Fix bug#7334017 for R12 enhancment
58 --===========================================================================
59
60 PROCEDURE Cfs_Detail_Report
61 (
62 Errbuf OUT NOCOPY VARCHAR2
63 ,Retcode OUT NOCOPY VARCHAR2
64 ,p_Legal_Entity_Id IN NUMBER
65 ,p_Ledger_Id IN NUMBER
66 ,p_Chart_Of_Accounts_Id IN NUMBER
67 ,p_Adhoc_Prefix IN VARCHAR2
68 ,p_Industry IN VARCHAR2
69 ,p_Id_Flex_Code IN VARCHAR2
70 ,p_Report_Id IN NUMBER
71 ,p_Row_Set_Id IN NUMBER
72 -- Fix bug#6751696 delete begin
73 --,P_Row_Name IN VARCHAR2
74 -- Fix bug#6751696 delete end
75 -- Fix bug#6751696 add begin
76 ,P_Row_Name IN NUMBER
77 -- Fix bug#6751696 add end
78 ,p_Gl_Period_From IN VARCHAR2
79 ,p_Gl_Period_To IN VARCHAR2
80 ,p_Source IN VARCHAR2
81 ,P_BSV IN VARCHAR2--Fix bug#7334017 add
82 );
83
84 END Ja_Cn_Cfs_Report_Pkg;
85