1441: INTO l_file_name
1442: FROM fnd_lobs
1443: WHERE file_id = p_file_id;
1444: -- the delete will ensure that the patch is rerunnable
1445: DELETE FROM per_gb_xdo_templates
1446: WHERE file_name = l_file_name AND
1447: effective_start_date = l_start_date AND
1448: effective_end_date = l_end_date;
1449: INSERT INTO per_gb_xdo_templates
1445: DELETE FROM per_gb_xdo_templates
1446: WHERE file_name = l_file_name AND
1447: effective_start_date = l_start_date AND
1448: effective_end_date = l_end_date;
1449: INSERT INTO per_gb_xdo_templates
1450: (file_id,
1451: file_name,
1452: file_description,
1453: effective_start_date,