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.HR_DM_GEN_MAIN dependencies on HR_DM_TABLES

Line 8: -- the table. Mostly the information is taken from HR_DM_TABLES table.

4: -- DATA STRUCTURE DEFINITIONS --
5: --------------------------------
6: --
7: -- Table information structure. It stores the various properties of info about
8: -- the table. Mostly the information is taken from HR_DM_TABLES table.
9: -- table_id - Id value of the table. Primary key of HR_DM_TABLES.
10: -- table_name - Name of the table
11: -- datetrack - 'Y' - for date track table
12: -- 'N' - for non datetrack table

Line 9: -- table_id - Id value of the table. Primary key of HR_DM_TABLES.

5: --------------------------------
6: --
7: -- Table information structure. It stores the various properties of info about
8: -- the table. Mostly the information is taken from HR_DM_TABLES table.
9: -- table_id - Id value of the table. Primary key of HR_DM_TABLES.
10: -- table_name - Name of the table
11: -- datetrack - 'Y' - for date track table
12: -- 'N' - for non datetrack table
13: -- surrogate_primary_key - whether table has a surrogate id column i.e single

Line 96: table_id hr_dm_tables.table_id%type,

92: ----------------------------------------------------------------------------------
93: type t_table_info is record
94: (
95: migration_id hr_dm_migrations.migration_id%type,
96: table_id hr_dm_tables.table_id%type,
97: table_name hr_dm_tables.table_name%type,
98: datetrack hr_dm_tables.datetrack%type,
99: surrogate_primary_key varchar2(1),
100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,

Line 97: table_name hr_dm_tables.table_name%type,

93: type t_table_info is record
94: (
95: migration_id hr_dm_migrations.migration_id%type,
96: table_id hr_dm_tables.table_id%type,
97: table_name hr_dm_tables.table_name%type,
98: datetrack hr_dm_tables.datetrack%type,
99: surrogate_primary_key varchar2(1),
100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,
101: alias hr_dm_tables.table_alias%type,

Line 98: datetrack hr_dm_tables.datetrack%type,

94: (
95: migration_id hr_dm_migrations.migration_id%type,
96: table_id hr_dm_tables.table_id%type,
97: table_name hr_dm_tables.table_name%type,
98: datetrack hr_dm_tables.datetrack%type,
99: surrogate_primary_key varchar2(1),
100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,
101: alias hr_dm_tables.table_alias%type,
102: short_name hr_dm_tables.short_name%type,

Line 100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,

96: table_id hr_dm_tables.table_id%type,
97: table_name hr_dm_tables.table_name%type,
98: datetrack hr_dm_tables.datetrack%type,
99: surrogate_primary_key varchar2(1),
100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,
101: alias hr_dm_tables.table_alias%type,
102: short_name hr_dm_tables.short_name%type,
103: column_hierarchy varchar2(1),
104: table_hierarchy varchar2(1),

Line 101: alias hr_dm_tables.table_alias%type,

97: table_name hr_dm_tables.table_name%type,
98: datetrack hr_dm_tables.datetrack%type,
99: surrogate_primary_key varchar2(1),
100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,
101: alias hr_dm_tables.table_alias%type,
102: short_name hr_dm_tables.short_name%type,
103: column_hierarchy varchar2(1),
104: table_hierarchy varchar2(1),
105: use_non_pk_col_for_chk_row varchar2(1),

Line 102: short_name hr_dm_tables.short_name%type,

98: datetrack hr_dm_tables.datetrack%type,
99: surrogate_primary_key varchar2(1),
100: surrogate_pk_column_name hr_dm_tables.surrogate_pk_column_name%type,
101: alias hr_dm_tables.table_alias%type,
102: short_name hr_dm_tables.short_name%type,
103: column_hierarchy varchar2(1),
104: table_hierarchy varchar2(1),
105: use_non_pk_col_for_chk_row varchar2(1),
106: resolve_pk varchar2(1),

Line 113: who_link_alias hr_dm_tables.who_link_alias%type,

109: fk_to_aol_table varchar2(1),
110: missing_who_info varchar2(1),
111: missing_primary_key varchar2(1),
112: chk_row_exists_for_non_glb_tbl varchar2(1),
113: who_link_alias hr_dm_tables.who_link_alias%type,
114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,
115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,

Line 114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,

110: missing_who_info varchar2(1),
111: missing_primary_key varchar2(1),
112: chk_row_exists_for_non_glb_tbl varchar2(1),
113: who_link_alias hr_dm_tables.who_link_alias%type,
114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,
115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,

Line 115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,

111: missing_primary_key varchar2(1),
112: chk_row_exists_for_non_glb_tbl varchar2(1),
113: who_link_alias hr_dm_tables.who_link_alias%type,
114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,
115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,

Line 116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,

112: chk_row_exists_for_non_glb_tbl varchar2(1),
113: who_link_alias hr_dm_tables.who_link_alias%type,
114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,
115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,

Line 117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,

113: who_link_alias hr_dm_tables.who_link_alias%type,
114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,
115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,

Line 118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,

114: derive_sql_download_full hr_dm_tables.derive_sql_download_full%type,
115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,

Line 119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,

115: derive_sql_download_add hr_dm_tables.derive_sql_download_add%type,
116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,

Line 120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,

116: derive_sql_calc_ranges hr_dm_tables.derive_sql_calc_ranges%type,
117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,
124: always_check_row hr_dm_tables.always_check_row%type,

Line 121: global_data hr_dm_tables.global_data%type,

117: derive_sql_delete_source hr_dm_tables.derive_sql_delete_source%type,
118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,
124: always_check_row hr_dm_tables.always_check_row%type,
125: sequence_name hr_dm_tables.sequence_name%type

Line 122: upload_table_name hr_dm_tables.upload_table_name%type,

118: derive_sql_source_tables hr_dm_tables.derive_sql_source_tables%type,
119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,
124: always_check_row hr_dm_tables.always_check_row%type,
125: sequence_name hr_dm_tables.sequence_name%type
126: );

Line 123: use_distinct_download hr_dm_tables.use_distinct_download%type,

119: derive_sql_chk_source_tables hr_dm_tables.derive_sql_chk_source_tables%type,
120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,
124: always_check_row hr_dm_tables.always_check_row%type,
125: sequence_name hr_dm_tables.sequence_name%type
126: );
127:

Line 124: always_check_row hr_dm_tables.always_check_row%type,

120: derive_sql_chk_row_exists hr_dm_tables.derive_sql_chk_row_exists%type,
121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,
124: always_check_row hr_dm_tables.always_check_row%type,
125: sequence_name hr_dm_tables.sequence_name%type
126: );
127:
128: type t_table_info_tbl is table of t_table_info index by binary_integer;

