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_COPY dependencies on HR_API_MODULES

Line 202: -- o Insert the data migrator packages rows from HR_API_MODULES

198:
199: ----------------------- source_copy ---------------------------------
200: -- This procedure does some of the tasks of Copy phase in source
201: -- database. It does the following :
202: -- o Insert the data migrator packages rows from HR_API_MODULES
203: -- table into HR_DM_EXP_API_MODULES_V view based on
204: -- HR_DM_EXP_IMPS table.
205: -- o Insert the current migration row from HR_DM_MIGRATIONS tables
206: -- into HR_DM_EXP_MIGRATIONS_V view based on HR_DM_EXP_IMPS table

Line 255: -- insert data migrator packages rows from HR_API_MODULES i.e

251: hr_dm_utility.message('PARA','(p_migration_id - ' || p_migration_id ||
252: ')', 10);
253:
254:
255: -- insert data migrator packages rows from HR_API_MODULES i.e
256: -- where API_MODULE_TYPE = 'DM' into HR_DM_EXP_API_MODULES_V.
257: -- only when datapump will be used on the destination
258:
259: open csr_phase_rule;

Line 279: ,'HR_API_MODULES'

275: ,last_update_login
276: ,created_by
277: ,creation_date )
278: select hr_dm_exp_imps_s.nextval
279: ,'HR_API_MODULES'
280: ,api_module_id
281: ,api_module_type
282: ,module_name
283: ,data_within_business_group

Line 291: from hr_api_modules ai

287: ,last_updated_by
288: ,last_update_login
289: ,created_by
290: ,to_char(creation_date,'YYYYMMDD HH24:MI:SS')
291: from hr_api_modules ai
292: where api_module_type = 'DM'
293: and not exists (select null
294: from hr_dm_exp_api_modules_v v
295: where v.api_module_id = ai.api_module_id);

Line 1025: -- o Delete the data migrator packages rows from HR_API_MODULES table

1021: -- This procedure does some of the tasks of Copy phase in source
1022: -- database. It does the following :
1023: -- o Call procedure delete_datapump_tables to truncate datapump tables
1024: -- at destination.
1025: -- o Delete the data migrator packages rows from HR_API_MODULES table
1026: -- i.e API_MODULE_TYPE ='DM'.
1027: -- o Insert the rows into HR_API_MODULES tables from HR_DM_EXP_IMP table
1028: -- o Insert the row into HR_DM_MIGRATION table from HR_DM_EXP_IMP table
1029: -- o Inserts the rows for the business_group_id being copied

Line 1027: -- o Insert the rows into HR_API_MODULES tables from HR_DM_EXP_IMP table

1023: -- o Call procedure delete_datapump_tables to truncate datapump tables
1024: -- at destination.
1025: -- o Delete the data migrator packages rows from HR_API_MODULES table
1026: -- i.e API_MODULE_TYPE ='DM'.
1027: -- o Insert the rows into HR_API_MODULES tables from HR_DM_EXP_IMP table
1028: -- o Insert the row into HR_DM_MIGRATION table from HR_DM_EXP_IMP table
1029: -- o Inserts the rows for the business_group_id being copied
1030: -- from HR_DM_EXP_IMPS into HR_ALL_ORGANIZATION_UNITS,
1031: -- HR_ORGANIZATION_INFORMATION, HR_ALL_ORGANIZATION_UNITS_TL

Line 1223: -- so we can delete from HR_API_MODULES

1219: hr_utility.trace('(Errors may be seen if contraint does not exist).');
1220: hr_utility.trace(l_cr);
1221:
1222: -- disable constraint on HR_PUMP_BATCH_LINES
1223: -- so we can delete from HR_API_MODULES
1224: hr_utility.trace(' Disabling constraint - HR_PUMP_BATCH_LINES_FK2');
1225: begin
1226: execute immediate 'alter table ' || l_schema ||
1227: '.HR_PUMP_BATCH_LINES ' ||

Line 1236: hr_utility.trace(' Call delete hr_api_modules');

1232: hr_utility.trace(sqlerrm(sqlcode));
1233: end;
1234:
1235:
1236: hr_utility.trace(' Call delete hr_api_modules');
1237: -- delete data migrator packages rows from HR_API_MODULES.
1238: delete hr_api_modules
1239: where api_module_type = 'DM';
1240:

Line 1237: -- delete data migrator packages rows from HR_API_MODULES.

1233: end;
1234:
1235:
1236: hr_utility.trace(' Call delete hr_api_modules');
1237: -- delete data migrator packages rows from HR_API_MODULES.
1238: delete hr_api_modules
1239: where api_module_type = 'DM';
1240:
1241:

Line 1238: delete hr_api_modules

1234:
1235:
1236: hr_utility.trace(' Call delete hr_api_modules');
1237: -- delete data migrator packages rows from HR_API_MODULES.
1238: delete hr_api_modules
1239: where api_module_type = 'DM';
1240:
1241:
1242: hr_utility.trace(' Updating hr_api_modules');

Line 1242: hr_utility.trace(' Updating hr_api_modules');

1238: delete hr_api_modules
1239: where api_module_type = 'DM';
1240:
1241:
1242: hr_utility.trace(' Updating hr_api_modules');
1243: -- Insert the rows into HR_API_MODULES tables from HR_DM_EXP_API_MODULES_V
1244: -- table.
1245:
1246: insert into hr_api_modules ( api_module_id

Line 1243: -- Insert the rows into HR_API_MODULES tables from HR_DM_EXP_API_MODULES_V

1239: where api_module_type = 'DM';
1240:
1241:
1242: hr_utility.trace(' Updating hr_api_modules');
1243: -- Insert the rows into HR_API_MODULES tables from HR_DM_EXP_API_MODULES_V
1244: -- table.
1245:
1246: insert into hr_api_modules ( api_module_id
1247: ,api_module_type

Line 1246: insert into hr_api_modules ( api_module_id

1242: hr_utility.trace(' Updating hr_api_modules');
1243: -- Insert the rows into HR_API_MODULES tables from HR_DM_EXP_API_MODULES_V
1244: -- table.
1245:
1246: insert into hr_api_modules ( api_module_id
1247: ,api_module_type
1248: ,module_name
1249: ,data_within_business_group
1250: ,legislation_code