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.HZ_MERGE_ENTITY_ATTRI_PVT dependencies on AR_LOOKUPS

Line 999: from ar_lookups c, ar_lookups t, ar_lookups c1

995:
996: -- get all attributes for the passing in group leader attribute name
997: cursor get_group_attributes_csr(p_attribute_name varchar2, p_lookup_type varchar2) is
998: select c1.lookup_code
999: from ar_lookups c, ar_lookups t, ar_lookups c1
1000: where c.lookup_type = t.lookup_code
1001: and c1.lookup_type = t.lookup_code
1002: and substrb(c.externally_visible_flag,6,3) = substrb(c1.externally_visible_flag,6,3)
1003: and c.lookup_type = c1.lookup_type

Line 1075: from hz_merge_entity_attributes attri, ar_lookups c, ar_lookups t

1071:
1072: -- get master party attributes where leader is null
1073: cursor get_leader_attribute_name_csr(p_lookup_type varchar2) is
1074: select attri.attribute_name
1075: from hz_merge_entity_attributes attri, ar_lookups c, ar_lookups t
1076: where attri.attribute_name = c.lookup_code
1077: and c.lookup_type = t.lookup_code
1078: and t.lookup_type = p_lookup_type
1079: and attribute_value is null and substrb(c.externally_visible_flag,10,1) = 'L'

Line 1827: from ar_lookups c,

1823:
1824: function is_leading_attribute(p_attribute_name in varchar2, p_lookup_type in varchar2) return varchar2 is
1825: cursor get_leading_attri_csr is
1826: select 'X'
1827: from ar_lookups c,
1828: ar_lookups t
1829: where c.lookup_type = t.lookup_code
1830: and c.enabled_flag = 'Y'
1831: and t.lookup_type = p_lookup_type

Line 1828: ar_lookups t

1824: function is_leading_attribute(p_attribute_name in varchar2, p_lookup_type in varchar2) return varchar2 is
1825: cursor get_leading_attri_csr is
1826: select 'X'
1827: from ar_lookups c,
1828: ar_lookups t
1829: where c.lookup_type = t.lookup_code
1830: and c.enabled_flag = 'Y'
1831: and t.lookup_type = p_lookup_type
1832: and substrb(c.externally_visible_flag,10,1) = 'L'

Line 2015: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','SIC_CODE_TYPE',p_attri_value);

2011: then
2012:
2013: if p_attri_name = 'SIC_CODE_TYPE'
2014: then
2015: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','SIC_CODE_TYPE',p_attri_value);
2016: elsif p_attri_name = 'LEGAL_STATUS'
2017: then
2018: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LEGAL_STATUS',p_attri_value);
2019: elsif p_attri_name = 'HQ_BRANCH_IND'

Line 2018: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LEGAL_STATUS',p_attri_value);

2014: then
2015: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','SIC_CODE_TYPE',p_attri_value);
2016: elsif p_attri_name = 'LEGAL_STATUS'
2017: then
2018: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LEGAL_STATUS',p_attri_value);
2019: elsif p_attri_name = 'HQ_BRANCH_IND'
2020: then
2021: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','HQ_BRANCH_IND',p_attri_value);
2022: elsif p_attri_name = 'FISCAL_YEAREND_MONTH'

Line 2021: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','HQ_BRANCH_IND',p_attri_value);

2017: then
2018: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LEGAL_STATUS',p_attri_value);
2019: elsif p_attri_name = 'HQ_BRANCH_IND'
2020: then
2021: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','HQ_BRANCH_IND',p_attri_value);
2022: elsif p_attri_name = 'FISCAL_YEAREND_MONTH'
2023: then
2024: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MONTH',p_attri_value);
2025: elsif p_attri_name = 'LOCAL_BUS_IDEN_TYPE'

Line 2024: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MONTH',p_attri_value);

2020: then
2021: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','HQ_BRANCH_IND',p_attri_value);
2022: elsif p_attri_name = 'FISCAL_YEAREND_MONTH'
2023: then
2024: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MONTH',p_attri_value);
2025: elsif p_attri_name = 'LOCAL_BUS_IDEN_TYPE'
2026: then
2027: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_BUS_IDEN_TYPE',p_attri_value);
2028: elsif p_attri_name = 'REGISTRATION_TYPE'

Line 2027: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_BUS_IDEN_TYPE',p_attri_value);

2023: then
2024: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MONTH',p_attri_value);
2025: elsif p_attri_name = 'LOCAL_BUS_IDEN_TYPE'
2026: then
2027: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_BUS_IDEN_TYPE',p_attri_value);
2028: elsif p_attri_name = 'REGISTRATION_TYPE'
2029: then
2030: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);
2031: elsif p_attri_name = 'LOCAL_ACTIVITY_CODE_TYPE'

Line 2030: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);

2026: then
2027: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_BUS_IDEN_TYPE',p_attri_value);
2028: elsif p_attri_name = 'REGISTRATION_TYPE'
2029: then
2030: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);
2031: elsif p_attri_name = 'LOCAL_ACTIVITY_CODE_TYPE'
2032: then
2033: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_ACTIVITY_CODE_TYPE',p_attri_value);
2034:

Line 2033: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_ACTIVITY_CODE_TYPE',p_attri_value);

2029: then
2030: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);
2031: elsif p_attri_name = 'LOCAL_ACTIVITY_CODE_TYPE'
2032: then
2033: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_ACTIVITY_CODE_TYPE',p_attri_value);
2034:
2035: elsif p_attri_name = 'LOCAL_ACTIVITY_CODE'
2036: then
2037: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','NACE',p_attri_value);

