APPS.HR_DM_COPY dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 209: -- HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL and

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

Line 848: 'HR_ALL_ORGANIZATION_UNITS_TL',

844: CREATED_BY,
845: CREATION_DATE)
846: select
847: hr_dm_exp_imps_s.nextval,
848: 'HR_ALL_ORGANIZATION_UNITS_TL',
849: ORGANIZATION_ID,
850: LANGUAGE,
851: SOURCE_LANG,
852: NAME,

Line 858: from HR_ALL_ORGANIZATION_UNITS_TL

854: last_updated_by,
855: last_update_login,
856: created_by,
857: to_char(creation_date,'YYYYMMDD HH24:MI:SS')
858: from HR_ALL_ORGANIZATION_UNITS_TL
859: where ORGANIZATION_ID in (
860: select ORGANIZATION_ID
861: from HR_ALL_ORGANIZATION_UNITS
862: where BUSINESS_GROUP_ID = l_business_group_id);

Line 864: -- remove entries for HR_ALL_ORGANIZATION_UNITS_TL in the table hr_pump_batch lines

860: select ORGANIZATION_ID
861: from HR_ALL_ORGANIZATION_UNITS
862: where BUSINESS_GROUP_ID = l_business_group_id);
863:
864: -- remove entries for HR_ALL_ORGANIZATION_UNITS_TL in the table hr_pump_batch lines
865: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
866: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS_TL rows from hr_pump_batch_lines',15);
867: -- use dynamic sql to avoid compiliation errors where the data pump views
868: -- have not yet been created

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

862: where BUSINESS_GROUP_ID = l_business_group_id);
863:
864: -- remove entries for HR_ALL_ORGANIZATION_UNITS_TL in the table hr_pump_batch lines
865: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
866: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS_TL rows from hr_pump_batch_lines',15);
867: -- use dynamic sql to avoid compiliation errors where the data pump views
868: -- have not yet been created
869: execute immediate 'delete HRDPV_UHR_ALL_ORGANZTNUNITS_TL ' ||
870: ' where p_ORGANIZATION_ID in ( ' ||

Line 1031: -- HR_ORGANIZATION_INFORMATION, HR_ALL_ORGANIZATION_UNITS_TL

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
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)

Line 1743: insert into HR_ALL_ORGANIZATION_UNITS_TL (

1739: created_by,
1740: to_date(creation_date,'YYYYMMDD HH24:MI:SS')
1741: from HR_DM_EXP_ORG_INFO_V;
1742:
1743: insert into HR_ALL_ORGANIZATION_UNITS_TL (
1744: ORGANIZATION_ID,
1745: LANGUAGE,
1746: SOURCE_LANG,
1747: NAME,