[Home] [Help]
1962: p_person_id IN NUMBER,
1963: p_primary_flag IN VARCHAR2 DEFAULT 'Y',
1964: p_address_type IN VARCHAR2 DEFAULT NULL,
1965: p_effective_date IN DATE DEFAULT hr_api.g_sys,
1966: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
1967: --------------------------------------------------------------------------------
1968: IS
1969: l_unique_column_tbl UniColTbl;
1970: l_csr RefCsr;
1967: --------------------------------------------------------------------------------
1968: IS
1969: l_unique_column_tbl UniColTbl;
1970: l_csr RefCsr;
1971: l_rec PER_ADDRESSES%ROWTYPE;
1972: BEGIN
1973: unique_tbl_constructor('PERSON_ID','N',to_char(p_person_id),l_unique_column_tbl);
1974: if p_primary_flag = 'Y' then
1975: unique_tbl_constructor('PRIMARY_FLAG','T',p_primary_flag,l_unique_column_tbl);
1975: unique_tbl_constructor('PRIMARY_FLAG','T',p_primary_flag,l_unique_column_tbl);
1976: else
1977: unique_tbl_constructor('ADDRESS_TYPE','T',p_address_type,l_unique_column_tbl);
1978: end if;
1979: l_csr := csr('PER_ADDRESSES',l_unique_column_tbl,'DATED',p_effective_date);
1980: fetch l_csr into l_rec;
1981: if l_csr%NOTFOUND then
1982: if p_error_when_not_exist = 'TRUE' then
1983: close l_csr;
1996: FUNCTION primary_address_rec(
1997: -- This function is valid when address_type is not NULL.
1998: p_person_id IN NUMBER,
1999: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2000: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2001: --------------------------------------------------------------------------------
2002: IS
2003: BEGIN
2004: return address_rec(p_person_id,'Y',NULL,p_effective_date,p_error_when_not_exist);
2008: -- This function is valid when address_type is not NULL.
2009: p_person_id IN NUMBER,
2010: p_address_type IN VARCHAR2,
2011: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2012: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2013: --------------------------------------------------------------------------------
2014: IS
2015: BEGIN
2016: return address_rec(p_person_id,'N',p_address_type,p_effective_date,p_error_when_not_exist);
2020: -- This function is valid when address_type is not NULL.
2021: p_employee_number IN VARCHAR2,
2022: p_business_group_id IN NUMBER,
2023: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2024: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2025: --------------------------------------------------------------------------------
2026: IS
2027: l_person_id NUMBER;
2028: BEGIN
2036: p_employee_number IN VARCHAR2,
2037: p_address_type IN VARCHAR2,
2038: p_business_group_id IN NUMBER,
2039: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2040: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2041: --------------------------------------------------------------------------------
2042: IS
2043: l_person_id NUMBER;
2044: BEGIN
2051: -- This function is valid when address_type is not NULL.
2052: p_applicant_number IN VARCHAR2,
2053: p_business_group_id IN NUMBER,
2054: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2055: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2056: --------------------------------------------------------------------------------
2057: IS
2058: l_person_id NUMBER;
2059: BEGIN
2067: p_applicant_number IN VARCHAR2,
2068: p_address_type IN VARCHAR2,
2069: p_business_group_id IN NUMBER,
2070: p_effective_date IN DATE DEFAULT hr_api.g_sys,
2071: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ADDRESSES%ROWTYPE
2072: --------------------------------------------------------------------------------
2073: IS
2074: l_person_id NUMBER;
2075: BEGIN