Line 2037: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','NACE',p_attri_value);

2033: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','LOCAL_ACTIVITY_CODE_TYPE',p_attri_value);
2034:
2035: elsif p_attri_name = 'LOCAL_ACTIVITY_CODE'
2036: then
2037: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','NACE',p_attri_value);
2038: elsif p_attri_name = 'REGISTRATION_TYPE'
2039: then
2040: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);
2041: elsif p_attri_name = 'TOTAL_EMPLOYEES_IND'

Line 2040: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);

2036: then
2037: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','NACE',p_attri_value);
2038: elsif p_attri_name = 'REGISTRATION_TYPE'
2039: then
2040: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);
2041: elsif p_attri_name = 'TOTAL_EMPLOYEES_IND'
2042: then
2043: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMPLOYEES_INDICATOR',p_attri_value);
2044: elsif p_attri_name = 'TOTAL_EMP_EST_IND'

Line 2043: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMPLOYEES_INDICATOR',p_attri_value);

2039: then
2040: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','REGISTRATION_TYPE',p_attri_value);
2041: elsif p_attri_name = 'TOTAL_EMPLOYEES_IND'
2042: then
2043: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMPLOYEES_INDICATOR',p_attri_value);
2044: elsif p_attri_name = 'TOTAL_EMP_EST_IND'
2045: then
2046: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_EST_IND', p_attri_value);
2047: elsif p_attri_name = 'TOTAL_EMP_MIN_IND'

Line 2046: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_EST_IND', p_attri_value);

2042: then
2043: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMPLOYEES_INDICATOR',p_attri_value);
2044: elsif p_attri_name = 'TOTAL_EMP_EST_IND'
2045: then
2046: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_EST_IND', p_attri_value);
2047: elsif p_attri_name = 'TOTAL_EMP_MIN_IND'
2048: then
2049: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_MIN_IND', p_attri_value);
2050: elsif p_attri_name = 'EMP_AT_PRIMARY_ADR_EST_IND'

Line 2049: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_MIN_IND', p_attri_value);

2045: then
2046: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_EST_IND', p_attri_value);
2047: elsif p_attri_name = 'TOTAL_EMP_MIN_IND'
2048: then
2049: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_MIN_IND', p_attri_value);
2050: elsif p_attri_name = 'EMP_AT_PRIMARY_ADR_EST_IND'
2051: then
2052: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_EST_IND',p_attri_value);
2053: elsif p_attri_name = 'EMP_AT_PRIMARY_ADR_MIN_IND'

Line 2052: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_EST_IND',p_attri_value);

2048: then
2049: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','TOTAL_EMP_MIN_IND', p_attri_value);
2050: elsif p_attri_name = 'EMP_AT_PRIMARY_ADR_EST_IND'
2051: then
2052: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_EST_IND',p_attri_value);
2053: elsif p_attri_name = 'EMP_AT_PRIMARY_ADR_MIN_IND'
2054: then
2055: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_MIN_IND',p_attri_value);
2056: elsif p_attri_value in ('Y','N')

Line 2055: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_MIN_IND',p_attri_value);

2051: then
2052: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_EST_IND',p_attri_value);
2053: elsif p_attri_name = 'EMP_AT_PRIMARY_ADR_MIN_IND'
2054: then
2055: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_MIN_IND',p_attri_value);
2056: elsif p_attri_value in ('Y','N')
2057: then
2058: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);
2059: else return p_attri_value;

Line 2058: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);

2054: then
2055: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','EMP_AT_PRIMARY_ADR_MIN_IND',p_attri_value);
2056: elsif p_attri_value in ('Y','N')
2057: then
2058: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);
2059: else return p_attri_value;
2060: end if;
2061: elsif p_profile_type = 'PERSON'
2062: then

Line 2065: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','CONTACT_TITLE',p_attri_value);

2061: elsif p_profile_type = 'PERSON'
2062: then
2063: if p_attri_name = 'PERSON_PRE_NAME_ADJUNCT'
2064: then
2065: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','CONTACT_TITLE',p_attri_value);
2066: elsif p_attri_name = 'MARITAL_STATUS'
2067: then
2068: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MARITAL_STATUS',p_attri_value);
2069: elsif p_attri_value in ('Y','N')

Line 2068: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MARITAL_STATUS',p_attri_value);

2064: then
2065: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','CONTACT_TITLE',p_attri_value);
2066: elsif p_attri_name = 'MARITAL_STATUS'
2067: then
2068: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MARITAL_STATUS',p_attri_value);
2069: elsif p_attri_value in ('Y','N')
2070: then
2071: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);
2072: --Start bug 7279978

Line 2071: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);

2067: then
2068: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','MARITAL_STATUS',p_attri_value);
2069: elsif p_attri_value in ('Y','N')
2070: then
2071: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);
2072: --Start bug 7279978
2073: elsif p_attri_name = 'RENT_OWN_IND'
2074: then
2075: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','OWN_RENT_IND',p_attri_value);

Line 2075: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','OWN_RENT_IND',p_attri_value);

2071: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','YES/NO',p_attri_value);
2072: --Start bug 7279978
2073: elsif p_attri_name = 'RENT_OWN_IND'
2074: then
2075: return HZ_UTILITY_v2PUB.Get_LookupMeaning('AR_LOOKUPS','OWN_RENT_IND',p_attri_value);
2076: --End bug 7279978
2077: else return p_attri_value;
2078: end if;
2079: end if;