APPS.IGR_IMP_001 dependencies on IGR_I_PKG_INT

Line 1689: INSERT INTO igr_i_pkg_int

1685: /* Validate the data in Self Service table for not null before inseting into igs_ad_inq_pkg_int */
1686: validate_inq_pkg_int(INQ_INFO_rec,l_status,l_tokenstr);
1687: IF l_status = 1 THEN /*Validation Successfull*/
1688: BEGIN
1689: INSERT INTO igr_i_pkg_int
1690: (
1691: interface_inq_pkg_id ,
1692: interface_inq_appl_id ,
1693: package_item_id ,

Line 1708: igr_i_pkg_int_s.nextval ,

1704: program_id ,
1705: program_update_date
1706: ) VALUES
1707: (
1708: igr_i_pkg_int_s.nextval ,
1709: igr_i_appl_int_s.currval ,
1710: inq_info_rec.package_item_id ,
1711: '2' ,
1712: null ,

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

1722: sysdate
1723: );
1724: EXCEPTION WHEN OTHERS THEN
1725: l_status:=0;
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;