APPS.IGR_IMP_001 dependencies on IGR_IS_INFO_REQ

Line 216: CURSOR inq_info_cur(l_inq_id igr_is_info_req.inq_inq_id%TYPE) IS

212: WHERE
213: inq_test_id = l_test_id AND
214: status IN (inserted,updated);
215:
216: CURSOR inq_info_cur(l_inq_id igr_is_info_req.inq_inq_id%TYPE) IS
217: SELECT
218: package_item_id
219: FROM
220: igr_is_info_req

Line 220: igr_is_info_req

216: CURSOR inq_info_cur(l_inq_id igr_is_info_req.inq_inq_id%TYPE) IS
217: SELECT
218: package_item_id
219: FROM
220: igr_is_info_req
221: WHERE
222: inq_inq_id = l_inq_id AND
223: status IN (inserted,updated);
224:

Line 1730: UPDATE igr_is_info_req SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;

1726: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_PKG_INT failed '||SQLERRM);
1727: RAISE;
1728: END;
1729:
1730: UPDATE igr_is_info_req SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;
1731: ELSE /* l_status = 0 i.e Validation failed*/
1732: fnd_message.set_name('IGS','IGS_AD_SS_TO_INT_NULL_FAIL');
1733: fnd_message.set_token('TABLE_NAME','igs_ad_inq_pkg_int');
1734: fnd_message.set_token('COL_NAMES',l_tokenstr);