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_POSTING_DETAILS_ALL

Line 170: elsif (p_table_name = 'CN_POSTING_DETAILS_ALL') THEN

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
172: /*+ ROWID (cnh) */
173: FROM cn_posting_details_all cnh
174: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 173: FROM cn_posting_details_all cnh

169: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
170: elsif (p_table_name = 'CN_POSTING_DETAILS_ALL') THEN
171: DELETE
172: /*+ ROWID (cnh) */
173: FROM cn_posting_details_all cnh
174: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
175: AND paid_flag = 'Y'
176: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
177: elsif (p_table_name = 'CN_PAYMENT_TRANSACTIONS_ALL') THEN

Line 538: l_table_name := 'cn_posting_details_all';

534: p_addnl_para => '',
535: x_row_to_process_flag => l_any_rows_to_process,
536: x_return_status => x_return_status );
537:
538: l_table_name := 'cn_posting_details_all';
539:
540: delete_table ( p_start_period_id => p_start_period_id,
541: p_end_period_id => p_end_period_id,
542: x_start_date => x_start_date,

Line 841: l_table_name := 'cn_posting_details_all';

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(*)
843: INTO l_row_count
844: FROM cn_posting_details_all
845: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 844: FROM cn_posting_details_all

840:
841: l_table_name := 'cn_posting_details_all';
842: SELECT COUNT(*)
843: INTO l_row_count
844: FROM cn_posting_details_all
845: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
846: AND paid_flag = 'Y';
847: x_msg_data := x_msg_data || 'cn_posting_details_all count ' || l_row_count || ' : ';
848: x_msg_count := x_msg_count + 1;

Line 847: x_msg_data := x_msg_data || 'cn_posting_details_all count ' || l_row_count || ' : ';

843: INTO l_row_count
844: FROM cn_posting_details_all
845: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
846: AND paid_flag = 'Y';
847: x_msg_data := x_msg_data || 'cn_posting_details_all count ' || l_row_count || ' : ';
848: x_msg_count := x_msg_count + 1;
849: p_tot_rows_count := p_tot_rows_count + l_row_count;
850: insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
851: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:3 x_msg_data ' || x_msg_data);

Line 850: insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

846: AND paid_flag = 'Y';
847: x_msg_data := x_msg_data || 'cn_posting_details_all count ' || l_row_count || ' : ';
848: x_msg_count := x_msg_count + 1;
849: p_tot_rows_count := p_tot_rows_count + l_row_count;
850: insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
851: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:3 x_msg_data ' || x_msg_data);
852:
853: l_table_name := 'cn_payment_transactions_all';
854: SELECT COUNT(*)

Line 2052: l_sql := l_sql || ' as select * from cn_posting_details_all where pay_period_id between ' || p_start_period_id || ' and ' || p_end_period_id || ' and paid_flag = ''Y''';

2048: --l_sql := 'Create table cn_posting_details_arc ';
2049: if(p_table_space is not null) Then
2050: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2051: end if;
2052: l_sql := l_sql || ' as select * from cn_posting_details_all where pay_period_id between ' || p_start_period_id || ' and ' || p_end_period_id || ' and paid_flag = ''Y''';
2053: EXECUTE immediate l_sql;
2054:
2055: SELECT COUNT(*)
2056: INTO l_row_count

Line 2057: FROM cn_posting_details_all

2053: EXECUTE immediate l_sql;
2054:
2055: SELECT COUNT(*)
2056: INTO l_row_count
2057: FROM cn_posting_details_all
2058: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;
2059: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2060: x_msg_count := x_msg_count + 1;
2061: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2062: insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2058: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;
2059: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2060: x_msg_count := x_msg_count + 1;
2061: p_tot_rows_count := p_tot_rows_count + l_row_count;
2062: insert_archive(cn_posting_details_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2063:
2064: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:3 x_msg_data ' || x_msg_data);
2065: l_table_name := 'cn_payment_tran' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2066: l_sql := 'Create table ' || l_table_name ;