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_ORGANIZATION_INFORMATION

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 212: -- HR_ORGANIZATION_INFORMATION into HR_DM_EXP_IMPS for a FW migration

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
215: -- key on hr_dm_migrations table.
216: -- p_last_migration_date - last migration date

Line 761: 'HR_ORGANIZATION_INFORMATION',

757: CREATED_BY,
758: CREATION_DATE)
759: select
760: hr_dm_exp_imps_s.nextval,
761: 'HR_ORGANIZATION_INFORMATION',
762: ORG_INFORMATION_ID,
763: ORG_INFORMATION_CONTEXT,
764: ORGANIZATION_ID,
765: ORG_INFORMATION1,

Line 815: from HR_ORGANIZATION_INFORMATION

811: last_updated_by,
812: last_update_login,
813: created_by,
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);

Line 821: -- remove entries for HR_ORGANIZATION_INFORMATION in the table hr_pump_batch lines

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

Line 890: from hr_organization_information

886: select ID_FLEX_STRUCTURE_NAME
887: into l_org_information4
888: from fnd_id_flex_structures_vl
889: where id_flex_num = (select org_information4
890: from hr_organization_information
891: where org_information_context =
892: 'Business Group Information'
893: and organization_id = l_business_group_id)
894: and ID_FLEX_CODE = 'GRD';

Line 899: from hr_organization_information

895: select ID_FLEX_STRUCTURE_NAME
896: into l_org_information5
897: from fnd_id_flex_structures_vl
898: where id_flex_num = (select org_information5
899: from hr_organization_information
900: where org_information_context =
901: 'Business Group Information'
902: and organization_id = l_business_group_id)
903: and ID_FLEX_CODE = 'GRP';

Line 908: from hr_organization_information

904: select ID_FLEX_STRUCTURE_NAME
905: into l_org_information6
906: from fnd_id_flex_structures_vl
907: where id_flex_num = (select org_information6
908: from hr_organization_information
909: where org_information_context =
910: 'Business Group Information'
911: and organization_id = l_business_group_id)
912: and ID_FLEX_CODE = 'JOB';

Line 917: from hr_organization_information

913: select ID_FLEX_STRUCTURE_NAME
914: into l_org_information7
915: from fnd_id_flex_structures_vl
916: where id_flex_num = (select org_information7
917: from hr_organization_information
918: where org_information_context =
919: 'Business Group Information'
920: and organization_id = l_business_group_id)
921: and ID_FLEX_CODE = 'COST';

Line 926: from hr_organization_information

922: select ID_FLEX_STRUCTURE_NAME
923: into l_org_information8
924: from fnd_id_flex_structures_vl
925: where id_flex_num = (select org_information8
926: from hr_organization_information
927: where org_information_context =
928: 'Business Group Information'
929: and organization_id = l_business_group_id)
930: and ID_FLEX_CODE = 'POS';

Line 935: from hr_organization_information

931: select SECURITY_GROUP_KEY
932: into l_org_information14
933: from fnd_security_groups_vl
934: where security_group_id = (select org_information14
935: from hr_organization_information
936: where org_information_context =
937: 'Business Group Information'
938: and organization_id = l_business_group_id);
939:

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 1633: insert into HR_ORGANIZATION_INFORMATION (

1629: created_by,
1630: to_date(creation_date,'YYYYMMDD HH24:MI:SS')
1631: from HR_DM_EXP_ALL_ORG_UNITS_V;
1632:
1633: insert into HR_ORGANIZATION_INFORMATION (
1634: ORG_INFORMATION_ID,
1635: ORG_INFORMATION_CONTEXT,
1636: ORGANIZATION_ID,
1637: ORG_INFORMATION1,