APPS.HRI_OLTP_PMV_WRKFC_TRN_SUMMARY dependencies on BIS_QUERY_ATTRIBUTES

Line 142: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS

138: /* Entry point for staff summary pivot report SQL */
139: PROCEDURE get_sql_pvt
140: (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
141: x_custom_sql OUT NOCOPY VARCHAR2,
142: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
143:
144: l_sqltext VARCHAR2(32767);
145: l_custom_rec BIS_QUERY_ATTRIBUTES;
146: l_security_clause VARCHAR2(4000);

Line 145: l_custom_rec BIS_QUERY_ATTRIBUTES;

141: x_custom_sql OUT NOCOPY VARCHAR2,
142: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL) IS
143:
144: l_sqltext VARCHAR2(32767);
145: l_custom_rec BIS_QUERY_ATTRIBUTES;
146: l_security_clause VARCHAR2(4000);
147: l_direct_reports_string VARCHAR2(100);
148:
149: /* Dynamic SQL support */

Line 177: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();

173: BEGIN
174:
175: /* Initialize out parameters */
176: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
177: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
178:
179: /* Get common parameter values */
180: hri_oltp_pmv_util_param.get_parameters_from_table
181: (p_page_parameter_tbl => p_page_parameter_tbl,