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_PHASES

Line 182: -- Description: Reads the status of the passed phase from the hr_dm_phases

178: --
179:
180:
181: -- ------------------------- get_phase_status ------------------------
182: -- Description: Reads the status of the passed phase from the hr_dm_phases
183: -- table.
184: --
185: --
186: -- Input Parameters

Line 212: FROM hr_dm_phases

208: l_phase_status VARCHAR2(30);
209:
210: CURSOR csr_status IS
211: SELECT status
212: FROM hr_dm_phases
213: WHERE ((migration_id = p_migration_id)
214: AND (phase_name = p_phase));
215:
216: --

Line 254: -- hr_dm_phases table.

250: --
251:
252: -- ------------------------- get_phase_id ------------------------
253: -- Description: Reads the phase id of the passed phase from the
254: -- hr_dm_phases table.
255: --
256: --
257: -- Input Parameters
258: -- p_phase - code for phase to be reported on

Line 283: FROM hr_dm_phases

279: l_phase_id NUMBER;
280:
281: CURSOR csr_phase IS
282: SELECT phase_id
283: FROM hr_dm_phases
284: WHERE ((migration_id = p_migration_id)
285: AND (phase_name = p_phase));
286:
287: --

Line 783: hr_dm_phases ph

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)
787: AND (phi.status IN ('S', 'E'));

Line 848: hr_dm_phases ph

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)
852: AND (phi.status IN ('S', 'E'));

Line 909: hr_dm_phases ph

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

Line 980: hr_dm_phases ph

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)
984: AND (phi.status IN ('S', 'E'));

Line 1083: -- Description: All entries in the hr_dm_phases and the

1079: --
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: --

Line 1105: FROM hr_dm_phases ph

1101: l_phase_id NUMBER;
1102:
1103: CURSOR csr_c1 IS
1104: SELECT ph.phase_id
1105: FROM hr_dm_phases ph
1106: WHERE (ph.migration_id = p_migration_id)
1107: AND (ph.phase_name = 'I')
1108: AND (ph.status IN ('S', 'E'));
1109:

Line 1126: -- delete information from hr_dm_phases

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
1128: WHERE phase_id = l_phase_id;
1129:
1130: END LOOP;

Line 1127: DELETE FROM hr_dm_phases

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
1128: WHERE phase_id = l_phase_id;
1129:
1130: END LOOP;
1131: CLOSE csr_c1;

Line 1173: hr_dm_phases ph

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)
1177: AND (phi.status IN ('S', 'E'));

Line 1234: hr_dm_phases ph

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)
1238: AND (phi.status IN ('S', 'E'));

Line 1299: hr_dm_phases ph

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)
1303: AND (phi.status IN ('S', 'E'));

Line 1381: hr_dm_phases ph

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)
1385: AND (phi.status IN ('S', 'E'));

Line 1433: -- hr_dm_phases are checked to ensure that they have completed.

1429:
1430: -- ------------------------- update_migrations ------------------------
1431: -- Description: Updates the status of the migration in the hr_dm_migrations
1432: -- table. If the status is to be set to C then all child entries in
1433: -- hr_dm_phases are checked to ensure that they have completed.
1434: --
1435: --
1436: -- Input Parameters
1437: -- p_new_status - new status code

Line 1452: -- parent of hr_dm_phases

1448: --
1449: PROCEDURE update_migrations (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
1450: --
1451: -- table is hr_dm_migrations
1452: -- parent of hr_dm_phases
1453: -- child of (none)
1454:
1455: l_parent_table_id NUMBER(9);
1456: l_complete VARCHAR2(30);

Line 1462: FROM hr_dm_phases

1458:
1459: -- search child table for all complete
1460: CURSOR csr_child_table_complete IS
1461: SELECT status
1462: FROM hr_dm_phases
1463: WHERE ((migration_id = p_id)
1464: AND (status <> 'C'));
1465:
1466: --

Line 1567: hr_dm_phases ph

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;
1571:

Line 1730: -- child of hr_dm_phases

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);
1733: l_start_time DATE;
1734: l_end_time DATE;

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

1790: --
1791:
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: --

Line 1815: -- table is hr_dm_phases

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

Line 1834: FROM hr_dm_phases

1830:
1831: -- find parent table id
1832: CURSOR csr_parent_id IS
1833: SELECT migration_id
1834: FROM hr_dm_phases
1835: WHERE phase_id = p_id;
1836:
1837:
1838: --

Line 1856: UPDATE hr_dm_phases

1852:
1853: -- non-complete
1854: IF (l_new_status IN('S', 'NS', 'E')) THEN
1855: -- update the status for this row
1856: UPDATE hr_dm_phases
1857: SET status = l_new_status,
1858: start_time = NVL(l_start_time, start_time)
1859: WHERE phase_id = p_id;
1860: COMMIT;

Line 1873: UPDATE hr_dm_phases

1869:
1870: IF (csr_child_table_complete%NOTFOUND) THEN
1871: -- update the status for this row since no child rows
1872: -- are incomplete
1873: UPDATE hr_dm_phases
1874: SET status = l_new_status,
1875: end_time = sysdate
1876: WHERE phase_id = p_id;
1877: COMMIT;