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.PQP_HRTCA_INTEGRATION dependencies on PER_PEOPLE_EXTRA_INFO

Line 188: ,p_extra_info_rec IN OUT NOCOPY per_people_extra_info%ROWTYPE

184: (p_person_id IN Number
185: ,p_business_group_id IN Number
186: ,p_validate IN Boolean DEFAULT FALSE
187: ,p_action IN Varchar2
188: ,p_extra_info_rec IN OUT NOCOPY per_people_extra_info%ROWTYPE
189: ) IS
190:
191: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'InsUpd_Per_Extra_info';
192: l_error_msg Varchar2(2000);

Line 677: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE

673: PROCEDURE InsUpd_OSS_PassPort
674: (p_person_id IN Number
675: ,p_party_id IN Number
676: ,p_action IN Varchar2
677: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
678: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
679: ) AS
680:
681: TYPE csr_pp_t IS REF CURSOR;

Line 678: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE

674: (p_person_id IN Number
675: ,p_party_id IN Number
676: ,p_action IN Varchar2
677: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
678: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
679: ) AS
680:
681: TYPE csr_pp_t IS REF CURSOR;
682: csr_pp csr_pp_t;

Line 943: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE

939: PROCEDURE InsUpd_OSS_Visa
940: (p_person_id IN Number
941: ,p_party_id IN Number
942: ,p_action IN Varchar2
943: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
944: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
945: ) AS
946:
947: TYPE csr_visa_t IS REF CURSOR;

Line 944: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE

940: (p_person_id IN Number
941: ,p_party_id IN Number
942: ,p_action IN Varchar2
943: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
944: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
945: ) AS
946:
947: TYPE csr_visa_t IS REF CURSOR;
948: csr_visa csr_visa_t;

Line 1234: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE

1230: PROCEDURE InsUpd_OSS_VisitHistory
1231: (p_person_id IN Number
1232: ,p_party_id IN Number
1233: ,p_action IN Varchar2
1234: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
1235: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
1236: ) AS
1237:
1238: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_OSS_VistHistory';

Line 1235: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE

1231: (p_person_id IN Number
1232: ,p_party_id IN Number
1233: ,p_action IN Varchar2
1234: ,p_pei_info_rec_old IN per_people_extra_info%ROWTYPE
1235: ,p_pei_info_rec_new IN per_people_extra_info%ROWTYPE
1236: ) AS
1237:
1238: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_OSS_VistHistory';
1239: l_oss_vvhist_rec_old Visit_Hist_Rec;

Line 1551: FROM per_people_extra_info pei

1547: ,pei.pei_information7
1548: ,pei.pei_information8
1549: ,pei.object_version_number
1550: ,pei.person_extra_info_id
1551: FROM per_people_extra_info pei
1552: WHERE pei.person_id = c_person_id
1553: AND pei.information_type ='PER_US_PASSPORT_DETAILS'
1554: AND pei.pei_information5 = c_pp_cntry_code
1555: AND pei.pei_information6 = c_pp_number ;

Line 1563: l_passport_category per_people_extra_info.information_type%TYPE;

1559: SQLstmt Varchar2(2000);
1560: csr_pp csr_oss_t;
1561: l_oss_pp_rec oss_pp_rec;
1562: l_action Varchar2(50);
1563: l_passport_category per_people_extra_info.information_type%TYPE;
1564: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
1565: l_cntry_mapping csr_cntry_code%ROWTYPE;
1566: --
1567: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_PassPort';

Line 1564: l_person_extra_info_rec per_people_extra_info%ROWTYPE;

1560: csr_pp csr_oss_t;
1561: l_oss_pp_rec oss_pp_rec;
1562: l_action Varchar2(50);
1563: l_passport_category per_people_extra_info.information_type%TYPE;
1564: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
1565: l_cntry_mapping csr_cntry_code%ROWTYPE;
1566: --
1567: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_PassPort';
1568: --

Line 1701: FROM per_people_extra_info pei

