APPS.HRI_OLTP_PMV_WMV_SAL_SUP dependencies on BIS_QUERY_ATTRIBUTES

Line 9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

5: ';
6:
7: PROCEDURE get_sql2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
8: x_custom_sql OUT NOCOPY VARCHAR2,
9: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
10:
11: l_sqltext VARCHAR2(32767);
12: l_security_clause VARCHAR2(4000);
13: l_custom_rec BIS_QUERY_ATTRIBUTES;

Line 13: l_custom_rec BIS_QUERY_ATTRIBUTES;

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

Line 35: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

31: BEGIN
32:
33: /* Initialize out parameters */
34: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
35: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
36:
37: /* Get security clause for Manager based security */
38: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
39:

Line 195: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

191: -- ----------------------------------------------------------------------
192: --
193: PROCEDURE get_sal_kpi(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
194: x_custom_sql OUT NOCOPY VARCHAR2,
195: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
196: --
197: -- The security clause
198: --
199: l_security_clause VARCHAR2(4000);

Line 216: l_custom_rec BIS_QUERY_ATTRIBUTES;

212: --
213: -- Inner SQL
214: --
215: l_inn_sql VARCHAR2(32767);
216: l_custom_rec BIS_QUERY_ATTRIBUTES;
217: --
218: BEGIN
219: --
220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

Line 220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

216: l_custom_rec BIS_QUERY_ATTRIBUTES;
217: --
218: BEGIN
219: --
220: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
221: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
222: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
223: --
224: -- Get the parameter information from the page parameter table