eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZPB_METADATA_PKG dependencies on ZPB_METADATA_NAMES

Line 1921: m_dimension_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_dim);

1917: -- Dimension Default Hierarchy
1918: m_dimension_en.DefaultHier := l_dim_ecm.HierDefault;
1919:
1920: -- get both the personal and shared CWM dimension names
1921: m_dimension_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_dim);
1922: m_dimension_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_dim);
1923:
1924: m_dimension_en.DimType := l_dim_data.Type;
1925: m_dimension_en.AnnotationDim := l_dim_ecm.AnnDim ;

Line 1922: m_dimension_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_dim);

1918: m_dimension_en.DefaultHier := l_dim_ecm.HierDefault;
1919:
1920: -- get both the personal and shared CWM dimension names
1921: m_dimension_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_dim);
1922: m_dimension_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_dim);
1923:
1924: m_dimension_en.DimType := l_dim_data.Type;
1925: m_dimension_en.AnnotationDim := l_dim_ecm.AnnDim ;
1926: m_dimension_en.DefaultMember := l_dim_ecm.DefaultMember;

Line 1931: m_shar_table_en.TableName:= zpb_metadata_names.get_dimension_view

1927: m_dimension_en.IsOwnerDim := l_dim_data.IsOwnerDim;
1928: m_dimension_en.IsDataDim := l_dim_data.IsDataDim;
1929:
1930: -- get the dimension table names for personal and shared
1931: m_shar_table_en.TableName:= zpb_metadata_names.get_dimension_view
1932: (p_sharedAW, 'SHARED', l_dim);
1933: m_pers_table_en.TableName:=zpb_metadata_names.get_dimension_view
1934: (p_sharedAW, 'PERSONAL', l_dim);
1935:

Line 1933: m_pers_table_en.TableName:=zpb_metadata_names.get_dimension_view

1929:
1930: -- get the dimension table names for personal and shared
1931: m_shar_table_en.TableName:= zpb_metadata_names.get_dimension_view
1932: (p_sharedAW, 'SHARED', l_dim);
1933: m_pers_table_en.TableName:=zpb_metadata_names.get_dimension_view
1934: (p_sharedAW, 'PERSONAL', l_dim);
1935:
1936: m_shar_table_en.TableType := 'DIMENSION';
1937: m_pers_table_en.TableType := 'DIMENSION';

Line 1955: m_pers_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);

1951: -- Create MEMBER_COLUMN's for the tables
1952: m_pers_column_en.columnType := 'MEMBER_COLUMN';
1953: m_shar_column_en.columnType := 'MEMBER_COLUMN';
1954:
1955: m_pers_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);
1956: m_shar_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);
1957:
1958: m_pers_column_en.AWName := l_dim_data.ExpObj;
1959: m_shar_column_en.AWName := l_dim_data.ExpObj;

Line 1956: m_shar_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);

1952: m_pers_column_en.columnType := 'MEMBER_COLUMN';
1953: m_shar_column_en.columnType := 'MEMBER_COLUMN';
1954:
1955: m_pers_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);
1956: m_shar_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);
1957:
1958: m_pers_column_en.AWName := l_dim_data.ExpObj;
1959: m_shar_column_en.AWName := l_dim_data.ExpObj;
1960:

Line 1969: m_pers_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);

1965: -- Creat LONG NAME column for the tables
1966: m_pers_column_en.columnType := 'LNAME_COLUMN';
1967: m_shar_column_en.columnType := 'LNAME_COLUMN';
1968:
1969: m_pers_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
1970: m_shar_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
1971:
1972: m_pers_column_en.AWName := l_dim_ecm.LdscVar;
1973: m_shar_column_en.AWName := l_dim_ecm.LdscVar;

Line 1970: m_shar_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);

1966: m_pers_column_en.columnType := 'LNAME_COLUMN';
1967: m_shar_column_en.columnType := 'LNAME_COLUMN';
1968:
1969: m_pers_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
1970: m_shar_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
1971:
1972: m_pers_column_en.AWName := l_dim_ecm.LdscVar;
1973: m_shar_column_en.AWName := l_dim_ecm.LdscVar;
1974:

Line 1983: m_pers_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);

1979: -- Create SHORT NAME columns for the tables
1980: m_pers_column_en.columnType := 'SNAME_COLUMN';
1981: m_shar_column_en.columnType := 'SNAME_COLUMN';
1982:
1983: m_pers_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
1984: m_shar_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
1985:
1986: m_pers_column_en.AWName := l_dim_ecm.MdscVar;
1987: m_shar_column_en.AWName := l_dim_ecm.MdscVar;

Line 1984: m_shar_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);

1980: m_pers_column_en.columnType := 'SNAME_COLUMN';
1981: m_shar_column_en.columnType := 'SNAME_COLUMN';
1982:
1983: m_pers_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
1984: m_shar_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
1985:
1986: m_pers_column_en.AWName := l_dim_ecm.MdscVar;
1987: m_shar_column_en.AWName := l_dim_ecm.MdscVar;
1988:

Line 1997: m_pers_column_en.columnName := zpb_metadata_names.get_dim_code_column(l_dim);

1993: -- Create CODE columns for the tables
1994: m_pers_column_en.columnType := 'CODE_COLUMN';
1995: m_shar_column_en.columnType := 'CODE_COLUMN';
1996:
1997: m_pers_column_en.columnName := zpb_metadata_names.get_dim_code_column(l_dim);
1998: m_shar_column_en.columnName := zpb_metadata_names.get_dim_code_column(l_dim);
1999:
2000: m_pers_column_en.AWName := l_dim_ecm.SdscVar;
2001: m_shar_column_en.AWName := l_dim_ecm.SdscVar;

Line 1998: m_shar_column_en.columnName := zpb_metadata_names.get_dim_code_column(l_dim);

1994: m_pers_column_en.columnType := 'CODE_COLUMN';
1995: m_shar_column_en.columnType := 'CODE_COLUMN';
1996:
1997: m_pers_column_en.columnName := zpb_metadata_names.get_dim_code_column(l_dim);
1998: m_shar_column_en.columnName := zpb_metadata_names.get_dim_code_column(l_dim);
1999:
2000: m_pers_column_en.AWName := l_dim_ecm.SdscVar;
2001: m_shar_column_en.AWName := l_dim_ecm.SdscVar;
2002:

Line 2011: m_pers_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);

2007: -- Create GID columns for the tables
2008: m_pers_column_en.columnType := 'GID_COLUMN';
2009: m_shar_column_en.columnType := 'GID_COLUMN';
2010:
2011: m_pers_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2012: m_shar_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2013:
2014: m_pers_column_en.AWName := l_dim_ecm.GID;
2015: m_shar_column_en.AWName := l_dim_ecm.GID;

Line 2012: m_shar_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);

2008: m_pers_column_en.columnType := 'GID_COLUMN';
2009: m_shar_column_en.columnType := 'GID_COLUMN';
2010:
2011: m_pers_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2012: m_shar_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2013:
2014: m_pers_column_en.AWName := l_dim_ecm.GID;
2015: m_shar_column_en.AWName := l_dim_ecm.GID;
2016:

Line 2029: m_hr_pers_col_memCol.columnName := zpb_metadata_names.get_dimension_column(l_dim);

2025: -- MEMBER COLUMN
2026: m_hr_pers_col_memCol.columnType := 'MEMBER_COLUMN';
2027: m_hr_shar_col_memCol.columnType := 'MEMBER_COLUMN';
2028:
2029: m_hr_pers_col_memCol.columnName := zpb_metadata_names.get_dimension_column(l_dim);
2030: m_hr_shar_col_memCol.columnName := zpb_metadata_names.get_dimension_column(l_dim);
2031:
2032: m_hr_pers_col_memCol.AWName := l_dim_data.ExpObj;
2033: m_hr_shar_col_memCol.AWName := l_dim_data.ExpObj;

Line 2030: m_hr_shar_col_memCol.columnName := zpb_metadata_names.get_dimension_column(l_dim);

2026: m_hr_pers_col_memCol.columnType := 'MEMBER_COLUMN';
2027: m_hr_shar_col_memCol.columnType := 'MEMBER_COLUMN';
2028:
2029: m_hr_pers_col_memCol.columnName := zpb_metadata_names.get_dimension_column(l_dim);
2030: m_hr_shar_col_memCol.columnName := zpb_metadata_names.get_dimension_column(l_dim);
2031:
2032: m_hr_pers_col_memCol.AWName := l_dim_data.ExpObj;
2033: m_hr_shar_col_memCol.AWName := l_dim_data.ExpObj;
2034:

Line 2039: m_hr_pers_col_gidCol.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);

2035: -- GID COLUMNS
2036: m_hr_pers_col_gidCol.columnType := 'GID_COLUMN';
2037: m_hr_shar_col_gidCol.columnType := 'GID_COLUMN';
2038:
2039: m_hr_pers_col_gidCol.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2040: m_hr_shar_col_gidCol.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2041:
2042: m_hr_pers_col_gidCol.AWName := l_dim_ecm.GID;
2043: m_hr_shar_col_gidCol.AWName := l_dim_ecm.GID;

Line 2040: m_hr_shar_col_gidCol.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);

2036: m_hr_pers_col_gidCol.columnType := 'GID_COLUMN';
2037: m_hr_shar_col_gidCol.columnType := 'GID_COLUMN';
2038:
2039: m_hr_pers_col_gidCol.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2040: m_hr_shar_col_gidCol.columnName := zpb_metadata_names.get_dim_gid_column(l_dim);
2041:
2042: m_hr_pers_col_gidCol.AWName := l_dim_ecm.GID;
2043: m_hr_shar_col_gidCol.AWName := l_dim_ecm.GID;
2044:

