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_ALL_ORGANIZATION_UNITS

Line 208: -- from HR_ALL_ORGANIZATION_UNITS, HR_ORGANIZATION_INFORMATION,

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

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 649: 'HR_ALL_ORGANIZATION_UNITS',

645: CREATED_BY,
646: CREATION_DATE)
647: select
648: hr_dm_exp_imps_s.nextval,
649: 'HR_ALL_ORGANIZATION_UNITS',
650: ORGANIZATION_ID,
651: BUSINESS_GROUP_ID,
652: COST_ALLOCATION_KEYFLEX_ID,
653: LOCATION_ID,

Line 691: from HR_ALL_ORGANIZATION_UNITS

687: last_updated_by,
688: last_update_login,
689: created_by,
690: to_char(creation_date,'YYYYMMDD HH24:MI:SS')
691: from HR_ALL_ORGANIZATION_UNITS
692: where BUSINESS_GROUP_ID = l_business_group_id;
693:
694: -- remove entries for HR_ALL_ORGANIZATION_UNITS in the table hr_pump_batch lines
695: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table

Line 694: -- remove entries for HR_ALL_ORGANIZATION_UNITS in the table hr_pump_batch lines

690: to_char(creation_date,'YYYYMMDD HH24:MI:SS')
691: from HR_ALL_ORGANIZATION_UNITS
692: where BUSINESS_GROUP_ID = l_business_group_id;
693:
694: -- remove entries for HR_ALL_ORGANIZATION_UNITS in the table hr_pump_batch lines
695: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
696: -- Note that the view already matches the where clause
697: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);
698: -- use dynamic sql to avoid compiliation errors where the data pump views

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

693:
694: -- remove entries for HR_ALL_ORGANIZATION_UNITS in the table hr_pump_batch lines
695: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
696: -- Note that the view already matches the where clause
697: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);
698: -- use dynamic sql to avoid compiliation errors where the data pump views
699: -- have not yet been created
700: execute immediate 'delete HRDPV_UHR_ALL_ORGANIZATONUNITS';
701:

Line 818: from HR_ALL_ORGANIZATION_UNITS

814: to_char(creation_date,'YYYYMMDD HH24:MI:SS')
815: from HR_ORGANIZATION_INFORMATION
816: where ORGANIZATION_ID in (
817: select ORGANIZATION_ID
818: from HR_ALL_ORGANIZATION_UNITS
819: where BUSINESS_GROUP_ID = l_business_group_id);
820:
821: -- remove entries for HR_ORGANIZATION_INFORMATION in the table hr_pump_batch lines
822: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table

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

819: where BUSINESS_GROUP_ID = l_business_group_id);
820:
821: -- remove entries for HR_ORGANIZATION_INFORMATION in the table hr_pump_batch lines
822: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
823: hr_dm_utility.message('INFO','Removing HR_ALL_ORGANIZATION_UNITS rows from hr_pump_batch_lines',15);
824: -- use dynamic sql to avoid compiliation errors where the data pump views
825: -- have not yet been created
826: execute immediate 'delete HRDPV_UHR_ORGANIZATNINFORMATON ' ||
827: ' where p_ORGANIZATION_ID in ( ' ||

Line 829: ' from HR_ALL_ORGANIZATION_UNITS ' ||

825: -- have not yet been created
826: execute immediate 'delete HRDPV_UHR_ORGANIZATNINFORMATON ' ||
827: ' where p_ORGANIZATION_ID in ( ' ||
828: ' select to_char(ORGANIZATION_ID) ' ||
829: ' from HR_ALL_ORGANIZATION_UNITS ' ||
830: ' where BUSINESS_GROUP_ID = ' ||
831: l_business_group_id || ')';
832:
833: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_TL_V',15);

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 861: from HR_ALL_ORGANIZATION_UNITS

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

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 872: ' from HR_ALL_ORGANIZATION_UNITS ' ||

868: -- have not yet been created
869: execute immediate 'delete HRDPV_UHR_ALL_ORGANZTNUNITS_TL ' ||
870: ' where p_ORGANIZATION_ID in ( ' ||
871: ' select to_char(ORGANIZATION_ID) ' ||
872: ' from HR_ALL_ORGANIZATION_UNITS ' ||
873: ' where BUSINESS_GROUP_ID = ' ||
874: l_business_group_id || ')';
875:
876: end if;

Line 1030: -- from HR_DM_EXP_IMPS into HR_ALL_ORGANIZATION_UNITS,

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

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 1547: insert into HR_ALL_ORGANIZATION_UNITS (

1543:
1544:
1545:
1546: -- the comments column has been removed
1547: insert into HR_ALL_ORGANIZATION_UNITS (
1548: ORGANIZATION_ID,
1549: BUSINESS_GROUP_ID,
1550: COST_ALLOCATION_KEYFLEX_ID,
1551: LOCATION_ID,

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,