APPS.CN_PURGE_PKG dependencies on CN_TRX

Line 251: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES

247: WHERE salesrep_id = x_salesrep_id
248: AND period_id between l_start_period_id and l_end_period_id);
249: COMMIT;
250:
251: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
252: DELETE FROM CN_COMM_LINES_API
253: WHERE (employee_number, type) = (SELECT employee_number, type FROM cn_salesreps WHERE salesrep_id = x_salesrep_id)
254: AND processed_date between l_start_date and l_end_date;
255: COMMIT;

Line 259: FROM cn_trx

255: COMMIT;
256:
257: DELETE FROM cn_not_trx
258: WHERE source_trx_id IN (SELECT source_trx_id
259: FROM cn_trx
260: WHERE trx_id IN (SELECT trx_id
261: FROM cn_trx_sales_lines
262: WHERE salesrep_id = x_salesrep_id
263: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));

Line 261: FROM cn_trx_sales_lines

257: DELETE FROM cn_not_trx
258: WHERE source_trx_id IN (SELECT source_trx_id
259: FROM cn_trx
260: WHERE trx_id IN (SELECT trx_id
261: FROM cn_trx_sales_lines
262: WHERE salesrep_id = x_salesrep_id
263: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));
264: COMMIT;
265:

Line 266: DELETE FROM cn_trx

262: WHERE salesrep_id = x_salesrep_id
263: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));
264: COMMIT;
265:
266: DELETE FROM cn_trx
267: WHERE trx_id IN (SELECT trx_id
268: FROM cn_trx_sales_lines
269: WHERE salesrep_id = x_salesrep_id
270: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);

Line 268: FROM cn_trx_sales_lines

264: COMMIT;
265:
266: DELETE FROM cn_trx
267: WHERE trx_id IN (SELECT trx_id
268: FROM cn_trx_sales_lines
269: WHERE salesrep_id = x_salesrep_id
270: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
271: COMMIT;
272:

Line 273: DELETE FROM cn_trx_lines

269: WHERE salesrep_id = x_salesrep_id
270: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
271: COMMIT;
272:
273: DELETE FROM cn_trx_lines
274: WHERE trx_line_id IN (SELECT trx_line_id
275: FROM cn_trx_sales_lines
276: WHERE salesrep_id = x_salesrep_id
277: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);

Line 275: FROM cn_trx_sales_lines

271: COMMIT;
272:
273: DELETE FROM cn_trx_lines
274: WHERE trx_line_id IN (SELECT trx_line_id
275: FROM cn_trx_sales_lines
276: WHERE salesrep_id = x_salesrep_id
277: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
278: COMMIT;
279:

Line 280: DELETE FROM CN_TRX_SALES_LINES

276: WHERE salesrep_id = x_salesrep_id
277: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
278: COMMIT;
279:
280: DELETE FROM CN_TRX_SALES_LINES
281: WHERE salesrep_id = x_salesrep_id
282: AND processed_period_id between l_start_period_id and l_end_period_id;
283: COMMIT;
284: ELSE

Line 485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES

481: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
482: AND period_id between l_start_period_id and l_end_period_id);
483: COMMIT;
484:
485: -- Delete transactions from CN_COMM_LINES_API, CN_NOT_TRX, CN_TRX, CN_TRX_LINES, CN_TRX_SALES_LINES
486: DELETE FROM CN_COMM_LINES_API
487: WHERE (employee_number, TYPE) IN (SELECT employee_number, TYPE FROM cn_salesreps)
488: AND processed_date between l_start_date and l_end_date;
489: COMMIT;

Line 493: FROM cn_trx

489: COMMIT;
490:
491: DELETE FROM cn_not_trx
492: WHERE source_trx_id IN (SELECT source_trx_id
493: FROM cn_trx
494: WHERE trx_id IN (SELECT trx_id
495: FROM cn_trx_sales_lines
496: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
497: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));

Line 495: FROM cn_trx_sales_lines

491: DELETE FROM cn_not_trx
492: WHERE source_trx_id IN (SELECT source_trx_id
493: FROM cn_trx
494: WHERE trx_id IN (SELECT trx_id
495: FROM cn_trx_sales_lines
496: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
497: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));
498: COMMIT;
499:

Line 500: DELETE FROM cn_trx

496: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
497: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id));
498: COMMIT;
499:
500: DELETE FROM cn_trx
501: WHERE trx_id IN (SELECT trx_id
502: FROM cn_trx_sales_lines
503: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
504: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);

Line 502: FROM cn_trx_sales_lines

498: COMMIT;
499:
500: DELETE FROM cn_trx
501: WHERE trx_id IN (SELECT trx_id
502: FROM cn_trx_sales_lines
503: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
504: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
505: COMMIT;
506:

Line 507: DELETE FROM cn_trx_lines

503: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
504: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
505: COMMIT;
506:
507: DELETE FROM cn_trx_lines
508: WHERE trx_line_id IN (SELECT trx_line_id
509: FROM cn_trx_sales_lines
510: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
511: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);

Line 509: FROM cn_trx_sales_lines

505: COMMIT;
506:
507: DELETE FROM cn_trx_lines
508: WHERE trx_line_id IN (SELECT trx_line_id
509: FROM cn_trx_sales_lines
510: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
511: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
512: COMMIT;
513:

Line 514: DELETE FROM CN_TRX_SALES_LINES

510: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
511: AND processed_period_id BETWEEN l_start_period_id AND l_end_period_id);
512: COMMIT;
513:
514: DELETE FROM CN_TRX_SALES_LINES
515: WHERE salesrep_id IN (SELECT salesrep_id FROM cn_salesreps)
516: AND processed_period_id between l_start_period_id and l_end_period_id;
517: COMMIT;
518: END IF;