DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_ABS_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 13: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

9: --****************************************************************************
10: --
11: PROCEDURE get_sql(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
12: ,x_custom_sql OUT NOCOPY VARCHAR2
13: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
14: IS
15:
16: l_SQLText VARCHAR2(32000);
17: l_security_clause VARCHAR2(4000);

Line 18: l_custom_rec BIS_QUERY_ATTRIBUTES ;

14: IS
15:
16: l_SQLText VARCHAR2(32000);
17: l_security_clause VARCHAR2(4000);
18: l_custom_rec BIS_QUERY_ATTRIBUTES ;
19:
20: /* Dynamic SQL Controls */
21: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;
22: l_abs_fact_sql VARCHAR2(10000);

Line 37: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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