APPS.IGR_IMP_001 dependencies on IGR_IS_EXTRACURR

Line 168: CURSOR inq_per_extra_cur(l_person_id igr_is_extracurr.inq_person_id%TYPE) IS

164: WHERE
165: inq_person_id = l_person_id AND
166: status IN (inserted,updated);
167:
168: CURSOR inq_per_extra_cur(l_person_id igr_is_extracurr.inq_person_id%TYPE) IS
169: SELECT
170: interest_type_code,
171: interest_name,
172: activity_source_cd,

Line 176: igr_is_extracurr

172: activity_source_cd,
173: start_date,
174: end_date
175: FROM
176: igr_is_extracurr
177: WHERE
178: inq_person_id = l_person_id AND
179: status IN (inserted,updated);
180:

Line 181: CURSOR inq_sub_interest_type_cur (cp_interest_type_code igr_is_extracurr.interest_type_code%TYPE) IS

177: WHERE
178: inq_person_id = l_person_id AND
179: status IN (inserted,updated);
180:
181: CURSOR inq_sub_interest_type_cur (cp_interest_type_code igr_is_extracurr.interest_type_code%TYPE) IS
182: SELECT
183: lookup_type
184: FROM
185: fnd_lookup_values

Line 1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

1518: fnd_file.put_line(fnd_file.log,'Insert on IGS_AD_EXCURR_INT failed '||SQLERRM);
1519: RAISE;
1520: END;
1521:
1522: UPDATE igr_is_extracurr SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1523: ELSE /* l_status = 0 i.e Validation failed*/
1524: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1525: fnd_message.set_token('TABLE_NAME','igs_ad_excurr_int');
1526: fnd_message.set_token('COL_NAMES',l_tokenstr);