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_GENERAL2 dependencies on HR_GENERAL

Line 1: PACKAGE BODY Hr_General2 AS

1: PACKAGE BODY Hr_General2 AS
2: /* $Header: hrgenrl2.pkb 120.16.12020000.6 2012/12/13 11:58:57 jkvallab ship $ */
3: ------------------------------------------------------------------------------
4: /*
5: +==========================================================================+

Line 162: g_package VARCHAR2(12) := 'hr_general2.';

158: g_dup_no_match VARCHAR2(2000):=NULL;
159: g_dup_no_security_char VARCHAR2(2000):=NULL;
160: g_oracle_version NUMBER; -- holds the oracle version number and is
161: -- set by get_oracle_db_version
162: g_package VARCHAR2(12) := 'hr_general2.';
163: g_debug BOOLEAN;
164: -- --------------------------------------------------------------------------
165: -- |----------------------< init_fndload procedure >------------------------|
166: -- --------------------------------------------------------------------------

Line 534: AND per.business_group_id=Hr_General.get_business_Group_id);

530: FROM dual
531: WHERE EXISTS (SELECT 1
532: FROM PER_ALL_PEOPLE_F per
533: WHERE per.party_id=p_party_id
534: AND per.business_group_id=Hr_General.get_business_Group_id);
535:
536: return_value:=get_dup_no_security_char;
537:
538: EXCEPTION

Line 1283: ,p_dup_tbl OUT nocopy hr_general2.party_id_tbl

1279: ,p_last_name IN VARCHAR2
1280: ,p_national_identifier IN VARCHAR2
1281: ,p_date_of_birth IN DATE
1282: ,p_global_name IN VARCHAR2
1283: ,p_dup_tbl OUT nocopy hr_general2.party_id_tbl
1284: )
1285: RETURN BOOLEAN
1286: IS
1287: l_session_date date;

Line 1307: ,hr_general2.get_dup_security_status ( per.party_id

1303: ,p_first_name varchar2,l_ul_check varchar2,l_lu_check varchar2,l_uu_check varchar2
1304: ,l_ll_check varchar2 ) is
1305: SELECT per.party_id party_id
1306: ,per.person_id person_id
1307: ,hr_general2.get_dup_security_status ( per.party_id
1308: ,per.business_group_id
1309: ,per.person_id) security_status -- modified for Bug14664920
1310: ,per.global_name person_name
1311: ,nvl(bg.name,hr_general2.get_dup_external_name) bg_name

Line 1311: ,nvl(bg.name,hr_general2.get_dup_external_name) bg_name

1307: ,hr_general2.get_dup_security_status ( per.party_id
1308: ,per.business_group_id
1309: ,per.person_id) security_status -- modified for Bug14664920
1310: ,per.global_name person_name
1311: ,nvl(bg.name,hr_general2.get_dup_external_name) bg_name
1312: ,loc.location_code location_code
1313: ,org.NAME org_name
1314: ,adr.postal_code postal_code
1315: ,SUBSTR(per.national_identifier,-4,4) national_identifier

Line 1358: ,hr_general2.get_dup_full_name

1354: UNION
1355: SELECT pty.party_id party_id
1356: ,to_number(NULL) person_id
1357: ,NULL security_status
1358: ,hr_general2.get_dup_full_name
1359: (pty.person_title
1360: ,pty.person_first_name
1361: ,pty.person_middle_name
1362: ,pty.person_last_name

Line 1365: ,hr_general2.get_dup_external_name bg_name

1361: ,pty.person_middle_name
1362: ,pty.person_last_name
1363: ,pty.person_name_suffix
1364: ) person_name
1365: ,hr_general2.get_dup_external_name bg_name
1366: ,NULL location_code
1367: ,NULL org_name
1368: ,NULL postal_code
1369: ,NULL national_identifier

Line 1635: hr_general2.get_dup_security_status(per.party_id,per.business_group_id

1631: if l_duplicate_name = 'Y' then
1632: open rc for
1633: select per.party_id "PartyId",
1634: per.person_id "PersonId",
1635: hr_general2.get_dup_security_status(per.party_id,per.business_group_id
1636: ,per.person_id) "SecurityStatus", -- modified for Bug14664920
1637: hr_general2.get_dup_full_name(hr_general.decode_lookup('TITLE',per.title),per.first_name, per.middle_names,per.last_name,per.suffix,hr_api.return_legislation_code(per.business_group_id),per.per_information19,per.per_information18) "PersonName",
1638: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",
1639: loc.location_code "LocationCode",

Line 1637: hr_general2.get_dup_full_name(hr_general.decode_lookup('TITLE',per.title),per.first_name, per.middle_names,per.last_name,per.suffix,hr_api.return_legislation_code(per.business_group_id),per.per_information19,per.per_information18) "PersonName",

1633: select per.party_id "PartyId",
1634: per.person_id "PersonId",
1635: hr_general2.get_dup_security_status(per.party_id,per.business_group_id
1636: ,per.person_id) "SecurityStatus", -- modified for Bug14664920
1637: hr_general2.get_dup_full_name(hr_general.decode_lookup('TITLE',per.title),per.first_name, per.middle_names,per.last_name,per.suffix,hr_api.return_legislation_code(per.business_group_id),per.per_information19,per.per_information18) "PersonName",
1638: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",
1639: loc.location_code "LocationCode",
1640: org.name "OrgName",
1641: adr.postal_code "PostalCode",

Line 1638: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",

1634: per.person_id "PersonId",
1635: hr_general2.get_dup_security_status(per.party_id,per.business_group_id
1636: ,per.person_id) "SecurityStatus", -- modified for Bug14664920
1637: hr_general2.get_dup_full_name(hr_general.decode_lookup('TITLE',per.title),per.first_name, per.middle_names,per.last_name,per.suffix,hr_api.return_legislation_code(per.business_group_id),per.per_information19,per.per_information18) "PersonName",
1638: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",
1639: loc.location_code "LocationCode",
1640: org.name "OrgName",
1641: adr.postal_code "PostalCode",
1642: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",

Line 1674: ,hr_general2.get_dup_full_name(pty.person_title

1670: /*union
1671: select pty.party_id "PartyId"
1672: ,to_number(null) "PersonId"
1673: ,null "SecurityStatus"
1674: ,hr_general2.get_dup_full_name(pty.person_title
1675: ,pty.person_first_name,pty.person_middle_name ,pty.person_last_name,pty.person_name_suffix,null,null,null) "PersonName"
1676: ,hr_general2.get_dup_external_name "BgName"
1677: ,null "LocationCode"
1678: ,null "OrgName"

Line 1676: ,hr_general2.get_dup_external_name "BgName"

1672: ,to_number(null) "PersonId"
1673: ,null "SecurityStatus"
1674: ,hr_general2.get_dup_full_name(pty.person_title
1675: ,pty.person_first_name,pty.person_middle_name ,pty.person_last_name,pty.person_name_suffix,null,null,null) "PersonName"
1676: ,hr_general2.get_dup_external_name "BgName"
1677: ,null "LocationCode"
1678: ,null "OrgName"
1679: ,null "PostalCode"
1680: ,null "NationalIdentifier",

Line 1736: ,hr_general2.get_dup_security_status ( per.party_id

1732: -- NOTE : Any changes made to the below cursor MUST also be made to the cursor used for PUI
1733: open rc for
1734: SELECT per.party_id "PartyId"
1735: ,per.person_id "PersonId"
1736: ,hr_general2.get_dup_security_status ( per.party_id
1737: ,per.business_group_id
1738: ,per.person_id) "SecurityStatus" -- modified for Bug14664920
1739: ,per.global_name "PersonName"
1740: ,nvl(bg.name,hr_general2.get_dup_external_name) "BgName"

Line 1740: ,nvl(bg.name,hr_general2.get_dup_external_name) "BgName"

1736: ,hr_general2.get_dup_security_status ( per.party_id
1737: ,per.business_group_id
1738: ,per.person_id) "SecurityStatus" -- modified for Bug14664920
1739: ,per.global_name "PersonName"
1740: ,nvl(bg.name,hr_general2.get_dup_external_name) "BgName"
1741: ,loc.location_code "LocationCode"
1742: ,org.NAME "OrgName"
1743: ,adr.postal_code "PostalCode"
1744: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"

Line 1788: ,hr_general2.get_dup_full_name

1784: UNION
1785: SELECT pty.party_id "PartyId"
1786: ,to_number(NULL) "PersonId"
1787: ,NULL "SecurityStatus"
1788: ,hr_general2.get_dup_full_name
1789: (pty.person_title
1790: ,pty.person_first_name
1791: ,pty.person_middle_name
1792: ,pty.person_last_name

Line 1795: ,hr_general2.get_dup_external_name "BgName"

1791: ,pty.person_middle_name
1792: ,pty.person_last_name
1793: ,pty.person_name_suffix
1794: ) "PersonName"
1795: ,hr_general2.get_dup_external_name "BgName"
1796: ,NULL "LocationCode"
1797: ,NULL "OrgName"
1798: ,NULL "PostalCode"
1799: ,NULL "NationalIdentifier"

Line 1898: END Hr_General2;

1894: end if;
1895:
1896: end reporting_user;
1897:
1898: END Hr_General2;