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.12.12010000.3 2008/08/06 06:29:29 ubhat ship $ */
3: ------------------------------------------------------------------------------
4: /*
5: +==========================================================================+

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

146: g_dup_no_match VARCHAR2(2000):=NULL;
147: g_dup_no_security_char VARCHAR2(2000):=NULL;
148: g_oracle_version NUMBER; -- holds the oracle version number and is
149: -- set by get_oracle_db_version
150: g_package VARCHAR2(12) := 'hr_general2.';
151: g_debug BOOLEAN;
152: -- --------------------------------------------------------------------------
153: -- |----------------------< init_fndload procedure >------------------------|
154: -- --------------------------------------------------------------------------

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

491: FROM dual
492: WHERE EXISTS (SELECT 1
493: FROM PER_ALL_PEOPLE_F per
494: WHERE per.party_id=p_party_id
495: AND per.business_group_id=Hr_General.get_business_Group_id);
496: return_value:=get_dup_no_security_char;
497: EXCEPTION
498: WHEN NO_DATA_FOUND THEN
499: return_value:=null;

Line 1229: ,p_dup_tbl OUT nocopy hr_general2.party_id_tbl

1225: ,p_last_name IN VARCHAR2
1226: ,p_national_identifier IN VARCHAR2
1227: ,p_date_of_birth IN DATE
1228: ,p_global_name IN VARCHAR2
1229: ,p_dup_tbl OUT nocopy hr_general2.party_id_tbl
1230: )
1231: RETURN BOOLEAN
1232: IS
1233: l_session_date date;

Line 1253: ,hr_general2.get_dup_security_status ( per.party_id

1249: ,p_first_name varchar2,l_ul_check varchar2,l_lu_check varchar2,l_uu_check varchar2
1250: ,l_ll_check varchar2 ) is
1251: SELECT per.party_id party_id
1252: ,per.person_id person_id
1253: ,hr_general2.get_dup_security_status ( per.party_id
1254: ,per.business_group_id
1255: ) security_status
1256: ,per.global_name person_name
1257: ,nvl(bg.name,hr_general2.get_dup_external_name) bg_name

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

1253: ,hr_general2.get_dup_security_status ( per.party_id
1254: ,per.business_group_id
1255: ) security_status
1256: ,per.global_name person_name
1257: ,nvl(bg.name,hr_general2.get_dup_external_name) bg_name
1258: ,loc.location_code location_code
1259: ,org.NAME org_name
1260: ,adr.postal_code postal_code
1261: ,SUBSTR(per.national_identifier,-4,4) national_identifier

Line 1304: ,hr_general2.get_dup_full_name

1300: UNION
1301: SELECT pty.party_id party_id
1302: ,to_number(NULL) person_id
1303: ,NULL security_status
1304: ,hr_general2.get_dup_full_name
1305: (pty.person_title
1306: ,pty.person_first_name
1307: ,pty.person_middle_name
1308: ,pty.person_last_name

Line 1311: ,hr_general2.get_dup_external_name bg_name

1307: ,pty.person_middle_name
1308: ,pty.person_last_name
1309: ,pty.person_name_suffix
1310: ) person_name
1311: ,hr_general2.get_dup_external_name bg_name
1312: ,NULL location_code
1313: ,NULL org_name
1314: ,NULL postal_code
1315: ,NULL national_identifier

Line 1581: hr_general2.get_dup_security_status(per.party_id,per.business_group_id) "SecurityStatus",

1577: if l_duplicate_name = 'Y' then
1578: open rc for
1579: select per.party_id "PartyId",
1580: per.person_id "PersonId",
1581: hr_general2.get_dup_security_status(per.party_id,per.business_group_id) "SecurityStatus",
1582: 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",
1583: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",
1584: loc.location_code "LocationCode",
1585: org.name "OrgName",

Line 1582: 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",

1578: open rc for
1579: select per.party_id "PartyId",
1580: per.person_id "PersonId",
1581: hr_general2.get_dup_security_status(per.party_id,per.business_group_id) "SecurityStatus",
1582: 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",
1583: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",
1584: loc.location_code "LocationCode",
1585: org.name "OrgName",
1586: adr.postal_code "PostalCode",

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

1579: select per.party_id "PartyId",
1580: per.person_id "PersonId",
1581: hr_general2.get_dup_security_status(per.party_id,per.business_group_id) "SecurityStatus",
1582: 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",
1583: NVL(bg.name,hr_general2.get_dup_external_name) "BgName",
1584: loc.location_code "LocationCode",
1585: org.name "OrgName",
1586: adr.postal_code "PostalCode",
1587: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",

Line 1619: ,hr_general2.get_dup_full_name(pty.person_title

1615: /*union
1616: select pty.party_id "PartyId"
1617: ,to_number(null) "PersonId"
1618: ,null "SecurityStatus"
1619: ,hr_general2.get_dup_full_name(pty.person_title
1620: ,pty.person_first_name,pty.person_middle_name ,pty.person_last_name,pty.person_name_suffix,null,null,null) "PersonName"
1621: ,hr_general2.get_dup_external_name "BgName"
1622: ,null "LocationCode"
1623: ,null "OrgName"

Line 1621: ,hr_general2.get_dup_external_name "BgName"

1617: ,to_number(null) "PersonId"
1618: ,null "SecurityStatus"
1619: ,hr_general2.get_dup_full_name(pty.person_title
1620: ,pty.person_first_name,pty.person_middle_name ,pty.person_last_name,pty.person_name_suffix,null,null,null) "PersonName"
1621: ,hr_general2.get_dup_external_name "BgName"
1622: ,null "LocationCode"
1623: ,null "OrgName"
1624: ,null "PostalCode"
1625: ,null "NationalIdentifier",

Line 1681: ,hr_general2.get_dup_security_status ( per.party_id

1677: -- NOTE : Any changes made to the below cursor MUST also be made to the cursor used for PUI
1678: open rc for
1679: SELECT per.party_id "PartyId"
1680: ,per.person_id "PersonId"
1681: ,hr_general2.get_dup_security_status ( per.party_id
1682: ,per.business_group_id
1683: ) "SecurityStatus"
1684: ,per.global_name "PersonName"
1685: ,nvl(bg.name,hr_general2.get_dup_external_name) "BgName"

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

1681: ,hr_general2.get_dup_security_status ( per.party_id
1682: ,per.business_group_id
1683: ) "SecurityStatus"
1684: ,per.global_name "PersonName"
1685: ,nvl(bg.name,hr_general2.get_dup_external_name) "BgName"
1686: ,loc.location_code "LocationCode"
1687: ,org.NAME "OrgName"
1688: ,adr.postal_code "PostalCode"
1689: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"

Line 1732: ,hr_general2.get_dup_full_name

1728: UNION
1729: SELECT pty.party_id "PartyId"
1730: ,to_number(NULL) "PersonId"
1731: ,NULL "SecurityStatus"
1732: ,hr_general2.get_dup_full_name
1733: (pty.person_title
1734: ,pty.person_first_name
1735: ,pty.person_middle_name
1736: ,pty.person_last_name

Line 1739: ,hr_general2.get_dup_external_name "BgName"

1735: ,pty.person_middle_name
1736: ,pty.person_last_name
1737: ,pty.person_name_suffix
1738: ) "PersonName"
1739: ,hr_general2.get_dup_external_name "BgName"
1740: ,NULL "LocationCode"
1741: ,NULL "OrgName"
1742: ,NULL "PostalCode"
1743: ,NULL "NationalIdentifier"

Line 1818: END Hr_General2;

1814: end SERVER_SIDE_PROFILE_PUT;
1815:
1816:
1817:
1818: END Hr_General2;