APPS.HRI_OLTP_PMV_HDCNT_ORGMGR dependencies on BIS_QUERY_ATTRIBUTES

Line 11: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

7:
8:
9: PROCEDURE GET_KPI_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
10: x_custom_sql OUT NOCOPY VARCHAR2,
11: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
12:
13: l_sqltext VARCHAR2(32767);
14: l_custom_rec BIS_QUERY_ATTRIBUTES;
15:

Line 14: l_custom_rec BIS_QUERY_ATTRIBUTES;

10: x_custom_sql OUT NOCOPY VARCHAR2,
11: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
12:
13: l_sqltext VARCHAR2(32767);
14: l_custom_rec BIS_QUERY_ATTRIBUTES;
15:
16: /* Parameter values */
17: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
18: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 27: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

23:
24: /* Initialize out parameters */
25:
26: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
27: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
28:
29:
30: /* Get common parameter values */
31: hri_oltp_pmv_util_param.get_parameters_from_table

Line 200: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

196: -- ----------------------------------------------------
197:
198: PROCEDURE GET_ORG_SQL(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
199: x_custom_sql OUT NOCOPY VARCHAR2,
200: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
201:
202: l_sqltext VARCHAR2(32767);
203: l_custom_rec BIS_QUERY_ATTRIBUTES;
204: l_trend_table VARCHAR2(4000);

Line 203: l_custom_rec BIS_QUERY_ATTRIBUTES;

199: x_custom_sql OUT NOCOPY VARCHAR2,
200: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
201:
202: l_sqltext VARCHAR2(32767);
203: l_custom_rec BIS_QUERY_ATTRIBUTES;
204: l_trend_table VARCHAR2(4000);
205: l_previous_periods NUMBER;
206: l_projection_periods NUMBER;
207:

Line 225: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

221:
222: /* Initialize out parameters */
223:
224: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
225: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
226:
227:
228: /* Get common parameter values */
229: hri_oltp_pmv_util_param.get_parameters_from_table