PACKAGE BODY: APPS.HRI_MTDT_PARAM

Source

1 PACKAGE BODY hri_mtdt_param AS
2 /* $Header: hrimpar.pkb 120.2 2005/12/20 06:09:53 jtitmas noship $ */
3 
4 g_rtn   VARCHAR2(30) := '
5 ';
6 
7 /* Called during package initialization */
8 PROCEDURE set_pmv_metadata IS
9 
10   l_bind  VARCHAR2(80);
11 
12 BEGIN
13 
14 /* Time Dimension */
15 /******************/
16   l_bind := 'TIME_CURR_START_DATE';
17   g_param_mtdt_tab(l_bind).pmv_bind_string := '&BIS_CURRENT_EFFECTIVE_START_DATE';
18 
19   l_bind := 'TIME_CURR_END_DATE';
20   g_param_mtdt_tab(l_bind).pmv_bind_string := '&BIS_CURRENT_EFFECTIVE_END_DATE';
21 
22   l_bind := 'TIME_CURR_ASOF_DATE';
23   g_param_mtdt_tab(l_bind).pmv_bind_string := '&BIS_CURRENT_ASOF_DATE';
24 
25   l_bind := 'TIME_COMP_START_DATE';
26   g_param_mtdt_tab(l_bind).pmv_bind_string := '&BIS_PREVIOUS_EFFECTIVE_START_DATE';
27 
28   l_bind := 'TIME_COMP_END_DATE';
29   g_param_mtdt_tab(l_bind).pmv_bind_string := '&BIS_PREVIOUS_EFFECTIVE_END_DATE';
30 
31   l_bind := 'TIME_COMP_ASOF_DATE';
32   g_param_mtdt_tab(l_bind).pmv_bind_string := '&BIS_PREVIOUS_ASOF_DATE';
33 
34   l_bind := 'TIME_COMPARISON_TYPE';
35   g_param_mtdt_tab(l_bind).pmv_bind_string := '&TIME_COMPARISON_TYPE';
36 
37   l_bind := 'PERIOD_TYPE';
38   g_param_mtdt_tab(l_bind).pmv_bind_string := '&PERIOD_TYPE';
39 
40 /* Other Common Dimensions */
41 /***************************/
42   l_bind := 'HRI_PERSON+HRI_PER_USRDR_H';
43   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_PERSON+HRI_PER_USRDR_H';
44 
45   l_bind := 'GEOGRAPHY+AREA';
46   g_param_mtdt_tab(l_bind).pmv_bind_string := '&GEOGRAPHY+AREA';
47 
48   l_bind := 'GEOGRAPHY+COUNTRY';
49   g_param_mtdt_tab(l_bind).pmv_bind_string := '&GEOGRAPHY+COUNTRY';
50 
51   l_bind := 'CURRENCY';
52   g_param_mtdt_tab(l_bind).pmv_bind_string := ':GLOBAL_CURRENCY';
53 
54   l_bind := 'RATE_TYPE';
55   g_param_mtdt_tab(l_bind).pmv_bind_string := ':GLOBAL_RATE';
56 
57 /* Other HR Dimensions */
58 /***********************/
59   l_bind := 'JOB+JOB_FAMILY';
60   g_param_mtdt_tab(l_bind).pmv_bind_string := '&JOB+JOB_FAMILY';
61 
62   l_bind := 'JOB+JOB_FUNCTION';
63   g_param_mtdt_tab(l_bind).pmv_bind_string := '&JOB+JOB_FUNCTION';
64 
65   l_bind := 'HRI_LOW+HRI_LOW_BAND_X';
66   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_LOW+HRI_LOW_BAND_X';
67 
68   l_bind := 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
69   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
70 
71   l_bind := 'HRI_WRKACTVT+HRI_WAC_SEPCAT_X';
72   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_WRKACTVT+HRI_WAC_SEPCAT_X';
73 
74   l_bind := 'HRI_REASON+HRI_RSN_SEP_X';
75   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_REASON+HRI_RSN_SEP_X';
76 
77 /* Absence Dimensions */
78 /**********************/
79   l_bind := 'HRI_ABSNC_M+HRI_ABSNC_M_DRTN_UOM';
80   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_ABSNC_M+HRI_ABSNC_M_DRTN_UOM';
81 
82   l_bind := 'HRI_ABSNC+HRI_ABSNC_CAT';
83   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_ABSNC+HRI_ABSNC_CAT';
84 
85   l_bind := 'HRI_ABSNC+HRI_ABSNC_TYP';
86   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_ABSNC+HRI_ABSNC_TYP';
87 
88   l_bind := 'HRI_ABSNC+HRI_ABSNC_RSN';
89   g_param_mtdt_tab(l_bind).pmv_bind_string := '&HRI_ABSNC+HRI_ABSNC_RSN';
90 
91 END set_pmv_metadata;
92 
93 /* Initialization - set metadata for parameters */
94 BEGIN
95 
96   set_pmv_metadata;
97 
98 END hri_mtdt_param;