APPS.HRI_OLTP_PMV_ABS_WMV_PVT dependencies on BIS_QUERY_ATTRIBUTES

Line 15: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

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

Line 20: l_custom_rec BIS_QUERY_ATTRIBUTES ;

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

Line 58: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

54:
55: BEGIN
56: /* Initialize out parameters */
57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
58: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
59:
60: /* Get security clause for Manager based security */
61: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
62:

Line 361: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)

357: --****************************************************************************
358: --
359: PROCEDURE GET_SQL_KPI(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
360: ,x_custom_sql OUT NOCOPY VARCHAR2
361: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
362: IS
363:
364: l_SQLText VARCHAR2(32000);
365: l_security_clause VARCHAR2(4000);

Line 366: l_custom_rec BIS_QUERY_ATTRIBUTES ;

362: IS
363:
364: l_SQLText VARCHAR2(32000);
365: l_security_clause VARCHAR2(4000);
366: l_custom_rec BIS_QUERY_ATTRIBUTES ;
367:
368: /* Dynamic SQL Controls */
369: l_abs_fact_params hri_bpl_fact_abs_sql.abs_fact_param_type;
370: l_abs_fact_sql VARCHAR2(10000);

Line 393: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

389:
390: BEGIN
391: /* Initialize out parameters */
392: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
393: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
394:
395: /* Get security clause for Manager based security */
396: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
397: