160: 'Y'
161: INTO
162: l_attachment_exists
163: from
164: fnd_attached_documents fad
165: where
166: fad.entity_name = 'EAM_WORK_REQUESTS' and
167: fad.pk1_value = to_char(p_eam_request_rec.request_id) and
168: rownum<2;
174:
175:
176: IF l_attachment_exists <> 'N' THEN
177:
178: fnd_attached_documents2_pkg.copy_attachments(
179: X_from_entity_name => 'EAM_WORK_REQUESTS',
180: X_from_pk1_value => to_char(p_eam_request_rec.request_id),
181: X_from_pk2_value => '',
182: X_from_pk3_value => '',