APPS.IGR_IMP_001 dependencies on IGR_I_LINES_INT

Line 1745: INSERT INTO igr_i_lines_int

1741: FOR inq_lines_rec IN inq_lines_cur(inq_rec.inq_inq_id) LOOP
1742: /* No validation required for the data that is comming from SS Table -
1743: we just need to transfer this data to the interface table */
1744: BEGIN
1745: INSERT INTO igr_i_lines_int
1746: (
1747: interface_lines_id ,
1748: interface_inq_appl_id ,
1749: preference ,

Line 1766: igr_i_lines_int_s.nextval,

1762: program_id ,
1763: program_update_date
1764: ) VALUES
1765: (
1766: igr_i_lines_int_s.nextval,
1767: igr_i_appl_int_s.currval,
1768: inq_lines_rec.preference,
1769: inq_lines_rec.product_category_id ,
1770: inq_lines_rec.product_category_set_id ,

Line 1786: fnd_file.put_line(fnd_file.log,'Insert on IGR_I_LINES_INT failed '||SQLERRM);

1782: sysdate
1783: );
1784: EXCEPTION WHEN OTHERS THEN
1785: l_status:=0;
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;