1 PACKAGE JA_CN_FSG_FORMULA_EXTRACT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNDFES.pls 120.0 2010/03/27 09:03:18 weihuang noship $
3 --+=======================================================================+
4 --| Copyright (c) 2010 Oracle Corporation
5 --| Redwood Shores, CA, USA
6 --| All rights reserved.
7 --+=======================================================================
8 --| FILENAME
9 --| JACNDFES.pls
10 --|
11 --| DESCRIPTION
12 --|
13 --| This package contains the following PL/SQL tables/procedures/functions
14 --| to extract formula for each row in the four FSG reports.
15 --|
16 --| PROCEDURE LIST
17 --| Extract_Row_Formula
18 --|
19 --| HISTORY
20 --| 19-JAN-2010 Wei Huang Created
21 --|
22 --+======================================================================*/
23 -- Declare global variable for package name
24 GV_MODULE_PREFIX VARCHAR2(50) :='JA.plsql.JA_CN_FSG_FORMULA_EXTRACT_PKG';
25
26 --==========================================================================
27 -- PROCEDURE NAME:
28 --
29 -- Extract_Row_Formula Public
30 --
31 -- DESCRIPTION:
32 --
33 -- This function is to extract formula for each row in the four FSG
34 -- reports.
35 --
36 -- PARAMETERS:
37 -- In: pn_report_id Report ID
38 -- pn_ledger_id Ledger ID
39 -- pn_axis_seq Row Sequence
40 --
41 -- Out:
42 --
43 -- DESIGN REFERENCES:
44 --
45 --
46 -- CHANGE HISTORY:
47 -- 19-JAN-2010 Wei Huang Created
48 --
49 --===========================================================================
50
51 FUNCTION Extract_Row_Formula
52 (pn_coa IN NUMBER
53 ,pn_axis_set_id IN NUMBER
54 ,pn_axis_seq IN NUMBER
55 ) RETURN VARCHAR2;
56
57
58 PROCEDURE Populate_Formula
59 (pn_coa IN NUMBER
60 ,pn_axis_set_id IN NUMBER
61 ,pn_axis_seq IN NUMBER
62 );
63
64 END JA_CN_FSG_FORMULA_EXTRACT_PKG;