APPS.HRI_OLTP_PMV_WMV_WF_SUP dependencies on HRI_BPL_FACT_SUP_WRKFC_SQL

Line 26: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

22: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
23: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
24:
25: /* Dynamic SQL controls */
26: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
27: l_wrkfc_fact_sql VARCHAR2(10000);
28:
29: BEGIN
30:

Line 53: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

49: l_wrkfc_fact_params.include_comp := 'Y';
50: l_wrkfc_fact_params.include_hdc := 'Y';
51: l_wrkfc_fact_params.kpi_mode := 'Y';
52: l_wrkfc_fact_params.bucket_dim := 'HRI_PRSNTYP+HRI_WKTH_WKTYP';
53: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
54: (p_parameter_rec => l_parameter_rec,
55: p_bind_tab => l_bind_tab,
56: p_wrkfc_params => l_wrkfc_fact_params,
57: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_KPI');

Line 141: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

137: l_drill_url7 VARCHAR2(300);
138: l_drill_url8 VARCHAR2(300);
139:
140: /* Dynamic SQL controls */
141: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
142: l_wrkfc_fact_sql VARCHAR2(10000);
143: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
144: l_wcnt_chg_fact_sql VARCHAR2(10000);
145:

Line 267: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

263: l_wrkfc_fact_params.bind_format := 'PMV';
264: l_wrkfc_fact_params.include_comp := 'Y';
265: l_wrkfc_fact_params.include_hdc := 'Y';
266: l_wrkfc_fact_params.include_start := 'Y';
267: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
268: (p_parameter_rec => l_parameter_rec,
269: p_bind_tab => l_bind_tab,
270: p_wrkfc_params => l_wrkfc_fact_params,
271: p_calling_module => 'HRI_OLTP_PMV_WMV_WF_SUP.GET_SQL2');