410:
411: begin
412: select 'x'
413: into l_dummy
414: from ad_comprising_patches
415: where patch_driver_id = l_patch_driver_id
416: and bug_id = l_bug_id;
417:
418: return;
418: return;
419:
420: exception when no_data_found then
421:
422: insert into ad_comprising_patches
423: (
424: comprising_patch_id, patch_driver_id, bug_id,
425: creation_date, last_update_date, last_updated_by, created_by
426: ) values
424: comprising_patch_id, patch_driver_id, bug_id,
425: creation_date, last_update_date, last_updated_by, created_by
426: ) values
427: (
428: ad_comprising_patches_s.nextval, l_patch_driver_id, l_bug_id,
429: sysdate, sysdate, G_WHO_USER_ID, G_WHO_USER_ID
430: );
431:
432: end;