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_NOT_TRX_ALL

Line 221: elsif (p_table_name = 'CN_NOT_TRX_ALL') THEN

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
223: /*+ ROWID (cnh) */
224: FROM cn_not_trx_all cnh
225: WHERE processed_date BETWEEN x_start_date AND x_end_date

Line 224: FROM cn_not_trx_all cnh

220: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
221: elsif (p_table_name = 'CN_NOT_TRX_ALL') THEN
222: DELETE
223: /*+ ROWID (cnh) */
224: FROM cn_not_trx_all cnh
225: WHERE processed_date BETWEEN x_start_date AND x_end_date
226: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
227: elsif (p_table_name = 'CN_INVOICE_CHANGES_ALL') THEN
228: DELETE

Line 653: l_table_name := 'cn_not_trx_all';

649: p_addnl_para => '',
650: x_row_to_process_flag => l_any_rows_to_process,
651: x_return_status => x_return_status );
652:
653: l_table_name := 'cn_not_trx_all';
654:
655: delete_table ( p_start_period_id => p_start_period_id,
656: p_end_period_id => p_end_period_id,
657: x_start_date => x_start_date,

Line 929: l_table_name := 'cn_not_trx_all';

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(*)
931: INTO l_row_count
932: FROM cn_not_trx_all
933: WHERE processed_date BETWEEN x_start_date AND x_end_date;

Line 932: FROM cn_not_trx_all

928:
929: l_table_name := 'cn_not_trx_all';
930: SELECT COUNT(*)
931: INTO l_row_count
932: FROM cn_not_trx_all
933: WHERE processed_date BETWEEN x_start_date AND x_end_date;
934:
935: x_msg_data := x_msg_data || 'cn_not_trx_all count ' || l_row_count || ' : ';
936: x_msg_count := x_msg_count + 1;

Line 935: x_msg_data := x_msg_data || 'cn_not_trx_all count ' || l_row_count || ' : ';

931: INTO l_row_count
932: FROM cn_not_trx_all
933: WHERE processed_date BETWEEN x_start_date AND x_end_date;
934:
935: x_msg_data := x_msg_data || 'cn_not_trx_all count ' || l_row_count || ' : ';
936: x_msg_count := x_msg_count + 1;
937: p_tot_rows_count := p_tot_rows_count + l_row_count;
938: insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
939: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:10 x_msg_data ' || x_msg_data);

Line 938: insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

934:
935: x_msg_data := x_msg_data || 'cn_not_trx_all count ' || l_row_count || ' : ';
936: x_msg_count := x_msg_count + 1;
937: p_tot_rows_count := p_tot_rows_count + l_row_count;
938: insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
939: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:10 x_msg_data ' || x_msg_data);
940:
941: l_table_name := 'cn_invoice_changes_all';
942: SELECT COUNT(*)

Line 2183: l_sql := l_sql || ' as select * from cn_not_trx_all where processed_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';

2179: l_sql := 'Create table ' || l_table_name ;
2180: if(p_table_space is not null) Then
2181: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2182: end if;
2183: l_sql := l_sql || ' as select * from cn_not_trx_all where processed_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''';
2184: EXECUTE immediate l_sql;
2185:
2186: SELECT COUNT(*)
2187: INTO l_row_count

Line 2188: FROM cn_not_trx_all

2184: EXECUTE immediate l_sql;
2185:
2186: SELECT COUNT(*)
2187: INTO l_row_count
2188: FROM cn_not_trx_all
2189: WHERE processed_date BETWEEN x_start_date AND x_end_date;
2190: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2191: x_msg_count := x_msg_count + 1;
2192: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2193: insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2189: WHERE processed_date BETWEEN x_start_date AND x_end_date;
2190: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2191: x_msg_count := x_msg_count + 1;
2192: p_tot_rows_count := p_tot_rows_count + l_row_count;
2193: insert_archive(cn_not_trx_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2194:
2195: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:9 x_msg_data ' || x_msg_data);
2196: l_table_name := 'cn_invoice_chng' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2197: l_sql := 'Create table ' || l_table_name ;