25:
26: /*
27: Report query Function for viewby = Resource Group, Department, Resource, Org
28: */
29: PROCEDURE get_rpt_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
30: x_custom_sql OUT NOCOPY VARCHAR2,
31: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
32: IS
33: l_query VARCHAR2(15000);
248: /*
249: Report query for viewby = time
250: */
251:
252: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
253: x_custom_sql OUT NOCOPY VARCHAR2,
254: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
255: IS
256: l_query VARCHAR2(15000);