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_IMP_HEADERS

Line 237: elsif (p_table_name = 'CN_IMP_HEADERS') THEN

233: FROM cn_comm_lines_api_all c
234: WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id
235: )
236: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
237: elsif (p_table_name = 'CN_IMP_HEADERS') THEN
238: l_sql := 'DELETE
239: /*+ ROWID (ih) */
240: FROM cn_imp_headers ih
241: WHERE ih.imp_header_id IN ' || p_addnl_para ||

Line 240: FROM cn_imp_headers ih

236: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
237: elsif (p_table_name = 'CN_IMP_HEADERS') THEN
238: l_sql := 'DELETE
239: /*+ ROWID (ih) */
240: FROM cn_imp_headers ih
241: WHERE ih.imp_header_id IN ' || p_addnl_para ||
242: ' AND rowid BETWEEN ' || l_start_rowid || ' AND ' || l_end_rowid;
243: EXECUTE IMMEDIATE l_sql;
244: elsif (p_table_name = 'CN_IMP_LINES') THEN

Line 491: FROM cn_imp_headers h

487: IS
488: CURSOR c_overlaping_header_records
489: IS
490: SELECT DISTINCT h.imp_header_id
491: FROM cn_imp_headers h
492: WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id
493: and to_date(l.col3, 'dd-mm-rr') between x_start_date AND x_end_date
494: and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where
495: to_date(l2.col3, 'dd-mm-rr') not between x_start_date AND x_end_date

Line 727: l_table_name := 'cn_imp_headers';

723: p_addnl_para => l_imp_header_id_list,
724: x_row_to_process_flag => l_any_rows_to_process,
725: x_return_status => x_return_status );
726:
727: l_table_name := 'cn_imp_headers';
728:
729: delete_table ( p_start_period_id => p_start_period_id,
730: p_end_period_id => p_end_period_id,
731: x_start_date => x_start_date,

Line 797: FROM cn_imp_headers h

793: IS
794: CURSOR c_overlaping_header_records
795: IS
796: SELECT DISTINCT h.imp_header_id
797: FROM cn_imp_headers h
798: WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id
799: and to_date(l.col3, 'dd-mm-rr') between x_start_date AND x_end_date
800: and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where
801: to_date(l2.col3, 'dd-mm-rr') not between x_start_date AND x_end_date

Line 995: l_table_name := 'cn_imp_headers';

991: insert_archive(cn_imp_lines_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
992: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:13 x_msg_data ' || x_msg_data);
993:
994:
995: l_table_name := 'cn_imp_headers';
996: l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;
997:
998: EXECUTE IMMEDIATE l_sql INTO l_row_count;
999:

Line 996: l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;

992: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:13 x_msg_data ' || x_msg_data);
993:
994:
995: l_table_name := 'cn_imp_headers';
996: l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;
997:
998: EXECUTE IMMEDIATE l_sql INTO l_row_count;
999:
1000: x_msg_data := x_msg_data || 'cn_imp_headers count ' || l_row_count || ' : ';

Line 1000: x_msg_data := x_msg_data || 'cn_imp_headers count ' || l_row_count || ' : ';

996: l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;
997:
998: EXECUTE IMMEDIATE l_sql INTO l_row_count;
999:
1000: x_msg_data := x_msg_data || 'cn_imp_headers count ' || l_row_count || ' : ';
1001: x_msg_count := x_msg_count + 1;
1002: p_tot_rows_count := p_tot_rows_count + l_row_count;
1003: insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1004: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:12 x_msg_data ' || x_msg_data);

Line 1003: insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

999:
1000: x_msg_data := x_msg_data || 'cn_imp_headers count ' || l_row_count || ' : ';
1001: x_msg_count := x_msg_count + 1;
1002: p_tot_rows_count := p_tot_rows_count + l_row_count;
1003: insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1004: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:12 x_msg_data ' || x_msg_data);
1005:
1006:
1007: EXCEPTION

Line 2008: FROM cn_imp_headers h

2004: IS
2005: CURSOR c_overlaping_header_records
2006: IS
2007: SELECT DISTINCT h.imp_header_id
2008: FROM cn_imp_headers h
2009: WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id
2010: and to_date(l.col3, 'dd-mm-rr') between x_start_date AND x_end_date
2011: and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where
2012: to_date(l2.col3, 'dd-mm-rr') not between x_start_date AND x_end_date

Line 2272: l_table_name := 'cn_imp_headers' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');

2268: insert_archive(cn_imp_lines_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2269:
2270: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:11 x_msg_data ' || x_msg_data);
2271:
2272: l_table_name := 'cn_imp_headers' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2273: l_sql := 'Create table ' || l_table_name ;
2274: if(p_table_space is not null) Then
2275: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2276: end if;

Line 2277: l_sql := l_sql || ' as select * from cn_imp_headers ih where ih.imp_header_id in '

2273: l_sql := 'Create table ' || l_table_name ;
2274: if(p_table_space is not null) Then
2275: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2276: end if;
2277: l_sql := l_sql || ' as select * from cn_imp_headers ih where ih.imp_header_id in '
2278: || l_imp_header_id_list;
2279:
2280: EXECUTE immediate l_sql;
2281:

Line 2282: l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;

2278: || l_imp_header_id_list;
2279:
2280: EXECUTE immediate l_sql;
2281:
2282: l_sql := 'SELECT COUNT(*) FROM cn_imp_headers ih WHERE ih.imp_header_id IN ' || l_imp_header_id_list;
2283:
2284: EXECUTE IMMEDIATE l_sql INTO l_row_count;
2285: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2286: x_msg_count := x_msg_count + 1;

Line 2288: insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2284: EXECUTE IMMEDIATE l_sql INTO l_row_count;
2285: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2286: x_msg_count := x_msg_count + 1;
2287: p_tot_rows_count := p_tot_rows_count + l_row_count;
2288: insert_archive(cn_imp_headers_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2289:
2290: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:12 x_msg_data ' || x_msg_data);
2291:
2292: