16: FROM fnd_lobs
17: WHERE file_id = p_file_id;
18:
19: -- the delete will ensure that the patch is rerunnable!
20: DELETE FROM per_gb_xdo_templates
21: WHERE file_name = l_file_name AND
22: effective_start_date = l_start_date AND
23: effective_end_date = l_end_date;
24:
21: WHERE file_name = l_file_name AND
22: effective_start_date = l_start_date AND
23: effective_end_date = l_end_date;
24:
25: INSERT INTO per_gb_xdo_templates
26: (file_id,
27: file_name,
28: file_description,
29: effective_start_date,
50: FROM fnd_lobs
51: WHERE file_id = p_file_id;
52:
53: -- the delete will ensure that the patch is rerunnable!
54: DELETE FROM per_gb_xdo_templates
55: WHERE file_name = l_file_name AND
56: effective_start_date = l_start_date AND
57: effective_end_date = l_end_date;
58:
55: WHERE file_name = l_file_name AND
56: effective_start_date = l_start_date AND
57: effective_end_date = l_end_date;
58:
59: INSERT INTO per_gb_xdo_templates
60: (file_id,
61: file_name,
62: file_description,
63: effective_start_date,
84: FROM fnd_lobs
85: WHERE file_id = p_file_id;
86:
87: -- the delete will ensure that the patch is rerunnable!
88: DELETE FROM per_gb_xdo_templates
89: WHERE file_name = l_file_name AND
90: effective_start_date = l_start_date AND
91: effective_end_date = l_end_date;
92:
89: WHERE file_name = l_file_name AND
90: effective_start_date = l_start_date AND
91: effective_end_date = l_end_date;
92:
93: INSERT INTO per_gb_xdo_templates
94: (file_id,
95: file_name,
96: file_description,
97: effective_start_date,