APPS.HRI_OLTP_PMV_WMV_TRN_SUMMRY dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 34: (p_parameter_rec IN hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE,

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

Line 35: p_bind_tab IN hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE,

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

Line 161: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

157: l_wrkfc_fact_sql VARCHAR2(32767);
158: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
159: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
160:
161: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
162: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
163:
164: /* Messages */
165: l_direct_reports_string VARCHAR2(240);

Line 162: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

158: l_wrkfc_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
159: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.wcnt_chg_fact_param_type;
160:
161: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
162: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
163:
164: /* Messages */
165: l_direct_reports_string VARCHAR2(240);
166:

Line 174: hri_oltp_pmv_util_param.get_parameters_from_table

170: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
171: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
172:
173: /* Get common parameter values */
174: hri_oltp_pmv_util_param.get_parameters_from_table
175: (p_page_parameter_tbl => p_page_parameter_tbl,
176: p_parameter_rec => l_parameter_rec,
177: p_bind_tab => l_bind_tab);
178: