eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PURGE_TABLES_PVT dependencies on CN_TRX_SALES_LINES_ALL

Line 200: elsif (p_table_name = 'CN_TRX_SALES_LINES_ALL') THEN

196: /*+ ROWID (cnh) */
197: FROM cn_commission_headers_all cnh
198: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
199: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
200: elsif (p_table_name = 'CN_TRX_SALES_LINES_ALL') THEN
201: DELETE
202: /*+ ROWID (cnh) */
203: FROM cn_trx_sales_lines_all cnh
204: WHERE processed_date BETWEEN x_start_date AND x_end_date

Line 203: FROM cn_trx_sales_lines_all cnh

199: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
200: elsif (p_table_name = 'CN_TRX_SALES_LINES_ALL') THEN
201: DELETE
202: /*+ ROWID (cnh) */
203: FROM cn_trx_sales_lines_all cnh
204: WHERE processed_date BETWEEN x_start_date AND x_end_date
205: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
206: elsif (p_table_name = 'CN_TRX_LINES_ALL') THEN
207: DELETE

Line 603: l_table_name := 'cn_trx_sales_lines_all';

599: x_row_to_process_flag => l_any_rows_to_process,
600: x_return_status => x_return_status );
601:
602:
603: l_table_name := 'cn_trx_sales_lines_all';
604:
605: delete_table ( p_start_period_id => p_start_period_id,
606: p_end_period_id => p_end_period_id,
607: x_start_date => x_start_date,

Line 889: l_table_name := 'cn_trx_sales_lines_all';

885: p_tot_rows_count := p_tot_rows_count + l_row_count;
886: insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
887: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:6 x_msg_data ' || x_msg_data);
888:
889: l_table_name := 'cn_trx_sales_lines_all';
890: SELECT COUNT(*)
891: INTO l_row_count
892: FROM cn_trx_sales_lines_all
893: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;

Line 892: FROM cn_trx_sales_lines_all

888:
889: l_table_name := 'cn_trx_sales_lines_all';
890: SELECT COUNT(*)
891: INTO l_row_count
892: FROM cn_trx_sales_lines_all
893: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
894:
895: x_msg_data := x_msg_data || 'cn_trx_sales_lines_all count ' || l_row_count || ' : ';
896: x_msg_count := x_msg_count + 1;

Line 895: x_msg_data := x_msg_data || 'cn_trx_sales_lines_all count ' || l_row_count || ' : ';

891: INTO l_row_count
892: FROM cn_trx_sales_lines_all
893: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
894:
895: x_msg_data := x_msg_data || 'cn_trx_sales_lines_all count ' || l_row_count || ' : ';
896: x_msg_count := x_msg_count + 1;
897: p_tot_rows_count := p_tot_rows_count + l_row_count;
898: insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
899: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:7 x_msg_data ' || x_msg_data);

Line 898: insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

894:
895: x_msg_data := x_msg_data || 'cn_trx_sales_lines_all count ' || l_row_count || ' : ';
896: x_msg_count := x_msg_count + 1;
897: p_tot_rows_count := p_tot_rows_count + l_row_count;
898: insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
899: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:7 x_msg_data ' || x_msg_data);
900:
901: l_table_name := 'cn_trx_lines_all';
902: SELECT COUNT(*)

Line 2125: l_sql := l_sql || ' as select * from cn_trx_sales_lines_all where TRUNC(processed_date) between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';

2121: l_sql := 'Create table ' || l_table_name ;
2122: if(p_table_space is not null) Then
2123: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2124: end if;
2125: l_sql := l_sql || ' as select * from cn_trx_sales_lines_all where TRUNC(processed_date) between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';
2126: EXECUTE immediate l_sql;
2127:
2128: SELECT COUNT(*)
2129: INTO l_row_count

Line 2130: FROM cn_trx_sales_lines_all

2126: EXECUTE immediate l_sql;
2127:
2128: SELECT COUNT(*)
2129: INTO l_row_count
2130: FROM cn_trx_sales_lines_all
2131: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
2132: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2133: x_msg_count := x_msg_count + 1;
2134: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2135: insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2131: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
2132: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2133: x_msg_count := x_msg_count + 1;
2134: p_tot_rows_count := p_tot_rows_count + l_row_count;
2135: insert_archive(cn_trx_sales_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2136:
2137: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:6.5 x_msg_data ' || x_msg_data);
2138: l_table_name := 'cn_trx_lines' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2139: l_sql := 'Create table ' || l_table_name ;