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_PER_QUOTA_RC_ALL

Line 323: elsif (p_table_name = 'CN_SRP_PER_QUOTA_RC_ALL') THEN

319: FROM cn_srp_period_quotas_all qa
320: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
321: )
322: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
323: elsif (p_table_name = 'CN_SRP_PER_QUOTA_RC_ALL') THEN
324: DELETE
325: /*+ ROWID (cnh) */
326: FROM cn_srp_per_quota_rc_all cnh
327: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 326: FROM cn_srp_per_quota_rc_all cnh

322: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
323: elsif (p_table_name = 'CN_SRP_PER_QUOTA_RC_ALL') THEN
324: DELETE
325: /*+ ROWID (cnh) */
326: FROM cn_srp_per_quota_rc_all cnh
327: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
328: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
329: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_ALL') THEN
330: DELETE

Line 1091: l_table_name := 'cn_srp_per_quota_rc_all';

1087: x_row_to_process_flag => l_any_rows_to_process,
1088: x_return_status => x_return_status );
1089:
1090:
1091: l_table_name := 'cn_srp_per_quota_rc_all';
1092:
1093: delete_table ( p_start_period_id => p_start_period_id,
1094: p_end_period_id => p_end_period_id,
1095: x_start_date => x_start_date,

Line 1319: l_table_name := 'cn_srp_per_quota_rc_all';

1315: p_tot_rows_count := p_tot_rows_count + l_row_count;
1316: insert_archive(cn_srp_period_quotas_ext_all_i,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1317: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:1 x_msg_data ' || x_msg_data);
1318:
1319: l_table_name := 'cn_srp_per_quota_rc_all';
1320: SELECT COUNT(*)
1321: INTO l_row_count
1322: FROM cn_srp_per_quota_rc_all
1323: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1322: FROM cn_srp_per_quota_rc_all

1318:
1319: l_table_name := 'cn_srp_per_quota_rc_all';
1320: SELECT COUNT(*)
1321: INTO l_row_count
1322: FROM cn_srp_per_quota_rc_all
1323: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1324:
1325: x_msg_data := x_msg_data || 'cn_srp_per_quota_rc_all count ' || l_row_count || ' : ';
1326:

Line 1325: x_msg_data := x_msg_data || 'cn_srp_per_quota_rc_all count ' || l_row_count || ' : ';

1321: INTO l_row_count
1322: FROM cn_srp_per_quota_rc_all
1323: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1324:
1325: x_msg_data := x_msg_data || 'cn_srp_per_quota_rc_all count ' || l_row_count || ' : ';
1326:
1327: x_msg_count := x_msg_count + 1;
1328: p_tot_rows_count := p_tot_rows_count + l_row_count;
1329: insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1329: insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1325: x_msg_data := x_msg_data || 'cn_srp_per_quota_rc_all count ' || l_row_count || ' : ';
1326:
1327: x_msg_count := x_msg_count + 1;
1328: p_tot_rows_count := p_tot_rows_count + l_row_count;
1329: insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1330: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:2 x_msg_data ' || x_msg_data);
1331:
1332: l_table_name := 'cn_srp_period_quotas_all';
1333: SELECT COUNT(*)

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

2380: l_sql := 'Create table ' || l_table_name ;
2381: if(p_table_space is not null) Then
2382: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2383: end if;
2384: l_sql := l_sql || ' as select * from cn_srp_per_quota_rc_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id ;
2385: EXECUTE immediate l_sql;
2386:
2387: SELECT COUNT(*)
2388: INTO l_row_count

Line 2389: FROM cn_srp_per_quota_rc_all

2385: EXECUTE immediate l_sql;
2386:
2387: SELECT COUNT(*)
2388: INTO l_row_count
2389: FROM cn_srp_per_quota_rc_all
2390: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2391: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2392: x_msg_count := x_msg_count + 1;
2393: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2394: insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2390: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2391: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2392: x_msg_count := x_msg_count + 1;
2393: p_tot_rows_count := p_tot_rows_count + l_row_count;
2394: insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2395: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:3 x_msg_data ' || x_msg_data);
2396: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:3 x_return_status ' || x_return_status);
2397:
2398: l_table_name := 'cn_srp_prd_quta' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');