[Home] [Help]
18: p_xtd IN VARCHAR2,
19: p_comparison_type IN VARCHAR2,
20: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
21: p_context_code IN VARCHAR2,
22: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
23: ) ;
24: function get_msg (p_current in varchar2)return varchar2;
25:
26: PROCEDURE bind_reqfact_date(
65:
66: return l_where;
67: END;
68:
69: PROCEDURE process_parameters(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
70: p_view_by out NOCOPY VARCHAR2,
71: p_view_by_col_name OUT NOCOPY VARCHAR2,
72: p_view_by_value OUT NOCOPY VARCHAR2,
73: p_comparison_type out NOCOPY VARCHAR2,
218: get_binds(p_trend,p_mv_set,p_xtd,p_comparison_type,x_custom_output, l_context_code, p_param);
219:
220: END process_parameters;
221:
222: PROCEDURE drill_process_parameters(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
223: p_cur_suffix out NOCOPY VARCHAR2,
224: p_where_clause out NOCOPY VARCHAR2,
225: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl,
226: p_func_area IN VaRCHAR2,
650:
651:
652: PROCEDURE populate_in_join_tbl(
653: p_in_join_tbl out NOCOPY poa_dbi_util_pkg.poa_dbi_in_join_tbl
654: , p_param in BIS_PMV_PAGE_PARAMETER_TBL
655: , p_dim_map in poa_dbi_util_pkg.poa_dbi_dim_map
656: , p_context_code VARCHAR2
657: , p_version in VARCHAR2
658: , p_mv_set in varchar2
1188: p_xtd IN VARCHAR2,
1189: p_comparison_type IN VARCHAR2,
1190: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL,
1191: p_context_code IN VARCHAR2,
1192: p_param IN BIS_PMV_PAGE_PARAMETER_TBL
1193: )
1194: IS
1195: l_custom_rec BIS_QUERY_ATTRIBUTES;
1196: BEGIN
1737: when others then
1738: return '2';
1739: end get_display_commodity;
1740:
1741: procedure hide_parameter(p_param in bis_pmv_page_parameter_tbl, hideParameter out nocopy varchar2)
1742: is
1743: l_bis_calling_parameter varchar2(100) := 'NA';
1744: l_context_code varchar2(10) := 'OU/COM';
1745: l_flag varchar2(1) := 'N';
1779: * procedure returns a 'N' (meaning show) if the context code is COMP. Hence the three
1780: * dimensions are hidden on the Commodity Spend Analysis dashboard but
1781: * shown on the Spend Analysis (Public Sector) dashboard.
1782: */
1783: procedure hide_parameter2(p_param in bis_pmv_page_parameter_tbl, hideParameter out nocopy varchar2)
1784: is
1785: l_context_code varchar2(10) := 'OU/COM';
1786: l_flag varchar2(1) := 'Y';
1787: begin
1801: * procedure returns a 'Y' (meaning hide) if the context code is COMP. Hence the three
1802: * dimensions are shown on the Commodity Spend Analysis dashboard but
1803: * hidden on the Spend Analysis (Public Sector) dashboard.
1804: */
1805: procedure hide_parameter3(p_param in bis_pmv_page_parameter_tbl, hideParameter out nocopy varchar2)
1806: is
1807: l_context_code varchar2(10) := 'OU/COM';
1808: l_bis_calling_parameter varchar2(100);
1809: l_flag varchar2(1) := 'Y';
1826: *
1827: * This procedure is called by PMV for the commodity region item of PO Purchases
1828: * report to determine whether the parameter should be hidden or not.
1829: */
1830: procedure hide_commodity(p_param in bis_pmv_page_parameter_tbl, hideParameter out nocopy varchar2)
1831: is
1832: l_function_name varchar2(30);
1833: l_bis_calling_parameter varchar2(100) := 'NA';
1834: l_context_code varchar2(10) := 'OU/COM';
2105: * This function takes the parameter table passed by PMV as input as returns
2106: * the context code. The context code is the value associated with the
2107: * POA_CONTEXT1 parameter
2108: */
2109: function get_sec_context(p_param in BIS_PMV_PAGE_PARAMETER_TBL) return varchar2
2110: is
2111: l_value varchar2(10) := 'OU/COM';
2112: begin
2113: for i in 1..p_param.count loop
2127: * the calling parameter string. The calling parameter is the value associated with the
2128: * BIS_CALLING_PARAMETER parameter. This is available only in Show/Hide
2129: * Function
2130: */
2131: function get_bis_calling_parameter(p_param in BIS_PMV_PAGE_PARAMETER_TBL) return varchar2
2132: is
2133: l_value varchar2(100);
2134: begin
2135: for i in 1..p_param.count loop
2262: *
2263: * This procedure is called by poa_dbi_pqc_pkg.trend_sql to set the values
2264: * of three global variables which are used by get_msg function
2265: */
2266: procedure get_parameters (p_page_parameter_tbl in bis_pmv_page_parameter_tbl) is
2267: l_lob_enabled_flag varchar2(1);
2268: begin
2269: -- -------------------------------------------------
2270: -- Parse through the parameter table and set globals
2301: * required for reports having company and cost center security.
2302: */
2303: procedure bind_com_cc_values(
2304: x_custom_output in out nocopy bis_query_attributes_tbl,
2305: p_param in bis_pmv_page_parameter_tbl
2306: )
2307: is
2308: l_company_value varchar2(30) := 'All';
2309: l_top_company_value varchar2(30) := 'All';