[Home] [Help]
25: Report query Function for viewby = Item, Org, Cat, Customer
26: */
27: PROCEDURE margin_status_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
28: x_custom_sql OUT NOCOPY VARCHAR2,
29: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
30: IS
31: l_query VARCHAR2(32767);
32: l_view_by VARCHAR2(120);
33: l_view_by_col VARCHAR2 (120);
45: l_mv_flag_type VARCHAR2(50);
46: l_mv_set VARCHAR2(50);
47:
48: l_prd_cust_flag VARCHAR2(100);
49: l_custom_rec BIS_QUERY_ATTRIBUTES;
50:
51: BEGIN
52:
53: -- initialization block
102: p_col_name => l_col_tbl,
103: p_use_grpid => 'N');
104:
105: -- prepare output for bind variables
106: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
107: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
108:
109: -- set the basic bind variables for the status SQL
110: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
349: */
350:
351: PROCEDURE margin_trend_sql (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
352: x_custom_sql OUT NOCOPY VARCHAR2,
353: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
354: IS
355: l_query VARCHAR2(32767);
356: l_view_by VARCHAR2(120);
357: l_view_by_col VARCHAR2 (120);
360: l_cur_suffix VARCHAR2(2);
361: l_custom_sql VARCHAR2(4000);
362: l_mv VARCHAR2 (2000);
363: l_where_clause VARCHAR2 (4000);
364: l_custom_rec BIS_QUERY_ATTRIBUTES;
365:
366: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
367: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
368:
426: p_col_name => l_col_tbl,
427: p_use_grpid => 'N');
428:
429: -- Prepare PMV bind variables
430: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
431: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
432:
433: -- get all the basic binds used by POA queries
434: -- Do this before adding any of our binds, since the procedure