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_COLUMNS

Line 209: -- zpb_md_records.columns_entry into zpb_columns and

205:
206:
207: -------------------------------------------------------------------------------
208: -- insertColumnRecord - Private function that inserts a
209: -- zpb_md_records.columns_entry into zpb_columns and
210: -- returns the primary key of the newly created entry
211: -------------------------------------------------------------------------------
212: function insertColumnRecord(p_col_rec in zpb_md_records.columns_entry)
213: return number is

Line 224: from zpb_columns

220:
221: begin
222:
223: select column_id into l_col_rec.ColumnId
224: from zpb_columns
225: where table_id = l_col_rec.TableId and
226: column_name = l_col_rec.ColumnName;
227:
228: update zpb_columns

Line 228: update zpb_columns

224: from zpb_columns
225: where table_id = l_col_rec.TableId and
226: column_name = l_col_rec.ColumnName;
227:
228: update zpb_columns
229: set
230: AW_NAME = l_col_rec.AwName,
231: COLUMN_NAME = l_col_rec.ColumnName,
232: COLUMN_TYPE = l_col_rec.ColumnType,

Line 244: SELECT zpb_columns_seq.NEXTVAL INTO l_col_rec.ColumnId FROM DUAL;

240:
241:
242: exception
243: when NO_DATA_FOUND then
244: SELECT zpb_columns_seq.NEXTVAL INTO l_col_rec.ColumnId FROM DUAL;
245:
246: insert into zpb_columns
247: (
248: COLUMN_ID,

Line 246: insert into zpb_columns

242: exception
243: when NO_DATA_FOUND then
244: SELECT zpb_columns_seq.NEXTVAL INTO l_col_rec.ColumnId FROM DUAL;
245:
246: insert into zpb_columns
247: (
248: COLUMN_ID,
249: AW_NAME,
250: COLUMN_NAME,

Line 1145: delete zpb_columns

1141: delete zpb_measures
1142: where cube_id = p_cube_id;
1143:
1144: -- delete table and column entries for cube
1145: delete zpb_columns
1146: where table_id=(select table_id
1147: from zpb_cubes
1148: where cube_id = p_cube_id);
1149:

Line 1539: delete zpb_columns

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
1540: where table_id in (select pers_table_id from zpb_hierarchies
1541: where dimension_id = p_dimension_id);
1542:
1543: delete zpb_tables

Line 1547: delete zpb_columns

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
1548: where table_id in (select shar_table_id from zpb_hierarchies
1549: where dimension_id = p_dimension_id);
1550:
1551: -- Finally delete hierarchies entry

Line 1568: delete zpb_columns where table_id = (select pers_table_id from zpb_dimensions 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);
1572:

Line 1571: delete zpb_columns where table_id = (select shar_table_id from zpb_dimensions where dimension_id = p_dimension_id);

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
1575: where dimension_id = p_dimension_id;

Line 1649: delete zpb_columns where table_id = (select pers_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

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);
1653:

Line 1652: delete zpb_columns where table_id = (select shar_table_id from zpb_hierarchies where hierarchy_id = p_hierarchy_id);

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
1656: where hierarchy_id = p_hierarchy_id;

Line 2397: delete zpb_columns

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
2397: delete zpb_columns
2398: where table_id = m_hr_pers_table_en.TableId and
2399: last_update_date < l_pp_hiert_start_time;
2400:
2401: else

Line 5952: delete zpb_columns

5948:
5949: for v_table in c_tables loop
5950:
5951: -- delete columns
5952: delete zpb_columns
5953: where table_id = v_table.table_id;
5954:
5955: -- delete tables
5956: delete zpb_tables