Line 125: sequence_name hr_dm_tables.sequence_name%type

121: global_data hr_dm_tables.global_data%type,
122: upload_table_name hr_dm_tables.upload_table_name%type,
123: use_distinct_download hr_dm_tables.use_distinct_download%type,
124: always_check_row hr_dm_tables.always_check_row%type,
125: sequence_name hr_dm_tables.sequence_name%type
126: );
127:
128: type t_table_info_tbl is table of t_table_info index by binary_integer;
129:

Line 136: -- parent_table_id - Table Id (Primary key of HR_DM_TABLES) of the AOL table.

132: -- have a foreign key to the aol table.
133: --
134: -- column_name - Name of the column of the table which has foreign key
135: -- on AOL table.
136: -- parent_table_id - Table Id (Primary key of HR_DM_TABLES) of the AOL table.
137: -- parent_table_name - Name of the AOL table.
138: -- parent_table_alias - Alias of the AOL table.
139: -- parent_column_name - Developer key of the AOL table.
140: -- parent_id_column_name - Primary key of AOL table.

Line 146: parent_table_name hr_dm_tables.table_name%type,

142: type t_fk_to_aol_columns_info is record
143: (
144: column_name hr_dm_hierarchies.column_name%type,
145: parent_table_id hr_dm_hierarchies.parent_table_id%type,
146: parent_table_name hr_dm_tables.table_name%type,
147: parent_table_alias hr_dm_tables.table_alias%type,
148: parent_column_name hr_dm_hierarchies.parent_column_name%type,
149: parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type
150: );

Line 147: parent_table_alias hr_dm_tables.table_alias%type,

143: (
144: column_name hr_dm_hierarchies.column_name%type,
145: parent_table_id hr_dm_hierarchies.parent_table_id%type,
146: parent_table_name hr_dm_tables.table_name%type,
147: parent_table_alias hr_dm_tables.table_alias%type,
148: parent_column_name hr_dm_hierarchies.parent_column_name%type,
149: parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type
150: );
151: