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_COMMISSION_HEADERS_ALL

Line 194: elsif (p_table_name = 'CN_COMMISSION_HEADERS_ALL') THEN

190: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
191: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
192: -- DELETE FROM cn_commission_lines_all
193: -- WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
194: elsif (p_table_name = 'CN_COMMISSION_HEADERS_ALL') THEN
195: DELETE
196: /*+ ROWID (cnh) */
197: FROM cn_commission_headers_all cnh
198: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 197: FROM cn_commission_headers_all cnh

193: -- WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
194: elsif (p_table_name = 'CN_COMMISSION_HEADERS_ALL') THEN
195: DELETE
196: /*+ ROWID (cnh) */
197: FROM cn_commission_headers_all cnh
198: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
199: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
200: elsif (p_table_name = 'CN_TRX_SALES_LINES_ALL') THEN
201: DELETE

Line 586: l_table_name := 'cn_commission_headers_all';

582: p_addnl_para => '',
583: x_row_to_process_flag => l_any_rows_to_process,
584: x_return_status => x_return_status );
585:
586: l_table_name := 'cn_commission_headers_all';
587:
588: delete_table ( p_start_period_id => p_start_period_id,
589: p_end_period_id => p_end_period_id,
590: x_start_date => x_start_date,

Line 877: l_table_name := 'cn_commission_headers_all';

873: p_tot_rows_count := p_tot_rows_count + l_row_count;
874: insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
875: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:5 x_msg_data ' || x_msg_data);
876:
877: l_table_name := 'cn_commission_headers_all';
878: SELECT COUNT(*)
879: INTO l_row_count
880: FROM cn_commission_headers_all
881: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 880: FROM cn_commission_headers_all

876:
877: l_table_name := 'cn_commission_headers_all';
878: SELECT COUNT(*)
879: INTO l_row_count
880: FROM cn_commission_headers_all
881: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
882:
883: x_msg_data := x_msg_data || 'cn_commission_headers_all count ' || l_row_count || ' : ';
884: x_msg_count := x_msg_count + 1;

Line 883: x_msg_data := x_msg_data || 'cn_commission_headers_all count ' || l_row_count || ' : ';

879: INTO l_row_count
880: FROM cn_commission_headers_all
881: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
882:
883: x_msg_data := x_msg_data || 'cn_commission_headers_all count ' || l_row_count || ' : ';
884: x_msg_count := x_msg_count + 1;
885: p_tot_rows_count := p_tot_rows_count + l_row_count;
886: insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
887: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:6 x_msg_data ' || x_msg_data);

Line 886: insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

882:
883: x_msg_data := x_msg_data || 'cn_commission_headers_all count ' || l_row_count || ' : ';
884: x_msg_count := x_msg_count + 1;
885: p_tot_rows_count := p_tot_rows_count + l_row_count;
886: insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
887: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:6 x_msg_data ' || x_msg_data);
888:
889: l_table_name := 'cn_trx_sales_lines_all';
890: SELECT COUNT(*)

Line 2107: l_sql := l_sql || ' as select * from cn_commission_headers_all where processed_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;

2103: l_sql := 'Create table ' || l_table_name ;
2104: if(p_table_space is not null) Then
2105: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2106: end if;
2107: l_sql := l_sql || ' as select * from cn_commission_headers_all where processed_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2108: EXECUTE immediate l_sql;
2109:
2110: SELECT COUNT(*)
2111: INTO l_row_count

Line 2112: FROM cn_commission_headers_all

2108: EXECUTE immediate l_sql;
2109:
2110: SELECT COUNT(*)
2111: INTO l_row_count
2112: FROM cn_commission_headers_all
2113: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
2114: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2115: x_msg_count := x_msg_count + 1;
2116: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2117: insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2113: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
2114: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2115: x_msg_count := x_msg_count + 1;
2116: p_tot_rows_count := p_tot_rows_count + l_row_count;
2117: insert_archive(cn_commission_headers_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2118:
2119: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:6 x_msg_data ' || x_msg_data);
2120: l_table_name := 'cn_trx_sale_lin' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2121: l_sql := 'Create table ' || l_table_name ;