APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on BIS_QUERY_ATTRIBUTES

Line 10: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

6:
7: PROCEDURE get_sql_bckt_perf
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_security_clause VARCHAR2(4000);
14: l_SQLText VARCHAR2(4000);

Line 12: l_custom_rec BIS_QUERY_ATTRIBUTES;

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_security_clause VARCHAR2(4000);
14: l_SQLText VARCHAR2(4000);
15:
16: /* Parameter values */

Line 33: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

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

Line 114: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

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

Line 117: l_custom_rec BIS_QUERY_ATTRIBUTES;

113: x_custom_sql OUT NOCOPY VARCHAR2,
114: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
115:
116: l_SQLText VARCHAR2(32767) ;
117: l_custom_rec BIS_QUERY_ATTRIBUTES;
118: l_security_clause VARCHAR2(4000);
119:
120: /* Parameter values */
121: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;

Line 135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

131: BEGIN
132:
133: /* Initialize out parameters */
134: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
135: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
136:
137: /* Get common parameter values */
138: hri_oltp_pmv_util_param.get_parameters_from_table
139: (p_page_parameter_tbl => p_page_parameter_tbl,

Line 237: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

233:
234: PROCEDURE get_sql_rnk_rsn_graph
235: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
236: x_custom_sql OUT NOCOPY VARCHAR2,
237: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
238:
239: l_SQLText VARCHAR2(32767) ;
240: l_custom_rec BIS_QUERY_ATTRIBUTES;
241:

Line 240: l_custom_rec BIS_QUERY_ATTRIBUTES;

236: x_custom_sql OUT NOCOPY VARCHAR2,
237: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
238:
239: l_SQLText VARCHAR2(32767) ;
240: l_custom_rec BIS_QUERY_ATTRIBUTES;
241:
242: /* Parameter values */
243: l_parameter_rec hri_oltp_pmv_util_param.HRI_PMV_PARAM_REC_TYPE;
244: l_bind_tab hri_oltp_pmv_util_param.HRI_PMV_BIND_TAB_TYPE;

Line 257: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

253:
254: BEGIN
255: /* Initialize out parameters */
256: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
257: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
258:
259: /* Get common parameter values */
260: hri_oltp_pmv_util_param.get_parameters_from_table
261: (p_page_parameter_tbl => p_page_parameter_tbl,