PACKAGE: APPS.HRI_OLTP_PMV_UTIL_PARAM

Source

1 PACKAGE hri_oltp_pmv_util_param AS
2 /* $Header: hrioputp.pkh 120.2 2005/09/20 05:02:44 jrstewar noship $ */
3 
4 TYPE HRI_PMV_PARAM_REC_TYPE IS RECORD
5       (time_curr_start_date   DATE,
6        time_curr_end_date     DATE,
7        time_comp_start_date   DATE,
8        time_comp_end_date     DATE,
9        page_period_type       VARCHAR2(30),
10        time_comparison_type   VARCHAR2(30),
11        peo_supervisor_id      NUMBER,
12        currency_code          VARCHAR2(40),
13        rate_type              VARCHAR2(40),
14        event_sep_type         VARCHAR2(30),
15        absence_duration_uom   VARCHAR2(100),
16        absence_category       VARCHAR2(4000),
17        absence_type           VARCHAR2(4000),
18        absence_reason         VARCHAR2(4000),
19        view_by                VARCHAR2(100),
20        peo_sup_rollup_flag    VARCHAR2(30),
21        wkth_wktyp_sk_fk       VARCHAR2(30),
22        order_by               VARCHAR2(1000),
23        bis_region_code        VARCHAR2(30),
24        debug_header           VARCHAR2(4000));
25 
26 TYPE HRI_PMV_BIND_REC_TYPE IS RECORD
27       (pmv_bind_string        VARCHAR2(32000),
28        sql_bind_string        VARCHAR2(32000));
29 
30 TYPE HRI_PMV_BIND_TAB_TYPE IS TABLE OF HRI_PMV_BIND_REC_TYPE
31        INDEX BY VARCHAR2(100);
32 
33 PROCEDURE get_parameters_from_table
34            (p_page_parameter_tbl   IN BIS_PMV_PAGE_PARAMETER_TBL,
35             p_parameter_rec        OUT NOCOPY HRI_PMV_PARAM_REC_TYPE,
36             p_bind_tab             OUT NOCOPY HRI_PMV_BIND_TAB_TYPE);
37 
38 END hri_oltp_pmv_util_param;