APPS.HRI_BPL_FACT_ABS_SQL dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 150: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

146: /******************************************************************************/
147: /* Populates g_binds with the selected BIND format */
148: /******************************************************************************/
149: PROCEDURE populate_global_bind_table
150: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
151: p_bind_format IN VARCHAR2) IS
152:
153: l_parameter_name VARCHAR2(100);
154:

Line 186: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

182: /* parameter is set the name of that parameter is returned. This helps select */
183: /* the most efficient fact to retrieve the data from. */
184: /******************************************************************************/
185: PROCEDURE analyze_parameters
186: (p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
187: p_fact_conditions OUT NOCOPY VARCHAR2,
188: p_parameter_count OUT NOCOPY PLS_INTEGER,
189: p_single_param OUT NOCOPY VARCHAR2) IS
190:

Line 255: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

251: /* If a fact table is selected that does not have a snapshot available then */
252: /* p_use_snapshot is set accordingly */
253: /******************************************************************************/
254: PROCEDURE set_fact_table
255: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
256: p_bucket_dim IN VARCHAR2,
257: p_abs_drtn_days IN VARCHAR2,
258: p_abs_drtn_hrs IN VARCHAR2,
259: p_abs_in_period IN VARCHAR2,

Line 369: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

365: /* - bucket_dim: the measures is sampled for all buckets of dimension */
366: /* */
367: /******************************************************************************/
368: FUNCTION build_columns
369: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
370: p_abs_params IN abs_fact_param_type,
371: p_template_standard IN VARCHAR2,
372: p_template_bucket IN VARCHAR2,
373: p_measure_alias IN VARCHAR2)

Line 442: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

438: /* Puts together the FROM/WHERE clauses depending on whether the view by */
439: /* manager special case is selected. */
440: /******************************************************************************/
441: FUNCTION build_sql
442: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
443: p_abs_params IN abs_fact_param_type,
444: p_use_snapshot IN BOOLEAN,
445: p_fact_table IN VARCHAR2,
446: p_fact_conditions IN VARCHAR2)

Line 643: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

639: /* Main entry point, takes PMV parameters and SQL control parameters */
640: /* Returns the SQL statement for the PMV report. */
641: /******************************************************************************/
642: FUNCTION get_sql
643: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
644: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
645: p_abs_params IN abs_fact_param_type)
646: RETURN VARCHAR2 IS
647:

Line 644: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

640: /* Returns the SQL statement for the PMV report. */
641: /******************************************************************************/
642: FUNCTION get_sql
643: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
644: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
645: p_abs_params IN abs_fact_param_type)
646: RETURN VARCHAR2 IS
647:
648: l_date_list VARCHAR2(3000);

Line 707: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

703: /* Returns the SQL statement for the PMV report. */
704: /* Version with debugging built in */
705: /******************************************************************************/
706: FUNCTION get_sql
707: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
708: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
709: p_abs_params IN abs_fact_param_type,
710: p_calling_module IN VARCHAR2)
711: RETURN VARCHAR2 IS

Line 708: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

704: /* Version with debugging built in */
705: /******************************************************************************/
706: FUNCTION get_sql
707: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
708: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
709: p_abs_params IN abs_fact_param_type,
710: p_calling_module IN VARCHAR2)
711: RETURN VARCHAR2 IS
712: