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_LOCATIONS_ALL

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 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 450: 'HR_LOCATIONS_ALL',

446: ECE_TP_LOCATION_CODE,
447: OBJECT_VERSION_NUMBER)
448: select
449: hr_dm_exp_imps_s.nextval,
450: 'HR_LOCATIONS_ALL',
451: LOCATION_ID,
452: LOCATION_CODE,
453: BUSINESS_GROUP_ID,
454: DESCRIPTION,

Line 534: from HR_LOCATIONS_ALL

530: ENTERED_BY,
531: TP_HEADER_ID,
532: ECE_TP_LOCATION_CODE,
533: OBJECT_VERSION_NUMBER
534: from HR_LOCATIONS_ALL
535: where BUSINESS_GROUP_ID = l_business_group_id
536: or BUSINESS_GROUP_ID is null;
537:
538: -- remove entries for HR_LOCATIONS_ALL in the table hr_pump_batch lines

Line 538: -- remove entries for HR_LOCATIONS_ALL in the table hr_pump_batch lines

534: from HR_LOCATIONS_ALL
535: where BUSINESS_GROUP_ID = l_business_group_id
536: or BUSINESS_GROUP_ID is null;
537:
538: -- remove entries for HR_LOCATIONS_ALL in the table hr_pump_batch lines
539: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
540: -- Note that the view already matches the where clause
541: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL rows from hr_pump_batch_lines',15);
542: -- use dynamic sql to avoid compiliation errors where the data pump views

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

537:
538: -- remove entries for HR_LOCATIONS_ALL in the table hr_pump_batch lines
539: -- that match the where clause used to migrate via HR_DM_EXP_IMPS table
540: -- Note that the view already matches the where clause
541: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL rows from hr_pump_batch_lines',15);
542: -- use dynamic sql to avoid compiliation errors where the data pump views
543: -- have not yet been created
544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';
545:

Line 544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';

540: -- Note that the view already matches the where clause
541: hr_dm_utility.message('INFO','Removing HR_LOCATIONS_ALL rows from hr_pump_batch_lines',15);
542: -- use dynamic sql to avoid compiliation errors where the data pump views
543: -- have not yet been created
544: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL';
545:
546: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_HR_LOC_ALL_TL_V',15);
547: insert into HR_DM_EXP_HR_LOC_ALL_TL_V (
548: EXP_IMP_ID,

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 576: from HR_LOCATIONS_ALL

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)
578: or LOCATION_ID in (
579: select LOCATION_ID
580: from HR_LOCATIONS_ALL

Line 580: from HR_LOCATIONS_ALL

576: from HR_LOCATIONS_ALL
577: where BUSINESS_GROUP_ID = l_business_group_id)
578: or LOCATION_ID in (
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

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 591: ' from HR_LOCATIONS_ALL ' ||

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 = ' ||
593: l_business_group_id || ')';
594: execute immediate 'delete HRDPV_UHR_LOCATIONS_ALL_TL ' ||
595: 'where p_LOCATION_ID in ( ' ||

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 597: ' from HR_LOCATIONS_ALL ' ||

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' || ')';
599:
600:
601: hr_dm_utility.message('INFO','Inserting row(s) into HR_DM_EXP_ALL_ORG_UNITS_V',15);

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 1343: insert into HR_LOCATIONS_ALL (

1339: if (l_migration_type = 'FW') then
1340:
1341: hr_utility.trace('Creating business group.');
1342:
1343: insert into HR_LOCATIONS_ALL (
1344: LOCATION_ID,
1345: LOCATION_CODE,
1346: BUSINESS_GROUP_ID,
1347: DESCRIPTION,

Line 1513: from HR_LOCATIONS_ALL tb

1509: ECE_TP_LOCATION_CODE,
1510: OBJECT_VERSION_NUMBER
1511: from HR_DM_EXP_HR_LOC_ALL_V dmv
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,

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: