APPS.IGR_IMP_001 dependencies on IGR_IS_I_LINES

Line 231: CURSOR inq_lines_cur(l_inq_inq_id igr_is_i_lines.inq_inq_id%TYPE) IS

227: -- This cursor will return an empty record if lines table doesnt have
228: -- any record correspoding to the inquiry record
229: -- So that it will insert dummy record in the interface table
230:
231: CURSOR inq_lines_cur(l_inq_inq_id igr_is_i_lines.inq_inq_id%TYPE) IS
232: SELECT
233: preference,
234: product_category_id,
235: product_category_set_id

Line 237: igr_is_i_lines

233: preference,
234: product_category_id,
235: product_category_set_id
236: FROM
237: igr_is_i_lines
238: WHERE
239: inq_inq_id = l_inq_inq_id AND
240: status IN (inserted,updated);
241:

Line 1790: UPDATE igr_is_i_lines SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;

1786: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_LINES_INT failed '||SQLERRM);
1787: RAISE;
1788: END;
1789:
1790: UPDATE igr_is_i_lines SET status = 'T' WHERE inq_inq_id = inq_rec.inq_inq_id;
1791: END LOOP;
1792:
1793:
1794: