APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 30: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

26: );
27:
28: /* Dynamically changes report SQL depending on parameters */
29: PROCEDURE set_dynamic_sql
30: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
31: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
32: p_dynsql_rec OUT NOCOPY dynamic_sql_rec_type) IS
33:
34: BEGIN

Line 31: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

27:
28: /* Dynamically changes report SQL depending on parameters */
29: PROCEDURE set_dynamic_sql
30: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,
31: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,
32: p_dynsql_rec OUT NOCOPY dynamic_sql_rec_type) IS
33:
34: BEGIN
35:

Line 159: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

155: l_wcnt_chg_fact_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
156: l_wcnt_chg_fact_sql VARCHAR2(10000);
157:
158: /* Parameter values */
159: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
160: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
161:
162: /* Annualization factor for period type parameter */
163: l_calc_anl_factor NUMBER;

Line 160: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

156: l_wcnt_chg_fact_sql VARCHAR2(10000);
157:
158: /* Parameter values */
159: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
160: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
161:
162: /* Annualization factor for period type parameter */
163: l_calc_anl_factor NUMBER;
164:

Line 180: hri_oltp_pmv_util_param.get_parameters_from_table

176: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
177: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
178:
179: /* Get common parameter values */
180: hri_oltp_pmv_util_param.get_parameters_from_table
181: (p_page_parameter_tbl => p_page_parameter_tbl,
182: p_parameter_rec => l_parameter_rec,
183: p_bind_tab => l_bind_tab);
184: