APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on HRI_BPL_FACT_SUP_WCNT_CHG_SQL

Line 125: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

121: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
122: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
123:
124: /* Dynamic SQL Controls */
125: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
126: l_wcnt_chg_fact_sql VARCHAR2(10000);
127:
128: /* Drill URLs */
129: l_drill_url1 VARCHAR2(1000);

Line 155: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

151: /* Get SQL for workforce changes fact */
152: l_wcnt_chg_fact_params.bind_format := 'PMV';
153: l_wcnt_chg_fact_params.include_comp := 'Y';
154: l_wcnt_chg_fact_params.include_sep := 'Y';
155: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
156: (p_parameter_rec => l_parameter_rec,
157: p_bind_tab => l_bind_tab,
158: p_wcnt_chg_params => l_wcnt_chg_fact_params,
159: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_RNK_JFN_GRAPH');

Line 251: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;

247:
248: l_drill_url1 VARCHAR2(1000);
249:
250: /* Dynamic SQL Controls */
251: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
252: l_wcnt_chg_fact_sql VARCHAR2(10000);
253:
254: BEGIN
255: /* Initialize out parameters */

Line 286: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql

282: l_wcnt_chg_fact_params.bind_format := 'PMV';
283: l_wcnt_chg_fact_params.include_comp := 'Y';
284: l_wcnt_chg_fact_params.include_sep := 'Y';
285: l_wcnt_chg_fact_params.bucket_dim := 'HRI_PRFRMNC+HRI_PRFMNC_RTNG_X';
286: l_wcnt_chg_fact_sql := hri_bpl_fact_sup_wcnt_chg_sql.get_sql
287: (p_parameter_rec => l_parameter_rec,
288: p_bind_tab => l_bind_tab,
289: p_wcnt_chg_params => l_wcnt_chg_fact_params,
290: p_calling_module => 'HRI_OLTP_PMV_TRN_BCKT_GRAPH.GET_SQL_RNK_RSN_GRAPH');