APPS.PAY_KW_XDO_TEMPLATE dependencies on PER_GB_XDO_TEMPLATES

Line 24: DELETE FROM per_gb_xdo_templates

20: FROM fnd_lobs
21: WHERE file_id = p_file_id;
22:
23: -- the delete will ensure that the patch is rerunnable!
24: DELETE FROM per_gb_xdo_templates
25: WHERE file_name = l_file_name AND
26: effective_start_date = l_start_date AND
27: effective_end_date = l_end_date;
28:

Line 29: INSERT INTO per_gb_xdo_templates

25: WHERE file_name = l_file_name AND
26: effective_start_date = l_start_date AND
27: effective_end_date = l_end_date;
28:
29: INSERT INTO per_gb_xdo_templates
30: (file_id,
31: file_name,
32: file_description,
33: effective_start_date,

Line 61: DELETE FROM per_gb_xdo_templates

57: FROM fnd_lobs
58: WHERE file_id = p_file_id;
59:
60: -- the delete will ensure that the patch is rerunnable!
61: DELETE FROM per_gb_xdo_templates
62: WHERE file_name = l_file_name AND
63: effective_start_date = l_start_date AND
64: effective_end_date = l_end_date;
65:

Line 66: INSERT INTO per_gb_xdo_templates

62: WHERE file_name = l_file_name AND
63: effective_start_date = l_start_date AND
64: effective_end_date = l_end_date;
65:
66: INSERT INTO per_gb_xdo_templates
67: (file_id,
68: file_name,
69: file_description,
70: effective_start_date,

Line 100: DELETE FROM per_gb_xdo_templates

96: FROM fnd_lobs
97: WHERE file_id = p_file_id;
98:
99: -- the delete will ensure that the patch is rerunnable!
100: DELETE FROM per_gb_xdo_templates
101: WHERE file_name = l_file_name AND
102: effective_start_date = l_start_date AND
103: effective_end_date = l_end_date;
104:

Line 105: INSERT INTO per_gb_xdo_templates

101: WHERE file_name = l_file_name AND
102: effective_start_date = l_start_date AND
103: effective_end_date = l_end_date;
104:
105: INSERT INTO per_gb_xdo_templates
106: (file_id,
107: file_name,
108: file_description,
109: effective_start_date,

Line 141: DELETE FROM per_gb_xdo_templates

137: FROM fnd_lobs
138: WHERE file_id = p_file_id;
139:
140: -- the delete will ensure that the patch is rerunnable!
141: DELETE FROM per_gb_xdo_templates
142: WHERE file_name = l_file_name AND
143: effective_start_date = l_start_date AND
144: effective_end_date = l_end_date;
145:

Line 146: INSERT INTO per_gb_xdo_templates

142: WHERE file_name = l_file_name AND
143: effective_start_date = l_start_date AND
144: effective_end_date = l_end_date;
145:
146: INSERT INTO per_gb_xdo_templates
147: (file_id,
148: file_name,
149: file_description,
150: effective_start_date,

Line 169: ad_zd_seed.prepare('PER_GB_XDO_TEMPLATES'); -- bug 16398512

165: l_start_date DATE ;
166: l_end_date DATE ;
167: BEGIN
168:
169: ad_zd_seed.prepare('PER_GB_XDO_TEMPLATES'); -- bug 16398512
170:
171: L_START_DATE := TO_DATE('10/01/2012', 'mm/dd/yyyy');
172: l_end_date := TO_DATE('12/31/4712', 'mm/dd/yyyy');
173: -- program_name will be used to store the file_name

Line 182: DELETE FROM per_gb_xdo_templates

178: FROM fnd_lobs
179: WHERE file_id = p_file_id;
180:
181: -- the delete will ensure that the patch is rerunnable!
182: DELETE FROM per_gb_xdo_templates
183: WHERE file_name = l_file_name AND
184: effective_start_date = l_start_date AND
185: effective_end_date = l_end_date;
186:

Line 187: INSERT INTO per_gb_xdo_templates

183: WHERE file_name = l_file_name AND
184: effective_start_date = l_start_date AND
185: effective_end_date = l_end_date;
186:
187: INSERT INTO per_gb_xdo_templates
188: (file_id,
189: file_name,
190: file_description,
191: effective_start_date,