[Home] [Help]
PACKAGE: APPS.JA_CN_CFS_REPORT_PKG
Source
1 PACKAGE JA_CN_CFS_REPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNCFDS.pls 120.8 2010/09/25 01:23:46 riqi 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 prepare for generating of the CFS detail |
13 --| report. |
14 --| |
15 -- PARAMETERS: |
16 -- In: P_LEGAL_ENTITY_ID ID of Legal Entity |
17 -- In: P_LEGAL_ENTITY Name of Legal Entity |
18 -- In: P_LEDGER_ID ID of Set Of Book |
19 -- In: P_LEDGER_NAME Name of Set Of Book |
20 -- In: P_CHART_OF_ACCOUNTS_ID Identifier of gl chart of account |
21 -- In: P_ADHOC_PREFIX Ad hoc prefix for FSG report, a |
22 -- required parameter for FSG report |
23 -- In: P_INDUSTRY Industry with constant value 'C' for |
24 -- now, a required parameter for FSG |
25 -- report |
26 -- In: P_ID_FLEX_CODE ID flex code, a required parameter for|
27 -- FSG report |
28 -- In: P_REPORT_ID Identifier of FSG report |
29 -- In: P_REPORT_NAME Name of FSG report |
30 -- In: P_ROW_SET_ID Identifier of Row Set |
31 -- In: P_ROW_ID Identifier of Row |
32 -- In: P_ROW_NAME Name of Row |
33 -- In: P_START_PERIOD Start period |
34 -- In: P_END_PERIOD End period |
35 -- In: P_SOURCE Source of the collection |
36 -- In: P_INTERNAL_TRX To indicate if intercompany |
37 -- transactions should be involved in |
38 -- amount calculation of cash flow |
39 -- statement. |
40 --| PROCEDURE LIST |
41 --| |
42 --| FUNCTION Prepare_CFS_Detail_Report PUBLIC |
43 --| |
44 --| HISTORY |
45 --| 30/12/2006 Shujuan Yan Created |
46 --| 08/09/2008 Yao Zhang Fix bug#7334017 |
47 --| 20/09/2010 Richard Qi reconstructed to follow the |
48 --| standards of XML Publiser |
49 --+======================================================================*/
50 l_Module_Prefix VARCHAR2(100) := 'JA_CN_CFS_RPT_TEST_PKG';
51
52 P_LEGAL_ENTITY_ID NUMBER;
53 P_LEGAL_ENTITY VARCHAR2(240);
54 P_LEDGER_ID NUMBER;
55 P_LEDGER_NAME VARCHAR2(30);
56 P_CHART_OF_ACCOUNTS_ID NUMBER;
57 P_ADHOC_PREFIX VARCHAR2(80);
58 P_INDUSTRY VARCHAR2(1);
59 P_ID_FLEX_CODE VARCHAR2(50);
60 P_REPORT_ID NUMBER;
61 P_REPORT_NAME VARCHAR2(30);
62 P_ROW_SET_ID NUMBER;
63 P_ROW_ID NUMBER;
64 P_ROW_NAME VARCHAR2(50);
65 P_START_PERIOD VARCHAR2(15);
66 P_END_PERIOD VARCHAR2(15);
67 P_SOURCE VARCHAR2(50);
68 P_BSV VARCHAR2(15);
69
70 --==========================================================================
71 -- PROCEDURE NAME:
72 -- Prepare_CFS_Detail_Report Public
73 --
74 -- DESCRIPTION:
75 -- This procedure is to prepare for generating the cfs detail report.
76 --
77 -- DESIGN REFERENCES:
78 -- None
79 --
80 -- CHANGE HISTORY:
81 -- 20/09/2010 Richard Qi Created
82 --===========================================================================
83
84 FUNCTION Prepare_CFS_Detail_Report RETURN BOOLEAN;
85
86 END JA_CN_CFS_REPORT_PKG;