14: p_full_refresh IN VARCHAR2 DEFAULT 'N'
15: ) IS
16: CURSOR min_log_date IS
17: SELECT TRUNC(MIN(start_date))
18: FROM bim_rep_history ;
19:
20: cursor max_log_date IS
21: select TRUNC(max(object_last_updated_date))
22: from bim_rep_history
18: FROM bim_rep_history ;
19:
20: cursor max_log_date IS
21: select TRUNC(max(object_last_updated_date))
22: from bim_rep_history
23: where object='DATES';
24: v_error_code NUMBER;
25: v_error_text VARCHAR2(1500);
26: l_start_date DATE;
109: END LOOP;
110:
111: dbms_sql.close_cursor(ddl_curs);
112:
113: DELETE bim_rep_history
114: WHERE object = 'CAMPAIGN';
115:
116: END IF;
117:
130: END LOOP;
131:
132: dbms_sql.close_cursor(ddl_curs);
133:
134: DELETE bim_rep_history
135: WHERE object = 'EVENT';
136:
137: END IF;
138:
151: END LOOP;
152:
153: dbms_sql.close_cursor(ddl_curs);
154:
155: DELETE BIM_REP_HISTORY
156: WHERE object = 'FUND';
157:
158: END IF;
159:
172: END LOOP;
173:
174: dbms_sql.close_cursor (ddl_curs);
175:
176: DELETE BIM_REP_HISTORY
177: WHERE object = 'LEADS';
178:
179: END IF;
180:
193: END LOOP;
194:
195: dbms_sql.close_cursor (ddl_curs);
196:
197: DELETE BIM_REP_HISTORY
198: WHERE object = 'LEAD_IMPORT';
199:
200: END IF;
201:
214: END LOOP;
215:
216: dbms_sql.close_cursor (ddl_curs);
217:
218: DELETE BIM_REP_HISTORY
219: WHERE object = 'RESPONSE';
220:
221: END IF;
222:
233: dbms_sql.parse(ddl_curs, rec.sqlstmt,dbms_sql.native) ;
234:
235: END LOOP;
236:
237: DELETE bim_rep_history
238: WHERE object = 'CAMPAIGN';
239:
240: FOR rec in trunc_even_tables(l_schema) LOOP
241:
244: dbms_sql.parse(ddl_curs, rec.sqlstmt,dbms_sql.native) ;
245:
246: END LOOP;
247:
248: DELETE bim_rep_history
249: WHERE object = 'EVENT';
250:
251: FOR rec in trunc_fund_tables(l_schema) LOOP
252:
255: dbms_sql.parse(ddl_curs, rec.sqlstmt,dbms_sql.native) ;
256:
257: END LOOP;
258:
259: DELETE bim_rep_history
260: WHERE object = 'FUND';
261:
262:
263: FOR rec in trunc_lead_tables(l_schema) LOOP
267: dbms_sql.parse (ddl_curs, rec.sqlstmt, dbms_sql.native);
268:
269: END LOOP;
270:
271: DELETE BIM_REP_HISTORY
272: WHERE object = 'LEADS';
273:
274: FOR rec in trunc_limp_tables(l_schema) LOOP
275:
278: dbms_sql.parse (ddl_curs, rec.sqlstmt, dbms_sql.native);
279:
280: END LOOP;
281:
282: DELETE BIM_REP_HISTORY
283: WHERE object = 'LEAD_IMPORT';
284:
285: FOR rec in trunc_resp_tables(l_schema) LOOP
286:
289: dbms_sql.parse (ddl_curs, rec.sqlstmt, dbms_sql.native);
290:
291: END LOOP;
292:
293: DELETE BIM_REP_HISTORY
294: WHERE object = 'RESPONSE';
295:
296: dbms_sql.close_cursor(ddl_curs);
297:
296: dbms_sql.close_cursor(ddl_curs);
297:
298: END IF;
299:
300: DELETE bim_rep_history
301: WHERE object = 'DATES';
302:
303: END IF;
304: