1 PACKAGE BIS_RKPI AS
2 /*$Header: BISRKPIS.pls 120.0 2005/06/01 15:48:26 appldev noship $*/
3
4 -- params: p_ak_region_code - ak region code
5 -- get Dimension Level Short Name List
6 -- surround each short name with ','
7 -- note that the first and the last positions are also ','
8 -- for example the output could be ",SHORT_NAME1,,SHORT_NAME2,,SHORTNAME3,"
9 FUNCTION GET_PMF_DIM_L_SN(
10 p_ak_region_code IN VARCHAR2,
11 p_filter_time_dl IN VARCHAR2 := 'T'
12 ) RETURN VARCHAR2;
13
14 -- params: p_dim_level_list - shortname list, output of GET_PMF_DIM_L_SN,
15 -- p_lang - user language
16 -- convert the shortnames in p_dim_level_list
17 -- to the corresponding names in the user's language
18 -- and reformat it by removing the ','
19 -- the output would look like "name1, name 2, name3"
20 FUNCTION GET_PMF_DIM_L_COMB(
21 p_dim_level_list IN VARCHAR2,
22 p_lang IN VARCHAR2
23 ) RETURN VARCHAR2;
24
25 -- params: p_dim_level_list - shortname list, output of GET_PMF_DIM_L_SN
26 -- p_common_params - shortname list to be removed from p_dim_level_list,
27 -- (output of GET_PMF_DIM_L_SN)
28 -- remove the shortnames in p_common_params from p_dim_level_list
29 FUNCTION REMOVE_COMMON_PARAMS(
30 p_dim_level_list IN VARCHAR2,
31 p_common_params IN VARCHAR2
32 ) RETURN VARCHAR2;
33
34 END BIS_RKPI;
[Home] [Help]