[Home] [Help]
101: -- In this case, we check on checksum, etc
102:
103: select patch_driver_id
104: into l_patch_driver_id
105: from ad_patch_drivers
106: where file_contents_checksum = p_chksum
107: and file_size = p_fil_size
108: and driver_file_name = p_drv_fil_nm;
109:
115: -- In this case, we check if its ever been export-imported before
116:
117: select patch_driver_id
118: into l_patch_driver_id
119: from ad_patch_drivers
120: where imported_from_db = p_exported_from_db
121: and imported_id = p_src_ptch_drvr_id;
122:
123: end if; -- end if src-cd = DRV/TXT
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
182:
183: insert into ad_patch_drivers
184: (
185: patch_driver_id,
186: applied_patch_id, driver_file_name,
187: driver_type_c_flag, driver_type_d_flag, driver_type_g_flag,
192: creation_date, last_update_date, last_updated_by, created_by,
193: imported_flag, imported_from_db, imported_id
194: ) values
195: (
196: ad_patch_drivers_s.nextval,
197: l_applied_patch_id, p_drv_fil_nm,
198: p_drv_typ_cflag, p_drv_typ_dflag, p_drv_typ_gflag,
199: p_plat, p_platver,
200: p_fil_size, p_chksum,
226: sysdate, sysdate, G_WHO_USER_ID, G_WHO_USER_ID,
227: 'Y', p_exported_from_db, p_src_ap_app_ptch_id
228: ) returning applied_patch_id into l_applied_patch_id;
229:
230: insert into ad_patch_drivers
231: (
232: patch_driver_id,
233: applied_patch_id, driver_file_name,
234: driver_type_c_flag, driver_type_d_flag, driver_type_g_flag,
239: creation_date, last_update_date, last_updated_by, created_by,
240: imported_flag, imported_from_db, imported_id
241: ) values
242: (
243: ad_patch_drivers_s.nextval,
244: l_applied_patch_id, p_drv_fil_nm,
245: p_drv_typ_cflag, p_drv_typ_dflag, p_drv_typ_gflag,
246: p_plat, p_platver,
247: p_fil_size, p_chksum,