APPS.IGS_AD_IMP_026 dependencies on IGS_AD_ADDR_INT_ALL

Line 2985: CURSOR addr_cur(cp_interface_run_id igs_ad_addr_int_all.interface_run_id%TYPE) IS

2981: l_enable_log VARCHAR2(1);
2982: l_request_id NUMBER;
2983: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2984:
2985: CURSOR addr_cur(cp_interface_run_id igs_ad_addr_int_all.interface_run_id%TYPE) IS
2986: SELECT ai.*, i.person_id
2987: FROM igs_ad_addr_int_all ai, igs_ad_interface_all i
2988: WHERE ai.status = '2' AND
2989: i.interface_run_id = cp_interface_run_id AND

Line 2987: FROM igs_ad_addr_int_all ai, igs_ad_interface_all i

2983: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2984:
2985: CURSOR addr_cur(cp_interface_run_id igs_ad_addr_int_all.interface_run_id%TYPE) IS
2986: SELECT ai.*, i.person_id
2987: FROM igs_ad_addr_int_all ai, igs_ad_interface_all i
2988: WHERE ai.status = '2' AND
2989: i.interface_run_id = cp_interface_run_id AND
2990: ai.interface_id = i.interface_id AND
2991: i.status = '1';

Line 2995: l_addr_rec1 igs_ad_addr_int_all%ROWTYPE;

2991: i.status = '1';
2992:
2993:
2994: addr_rec addr_cur%ROWTYPE;
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.*

Line 3040: UPDATE igs_ad_addr_int_all

3036: lvcAction := Igs_Ad_Imp_001.find_source_cat_rule(p_source_type_id,'PERSON_ADDRESS');
3037:
3038: IF lvcAction = 'E' OR lvcAction = 'I' THEN
3039:
3040: UPDATE igs_ad_addr_int_all
3041: SET status='3',
3042: error_code = 'E695'
3043: WHERE interface_run_id=l_interface_run_id
3044: AND STATUS = '2'

Line 3049: UPDATE igs_ad_addr_int_all ai

3045: AND match_ind IS NOT NULL;
3046:
3047: IF lvcAction = 'E' THEN
3048:
3049: UPDATE igs_ad_addr_int_all ai
3050: SET status='1',
3051: match_ind='19'
3052: WHERE interface_run_id=l_interface_run_id
3053: AND STATUS = '2'

Line 3074: UPDATE igs_ad_addr_int_all

3070: END IF;
3071:
3072: ELSIF lvcAction = 'R' THEN
3073:
3074: UPDATE igs_ad_addr_int_all
3075: SET status = '1'
3076: WHERE interface_run_id=l_interface_run_id
3077: AND status = '2'
3078: AND match_ind IN ('18','19','22','23');

Line 3080: UPDATE igs_ad_addr_int_all

3076: WHERE interface_run_id=l_interface_run_id
3077: AND status = '2'
3078: AND match_ind IN ('18','19','22','23');
3079:
3080: UPDATE igs_ad_addr_int_all
3081: SET status = '3',
3082: error_code = 'E695'
3083: WHERE interface_run_id=l_interface_run_id
3084: AND status = '2'

Line 3087: UPDATE igs_ad_addr_int_all ai

3083: WHERE interface_run_id=l_interface_run_id
3084: AND status = '2'
3085: AND ( match_ind IS NOT NULL AND match_ind <> '21' AND match_ind <> '25');
3086:
3087: UPDATE igs_ad_addr_int_all ai
3088: SET status='1',
3089: match_ind = '23'
3090: WHERE interface_run_id=l_interface_run_id
3091: AND status = '2'

Line 3112: UPDATE igs_ad_addr_int_all ai

3108: hl.country = UPPER(ai.country) AND
3109: NVL(UPPER(hl.postal_code), 'X') = NVL(UPPER(ai.postcode), 'X'));
3110:
3111:
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,