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_SRP_INTEL_PERIODS_ALL

Line 428: elsif (p_table_name = 'CN_SRP_INTEL_PERIODS_ALL') THEN

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 ' );
430: DELETE
431: /*+ ROWID (cnh) */
432: FROM cn_srp_intel_periods_all cnh

Line 429: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_srp_intel_periods_all ' );

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 ' );
430: DELETE
431: /*+ ROWID (cnh) */
432: FROM cn_srp_intel_periods_all cnh
433: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 432: FROM cn_srp_intel_periods_all cnh

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 ' );
430: DELETE
431: /*+ ROWID (cnh) */
432: FROM cn_srp_intel_periods_all cnh
433: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
434: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
435: END IF;
436: l_rows_processed := SQL%ROWCOUNT;

Line 1868: l_table_name := 'cn_srp_intel_periods_all';

1864: p_addnl_para => '',
1865: x_row_to_process_flag => l_any_rows_to_process,
1866: x_return_status => x_return_status );
1867:
1868: l_table_name := 'cn_srp_intel_periods_all';
1869:
1870: delete_table ( p_start_period_id => p_start_period_id,
1871: p_end_period_id => p_end_period_id,
1872: x_start_date => x_start_date,

Line 1966: l_table_name := 'cn_srp_intel_periods_all';

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(*)
1968: INTO l_row_count
1969: FROM cn_srp_intel_periods_all
1970: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1969: FROM cn_srp_intel_periods_all

1965:
1966: l_table_name := 'cn_srp_intel_periods_all';
1967: SELECT COUNT(*)
1968: INTO l_row_count
1969: FROM cn_srp_intel_periods_all
1970: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1971:
1972: x_msg_data := x_msg_data || 'cn_srp_intel_periods_all count ' || l_row_count || ' : ';
1973:

Line 1972: x_msg_data := x_msg_data || 'cn_srp_intel_periods_all count ' || l_row_count || ' : ';

1968: INTO l_row_count
1969: FROM cn_srp_intel_periods_all
1970: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1971:
1972: x_msg_data := x_msg_data || 'cn_srp_intel_periods_all count ' || l_row_count || ' : ';
1973:
1974: x_msg_count := x_msg_count + 1;
1975: p_tot_rows_count := p_tot_rows_count + l_row_count;
1976: insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1976: insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1972: x_msg_data := x_msg_data || 'cn_srp_intel_periods_all count ' || l_row_count || ' : ';
1973:
1974: x_msg_count := x_msg_count + 1;
1975: p_tot_rows_count := p_tot_rows_count + l_row_count;
1976: insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1977: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_processing:5 x_msg_data ' || x_msg_data);
1978: x_return_status := 'S';
1979: EXCEPTION
1980: WHEN OTHERS THEN

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

2838: l_sql := 'Create table ' || l_table_name ;
2839: if(p_table_space is not null) Then
2840: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2841: end if;
2842: l_sql := l_sql || ' as select * from cn_srp_intel_periods_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2843: EXECUTE immediate l_sql;
2844:
2845: SELECT COUNT(*)
2846: INTO l_row_count

Line 2847: FROM cn_srp_intel_periods_all

2843: EXECUTE immediate l_sql;
2844:
2845: SELECT COUNT(*)
2846: INTO l_row_count
2847: FROM cn_srp_intel_periods_all
2848: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2849: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2850: x_msg_count := x_msg_count + 1;
2851: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2852: insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2848: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2849: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2850: x_msg_count := x_msg_count + 1;
2851: p_tot_rows_count := p_tot_rows_count + l_row_count;
2852: insert_archive(cn_srp_intel_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2853: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_processing:3 x_msg_data ' || x_msg_data);
2854: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_processing:3 x_return_status ' || x_return_status);
2855:
2856: EXCEPTION