APPS.CN_PURGE_PKG dependencies on CN_TRX_LINES

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 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 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 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);