DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_CTR_SUP_GRAPH dependencies on BIS_QUERY_ATTRIBUTES_TBL

Line 10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

6: --
7: PROCEDURE get_sql2
8: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
9: x_custom_sql OUT NOCOPY VARCHAR2,
10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
11:
12: l_custom_rec BIS_QUERY_ATTRIBUTES;
13: l_sqltext VARCHAR2(10000) ;
14: l_security_clause VARCHAR2(500);

Line 31: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

27: BEGIN
28: --
29: /* Initialize table/record variables */
30: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
31: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
32:
33: /* Get security clause for Manager based security */
34: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
35:

Line 144: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

140:
141: PROCEDURE get_avg_sal_sql
142: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
143: x_custom_sql OUT NOCOPY VARCHAR2,
144: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
145:
146: l_custom_rec BIS_QUERY_ATTRIBUTES;
147: l_sqltext VARCHAR2(10000) ;
148: l_security_clause VARCHAR2(500);

Line 166: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

162: BEGIN
163: --
164: /* Initialize table/record variables */
165: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
166: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
167:
168: /* Get security clause for Manager based security */
169: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
170: