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_COMM_LINES_API_ALL

Line 233: FROM cn_comm_lines_api_all c

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
235: )
236: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
237: elsif (p_table_name = 'CN_IMP_HEADERS') THEN

Line 252: elsif (p_table_name = 'CN_COMM_LINES_API_ALL') THEN

248: WHERE import_type_code = ''TRXAPI''
249: AND imp_header_id IN ' || p_addnl_para ||
250: ' AND rowid BETWEEN ' || l_start_rowid || ' AND ' || l_end_rowid;
251: EXECUTE IMMEDIATE l_sql;
252: elsif (p_table_name = 'CN_COMM_LINES_API_ALL') THEN
253: DELETE
254: /*+ ROWID (cnh) */
255: FROM cn_comm_lines_api_all cnh
256: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 255: FROM cn_comm_lines_api_all cnh

251: EXECUTE IMMEDIATE l_sql;
252: elsif (p_table_name = 'CN_COMM_LINES_API_ALL') THEN
253: DELETE
254: /*+ ROWID (cnh) */
255: FROM cn_comm_lines_api_all cnh
256: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
257: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
258: elsif (p_table_name = 'CN_SRP_QUOTA_ASSIGNS_ALL') THEN
259: DELETE

Line 751: l_table_name := 'cn_comm_lines_api_all';

747: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables_transactions Error (possible error may be cn_imp_lines for col3 date format iisue - ' || sqlerrm);
748:
749: END;
750:
751: l_table_name := 'cn_comm_lines_api_all';
752:
753: delete_table ( p_start_period_id => p_start_period_id,
754: p_end_period_id => p_end_period_id,
755: x_start_date => x_start_date,

Line 947: FROM cn_comm_lines_api_all c

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
949: );
950:
951: x_msg_data := x_msg_data || 'cn_invoice_changes_all count ' || l_row_count || ' : ';

Line 1014: l_table_name := 'cn_comm_lines_api_all';

1010: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions Error (possible error may be cn_imp_lines for col3 date format iisue - ' || sqlerrm);
1011:
1012: END;
1013:
1014: l_table_name := 'cn_comm_lines_api_all';
1015: SELECT COUNT(*)
1016: INTO l_row_count
1017: FROM cn_comm_lines_api_all
1018: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1017: FROM cn_comm_lines_api_all

1013:
1014: l_table_name := 'cn_comm_lines_api_all';
1015: SELECT COUNT(*)
1016: INTO l_row_count
1017: FROM cn_comm_lines_api_all
1018: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
1019:
1020: x_msg_data := x_msg_data || 'cn_comm_lines_api_all count ' || l_row_count || ' : ';
1021: x_msg_count := x_msg_count + 1;

Line 1020: x_msg_data := x_msg_data || 'cn_comm_lines_api_all count ' || l_row_count || ' : ';

1016: INTO l_row_count
1017: FROM cn_comm_lines_api_all
1018: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
1019:
1020: x_msg_data := x_msg_data || 'cn_comm_lines_api_all count ' || l_row_count || ' : ';
1021: x_msg_count := x_msg_count + 1;
1022: p_tot_rows_count := p_tot_rows_count + l_row_count;
1023: insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1024: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:14 x_msg_data ' || x_msg_data);

Line 1023: insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1019:
1020: x_msg_data := x_msg_data || 'cn_comm_lines_api_all count ' || l_row_count || ' : ';
1021: x_msg_count := x_msg_count + 1;
1022: p_tot_rows_count := p_tot_rows_count + l_row_count;
1023: insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1024: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:14 x_msg_data ' || x_msg_data);
1025:
1026: EXCEPTION
1027: WHEN OTHERS THEN

Line 2202: ' (select distinct c.comm_lines_api_id from cn_comm_lines_api_all c where c.processed_period_id between ' ||

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:
2206: SELECT COUNT(*)

Line 2211: FROM cn_comm_lines_api_all c

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

Line 2304: l_sql := l_sql || ' as select * from cn_comm_lines_api_all where processed_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;

2300: l_sql := 'Create table ' || l_table_name ;
2301: if(p_table_space is not null) Then
2302: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2303: end if;
2304: l_sql := l_sql || ' as select * from cn_comm_lines_api_all where processed_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2305: EXECUTE immediate l_sql;
2306:
2307: SELECT COUNT(*)
2308: INTO l_row_count

Line 2309: FROM cn_comm_lines_api_all

2305: EXECUTE immediate l_sql;
2306:
2307: SELECT COUNT(*)
2308: INTO l_row_count
2309: FROM cn_comm_lines_api_all
2310: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
2311: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2312: x_msg_count := x_msg_count + 1;
2313: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2314: insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2310: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
2311: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2312: x_msg_count := x_msg_count + 1;
2313: p_tot_rows_count := p_tot_rows_count + l_row_count;
2314: insert_archive(cn_comm_lines_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2315: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:13 x_msg_data ' || x_msg_data);
2316: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:14 x_return_status ' || x_return_status);
2317: EXCEPTION
2318: WHEN OTHERS THEN