APPS.AD_FILE_UTIL dependencies on AD_PATCH_COMMON_ACTIONS

Line 2228: -- Add new entries in the ad_patch_common_actions

2224: --
2225: --
2226: commit;
2227: --
2228: -- Add new entries in the ad_patch_common_actions
2229: --
2230: INSERT INTO AD_PATCH_COMMON_ACTIONS
2231: (
2232: COMMON_ACTION_ID, ACTION_CODE, ACTION_PHASE, NUMERIC_PHASE,

Line 2230: INSERT INTO AD_PATCH_COMMON_ACTIONS

2226: commit;
2227: --
2228: -- Add new entries in the ad_patch_common_actions
2229: --
2230: INSERT INTO AD_PATCH_COMMON_ACTIONS
2231: (
2232: COMMON_ACTION_ID, ACTION_CODE, ACTION_PHASE, NUMERIC_PHASE,
2233: NUMERIC_SUB_PHASE, ACTION_ARGUMENTS, CHECKFILE_ARGS,
2234: ACTION_CHECK_OBJ, ACTION_CHECK_OBJ_USERNAME, ACTION_CHECK_OBJ_PASSWD,

Line 2239: select AD_PATCH_COMMON_ACTIONS_S.NEXTVAL,

2235: ACTION_WHAT_SQL_EXEC, ACTION_TIERLIST_IN_DRIVER, ACTION_LANG_CODE,
2236: CONCAT_ATTRIBS, LOADER_DATA_FILE_ID, CREATION_DATE,
2237: LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY
2238: )
2239: select AD_PATCH_COMMON_ACTIONS_S.NEXTVAL,
2240: t.action_code, t.action_phase, t.major_phase, t.minor_phase,
2241: t.action_arguments, t.checkfile_args, t.checkobj , t.checkobj_un ,
2242: t.checkobj_pw, t.action_modifier , t.action_tierlist ,
2243: t.action_lang_code , t.concat_attribs, t.loader_data_file_id,

Line 2258: AD_PATCH_COMMON_ACTIONS PCA

2254: where not exists (
2255: select
2256: 'x'
2257: FROM
2258: AD_PATCH_COMMON_ACTIONS PCA
2259: WHERE
2260: PCA.CONCAT_ATTRIBS = t.CONCAT_ATTRIBS)
2261: and t.concat_attribs is not null;
2262: --

Line 2270: AD_PATCH_COMMON_ACTIONS PCA

2266: set t.COMMON_ACTION_ID =
2267: (select
2268: PCA.COMMON_ACTION_ID
2269: from
2270: AD_PATCH_COMMON_ACTIONS PCA
2271: WHERE
2272: PCA.CONCAT_ATTRIBS = t.concat_attribs )
2273: where t.concat_attribs is not null;
2274: --