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.IGS_AD_IMP_002 dependencies on HZ_PARTY_SITES

Line 913: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,

909:
910:
911: -- Begin Address
912: DECLARE
913: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,
914: cp_addr_rec addr_cur%ROWTYPE) IS
915: SELECT site.location_id, site.party_site_id
916: FROM hz_locations loc, hz_party_sites site
917: WHERE site.party_id = cp_person_id

Line 916: FROM hz_locations loc, hz_party_sites site

912: DECLARE
913: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,
914: cp_addr_rec addr_cur%ROWTYPE) IS
915: SELECT site.location_id, site.party_site_id
916: FROM hz_locations loc, hz_party_sites site
917: WHERE site.party_id = cp_person_id
918: AND site.location_id = loc.location_id
919: AND UPPER(NVL(loc.address1,'X')) = UPPER(NVL(cp_addr_rec.addr_line_1,'X'))
920: AND UPPER(NVL(loc.address2,'X')) = UPPER(NVL(cp_addr_rec.addr_line_2,'X'))

Line 929: l_party_site_id hz_party_sites.party_site_id%TYPE;

925: AND loc.country = cp_addr_rec.country
926: AND UPPER(NVL(loc.county,'X')) = UPPER(NVL(cp_addr_rec.county,'X'))
927: AND UPPER(NVL(loc.province,'X')) = UPPER(NVL(cp_addr_rec.province,'X'));
928:
929: l_party_site_id hz_party_sites.party_site_id%TYPE;
930: BEGIN
931: g_addr_process := FALSE;
932:
933: OPEN ADDR_CUR(p_person_rec.INTERFACE_ID);

Line 1579: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,

1575: END IF;
1576:
1577:
1578: DECLARE
1579: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,
1580: cp_addr_rec addr_cur%ROWTYPE) IS
1581: SELECT site.location_id , site.party_site_id
1582: FROM hz_locations loc, hz_party_sites site
1583: WHERE site.party_id = cp_person_id

Line 1582: FROM hz_locations loc, hz_party_sites site

1578: DECLARE
1579: CURSOR check_addr_dup_cur(cp_person_id hz_party_sites.party_id%TYPE,
1580: cp_addr_rec addr_cur%ROWTYPE) IS
1581: SELECT site.location_id , site.party_site_id
1582: FROM hz_locations loc, hz_party_sites site
1583: WHERE site.party_id = cp_person_id
1584: AND site.location_id = loc.location_id
1585: AND UPPER(NVL(loc.address1,'X')) = UPPER(NVL(cp_addr_rec.addr_line_1,'X'))
1586: AND UPPER(NVL(loc.address2,'X')) = UPPER(NVL(cp_addr_rec.addr_line_2,'X'))

Line 1595: l_party_site_id hz_party_sites.party_site_id%TYPE;

1591: AND loc.country = cp_addr_rec.country
1592: AND UPPER(NVL(loc.county,'X')) = UPPER(NVL(cp_addr_rec.county,'X'))
1593: AND UPPER(NVL(loc.province,'X')) = UPPER(NVL(cp_addr_rec.province,'X'));
1594:
1595: l_party_site_id hz_party_sites.party_site_id%TYPE;
1596:
1597: BEGIN
1598:
1599: g_addr_process := FALSE;

Line 2159: l_party_site_ovn hz_party_sites.object_version_number%TYPE;

2155: l_label VARCHAR2(4000);
2156: l_debug_str VARCHAR2(4000);
2157: l_enable_log VARCHAR2(1);
2158: l_request_id NUMBER(10);
2159: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2160: l_location_ovn hz_locations.object_version_number%TYPE;
2161:
2162: -- local procedure to check whether duplicate record exists for hz_party_site_uses for a party site id
2163: PROCEDURE check_dup_addr_usage(l_party_site_id IN HZ_PARTY_SITE_USES.PARTY_SITE_ID%TYPE,

Line 2559: p_location_id IN hz_party_sites.location_id%TYPE,

2555:
2556: PROCEDURE UPDATE_ADDRESS(
2557: p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
2558: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
2559: p_location_id IN hz_party_sites.location_id%TYPE,
2560: p_party_site_id IN hz_party_sites.party_site_id%TYPE) AS
2561:
2562: l_rowid VARCHAR2(25);
2563: l_return_status VARCHAR2(100);

Line 2560: p_party_site_id IN hz_party_sites.party_site_id%TYPE) AS

2556: PROCEDURE UPDATE_ADDRESS(
2557: p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
2558: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
2559: p_location_id IN hz_party_sites.location_id%TYPE,
2560: p_party_site_id IN hz_party_sites.party_site_id%TYPE) AS
2561:
2562: l_rowid VARCHAR2(25);
2563: l_return_status VARCHAR2(100);
2564: l_msg_data VARCHAR2(4000);

Line 2565: l_location_id hz_party_sites.location_id%TYPE;

2561:
2562: l_rowid VARCHAR2(25);
2563: l_return_status VARCHAR2(100);
2564: l_msg_data VARCHAR2(4000);
2565: l_location_id hz_party_sites.location_id%TYPE;
2566: l_party_site_id hz_party_sites.party_site_id%TYPE;
2567: l_party_site_use_id NUMBER;
2568: l_date hz_party_sites.last_update_date%TYPE;
2569: l_prog_label VARCHAR2(4000);

Line 2566: l_party_site_id hz_party_sites.party_site_id%TYPE;

2562: l_rowid VARCHAR2(25);
2563: l_return_status VARCHAR2(100);
2564: l_msg_data VARCHAR2(4000);
2565: l_location_id hz_party_sites.location_id%TYPE;
2566: l_party_site_id hz_party_sites.party_site_id%TYPE;
2567: l_party_site_use_id NUMBER;
2568: l_date hz_party_sites.last_update_date%TYPE;
2569: l_prog_label VARCHAR2(4000);
2570: l_label VARCHAR2(4000);

Line 2568: l_date hz_party_sites.last_update_date%TYPE;

2564: l_msg_data VARCHAR2(4000);
2565: l_location_id hz_party_sites.location_id%TYPE;
2566: l_party_site_id hz_party_sites.party_site_id%TYPE;
2567: l_party_site_use_id NUMBER;
2568: l_date hz_party_sites.last_update_date%TYPE;
2569: l_prog_label VARCHAR2(4000);
2570: l_label VARCHAR2(4000);
2571: l_debug_str VARCHAR2(4000);
2572: l_enable_log VARCHAR2(1);

Line 2574: l_party_site_ovn hz_party_sites.object_version_number%TYPE;

2570: l_label VARCHAR2(4000);
2571: l_debug_str VARCHAR2(4000);
2572: l_enable_log VARCHAR2(1);
2573: l_request_id NUMBER(10);
2574: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
2575: l_location_ovn hz_locations.object_version_number%TYPE;
2576:
2577:
2578: CURSOR null_hand_addr_cur(cp_location_id IGS_PE_PERSON_ADDR_V.location_id%TYPE,