APPS.AD_FILE_UTIL dependencies on AD_PATCH_COMMON_ACTIONS

Line 2160: -- Add new entries in the ad_patch_common_actions

2156: --
2157: --
2158: commit;
2159: --
2160: -- Add new entries in the ad_patch_common_actions
2161: --
2162: INSERT INTO AD_PATCH_COMMON_ACTIONS
2163: (
2164: COMMON_ACTION_ID, ACTION_CODE, ACTION_PHASE, NUMERIC_PHASE,

Line 2162: INSERT INTO AD_PATCH_COMMON_ACTIONS

2158: commit;
2159: --
2160: -- Add new entries in the ad_patch_common_actions
2161: --
2162: INSERT INTO AD_PATCH_COMMON_ACTIONS
2163: (
2164: COMMON_ACTION_ID, ACTION_CODE, ACTION_PHASE, NUMERIC_PHASE,
2165: NUMERIC_SUB_PHASE, ACTION_ARGUMENTS, CHECKFILE_ARGS,
2166: ACTION_CHECK_OBJ, ACTION_CHECK_OBJ_USERNAME, ACTION_CHECK_OBJ_PASSWD,

Line 2171: select AD_PATCH_COMMON_ACTIONS_S.NEXTVAL,

2167: ACTION_WHAT_SQL_EXEC, ACTION_TIERLIST_IN_DRIVER, ACTION_LANG_CODE,
2168: CONCAT_ATTRIBS, LOADER_DATA_FILE_ID, CREATION_DATE,
2169: LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
2170: )
2171: select AD_PATCH_COMMON_ACTIONS_S.NEXTVAL,
2172: t.action_code, t.action_phase, t.major_phase, t.minor_phase,
2173: t.action_arguments, t.checkfile_args, t.checkobj , t.checkobj_un ,
2174: t.checkobj_pw, t.action_modifier , t.action_tierlist ,
2175: t.action_lang_code , t.concat_attribs, t.loader_data_file_id,

Line 2190: AD_PATCH_COMMON_ACTIONS PCA

2186: where not exists (
2187: select
2188: 'x'
2189: FROM
2190: AD_PATCH_COMMON_ACTIONS PCA
2191: WHERE
2192: PCA.CONCAT_ATTRIBS = t.CONCAT_ATTRIBS)
2193: and t.concat_attribs is not null;
2194: --

Line 2202: AD_PATCH_COMMON_ACTIONS PCA

2198: set t.COMMON_ACTION_ID =
2199: (select
2200: PCA.COMMON_ACTION_ID
2201: from
2202: AD_PATCH_COMMON_ACTIONS PCA
2203: WHERE
2204: PCA.CONCAT_ATTRIBS = t.concat_attribs )
2205: where t.concat_attribs is not null;
2206: --