PACKAGE: APPS.HRI_MTDT_DIM_LVL

Source

1 PACKAGE hri_mtdt_dim_lvl AUTHID CURRENT_USER AS
2 /* $Header: hrimdlv.pkh 120.2 2005/09/19 03:26:26 cbridge noship $ */
3 
4 TYPE dim_lvl_metadata_rectype IS RECORD
5   (fact_viewby_col         VARCHAR2(30)
6   ,viewby_table            VARCHAR2(30)
7   ,viewby_id_col           VARCHAR2(30)
8   ,viewby_value_col        VARCHAR2(30)
9   ,sup_lvl_wrkfc_mv_name   VARCHAR2(30)
10   ,sup_lvl_wrkfc_mv_snp    VARCHAR2(30)
11   ,sup_lvl_wcnt_mv_snp     VARCHAR2(30)
12   ,sup_lvl_abs_mv_name     VARCHAR2(30)
13   ,sup_lvl_abs_mv_snp      VARCHAR2(30)
14 );
15 
16 TYPE dim_lvl_metadata_tabtype IS TABLE OF dim_lvl_metadata_rectype
17                    INDEX BY VARCHAR2(80);
18 
19 TYPE dim_lvl_buckets_rectype IS RECORD
20   (bucket_id_string  VARCHAR2(30)
21   ,bucket_name       VARCHAR2(30));
22 
23 TYPE dim_lvl_buckets_tabtype IS TABLE OF dim_lvl_buckets_rectype
24                    INDEX BY BINARY_INTEGER;
25 
26 g_dim_lvl_mtdt_tab   dim_lvl_metadata_tabtype;
27 
28 g_buckets_tab_reset          dim_lvl_buckets_tabtype;
29 g_low_band_buckets_tab       dim_lvl_buckets_tabtype;
30 g_prfmnc_band_buckets_tab    dim_lvl_buckets_tabtype;
31 g_country_buckets_tab        dim_lvl_buckets_tabtype;
32 g_abs_category_buckets_tab   dim_lvl_buckets_tabtype;
33 g_primary_job_role_tab       dim_lvl_buckets_tabtype;
34 g_wkth_wktyp_tab             dim_lvl_buckets_tabtype;
35 
36 PROCEDURE set_low_band_buckets(p_wkth_wktyp_sk_fk  IN VARCHAR2);
37 
38 END hri_mtdt_dim_lvl;