DBA Data[Home] [Help]

APPS.OKI_DBI_UTIL_PVT dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 14: p_param IN bis_pmv_page_parameter_tbl);

10: -- , p_trend IN VARCHAR2)
11: -- RETURN VARCHAR2;
12:
13: PROCEDURE split_pseudo_rs_group (
14: p_param IN bis_pmv_page_parameter_tbl);
15:
16: FUNCTION current_period_start_date (
17: as_of_date IN DATE
18: , period_type IN VARCHAR2)

Line 710: p_param IN bis_pmv_page_parameter_tbl

706: -- -----------------------------------------------------
707: -- get_parameter_values : Gets all the BIS parameters
708: -- -----------------------------------------------------
709: PROCEDURE get_parameter_values (
710: p_param IN bis_pmv_page_parameter_tbl
711: , p_view_by OUT NOCOPY VARCHAR2
712: , p_period_type OUT NOCOPY VARCHAR2
713: , p_org OUT NOCOPY VARCHAR2
714: , p_comparison_type OUT NOCOPY VARCHAR2

Line 830: p_param IN bis_pmv_page_parameter_tbl

826: , TRUE);
827: END get_parameter_values;
828:
829: PROCEDURE get_drill_across_param_val (
830: p_param IN bis_pmv_page_parameter_tbl
831: , p_attribute_code_num1 OUT NOCOPY NUMBER
832: , p_attribute_code_num2 OUT NOCOPY NUMBER
833: , p_attribute_code_num3 OUT NOCOPY NUMBER
834: , p_attribute_code_num4 OUT NOCOPY NUMBER

Line 909: p_param IN bis_pmv_page_parameter_tbl

905: , TRUE);
906: END get_drill_across_param_val;
907:
908: PROCEDURE process_parameters (
909: p_param IN bis_pmv_page_parameter_tbl
910: , p_view_by OUT NOCOPY VARCHAR2
911: , p_view_by_col_name OUT NOCOPY VARCHAR2
912: , p_comparison_type OUT NOCOPY VARCHAR2
913: , p_xtd OUT NOCOPY VARCHAR2

Line 1003: FUNCTION get_dtl_param_where( p_param IN bis_pmv_page_parameter_tbl)

999:
1000: END process_parameters;
1001:
1002: -----------------------------------------
1003: FUNCTION get_dtl_param_where( p_param IN bis_pmv_page_parameter_tbl)
1004: RETURN VARCHAR2
1005: IS
1006: l_sg VARCHAR2(3200);
1007: l_org VARCHAR2(3200);

Line 1261: , p_param IN bis_pmv_page_parameter_tbl)

1257: , p_version IN VARCHAR2
1258: , p_role IN VARCHAR2
1259: , p_view_by IN VARCHAR2
1260: , p_rg_where IN VARCHAR2
1261: , p_param IN bis_pmv_page_parameter_tbl)
1262: RETURN VARCHAR2
1263: IS
1264: l_sec_where_clause VARCHAR2 (1000);
1265:

Line 2320: p_param IN bis_pmv_page_parameter_tbl)

2316: RETURN l_params;
2317: END get_default_portlet_param;
2318:
2319: FUNCTION get_view_by (
2320: p_param IN bis_pmv_page_parameter_tbl)
2321: RETURN VARCHAR2
2322: IS
2323: p_view_by VARCHAR2 (100);
2324: BEGIN

Line 2337: p_param IN bis_pmv_page_parameter_tbl

2333: RETURN p_view_by;
2334: END get_view_by;
2335:
2336: FUNCTION get_param_id (
2337: p_param IN bis_pmv_page_parameter_tbl
2338: , p_param_name IN VARCHAR2)
2339: RETURN VARCHAR2
2340: IS
2341: p_param_id VARCHAR2 (100);

Line 2356: p_param IN bis_pmv_page_parameter_tbl)

2352: END get_param_id;
2353:
2354:
2355: PROCEDURE split_pseudo_rs_group (
2356: p_param IN bis_pmv_page_parameter_tbl)
2357: IS
2358: l_pseudo_rs_group VARCHAR2 (200);
2359: l_sep NUMBER;
2360: BEGIN