APPS.HRI_BPL_FACT_SUP_WCNT_CHG_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 176: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

172: /******************************************************************************/
173: /* Populates g_binds with the selected BIND format */
174: /******************************************************************************/
175: PROCEDURE populate_global_bind_table
176: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
177: p_bind_format IN VARCHAR2) IS
178:
179: l_parameter_name VARCHAR2(100);
180:

Line 212: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

208: /* parameter is set the name of that parameter is returned. This helps select */
209: /* the most efficient fact to retrieve the data from. */
210: /******************************************************************************/
211: PROCEDURE analyze_parameters
212: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
213: p_fact_conditions OUT NOCOPY VARCHAR2,
214: p_parameter_count OUT NOCOPY PLS_INTEGER,
215: p_single_param OUT NOCOPY VARCHAR2) IS
216:

Line 277: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

273: /* If a fact table is selected that does not have a snapshot available then */
274: /* p_use_snapshot is set accordingly */
275: /******************************************************************************/
276: PROCEDURE set_fact_table
277: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
278: p_bucket_dim IN VARCHAR2,
279: p_include_hire IN VARCHAR2,
280: p_include_trin IN VARCHAR2,
281: p_include_trout IN VARCHAR2,

Line 486: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

482: /* - bucket_dim: the measures is sampled for all buckets of dimension */
483: /* */
484: /******************************************************************************/
485: FUNCTION build_columns
486: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
487: p_wcnt_chg_params IN wcnt_chg_fact_param_type,
488: p_template_standard IN VARCHAR2,
489: p_template_bucket IN VARCHAR2,
490: p_measure_alias IN VARCHAR2)

Line 608: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

604: /* Puts together the FROM/WHERE clauses depending on whether the view by */
605: /* manager special case is selected. */
606: /******************************************************************************/
607: FUNCTION build_sql
608: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
609: p_wcnt_chg_params IN wcnt_chg_fact_param_type,
610: p_use_snapshot IN BOOLEAN,
611: p_fact_table IN VARCHAR2,
612: p_fact_conditions IN VARCHAR2)

Line 876: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

872: /* Main entry point, takes PMV parameters and SQL control parameters */
873: /* Returns the SQL statement for the PMV report. */
874: /******************************************************************************/
875: FUNCTION get_sql
876: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
877: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
878: p_wcnt_chg_params IN wcnt_chg_fact_param_type)
879: RETURN VARCHAR2 IS
880:

Line 877: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

873: /* Returns the SQL statement for the PMV report. */
874: /******************************************************************************/
875: FUNCTION get_sql
876: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
877: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
878: p_wcnt_chg_params IN wcnt_chg_fact_param_type)
879: RETURN VARCHAR2 IS
880:
881: l_date_list VARCHAR2(3000);

Line 940: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

936: /* Returns the SQL statement for the PMV report. */
937: /* Version with debugging built in */
938: /******************************************************************************/
939: FUNCTION get_sql
940: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
941: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
942: p_wcnt_chg_params IN wcnt_chg_fact_param_type,
943: p_calling_module IN VARCHAR2)
944: RETURN VARCHAR2 IS

Line 941: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

937: /* Version with debugging built in */
938: /******************************************************************************/
939: FUNCTION get_sql
940: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
941: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
942: p_wcnt_chg_params IN wcnt_chg_fact_param_type,
943: p_calling_module IN VARCHAR2)
944: RETURN VARCHAR2 IS
945: