DBA Data[Home] [Help]

APPS.AD_PATCH_HIST_MIGR_PKG dependencies on AD_COMPRISING_PATCHES

Line 414: from ad_comprising_patches

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;

Line 422: insert into ad_comprising_patches

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

Line 428: ad_comprising_patches_s.nextval, l_patch_driver_id, l_bug_id,

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;