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_PERIOD_QUOTAS_EXT_ALL

Line 313: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_EXT_ALL') THEN

309: FROM cn_srp_plan_assigns_all cnh
310: WHERE ((start_date BETWEEN x_start_date AND x_end_date)
311: AND (end_date BETWEEN x_start_date AND x_end_date))
312: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
313: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_EXT_ALL') THEN
314: DELETE
315: /*+ ROWID (qe) */
316: FROM cn_srp_period_quotas_ext_all qe
317: WHERE qe.srp_period_quota_id IN

Line 316: FROM cn_srp_period_quotas_ext_all qe

312: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
313: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_EXT_ALL') THEN
314: DELETE
315: /*+ ROWID (qe) */
316: FROM cn_srp_period_quotas_ext_all qe
317: WHERE qe.srp_period_quota_id IN
318: (SELECT DISTINCT qa.srp_period_quota_id
319: FROM cn_srp_period_quotas_all qa
320: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id

Line 1074: l_table_name := 'cn_srp_period_quotas_ext_all';

1070: END IF;
1071:
1072: x_return_status := 'S';
1073:
1074: l_table_name := 'cn_srp_period_quotas_ext_all';
1075:
1076: delete_table ( p_start_period_id => p_start_period_id,
1077: p_end_period_id => p_end_period_id,
1078: x_start_date => x_start_date,

Line 1302: l_table_name := 'cn_srp_period_quotas_ext_all';

1298:
1299: x_return_status := 'S';
1300: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:0 x_msg_data ' || x_msg_data);
1301:
1302: l_table_name := 'cn_srp_period_quotas_ext_all';
1303: SELECT COUNT(*)
1304: INTO l_row_count
1305: FROM cn_srp_period_quotas_ext_all qe
1306: WHERE qe.srp_period_quota_id IN

Line 1305: FROM cn_srp_period_quotas_ext_all qe

1301:
1302: l_table_name := 'cn_srp_period_quotas_ext_all';
1303: SELECT COUNT(*)
1304: INTO l_row_count
1305: FROM cn_srp_period_quotas_ext_all qe
1306: WHERE qe.srp_period_quota_id IN
1307: (SELECT DISTINCT qa.srp_period_quota_id
1308: FROM cn_srp_period_quotas_all qa
1309: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id

Line 1312: x_msg_data := x_msg_data || 'cn_srp_period_quotas_ext_all count ' || l_row_count || ' : ';

1308: FROM cn_srp_period_quotas_all qa
1309: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
1310: );
1311:
1312: x_msg_data := x_msg_data || 'cn_srp_period_quotas_ext_all count ' || l_row_count || ' : ';
1313:
1314: x_msg_count := x_msg_count + 1;
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);

Line 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);

1312: x_msg_data := x_msg_data || 'cn_srp_period_quotas_ext_all count ' || l_row_count || ' : ';
1313:
1314: x_msg_count := x_msg_count + 1;
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(*)

Line 2358: l_sql := l_sql || ' as select * from cn_srp_period_quotas_ext_all qe where ' ||

2354: l_sql := 'Create table ' || l_table_name ;
2355: if(p_table_space is not null) Then
2356: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2357: end if;
2358: l_sql := l_sql || ' as select * from cn_srp_period_quotas_ext_all qe where ' ||
2359: ' qe.srp_period_quota_id in (Select distinct qa.srp_period_quota_id from cn_srp_period_quotas_all qa where qa.period_id between ' ||
2360: p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2361: EXECUTE immediate l_sql;
2362:

Line 2365: FROM cn_srp_period_quotas_ext_all qe

2361: EXECUTE immediate l_sql;
2362:
2363: SELECT COUNT(*)
2364: INTO l_row_count
2365: FROM cn_srp_period_quotas_ext_all qe
2366: WHERE qe.srp_period_quota_id IN
2367: (SELECT DISTINCT qa.srp_period_quota_id
2368: FROM cn_srp_period_quotas_all qa
2369: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id

Line 2374: 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);

2370: );
2371: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2372: x_msg_count := x_msg_count + 1;
2373: p_tot_rows_count := p_tot_rows_count + l_row_count;
2374: 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);
2375: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:2 x_msg_data ' || x_msg_data);
2376: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:2 x_return_status ' || x_return_status);
2377:
2378: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:2 x_msg_data ' || x_msg_data);