16: l_sqltext VARCHAR2(32767);
17: l_custom_rec BIS_QUERY_ATTRIBUTES;
18:
19: /* Parameter values */
20: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
21: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
22:
23:
24: BEGIN
17: l_custom_rec BIS_QUERY_ATTRIBUTES;
18:
19: /* Parameter values */
20: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
21: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
22:
23:
24: BEGIN
25:
29: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
30: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
31:
32: /* Get common parameter values */
33: hri_oltp_pmv_util_param.get_parameters_from_table
34: (p_page_parameter_tbl => p_page_parameter_tbl,
35: p_parameter_rec => l_parameter_rec,
36: p_bind_tab => l_bind_tab);
37:
212: l_sqltext VARCHAR2(32767);
213: l_custom_rec BIS_QUERY_ATTRIBUTES;
214:
215: /* Parameter values */
216: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
217: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
218:
219:
220: BEGIN
213: l_custom_rec BIS_QUERY_ATTRIBUTES;
214:
215: /* Parameter values */
216: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
217: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
218:
219:
220: BEGIN
221:
225: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
226: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
227:
228: /* Get common parameter values */
229: hri_oltp_pmv_util_param.get_parameters_from_table
230: (p_page_parameter_tbl => p_page_parameter_tbl,
231: p_parameter_rec => l_parameter_rec,
232: p_bind_tab => l_bind_tab);
233:
673: l_sqltext VARCHAR2(32767);
674: l_custom_rec BIS_QUERY_ATTRIBUTES;
675:
676: /* Parameter values */
677: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
678: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
679:
680:
681: BEGIN
674: l_custom_rec BIS_QUERY_ATTRIBUTES;
675:
676: /* Parameter values */
677: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
678: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
679:
680:
681: BEGIN
682:
685: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
686: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
687:
688: /* Get common parameter values */
689: /* hri_oltp_pmv_util_param.get_parameters_from_table
690: (p_page_parameter_tbl => p_page_parameter_tbl,
691: p_parameter_rec => l_parameter_rec,
692: p_bind_tab => l_bind_tab); */
693:
690: (p_page_parameter_tbl => p_page_parameter_tbl,
691: p_parameter_rec => l_parameter_rec,
692: p_bind_tab => l_bind_tab); */
693:
694: hri_oltp_pmv_util_param.get_parameters_from_table
695: (p_page_parameter_tbl => p_page_parameter_tbl,
696: p_parameter_rec => l_parameter_rec,
697: p_bind_tab => l_bind_tab);
698:
811: l_sqltext VARCHAR2(32767);
812: l_custom_rec BIS_QUERY_ATTRIBUTES;
813:
814: /* Parameter values */
815: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
816: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
817:
818: BEGIN
819:
812: l_custom_rec BIS_QUERY_ATTRIBUTES;
813:
814: /* Parameter values */
815: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
816: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
817:
818: BEGIN
819:
820: /* Initialize out parameters */
823: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
824:
825:
826: /* Get common parameter values */
827: hri_oltp_pmv_util_param.get_parameters_from_table
828: (p_page_parameter_tbl => p_page_parameter_tbl,
829: p_parameter_rec => l_parameter_rec,
830: p_bind_tab => l_bind_tab);
831:
985: l_sqltext VARCHAR2(32767);
986: l_custom_rec BIS_QUERY_ATTRIBUTES;
987:
988: /* Parameter values */
989: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
990: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
991:
992: BEGIN
993:
986: l_custom_rec BIS_QUERY_ATTRIBUTES;
987:
988: /* Parameter values */
989: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
990: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
991:
992: BEGIN
993:
994: /* Initialize out parameters */
996: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
997: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
998:
999: /* Get common parameter values */
1000: hri_oltp_pmv_util_param.get_parameters_from_table
1001: (p_page_parameter_tbl => p_page_parameter_tbl,
1002: p_parameter_rec => l_parameter_rec,
1003: p_bind_tab => l_bind_tab);
1004:
1179: l_sqltext VARCHAR2(32767);
1180: l_custom_rec BIS_QUERY_ATTRIBUTES;
1181:
1182: /* Parameter values */
1183: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
1184: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
1185:
1186:
1187: BEGIN
1180: l_custom_rec BIS_QUERY_ATTRIBUTES;
1181:
1182: /* Parameter values */
1183: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
1184: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
1185:
1186:
1187: BEGIN
1188:
1192: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
1193:
1194:
1195: /* Get common parameter values */
1196: hri_oltp_pmv_util_param.get_parameters_from_table
1197: (p_page_parameter_tbl => p_page_parameter_tbl,
1198: p_parameter_rec => l_parameter_rec,
1199: p_bind_tab => l_bind_tab);
1200: