APPS.HR_DM_COPY dependencies on HR_LOCATIONS_ALL_TL

Line 210: -- HR_LOCATIONS_ALL_TL into HR_DM_EXP_IMPS for a FW migration

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
208: -- from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION,
209: -- HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL and
210: -- HR_LOCATIONS_ALL_TL into HR_DM_EXP_IMPS for a FW migration
211: -- o Copy the values for the ID_FLEX_STRUCTURE_NAME from the table
212: -- HR_ORGANIZATION_INFORMATION into HR_DM_EXP_IMPS for a FW migration
213: -- Input Parameters :
214: -- p_migration_id - Migration Id of the current migration. Primary

Line 562: 'HR_LOCATIONS_ALL_TL',

558: CREATED_BY,
559: CREATION_DATE)
560: select
561: hr_dm_exp_imps_s.nextval,
562: 'HR_LOCATIONS_ALL_TL',
563: LOCATION_ID,
564: LANGUAGE,
565: SOURCE_LANG,
566: LOCATION_CODE,

Line 573: from HR_LOCATIONS_ALL_TL

569: LAST_UPDATED_BY,
570: LAST_UPDATE_LOGIN,
571: CREATED_BY,
572: to_char(creation_date,'YYYYMMDD HH24:MI:SS')
573: from HR_LOCATIONS_ALL_TL
574: where LOCATION_ID in (
575: select LOCATION_ID
576: from HR_LOCATIONS_ALL
577: where BUSINESS_GROUP_ID = l_business_group_id)

Line 583: -- remove entries for HR_LOCATIONS_ALL_TL in the table hr_pump_batch lines

579: select LOCATION_ID
580: from HR_LOCATIONS_ALL
581: where BUSINESS_GROUP_ID is null);
582:
583: -- remove entries for HR_LOCATIONS_ALL_TL in the table hr_pump_batch lines
584: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
585: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL_TL rows from hr_pump_batch_lines',15);
586: -- use dynamic sql to avoid compiliation errors where the data pump views
587: -- have not yet been created

Line 585: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL_TL rows from hr_pump_batch_lines',15);

581: where BUSINESS_GROUP_ID is null);
582:
583: -- remove entries for HR_LOCATIONS_ALL_TL in the table hr_pump_batch lines
584: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
585: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL_TL rows from hr_pump_batch_lines',15);
586: -- use dynamic sql to avoid compiliation errors where the data pump views
587: -- have not yet been created
588: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
589: 'where p_LOCATION_ID in ( ' ||

Line 588: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||

584: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
585: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL_TL rows from hr_pump_batch_lines',15);
586: -- use dynamic sql to avoid compiliation errors where the data pump views
587: -- have not yet been created
588: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
589: 'where p_LOCATION_ID in ( ' ||
590: ' select to_char(LOCATION_ID) ' ||
591: ' from HR_LOCATIONS_ALL ' ||
592: ' where BUSINESS_GROUP_ID = ' ||

Line 594: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||

590: ' select to_char(LOCATION_ID) ' ||
591: ' from HR_LOCATIONS_ALL ' ||
592: ' where BUSINESS_GROUP_ID = ' ||
593: l_business_group_id || ')';
594: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
595: 'where p_LOCATION_ID in ( ' ||
596: ' select to_char(LOCATION_ID) ' ||
597: ' from HR_LOCATIONS_ALL ' ||
598: ' where BUSINESS_GROUP_ID is null' || ')';

Line 1032: -- HR_LOCATIONS_ALL and HR_LOCATIONS_ALL_TL

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
1032: -- HR_LOCATIONS_ALL and HR_LOCATIONS_ALL_TL
1033: -- (for an FW migration only)
1034: -- o Update the row in the HR_DM_MIGRATIONS table to show that the business
1035: -- group has been created (for an FW migration only)
1036: -- Called By : Run manually.

Line 1516: insert into HR_LOCATIONS_ALL_TL (

1512: where not exists (select null
1513: from HR_LOCATIONS_ALL tb
1514: where dmv.location_id = tb.LOCATION_ID);
1515:
1516: insert into HR_LOCATIONS_ALL_TL (
1517: LOCATION_ID,
1518: LANGUAGE,
1519: SOURCE_LANG,
1520: LOCATION_CODE,

Line 1540: from HR_LOCATIONS_ALL_TL tb

1536: CREATED_BY,
1537: to_date(creation_date,'YYYYMMDD HH24:MI:SS')
1538: from HR_DM_EXP_HR_LOC_ALL_TL_V dmv
1539: where not exists (select null
1540: from HR_LOCATIONS_ALL_TL tb
1541: where dmv.location_id = tb.LOCATION_ID);
1542:
1543:
1544: