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_PHASE_ITEMS

Line 762: -- phase are deleted and the phase item status in hr_dm_phase_items is reset

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: --
766: -- Input Parameters

Line 782: FROM hr_dm_phase_items phi,

778: --
779:
780: CURSOR csr_c1 IS
781: SELECT phi.phase_item_id
782: FROM hr_dm_phase_items phi,
783: hr_dm_phases ph
784: WHERE (ph.migration_id = p_migration_id)
785: AND (ph.phase_name = 'R')
786: AND (phi.phase_id = ph.phase_id)

Line 827: -- Description: All entries in the hr_dm_phase_items table for the download

823: --
824:
825:
826: -- ---------------------- rollback_down_aol_master ------------------------
827: -- Description: All entries in the hr_dm_phase_items table for the download
828: -- aol phase which have a status of S or E are reset to NS.
829: --
830: --
831: -- Input Parameters

Line 847: FROM hr_dm_phase_items phi,

843: --
844:
845: CURSOR csr_c1 IS
846: SELECT phi.phase_item_id
847: FROM hr_dm_phase_items phi,
848: hr_dm_phases ph
849: WHERE (ph.migration_id = p_migration_id)
850: AND (ph.phase_name = 'DA')
851: AND (phi.phase_id = ph.phase_id)

Line 888: -- Description: All entries in the hr_dm_phase_items table for the upload

884: END rollback_down_aol_master;
885: --
886:
887: -- ---------------------- rollback_up_aol_master ------------------------
888: -- Description: All entries in the hr_dm_phase_items table for the upload
889: -- aol phase are reset to NS.
890: --
891: --
892: -- Input Parameters

Line 908: FROM hr_dm_phase_items phi,

904: --
905:
906: CURSOR csr_c1 IS
907: SELECT phi.phase_item_id
908: FROM hr_dm_phase_items phi,
909: hr_dm_phases ph
910: WHERE (ph.migration_id = p_migration_id)
911: AND (ph.phase_name = 'UA')
912: AND (phi.phase_id = ph.phase_id);

Line 950: -- hr_dm_phase_items table for the download phase which have a status of

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: --
954: -- Input Parameters

Line 979: FROM hr_dm_phase_items phi,

975: l_phase_id NUMBER;
976:
977: CURSOR csr_c1 IS
978: SELECT phi.phase_item_id
979: FROM hr_dm_phase_items phi,
980: hr_dm_phases ph
981: WHERE (ph.migration_id = p_migration_id)
982: AND (ph.phase_name = 'DP')
983: AND (phi.phase_id = ph.phase_id)

Line 994: hr_dm_phase_items pi

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)
997: AND (pi.table_name = tbl.table_name)
998: AND (mr.status IN ('S', 'E'));

Line 1004: hr_dm_phase_items pi,

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)
1007: AND (pi.group_id = tgp.group_id)
1008: AND (tbl.table_name = l_table_name)

Line 1084: -- hr_dm_phase_items table are deleted and the status of the

1080:
1081:
1082: -- ---------------------- rollback_init ------------------------
1083: -- Description: All entries in the hr_dm_phases and the
1084: -- hr_dm_phase_items table are deleted and the status of the
1085: -- migration is reset to NS.
1086: --
1087: --
1088: -- Input Parameters

Line 1122: -- delete all entries in hr_dm_phase_items

1118: OPEN csr_c1;
1119: LOOP
1120: FETCH csr_c1 INTO l_phase_id;
1121: EXIT WHEN csr_c1%NOTFOUND;
1122: -- delete all entries in hr_dm_phase_items
1123: DELETE FROM hr_dm_phase_items
1124: WHERE phase_id = l_phase_id;
1125:
1126: -- delete information from hr_dm_phases

Line 1123: DELETE FROM hr_dm_phase_items

1119: LOOP
1120: FETCH csr_c1 INTO l_phase_id;
1121: EXIT WHEN csr_c1%NOTFOUND;
1122: -- delete all entries in hr_dm_phase_items
1123: DELETE FROM hr_dm_phase_items
1124: WHERE phase_id = l_phase_id;
1125:
1126: -- delete information from hr_dm_phases
1127: DELETE FROM hr_dm_phases

Line 1152: -- Description: All entries in the hr_dm_phase_items table for the generator

1148: END rollback_init;
1149: --
1150:
1151: -- ---------------------------- rollback_generator -------------------------
1152: -- Description: All entries in the hr_dm_phase_items table for the generator
1153: -- phase are reset to NS.
1154: --
1155: --
1156: -- Input Parameters

Line 1172: FROM hr_dm_phase_items phi,

1168: --
1169:
1170: CURSOR csr_c1 IS
1171: SELECT phi.phase_item_id
1172: FROM hr_dm_phase_items phi,
1173: hr_dm_phases ph
1174: WHERE (ph.migration_id = p_migration_id)
1175: AND (ph.phase_name = 'G')
1176: AND (phi.phase_id = ph.phase_id)

Line 1213: -- Description: All entries in the hr_dm_phase_items table for the cleanup

1209: END rollback_generator;
1210: --
1211:
1212: -- ---------------------------- rollback_cleanup -------------------------
1213: -- Description: All entries in the hr_dm_phase_items table for the cleanup
1214: -- phase are reset to NS.
1215: --
1216: --
1217: -- Input Parameters

