APPS.HR_DM_INIT dependencies on HR_DM_TABLES

Line 173: -- 4. row in hr_dm_tables has been updated since the last generation

169: -- 1. generator not yet run (last_generated_date is null) OR
170: -- 2. table updated since last run (last_ddl_time >= last_generated_date) OR
171: -- 3. generator updated (generator_version(table) <>
172: -- generator version(generator))
173: -- 4. row in hr_dm_tables has been updated since the last generation
174: -- (last_update_date > last_generated_date)
175:
176: CURSOR csr_select_pi IS
177: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name

Line 178: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

174: -- (last_update_date > last_generated_date)
175:
176: CURSOR csr_select_pi IS
177: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name
178: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
179: all_objects obj, hr_dm_application_groups app,
180: hr_dm_migrations mig
181: WHERE (tbl.table_id = tbg.table_id)
182: AND (app.group_id = tbg.group_id)

Line 204: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

200: tbl.last_update_date))
201: )
202: UNION
203: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name
204: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
205: all_objects obj, hr_dm_application_groups app,
206: hr_dm_migrations mig
207: WHERE (tbl.table_id = tbg.table_id)
208: AND (app.group_id = tbg.group_id)

Line 230: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

226: tbl.last_update_date))
227: )
228: UNION
229: SELECT DISTINCT tbl.loader_name, tbg.group_id, tbl.table_name
230: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
231: hr_dm_application_groups app,
232: hr_dm_migrations mig
233: WHERE (tbl.table_id = tbg.table_id)
234: AND (app.group_id = tbg.group_id)

Line 258: UPDATE hr_dm_tables

254: hr_dm_library.get_generator_version(p_generator_version =>
255: l_generator_version);
256:
257: -- we always want to generate for ff_formulas_f
258: UPDATE hr_dm_tables
259: SET last_generated_date = NULL
260: WHERE table_name = 'FF_FORMULAS_F'
261: OR table_name LIKE 'HR_DMV%';
262: COMMIT;

Line 356: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,

352: l_table_name VARCHAR2(30);
353:
354: CURSOR csr_select_pi IS
355: SELECT tbg.group_id, tbl.table_name
356: FROM hr_dm_tables tbl, hr_dm_table_groupings tbg,
357: hr_dm_groups grp, hr_dm_application_groups apg
358: WHERE ( (tbl.table_id = tbg.table_id)
359: AND (tbg.group_id = grp.group_id)
360: AND (grp.group_type = 'D')

Line 779: hr_dm_tables tbl

775: grp.group_id
776: FROM hr_dm_groups grp,
777: hr_dm_application_groups apg,
778: hr_dm_table_groupings tbg,
779: hr_dm_tables tbl
780: WHERE tbl.table_id = tbg.table_id
781: AND tbg.group_id = grp.group_id
782: AND grp.group_type = 'A'
783: AND grp.group_id = apg.group_id

Line 867: -- get loader info from hr_dm_tables

863:
864: -- null out unused entries
865: l_param_rec.parameter10 := NULL;
866:
867: -- get loader info from hr_dm_tables
868: OPEN csr_loader_info;
869: FETCH csr_loader_info INTO l_param_rec.loader_conc_program,
870: l_param_rec.loader_config_file,
871: l_param_rec.loader_application,

Line 953: hr_dm_tables tbl,

949: grp.group_id
950: FROM hr_dm_groups grp,
951: hr_dm_application_groups apg,
952: hr_dm_table_groupings tbg,
953: hr_dm_tables tbl,
954: hr_dm_loader_params lp
955: WHERE (lp.table_id = tbl.table_id)
956: AND (lp.application_id = r_migration_data.application_id)
957: AND (tbl.table_id = tbg.table_id)

Line 1586: hr_dm_tables tbl,

1582: grp.group_id
1583: FROM hr_dm_groups grp,
1584: hr_dm_application_groups apg,
1585: hr_dm_table_groupings tbg,
1586: hr_dm_tables tbl,
1587: hr_dm_loader_params lp
1588: WHERE (lp.table_id = tbl.table_id)
1589: AND (lp.application_id = r_migration_data.application_id)
1590: AND (tbl.table_id = tbg.table_id)

Line 1775: hr_dm_tables tbl,

1771: grp.group_id
1772: FROM hr_dm_groups grp,
1773: hr_dm_application_groups apg,
1774: hr_dm_table_groupings tbg,
1775: hr_dm_tables tbl,
1776: hr_dm_loader_params lp
1777: WHERE (lp.table_id = tbl.table_id)
1778: AND (lp.application_id = r_migration_data.application_id)
1779: AND (tbl.table_id = tbg.table_id)