1697: ,pei.pei_information9
1698: ,pei.pei_information10
1699: ,pei.object_version_number
1700: ,pei.person_extra_info_id
1701: FROM per_people_extra_info pei
1702: WHERE pei.person_id = c_person_id
1703: AND pei.information_type ='PER_US_VISA_DETAILS'
1704: AND pei.pei_information5 = c_visa_type
1705: AND pei.pei_information6 = c_visa_number;

Line 1714: l_visa_category per_people_extra_info.information_type%TYPE;

1710: SQLstmt Varchar2(2000);
1711: csr_visa csr_oss_t;
1712: l_visa_rec oss_visa_rec;
1713: l_action Varchar2(50);
1714: l_visa_category per_people_extra_info.information_type%TYPE;
1715: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
1716: --
1717: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_Visa';
1718: --

Line 1715: l_person_extra_info_rec per_people_extra_info%ROWTYPE;

1711: csr_visa csr_oss_t;
1712: l_visa_rec oss_visa_rec;
1713: l_action Varchar2(50);
1714: l_visa_category per_people_extra_info.information_type%TYPE;
1715: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
1716: --
1717: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_Visa';
1718: --
1719: BEGIN

Line 1854: FROM per_people_extra_info pei

1850: ,pei.pei_information9
1851: ,pei.pei_information10
1852: ,pei.object_version_number
1853: ,pei.person_extra_info_id
1854: FROM per_people_extra_info pei
1855: WHERE pei.person_id = c_person_id
1856: AND pei.information_type = 'PER_US_VISIT_HISTORY'
1857: AND pei.pei_information11 = c_visa_number;
1858: --

Line 1865: l_visit_category per_people_extra_info.information_type%TYPE;

1861: TYPE csr_oss_t IS REF CURSOR;
1862: SQLstmt Varchar2(2000);
1863: csr_visit csr_oss_t;
1864: l_vv_rec Visit_Hist_Rec;
1865: l_visit_category per_people_extra_info.information_type%TYPE;
1866: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
1867: l_action Varchar2(50);
1868: --
1869: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_Visit';

Line 1866: l_person_extra_info_rec per_people_extra_info%ROWTYPE;

1862: SQLstmt Varchar2(2000);
1863: csr_visit csr_oss_t;
1864: l_vv_rec Visit_Hist_Rec;
1865: l_visit_category per_people_extra_info.information_type%TYPE;
1866: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
1867: l_action Varchar2(50);
1868: --
1869: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_Visit';
1870: --

Line 1985: FROM per_people_extra_info pei

1981: ,pei.pei_information4
1982: ,pei.pei_information5
1983: ,pei.object_version_number
1984: ,pei.person_extra_info_id
1985: FROM per_people_extra_info pei
1986: WHERE pei.person_id = c_person_id
1987: AND pei.information_type = c_information_type;
1988: l_OSS_pe csr_oss_pe%ROWTYPE;
1989: TYPE oss_per_rec IS RECORD

Line 1999: l_oss_person_details per_people_extra_info.information_type%TYPE;

1995: TYPE csr_oss_t IS REF CURSOR;
1996: SQLstmt Varchar2(2000);
1997: csr_igs csr_oss_t;
1998: l_oss_per_details oss_per_rec;
1999: l_oss_person_details per_people_extra_info.information_type%TYPE;
2000: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
2001: --
2002: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_OSSPerDtls';
2003: --

Line 2000: l_person_extra_info_rec per_people_extra_info%ROWTYPE;

1996: SQLstmt Varchar2(2000);
1997: csr_igs csr_oss_t;
1998: l_oss_per_details oss_per_rec;
1999: l_oss_person_details per_people_extra_info.information_type%TYPE;
2000: l_person_extra_info_rec per_people_extra_info%ROWTYPE;
2001: --
2002: l_proc_name CONSTANT Varchar2(150) := g_pkg ||'InsUpd_InHR_OSSPerDtls';
2003: --
2004: CURSOR hz_pe (c_party_id IN Number) IS