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_LINES_ALL

Line 206: elsif (p_table_name = 'CN_TRX_LINES_ALL') THEN

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
208: /*+ ROWID (t1) */
209: FROM cn_trx_lines_all tl
210: WHERE tl.TRX_ID IN

Line 209: FROM cn_trx_lines_all tl

205: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
206: elsif (p_table_name = 'CN_TRX_LINES_ALL') THEN
207: DELETE
208: /*+ ROWID (t1) */
209: FROM cn_trx_lines_all tl
210: WHERE tl.TRX_ID IN
211: (SELECT DISTINCT t.TRX_ID
212: FROM cn_trx_all t
213: WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date

Line 620: l_table_name := 'cn_trx_lines_all';

616: x_row_to_process_flag => l_any_rows_to_process,
617: x_return_status => x_return_status );
618:
619:
620: l_table_name := 'cn_trx_lines_all';
621:
622: delete_table ( p_start_period_id => p_start_period_id,
623: p_end_period_id => p_end_period_id,
624: x_start_date => x_start_date,

Line 901: l_table_name := 'cn_trx_lines_all';

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(*)
903: INTO l_row_count
904: FROM cn_trx_lines_all tl
905: WHERE tl.TRX_ID IN

Line 904: FROM cn_trx_lines_all tl

900:
901: l_table_name := 'cn_trx_lines_all';
902: SELECT COUNT(*)
903: INTO l_row_count
904: FROM cn_trx_lines_all tl
905: WHERE tl.TRX_ID IN
906: (SELECT DISTINCT t.TRX_ID
907: FROM cn_trx_all t
908: WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date

Line 911: x_msg_data := x_msg_data || 'cn_trx_lines_all count ' || l_row_count || ' : ';

907: FROM cn_trx_all t
908: WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date
909: );
910:
911: x_msg_data := x_msg_data || 'cn_trx_lines_all count ' || l_row_count || ' : ';
912: x_msg_count := x_msg_count + 1;
913: p_tot_rows_count := p_tot_rows_count + l_row_count;
914: insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
915: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:8 x_msg_data ' || x_msg_data);

Line 914: insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

910:
911: x_msg_data := x_msg_data || 'cn_trx_lines_all count ' || l_row_count || ' : ';
912: x_msg_count := x_msg_count + 1;
913: p_tot_rows_count := p_tot_rows_count + l_row_count;
914: insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
915: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:8 x_msg_data ' || x_msg_data);
916:
917: l_table_name := 'cn_trx_all';
918: SELECT COUNT(*)

Line 2143: l_sql := l_sql || ' as select * from cn_trx_lines_all tl where tl.TRX_ID in (Select distinct t.TRX_ID from cn_trx_all t where TRUNC(t.processed_date) between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ' ) ';

2139: l_sql := 'Create table ' || l_table_name ;
2140: if(p_table_space is not null) Then
2141: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2142: end if;
2143: l_sql := l_sql || ' as select * from cn_trx_lines_all tl where tl.TRX_ID in (Select distinct t.TRX_ID from cn_trx_all t where TRUNC(t.processed_date) between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ' ) ';
2144: EXECUTE immediate l_sql;
2145:
2146: SELECT COUNT(*)
2147: INTO l_row_count

Line 2148: FROM cn_trx_lines_all tl

2144: EXECUTE immediate l_sql;
2145:
2146: SELECT COUNT(*)
2147: INTO l_row_count
2148: FROM cn_trx_lines_all tl
2149: WHERE tl.TRX_ID IN
2150: (SELECT DISTINCT t.TRX_ID
2151: FROM cn_trx_all t
2152: WHERE TRUNC(t.processed_date) BETWEEN x_start_date AND x_end_date

Line 2157: insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2153: );
2154: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2155: x_msg_count := x_msg_count + 1;
2156: p_tot_rows_count := p_tot_rows_count + l_row_count;
2157: insert_archive(cn_trx_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2158:
2159: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:7 x_msg_data ' || x_msg_data);
2160: l_table_name := 'cn_trx' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2161: l_sql := 'Create table ' || l_table_name ;