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_LINES

Line 244: elsif (p_table_name = 'CN_IMP_LINES') THEN

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
245: l_sql := 'DELETE
246: /*+ ROWID (cnh) */
247: FROM cn_imp_lines cnh
248: WHERE import_type_code = ''TRXAPI''

Line 247: FROM cn_imp_lines cnh

243: EXECUTE IMMEDIATE l_sql;
244: elsif (p_table_name = 'CN_IMP_LINES') THEN
245: l_sql := 'DELETE
246: /*+ ROWID (cnh) */
247: FROM cn_imp_lines cnh
248: WHERE import_type_code = ''TRXAPI''
249: AND imp_header_id IN ' || p_addnl_para ||
250: ' AND rowid BETWEEN ' || l_start_rowid || ' AND ' || l_end_rowid;
251: EXECUTE IMMEDIATE l_sql;

Line 492: WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id

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
496: ));

Line 494: and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where

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
496: ));
497:
498: l_imp_header_id number := 0;

Line 711: l_table_name := 'cn_imp_lines';

707: else
708: l_imp_header_id_list := '(' || l_imp_header_id_list || ')';
709: end if;
710: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions:11.4 l_imp_header_id_list ' || l_imp_header_id_list);
711: l_table_name := 'cn_imp_lines';
712:
713: delete_table ( p_start_period_id => p_start_period_id,
714: p_end_period_id => p_end_period_id,
715: x_start_date => x_start_date,

Line 747: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions Error (possible error may be cn_imp_lines for col3 date format iisue - ' || sqlerrm);

743:
744: EXCEPTION
745: WHEN OTHERS THEN
746: --x_return_status := 'F';
747: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions Error (possible error may be cn_imp_lines for col3 date format iisue - ' || sqlerrm);
748:
749: END;
750:
751: l_table_name := 'cn_comm_lines_api_all';

Line 798: WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id

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
802: ));

Line 800: and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where

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
802: ));
803:
804: l_imp_header_id number := 0;

Line 983: l_table_name := 'cn_imp_lines';

979: else
980: l_imp_header_id_list := '(' || l_imp_header_id_list || ')';
981: end if;
982: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:11.4 l_imp_header_id_list ' || l_imp_header_id_list);
983: l_table_name := 'cn_imp_lines';
984: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;
985:
986: EXECUTE IMMEDIATE l_sql INTO l_row_count;
987:

Line 984: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;

980: l_imp_header_id_list := '(' || l_imp_header_id_list || ')';
981: end if;
982: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:11.4 l_imp_header_id_list ' || l_imp_header_id_list);
983: l_table_name := 'cn_imp_lines';
984: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;
985:
986: EXECUTE IMMEDIATE l_sql INTO l_row_count;
987:
988: x_msg_data := x_msg_data || 'cn_imp_lines count ' || l_row_count || ' : ';

Line 988: x_msg_data := x_msg_data || 'cn_imp_lines count ' || l_row_count || ' : ';

984: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;
985:
986: EXECUTE IMMEDIATE l_sql INTO l_row_count;
987:
988: x_msg_data := x_msg_data || 'cn_imp_lines count ' || l_row_count || ' : ';
989: x_msg_count := x_msg_count + 1;
990: p_tot_rows_count := p_tot_rows_count + l_row_count;
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);

Line 991: insert_archive(cn_imp_lines_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

987:
988: x_msg_data := x_msg_data || 'cn_imp_lines count ' || l_row_count || ' : ';
989: x_msg_count := x_msg_count + 1;
990: p_tot_rows_count := p_tot_rows_count + l_row_count;
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';

Line 1010: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions Error (possible error may be cn_imp_lines for col3 date format iisue - ' || sqlerrm);

1006:
1007: EXCEPTION
1008: WHEN OTHERS THEN
1009: --x_return_status := 'F';
1010: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions Error (possible error may be cn_imp_lines for col3 date format iisue - ' || sqlerrm);
1011:
1012: END;
1013:
1014: l_table_name := 'cn_comm_lines_api_all';

Line 2009: WHERE exists (select distinct l.imp_header_id from cn_imp_lines l where h.imp_header_id = l.imp_header_id

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
2013: ));

Line 2011: and h.imp_header_id not in (select distinct l2.imp_header_id from cn_imp_lines l2 where

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
2013: ));
2014:
2015: l_imp_header_id number := 0;

Line 2249: l_table_name := 'cn_imp_lines' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');

2245: l_imp_header_id_list := '(' || l_imp_header_id_list || ')';
2246: end if;
2247:
2248: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.4 l_imp_header_id_list ' || l_imp_header_id_list);
2249: l_table_name := 'cn_imp_lines' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2250: l_sql := 'Create table ' || l_table_name ;
2251: if(p_table_space is not null) Then
2252: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2253: end if;

Line 2254: l_sql := l_sql || ' as select * from cn_imp_lines il where il.import_type_code = ''TRXAPI'' and il.imp_header_id in '

2250: l_sql := 'Create table ' || l_table_name ;
2251: if(p_table_space is not null) Then
2252: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2253: end if;
2254: l_sql := l_sql || ' as select * from cn_imp_lines il where il.import_type_code = ''TRXAPI'' and il.imp_header_id in '
2255: || l_imp_header_id_list;
2256:
2257: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.6 l_sql for cn_imp_lines : ' || l_sql);
2258:

Line 2257: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.6 l_sql for cn_imp_lines : ' || l_sql);

2253: end if;
2254: l_sql := l_sql || ' as select * from cn_imp_lines il where il.import_type_code = ''TRXAPI'' and il.imp_header_id in '
2255: || l_imp_header_id_list;
2256:
2257: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.6 l_sql for cn_imp_lines : ' || l_sql);
2258:
2259: EXECUTE immediate l_sql;
2260: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.7');
2261: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;

Line 2261: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;

2257: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.6 l_sql for cn_imp_lines : ' || l_sql);
2258:
2259: EXECUTE immediate l_sql;
2260: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.7');
2261: l_sql := 'SELECT COUNT(*) FROM cn_imp_lines WHERE import_type_code = ''TRXAPI'' AND imp_header_id in ' || l_imp_header_id_list;
2262: EXECUTE immediate l_sql INTO l_row_count;
2263: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2264: x_msg_count := x_msg_count + 1;
2265: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2268: insert_archive(cn_imp_lines_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2264: x_msg_count := x_msg_count + 1;
2265: p_tot_rows_count := p_tot_rows_count + l_row_count;
2266: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10.9 x_msg_data ' || x_msg_data);
2267:
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');

Line 2296: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions Error in cn_imp_lines (possible reason may be col3 date format issue) - ' || sqlerrm);

2292:
2293: EXCEPTION
2294: WHEN OTHERS THEN
2295: -- x_return_status := 'F';
2296: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions Error in cn_imp_lines (possible reason may be col3 date format issue) - ' || sqlerrm);
2297: END;
2298:
2299: l_table_name := 'cn_comm_lin_api' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2300: l_sql := 'Create table ' || l_table_name ;