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 908: GHR_INTERFACE_ID,

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

Line 994: ghr_interface_s.nextval,

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

Line 1375: GHR_INTERFACE_ID,

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

Line 1409: ghr_interface_s.nextval,

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

Line 1588: GHR_INTERFACE_ID,

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

Line 1648: ghr_interface_s.nextval,

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

Line 1844: GHR_INTERFACE_ID,

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

Line 1945: ghr_interface_s.nextval,

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

Line 2269: GHR_INTERFACE_ID,

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

Line 2351: ghr_interface_s.nextval,

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

Line 2645: GHR_INTERFACE_ID,

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

Line 2708: ghr_interface_s.nextval,

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

Line 2964: GHR_INTERFACE_ID,

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

Line 3049: ghr_interface_s.nextval,

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

Line 3355: GHR_INTERFACE_ID,

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

Line 3408: ghr_interface_s.nextval,

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

Line 3606: GHR_INTERFACE_ID,

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

Line 3657: ghr_interface_s.nextval,

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

Line 3878: GHR_INTERFACE_ID,

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

Line 3902: ghr_interface_s.nextval,

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

Line 4180: delete ghr_interface

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