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_PROCESS_AUDIT_LINES_ALL

Line 415: elsif (p_table_name = 'CN_PROCESS_AUDIT_LINES_ALL') THEN

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
418: /*+ ROWID (cnh) */
419: FROM cn_process_audit_lines_all cnh

Line 416: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDIT_LINES_ALL ' );

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
418: /*+ ROWID (cnh) */
419: FROM cn_process_audit_lines_all cnh
420: WHERE rowid BETWEEN l_start_rowid AND l_end_rowid;

Line 419: FROM cn_process_audit_lines_all cnh

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
418: /*+ ROWID (cnh) */
419: FROM cn_process_audit_lines_all cnh
420: WHERE rowid BETWEEN l_start_rowid AND l_end_rowid;
421: elsif (p_table_name = 'CN_PROCESS_BATCHES_ALL') THEN
422: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_BATCHES_ALL ' );
423: DELETE

Line 1819: l_table_name := 'cn_process_audit_lines_all';

1815: END IF;
1816:
1817: x_return_status := 'S';
1818:
1819: l_table_name := 'cn_process_audit_lines_all';
1820:
1821: delete_table ( p_start_period_id => p_start_period_id,
1822: p_end_period_id => p_end_period_id,
1823: x_start_date => x_start_date,

Line 1933: l_table_name := 'cn_process_audit_lines_all';

1929:
1930: x_return_status := 'S';
1931: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:1 x_msg_data ' || x_msg_data);
1932:
1933: l_table_name := 'cn_process_audit_lines_all';
1934: SELECT COUNT(*) INTO l_row_count FROM cn_process_audit_lines_all;
1935:
1936: x_msg_data := x_msg_data || 'cn_process_audit_lines_all count ' || l_row_count || ' : ';
1937:

Line 1934: SELECT COUNT(*) INTO l_row_count FROM cn_process_audit_lines_all;

1930: x_return_status := 'S';
1931: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:1 x_msg_data ' || x_msg_data);
1932:
1933: l_table_name := 'cn_process_audit_lines_all';
1934: SELECT COUNT(*) INTO l_row_count FROM cn_process_audit_lines_all;
1935:
1936: x_msg_data := x_msg_data || 'cn_process_audit_lines_all count ' || l_row_count || ' : ';
1937:
1938: x_msg_count := x_msg_count + 1;

Line 1936: x_msg_data := x_msg_data || 'cn_process_audit_lines_all count ' || l_row_count || ' : ';

1932:
1933: l_table_name := 'cn_process_audit_lines_all';
1934: SELECT COUNT(*) INTO l_row_count FROM cn_process_audit_lines_all;
1935:
1936: x_msg_data := x_msg_data || 'cn_process_audit_lines_all count ' || l_row_count || ' : ';
1937:
1938: x_msg_count := x_msg_count + 1;
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);

Line 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);

1936: x_msg_data := x_msg_data || 'cn_process_audit_lines_all count ' || l_row_count || ' : ';
1937:
1938: x_msg_count := x_msg_count + 1;
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;