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_TABLES

Line 126: -- zpb_md_records.tables_entry into zpb_tables and

122: end insertDimensionRecord;
123:
124: -------------------------------------------------------------------------------
125: -- insertTableRecord - Private function that inserts a
126: -- zpb_md_records.tables_entry into zpb_tables and
127: -- returns the primary key of the newly created entry
128: --
129: -- if p_primary_key_provided is true, then the primary key for the
130: -- table to be inserted is provided and we do not select it from sequence

Line 150: from zpb_tables

146:
147: begin
148:
149: select table_id into l_table_rec.TableId
150: from zpb_tables
151: where bus_area_id = bus_area_id_num and
152: table_name = l_table_rec.TableName;
153:
154: update zpb_tables

Line 154: update zpb_tables

150: from zpb_tables
151: where bus_area_id = bus_area_id_num and
152: table_name = l_table_rec.TableName;
153:
154: update zpb_tables
155: set
156: AW_NAME = l_table_rec.AwName,
157: TABLE_TYPE = l_table_rec.TableType,
158: CREATED_BY = FND_GLOBAL.USER_ID,

Line 167: SELECT zpb_tables_seq.NEXTVAL INTO l_table_rec.TableId FROM DUAL;

163: where table_id = l_table_rec.TableId;
164:
165: exception
166: when NO_DATA_FOUND then
167: SELECT zpb_tables_seq.NEXTVAL INTO l_table_rec.TableId FROM DUAL;
168: insert_flag := true;
169: end;
170: end if;
171:

Line 174: insert into zpb_tables

170: end if;
171:
172: if insert_flag = true then
173:
174: insert into zpb_tables
175: (
176: AW_NAME,
177: BUS_AREA_ID,
178: TABLE_ID,

Line 1150: delete zpb_tables

1146: where table_id=(select table_id
1147: from zpb_cubes
1148: where cube_id = p_cube_id);
1149:
1150: delete zpb_tables
1151: where table_id = (select table_id
1152: from zpb_cubes
1153: where cube_id = p_cube_id);
1154:

Line 1534: -- delete hierarchy zpb_tables and zpb_column entries

1530: where hierarchy_id in (select hierarchy_id
1531: from zpb_hierarchies
1532: where dimension_id = p_dimension_id);
1533:
1534: -- delete hierarchy zpb_tables and zpb_column entries
1535: delete zpb_tables
1536: where table_id in (select pers_table_id from zpb_hierarchies
1537: where dimension_id = p_dimension_id);
1538:

Line 1535: delete zpb_tables

1531: from zpb_hierarchies
1532: where dimension_id = p_dimension_id);
1533:
1534: -- delete hierarchy zpb_tables and zpb_column entries
1535: delete zpb_tables
1536: where table_id in (select pers_table_id from zpb_hierarchies
1537: where dimension_id = p_dimension_id);
1538:
1539: delete zpb_columns

Line 1543: delete zpb_tables

1539: delete zpb_columns
1540: where table_id in (select pers_table_id from zpb_hierarchies
1541: where dimension_id = p_dimension_id);
1542:
1543: delete zpb_tables
1544: where table_id in (select shar_table_id from zpb_hierarchies
1545: where dimension_id = p_dimension_id);
1546:
1547: delete zpb_columns

Line 1566: -- Delete zpb_tables entries for dimension

1562: delete zpb_levels
1563: where dimension_id = p_dimension_id;
1564:
1565:
1566: -- Delete zpb_tables entries for dimension
1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

Line 1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);

1563: where dimension_id = p_dimension_id;
1564:
1565:
1566: -- Delete zpb_tables entries for dimension
1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

Line 1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

1566: -- Delete zpb_tables entries for dimension
1567: delete zpb_tables where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1569:
1570: delete zpb_tables where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);
1572:
1573: -- Finally delete dimension
1574: delete zpb_dimensions

Line 1647: -- delete zpb_tables for hierarchy

1643: -- delete hier_scope
1644: delete zpb_hier_scope
1645: where hierarchy_id = p_hierarchy_id;
1646:
1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

Line 1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

1644: delete zpb_hier_scope
1645: where hierarchy_id = p_hierarchy_id;
1646:
1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

Line 1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

1647: -- delete zpb_tables for hierarchy
1648: delete zpb_tables where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1650:
1651: delete zpb_tables where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);
1653:
1654: -- Finally delete hierarchies entry
1655: delete zpb_hierarchies