Line 2049: m_hr_pers_col_pgidCol.columnName := zpb_metadata_names.get_dim_pgid_column(l_dim);

2045: -- PGID COLUMNS
2046: m_hr_pers_col_pgidCol.columnType := 'PGID_COLUMN';
2047: m_hr_shar_col_pgidCol.columnType := 'PGID_COLUMN';
2048:
2049: m_hr_pers_col_pgidCol.columnName := zpb_metadata_names.get_dim_pgid_column(l_dim);
2050: m_hr_shar_col_pgidCol.columnName := zpb_metadata_names.get_dim_pgid_column(l_dim);
2051:
2052: m_hr_pers_col_pgidCol.AWName := l_dim_ecm.GID;
2053: m_hr_shar_col_pgidCol.AWName := l_dim_ecm.GID;

Line 2050: m_hr_shar_col_pgidCol.columnName := zpb_metadata_names.get_dim_pgid_column(l_dim);

2046: m_hr_pers_col_pgidCol.columnType := 'PGID_COLUMN';
2047: m_hr_shar_col_pgidCol.columnType := 'PGID_COLUMN';
2048:
2049: m_hr_pers_col_pgidCol.columnName := zpb_metadata_names.get_dim_pgid_column(l_dim);
2050: m_hr_shar_col_pgidCol.columnName := zpb_metadata_names.get_dim_pgid_column(l_dim);
2051:
2052: m_hr_pers_col_pgidCol.AWName := l_dim_ecm.GID;
2053: m_hr_shar_col_pgidCol.AWName := l_dim_ecm.GID;
2054:

Line 2059: m_hr_pers_col_parentCol.columnName := zpb_metadata_names.get_dim_parent_column(l_dim);

2055: -- PARENT COLUMNS
2056: m_hr_pers_col_parentCol.columnType := 'PARENT_COLUMN';
2057: m_hr_shar_col_parentCol.columnType := 'PARENT_COLUMN';
2058:
2059: m_hr_pers_col_parentCol.columnName := zpb_metadata_names.get_dim_parent_column(l_dim);
2060: m_hr_shar_col_parentCol.columnName := zpb_metadata_names.get_dim_parent_column(l_dim);
2061:
2062: m_hr_pers_col_parentCol.AWName := l_dim_ecm.ParentRel;
2063: m_hr_shar_col_parentCol.AWName := l_dim_ecm.ParentRel;

Line 2060: m_hr_shar_col_parentCol.columnName := zpb_metadata_names.get_dim_parent_column(l_dim);

2056: m_hr_pers_col_parentCol.columnType := 'PARENT_COLUMN';
2057: m_hr_shar_col_parentCol.columnType := 'PARENT_COLUMN';
2058:
2059: m_hr_pers_col_parentCol.columnName := zpb_metadata_names.get_dim_parent_column(l_dim);
2060: m_hr_shar_col_parentCol.columnName := zpb_metadata_names.get_dim_parent_column(l_dim);
2061:
2062: m_hr_pers_col_parentCol.AWName := l_dim_ecm.ParentRel;
2063: m_hr_shar_col_parentCol.AWName := l_dim_ecm.ParentRel;
2064:

Line 2069: m_hr_pers_col_orderCol.ColumnName := zpb_metadata_names.get_dim_order_column(l_dim);

2065: -- ORDER COLUMNS
2066: m_hr_pers_col_orderCol.ColumnType := 'ORDER_COLUMN';
2067: m_hr_shar_col_orderCol.ColumnType := 'ORDER_COLUMN';
2068:
2069: m_hr_pers_col_orderCol.ColumnName := zpb_metadata_names.get_dim_order_column(l_dim);
2070: m_hr_shar_col_orderCol.ColumnName := zpb_metadata_names.get_dim_order_column(l_dim);
2071:
2072: m_hr_pers_col_orderCol.AWName := l_dim_ecm.FullOrderVar;
2073: m_hr_shar_col_orderCol.AWName := l_dim_ecm.FullOrderVar;

Line 2070: m_hr_shar_col_orderCol.ColumnName := zpb_metadata_names.get_dim_order_column(l_dim);

2066: m_hr_pers_col_orderCol.ColumnType := 'ORDER_COLUMN';
2067: m_hr_shar_col_orderCol.ColumnType := 'ORDER_COLUMN';
2068:
2069: m_hr_pers_col_orderCol.ColumnName := zpb_metadata_names.get_dim_order_column(l_dim);
2070: m_hr_shar_col_orderCol.ColumnName := zpb_metadata_names.get_dim_order_column(l_dim);
2071:
2072: m_hr_pers_col_orderCol.AWName := l_dim_ecm.FullOrderVar;
2073: m_hr_shar_col_orderCol.AWName := l_dim_ecm.FullOrderVar;
2074:

Line 2131: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view

