APPS.HR_DM_COPY dependencies on HR_DM_EXP_API_MODULES_V

Line 203: -- table into HR_DM_EXP_API_MODULES_V view based on

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
207: -- o Inserts the rows for the business_group_id being copied

Line 256: -- where API_MODULE_TYPE = 'DM' into HR_DM_EXP_API_MODULES_V.

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;
260: fetch csr_phase_rule into l_up_phase_used;

Line 264: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_api_modules_v',15);

260: fetch csr_phase_rule into l_up_phase_used;
261: close csr_phase_rule;
262:
263: if (l_up_phase_used = 'UP') then
264: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_api_modules_v',15);
265: insert into hr_dm_exp_api_modules_v (exp_imp_id
266: ,table_name
267: ,api_module_id
268: ,api_module_type

Line 265: insert into hr_dm_exp_api_modules_v (exp_imp_id

261: close csr_phase_rule;
262:
263: if (l_up_phase_used = 'UP') then
264: hr_dm_utility.message('INFO','Inserting row into hr_dm_exp_api_modules_v',15);
265: insert into hr_dm_exp_api_modules_v (exp_imp_id
266: ,table_name
267: ,api_module_id
268: ,api_module_type
269: ,module_name

Line 294: from hr_dm_exp_api_modules_v v

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);
296: end if;
297:
298:

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 1268: from hr_dm_exp_api_modules_v;

1264: ,last_updated_by
1265: ,last_update_login
1266: ,created_by
1267: ,to_date(creation_date,'YYYYMMDD HH24:MI:SS')
1268: from hr_dm_exp_api_modules_v;
1269:
1270:
1271: -- now re-enable constraint on HR_PUMP_BATCH_LINES
1272: hr_utility.trace('Enabling constraint - HR_PUMP_BATCH_LINES_FK2');