APPS.HR_DM_INIT dependencies on HR_DM_PHASES

Line 2015: -- hr_dm_phases table.

2011:
2012: -- ------------------------- populate_p_table ----------------------
2013: -- Description: The phases applicable to the current migration and the
2014: -- database location (ie source / destination) are seeded into the
2015: -- hr_dm_phases table.
2016: --
2017: --
2018: -- Input Parameters
2019: -- r_migration_data - record containing migration information

Line 2041: INSERT INTO hr_dm_phases (PHASE_ID,

2037: hr_dm_utility.message('ROUT','entry:hr_dm_init.populate_p_table', 5);
2038: hr_dm_utility.message('PARA','(r_migration_data - record' ||
2039: ')(p_phase_name - ' || p_phase_name || ')', 10);
2040:
2041: INSERT INTO hr_dm_phases (PHASE_ID,
2042: MIGRATION_ID,
2043: PHASE_NAME,
2044: STATUS,
2045: START_TIME,

Line 2052: SELECT hr_dm_phases_s.nextval,

2048: CREATION_DATE,
2049: LAST_UPDATED_BY,
2050: LAST_UPDATE_DATE,
2051: LAST_UPDATE_LOGIN)
2052: SELECT hr_dm_phases_s.nextval,
2053: r_migration_data.migration_id,
2054: p_phase_name,
2055: 'NS',
2056: NULL,

Line 2065: (SELECT NULL FROM hr_dm_phases

2061: SYSDATE,
2062: NULL
2063: FROM dual
2064: WHERE NOT EXISTS
2065: (SELECT NULL FROM hr_dm_phases
2066: WHERE ((migration_id = r_migration_data.migration_id)
2067: AND (phase_name = p_phase_name)));
2068:
2069: COMMIT;