2127: ' to &joinchars ('''||l_aw||''' obj(property '''
2128: ||'PERSONALVAR'' '''||l_dim_ecm.LevelDim||''')))) text 0 no no)') > 0) then
2129:
2130: l_persLvl := true;
2131: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
2132: (p_aw, 'PERSONAL', l_dim, l_hier);
2133: m_hr_pers_table_en.AWName:= p_aw;
2134:
2135: select sysdate into l_pp_hiert_start_time from dual;

Line 2146: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);

2142: m_hier_en.DimensionId := m_dimension_en.DimensionId;
2143: m_hier_en.EPBId := l_hier;
2144: m_hier_en.HierType := zpb_aw.interp ('shw '||l_dim_ecm.HierTypeRel);
2145:
2146: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);
2147: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim, l_hier);
2148:
2149: -- Hierarchy Tables
2150: -- Have to get the Primary Key before we insert the entry because sub-entries

Line 2147: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim, l_hier);

2143: m_hier_en.EPBId := l_hier;
2144: m_hier_en.HierType := zpb_aw.interp ('shw '||l_dim_ecm.HierTypeRel);
2145:
2146: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);
2147: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim, l_hier);
2148:
2149: -- Hierarchy Tables
2150: -- Have to get the Primary Key before we insert the entry because sub-entries
2151: -- need to reference entry

Line 2304: m_level_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim, l_lvlHier, l_level);

2300: -- initialize Level Entry
2301: m_level_en.DimensionId := m_dimension_en.DimensionId;
2302: m_level_en.EPBId := l_level;
2303:
2304: m_level_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim, l_lvlHier, l_level);
2305: m_level_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_dim, l_lvlHier, l_level);
2306:
2307: -- Level Column Entries
2308: m_pers_column_en.TableId := m_hr_pers_table_en.TableId;

Line 2305: m_level_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_dim, l_lvlHier, l_level);

2301: m_level_en.DimensionId := m_dimension_en.DimensionId;
2302: m_level_en.EPBId := l_level;
2303:
2304: m_level_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim, l_lvlHier, l_level);
2305: m_level_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_dim, l_lvlHier, l_level);
2306:
2307: -- Level Column Entries
2308: m_pers_column_en.TableId := m_hr_pers_table_en.TableId;
2309: m_shar_column_en.TableId := m_hr_shar_table_en.TableId;

Line 2314: m_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);

2310:
2311: m_pers_column_en.columnType :='LEVEL_COLUMN';
2312: m_shar_column_en.columnType :='LEVEL_COLUMN';
2313:
2314: m_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);
2315: m_shar_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);
2316:
2317: -- Initialize Hierarchy To Level Mapping Entry
2318: m_hier_level_en.SharColId := insertColumnRecord(m_shar_column_en);

Line 2315: m_shar_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);

2311: m_pers_column_en.columnType :='LEVEL_COLUMN';
2312: m_shar_column_en.columnType :='LEVEL_COLUMN';
2313:
2314: m_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);
2315: m_shar_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);
2316:
2317: -- Initialize Hierarchy To Level Mapping Entry
2318: m_hier_level_en.SharColId := insertColumnRecord(m_shar_column_en);
2319: m_hier_level_en.PersColId := insertColumnRecord(m_pers_column_en);

Line 2390: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view

2386:
2387: -- this is the name of the hierarchy table
2388:
2389: if (l_persLvl) then
2390: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
2391: (p_aw, 'PERSONAL', l_dim, l_hier);
2392: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view
2393: (p_sharedAW, 'PERSONAL', l_dim, l_hier);
2394:

Line 2392: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view

2388:
2389: if (l_persLvl) then
2390: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
2391: (p_aw, 'PERSONAL', l_dim, l_hier);
2392: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view
2393: (p_sharedAW, 'PERSONAL', l_dim, l_hier);
2394:
2395: -- clean up personal-personal hierarchy table columns that have not been updated here
2396: -- these must be removed personal levels

Line 2402: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view

2398: where table_id = m_hr_pers_table_en.TableId and
2399: last_update_date < l_pp_hiert_start_time;
2400:
2401: else
2402: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
2403: (p_sharedAW, 'PERSONAL', l_dim, l_hier);
2404: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view
2405: (p_sharedAW, 'SHARED', l_dim, l_hier);
2406: end if;

Line 2404: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view

2400:
2401: else
2402: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
2403: (p_sharedAW, 'PERSONAL', l_dim, l_hier);
2404: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view
2405: (p_sharedAW, 'SHARED', l_dim, l_hier);
2406: end if;
2407:
2408: -- Insert Table Record For Hierarchy

Line 2458: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim);

2454:
2455: m_hier_en.DimensionId := m_dimension_en.DimensionId;
2456: m_hier_en.EPBId := 'NULL_GID';
2457: m_hier_en.HierType := 'NULL';
2458: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim);
2459: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim);
2460:
2461: -- Null Hierarchy Table Entry
2462: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_dim);

Line 2459: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim);

2455: m_hier_en.DimensionId := m_dimension_en.DimensionId;
2456: m_hier_en.EPBId := 'NULL_GID';
2457: m_hier_en.HierType := 'NULL';
2458: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim);
2459: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim);
2460:
2461: -- Null Hierarchy Table Entry
2462: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_dim);
2463: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'PERSONAL', l_dim);

Line 2462: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_dim);

2458: m_hier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim);
2459: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim);
2460:
2461: -- Null Hierarchy Table Entry
2462: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_dim);
2463: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'PERSONAL', l_dim);
2464:
2465: m_hr_shar_table_en.AWName := p_sharedAw;
2466: m_hr_pers_table_en.AWName := p_sharedAw;

Line 2463: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'PERSONAL', l_dim);

2459: m_hier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_dim);
2460:
2461: -- Null Hierarchy Table Entry
2462: m_hr_shar_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_dim);
2463: m_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'PERSONAL', l_dim);
2464:
2465: m_hr_shar_table_en.AWName := p_sharedAw;
2466: m_hr_pers_table_en.AWName := p_sharedAw;
2467:

Line 2559: m_level_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim);

2555:
2556: -- initialize Level entry
2557: m_level_en.DimensionId := m_dimension_en.DimensionId;
2558: m_level_en.EPBId := '0';
2559: m_level_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim);
2560: m_level_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_dim);
2561: m_level_en.PersLevelFlag :='N';
2562:
2563: -- initialize Level TL entry

Line 2560: m_level_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_dim);

2556: -- initialize Level entry
2557: m_level_en.DimensionId := m_dimension_en.DimensionId;
2558: m_level_en.EPBId := '0';
2559: m_level_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim);
2560: m_level_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_dim);
2561: m_level_en.PersLevelFlag :='N';
2562:
2563: -- initialize Level TL entry
2564: m_level_tl_en.Name := 'NULL_HIER_LEVEL';

Line 2576: m_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, null);

2572:
2573: m_pers_column_en.columnType := 'LEVEL_COLUMN';
2574: m_shar_column_en.columnType := 'LEVEL_COLUMN';
2575:
2576: m_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, null);
2577: m_shar_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, null);
2578:
2579: -- Insert Column Entries
2580: m_hier_level_en.SharColId := insertColumnRecord(m_shar_column_en);

Line 2577: m_shar_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, null);

2573: m_pers_column_en.columnType := 'LEVEL_COLUMN';
2574: m_shar_column_en.columnType := 'LEVEL_COLUMN';
2575:
2576: m_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, null);
2577: m_shar_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, null);
2578:
2579: -- Insert Column Entries
2580: m_hier_level_en.SharColId := insertColumnRecord(m_shar_column_en);
2581: m_hier_level_en.PersColId := insertColumnRecord(m_pers_column_en);

Line 2634: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);

2630: -- create attribute entry
2631: m_attr_en.DimensionId := m_dimension_en.DimensionId;
2632: m_attr_en.EPBId := l_attr;
2633: m_attr_en.Type :='DIMENSION_ATTRIBUTE';
2634: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);
2635: m_attr_en.SharCWMName := l_attr;
2636: m_attr_en.Label := zpb_aw.interp('shw '||l_aw||'ATTRLABEL');
2637: m_attr_en.FEMAttrId := null;
2638:

Line 2655: m_pers_column_en.columnName := zpb_metadata_names.get_attribute_column(l_dim, l_attr);

2651:
2652: m_pers_column_en.columnType := 'ATTRIBUTE_COLUMN';
2653: m_shar_column_en.columnType := 'ATTRIBUTE_COLUMN';
2654:
2655: m_pers_column_en.columnName := zpb_metadata_names.get_attribute_column(l_dim, l_attr);
2656: m_shar_column_en.columnName := zpb_metadata_names.get_attribute_column(l_dim, l_attr);
2657:
2658: m_pers_column_en.AWName := l_attr_ecm.LdscFrm;
2659: m_shar_column_en.AWNAme := l_attr_ecm.LdscFrm;

Line 2656: m_shar_column_en.columnName := zpb_metadata_names.get_attribute_column(l_dim, l_attr);

2652: m_pers_column_en.columnType := 'ATTRIBUTE_COLUMN';
2653: m_shar_column_en.columnType := 'ATTRIBUTE_COLUMN';
2654:
2655: m_pers_column_en.columnName := zpb_metadata_names.get_attribute_column(l_dim, l_attr);
2656: m_shar_column_en.columnName := zpb_metadata_names.get_attribute_column(l_dim, l_attr);
2657:
2658: m_pers_column_en.AWName := l_attr_ecm.LdscFrm;
2659: m_shar_column_en.AWNAme := l_attr_ecm.LdscFrm;
2660:

Line 2682: m_attr_rangedim_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_attrId);

2678: -- end;
2679:
2680: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2681:
2682: m_attr_rangedim_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_attrId);
2683: m_attr_rangedim_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_attrId);
2684: m_attr_rangedim_en.SharTableId :=0;
2685: m_attr_rangedim_en.AWName := l_range_dim_data.ExpObj;
2686: m_attr_rangedim_en.IsDatadim :='N';

Line 2683: m_attr_rangedim_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_attrId);

2679:
2680: l_range_dim_data := zpb_ecm.get_dimension_data (m_attr_rangedim_en.EPBId, p_aw);
2681:
2682: m_attr_rangedim_en.PersCWMName := zpb_metadata_names.get_dimension_cwm2_name('PRS', l_attrId);
2683: m_attr_rangedim_en.SharCWMName := zpb_metadata_names.get_dimension_cwm2_name(p_sharedAw, l_attrId);
2684: m_attr_rangedim_en.SharTableId :=0;
2685: m_attr_rangedim_en.AWName := l_range_dim_data.ExpObj;
2686: m_attr_rangedim_en.IsDatadim :='N';
2687:

Line 2690: m_attr_rangetbl_en.TableName := zpb_metadata_names.get_dimension_view

2686: m_attr_rangedim_en.IsDatadim :='N';
2687:
2688: -- Attribute Range Dimension Table
2689: -- Feb 02 change from l_attrId to l_attr per Greg
2690: m_attr_rangetbl_en.TableName := zpb_metadata_names.get_dimension_view
2691: (p_sharedAW, 'PERSONAL', l_attr);
2692: m_attr_rangetbl_en.tableType := 'ATTRIBUTE';
2693: m_attr_rangetbl_en.AWName := p_aw;
2694:

Line 2696: m_attr_range_sh_tbl_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_attr);

2692: m_attr_rangetbl_en.tableType := 'ATTRIBUTE';
2693: m_attr_rangetbl_en.AWName := p_aw;
2694:
2695: -- shared attribute range dimension table
2696: m_attr_range_sh_tbl_en.TableName := zpb_metadata_names.get_dimension_view(p_sharedAW, 'SHARED', l_attr);
2697: m_attr_range_sh_tbl_en.tableType := 'ATTRIBUTE';
2698: m_attr_range_sh_tbl_en.AWName := p_sharedAW;
2699:
2700: m_attr_rangecol_en.TableId := insertTableRecord(m_attr_rangetbl_en);

Line 2716: m_attr_rangehier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_attr);

2712: m_attr_rangehier_en.DimensionId := m_attr_rangedim_en.DimensionId;
2713:
2714: -- Attribute Range Dimension Hierarchy
2715: m_attr_rangehier_en.EPBID :='0';
2716: m_attr_rangehier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_attr);
2717: m_attr_rangehier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_attr);
2718: m_attr_rangehier_en.HierType := 'NULL';
2719:
2720: m_attr_rangehier_en.SharTableId := m_attr_range_sh_col_en.TableId;

Line 2717: m_attr_rangehier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_attr);

2713:
2714: -- Attribute Range Dimension Hierarchy
2715: m_attr_rangehier_en.EPBID :='0';
2716: m_attr_rangehier_en.PersCWMName := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_attr);
2717: m_attr_rangehier_en.SharCWMName := zpb_metadata_names.get_hierarchy_cwm2_name(p_sharedAw, l_attr);
2718: m_attr_rangehier_en.HierType := 'NULL';
2719:
2720: m_attr_rangehier_en.SharTableId := m_attr_range_sh_col_en.TableId;
2721: m_attr_rangehier_en.PersTableId := m_attr_rangecol_en.TableId;

Line 2725: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dimension_column(l_attr);

2721: m_attr_rangehier_en.PersTableId := m_attr_rangecol_en.TableId;
2722:
2723: -- Attribute Range Dimension Column - MEMBER
2724: m_attr_rangecol_en.columnType := 'MEMBER_COLUMN';
2725: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dimension_column(l_attr);
2726: m_attr_rangecol_en.AWName := 'NA';
2727: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2728:
2729: m_attr_range_sh_col_en.columnType := 'MEMBER_COLUMN';

Line 2730: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dimension_column(l_attr);

2726: m_attr_rangecol_en.AWName := 'NA';
2727: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2728:
2729: m_attr_range_sh_col_en.columnType := 'MEMBER_COLUMN';
2730: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dimension_column(l_attr);
2731: m_attr_range_sh_col_en.AWName := 'NA';
2732: m_column_id := insertColumnRecord(m_attr_range_sh_col_en);
2733:
2734:

Line 2737: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_gid_column(l_attr);

2733:
2734:
2735: -- Attribute Range Dimension Column - GID
2736: m_attr_rangecol_en.columnType := 'GID_COLUMN';
2737: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_gid_column(l_attr);
2738: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2739:
2740: m_attr_range_sh_col_en.columnType := 'GID_COLUMN';
2741: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_gid_column(l_attr);

Line 2741: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_gid_column(l_attr);

2737: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_gid_column(l_attr);
2738: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2739:
2740: m_attr_range_sh_col_en.columnType := 'GID_COLUMN';
2741: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_gid_column(l_attr);
2742: m_column_id := insertColumnRecord(m_attr_range_sh_col_en);
2743:
2744: -- Attribute Range Dimension Column - PGID
2745: m_attr_rangecol_en.columnType := 'PGID_COLUMN';

Line 2746: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_pgid_column(l_attr);

2742: m_column_id := insertColumnRecord(m_attr_range_sh_col_en);
2743:
2744: -- Attribute Range Dimension Column - PGID
2745: m_attr_rangecol_en.columnType := 'PGID_COLUMN';
2746: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_pgid_column(l_attr);
2747: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2748:
2749: m_attr_range_sh_col_en.columnType := 'PGID_COLUMN';
2750: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_pgid_column(l_attr);

Line 2750: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_pgid_column(l_attr);

2746: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_pgid_column(l_attr);
2747: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2748:
2749: m_attr_range_sh_col_en.columnType := 'PGID_COLUMN';
2750: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_pgid_column(l_attr);
2751: m_column_id := insertColumnRecord(m_attr_range_sh_col_en);
2752:
2753: -- Attribute Range Dimension Column - PARENT
2754: m_attr_rangecol_en.columnType := 'PARENT_COLUMN';

Line 2755: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_parent_column(l_attr);

2751: m_column_id := insertColumnRecord(m_attr_range_sh_col_en);
2752:
2753: -- Attribute Range Dimension Column - PARENT
2754: m_attr_rangecol_en.columnType := 'PARENT_COLUMN';
2755: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_parent_column(l_attr);
2756: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2757:
2758: m_attr_range_sh_col_en.columnType := 'PARENT_COLUMN';
2759: m_attr_range_sh_col_en.columnName :=

Line 2760: zpb_metadata_names.get_dim_parent_column(l_attr);

2756: m_column_id := insertColumnRecord(m_attr_rangecol_en);
2757:
2758: m_attr_range_sh_col_en.columnType := 'PARENT_COLUMN';
2759: m_attr_range_sh_col_en.columnName :=
2760: zpb_metadata_names.get_dim_parent_column(l_attr);
2761: m_column_id := insertColumnRecord(m_attr_range_sh_col_en);
2762:
2763: -- Attribute Range Dimension Level
2764: m_attr_rangelev_en.DimensionId :=m_attr_rangedim_en.DimensionId;

Line 2767: m_attr_rangelev_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_attr);

2763: -- Attribute Range Dimension Level
2764: m_attr_rangelev_en.DimensionId :=m_attr_rangedim_en.DimensionId;
2765:
2766: m_attr_rangelev_en.EPBId :='0';
2767: m_attr_rangelev_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_attr);
2768: m_attr_rangelev_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_attr);
2769: m_attr_rangelev_en.PersLevelFlag :='N';
2770:
2771: -- Attribute Range Dimension Hierarchy to Level Mapping

Line 2768: m_attr_rangelev_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_attr);

2764: m_attr_rangelev_en.DimensionId :=m_attr_rangedim_en.DimensionId;
2765:
2766: m_attr_rangelev_en.EPBId :='0';
2767: m_attr_rangelev_en.PersCWMName := zpb_metadata_names.get_level_cwm2_name('PRS', l_attr);
2768: m_attr_rangelev_en.SharCWMName := zpb_metadata_names.get_level_cwm2_name(p_sharedAw, l_attr);
2769: m_attr_rangelev_en.PersLevelFlag :='N';
2770:
2771: -- Attribute Range Dimension Hierarchy to Level Mapping
2772: m_attr_rangehl_en.LevelId := insertLevelRecord(m_attr_rangelev_en);

Line 2775: m_attr_rangecol_en.columnName := zpb_metadata_names.get_level_column(l_attr, null);

2771: -- Attribute Range Dimension Hierarchy to Level Mapping
2772: m_attr_rangehl_en.LevelId := insertLevelRecord(m_attr_rangelev_en);
2773:
2774: -- Attribute Range Dimension Hiearchy Level
2775: m_attr_rangecol_en.columnName := zpb_metadata_names.get_level_column(l_attr, null);
2776: m_attr_rangecol_en.columnType := 'LEVEL_COLUMN';
2777: m_attr_rangecol_en.AWName :='';
2778: m_attr_rangehl_en.LevelOrder := 1;
2779: m_attr_rangehl_en.PersColId := insertColumnRecord(m_attr_rangecol_en);

Line 2781: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_level_column(l_attr, null);

2777: m_attr_rangecol_en.AWName :='';
2778: m_attr_rangehl_en.LevelOrder := 1;
2779: m_attr_rangehl_en.PersColId := insertColumnRecord(m_attr_rangecol_en);
2780:
2781: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_level_column(l_attr, null);
2782: m_attr_range_sh_col_en.columnType := 'LEVEL_COLUMN';
2783: m_attr_range_sh_col_en.AWName :='';
2784: m_attr_rangehl_en.LevelOrder := 1;
2785: m_attr_rangehl_en.SharColId := insertColumnRecord(m_attr_range_sh_col_en);

Line 2792: m_attr_rangeattr_en.PersCWMName := zpb_metadata_names.get_dim_long_name_cwm2('PRS',l_attr);

2788:
2789: m_attr_rangeattr_en.DimensionId := m_attr_rangedim_en.DimensionId;
2790: m_attr_rangeattr_en.EPBId :='';
2791: m_attr_rangeattr_en.Type := 'VALUE_NAME_ATTRIBUTE';
2792: m_attr_rangeattr_en.PersCWMName := zpb_metadata_names.get_dim_long_name_cwm2('PRS',l_attr);
2793: m_attr_rangeattr_en.SharCWMName := zpb_metadata_names.get_dim_long_name_cwm2(p_sharedAw,l_attr);
2794:
2795: m_attr_rangeattr_en.FEMAttrId := null;
2796: m_attr_rangeattr_en.Label :=' ';

Line 2793: m_attr_rangeattr_en.SharCWMName := zpb_metadata_names.get_dim_long_name_cwm2(p_sharedAw,l_attr);

2789: m_attr_rangeattr_en.DimensionId := m_attr_rangedim_en.DimensionId;
2790: m_attr_rangeattr_en.EPBId :='';
2791: m_attr_rangeattr_en.Type := 'VALUE_NAME_ATTRIBUTE';
2792: m_attr_rangeattr_en.PersCWMName := zpb_metadata_names.get_dim_long_name_cwm2('PRS',l_attr);
2793: m_attr_rangeattr_en.SharCWMName := zpb_metadata_names.get_dim_long_name_cwm2(p_sharedAw,l_attr);
2794:
2795: m_attr_rangeattr_en.FEMAttrId := null;
2796: m_attr_rangeattr_en.Label :=' ';
2797:

Line 2805: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_attr);

2801: m_attr_sh_rangeatc_en.AttributeId := m_attr_rangeatc_en.AttributeId;
2802: m_attr_sh_rangeatc_en.TableId := m_attr_rangehier_en.SharTableId;
2803:
2804: m_attr_rangecol_en.columnType := 'LNAME_COLUMN';
2805: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_attr);
2806: m_attr_rangeatc_en.ColumnId := insertColumnRecord(m_attr_rangecol_en);
2807:
2808: m_attr_range_sh_col_en.columnType := 'LNAME_COLUMN';
2809: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_attr);

Line 2809: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_attr);

2805: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_attr);
2806: m_attr_rangeatc_en.ColumnId := insertColumnRecord(m_attr_rangecol_en);
2807:
2808: m_attr_range_sh_col_en.columnType := 'LNAME_COLUMN';
2809: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_attr);
2810: m_attr_sh_rangeatc_en.ColumnId := insertColumnRecord(m_attr_range_sh_col_en);
2811:
2812: m_attr_table_col_id := insertAttrTableColRecord(m_attr_rangeatc_en);
2813:

Line 2825: m_attr_rangeattr_en.PersCWMName := zpb_metadata_names.get_dim_short_name_cwm2('PRS',l_attr);

2821:
2822: -- previously we had no shared attribute range dimensions and the personal names for their attributes
2823: -- was actually using the shared convention. Now that we do have shared attribute range dimensions,
2824: -- personal and shared names will use their appropriate conventions.
2825: m_attr_rangeattr_en.PersCWMName := zpb_metadata_names.get_dim_short_name_cwm2('PRS',l_attr);
2826: m_attr_rangeattr_en.SharCWMName := zpb_metadata_names.get_dim_short_name_cwm2(p_sharedAW,l_attr);
2827:
2828:
2829: m_attr_rangeatc_en.AttributeId := insertAttributeRecord(m_attr_rangeattr_en);

Line 2826: m_attr_rangeattr_en.SharCWMName := zpb_metadata_names.get_dim_short_name_cwm2(p_sharedAW,l_attr);

2822: -- previously we had no shared attribute range dimensions and the personal names for their attributes
2823: -- was actually using the shared convention. Now that we do have shared attribute range dimensions,
2824: -- personal and shared names will use their appropriate conventions.
2825: m_attr_rangeattr_en.PersCWMName := zpb_metadata_names.get_dim_short_name_cwm2('PRS',l_attr);
2826: m_attr_rangeattr_en.SharCWMName := zpb_metadata_names.get_dim_short_name_cwm2(p_sharedAW,l_attr);
2827:
2828:
2829: m_attr_rangeatc_en.AttributeId := insertAttributeRecord(m_attr_rangeattr_en);
2830: m_attr_rangeatc_en.TableId := m_attr_rangehier_en.PersTableId;

Line 2836: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_attr);

2832: m_attr_sh_rangeatc_en.AttributeId := m_attr_rangeatc_en.AttributeId;
2833: m_attr_sh_rangeatc_en.TableId := m_attr_rangehier_en.SharTableId;
2834:
2835: m_attr_rangecol_en.columnType := 'SNAME_COLUMN';
2836: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_attr);
2837: m_attr_rangeatc_en.ColumnId := insertColumnRecord(m_attr_rangecol_en);
2838:
2839: m_attr_range_sh_col_en.columnType := 'SNAME_COLUMN';
2840: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_attr);

Line 2840: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_attr);

2836: m_attr_rangecol_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_attr);
2837: m_attr_rangeatc_en.ColumnId := insertColumnRecord(m_attr_rangecol_en);
2838:
2839: m_attr_range_sh_col_en.columnType := 'SNAME_COLUMN';
2840: m_attr_range_sh_col_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_attr);
2841: m_attr_sh_rangeatc_en.ColumnId := insertColumnRecord(m_attr_range_sh_col_en);
2842:
2843: m_attr_table_col_id := insertAttrTableColRecord(m_attr_rangeatc_en);
2844:

Line 2941: m_attr_en.PersCWMName := zpb_metadata_names.get_dim_long_name_cwm2('PERSONAL', l_dim);

2937: m_attr_en.DimensionId := m_dimension_en.DimensionId;
2938: m_attr_en.FEMAttrId :=null;
2939: m_attr_en.RangeDimId := null;
2940: m_attr_en.EPBId := '';
2941: m_attr_en.PersCWMName := zpb_metadata_names.get_dim_long_name_cwm2('PERSONAL', l_dim);
2942: m_attr_en.SharCWMName := zpb_metadata_names.get_dim_long_name_cwm2(p_sharedAw, l_dim);
2943: m_attr_en.Label := ' ';
2944: m_attr_en.Type := 'VALUE_NAME_ATTRIBUTE';
2945:

Line 2942: m_attr_en.SharCWMName := zpb_metadata_names.get_dim_long_name_cwm2(p_sharedAw, l_dim);

2938: m_attr_en.FEMAttrId :=null;
2939: m_attr_en.RangeDimId := null;
2940: m_attr_en.EPBId := '';
2941: m_attr_en.PersCWMName := zpb_metadata_names.get_dim_long_name_cwm2('PERSONAL', l_dim);
2942: m_attr_en.SharCWMName := zpb_metadata_names.get_dim_long_name_cwm2(p_sharedAw, l_dim);
2943: m_attr_en.Label := ' ';
2944: m_attr_en.Type := 'VALUE_NAME_ATTRIBUTE';
2945:
2946: m_pers_column_en.TableId := m_dimension_en.PersTableId;

Line 2952: m_shar_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);

2948:
2949: m_shar_column_en.columnType := 'LNAME_COLUMN';
2950: m_pers_column_en.columnType := 'LNAME_COLUMN';
2951:
2952: m_shar_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
2953: m_pers_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
2954:
2955: m_shar_column_en.AWName := l_dim_ecm.LdscVar;
2956: m_pers_column_en.AWName := l_dim_ecm.LdscVar;

Line 2953: m_pers_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);

2949: m_shar_column_en.columnType := 'LNAME_COLUMN';
2950: m_pers_column_en.columnType := 'LNAME_COLUMN';
2951:
2952: m_shar_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
2953: m_pers_column_en.columnName := zpb_metadata_names.get_dim_long_name_column(l_dim);
2954:
2955: m_shar_column_en.AWName := l_dim_ecm.LdscVar;
2956: m_pers_column_en.AWName := l_dim_ecm.LdscVar;
2957:

Line 2975: m_attr_en.PersCWMName := zpb_metadata_names.get_dim_short_name_cwm2('PERSONAL', l_dim);

2971:
2972: m_attr_en.DimensionId := m_dimension_en.DimensionId;
2973: m_attr_en.RangeDimId := null;
2974: m_attr_en.EPBId := '';
2975: m_attr_en.PersCWMName := zpb_metadata_names.get_dim_short_name_cwm2('PERSONAL', l_dim);
2976: m_attr_en.SharCWMName := zpb_metadata_names.get_dim_short_name_cwm2(p_sharedAw, l_dim);
2977: m_attr_en.Type := 'SHORT_VALUE_NAME_ATTRIBUTE';
2978: m_attr_en.Label := ' ';
2979:

Line 2976: m_attr_en.SharCWMName := zpb_metadata_names.get_dim_short_name_cwm2(p_sharedAw, l_dim);

2972: m_attr_en.DimensionId := m_dimension_en.DimensionId;
2973: m_attr_en.RangeDimId := null;
2974: m_attr_en.EPBId := '';
2975: m_attr_en.PersCWMName := zpb_metadata_names.get_dim_short_name_cwm2('PERSONAL', l_dim);
2976: m_attr_en.SharCWMName := zpb_metadata_names.get_dim_short_name_cwm2(p_sharedAw, l_dim);
2977: m_attr_en.Type := 'SHORT_VALUE_NAME_ATTRIBUTE';
2978: m_attr_en.Label := ' ';
2979:
2980: m_pers_column_en.TableId := m_dimension_en.PersTableId;

Line 2986: m_shar_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);

2982:
2983: m_shar_column_en.columnType := 'SNAME_COLUMN';
2984: m_pers_column_en.columnType := 'SNAME_COLUMN';
2985:
2986: m_shar_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
2987: m_pers_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
2988:
2989: m_shar_column_en.AWName := l_dim_ecm.MdscVar;
2990: m_pers_column_en.AWName := l_dim_ecm.MdscVar;

Line 2987: m_pers_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);

2983: m_shar_column_en.columnType := 'SNAME_COLUMN';
2984: m_pers_column_en.columnType := 'SNAME_COLUMN';
2985:
2986: m_shar_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
2987: m_pers_column_en.columnName := zpb_metadata_names.get_dim_short_name_column(l_dim);
2988:
2989: m_shar_column_en.AWName := l_dim_ecm.MdscVar;
2990: m_pers_column_en.AWName := l_dim_ecm.MdscVar;
2991:

Line 3014: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'ENDDATE');

3010: m_attr_en.DimensionId := m_dimension_en.DimensionId;
3011: m_attr_en.FEMAttrId := null;
3012: m_attr_en.RangeDimId := null;
3013: m_attr_en.EPBId := 'ENDDATE';
3014: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'ENDDATE');
3015: m_attr_en.SharCWMName := 'END DATE';
3016: m_attr_en.Type := 'ENDDATE_ATTRIBUTE';
3017: m_attr_en.Label := ' ';
3018:

Line 3025: m_shar_column_en.columnName := zpb_metadata_names.get_dim_enddate_column(l_dim);

3021:
3022: m_shar_column_en.columnType := 'ENDDATE_COLUMN';
3023: m_pers_column_en.columnType := 'ENDDATE_COLUMN';
3024:
3025: m_shar_column_en.columnName := zpb_metadata_names.get_dim_enddate_column(l_dim);
3026: m_pers_column_en.columnName := zpb_metadata_names.get_dim_enddate_column(l_dim);
3027:
3028: m_shar_column_en.AWName := l_dim_time_ecm.EndDateVar;
3029: m_pers_column_en.AWName := l_dim_time_ecm.EndDateVar;

Line 3026: m_pers_column_en.columnName := zpb_metadata_names.get_dim_enddate_column(l_dim);

3022: m_shar_column_en.columnType := 'ENDDATE_COLUMN';
3023: m_pers_column_en.columnType := 'ENDDATE_COLUMN';
3024:
3025: m_shar_column_en.columnName := zpb_metadata_names.get_dim_enddate_column(l_dim);
3026: m_pers_column_en.columnName := zpb_metadata_names.get_dim_enddate_column(l_dim);
3027:
3028: m_shar_column_en.AWName := l_dim_time_ecm.EndDateVar;
3029: m_pers_column_en.AWName := l_dim_time_ecm.EndDateVar;
3030:

Line 3049: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'TIMESPAN');

3045: m_attr_en.DimensionId := m_dimension_en.DimensionId;
3046: m_attr_en.FEMAttrId := null;
3047: m_attr_en.RangeDimId := null;
3048: m_attr_en.EPBId := 'TIMESPAN';
3049: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'TIMESPAN');
3050: m_attr_en.SharCWMName := 'TIME SPAN';
3051: m_attr_en.Type := 'TIMESPAN_ATTRIBUTE';
3052: m_attr_en.Label := ' ';
3053:

Line 3060: m_shar_column_en.columnName := zpb_metadata_names.get_dim_timespan_column(l_dim);

3056:
3057: m_shar_column_en.columnType := 'TIMESPAN_COLUMN';
3058: m_pers_column_en.columnType := 'TIMESPAN_COLUMN';
3059:
3060: m_shar_column_en.columnName := zpb_metadata_names.get_dim_timespan_column(l_dim);
3061: m_pers_column_en.columnName := zpb_metadata_names.get_dim_timespan_column(l_dim);
3062:
3063: m_shar_column_en.AWName := l_dim_time_ecm.TimeSpanVar;
3064: m_pers_column_en.AWName := l_dim_time_ecm.TimeSpanVar;

Line 3061: m_pers_column_en.columnName := zpb_metadata_names.get_dim_timespan_column(l_dim);

3057: m_shar_column_en.columnType := 'TIMESPAN_COLUMN';
3058: m_pers_column_en.columnType := 'TIMESPAN_COLUMN';
3059:
3060: m_shar_column_en.columnName := zpb_metadata_names.get_dim_timespan_column(l_dim);
3061: m_pers_column_en.columnName := zpb_metadata_names.get_dim_timespan_column(l_dim);
3062:
3063: m_shar_column_en.AWName := l_dim_time_ecm.TimeSpanVar;
3064: m_pers_column_en.AWName := l_dim_time_ecm.TimeSpanVar;
3065:

Line 3090: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'LINEAGGTIME');

3086: m_attr_en.DimensionId := m_dimension_en.DimensionId;
3087: m_attr_en.RangeDimId := null;
3088: m_attr_en.FEMAttrId := null;
3089: m_attr_en.EPBId := 'LINEAGGTIME';
3090: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'LINEAGGTIME');
3091: m_attr_en.SharCWMName := zpb_metadata_names.get_attribute_cwm2_name(p_sharedAw,l_dim,'LINEAGGTIME');
3092: m_attr_en.Type := 'LINEAGG_ATTRIBUTE';
3093: m_attr_en.Label := ' ';
3094:

Line 3091: m_attr_en.SharCWMName := zpb_metadata_names.get_attribute_cwm2_name(p_sharedAw,l_dim,'LINEAGGTIME');

3087: m_attr_en.RangeDimId := null;
3088: m_attr_en.FEMAttrId := null;
3089: m_attr_en.EPBId := 'LINEAGGTIME';
3090: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'LINEAGGTIME');
3091: m_attr_en.SharCWMName := zpb_metadata_names.get_attribute_cwm2_name(p_sharedAw,l_dim,'LINEAGGTIME');
3092: m_attr_en.Type := 'LINEAGG_ATTRIBUTE';
3093: m_attr_en.Label := ' ';
3094:
3095: m_pers_column_en.TableId := m_dimension_en.PersTableId;

Line 3101: m_shar_column_en.columnName := zpb_metadata_names.get_dim_aggtime_column(l_dim);

3097:
3098: m_shar_column_en.columnType := 'AGGTIME_COLUMN';
3099: m_pers_column_en.columnType := 'AGGTIME_COLUMN';
3100:
3101: m_shar_column_en.columnName := zpb_metadata_names.get_dim_aggtime_column(l_dim);
3102: m_pers_column_en.columnName := zpb_metadata_names.get_dim_aggtime_column(l_dim);
3103:
3104: m_shar_column_en.AWName := 'LINEAGGTIME.DL';
3105: m_pers_column_en.AWName := 'LINEAGGTIME.DL';

Line 3102: m_pers_column_en.columnName := zpb_metadata_names.get_dim_aggtime_column(l_dim);

3098: m_shar_column_en.columnType := 'AGGTIME_COLUMN';
3099: m_pers_column_en.columnType := 'AGGTIME_COLUMN';
3100:
3101: m_shar_column_en.columnName := zpb_metadata_names.get_dim_aggtime_column(l_dim);
3102: m_pers_column_en.columnName := zpb_metadata_names.get_dim_aggtime_column(l_dim);
3103:
3104: m_shar_column_en.AWName := 'LINEAGGTIME.DL';
3105: m_pers_column_en.AWName := 'LINEAGGTIME.DL';
3106:

Line 3125: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'LINEAGGOTHER');

3121: m_attr_en.DimensionId := m_dimension_en.DimensionId;
3122: m_attr_en.RangeDimId := null;
3123: m_attr_en.FEMAttrId := null;
3124: m_attr_en.EPBId := 'LINEAGGOTHER';
3125: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'LINEAGGOTHER');
3126: m_attr_en.SharCWMName := zpb_metadata_names.get_attribute_cwm2_name(p_sharedAw,l_dim,'LINEAGGOTHER');
3127: m_attr_en.Type := 'LINEAGG_ATTRIBUTE';
3128: m_attr_en.Label := ' ';
3129:

Line 3126: m_attr_en.SharCWMName := zpb_metadata_names.get_attribute_cwm2_name(p_sharedAw,l_dim,'LINEAGGOTHER');

3122: m_attr_en.RangeDimId := null;
3123: m_attr_en.FEMAttrId := null;
3124: m_attr_en.EPBId := 'LINEAGGOTHER';
3125: m_attr_en.PersCWMName := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,'LINEAGGOTHER');
3126: m_attr_en.SharCWMName := zpb_metadata_names.get_attribute_cwm2_name(p_sharedAw,l_dim,'LINEAGGOTHER');
3127: m_attr_en.Type := 'LINEAGG_ATTRIBUTE';
3128: m_attr_en.Label := ' ';
3129:
3130: m_pers_column_en.TableId := m_dimension_en.PersTableId;

Line 3136: m_shar_column_en.columnName := zpb_metadata_names.get_dim_aggother_column(l_dim);

3132:
3133: m_shar_column_en.columnType := 'AGGOTHER_COLUMN';
3134: m_pers_column_en.columnType := 'AGGOTHER_COLUMN';
3135:
3136: m_shar_column_en.columnName := zpb_metadata_names.get_dim_aggother_column(l_dim);
3137: m_pers_column_en.columnName := zpb_metadata_names.get_dim_aggother_column(l_dim);
3138:
3139: m_shar_column_en.AWName := 'LINEAGGOTHER.DL';
3140: m_pers_column_en.AWName := 'LINEAGGOTHER.DL';

Line 3137: m_pers_column_en.columnName := zpb_metadata_names.get_dim_aggother_column(l_dim);

3133: m_shar_column_en.columnType := 'AGGOTHER_COLUMN';
3134: m_pers_column_en.columnType := 'AGGOTHER_COLUMN';
3135:
3136: m_shar_column_en.columnName := zpb_metadata_names.get_dim_aggother_column(l_dim);
3137: m_pers_column_en.columnName := zpb_metadata_names.get_dim_aggother_column(l_dim);
3138:
3139: m_shar_column_en.AWName := 'LINEAGGOTHER.DL';
3140: m_pers_column_en.AWName := 'LINEAGGOTHER.DL';
3141:

Line 3261: m_cube_view := zpb_metadata_names.get_security_cwm2_cube(p_aw);

3257: bus_area_id_num := sys_context('ZPB_CONTEXT', 'business_area_id');
3258:
3259: if p_cube_type = 'SEC_CUBE' then
3260:
3261: m_cube_view := zpb_metadata_names.get_security_cwm2_cube(p_aw);
3262: m_object_name := 'SEC_CUBE';
3263: m_cube_en.Type := 'MEASCUBE';
3264: else
3265: m_cube_view := p_cubeView;

Line 3321: m_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);

3317: ' of cube ' || p_cubeView);
3318: end;
3319:
3320: m_column_en.tableId:= m_table_id;
3321: m_column_en.columnName := zpb_metadata_names.get_dimension_column(l_dim);
3322: m_column_en.columnType := 'MEMBER_COLUMN';
3323: m_column_en.AWName := 'NA';
3324:
3325: m_cube_dims_en.columnId := insertColumnRecord(m_column_en);

Line 3364: m_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim, l_hier);

3360: ' of dimension ' || m_cube_dims_en.dimensionId);
3361: end;
3362:
3363: m_column_en.tableId := m_table_id;
3364: m_column_en.columnName := zpb_metadata_names.get_dim_gid_column(l_dim, l_hier);
3365: m_column_en.columnType := 'GID_COLUMN';
3366: m_column_en.AWName := 'NA';
3367:
3368: m_cube_hier_en.columnId := insertColumnRecord(m_column_en);

Line 3378: m_column_en.columnName := zpb_metadata_names.get_dim_gid_column;

3374: elsif (l_gid = false) then
3375: -- no hierarchies case = null hiearchy
3376:
3377: m_column_en.tableId := m_table_id;
3378: m_column_en.columnName := zpb_metadata_names.get_dim_gid_column;
3379: m_column_en.columnType := 'GID_COLUMN';
3380: m_column_en.AWName :='NA';
3381:
3382: m_cube_hier_en.cubeId := m_cube_num;

Line 4058: m_cwm_name := zpb_metadata_names.get_measure_cwm2

4054: p_awParam :=p_aw;
4055: end if;
4056:
4057: if (instr (l_measType, '_DATA') > 0) then
4058: m_cwm_name := zpb_metadata_names.get_measure_cwm2
4059: (p_awParam,p_instance,l_measType,p_template,p_approvee, p_currencyRel);
4060: elsif (instr (l_measType, '_ANNOTATION') > 0) then
4061: m_cwm_name := zpb_metadata_names.get_measure_annot_cwm2
4062: (p_awParam,p_instance,l_measType,p_template,p_approvee, p_currencyRel);

Line 4061: m_cwm_name := zpb_metadata_names.get_measure_annot_cwm2

4057: if (instr (l_measType, '_DATA') > 0) then
4058: m_cwm_name := zpb_metadata_names.get_measure_cwm2
4059: (p_awParam,p_instance,l_measType,p_template,p_approvee, p_currencyRel);
4060: elsif (instr (l_measType, '_ANNOTATION') > 0) then
4061: m_cwm_name := zpb_metadata_names.get_measure_annot_cwm2
4062: (p_awParam,p_instance,l_measType,p_template,p_approvee, p_currencyRel);
4063: elsif (instr (l_measType, '_TARGET_TYPE') > 0) then
4064: m_cwm_name := zpb_metadata_names.get_measure_targ_type_cwm2
4065: (p_awParam,p_instance,l_measType,p_template,p_approvee);

Line 4064: m_cwm_name := zpb_metadata_names.get_measure_targ_type_cwm2

4060: elsif (instr (l_measType, '_ANNOTATION') > 0) then
4061: m_cwm_name := zpb_metadata_names.get_measure_annot_cwm2
4062: (p_awParam,p_instance,l_measType,p_template,p_approvee, p_currencyRel);
4063: elsif (instr (l_measType, '_TARGET_TYPE') > 0) then
4064: m_cwm_name := zpb_metadata_names.get_measure_targ_type_cwm2
4065: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4066: elsif (instr (l_measType, '_TARGET') > 0) then
4067: m_cwm_name := zpb_metadata_names.get_measure_target_cwm2
4068: (p_awParam,p_instance,l_measType,p_template,p_approvee);

Line 4067: m_cwm_name := zpb_metadata_names.get_measure_target_cwm2

4063: elsif (instr (l_measType, '_TARGET_TYPE') > 0) then
4064: m_cwm_name := zpb_metadata_names.get_measure_targ_type_cwm2
4065: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4066: elsif (instr (l_measType, '_TARGET') > 0) then
4067: m_cwm_name := zpb_metadata_names.get_measure_target_cwm2
4068: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4069: elsif (instr (l_measType, '_INPUT_LEVEL') > 0) then
4070: m_cwm_name := zpb_metadata_names.get_measure_input_lvl_cwm2
4071: (p_awParam,p_instance,l_measType,p_template,p_approvee);

Line 4070: m_cwm_name := zpb_metadata_names.get_measure_input_lvl_cwm2

4066: elsif (instr (l_measType, '_TARGET') > 0) then
4067: m_cwm_name := zpb_metadata_names.get_measure_target_cwm2
4068: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4069: elsif (instr (l_measType, '_INPUT_LEVEL') > 0) then
4070: m_cwm_name := zpb_metadata_names.get_measure_input_lvl_cwm2
4071: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4072: elsif (instr (l_measType, '_WRITE_SECURITY') > 0) then
4073:
4074: if(instr (l_measType, 'PERSONAL_ENTERED') > 0) then

Line 4075: m_cwm_name := zpb_metadata_names.get_measure_cur_write_sec_cwm2

4071: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4072: elsif (instr (l_measType, '_WRITE_SECURITY') > 0) then
4073:
4074: if(instr (l_measType, 'PERSONAL_ENTERED') > 0) then
4075: m_cwm_name := zpb_metadata_names.get_measure_cur_write_sec_cwm2
4076: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4077: else
4078: m_cwm_name := zpb_metadata_names.get_measure_write_sec_cwm2
4079: (p_awParam,p_instance,l_measType,p_template,p_approvee);

Line 4078: m_cwm_name := zpb_metadata_names.get_measure_write_sec_cwm2

4074: if(instr (l_measType, 'PERSONAL_ENTERED') > 0) then
4075: m_cwm_name := zpb_metadata_names.get_measure_cur_write_sec_cwm2
4076: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4077: else
4078: m_cwm_name := zpb_metadata_names.get_measure_write_sec_cwm2
4079: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4080: end if;
4081:
4082: elsif (instr (l_measType, '_FORMAT') > 0) then

Line 4083: m_cwm_name := zpb_metadata_names.get_measure_format_cwm2

4079: (p_awParam,p_instance,l_measType,p_template,p_approvee);
4080: end if;
4081:
4082: elsif (instr (l_measType, '_FORMAT') > 0) then
4083: m_cwm_name := zpb_metadata_names.get_measure_format_cwm2
4084: (p_awParam,p_instance,l_measType,p_template,p_approvee, p_currencyRel);
4085: end if;
4086:
4087: m_meas_en.CWMName := m_cwm_name;

Line 4342: BUILD_CUBE(p_aw, zpb_metadata_names.get_security_view(p_aw), l_dims, 'SEC_CUBE');

4338: -- Generate the dimension up front, since they are the same for all meas
4339: --
4340: l_dims := zpb_aw.interp ('shw CM.GETDATADIMS');
4341:
4342: BUILD_CUBE(p_aw, zpb_metadata_names.get_security_view(p_aw), l_dims, 'SEC_CUBE');
4343:
4344:
4345: --
4346: -- Full scope:

Line 4351: m_meas_en.CWMName := zpb_metadata_names.get_full_scope_cwm2_name(p_aw);

4347: --
4348:
4349: m_meas_en.name := 'FULL_SCOPE';
4350: m_meas_en.type := 'FULL_SCOPE';
4351: m_meas_en.CWMName := zpb_metadata_names.get_full_scope_cwm2_name(p_aw);
4352: m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);
4353:
4354: m_column_en.columnName := zpb_metadata_names.get_full_scope_column;
4355: m_column_en.columnType := 'FULLSCOPE';

Line 4352: m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);

4348:
4349: m_meas_en.name := 'FULL_SCOPE';
4350: m_meas_en.type := 'FULL_SCOPE';
4351: m_meas_en.CWMName := zpb_metadata_names.get_full_scope_cwm2_name(p_aw);
4352: m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);
4353:
4354: m_column_en.columnName := zpb_metadata_names.get_full_scope_column;
4355: m_column_en.columnType := 'FULLSCOPE';
4356: m_column_en.AWName := '';

Line 4354: m_column_en.columnName := zpb_metadata_names.get_full_scope_column;

4350: m_meas_en.type := 'FULL_SCOPE';
4351: m_meas_en.CWMName := zpb_metadata_names.get_full_scope_cwm2_name(p_aw);
4352: m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);
4353:
4354: m_column_en.columnName := zpb_metadata_names.get_full_scope_column;
4355: m_column_en.columnType := 'FULLSCOPE';
4356: m_column_en.AWName := '';
4357:
4358: m_meas_en.AWName :='NA';

Line 4378: -- m_meas_en.CWMName := zpb_metadata_names.get_writemap_cwm2_name(p_aw);

4374: -- Writemap:
4375: --
4376: -- m_meas_en.name := 'WRITEMAP';
4377: -- m_meas_en.type := 'WRITEMAP';
4378: -- m_meas_en.CWMName := zpb_metadata_names.get_writemap_cwm2_name(p_aw);
4379: -- m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);
4380: --
4381: -- m_column_en.columnName := zpb_metadata_names.get_writemap_column;
4382: -- m_column_en.columnType := 'WRITEMAP';

Line 4379: -- m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);

4375: --
4376: -- m_meas_en.name := 'WRITEMAP';
4377: -- m_meas_en.type := 'WRITEMAP';
4378: -- m_meas_en.CWMName := zpb_metadata_names.get_writemap_cwm2_name(p_aw);
4379: -- m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);
4380: --
4381: -- m_column_en.columnName := zpb_metadata_names.get_writemap_column;
4382: -- m_column_en.columnType := 'WRITEMAP';
4383: -- m_column_en.AWName := 'TempNA';

Line 4381: -- m_column_en.columnName := zpb_metadata_names.get_writemap_column;

4377: -- m_meas_en.type := 'WRITEMAP';
4378: -- m_meas_en.CWMName := zpb_metadata_names.get_writemap_cwm2_name(p_aw);
4379: -- m_meas_cube_name := zpb_metadata_names.get_security_cwm2_cube(p_aw);
4380: --
4381: -- m_column_en.columnName := zpb_metadata_names.get_writemap_column;
4382: -- m_column_en.columnType := 'WRITEMAP';
4383: -- m_column_en.AWName := 'TempNA';
4384:
4385: -- m_meas_en.AWName :='NA';

Line 4421: m_table_en.TableName := zpb_metadata_names.get_all_annotations_view(p_aw);

4417: -- All annotations table:
4418: --
4419:
4420: -- initialize ALL_ANNOTATIONS table
4421: m_table_en.TableName := zpb_metadata_names.get_all_annotations_view(p_aw);
4422: m_table_en.TableType := 'ALL_ANNOTATIONS';
4423:
4424: -- initialize column entry for table
4425: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4464: m_table_en.TableName := zpb_metadata_names.get_all_annot_pers_view(p_aw);

4460: m_column_en.AWName := 'ANNDATE';
4461: m_column_id_num := insertColumnRecord(m_column_en);
4462:
4463: -- initialize ALL_PERS_ANNOTATIONS table
4464: m_table_en.TableName := zpb_metadata_names.get_all_annot_pers_view(p_aw);
4465: m_table_en.TableType := 'ALL_PERS_ANNOTATIONS';
4466:
4467: -- this table and ALL_ANNOTATIONS table have same columns
4468:

Line 4512: m_table_en.TableName := zpb_metadata_names.get_scope_status_view(p_aw);

4508: --
4509: -- Security scope status table
4510: --
4511:
4512: m_table_en.TableName := zpb_metadata_names.get_scope_status_view(p_aw);
4513: m_table_en.TableType := 'SCOPE_STATUS';
4514:
4515: -- initiaize columns for SCOPE_STATUS table
4516: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4540: m_table_en.TableName := zpb_metadata_names.get_data_exception_view(p_aw);

4536: --
4537: -- Data Exception table
4538: --
4539:
4540: m_table_en.TableName := zpb_metadata_names.get_data_exception_view(p_aw);
4541: m_table_en.TableType := 'DATA_EXCEPTION';
4542:
4543: -- initiaize columns for DATA_EXCEPTION table : currently no columns
4544: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4550: m_table_en.TableName := zpb_metadata_names.get_solve_level_table(p_aw);

4546: --
4547: -- Solve Input/Output level table
4548: --
4549:
4550: m_table_en.TableName := zpb_metadata_names.get_solve_level_table(p_aw);
4551: m_table_en.TableType := 'SOLVE_LEVEL';
4552:
4553: -- initiaize columns for SOLVE_LEVEL table : currently no columns
4554: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4560: m_table_en.TableName := zpb_metadata_names.get_to_currency_view(p_aw);

4556: --
4557: -- To Currency Tables
4558: --
4559:
4560: m_table_en.TableName := zpb_metadata_names.get_to_currency_view(p_aw);
4561: m_table_en.TableType := 'TO_CURRENCY';
4562:
4563: -- initiaize columns for to currency table
4564: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4594: m_table_en.TableName := zpb_metadata_names.get_exch_rates_view(p_aw);

4590: --
4591: -- Exchange Rates View
4592: --
4593:
4594: m_table_en.TableName := zpb_metadata_names.get_exch_rates_view(p_aw);
4595: m_table_en.TableType := 'EXCH_RATES';
4596:
4597: -- initiaize columns for to currency table
4598: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4628: m_table_en.TableName := zpb_metadata_names.get_exch_scenario_view(p_aw);

4624: --
4625: -- Exchange Scenario
4626: --
4627:
4628: m_table_en.TableName := zpb_metadata_names.get_exch_scenario_view(p_aw);
4629: m_table_en.TableType := 'EXCH_SCENARIO';
4630:
4631: -- initiaize columns for to currency table
4632: m_column_en.TableId := insertTableRecord(m_table_en);

Line 4793: l_cube := zpb_metadata_names.get_exception_meas_cube(p_sharedAw,l_currInst);

4789: into l_currInst
4790: from ZPB_ANALYSIS_CYCLES
4791: where ANALYSIS_CYCLE_ID = p_instance;
4792:
4793: l_cube := zpb_metadata_names.get_exception_meas_cube(p_sharedAw,l_currInst);
4794:
4795: m_cube_en.Name := l_cube;
4796: m_cube_en.Type := 'PRSMEASCUBE';
4797: m_cube_en.EpbId :='NA';

Line 4819: m_table_en.TableName := zpb_metadata_names.get_exception_check_tbl(p_sharedAw);

4815: zpb_cubes.table_id = zpb_tables.table_id;
4816:
4817: else
4818:
4819: m_table_en.TableName := zpb_metadata_names.get_exception_check_tbl(p_sharedAw);
4820:
4821: end if;
4822:
4823: m_table_en.AwName :='NA';

Line 4848: m_column_en.ColumnName := zpb_metadata_names.get_dimension_column(l_dim);

4844: where epb_id = l_dim and
4845: bus_area_id = bus_area_id_num;
4846:
4847: m_column_en.ColumnType :='MEMBER_COLUMN';
4848: m_column_en.ColumnName := zpb_metadata_names.get_dimension_column(l_dim);
4849: m_column_en.AwName := 'NA';
4850:
4851: -- insert Column and Reference column_id in cube-dim relation
4852: m_cube_dims_en.ColumnId := insertColumnRecord(m_column_en);

Line 4875: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column(l_dim, l_hier);

4871: end if;
4872:
4873: -- insert hierarchy columns into cube table
4874: m_column_en.ColumnType :='GID_COLUMN';
4875: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column(l_dim, l_hier);
4876: m_column_en.AwName := 'NA';
4877:
4878: -- insert Column and Reference column_id in cube-hier relation
4879: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);

Line 4895: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column;

4891: elsif (l_gid = false) then
4892: l_gid := true;
4893:
4894: m_column_en.ColumnType :='GID_COLUMN';
4895: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column;
4896: m_column_en.AwName := 'NA';
4897:
4898: -- insert Column and Reference column_id in cube-hier relation
4899: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);

Line 4915: m_meas_en.CwmName := zpb_metadata_names.get_exception_meas_cwm2(p_persAw, l_currInst);

4911:
4912: -- initialize measure entry
4913: m_meas_en.CubeId := m_cube_id;
4914: m_meas_en.Name := p_name;
4915: m_meas_en.CwmName := zpb_metadata_names.get_exception_meas_cwm2(p_persAw, l_currInst);
4916: m_meas_en.Type := 'EXCEPTION_DATA';
4917: m_meas_en.InstanceId := l_currInst;
4918:
4919: m_meas_en.AwName := l_frmcpr;

Line 4931: m_column_en.ColumnName := zpb_metadata_names.get_exception_column;

4927:
4928: if p_fake_flag = false then
4929: m_column_en.ColumnName := 'COL_DF_CPR';
4930: else
4931: m_column_en.ColumnName := zpb_metadata_names.get_exception_column;
4932: end if;
4933:
4934: m_column_en.AwName := 'NA';
4935:

Line 5001: m_cube_en.Name := zpb_metadata_names.get_ownermap_cwm2_cube(p_aw);

4997: l_aw := zpb_aw.get_schema||'.'||p_aw||'!';
4998: i := 1;
4999:
5000: -- initialize cube entry
5001: m_cube_en.Name := zpb_metadata_names.get_ownermap_cwm2_cube(p_aw);
5002: m_cube_en.Type := 'MEASCUBE';
5003: m_cube_en.EpbID :='NA';
5004:
5005: -- cube table

Line 5006: m_table_en.TableName := zpb_metadata_names.get_ownermap_view(p_aw);

5002: m_cube_en.Type := 'MEASCUBE';
5003: m_cube_en.EpbID :='NA';
5004:
5005: -- cube table
5006: m_table_en.TableName := zpb_metadata_names.get_ownermap_view(p_aw);
5007: m_table_en.AwName :='NA';
5008: m_table_en.TableType := 'MEASURE';
5009:
5010: m_cube_en.TableId := insertTableRecord(m_table_en);

Line 5031: m_column_en.ColumnName := zpb_metadata_names.get_dimension_column(l_dim);

5027: end if;
5028: l_dim_ecm := zpb_ecm.get_dimension_ecm(l_dim, p_aw);
5029:
5030: -- initialize dimension entry
5031: m_column_en.ColumnName := zpb_metadata_names.get_dimension_column(l_dim);
5032: m_column_en.ColumnType := 'MEMBER_COLUMN';
5033: m_column_en.AWName :='NA';
5034:
5035: -- set dimension id for cube-dims relation

Line 5062: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column(l_dim, l_hier);

5058: end if;
5059:
5060: -- insert hierarchy columns into cube table
5061: m_column_en.ColumnType :='GID_COLUMN';
5062: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column(l_dim, l_hier);
5063: m_column_en.AwName := 'NA';
5064:
5065: -- insert Column and Reference column_id in cube-hier relation
5066: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);

Line 5081: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column;

5077: elsif (l_gid = false) then
5078: l_gid := true;
5079:
5080: m_column_en.ColumnType :='GID_COLUMN';
5081: m_column_en.ColumnName := zpb_metadata_names.get_dim_gid_column;
5082: m_column_en.AwName := 'NA';
5083:
5084: -- insert Column and Reference column_id in cube-hier relation
5085: m_cube_hier_en.ColumnId :=insertColumnRecord(m_column_en);

Line 5101: m_meas_en.CwmName := zpb_metadata_names.get_ownermap_cwm2_name(p_aw);

5097:
5098: -- initialize measure entry
5099: m_meas_en.CubeId := m_cube_id;
5100: m_meas_en.Name := 'OWNERMAP';
5101: m_meas_en.CwmName := zpb_metadata_names.get_ownermap_cwm2_name(p_aw);
5102: m_meas_en.Type := 'OWNERMAP';
5103:
5104: m_meas_en.AwName :='NA';
5105: m_meas_en.CurrencyType :='NA';

Line 5111: m_column_en.ColumnName := zpb_metadata_names.get_ownermap_column;

5107: m_meas_en.CurrInstFlag := 'N';
5108:
5109: -- insert column entry for measure col of cube table
5110: m_column_en.ColumnType :='OWNERMAP';
5111: m_column_en.ColumnName := zpb_metadata_names.get_ownermap_column;
5112: m_column_en.AwName := 'NA';
5113:
5114: m_meas_en.ColumnId := insertColumnRecord(m_column_en);
5115:

Line 5562: l_hier_perscwm := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);

5558: l_accessToAHier:=true;
5559:
5560: -- add scope for this hierarchy
5561: l_hier_scope_en.UserId := l_user_id;
5562: l_hier_perscwm := zpb_metadata_names.get_hierarchy_cwm2_name('PRS', l_dim, l_hier);
5563:
5564: select hierarchy_id, pers_table_id
5565: into l_hier_scope_en.HierarchyId, l_hier_scope_en.PersTableId
5566: from zpb_hierarchies

Line 5615: l_level_perscwm := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim, l_lvlHier, l_level);

5611:
5612: -- dbms_output.put_line('Level has members');
5613:
5614: l_lvlHier := l_hier;
5615: l_level_perscwm := zpb_metadata_names.get_level_cwm2_name('PRS', l_dim, l_lvlHier, l_level);
5616:
5617: -- Although we are calling the insert commands for the personal personal table and
5618: -- the personal column records, we expect them to already exist, and are just using
5619: -- the insert helper functions to get information back (ids of the table and columns)

Line 5620: l_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view

5616:
5617: -- Although we are calling the insert commands for the personal personal table and
5618: -- the personal column records, we expect them to already exist, and are just using
5619: -- the insert helper functions to get information back (ids of the table and columns)
5620: l_hr_pers_table_en.TableName := zpb_metadata_names.get_dimension_view
5621: (p_aw, 'PERSONAL', l_dim, l_hier);
5622: l_hr_pers_table_en.AwName := p_aw;
5623: l_hr_pers_table_en.BusAreaId := bus_area_id_num;
5624: l_hr_pers_table_en.TableType :='HIERARCHY';

Line 5628: l_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);

5624: l_hr_pers_table_en.TableType :='HIERARCHY';
5625: l_pers_column_en.TableId:= insertTableRecord(l_hr_pers_table_en);
5626:
5627: l_pers_column_en.columnType :='LEVEL_COLUMN';
5628: l_pers_column_en.columnName := zpb_metadata_names.get_level_column(l_dim, l_level);
5629:
5630: l_hl_scope_en.PersColId := insertColumnRecord(l_pers_column_en);
5631:
5632: -- dbms_output.put_line('About to check personal');

Line 5771: l_attr_perscwm := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);

5767: -- explicitly exclude timespan and non displayed attrs
5768: if (instr (l_attr, 'TIMESPAN') = 0 and (zpb_aw.interpbool('shw exists(''' || l_aw || l_global_attr_ecm.AttrDisplayVar || ''')')
5769: and zpb_aw.interpbool('shw '||l_aw|| l_global_attr_ecm.AttrDisplayVar))) then
5770:
5771: l_attr_perscwm := zpb_metadata_names.get_attribute_cwm2_name('PRS',l_dim,l_attr);
5772:
5773: select attribute_id into l_attr_scope_en.AttributeId
5774: from zpb_attributes
5775: where dimension_id = l_dimension_id and