107: ) AND
108: pe.status IN (inserted,updated) AND
109: inq.status IN (inserted,updated);
110:
111: CURSOR inq_per_contacts_cur(l_person_id igr_is_contact.inq_person_id%TYPE) IS
112: SELECT
113: inq_contact_id,
114: inq_person_id,
115: request_id,
119: phone_extension,
120: phone_line_type,
121: email_address
122: FROM
123: igr_is_contact
124: WHERE
125: inq_person_id = l_person_id AND
126: status IN (inserted,updated);
127:
1134:
1135: END IF; -- kamohan Bug 2378114 End of Fix
1136:
1137: /* Update the Status of corresponding Self Service record to Transferred */
1138: UPDATE igr_is_contact SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1139: END LOOP;
1140:
1141: FOR inq_per_addr_rec IN inq_per_addr_cur(inq_rec.inq_person_id) LOOP
1142: /* Validate the data in Self Service table for not null before inseting into igs_ad_addr_int */