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_UTILITY dependencies on HR_DM_MIGRATION_RANGES

Line 761: -- Description: All entries in the hr_dm_migration_ranges table for the range

757: /*-------------------------- PRIVATE ROUTINES ----------------------------*/
758:
759:
760: -- ------------------------- rollback_range_master ------------------------
761: -- Description: All entries in the hr_dm_migration_ranges table for the range
762: -- phase are deleted and the phase item status in hr_dm_phase_items is reset
763: -- to NS.
764: --
765: --

Line 803: -- delete information from hr_dm_migration_ranges

799: OPEN csr_c1;
800: LOOP
801: FETCH csr_c1 INTO l_phase_item_id;
802: EXIT WHEN csr_c1%NOTFOUND;
803: -- delete information from hr_dm_migration_ranges
804: DELETE FROM hr_dm_migration_ranges
805: WHERE phase_item_id = l_phase_item_id;
806: -- update status to not started
807: update_phase_items('NS', l_phase_item_id);

Line 804: DELETE FROM hr_dm_migration_ranges

800: LOOP
801: FETCH csr_c1 INTO l_phase_item_id;
802: EXIT WHEN csr_c1%NOTFOUND;
803: -- delete information from hr_dm_migration_ranges
804: DELETE FROM hr_dm_migration_ranges
805: WHERE phase_item_id = l_phase_item_id;
806: -- update status to not started
807: update_phase_items('NS', l_phase_item_id);
808: END LOOP;

Line 949: -- migration are deleted. All entries in the hr_dm_migration_ranges and the

945: --
946:
947: -- ---------------------- rollback_download_master ------------------------
948: -- Description: Rows in the datapump for batches corresponding to the current
949: -- migration are deleted. All entries in the hr_dm_migration_ranges and the
950: -- hr_dm_phase_items table for the download phase which have a status of
951: -- S or E are reset to NS.
952: --
953: --

Line 992: FROM hr_dm_migration_ranges mr,

988: tbl.short_name,
989: mr.starting_process_sequence,
990: mr.ending_process_sequence,
991: mr.range_id
992: FROM hr_dm_migration_ranges mr,
993: hr_dm_tables tbl,
994: hr_dm_phase_items pi
995: WHERE (pi.phase_id = l_range_phase_id)
996: AND (pi.phase_item_id = mr.phase_item_id)

Line 1002: FROM hr_dm_migration_ranges mr,

998: AND (mr.status IN ('S', 'E'));
999:
1000: CURSOR csr_c3 IS
1001: SELECT pi.batch_id
1002: FROM hr_dm_migration_ranges mr,
1003: hr_dm_tables tbl,
1004: hr_dm_phase_items pi,
1005: hr_dm_table_groupings tgp
1006: WHERE (pi.phase_id = l_phase_id)

Line 1274: -- Description: All entries in the hr_dm_migration_ranges and the

1270: END rollback_cleanup;
1271: --
1272:
1273: -- ------------------------- rollback_delete ------------------------
1274: -- Description: All entries in the hr_dm_migration_ranges and the
1275: -- hr_dm_phase_items tables for the delete phase are reset to NS.
1276: --
1277: --
1278: -- Input Parameters

Line 1307: FROM hr_dm_migration_ranges mr,

1303: AND (phi.status IN ('S', 'E'));
1304:
1305: CURSOR csr_c2 IS
1306: SELECT mr.range_id
1307: FROM hr_dm_migration_ranges mr,
1308: hr_dm_phase_items pi
1309: WHERE (pi.phase_id = l_range_phase_id)
1310: AND (mr.phase_item_id = pi.phase_item_id)
1311: AND (mr.status IN ('S', 'E'));

Line 1529: -- hr_dm_migration_ranges table. If the status is to be set to C or E then

1525:
1526:
1527: -- ------------------------- update_migrations_ranges ----------------------
1528: -- Description: Updates the status of the migration range in the
1529: -- hr_dm_migration_ranges table. If the status is to be set to C or E then
1530: -- the update status is cascaded up to the parent phase.
1531: --
1532: --
1533: -- Input Parameters

Line 1549: -- table is hr_dm_migration_ranges

1545: --
1546: PROCEDURE update_migration_ranges (p_new_status IN VARCHAR2,
1547: p_id IN NUMBER) IS
1548: --
1549: -- table is hr_dm_migration_ranges
1550: -- parent of (none)
1551: -- child of hr_dm_phase_items
1552:
1553: l_parent_table_id NUMBER(9);

Line 1565: FROM hr_dm_migration_ranges mr,

1561:
1562: -- find migration id
1563: CURSOR csr_mig_id IS
1564: SELECT ph.migration_id
1565: FROM hr_dm_migration_ranges mr,
1566: hr_dm_phase_items pi,
1567: hr_dm_phases ph
1568: WHERE p_id = mr.range_id
1569: AND mr.phase_item_id = pi.phase_item_id

Line 1577: hr_dm_migration_ranges mr,

1573: CURSOR csr_par_pi_id IS
1574: SELECT pi_par.phase_item_id
1575: FROM hr_dm_phase_items pi_par,
1576: hr_dm_tables tbl,
1577: hr_dm_migration_ranges mr,
1578: hr_dm_phase_items pi_rg,
1579: hr_dm_table_groupings tgp
1580: WHERE p_id = mr.range_id
1581: AND mr.phase_item_id = pi_rg.phase_item_id

Line 1591: FROM hr_dm_migration_ranges mr,

1587:
1588: -- search 'child' table for all complete
1589: CURSOR csr_child_table_complete IS
1590: SELECT mr.status
1591: FROM hr_dm_migration_ranges mr,
1592: hr_dm_phase_items rg_pi
1593: WHERE (mr.phase_item_id = rg_pi.phase_item_id)
1594: AND (rg_pi.group_id = (SELECT rg_pi.group_id
1595: FROM hr_dm_phase_items rg_pi,

Line 1596: hr_dm_migration_ranges mr

1592: hr_dm_phase_items rg_pi
1593: WHERE (mr.phase_item_id = rg_pi.phase_item_id)
1594: AND (rg_pi.group_id = (SELECT rg_pi.group_id
1595: FROM hr_dm_phase_items rg_pi,
1596: hr_dm_migration_ranges mr
1597: WHERE p_id = mr.range_id
1598: AND mr.phase_item_id = rg_pi.phase_item_id))
1599: AND (mr.status <> 'C');
1600:

Line 1639: UPDATE hr_dm_migration_ranges

1635: l_end_time := sysdate;
1636: END IF;
1637:
1638: -- update the status for this row
1639: UPDATE hr_dm_migration_ranges
1640: SET status = p_new_status,
1641: start_time = NVL(l_start_time, start_time),
1642: end_time = NVL(l_end_time, end_time)
1643: WHERE range_id = p_id;