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_BATCHES_ALL

Line 421: elsif (p_table_name = 'CN_PROCESS_BATCHES_ALL') THEN

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
424: /*+ ROWID (cnh) */
425: FROM cn_process_batches_all cnh

Line 422: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_BATCHES_ALL ' );

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
424: /*+ ROWID (cnh) */
425: FROM cn_process_batches_all cnh
426: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 425: FROM cn_process_batches_all cnh

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
424: /*+ ROWID (cnh) */
425: FROM cn_process_batches_all cnh
426: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
427: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
428: elsif (p_table_name = 'CN_SRP_INTEL_PERIODS_ALL') THEN
429: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_srp_intel_periods_all ' );

Line 1852: l_table_name := 'cn_process_batches_all';

1848: p_addnl_para => '',
1849: x_row_to_process_flag => l_any_rows_to_process,
1850: x_return_status => x_return_status );
1851:
1852: l_table_name := 'cn_process_batches_all';
1853:
1854: delete_table ( p_start_period_id => p_start_period_id,
1855: p_end_period_id => p_end_period_id,
1856: x_start_date => x_start_date,

Line 1953: l_table_name := 'cn_process_batches_all';

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(*)
1955: INTO l_row_count
1956: FROM cn_process_batches_all
1957: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1956: FROM cn_process_batches_all

1952:
1953: l_table_name := 'cn_process_batches_all';
1954: SELECT COUNT(*)
1955: INTO l_row_count
1956: FROM cn_process_batches_all
1957: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1958:
1959: x_msg_data := x_msg_data || 'cn_process_batches_all count ' || l_row_count || ' : ';
1960:

Line 1959: x_msg_data := x_msg_data || 'cn_process_batches_all count ' || l_row_count || ' : ';

1955: INTO l_row_count
1956: FROM cn_process_batches_all
1957: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1958:
1959: x_msg_data := x_msg_data || 'cn_process_batches_all count ' || l_row_count || ' : ';
1960:
1961: x_msg_count := x_msg_count + 1;
1962: p_tot_rows_count := p_tot_rows_count + l_row_count;
1963: insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1963: insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1959: x_msg_data := x_msg_data || 'cn_process_batches_all count ' || l_row_count || ' : ';
1960:
1961: x_msg_count := x_msg_count + 1;
1962: p_tot_rows_count := p_tot_rows_count + l_row_count;
1963: insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1964: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:4 x_msg_data ' || x_msg_data);
1965:
1966: l_table_name := 'cn_srp_intel_periods_all';
1967: SELECT COUNT(*)

Line 2823: l_sql := l_sql || ' as select * from cn_process_batches_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;

2819: l_sql := 'Create table ' || l_table_name ;
2820: if(p_table_space is not null) Then
2821: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2822: end if;
2823: l_sql := l_sql || ' as select * from cn_process_batches_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2824: EXECUTE immediate l_sql;
2825:
2826: SELECT COUNT(*)
2827: INTO l_row_count

Line 2828: FROM cn_process_batches_all

2824: EXECUTE immediate l_sql;
2825:
2826: SELECT COUNT(*)
2827: INTO l_row_count
2828: FROM cn_process_batches_all
2829: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2830: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2831: x_msg_count := x_msg_count + 1;
2832: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2833: insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2829: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2830: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2831: x_msg_count := x_msg_count + 1;
2832: p_tot_rows_count := p_tot_rows_count + l_row_count;
2833: insert_archive(cn_process_batches_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2834: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_processing:2 x_msg_data ' || x_msg_data);
2835: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_processing:2 x_return_status ' || x_return_status);
2836:
2837: l_table_name := 'cn_srp_intl_prd' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');