DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_PER_MGR_LOV dependencies on BIS_QUERY_ATTRIBUTES

Line 6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

2: /* $Header: hriopmgrlov.pkb 120.8 2006/02/08 02:53 smohapat noship $ */
3:
4: PROCEDURE GET_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5: x_custom_sql OUT NOCOPY VARCHAR2,
6: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
7: IS
8:
9: /* Parameter values */
10: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 12: l_custom_rec BIS_QUERY_ATTRIBUTES ;

8:
9: /* Parameter values */
10: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
11: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
12: l_custom_rec BIS_QUERY_ATTRIBUTES ;
13: l_search VARCHAR2(500);
14: l_value VARCHAR2(250);
15:
16: BEGIN

Line 115: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

111: END;
112:
113: PROCEDURE GET_SQL_LEAF(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
114: x_custom_sql OUT NOCOPY VARCHAR2,
115: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
116: IS
117:
118: /* Parameter values */
119: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 121: l_custom_rec BIS_QUERY_ATTRIBUTES ;

117:
118: /* Parameter values */
119: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
120: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;
121: l_custom_rec BIS_QUERY_ATTRIBUTES ;
122:
123: l_search VARCHAR2(500);
124: l_value VARCHAR2(250);
125:

Line 131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

127: BEGIN
128:
129: /* Initialize out parameters */
130: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
131: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
132:
133: /* Get common parameter values */
134: hri_oltp_pmv_util_param.get_parameters_from_table
135: (p_page_parameter_tbl => p_page_parameter_tbl,