APPS.HRI_OLTP_PMV_ABS_CAT dependencies on BIS_QUERY_ATTRIBUTES

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 15: l_custom_rec BIS_QUERY_ATTRIBUTES;

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);
17:
18: -- Parameter values
19: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

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 225: l_custom_rec BIS_QUERY_ATTRIBUTES ;

221: IS
222:
223: l_SQLText VARCHAR2(32000);
224: l_security_clause VARCHAR2(4000);
225: l_custom_rec BIS_QUERY_ATTRIBUTES ;
226:
227: /* Dynamic SQL Controls */
228: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;
229: l_abs_fact_sql VARCHAR2(10000);

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: