DBA Data[Home] [Help]

APPS.HRI_OLTP_PMV_WMV_BCKT_GRAPH dependencies on BIS_QUERY_ATTRIBUTES

Line 7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

3:
4: PROCEDURE get_sql_bckt_low
5: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: l_custom_rec BIS_QUERY_ATTRIBUTES;
10: l_security_clause VARCHAR2(4000);
11: l_SQLText VARCHAR2(4000);

Line 9: l_custom_rec BIS_QUERY_ATTRIBUTES;

5: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
6: x_custom_sql OUT NOCOPY VARCHAR2,
7: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
8:
9: l_custom_rec BIS_QUERY_ATTRIBUTES;
10: l_security_clause VARCHAR2(4000);
11: l_SQLText VARCHAR2(4000);
12:
13: /* Parameter values */

Line 30: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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

Line 115: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

111:
112: PROCEDURE get_sql_bckt_perf
113: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
114: x_custom_sql OUT NOCOPY VARCHAR2,
115: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
116:
117: l_custom_rec BIS_QUERY_ATTRIBUTES;
118: l_security_clause VARCHAR2(4000);
119: l_SQLText VARCHAR2(4000);

Line 117: l_custom_rec BIS_QUERY_ATTRIBUTES;

113: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
114: x_custom_sql OUT NOCOPY VARCHAR2,
115: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
116:
117: l_custom_rec BIS_QUERY_ATTRIBUTES;
118: l_security_clause VARCHAR2(4000);
119: l_SQLText VARCHAR2(4000);
120:
121: /* Parameter values */

Line 138: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

134: BEGIN
135:
136: /* Initialize table/record variables */
137: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
138: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
139:
140: /* Get security clause for Manager based security */
141: l_security_clause := hri_oltp_pmv_util_pkg.get_security_clause('MGR');
142: