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_TRANSACTIONS_ALL

Line 177: elsif (p_table_name = 'CN_PAYMENT_TRANSACTIONS_ALL') THEN

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
178: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_payment_transactions_all ' );
179: DELETE
180: /*+ ROWID (cnh) */
181: FROM cn_payment_transactions_all cnh

Line 178: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_payment_transactions_all ' );

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
178: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_payment_transactions_all ' );
179: DELETE
180: /*+ ROWID (cnh) */
181: FROM cn_payment_transactions_all cnh
182: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 181: FROM cn_payment_transactions_all cnh

177: elsif (p_table_name = 'CN_PAYMENT_TRANSACTIONS_ALL') THEN
178: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_payment_transactions_all ' );
179: DELETE
180: /*+ ROWID (cnh) */
181: FROM cn_payment_transactions_all cnh
182: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
183: AND paid_flag = 'Y'
184: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
185: elsif (p_table_name = 'CN_COMMISSION_LINES_ALL') THEN

Line 554: l_table_name := 'cn_payment_transactions_all';

550: p_addnl_para => '',
551: x_row_to_process_flag => l_any_rows_to_process,
552: x_return_status => x_return_status );
553:
554: l_table_name := 'cn_payment_transactions_all';
555:
556: delete_table ( p_start_period_id => p_start_period_id,
557: p_end_period_id => p_end_period_id,
558: x_start_date => x_start_date,

Line 853: l_table_name := 'cn_payment_transactions_all';

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(*)
855: INTO l_row_count
856: FROM cn_payment_transactions_all
857: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 856: FROM cn_payment_transactions_all

852:
853: l_table_name := 'cn_payment_transactions_all';
854: SELECT COUNT(*)
855: INTO l_row_count
856: FROM cn_payment_transactions_all
857: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
858: AND paid_flag = 'Y';
859: x_msg_data := x_msg_data || 'cn_payment_transactions_all count ' || l_row_count || ' : ';
860: x_msg_count := x_msg_count + 1;

Line 859: x_msg_data := x_msg_data || 'cn_payment_transactions_all count ' || l_row_count || ' : ';

855: INTO l_row_count
856: FROM cn_payment_transactions_all
857: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
858: AND paid_flag = 'Y';
859: x_msg_data := x_msg_data || 'cn_payment_transactions_all count ' || l_row_count || ' : ';
860: x_msg_count := x_msg_count + 1;
861: p_tot_rows_count := p_tot_rows_count + l_row_count;
862: insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
863: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:4 x_msg_data ' || x_msg_data);

Line 862: insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

858: AND paid_flag = 'Y';
859: x_msg_data := x_msg_data || 'cn_payment_transactions_all count ' || l_row_count || ' : ';
860: x_msg_count := x_msg_count + 1;
861: p_tot_rows_count := p_tot_rows_count + l_row_count;
862: insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
863: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:4 x_msg_data ' || x_msg_data);
864:
865: l_table_name := 'cn_commission_lines_all';
866: SELECT COUNT(*)

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

2066: l_sql := 'Create table ' || l_table_name ;
2067: if(p_table_space is not null) Then
2068: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2069: end if;
2070: l_sql := l_sql || ' as select * from cn_payment_transactions_all where pay_period_id between ' || p_start_period_id || ' and ' || p_end_period_id || ' and paid_flag = ''Y''';
2071: EXECUTE immediate l_sql;
2072:
2073: SELECT COUNT(*)
2074: INTO l_row_count

Line 2075: FROM cn_payment_transactions_all

2071: EXECUTE immediate l_sql;
2072:
2073: SELECT COUNT(*)
2074: INTO l_row_count
2075: FROM cn_payment_transactions_all
2076: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
2077: AND paid_flag = 'Y';
2078: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2079: x_msg_count := x_msg_count + 1;

Line 2081: insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2077: AND paid_flag = 'Y';
2078: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2079: x_msg_count := x_msg_count + 1;
2080: p_tot_rows_count := p_tot_rows_count + l_row_count;
2081: insert_archive(cn_payment_transactions_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2082:
2083: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:4 x_msg_data ' || x_msg_data);
2084: l_table_name := 'cn_commsn_lines' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2085: l_sql := 'Create table ' || l_table_name ;