[Home] [Help]
7: FUNCTION get_status_sel_clause(p_view_by_dim in VARCHAR2, p_period_type in VARCHAR2, p_org in VARCHAR2) return VARCHAR2;
8:
9: PROCEDURE mtl_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
10: x_custom_sql OUT NOCOPY VARCHAR2,
11: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
12: IS
13: l_query VARCHAR2(15000);
14: l_view_by VARCHAR2(120);
15: l_view_by_col VARCHAR2 (120);
30: l_mv VARCHAR2 (30);
31:
32: l_item_cat_flag varchar2(1) := '0';
33:
34: l_custom_rec BIS_QUERY_ATTRIBUTES;
35:
36: BEGIN
37:
38: -- clear out the tables.
92: l_col_tbl,
93: 'N');
94:
95: -- prepare output for bind variables
96: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
97: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
98:
99: -- set the basic bind variables for the status SQL
100: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
197:
198:
199: PROCEDURE mtl_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
200: x_custom_sql OUT NOCOPY VARCHAR2,
201: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
202: IS
203: l_query VARCHAR2(15000);
204: l_view_by VARCHAR2(120);
205: l_view_by_col VARCHAR2 (120);
214: l_where_clause VARCHAR2 (4000) := '';
215:
216: l_item_cat_flag VARCHAR2(1) := '0';
217:
218: l_custom_rec BIS_QUERY_ATTRIBUTES;
219:
220: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
221: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
222:
272: 'N');
273:
274:
275: -- Prepare PMV bind variables
276: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
277: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
278:
279: -- get all the basic binds used by POA queries
280: -- Do this before adding any of our binds, since the procedure