2248:
2249: end loop;
2250: end;
2251: --
2252: -- Add new entries in the ad_patch_run_bug_actions
2253: --
2254: insert into AD_PATCH_RUN_BUG_ACTIONS
2255: (
2256: ACTION_ID,
2250: end;
2251: --
2252: -- Add new entries in the ad_patch_run_bug_actions
2253: --
2254: insert into AD_PATCH_RUN_BUG_ACTIONS
2255: (
2256: ACTION_ID,
2257: PATCH_RUN_BUG_ID,
2258: COMMON_ACTION_ID,
2264: DEST_FILE_ID, FILE_TYPE_FLAG,
2265: CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
2266: )
2267: select
2268: AD_PATCH_RUN_BUG_ACTIONS_S.NEXTVAL,
2269: t.patch_run_bug_id,
2270: t.common_action_id,
2271: t.file_id,
2272: t.patch_file_vers_id,
2278: where not exists
2279: (select
2280: 'x'
2281: from
2282: AD_PATCH_RUN_BUG_ACTIONS aprba
2283: where
2284: aprba.PATCH_RUN_BUG_ID = t.patch_run_bug_id
2285: and aprba.FILE_ID = t.file_id
2286: and aprba.COMMON_ACTION_ID = t.common_action_id)
2292: --
2293: --
2294: commit;
2295: --
2296: -- Add new entries in the ad_patch_run_bug_actions with loader files.
2297: -- bug 3486202, cbhati
2298: --
2299: insert into AD_PATCH_RUN_BUG_ACTIONS
2300: (
2295: --
2296: -- Add new entries in the ad_patch_run_bug_actions with loader files.
2297: -- bug 3486202, cbhati
2298: --
2299: insert into AD_PATCH_RUN_BUG_ACTIONS
2300: (
2301: ACTION_ID,
2302: PATCH_RUN_BUG_ID,
2303: COMMON_ACTION_ID,
2309: DEST_FILE_ID, FILE_TYPE_FLAG,
2310: CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
2311: )
2312: select
2313: AD_PATCH_RUN_BUG_ACTIONS_S.NEXTVAL,
2314: t.patch_run_bug_id,
2315: t.common_action_id,
2316: t.loader_data_file_id,
2317: t.patch_file_vers_id,
2323: where not exists
2324: (select
2325: 'x'
2326: from
2327: AD_PATCH_RUN_BUG_ACTIONS aprba
2328: where
2329: aprba.PATCH_RUN_BUG_ID = t.patch_run_bug_id
2330: and aprba.FILE_ID = t.loader_data_file_id
2331: and aprba.COMMON_ACTION_ID = t.common_action_id)