Line 1233: FROM hr_dm_phase_items phi,

1229: --
1230:
1231: CURSOR csr_c1 IS
1232: SELECT phi.phase_item_id
1233: FROM hr_dm_phase_items phi,
1234: hr_dm_phases ph
1235: WHERE (ph.migration_id = p_migration_id)
1236: AND (ph.phase_name = 'C')
1237: AND (phi.phase_id = ph.phase_id)

Line 1275: -- hr_dm_phase_items tables for the delete phase are reset to NS.

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
1279: -- p_migration_id - current migration id

Line 1298: FROM hr_dm_phase_items phi,

1294: l_range_phase_id NUMBER;
1295:
1296: CURSOR csr_c1 IS
1297: SELECT phi.phase_item_id
1298: FROM hr_dm_phase_items phi,
1299: hr_dm_phases ph
1300: WHERE (ph.migration_id = p_migration_id)
1301: AND (ph.phase_name = 'D')
1302: AND (phi.phase_id = ph.phase_id)

Line 1308: hr_dm_phase_items pi

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'));
1312:

Line 1360: -- Description: All entries in the hr_dm_phase_items table for the upload

1356: END rollback_delete;
1357: --
1358:
1359: -- ---------------------------- rollback_upload -------------------------
1360: -- Description: All entries in the hr_dm_phase_items table for the upload
1361: -- phase are reset to NS.
1362: --
1363: --
1364: -- Input Parameters

Line 1380: FROM hr_dm_phase_items phi,

1376: --
1377:
1378: CURSOR csr_c1 IS
1379: SELECT phi.phase_item_id
1380: FROM hr_dm_phase_items phi,
1381: hr_dm_phases ph
1382: WHERE (ph.migration_id = p_migration_id)
1383: AND (ph.phase_name = 'UP')
1384: AND (phi.phase_id = ph.phase_id)

Line 1551: -- child of hr_dm_phase_items

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);
1554: l_parent_table_status VARCHAR2(30);
1555: l_start_time DATE;

Line 1566: hr_dm_phase_items pi,

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
1570: AND pi.phase_id = ph.phase_id;

Line 1575: FROM hr_dm_phase_items pi_par,

1571:
1572: -- find parent phase item id
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

Line 1578: hr_dm_phase_items pi_rg,

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
1582: AND pi_rg.table_name = tbl.table_name

Line 1592: hr_dm_phase_items rg_pi

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,
1596: hr_dm_migration_ranges mr

Line 1595: FROM hr_dm_phase_items rg_pi,

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,
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');

Line 1604: FROM hr_dm_phase_items

1600:
1601:
1602: CURSOR csr_parent_status IS
1603: SELECT status
1604: FROM hr_dm_phase_items
1605: WHERE phase_item_id = l_parent_table_id;
1606:
1607:
1608:

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

1705:
1706:
1707: -- ------------------------- update_phase_items ----------------------
1708: -- Description: Updates the status of the phase item in the
1709: -- hr_dm_phase_items table. If the status is to be set to C or E then
1710: -- the update status is cascaded up to the parent phase.
1711: --
1712: --
1713: -- Input Parameters

Line 1728: -- table is hr_dm_phase_items

1724:
1725: --
1726: PROCEDURE update_phase_items (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
1727: --
1728: -- table is hr_dm_phase_items
1729: -- parent of n/a
1730: -- child of hr_dm_phases
1731:
1732: l_parent_table_id NUMBER(9);

Line 1739: FROM hr_dm_phase_items

1735:
1736: -- find parent table id
1737: CURSOR csr_parent_id IS
1738: SELECT phase_id
1739: FROM hr_dm_phase_items
1740: WHERE phase_item_id = p_id;
1741:
1742:
1743: --

Line 1762: UPDATE hr_dm_phase_items

1758: l_end_time := sysdate;
1759: END IF;
1760:
1761: -- update the status for this row
1762: UPDATE hr_dm_phase_items
1763: SET status = p_new_status,
1764: start_time = NVL(l_start_time, start_time),
1765: end_time = NVL(l_end_time, end_time)
1766: WHERE phase_item_id = p_id;

Line 1796: -- the status of all the child rows in the hr_dm_phase_items is

1792: -- ------------------------- update_phases ----------------------
1793: -- Description: Updates the status of the phase in the
1794: -- hr_dm_phases table. If the status is to be set to C or E then
1795: -- the update status is cascaded up to the parent phase. For a C,
1796: -- the status of all the child rows in the hr_dm_phase_items is
1797: -- checked.
1798: --
1799: --
1800: -- Input Parameters

Line 1816: -- parent of hr_dm_phase_items

1812: --
1813: PROCEDURE update_phases (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
1814: --
1815: -- table is hr_dm_phases
1816: -- parent of hr_dm_phase_items
1817: -- child of hr_dm_migrations
1818:
1819: l_parent_table_id NUMBER(9);
1820: l_complete VARCHAR2(30);

Line 1827: FROM hr_dm_phase_items

1823:
1824: -- search child table for all complete
1825: CURSOR csr_child_table_complete IS
1826: SELECT status
1827: FROM hr_dm_phase_items
1828: WHERE ((phase_id = p_id)
1829: AND (status <> 'C'));
1830:
1831: -- find parent table id