eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_PATCH_HIST_MIGR_PKG dependencies on AD_APPLIED_PATCHES

Line 177: from ad_applied_patches

173:
174: begin
175: select applied_patch_id
176: into l_applied_patch_id
177: from ad_applied_patches
178: where imported_from_db = p_exported_from_db
179: and imported_id = p_src_ap_app_ptch_id;
180:
181: -- Found an APP-PTCH => only need to create a PTCH-DRVR for that APP-PTCH

Line 213: insert into ad_applied_patches

209: exception when no_data_found then
210:
211: -- Need to create an APP-PTCH as well as a PTCH-DRVR row
212:
213: insert into ad_applied_patches
214: (
215: applied_patch_id,
216: rapid_installed_flag, patch_name,
217: patch_type, maint_pack_level, source_code,

Line 223: ad_applied_patches_s.nextval,

219: imported_flag, imported_from_db,
220: imported_id
221: ) values
222: (
223: ad_applied_patches_s.nextval,
224: p_ap_rapid_installed_flag, p_ap_ptch_nm,
225: p_ap_ptch_typ, p_ap_mtpk_lvl, p_ap_src_cd,
226: sysdate, sysdate, G_WHO_USER_ID, G_WHO_USER_ID,
227: 'Y', p_exported_from_db, p_src_ap_app_ptch_id