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_DELTA_SYNC_MESSAGES dependencies on HR_LOCATIONS_ALL

Line 504: p_bg_id hr_locations_all.business_group_id%type;

500:
501: is
502:
503:
504: p_bg_id hr_locations_all.business_group_id%type;
505: p_loc_id hr_locations_all.LOCATION_ID%type;
506: p_active_date date;
507: p_effecive_status varchar2(10);
508: p_loc_code hr_locations_all.LOCATION_CODE%type;

Line 505: p_loc_id hr_locations_all.LOCATION_ID%type;

501: is
502:
503:
504: p_bg_id hr_locations_all.business_group_id%type;
505: p_loc_id hr_locations_all.LOCATION_ID%type;
506: p_active_date date;
507: p_effecive_status varchar2(10);
508: p_loc_code hr_locations_all.LOCATION_CODE%type;
509: p_loc_desc hr_locations_all.DESCRIPTION%type;

Line 508: p_loc_code hr_locations_all.LOCATION_CODE%type;

504: p_bg_id hr_locations_all.business_group_id%type;
505: p_loc_id hr_locations_all.LOCATION_ID%type;
506: p_active_date date;
507: p_effecive_status varchar2(10);
508: p_loc_code hr_locations_all.LOCATION_CODE%type;
509: p_loc_desc hr_locations_all.DESCRIPTION%type;
510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;

Line 509: p_loc_desc hr_locations_all.DESCRIPTION%type;

505: p_loc_id hr_locations_all.LOCATION_ID%type;
506: p_active_date date;
507: p_effecive_status varchar2(10);
508: p_loc_code hr_locations_all.LOCATION_CODE%type;
509: p_loc_desc hr_locations_all.DESCRIPTION%type;
510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

Line 510: p_loc_style hr_locations_all.STYLE%type;

506: p_active_date date;
507: p_effecive_status varchar2(10);
508: p_loc_code hr_locations_all.LOCATION_CODE%type;
509: p_loc_desc hr_locations_all.DESCRIPTION%type;
510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

Line 511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;

507: p_effecive_status varchar2(10);
508: p_loc_code hr_locations_all.LOCATION_CODE%type;
509: p_loc_desc hr_locations_all.DESCRIPTION%type;
510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;

Line 512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;

508: p_loc_code hr_locations_all.LOCATION_CODE%type;
509: p_loc_desc hr_locations_all.DESCRIPTION%type;
510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;

Line 513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;

509: p_loc_desc hr_locations_all.DESCRIPTION%type;
510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;

Line 514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;

510: p_loc_style hr_locations_all.STYLE%type;
511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;

Line 515: p_country hr_locations_all.COUNTRY%type;

511: p_add_line_1 hr_locations_all.ADDRESS_LINE_1%type;
512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;

Line 516: p_postal_code hr_locations_all.POSTAL_CODE%type;

512: p_add_line_2 hr_locations_all.ADDRESS_LINE_2%type;
513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

Line 517: p_region_1 hr_locations_all.REGION_1%type;

513: p_add_line_3 hr_locations_all.ADDRESS_LINE_3%type;
514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

Line 518: p_region_2 hr_locations_all.REGION_2%type;

514: p_town_or_city hr_locations_all.TOWN_OR_CITY%type;
515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

Line 519: p_region_3 hr_locations_all.REGION_3%type;

515: p_country hr_locations_all.COUNTRY%type;
516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

Line 520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;

516: p_postal_code hr_locations_all.POSTAL_CODE%type;
517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

Line 521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;

517: p_region_1 hr_locations_all.REGION_1%type;
518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

Line 522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;

518: p_region_2 hr_locations_all.REGION_2%type;
519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

Line 523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;

519: p_region_3 hr_locations_all.REGION_3%type;
520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

Line 524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;

520: p_tel_no_1 hr_locations_all.TELEPHONE_NUMBER_1%type;
521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

Line 525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;

521: p_tel_no_2 hr_locations_all.TELEPHONE_NUMBER_2%type;
522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

Line 526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;

522: p_tel_no_3 hr_locations_all.TELEPHONE_NUMBER_3%type;
523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

Line 527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;

523: p_loc_info_13 hr_locations_all.LOC_INFORMATION13%type;
524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
531: p_effective_date date default sysdate;

Line 528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;

524: p_loc_info_14 hr_locations_all.LOC_INFORMATION14%type;
525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
531: p_effective_date date default sysdate;
532: l_params WF_PARAMETER_LIST_T;

Line 529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;

525: p_loc_info_15 hr_locations_all.LOC_INFORMATION15%type;
526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
531: p_effective_date date default sysdate;
532: l_params WF_PARAMETER_LIST_T;
533: p_unique_key number;

Line 530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;

526: p_loc_info_16 hr_locations_all.LOC_INFORMATION16%type;
527: p_loc_info_17 hr_locations_all.LOC_INFORMATION17%type;
528: p_loc_info_18 hr_locations_all.LOC_INFORMATION18%type;
529: p_loc_info_19 hr_locations_all.LOC_INFORMATION19%type;
530: p_loc_info_20 hr_locations_all.LOC_INFORMATION20%type;
531: p_effective_date date default sysdate;
532: l_params WF_PARAMETER_LIST_T;
533: p_unique_key number;
534: p_last_update_date date;

Line 600: hr_locations_all loc

596: LOC_INFORMATION20,
597: last_update_date
598:
599: from
600: hr_locations_all loc
601: where last_update_date > p_max_run_date
602: and (loc.location_id,loc.business_group_id)not in(
603: select sync.location_id,sync.business_group_id
604: from hr_locn_delta_sync sync

Line 655: hr_locations_all loc

651: LOC_INFORMATION20,
652: last_update_date
653:
654: from
655: hr_locations_all loc
656: where LOC.location_id = p_location_id
657: and nvl(LOC.business_group_id,0) = nvl(p_business_group_id,0);
658:
659: p_cntry_delta_sts varchar2(10);