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.GHR_MTO_INT dependencies on GHR_INTERFACE

Line 60: from ghr_interface

56: -- row regardless of the contact name. We want to have only one
57: -- contact address.
58: cursor cur_ck_unique is
59: select count(*)
60: from ghr_interface
61: where information4 = p_table_name -- mt_table_name
62: and information1 = p_transfer_name -- mt_name
63: and information3 = to_char(p_person_id) -- mt_person_id
64: and nvl(information5,'null') = nvl(p_info_type,'null')

Line 375: ghr_interface_id,

371: put_line(' - called locally');
372: end if;
373:
374: insert into ghr_mt_people_f_v (
375: ghr_interface_id,
376: MT_PROCESS_DATE, MT_SOURCE, MT_EFFECTIVE_DATE,
377: MT_NAME, MT_STATUS, MT_PERSON_ID,
378: MT_TABLE_NAME, MT_INFORMATION_TYPE,
379: MT_INTER_BG_TRANSFER, PERSON_ID,

Line 421: ghr_interface_s.nextval,

417: PER_INFORMATION29, PER_INFORMATION30, OBJECT_VERSION_NUMBER,
418: DATE_OF_DEATH, REHIRE_REASON
419: )
420: values (
421: ghr_interface_s.nextval,
422: sysdate,
423: l_name,
424: p_effective_date,
425: p_transfer_name,

Line 909: GHR_INTERFACE_ID,

905:
906: end if;
907:
908: insert into ghr_mt_people_ei_v (
909: GHR_INTERFACE_ID,
910: MT_PROCESS_DATE,
911: MT_SOURCE,
912: MT_EFFECTIVE_DATE,
913: MT_NAME,

Line 995: ghr_interface_s.nextval,

991: info10_meaning,
992: info11_meaning
993: )
994: values (
995: ghr_interface_s.nextval,
996: sysdate,
997: l_name,
998: p_effective_date,
999: p_transfer_name,

Line 1376: GHR_INTERFACE_ID,

1372: end if;
1373:
1374:
1375: insert into ghr_mt_analysis_criteria_v (
1376: GHR_INTERFACE_ID,
1377: MT_PROCESS_DATE,
1378: MT_SOURCE,
1379: MT_EFFECTIVE_DATE,
1380: MT_NAME,

Line 1410: ghr_interface_s.nextval,

1406: segment1_meaning,
1407: segment2_meaning
1408: )
1409: values (
1410: ghr_interface_s.nextval,
1411: sysdate,
1412: l_name,
1413: p_effective_date,
1414: p_transfer_name,

Line 1589: GHR_INTERFACE_ID,

1585: put_line(' - called locally');
1586: end if;
1587:
1588: insert into ghr_mt_addresses_v (
1589: GHR_INTERFACE_ID,
1590: MT_PROCESS_DATE,
1591: MT_SOURCE,
1592: MT_EFFECTIVE_DATE,
1593: MT_NAME,

Line 1649: ghr_interface_s.nextval,

1645: ADDR_ATTRIBUTE19,
1646: ADDR_ATTRIBUTE20
1647: )
1648: values (
1649: ghr_interface_s.nextval,
1650: sysdate,
1651: l_name,
1652: p_effective_date,
1653: p_transfer_name,

Line 1845: GHR_INTERFACE_ID,

1841: end if;
1842:
1843:
1844: insert into ghr_mt_assignments_f_v (
1845: GHR_INTERFACE_ID,
1846: MT_PROCESS_DATE,
1847: MT_SOURCE,
1848: MT_EFFECTIVE_DATE,
1849: MT_NAME,

Line 1946: ghr_interface_s.nextval,

1942: TITLE,
1943: OBJECT_VERSION_NUMBER
1944: )
1945: values (
1946: ghr_interface_s.nextval,
1947: sysdate,
1948: l_name,
1949: p_effective_date,
1950: p_transfer_name,

Line 2270: GHR_INTERFACE_ID,

2266: end if;
2267:
2268:
2269: insert into ghr_mt_assignment_ei_v (
2270: GHR_INTERFACE_ID,
2271: MT_PROCESS_DATE,
2272: MT_SOURCE,
2273: MT_EFFECTIVE_DATE,
2274: MT_NAME,

Line 2352: ghr_interface_s.nextval,

2348: info7_meaning,
2349: info8_meaning
2350: )
2351: values (
2352: ghr_interface_s.nextval,
2353: sysdate,
2354: l_name,
2355: p_effective_date,
2356: p_transfer_name,

Line 2646: GHR_INTERFACE_ID,

2642: put_line(' - called locally');
2643: end if;
2644:
2645: insert into ghr_mt_positions_v (
2646: GHR_INTERFACE_ID,
2647: MT_PROCESS_DATE,
2648: MT_SOURCE,
2649: MT_EFFECTIVE_DATE,
2650: MT_NAME,

Line 2709: ghr_interface_s.nextval,

2705: CREATION_DATE,
2706: STATUS
2707: )
2708: values (
2709: ghr_interface_s.nextval,
2710: sysdate,
2711: l_name,
2712: p_effective_date,
2713: p_transfer_name,

Line 2965: GHR_INTERFACE_ID,

2961: end if;
2962:
2963:
2964: insert into ghr_mt_position_ei_v (
2965: GHR_INTERFACE_ID,
2966: MT_PROCESS_DATE,
2967: MT_SOURCE,
2968: MT_EFFECTIVE_DATE,
2969: MT_NAME,

Line 3050: ghr_interface_s.nextval,

3046: info14_meaning,
3047: info16_meaning
3048: )
3049: values (
3050: ghr_interface_s.nextval,
3051: sysdate,
3052: l_name,
3053: p_effective_date,
3054: p_transfer_name,

Line 3356: GHR_INTERFACE_ID,

3352: put_line('Called locally');
3353: end if;
3354:
3355: insert into ghr_mt_position_definitions_v (
3356: GHR_INTERFACE_ID,
3357: MT_PROCESS_DATE,
3358: MT_SOURCE,
3359: MT_EFFECTIVE_DATE,
3360: MT_NAME,

Line 3409: ghr_interface_s.nextval,

3405: CREATED_BY,
3406: CREATION_DATE
3407: )
3408: values (
3409: ghr_interface_s.nextval,
3410: sysdate,
3411: l_name,
3412: p_effective_date,
3413: p_transfer_name,

Line 3607: GHR_INTERFACE_ID,

3603: p_lookup_type => 'GHR_US_RETIREMENT_PLAN',
3604: p_lookup_code => p_element.retirement_plan);
3605:
3606: insert into ghr_mt_element_entries_v (
3607: GHR_INTERFACE_ID,
3608: MT_PROCESS_DATE,
3609: MT_SOURCE,
3610: MT_EFFECTIVE_DATE,
3611: MT_NAME,

Line 3658: ghr_interface_s.nextval,

3654: TO_ADJUSTED_BASIC_PAY,
3655: TO_TOTAL_SALARY
3656: )
3657: values (
3658: ghr_interface_s.nextval,
3659: sysdate,
3660: l_name,
3661: p_effective_date,
3662: p_transfer_name,

Line 3879: GHR_INTERFACE_ID,

3875: p_lookup_type => 'GHR_US_AGENCY_CODE',
3876: p_lookup_code => p_misc.from_agency_code);
3877:
3878: insert into ghr_mt_misc_v (
3879: GHR_INTERFACE_ID,
3880: MT_PROCESS_DATE,
3881: MT_SOURCE,
3882: MT_EFFECTIVE_DATE,
3883: MT_NAME,

Line 3903: ghr_interface_s.nextval,

3899: DUTY_STATION_CODE,
3900: FROM_AGENCY_CODE_DESC
3901: )
3902: values (
3903: ghr_interface_s.nextval,
3904: sysdate,
3905: l_name,
3906: p_effective_date,
3907: p_transfer_name,

Line 4181: delete ghr_interface

4177: put_line('------------------------------------------');
4178: put_line('Person '||p_person_id||', found in table');
4179: put_line('------------------------------------------');
4180:
4181: delete ghr_interface
4182: where information1 = l_transfer_name
4183: and information3 = to_char(p_person_id);
4184: end if;
4185: