DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_HR_CTR dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 15: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

11: --
12: PROCEDURE get_kpi
13: (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) IS
16:
17: l_SQLText VARCHAR2(32000);
18: l_security_clause VARCHAR2(4000);
19: l_custom_rec BIS_QUERY_ATTRIBUTES ;

Line 33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

29: BEGIN
30:
31: /* Initialize out parameters */
32: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
34:
35: /* Get common parameter values */
36: hri_oltp_pmv_util_param.get_parameters_from_table
37: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 106: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

102: --****************************************************************************
103: --
104: PROCEDURE GET_SQL2(p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL
105: ,x_custom_sql OUT NOCOPY VARCHAR2
106: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
107:
108: l_SQLText VARCHAR2(32000);
109: l_security_clause VARCHAR2(4000);
110: l_custom_rec BIS_QUERY_ATTRIBUTES ;

Line 129: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

125:
126: BEGIN
127: /* Initialize out parameters */
128: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
129: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
130:
131: /* Get common parameter values */
132: hri_oltp_pmv_util_param.get_parameters_from_table
133: (p_page_parameter_tbl => p_page_parameter_tbl,