DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_ABS_CAT dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 12: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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

Line 45: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

41: BEGIN
42:
43: /* Initialize out parameters */
44: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
45: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
46:
47: /* Get common parameter values */
48: hri_oltp_pmv_util_param.get_parameters_from_table
49: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 220: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

216: END get_sql_abscat_t4 ;
217:
218: PROCEDURE GET_SQL_TN(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
219: ,x_custom_sql OUT NOCOPY VARCHAR2
220: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
221: IS
222:
223: l_SQLText VARCHAR2(32000);
224: l_security_clause VARCHAR2(4000);

Line 243: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

239:
240: BEGIN
241: /* Initialize out parameters */
242: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
243: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
244:
245: /* Get security clause for Manager based security */
246: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
247: