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_MAP_PARTY_PUB dependencies on HZ_ORIG_SYS_REFERENCES

Line 1854: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;

1850: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
1851: l_orig_system_ref_id NUMBER;
1852: l_object_version_number NUMBER;
1853: l_start_date_active date;
1854: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
1855: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
1856: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
1857: l_status varchar2(1);
1858:

Line 1855: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;

1851: l_orig_system_ref_id NUMBER;
1852: l_object_version_number NUMBER;
1853: l_start_date_active date;
1854: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
1855: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
1856: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
1857: l_status varchar2(1);
1858:
1859: --MOSR Changes

Line 1856: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;

1852: l_object_version_number NUMBER;
1853: l_start_date_active date;
1854: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
1855: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
1856: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
1857: l_status varchar2(1);
1858:
1859: --MOSR Changes
1860: --4227564: Modified the cursors to check for records of other parties having same

Line 1871: hz_orig_sys_references hosr

1867: hosr.orig_system,
1868: hosr.orig_system_reference,
1869: hosr.owner_table_name
1870: FROM -- hz_organization_profiles org_pro,
1871: hz_orig_sys_references hosr
1872: WHERE -- nvl(org_pro.party_id, '-999') = hosr.owner_table_id AND
1873: hosr.orig_system = 'DNB'
1874: AND hosr.owner_table_name = 'HZ_PARTIES'
1875: AND trunc(nvl(hosr.end_date_active, sysdate)) >= trunc(sysdate)

Line 1890: hz_orig_sys_references hosr

1886: hosr.orig_system,
1887: hosr.orig_system_reference,
1888: hosr.owner_table_name
1889: FROM --hz_party_sites ps,
1890: hz_orig_sys_references hosr
1891: WHERE --nvl(ps.party_site_id, '-999') = hosr.owner_table_id
1892: --AND ps.status = 'A' AND
1893: hosr.orig_system = 'DNB'
1894: AND hosr.owner_table_name = 'HZ_PARTY_SITES'

Line 1910: hz_orig_sys_references hosr

1906: hosr.orig_system,
1907: hosr.orig_system_reference,
1908: hosr.owner_table_name
1909: FROM -- hz_contact_points cp,
1910: hz_orig_sys_references hosr
1911: WHERE --nvl(cp.contact_point_id, '-999') = hosr.owner_table_id
1912: -- AND cp.status = 'A' AND
1913: hosr.orig_system = 'DNB'
1914: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'

Line 2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;

2061: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
2062: l_orig_system_ref_id NUMBER;
2063: l_object_version_number NUMBER;
2064: l_start_date_active date;
2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
2066: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2067: l_orig_system_reference_p HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2068: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
2069: l_owner_table_id HZ_ORIG_SYS_REFERENCES.owner_table_id%type;

Line 2066: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;

2062: l_orig_system_ref_id NUMBER;
2063: l_object_version_number NUMBER;
2064: l_start_date_active date;
2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
2066: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2067: l_orig_system_reference_p HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2068: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
2069: l_owner_table_id HZ_ORIG_SYS_REFERENCES.owner_table_id%type;
2070: l_msg_count NUMBER;

Line 2067: l_orig_system_reference_p HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;

2063: l_object_version_number NUMBER;
2064: l_start_date_active date;
2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
2066: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2067: l_orig_system_reference_p HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2068: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
2069: l_owner_table_id HZ_ORIG_SYS_REFERENCES.owner_table_id%type;
2070: l_msg_count NUMBER;
2071: l_msg_data VARCHAR2(2000);

Line 2068: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;

2064: l_start_date_active date;
2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
2066: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2067: l_orig_system_reference_p HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2068: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
2069: l_owner_table_id HZ_ORIG_SYS_REFERENCES.owner_table_id%type;
2070: l_msg_count NUMBER;
2071: l_msg_data VARCHAR2(2000);
2072: p_duns_number_c VARCHAR2(10);

Line 2069: l_owner_table_id HZ_ORIG_SYS_REFERENCES.owner_table_id%type;

2065: l_orig_system HZ_ORIG_SYS_REFERENCES.orig_system%type;
2066: l_orig_system_reference HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2067: l_orig_system_reference_p HZ_ORIG_SYS_REFERENCES.orig_system_reference%type;
2068: l_owner_table_name HZ_ORIG_SYS_REFERENCES.owner_table_name%type;
2069: l_owner_table_id HZ_ORIG_SYS_REFERENCES.owner_table_id%type;
2070: l_msg_count NUMBER;
2071: l_msg_data VARCHAR2(2000);
2072: p_duns_number_c VARCHAR2(10);
2073: --MOSR Changes

Line 2085: hz_orig_sys_references hosr

2081: hosr.owner_table_name,
2082: hosr.owner_table_id
2083: FROM
2084: --hz_organization_profiles org_pro,
2085: hz_orig_sys_references hosr
2086: WHERE
2087: --nvl(org_pro.party_id, '-999') = hosr.owner_table_id AND
2088: hosr.orig_system = 'DNB'
2089: AND hosr.owner_table_name = 'HZ_PARTIES'

Line 2106: hz_orig_sys_references hosr

2102: hosr.owner_table_name,
2103: hosr.owner_table_id
2104: FROM
2105: --hz_party_sites ps,
2106: hz_orig_sys_references hosr
2107: WHERE
2108: --nvl(ps.party_site_id, '-999') = hosr.owner_table_id AND
2109: hosr.orig_system = 'DNB'
2110: AND hosr.owner_table_name = 'HZ_PARTY_SITES'

Line 2127: hz_orig_sys_references hosr

