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.

[Home] [Help]

APPS.CN_PURGE_TABLES_PVT dependencies on CN_PROCESS_AUDITS_ALL

Line 409: elsif (p_table_name = 'CN_PROCESS_AUDITS_ALL') THEN

405: /*+ ROWID (cnh) */
406: FROM cn_srp_periods_all cnh
407: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
408: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
409: elsif (p_table_name = 'CN_PROCESS_AUDITS_ALL') THEN
410: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDITS_ALL ' );
411: DELETE
412: /*+ ROWID (cnh) */
413: FROM cn_process_audits_all cnh

Line 410: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDITS_ALL ' );

406: FROM cn_srp_periods_all cnh
407: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
408: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
409: elsif (p_table_name = 'CN_PROCESS_AUDITS_ALL') THEN
410: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDITS_ALL ' );
411: DELETE
412: /*+ ROWID (cnh) */
413: FROM cn_process_audits_all cnh
414: WHERE rowid BETWEEN l_start_rowid AND l_end_rowid;

Line 413: FROM cn_process_audits_all cnh

409: elsif (p_table_name = 'CN_PROCESS_AUDITS_ALL') THEN
410: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDITS_ALL ' );
411: DELETE
412: /*+ ROWID (cnh) */
413: FROM cn_process_audits_all cnh
414: WHERE rowid BETWEEN l_start_rowid AND l_end_rowid;
415: elsif (p_table_name = 'CN_PROCESS_AUDIT_LINES_ALL') THEN
416: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDIT_LINES_ALL ' );
417: DELETE

Line 1836: l_table_name := 'cn_process_audits_all';

1832: x_row_to_process_flag => l_any_rows_to_process,
1833: x_return_status => x_return_status );
1834:
1835:
1836: l_table_name := 'cn_process_audits_all';
1837:
1838: delete_table ( p_start_period_id => p_start_period_id,
1839: p_end_period_id => p_end_period_id,
1840: x_start_date => x_start_date,

Line 1943: l_table_name := 'cn_process_audits_all';

1939: p_tot_rows_count := p_tot_rows_count + l_row_count;
1940: insert_archive(cn_process_audit_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1941: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:2 x_msg_data ' || x_msg_data);
1942:
1943: l_table_name := 'cn_process_audits_all';
1944: SELECT COUNT(*) INTO l_row_count FROM cn_process_audits_all;
1945:
1946: x_msg_data := x_msg_data || 'cn_process_audits_all count ' || l_row_count || ' : ';
1947:

Line 1944: SELECT COUNT(*) INTO l_row_count FROM cn_process_audits_all;

1940: insert_archive(cn_process_audit_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1941: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:2 x_msg_data ' || x_msg_data);
1942:
1943: l_table_name := 'cn_process_audits_all';
1944: SELECT COUNT(*) INTO l_row_count FROM cn_process_audits_all;
1945:
1946: x_msg_data := x_msg_data || 'cn_process_audits_all count ' || l_row_count || ' : ';
1947:
1948: x_msg_count := x_msg_count + 1;

Line 1946: x_msg_data := x_msg_data || 'cn_process_audits_all count ' || l_row_count || ' : ';

1942:
1943: l_table_name := 'cn_process_audits_all';
1944: SELECT COUNT(*) INTO l_row_count FROM cn_process_audits_all;
1945:
1946: x_msg_data := x_msg_data || 'cn_process_audits_all count ' || l_row_count || ' : ';
1947:
1948: x_msg_count := x_msg_count + 1;
1949: p_tot_rows_count := p_tot_rows_count + l_row_count;
1950: insert_archive(cn_process_audits_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1950: insert_archive(cn_process_audits_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1946: x_msg_data := x_msg_data || 'cn_process_audits_all count ' || l_row_count || ' : ';
1947:
1948: x_msg_count := x_msg_count + 1;
1949: p_tot_rows_count := p_tot_rows_count + l_row_count;
1950: insert_archive(cn_process_audits_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1951: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:3 x_msg_data ' || x_msg_data);
1952:
1953: l_table_name := 'cn_process_batches_all';
1954: SELECT COUNT(*)