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_WORKSHEET_BONUSES_ALL

Line 377: elsif (p_table_name = 'CN_WORKSHEET_BONUSES_ALL') THEN

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
379: /*+ ROWID (wb) */
380: FROM cn_worksheet_bonuses_all wb
381: WHERE wb.payrun_id IN

Line 380: FROM cn_worksheet_bonuses_all wb

376: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
377: elsif (p_table_name = 'CN_WORKSHEET_BONUSES_ALL') THEN
378: DELETE
379: /*+ ROWID (wb) */
380: FROM cn_worksheet_bonuses_all wb
381: WHERE wb.payrun_id IN
382: (SELECT DISTINCT pa.payrun_id
383: FROM cn_payruns_all pa
384: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id

Line 1205: l_table_name := 'cn_worksheet_bonuses_all';

1201: p_addnl_para => '',
1202: x_row_to_process_flag => l_any_rows_to_process,
1203: x_return_status => x_return_status );
1204:
1205: l_table_name := 'cn_worksheet_bonuses_all';
1206:
1207: delete_table ( p_start_period_id => p_start_period_id,
1208: p_end_period_id => p_end_period_id,
1209: x_start_date => x_start_date,

Line 1422: l_table_name := 'cn_worksheet_bonuses_all';

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(*)
1424: INTO l_row_count
1425: FROM cn_worksheet_bonuses_all wb
1426: WHERE wb.payrun_id IN

Line 1425: FROM cn_worksheet_bonuses_all wb

1421:
1422: l_table_name := 'cn_worksheet_bonuses_all';
1423: SELECT COUNT(*)
1424: INTO l_row_count
1425: FROM cn_worksheet_bonuses_all wb
1426: WHERE wb.payrun_id IN
1427: (SELECT DISTINCT pa.payrun_id
1428: FROM cn_payruns_all pa
1429: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id

Line 1432: x_msg_data := x_msg_data || 'cn_worksheet_bonuses_all count ' || l_row_count || ' : ';

1428: FROM cn_payruns_all pa
1429: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
1430: );
1431:
1432: x_msg_data := x_msg_data || 'cn_worksheet_bonuses_all count ' || l_row_count || ' : ';
1433:
1434: x_msg_count := x_msg_count + 1;
1435: p_tot_rows_count := p_tot_rows_count + l_row_count;
1436: insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1436: insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1432: x_msg_data := x_msg_data || 'cn_worksheet_bonuses_all count ' || l_row_count || ' : ';
1433:
1434: x_msg_count := x_msg_count + 1;
1435: p_tot_rows_count := p_tot_rows_count + l_row_count;
1436: insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1437: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:9 x_msg_data ' || x_msg_data);
1438:
1439: l_table_name := 'cn_payruns_all';
1440: SELECT COUNT(*)

Line 2529: l_sql := l_sql || ' as select * from cn_worksheet_bonuses_all wb where wb.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

2525: l_sql := 'Create table ' || l_table_name ;
2526: if(p_table_space is not null) Then
2527: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2528: end if;
2529: l_sql := l_sql || ' as select * from cn_worksheet_bonuses_all wb where wb.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2530: EXECUTE immediate l_sql;
2531:
2532: SELECT COUNT(*)
2533: INTO l_row_count

Line 2534: FROM cn_worksheet_bonuses_all wb

2530: EXECUTE immediate l_sql;
2531:
2532: SELECT COUNT(*)
2533: INTO l_row_count
2534: FROM cn_worksheet_bonuses_all wb
2535: WHERE wb.payrun_id IN
2536: (SELECT DISTINCT pa.payrun_id
2537: FROM cn_payruns_all pa
2538: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id

Line 2543: insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2539: );
2540: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2541: x_msg_count := x_msg_count + 1;
2542: p_tot_rows_count := p_tot_rows_count + l_row_count;
2543: insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2544: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:10 x_msg_data ' || x_msg_data);
2545: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:10 x_return_status ' || x_return_status);
2546:
2547: l_table_name := 'cn_payruns' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');