1 PACKAGE FEM_BI_DIMENSION_UTILS_PKG AS
2 /* $Header: fem_bi_dim_utils.pls 120.1 2008/02/20 06:55:06 jcliving noship $ */
3
4 ---------------------------------------------
5 -- Package Constants
6 ---------------------------------------------
7 G_MODULE constant varchar2(80) := 'fem.plsql.fem_bi_dimension_utils_pkg';
8 G_PACKAGE_NAME constant varchar2(30) := 'FEM_BI_DIMENSION_UTILS_PKG';
9 G_FEM constant varchar2(3) := 'FEM';
10
11 type cal_periods_cursor is ref cursor return fem_cal_periods_b%rowtype;
12
13 ---------------------------------------------
14 -- Declare public procedures and functions --
15 ---------------------------------------------
16
17 /*===========================================================================+
18 | PROCEDURE
19 | Run_Transformation
20 |
21 | DESCRIPTION
22 | Runs Attribute Transformation for all supported dimensions
23 |
24 | SCOPE - PUBLIC
25 |
26 | ARGUMENTS
27 | x_errbuf Standard Concurrent Program parameter
28 | x_retcode Standard Concurrent Program parameter
29 | p_dimension_varchar_label Dimension Varchar Label
30 | p_seed_db_link Seed DB Link (INTERNAL USE ONLY)
31 +===========================================================================*/
32
33 PROCEDURE Run_Transformation (
34 x_errbuf out nocopy varchar2
35 ,x_retcode out nocopy varchar2
36 ,p_dimension_varchar_label in varchar2
37 ,p_seed_db_link in varchar2 := null
38 );
39
40
41 /*===========================================================================+
42 | PROCEDURE
43 | Get_Pago_Cal_Period_ID
44 |
45 | DESCRIPTION
46 | Returns the prior Calendar Period ID for the given Calendar Period.
47 |
48 | The returned Calendar Period will have the same Calendar, Dimension Group,
49 | and Adjustment Period Flag value.
50 |
51 | SCOPE - PUBLIC
52 |
53 | ARGUMENTS
54 | p_cal_period_id Calendar Period Id
55 +===========================================================================*/
56
57 FUNCTION Get_Pago_Cal_Period_ID (
58 p_cal_period_id in number
59 ) RETURN number;
60
61
62 /*===========================================================================+
63 | PROCEDURE
64 | Get_Yago_Cal_Period_ID
65 |
66 | DESCRIPTION
67 | Returns the prior year Calendar Period ID for the given Calendar Period.
68 |
69 | The returned Calendar Period will have the same Calendar and Dimension
70 | Group. As Adjusment Periods can have overlapping date ranges, only
71 | non adjustment periods are processed and returned.
72 |
73 | SCOPE - PUBLIC
74 |
75 | ARGUMENTS
76 | p_cal_period_id Calendar Period Id
77 +===========================================================================*/
78
79 FUNCTION Get_Yago_Cal_Period_ID (
80 p_cal_period_id in number
81 ) RETURN number;
82
83
84 /*===========================================================================+
85 | FOR INTERNAL USE ONLY.
86 +===========================================================================*/
87
88 PROCEDURE Run_Seed_Transformation (
89 p_dimension_varchar_label in varchar2
90 ,p_seed_db_link in varchar2
91 ,x_completion_status out nocopy varchar2
92 );
93
94 END FEM_BI_DIMENSION_UTILS_PKG;