APPS.HRI_OLTP_PMV_WMV_HR_CTR 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 54: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

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

Line 123: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

119: /* translation values */
120: l_others_string VARCHAR2(80);
121:
122: /* Dynamic SQL controls */
123: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
124: l_wrkfc_fact_sql VARCHAR2(10000);
125:
126: BEGIN
127: /* Initialize out parameters */

Line 155: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql

151: l_wrkfc_fact_params.bind_format := 'PMV';
152: l_wrkfc_fact_params.include_comp := 'Y';
153: l_wrkfc_fact_params.include_hdc := 'Y';
154: l_wrkfc_fact_params.bucket_dim := 'JOB+PRIMARY_JOB_ROLE';
155: l_wrkfc_fact_sql := hri_bpl_fact_sup_wrkfc_sql.get_sql
156: (p_parameter_rec => l_parameter_rec,
157: p_bind_tab => l_bind_tab,
158: p_wrkfc_params => l_wrkfc_fact_params,
159: p_calling_module => 'HRI_OLTP_PMV_WMV_HR_CTR_SUP.GET_SQL2');