PACKAGE: APPS.BSC_DIM_TPLATE

Source

1 PACKAGE BSC_DIM_TPLATE AUTHID CURRENT_USER AS
2 /* $Header: BSCUDIMS.pls 115.4 2003/01/14 23:44:36 meastmon ship $ */
3 
4 --
5 -- Global Variables
6 --
7 
8 Type Acct_Type_Rec_Type Is Record (
9 	Code   		Number,
10 	Name		Varchar2(15)
11 );
12 
13 TYPE Acct_Type_Tbl_Type IS TABLE OF Acct_Type_Rec_Type
14  INDEX BY BINARY_INTEGER;
15 
16 Type Acct_Rec_Type Is Record (
17 	Code   		Number,
18 	Name		Varchar2(15),
19 	Acct_Type	Number(5),
20 	Position	Number(2)
21 );
22 
23 TYPE Acct_Tbl_Type IS TABLE OF Acct_Rec_Type
24  INDEX BY BINARY_INTEGER;
25 
26 BSC_DIM_ERROR		Exception;
27 
28 /*===========================================================================+
29 |
30 |   Name:          Create_Dimensions
31 |
32 |   Description:   To create dimensions for Tab and Crosss templates
33 |                  Dimension for Tab template:
34 |			Account Type 	(P/L KPI)
35 |			Account		(P/L KPI)
36 |			Sub-Account	(P/L KPI)
37 |
38 |		   Dimensoion for Cross template:
39 |			Account Type	(P/L KPI)
40 |			Account		(P/L KPI)
41 |			Sub-Account	(P/L KPI)
42 |			Project		(Type 4 KPI)
43 |
44 |   History:
45 |     	02-APR-1999   Alex Yang             Created.
46 |    12/21/1999	  Henry Camacho	Modified to Model 4.0
47 +============================================================================*/
48 
49 Function Create_Dimensions  Return Boolean;
50 
51 
52 
53 /*===========================================================================+
54 |
55 |   Name:          Define_Dim_Relations
56 |
57 |   Description:   To configue dimension family and relation.
58 |                  The following tables store dimension metadata,
59 |
60 |                  * Dimension tables:
61 |
62 |	    		MPROJ_ENTITIES
63 |			MPROJ_ENTITIES_LANGUAGE
64 |    			MPROJ_ENTITIES_RELATIONS
65 |
66 |                  * Dimension family tables:
67 |
68 |			MPROJ_DRILLS_FAMILIES
69 |			MPROJ_DRILLS_FAMILIES_LANG
70 |			MPROJ_DRILLS_FAMILIES_ENT
71 |
72 |   Parameters:
73 |	x_num_of_levels		number of dimension levels
74 |	x_num_of_family		number of dimension families
75 |
76 |   History:
77 |     	02-APR-1999   Alex Yang             Created.
78 |    12/21/1999	  Henry Camacho	Modified to Model 4.0
79 +============================================================================*/
80 Function Define_Dim_Relations(
81 		x_num_of_levels		IN	Number,
82 		x_num_of_family		IN	Number
83 ) Return Boolean;
84 
85 
86 END BSC_DIM_TPLATE;