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_INVOICE_CHANGES_ALL

Line 227: elsif (p_table_name = 'CN_INVOICE_CHANGES_ALL') THEN

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
229: /*+ ROWID (i) */
230: FROM cn_invoice_changes_all i
231: WHERE i.comm_lines_api_id IN

Line 230: FROM cn_invoice_changes_all i

226: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
227: elsif (p_table_name = 'CN_INVOICE_CHANGES_ALL') THEN
228: DELETE
229: /*+ ROWID (i) */
230: FROM cn_invoice_changes_all i
231: WHERE i.comm_lines_api_id IN
232: (SELECT DISTINCT c.comm_lines_api_id
233: FROM cn_comm_lines_api_all c
234: WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 669: l_table_name := 'cn_invoice_changes_all';

665: p_addnl_para => '',
666: x_row_to_process_flag => l_any_rows_to_process,
667: x_return_status => x_return_status );
668:
669: l_table_name := 'cn_invoice_changes_all';
670:
671: delete_table ( p_start_period_id => p_start_period_id,
672: p_end_period_id => p_end_period_id,
673: x_start_date => x_start_date,

Line 941: l_table_name := 'cn_invoice_changes_all';

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(*)
943: INTO l_row_count
944: FROM cn_invoice_changes_all i
945: WHERE i.comm_lines_api_id IN

Line 944: FROM cn_invoice_changes_all i

940:
941: l_table_name := 'cn_invoice_changes_all';
942: SELECT COUNT(*)
943: INTO l_row_count
944: FROM cn_invoice_changes_all i
945: WHERE i.comm_lines_api_id IN
946: (SELECT DISTINCT c.comm_lines_api_id
947: FROM cn_comm_lines_api_all c
948: WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 951: x_msg_data := x_msg_data || 'cn_invoice_changes_all count ' || l_row_count || ' : ';

947: FROM cn_comm_lines_api_all c
948: WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id
949: );
950:
951: x_msg_data := x_msg_data || 'cn_invoice_changes_all count ' || l_row_count || ' : ';
952: x_msg_count := x_msg_count + 1;
953: p_tot_rows_count := p_tot_rows_count + l_row_count;
954: insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
955: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:11 x_msg_data ' || x_msg_data);

Line 954: insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

950:
951: x_msg_data := x_msg_data || 'cn_invoice_changes_all count ' || l_row_count || ' : ';
952: x_msg_count := x_msg_count + 1;
953: p_tot_rows_count := p_tot_rows_count + l_row_count;
954: insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
955: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:11 x_msg_data ' || x_msg_data);
956:
957: BEGIN
958:

Line 2201: l_sql := l_sql || ' as select * from cn_invoice_changes_all i where i.comm_lines_api_id in ' ||

2197: l_sql := 'Create table ' || l_table_name ;
2198: if(p_table_space is not null) Then
2199: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2200: end if;
2201: l_sql := l_sql || ' as select * from cn_invoice_changes_all i where i.comm_lines_api_id in ' ||
2202: ' (select distinct c.comm_lines_api_id from cn_comm_lines_api_all c where c.processed_period_id between ' ||
2203: p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2204: EXECUTE immediate l_sql;
2205:

Line 2208: FROM cn_invoice_changes_all i

2204: EXECUTE immediate l_sql;
2205:
2206: SELECT COUNT(*)
2207: INTO l_row_count
2208: FROM cn_invoice_changes_all i
2209: WHERE i.comm_lines_api_id IN
2210: (SELECT DISTINCT c.comm_lines_api_id
2211: FROM cn_comm_lines_api_all c
2212: WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id );

Line 2216: insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2212: WHERE c.processed_period_id BETWEEN p_start_period_id AND p_end_period_id );
2213: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2214: x_msg_count := x_msg_count + 1;
2215: p_tot_rows_count := p_tot_rows_count + l_row_count;
2216: insert_archive(cn_invoice_changes_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2217:
2218: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:10 x_msg_data ' || x_msg_data);
2219:
2220: BEGIN