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_SUM_ALL

Line 371: elsif (p_table_name = 'CN_POSTING_DETAILS_SUM_ALL') THEN

367: FROM cn_srp_periods_all sp
368: WHERE sp.period_id BETWEEN p_start_period_id AND p_end_period_id
369: )
370: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
371: elsif (p_table_name = 'CN_POSTING_DETAILS_SUM_ALL') THEN
372: DELETE
373: /*+ ROWID (cnh) */
374: FROM cn_posting_details_sum_all cnh
375: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 374: FROM cn_posting_details_sum_all cnh

370: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
371: elsif (p_table_name = 'CN_POSTING_DETAILS_SUM_ALL') THEN
372: DELETE
373: /*+ ROWID (cnh) */
374: FROM cn_posting_details_sum_all cnh
375: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
376: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
377: elsif (p_table_name = 'CN_WORKSHEET_BONUSES_ALL') THEN
378: DELETE

Line 1189: l_table_name := 'cn_posting_details_sum_all';

1185: p_addnl_para => '',
1186: x_row_to_process_flag => l_any_rows_to_process,
1187: x_return_status => x_return_status );
1188:
1189: l_table_name := 'cn_posting_details_sum_all';
1190:
1191: delete_table ( p_start_period_id => p_start_period_id,
1192: p_end_period_id => p_end_period_id,
1193: x_start_date => x_start_date,

Line 1409: l_table_name := 'cn_posting_details_sum_all';

1405: p_tot_rows_count := p_tot_rows_count + l_row_count;
1406: insert_archive(cn_ledger_journal_entries_alli,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1407: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:7 x_msg_data ' || x_msg_data);
1408:
1409: l_table_name := 'cn_posting_details_sum_all';
1410: SELECT COUNT(*)
1411: INTO l_row_count
1412: FROM cn_posting_details_sum_all
1413: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1412: FROM cn_posting_details_sum_all

1408:
1409: l_table_name := 'cn_posting_details_sum_all';
1410: SELECT COUNT(*)
1411: INTO l_row_count
1412: FROM cn_posting_details_sum_all
1413: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;
1414:
1415: x_msg_data := x_msg_data || 'cn_posting_details_sum_all count ' || l_row_count || ' : ';
1416:

Line 1415: x_msg_data := x_msg_data || 'cn_posting_details_sum_all count ' || l_row_count || ' : ';

1411: INTO l_row_count
1412: FROM cn_posting_details_sum_all
1413: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;
1414:
1415: x_msg_data := x_msg_data || 'cn_posting_details_sum_all count ' || l_row_count || ' : ';
1416:
1417: x_msg_count := x_msg_count + 1;
1418: p_tot_rows_count := p_tot_rows_count + l_row_count;
1419: insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1419: insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1415: x_msg_data := x_msg_data || 'cn_posting_details_sum_all count ' || l_row_count || ' : ';
1416:
1417: x_msg_count := x_msg_count + 1;
1418: p_tot_rows_count := p_tot_rows_count + l_row_count;
1419: insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1420: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:8 x_msg_data ' || x_msg_data);
1421:
1422: l_table_name := 'cn_worksheet_bonuses_all';
1423: SELECT COUNT(*)

Line 2510: l_sql := l_sql || ' as select * from cn_posting_details_sum_all where pay_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;

2506: l_sql := 'Create table ' || l_table_name ;
2507: if(p_table_space is not null) Then
2508: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2509: end if;
2510: l_sql := l_sql || ' as select * from cn_posting_details_sum_all where pay_period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2511: EXECUTE immediate l_sql;
2512:
2513: SELECT COUNT(*)
2514: INTO l_row_count

Line 2515: FROM cn_posting_details_sum_all

2511: EXECUTE immediate l_sql;
2512:
2513: SELECT COUNT(*)
2514: INTO l_row_count
2515: FROM cn_posting_details_sum_all
2516: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;
2517: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2518: x_msg_count := x_msg_count + 1;
2519: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2520: insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2516: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id;
2517: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2518: x_msg_count := x_msg_count + 1;
2519: p_tot_rows_count := p_tot_rows_count + l_row_count;
2520: insert_archive(cn_posting_details_sum_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2521: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:9 x_msg_data ' || x_msg_data);
2522: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:9 x_return_status ' || x_return_status);
2523:
2524: l_table_name := 'cn_wksht_bonuse' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');