APPS.AD_FILE_UTIL dependencies on AD_PATCH_RUN_BUG_ACTIONS

Line 2320: -- Add new entries in the ad_patch_run_bug_actions

2316:
2317: end loop;
2318: end;
2319: --
2320: -- Add new entries in the ad_patch_run_bug_actions
2321: --
2322: insert into AD_PATCH_RUN_BUG_ACTIONS
2323: (
2324: ACTION_ID,

Line 2322: insert into AD_PATCH_RUN_BUG_ACTIONS

2318: end;
2319: --
2320: -- Add new entries in the ad_patch_run_bug_actions
2321: --
2322: insert into AD_PATCH_RUN_BUG_ACTIONS
2323: (
2324: ACTION_ID,
2325: PATCH_RUN_BUG_ID,
2326: COMMON_ACTION_ID,

Line 2336: AD_PATCH_RUN_BUG_ACTIONS_S.NEXTVAL,

2332: DEST_FILE_ID, FILE_TYPE_FLAG,
2333: CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
2334: )
2335: select
2336: AD_PATCH_RUN_BUG_ACTIONS_S.NEXTVAL,
2337: t.patch_run_bug_id,
2338: t.common_action_id,
2339: t.file_id,
2340: t.patch_file_vers_id,

Line 2350: AD_PATCH_RUN_BUG_ACTIONS aprba

2346: where not exists
2347: (select
2348: 'x'
2349: from
2350: AD_PATCH_RUN_BUG_ACTIONS aprba
2351: where
2352: aprba.PATCH_RUN_BUG_ID = t.patch_run_bug_id
2353: and aprba.FILE_ID = t.file_id
2354: and aprba.COMMON_ACTION_ID = t.common_action_id)

Line 2364: -- Add new entries in the ad_patch_run_bug_actions with loader files.

2360: --
2361: --
2362: commit;
2363: --
2364: -- Add new entries in the ad_patch_run_bug_actions with loader files.
2365: -- bug 3486202, cbhati
2366: --
2367: insert into AD_PATCH_RUN_BUG_ACTIONS
2368: (

Line 2367: insert into AD_PATCH_RUN_BUG_ACTIONS

2363: --
2364: -- Add new entries in the ad_patch_run_bug_actions with loader files.
2365: -- bug 3486202, cbhati
2366: --
2367: insert into AD_PATCH_RUN_BUG_ACTIONS
2368: (
2369: ACTION_ID,
2370: PATCH_RUN_BUG_ID,
2371: COMMON_ACTION_ID,

Line 2381: AD_PATCH_RUN_BUG_ACTIONS_S.NEXTVAL,

2377: DEST_FILE_ID, FILE_TYPE_FLAG,
2378: CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
2379: )
2380: select
2381: AD_PATCH_RUN_BUG_ACTIONS_S.NEXTVAL,
2382: t.patch_run_bug_id,
2383: t.common_action_id,
2384: t.loader_data_file_id,
2385: t.patch_file_vers_id,

Line 2395: AD_PATCH_RUN_BUG_ACTIONS aprba

2391: where not exists
2392: (select
2393: 'x'
2394: from
2395: AD_PATCH_RUN_BUG_ACTIONS aprba
2396: where
2397: aprba.PATCH_RUN_BUG_ID = t.patch_run_bug_id
2398: and aprba.FILE_ID = t.loader_data_file_id
2399: and aprba.COMMON_ACTION_ID = t.common_action_id)