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_SRP_PERIODS_ALL

Line 367: FROM cn_srp_periods_all sp

363: /*+ ROWID (je) */
364: FROM cn_ledger_journal_entries_all je
365: WHERE je.srp_period_id IN
366: (SELECT DISTINCT sp.srp_period_id
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

Line 403: elsif (p_table_name = 'CN_SRP_PERIODS_ALL') THEN

399: /*+ ROWID (cnh) */
400: FROM cn_payruns_all cnh
401: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
402: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
403: elsif (p_table_name = 'CN_SRP_PERIODS_ALL') THEN
404: DELETE
405: /*+ ROWID (cnh) */
406: FROM cn_srp_periods_all cnh
407: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 406: FROM cn_srp_periods_all cnh

402: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
403: elsif (p_table_name = 'CN_SRP_PERIODS_ALL') THEN
404: DELETE
405: /*+ ROWID (cnh) */
406: FROM cn_srp_periods_all cnh
407: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
408: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
409: elsif (p_table_name = 'CN_PROCESS_AUDITS_ALL') THEN
410: --debugmsg('CN_PURGE_TABLES_PVT.delete_table:before deleting CN_PROCESS_AUDITS_ALL ' );

Line 1237: l_table_name := 'cn_srp_periods_all';

1233: p_addnl_para => '',
1234: x_row_to_process_flag => l_any_rows_to_process,
1235: x_return_status => x_return_status );
1236:
1237: l_table_name := 'cn_srp_periods_all';
1238:
1239: delete_table ( p_start_period_id => p_start_period_id,
1240: p_end_period_id => p_end_period_id,
1241: x_start_date => x_start_date,

Line 1398: FROM cn_srp_periods_all sp

1394: INTO l_row_count
1395: FROM cn_ledger_journal_entries_all je
1396: WHERE je.srp_period_id IN
1397: (SELECT DISTINCT sp.srp_period_id
1398: FROM cn_srp_periods_all sp
1399: WHERE sp.period_id BETWEEN p_start_period_id AND p_end_period_id
1400: );
1401:
1402: x_msg_data := x_msg_data || 'cn_ledger_journal_entries_all count ' || l_row_count || ' : ';

Line 1452: l_table_name := 'cn_srp_periods_all';

1448: p_tot_rows_count := p_tot_rows_count + l_row_count;
1449: insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1450: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:10 x_msg_data ' || x_msg_data);
1451:
1452: l_table_name := 'cn_srp_periods_all';
1453: SELECT COUNT(*)
1454: INTO l_row_count
1455: FROM cn_srp_periods_all
1456: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1455: FROM cn_srp_periods_all

1451:
1452: l_table_name := 'cn_srp_periods_all';
1453: SELECT COUNT(*)
1454: INTO l_row_count
1455: FROM cn_srp_periods_all
1456: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1457:
1458: x_msg_data := x_msg_data || 'cn_srp_periods_all count ' || l_row_count || ' : ';
1459:

Line 1458: x_msg_data := x_msg_data || 'cn_srp_periods_all count ' || l_row_count || ' : ';

1454: INTO l_row_count
1455: FROM cn_srp_periods_all
1456: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1457:
1458: x_msg_data := x_msg_data || 'cn_srp_periods_all count ' || l_row_count || ' : ';
1459:
1460: x_msg_count := x_msg_count + 1;
1461: p_tot_rows_count := p_tot_rows_count + l_row_count;
1462: insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1462: insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1458: x_msg_data := x_msg_data || 'cn_srp_periods_all count ' || l_row_count || ' : ';
1459:
1460: x_msg_count := x_msg_count + 1;
1461: p_tot_rows_count := p_tot_rows_count + l_row_count;
1462: insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1463: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:11 x_msg_data ' || x_msg_data);
1464:
1465: EXCEPTION
1466: WHEN OTHERS THEN

Line 2487: l_sql := l_sql || ' as select * from cn_ledger_journal_entries_all je where je.srp_period_id in (Select distinct sp.srp_period_id from cn_srp_periods_all sp where sp.period_id between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

2483: l_sql := 'Create table ' || l_table_name ;
2484: if(p_table_space is not null) Then
2485: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2486: end if;
2487: l_sql := l_sql || ' as select * from cn_ledger_journal_entries_all je where je.srp_period_id in (Select distinct sp.srp_period_id from cn_srp_periods_all sp where sp.period_id between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2488: EXECUTE immediate l_sql;
2489:
2490: SELECT COUNT(*)
2491: INTO l_row_count

Line 2495: FROM cn_srp_periods_all sp

2491: INTO l_row_count
2492: FROM cn_ledger_journal_entries_all je
2493: WHERE je.srp_period_id IN
2494: (SELECT DISTINCT sp.srp_period_id
2495: FROM cn_srp_periods_all sp
2496: WHERE sp.period_id BETWEEN p_start_period_id AND p_end_period_id
2497: );
2498: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2499: x_msg_count := x_msg_count + 1;

Line 2571: l_sql := l_sql || ' as select * from cn_srp_periods_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;

2567: l_sql := 'Create table ' || l_table_name ;
2568: if(p_table_space is not null) Then
2569: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2570: end if;
2571: l_sql := l_sql || ' as select * from cn_srp_periods_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2572: EXECUTE immediate l_sql;
2573:
2574: SELECT COUNT(*)
2575: INTO l_row_count

Line 2576: FROM cn_srp_periods_all

2572: EXECUTE immediate l_sql;
2573:
2574: SELECT COUNT(*)
2575: INTO l_row_count
2576: FROM cn_srp_periods_all
2577: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2578: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2579: x_msg_count := x_msg_count + 1;
2580: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2581: insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2577: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2578: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2579: x_msg_count := x_msg_count + 1;
2580: p_tot_rows_count := p_tot_rows_count + l_row_count;
2581: insert_archive(cn_srp_periods_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2582: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:12 x_msg_data ' || x_msg_data);
2583: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:12 x_return_status ' || x_return_status);
2584:
2585: EXCEPTION