2123: hosr.owner_table_name,
2124: hosr.owner_table_id
2125: FROM
2126: --hz_contact_points cp,
2127: hz_orig_sys_references hosr
2128: WHERE
2129: --nvl(cp.contact_point_id, '-999') = hosr.owner_table_id AND
2130: hosr.orig_system = 'DNB'
2131: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'

Line 2379: FROM hz_orig_sys_references hosr

2375:
2376: if(l_is_new_party = FALSE) THEN
2377: BEGIN
2378: SELECT hosr.orig_system_ref_id INTO l_orig_sys_ref_id
2379: FROM hz_orig_sys_references hosr
2380: WHERE hosr.orig_system = 'DNB'
2381: AND hosr.owner_table_name = 'HZ_PARTIES'
2382: AND hosr.status='A'
2383: AND hosr.owner_table_id = l_organization_rec.party_rec.party_id;

Line 3247: from hz_orig_sys_references

3243: p_orig_system_ref IN VARCHAR2,
3244: p_owner_table_name IN VARCHAR2)
3245: IS
3246: select 'Y'
3247: from hz_orig_sys_references
3248: where orig_system = p_orig_system
3249: and orig_system_reference = p_orig_system_ref
3250: and owner_table_name = p_owner_table_name
3251: and status = 'A'

Line 4107: FROM hz_orig_sys_references hosr

4103: END IF;
4104: --4227564
4105: BEGIN
4106: SELECT hosr.orig_system_ref_id INTO l_orig_sys_ref_id
4107: FROM hz_orig_sys_references hosr
4108: WHERE hosr.orig_system = 'DNB'
4109: AND hosr.owner_table_name = 'HZ_PARTY_SITES'
4110: AND hosr.status='A'
4111: AND hosr.owner_table_id = l_party_site_id;

Line 4116: from hz_orig_sys_references

4112: EXCEPTION
4113: WHEN NO_DATA_FOUND THEN
4114: select count(1)
4115: into l_count
4116: from hz_orig_sys_references
4117: where owner_table_name = 'HZ_PARTY_SITES'
4118: and orig_system = 'DNB'
4119: and status = 'A'
4120: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)

Line 4314: from hz_orig_sys_references

4310: p_orig_system_ref IN VARCHAR2,
4311: p_owner_table_name IN VARCHAR2)
4312: IS
4313: select 'Y'
4314: from hz_orig_sys_references
4315: where orig_system = p_orig_system
4316: and orig_system_reference = p_orig_system_ref
4317: and owner_table_name = p_owner_table_name
4318: and status = 'A'

Line 4344: from hz_orig_sys_references

4340: END IF;
4341:
4342: select count(1)
4343: into l_count
4344: from hz_orig_sys_references
4345: where owner_table_name = 'HZ_PARTY_SITES'
4346: and orig_system = 'DNB'
4347: and status = 'A'
4348: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)

Line 4437: l_orig_system_reference hz_orig_sys_references.orig_system_reference%TYPE;

4433: l_object_version_number NUMBER;
4434: l_contact_point_id NUMBER;
4435: l_create BOOLEAN := FALSE;
4436: l_count NUMBER;
4437: l_orig_system_reference hz_orig_sys_references.orig_system_reference%TYPE;
4438: l_duns_number_c hz_organization_profiles.duns_number_c%TYPE;
4439: --4227564
4440: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.orig_sys_reference_rec_type;
4441: l_orig_sys_ref_id NUMBER;

Line 4448: from hz_orig_sys_references

4444: p_orig_system_ref IN VARCHAR2,
4445: p_owner_table_name IN VARCHAR2)
4446: IS
4447: select 'Y'
4448: from hz_orig_sys_references
4449: where orig_system = p_orig_system
4450: and orig_system_reference = p_orig_system_ref
4451: and owner_table_name = p_owner_table_name
4452: and status = 'A'

Line 4476: from hz_orig_sys_references

4472: END IF;
4473:
4474: select count(1)
4475: into l_count
4476: from hz_orig_sys_references
4477: where owner_table_name = 'HZ_CONTACT_POINTS'
4478: and orig_system = 'DNB'
4479: and status = 'A'
4480: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)

Line 4527: FROM hz_orig_sys_references hosr

4523: END IF;
4524: --4227564
4525: BEGIN
4526: SELECT hosr.orig_system_ref_id INTO l_orig_sys_ref_id
4527: FROM hz_orig_sys_references hosr
4528: WHERE hosr.orig_system = 'DNB'
4529: AND hosr.owner_table_name = 'HZ_CONTACT_POINTS'
4530: AND hosr.status='A'
4531: AND hosr.owner_table_id = p_contact_points_rec.contact_point_id;

Line 4583: from hz_orig_sys_references

4579: END IF;
4580:
4581: select count(1)
4582: into l_count
4583: from hz_orig_sys_references
4584: where owner_table_name = 'HZ_CONTACT_POINTS'
4585: and orig_system = 'DNB'
4586: and status = 'A'
4587: and trunc(nvl(end_date_active, sysdate)) >= trunc(sysdate)

Line 6100: FROM hz_organization_profiles org, hz_orig_sys_references ssm

6096: -- to find active profile for related party.
6097:
6098: CURSOR c1 IS
6099: SELECT org.party_id
6100: FROM hz_organization_profiles org, hz_orig_sys_references ssm
6101: WHERE org.duns_number_c = lpad(to_char(p_related_duns_rec.DUNS_NUMBER),9,'0')
6102: AND org.actual_content_source = p_related_duns_rec.content_source_type
6103: AND org.effective_end_date is NULL
6104: AND org.party_id = ssm.owner_table_id