APPS.IGW_PROP dependencies on IGW_PROP_LOCATIONS

Line 648: INSERT INTO igw_prop_locations

644:
645: PROCEDURE copy_locations
646: ( p_old_proposal_id number, p_new_proposal_id number ) IS
647: BEGIN
648: INSERT INTO igw_prop_locations
649: (
650: prop_location_id,
651: proposal_id,
652: performing_organization_id,

Line 662: igw_prop_locations_s.nextval,

658: created_by,
659: last_update_login
660: )
661: SELECT
662: igw_prop_locations_s.nextval,
663: p_new_proposal_id,
664: performing_organization_id,
665: party_id,
666: 1,

Line 673: igw_prop_locations

669: SYSDATE,
670: FND_GLOBAL.USER_ID,
671: FND_GLOBAL.LOGIN_ID
672: FROM
673: igw_prop_locations
674: WHERE
675: proposal_id = p_old_proposal_id;
676: EXCEPTION
677: WHEN OTHERS THEN