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_PAYMENT_API_ALL

Line 164: IF (p_table_name = 'CN_PAYMENT_API_ALL') THEN

160: LOOP
161: --dbms_output.put_line('start rowid '||l_start_rowid||' end_rowid '||l_end_rowid||' batch_size '||l_batch_size);
162: -- debugmsg('CN_PURGE_TABLES_PVT.delete_table:after ad_parallel_updates_pkg.get_rowid_range l_any_rows_to_process True' );
163: BEGIN
164: IF (p_table_name = 'CN_PAYMENT_API_ALL') THEN
165: DELETE
166: /*+ ROWID (cnh) */
167: FROM CN_PAYMENT_API_ALL cnh
168: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 167: FROM CN_PAYMENT_API_ALL cnh

163: BEGIN
164: IF (p_table_name = 'CN_PAYMENT_API_ALL') THEN
165: DELETE
166: /*+ ROWID (cnh) */
167: FROM CN_PAYMENT_API_ALL cnh
168: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
169: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
170: elsif (p_table_name = 'CN_POSTING_DETAILS_ALL') THEN
171: DELETE

Line 523: l_table_name := 'cn_payment_api_all';

519: END IF;
520:
521: x_return_status := 'S';
522:
523: l_table_name := 'cn_payment_api_all';
524: delete_table ( p_start_period_id => p_start_period_id,
525: p_end_period_id => p_end_period_id,
526: x_start_date => x_start_date,
527: x_end_date => x_end_date,

Line 830: l_table_name := 'cn_payment_api_all';

826:
827: x_return_status := 'S';
828: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:1 x_msg_data ' || x_msg_data);
829:
830: l_table_name := 'cn_payment_api_all';
831: SELECT COUNT(*)
832: INTO l_row_count
833: FROM cn_payment_api_all
834: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 833: FROM cn_payment_api_all

829:
830: l_table_name := 'cn_payment_api_all';
831: SELECT COUNT(*)
832: INTO l_row_count
833: FROM cn_payment_api_all
834: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
835: x_msg_data := x_msg_data || 'cn_payment_api_all count ' || l_row_count || ' : ';
836: x_msg_count := x_msg_count + 1;
837: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 835: x_msg_data := x_msg_data || 'cn_payment_api_all count ' || l_row_count || ' : ';

831: SELECT COUNT(*)
832: INTO l_row_count
833: FROM cn_payment_api_all
834: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
835: x_msg_data := x_msg_data || 'cn_payment_api_all count ' || l_row_count || ' : ';
836: x_msg_count := x_msg_count + 1;
837: p_tot_rows_count := p_tot_rows_count + l_row_count;
838: insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
839: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:2 x_msg_data ' || x_msg_data);

Line 838: insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

834: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
835: x_msg_data := x_msg_data || 'cn_payment_api_all count ' || l_row_count || ' : ';
836: x_msg_count := x_msg_count + 1;
837: p_tot_rows_count := p_tot_rows_count + l_row_count;
838: insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
839: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:2 x_msg_data ' || x_msg_data);
840:
841: l_table_name := 'cn_posting_details_all';
842: SELECT COUNT(*)

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

2029: l_sql := 'Create table ' || l_table_name ;
2030: if(p_table_space is not null) Then
2031: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2032: end if;
2033: l_sql := l_sql || ' as select * from CN_PAYMENT_API_ALL where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2034: EXECUTE immediate l_sql;
2035:
2036: SELECT COUNT(*)
2037: INTO l_row_count

Line 2038: FROM cn_payment_api_all

2034: EXECUTE immediate l_sql;
2035:
2036: SELECT COUNT(*)
2037: INTO l_row_count
2038: FROM cn_payment_api_all
2039: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2040: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2041: x_msg_count := x_msg_count + 1;
2042: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2043: insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2039: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2040: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2041: x_msg_count := x_msg_count + 1;
2042: p_tot_rows_count := p_tot_rows_count + l_row_count;
2043: insert_archive(cn_payment_api_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2044:
2045: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:2 x_msg_data ' || x_msg_data);
2046: l_table_name := 'cn_post_details' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2047: l_sql := 'Create table ' || l_table_name ;