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_026 dependencies on HZ_PARTY_SITES

Line 2974: l_location_id hz_party_sites.location_id%TYPE;

2970: lvcAction VARCHAR2(1);
2971: lvcRecordExist VARCHAR2(1);
2972: p_status VARCHAR2(1);
2973: p_error_code VARCHAR2(30);
2974: l_location_id hz_party_sites.location_id%TYPE;
2975: l_party_site_id hz_party_sites.party_site_id%TYPE;
2976: l_processed_records NUMBER(5) := 0;
2977:
2978: l_prog_label VARCHAR2(100);

Line 2975: l_party_site_id hz_party_sites.party_site_id%TYPE;

2971: lvcRecordExist VARCHAR2(1);
2972: p_status VARCHAR2(1);
2973: p_error_code VARCHAR2(30);
2974: l_location_id hz_party_sites.location_id%TYPE;
2975: l_party_site_id hz_party_sites.party_site_id%TYPE;
2976: l_processed_records NUMBER(5) := 0;
2977:
2978: l_prog_label VARCHAR2(100);
2979: l_label VARCHAR2(100);

Line 2999: SELECT hz_party_sites.rowid,hz_party_sites.*

2995: l_addr_rec1 igs_ad_addr_int_all%ROWTYPE;
2996:
2997: CURSOR check_dup_addr(cp_x_value VARCHAR2,
2998: cp_addr_rec addr_cur%ROWTYPE) IS
2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))

Line 3000: FROM hz_locations, hz_party_sites

2996:
2997: CURSOR check_dup_addr(cp_x_value VARCHAR2,
2998: cp_addr_rec addr_cur%ROWTYPE) IS
2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))

Line 3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id

2997: CURSOR check_dup_addr(cp_x_value VARCHAR2,
2998: cp_addr_rec addr_cur%ROWTYPE) IS
2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))

Line 3002: AND hz_party_sites.location_id = hz_locations.location_id

2998: cp_addr_rec addr_cur%ROWTYPE) IS
2999: SELECT hz_party_sites.rowid,hz_party_sites.*
3000: FROM hz_locations, hz_party_sites
3001: WHERE hz_party_sites.party_id = cp_addr_rec.person_id
3002: AND hz_party_sites.location_id = hz_locations.location_id
3003: AND UPPER(NVL(hz_locations.address1,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_1,cp_x_value))
3004: AND UPPER(NVL(hz_locations.address2,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_2,cp_x_value))
3005: AND UPPER(NVL(hz_locations.address3,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_3,cp_x_value))
3006: AND UPPER(NVL(hz_locations.address4,cp_x_value)) = UPPER(NVL(cp_addr_rec.addr_line_4,cp_x_value))

Line 3055: FROM hz_party_sites hs,

3051: match_ind='19'
3052: WHERE interface_run_id=l_interface_run_id
3053: AND STATUS = '2'
3054: AND EXISTS( SELECT hs.rowid
3055: FROM hz_party_sites hs,
3056: igs_ad_interface_all ad,
3057: hz_locations hl
3058: WHERE ad.interface_id = ai.interface_id AND
3059: hs.party_id = ad.person_id AND

Line 3095: hz_party_sites hs,

3091: AND status = '2'
3092: AND match_ind IS NULL
3093: AND EXISTS( SELECT hs.rowid
3094: FROM hz_locations hl,
3095: hz_party_sites hs,
3096: igs_ad_interface_all ad
3097: WHERE ad.interface_id = ai.interface_id AND
3098: hs.party_id = ad.person_id AND
3099: hs.location_id = hl.location_id AND

Line 3116: FROM hz_party_sites hs,

3112: UPDATE igs_ad_addr_int_all ai
3113: SET status = '3',
3114: match_ind='20',
3115: dup_party_site_id = (SELECT hs.party_site_id
3116: FROM hz_party_sites hs,
3117: igs_ad_interface_all ad,
3118: hz_locations hl
3119: WHERE ad.interface_id = ai.interface_id AND
3120: ROWNUM = 1 AND

Line 3136: FROM hz_party_sites hs,

3132: WHERE interface_run_id=l_interface_run_id AND
3133: status = '2' AND
3134: match_ind IS NULL AND
3135: EXISTS (SELECT hs.rowid
3136: FROM hz_party_sites hs,
3137: igs_ad_interface_all ad,
3138: hz_locations hl
3139: WHERE ad.interface_id = ai.interface_id AND
3140: hs.party_id = ad.person_id AND