Line 1729: from zpb_tables

1725:
1726: delete zpb_attr_table_col
1727: where last_update_date < p_start_time and
1728: table_id in (select table_id
1729: from zpb_tables
1730: where bus_area_id = bus_area_id_num);
1731:
1732: delete zpb_hier_level
1733: where last_update_date < p_start_time

Line 2154: from zpb_tables

2150: -- Have to get the Primary Key before we insert the entry because sub-entries
2151: -- need to reference entry
2152: begin
2153: select table_id into m_hr_shar_table_en.tableId
2154: from zpb_tables
2155: where table_id = (select shar_table_id
2156: from zpb_hierarchies
2157: where dimension_id = m_dimension_en.DimensionId and
2158: pers_cwm_name = m_hier_en.PersCWMName);

Line 2163: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_shar_table_en.tableId FROM DUAL;

2159: m_shar_table_exists := false;
2160:
2161: exception
2162: when NO_DATA_FOUND then
2163: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_shar_table_en.tableId FROM DUAL;
2164:
2165: m_shar_table_exists := true;
2166: end;
2167:

Line 2174: from zpb_tables

2170: -- if the hierarchy has a personal level, the table name will be different
2171: if l_persLvl = true then
2172:
2173: select table_id into m_hr_pers_table_en.tableId
2174: from zpb_tables
2175: where table_name = m_hr_pers_table_en.TableName and
2176: bus_area_id = bus_area_id_num;
2177:
2178: else

Line 2180: from zpb_tables

2176: bus_area_id = bus_area_id_num;
2177:
2178: else
2179: select table_id into m_hr_pers_table_en.tableId
2180: from zpb_tables
2181: where table_id = (select pers_table_id
2182: from zpb_hierarchies
2183: where dimension_id = m_dimension_en.DimensionId and
2184: pers_cwm_name = m_hier_en.PersCWMName);

Line 2191: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_pers_table_en.tableId FROM DUAL;

2187: m_pers_table_exists :=false;
2188:
2189: exception
2190: when NO_DATA_FOUND then
2191: SELECT zpb_tables_seq.NEXTVAL INTO m_hr_pers_table_en.tableId FROM DUAL;
2192: m_pers_table_exists :=true;
2193: end;
2194:
2195: -- dbms_output.put_line('Hier Shar Table ID: ' || m_hr_shar_table_en.tableId );

Line 2476: from zpb_tables

2472: -- otherwise create the new null hierarchy table of type HIERARCHY
2473: begin
2474:
2475: select table_id into m_hier_en.SharTableId
2476: from zpb_tables
2477: where table_name = m_hr_shar_table_en.TableName and
2478: bus_area_id = bus_area_id_num and
2479: table_type = 'DIMENSION';
2480:

Line 2489: from zpb_tables

2485:
2486: begin
2487:
2488: select table_id into m_hier_en.PersTableId
2489: from zpb_tables
2490: where table_name = m_hr_pers_table_en.TableName and
2491: bus_area_id = bus_area_id_num and
2492: table_type = 'DIMENSION';
2493: exception

Line 4812: from zpb_cubes, zpb_tables

4808: l_cpr_meas_cube := l_cpr_meas_cube || '_PRS';
4809:
4810: -- cube table
4811: select table_name into m_table_en.TableName
4812: from zpb_cubes, zpb_tables
4813: where zpb_cubes.name = l_cpr_meas_cube and
4814: zpb_cubes.bus_area_id = bus_area_id_num and
4815: zpb_cubes.table_id = zpb_tables.table_id;
4816:

Line 4815: zpb_cubes.table_id = zpb_tables.table_id;

4811: select table_name into m_table_en.TableName
4812: from zpb_cubes, zpb_tables
4813: where zpb_cubes.name = l_cpr_meas_cube and
4814: zpb_cubes.bus_area_id = bus_area_id_num and
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);

Line 5863: from zpb_tables

5859: v_dim c_dimensions%ROWTYPE;
5860:
5861: CURSOR c_tables is
5862: select table_id
5863: from zpb_tables
5864: where bus_area_id = p_bus_area_id;
5865:
5866: v_table c_tables%ROWTYPE;
5867:

Line 5956: delete zpb_tables

5952: delete zpb_columns
5953: where table_id = v_table.table_id;
5954:
5955: -- delete tables
5956: delete zpb_tables
5957: where table_id = v_table.table_id;
5958:
5959: end loop;
5960: