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_COMMISSION_LINES_ALL

Line 185: elsif (p_table_name = 'CN_COMMISSION_LINES_ALL') THEN

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
186: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_commission_lines_all ' );
187: DELETE
188: /*+ ROWID (cnh) */
189: FROM cn_commission_lines_all cnh

Line 186: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_commission_lines_all ' );

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
186: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_commission_lines_all ' );
187: DELETE
188: /*+ ROWID (cnh) */
189: FROM cn_commission_lines_all cnh
190: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 189: FROM cn_commission_lines_all cnh

185: elsif (p_table_name = 'CN_COMMISSION_LINES_ALL') THEN
186: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting cn_commission_lines_all ' );
187: DELETE
188: /*+ ROWID (cnh) */
189: FROM cn_commission_lines_all cnh
190: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
191: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
192: -- DELETE FROM cn_commission_lines_all
193: -- WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 192: -- DELETE FROM cn_commission_lines_all

188: /*+ ROWID (cnh) */
189: FROM cn_commission_lines_all cnh
190: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
191: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
192: -- DELETE FROM cn_commission_lines_all
193: -- WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
194: elsif (p_table_name = 'CN_COMMISSION_HEADERS_ALL') THEN
195: DELETE
196: /*+ ROWID (cnh) */

Line 570: l_table_name := 'cn_commission_lines_all';

566: p_addnl_para => '',
567: x_row_to_process_flag => l_any_rows_to_process,
568: x_return_status => x_return_status );
569:
570: l_table_name := 'cn_commission_lines_all';
571:
572: delete_table ( p_start_period_id => p_start_period_id,
573: p_end_period_id => p_end_period_id,
574: x_start_date => x_start_date,

Line 865: l_table_name := 'cn_commission_lines_all';

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(*)
867: INTO l_row_count
868: FROM cn_commission_lines_all
869: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 868: FROM cn_commission_lines_all

864:
865: l_table_name := 'cn_commission_lines_all';
866: SELECT COUNT(*)
867: INTO l_row_count
868: FROM cn_commission_lines_all
869: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
870:
871: x_msg_data := x_msg_data || 'cn_commission_lines_all count ' || l_row_count || ' : ';
872: x_msg_count := x_msg_count + 1;

Line 871: x_msg_data := x_msg_data || 'cn_commission_lines_all count ' || l_row_count || ' : ';

867: INTO l_row_count
868: FROM cn_commission_lines_all
869: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
870:
871: x_msg_data := x_msg_data || 'cn_commission_lines_all count ' || l_row_count || ' : ';
872: x_msg_count := x_msg_count + 1;
873: p_tot_rows_count := p_tot_rows_count + l_row_count;
874: insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
875: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:5 x_msg_data ' || x_msg_data);

Line 874: insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

870:
871: x_msg_data := x_msg_data || 'cn_commission_lines_all count ' || l_row_count || ' : ';
872: x_msg_count := x_msg_count + 1;
873: p_tot_rows_count := p_tot_rows_count + l_row_count;
874: insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
875: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_transactions:5 x_msg_data ' || x_msg_data);
876:
877: l_table_name := 'cn_commission_headers_all';
878: SELECT COUNT(*)

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

2085: l_sql := 'Create table ' || l_table_name ;
2086: if(p_table_space is not null) Then
2087: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2088: end if;
2089: l_sql := l_sql || ' as select * from cn_commission_lines_all where processed_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2090: EXECUTE immediate l_sql;
2091:
2092: SELECT COUNT(*)
2093: INTO l_row_count

Line 2094: FROM cn_commission_lines_all

2090: EXECUTE immediate l_sql;
2091:
2092: SELECT COUNT(*)
2093: INTO l_row_count
2094: FROM cn_commission_lines_all
2095: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
2096: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2097: x_msg_count := x_msg_count + 1;
2098: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2099: insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2095: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id;
2096: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2097: x_msg_count := x_msg_count + 1;
2098: p_tot_rows_count := p_tot_rows_count + l_row_count;
2099: insert_archive(cn_commission_lines_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2100:
2101: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_transactions:5 x_msg_data ' || x_msg_data);
2102: l_table_name := 'cn_comsn_header' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');
2103: l_sql := 'Create table ' || l_table_name ;