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_ALL

Line 212: FROM cn_trx_all t

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
214: );
215: elsif (p_table_name = 'CN_TRX_ALL') THEN
216: DELETE

Line 215: elsif (p_table_name = 'CN_TRX_ALL') THEN

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
214: );
215: elsif (p_table_name = 'CN_TRX_ALL') THEN
216: DELETE
217: /*+ ROWID (cnh) */
218: FROM cn_trx_all cnh
219: WHERE processed_date BETWEEN x_start_date AND x_end_date

Line 218: FROM cn_trx_all cnh

214: );
215: elsif (p_table_name = 'CN_TRX_ALL') THEN
216: DELETE
217: /*+ ROWID (cnh) */
218: FROM cn_trx_all cnh
219: WHERE processed_date BETWEEN x_start_date AND x_end_date
220: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
221: elsif (p_table_name = 'CN_NOT_TRX_ALL') THEN
222: DELETE

Line 637: l_table_name := 'cn_trx_all';

633: x_row_to_process_flag => l_any_rows_to_process,
634: x_return_status => x_return_status );
635:
636:
637: l_table_name := 'cn_trx_all';
638:
639: delete_table ( p_start_period_id => p_start_period_id,
640: p_end_period_id => p_end_period_id,
641: x_start_date => x_start_date,

Line 907: FROM cn_trx_all t

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
909: );
910:
911: x_msg_data := x_msg_data || 'cn_trx_lines_all count ' || l_row_count || ' : ';

Line 917: l_table_name := 'cn_trx_all';

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(*)
919: INTO l_row_count
920: FROM cn_trx_all
921: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;

Line 920: FROM cn_trx_all

916:
917: l_table_name := 'cn_trx_all';
918: SELECT COUNT(*)
919: INTO l_row_count
920: FROM cn_trx_all
921: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
922:
923: x_msg_data := x_msg_data || 'cn_trx_all count ' || l_row_count || ' : ';
924: x_msg_count := x_msg_count + 1;

Line 923: x_msg_data := x_msg_data || 'cn_trx_all count ' || l_row_count || ' : ';

919: INTO l_row_count
920: FROM cn_trx_all
921: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
922:
923: x_msg_data := x_msg_data || 'cn_trx_all count ' || l_row_count || ' : ';
924: x_msg_count := x_msg_count + 1;
925: p_tot_rows_count := p_tot_rows_count + l_row_count;
926: insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
927: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:9 x_msg_data ' || x_msg_data);

Line 926: insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

922:
923: x_msg_data := x_msg_data || 'cn_trx_all count ' || l_row_count || ' : ';
924: x_msg_count := x_msg_count + 1;
925: p_tot_rows_count := p_tot_rows_count + l_row_count;
926: insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
927: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:9 x_msg_data ' || x_msg_data);
928:
929: l_table_name := 'cn_not_trx_all';
930: 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 2151: FROM cn_trx_all t

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
2153: );
2154: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2155: x_msg_count := x_msg_count + 1;

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

2161: l_sql := 'Create table ' || l_table_name ;
2162: if(p_table_space is not null) Then
2163: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2164: end if;
2165: l_sql := l_sql || ' as select * from cn_trx_all where TRUNC(processed_date) between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';
2166: EXECUTE immediate l_sql;
2167:
2168: SELECT COUNT(*)
2169: INTO l_row_count

Line 2170: FROM cn_trx_all

2166: EXECUTE immediate l_sql;
2167:
2168: SELECT COUNT(*)
2169: INTO l_row_count
2170: FROM cn_trx_all
2171: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
2172: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2173: x_msg_count := x_msg_count + 1;
2174: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2175: insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2171: WHERE TRUNC(processed_date) BETWEEN x_start_date AND x_end_date;
2172: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2173: x_msg_count := x_msg_count + 1;
2174: p_tot_rows_count := p_tot_rows_count + l_row_count;
2175: insert_archive(cn_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2176:
2177: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:8 x_msg_data ' || x_msg_data);
2178: l_table_name := 'cn_not_trx' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2179: l_sql := 'Create table ' || l_table_name ;