[Home] [Help]
26: Report query Function for viewby = Resource Group, Department, Resource, Org
27: */
28: PROCEDURE get_rpt_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
29: x_custom_sql OUT NOCOPY VARCHAR2,
30: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
31: IS
32: l_query VARCHAR2(15000);
33: l_view_by VARCHAR2(120);
34: l_view_by_col VARCHAR2 (120);
44: l_mv VARCHAR2 (30);
45:
46: l_resource_level_flag varchar2(1) := '0';
47:
48: l_custom_rec BIS_QUERY_ATTRIBUTES;
49:
50: l_period_type VARCHAR2(255) := NULL;
51: l_org VARCHAR2(255) := NULL;
52:
116: l_col_tbl,
117: 'N');
118:
119: -- prepare output for bind variables
120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
122:
123: -- set the basic bind variables for the status SQL
124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
307: */
308:
309: PROCEDURE get_trd_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
310: x_custom_sql OUT NOCOPY VARCHAR2,
311: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
312: IS
313: l_query VARCHAR2(15000);
314: l_view_by VARCHAR2(120);
315: l_view_by_col VARCHAR2 (120);
321: l_where_clause VARCHAR2 (4000) := '';
322:
323: l_resource_level_flag VARCHAR2(1) := '0';
324:
325: l_custom_rec BIS_QUERY_ATTRIBUTES;
326:
327: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
328: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
329:
380:
381:
382:
383: -- Prepare PMV bind variables
384: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
385: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
386:
387: -- get all the basic binds used by POA queries
388: -- Do this before adding any of our binds, since the procedure