APPS.IGR_IMP_001 dependencies on IGR_IS_ADDRESS

Line 128: CURSOR inq_per_addr_cur(l_person_id igr_is_address.inq_person_id%TYPE) IS

124: WHERE
125: inq_person_id = l_person_id AND
126: status IN (inserted,updated);
127:
128: CURSOR inq_per_addr_cur(l_person_id igr_is_address.inq_person_id%TYPE) IS
129: SELECT
130: addr_line_1,
131: addr_line_2,
132: addr_line_3,

Line 144: igr_is_address

140: start_date,
141: end_date,
142: addr_usage
143: FROM
144: igr_is_address
145: WHERE
146: inq_person_id = l_person_id AND
147: status IN (inserted,updated);
148:

Line 1287: UPDATE igr_is_address SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

1283: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_ADDRUSAGE_INT failed '||SQLERRM);
1284: RAISE;
1285: END;
1286:
1287: UPDATE igr_is_address SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1288: ELSE /* l_status = 0 i.e Validation failed*/
1289: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1290: fnd_message.set_token('TABLE_NAME','igs_ad_addrusage_int');
1291: fnd_message.set_token('COL_NAMES',l_tokenstr);