APPS.AD_FILE_UTIL dependencies on AD_PATCH_RUN_BUGS

Line 1837: -- Add new entries in the AD_PATCH_RUN_BUGS

1833: --
1834: --
1835: commit;
1836: --
1837: -- Add new entries in the AD_PATCH_RUN_BUGS
1838: --
1839: insert into ad_patch_run_bugs
1840: (
1841: PATCH_RUN_BUG_ID,

Line 1839: insert into ad_patch_run_bugs

1835: commit;
1836: --
1837: -- Add new entries in the AD_PATCH_RUN_BUGS
1838: --
1839: insert into ad_patch_run_bugs
1840: (
1841: PATCH_RUN_BUG_ID,
1842: PATCH_RUN_ID, BUG_ID, ORIG_BUG_NUMBER, APPLICATION_SHORT_NAME,
1843: SUCCESS_FLAG, APPLIED_FLAG, REASON_NOT_APPLIED,

Line 1847: ad_patch_run_bugs_s.nextval,

1843: SUCCESS_FLAG, APPLIED_FLAG, REASON_NOT_APPLIED,
1844: CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
1845: )
1846: select
1847: ad_patch_run_bugs_s.nextval,
1848: patch_run_id, bug_id, orig_bug_number,bug_app_short_name,
1849: success_flag, applied_flag, reason_not_applied,
1850: sysdate, sysdate, 5, 5
1851: from (

Line 1862: from ad_patch_run_bugs b

1858: where
1859: not exists (
1860: select
1861: 'x'
1862: from ad_patch_run_bugs b
1863: where
1864: b.PATCH_RUN_ID = t.patch_run_id
1865: and b.BUG_ID = t.bug_id
1866: and b.ORIG_BUG_NUMBER = t.orig_bug_number

Line 1879: ad_patch_run_bugs b

1875: set PATCH_RUN_BUG_ID
1876: =(select
1877: b.PATCH_RUN_BUG_ID
1878: from
1879: ad_patch_run_bugs b
1880: where
1881: b.PATCH_RUN_ID = t.patch_run_id
1882: and b.BUG_ID = t.bug_id
1883: and b.ORIG_BUG_NUMBER = t.orig_bug_number