APPS.AD_FILE_UTIL dependencies on AD_PATCH_RUN_BUGS

Line 1769: -- Add new entries in the AD_PATCH_RUN_BUGS

1765: --
1766: --
1767: commit;
1768: --
1769: -- Add new entries in the AD_PATCH_RUN_BUGS
1770: --
1771: insert into ad_patch_run_bugs
1772: (
1773: PATCH_RUN_BUG_ID,

Line 1771: insert into ad_patch_run_bugs

1767: commit;
1768: --
1769: -- Add new entries in the AD_PATCH_RUN_BUGS
1770: --
1771: insert into ad_patch_run_bugs
1772: (
1773: PATCH_RUN_BUG_ID,
1774: PATCH_RUN_ID, BUG_ID, ORIG_BUG_NUMBER, APPLICATION_SHORT_NAME,
1775: SUCCESS_FLAG, APPLIED_FLAG, REASON_NOT_APPLIED,

Line 1779: ad_patch_run_bugs_s.nextval,

1775: SUCCESS_FLAG, APPLIED_FLAG, REASON_NOT_APPLIED,
1776: CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
1777: )
1778: select
1779: ad_patch_run_bugs_s.nextval,
1780: patch_run_id, bug_id, orig_bug_number,bug_app_short_name,
1781: success_flag, applied_flag, reason_not_applied,
1782: sysdate, sysdate, 5, 5
1783: from (

Line 1794: from ad_patch_run_bugs b

1790: where
1791: not exists (
1792: select
1793: 'x'
1794: from ad_patch_run_bugs b
1795: where
1796: b.PATCH_RUN_ID = t.patch_run_id
1797: and b.BUG_ID = t.bug_id
1798: and b.ORIG_BUG_NUMBER = t.orig_bug_number

Line 1811: ad_patch_run_bugs b

1807: set PATCH_RUN_BUG_ID
1808: =(select
1809: b.PATCH_RUN_BUG_ID
1810: from
1811: ad_patch_run_bugs b
1812: where
1813: b.PATCH_RUN_ID = t.patch_run_id
1814: and b.BUG_ID = t.bug_id
1815: and b.ORIG_BUG_NUMBER = t.orig_bug_number