APPS.HRI_OLTP_PMV_WMV_TRN_SUP_BCKT dependencies on HRI_OLTP_PMV_UTIL_PARAM

Line 46: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

42: l_custom_rec BIS_QUERY_ATTRIBUTES;
43: l_security_clause VARCHAR2(4000);
44:
45: /* Parameter values */
46: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
47: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
48:
49: /* drill urls */
50: l_drill_url1 VARCHAR2(1000);

Line 47: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

43: l_security_clause VARCHAR2(4000);
44:
45: /* Parameter values */
46: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
47: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
48:
49: /* drill urls */
50: l_drill_url1 VARCHAR2(1000);
51: l_drill_url2 VARCHAR2(1000);

Line 86: hri_oltp_pmv_util_param.get_parameters_from_table

82: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
83: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
84:
85: /* Get common parameter values */
86: hri_oltp_pmv_util_param.get_parameters_from_table
87: (p_page_parameter_tbl => p_page_parameter_tbl,
88: p_parameter_rec => l_parameter_rec,
89: p_bind_tab => l_bind_tab);
90:

Line 476: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

472: l_custom_rec BIS_QUERY_ATTRIBUTES;
473: l_security_clause VARCHAR2(4000);
474:
475: /* Parameter values */
476: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
477: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
478:
479: /* Dynamic SQL Controls */
480: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;

Line 477: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

473: l_security_clause VARCHAR2(4000);
474:
475: /* Parameter values */
476: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
477: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
478:
479: /* Dynamic SQL Controls */
480: l_wrkfc_fact_params hri_bpl_fact_sup_wrkfc_sql.wrkfc_fact_param_type;
481: l_wrkfc_fact_sql VARCHAR2(10000);

Line 515: hri_oltp_pmv_util_param.get_parameters_from_table

511: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
512: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
513:
514: /* Get common parameter values */
515: hri_oltp_pmv_util_param.get_parameters_from_table
516: (p_page_parameter_tbl => p_page_parameter_tbl,
517: p_parameter_rec => l_parameter_rec,
518: p_bind_tab => l_bind_tab);
519:

Line 845: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

841: l_security_clause VARCHAR2(4000);
842: --
843: -- Page parameters
844: --
845: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
846: --
847: -- Bind values for SQL and PMV mode
848: --
849: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 849: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

845: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
846: --
847: -- Bind values for SQL and PMV mode
848: --
849: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
850: --
851: -- Parameter values for getting the inner SQL
852: --
853: l_wcnt_chg_params hri_bpl_fact_sup_wcnt_chg_sql.WCNT_CHG_FACT_PARAM_TYPE;

Line 868: hri_oltp_pmv_util_param.get_parameters_from_table

864: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
865: --
866: -- Get the parameter information from the page parameter table
867: --
868: hri_oltp_pmv_util_param.get_parameters_from_table
869: (p_page_parameter_tbl => p_page_parameter_tbl,
870: p_parameter_rec => l_parameter_rec,
871: p_bind_tab => l_bind_tab);
872: --