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_QUOTA_ASSIGNS_ALL

Line 258: elsif (p_table_name = 'CN_SRP_QUOTA_ASSIGNS_ALL') THEN

254: /*+ ROWID (cnh) */
255: FROM cn_comm_lines_api_all cnh
256: WHERE processed_period_id BETWEEN p_start_period_id AND p_end_period_id
257: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
258: elsif (p_table_name = 'CN_SRP_QUOTA_ASSIGNS_ALL') THEN
259: DELETE
260: /*+ ROWID (qa) */
261: FROM cn_srp_quota_assigns_all qa
262: WHERE qa.srp_plan_assign_id IN

Line 261: FROM cn_srp_quota_assigns_all qa

257: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
258: elsif (p_table_name = 'CN_SRP_QUOTA_ASSIGNS_ALL') THEN
259: DELETE
260: /*+ ROWID (qa) */
261: FROM cn_srp_quota_assigns_all qa
262: WHERE qa.srp_plan_assign_id IN
263: (SELECT DISTINCT pl.srp_plan_assign_id
264: FROM cn_srp_plan_assigns_all pl
265: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)

Line 1529: l_table_name := 'cn_srp_quota_assigns_all';

1525: x_row_to_process_flag => l_any_rows_to_process,
1526: x_return_status => x_return_status );
1527:
1528:
1529: l_table_name := 'cn_srp_quota_assigns_all';
1530:
1531: delete_table ( p_start_period_id => p_start_period_id,
1532: p_end_period_id => p_end_period_id,
1533: x_start_date => x_start_date,

Line 1682: l_table_name := 'cn_srp_quota_assigns_all';

1678: p_tot_rows_count := p_tot_rows_count + l_row_count;
1679: insert_archive(cn_srp_payee_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1680: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:1 x_msg_data ' || x_msg_data);
1681:
1682: l_table_name := 'cn_srp_quota_assigns_all';
1683: SELECT COUNT(*)
1684: INTO l_row_count
1685: FROM cn_srp_quota_assigns_all qa
1686: WHERE qa.srp_plan_assign_id IN

Line 1685: FROM cn_srp_quota_assigns_all qa

1681:
1682: l_table_name := 'cn_srp_quota_assigns_all';
1683: SELECT COUNT(*)
1684: INTO l_row_count
1685: FROM cn_srp_quota_assigns_all qa
1686: WHERE qa.srp_plan_assign_id IN
1687: (SELECT DISTINCT pl.srp_plan_assign_id
1688: FROM cn_srp_plan_assigns_all pl
1689: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)

Line 1693: x_msg_data := x_msg_data || 'cn_srp_quota_assigns_all count ' || l_row_count || ' : ';

1689: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
1690: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
1691: );
1692:
1693: x_msg_data := x_msg_data || 'cn_srp_quota_assigns_all count ' || l_row_count || ' : ';
1694:
1695: x_msg_count := x_msg_count + 1;
1696: p_tot_rows_count := p_tot_rows_count + l_row_count;
1697: insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1697: insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1693: x_msg_data := x_msg_data || 'cn_srp_quota_assigns_all count ' || l_row_count || ' : ';
1694:
1695: x_msg_count := x_msg_count + 1;
1696: p_tot_rows_count := p_tot_rows_count + l_row_count;
1697: insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1698: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:2 x_msg_data ' || x_msg_data);
1699:
1700: l_table_name := 'cn_srp_rate_assigns_all';
1701: SELECT COUNT(*)

Line 2657: l_sql := l_sql || ' as select * from cn_srp_quota_assigns_all qa where qa.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl

2653: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:2 l_sql ' || l_sql);
2654: if(p_table_space is not null) Then
2655: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2656: end if;
2657: l_sql := l_sql || ' as select * from cn_srp_quota_assigns_all qa where qa.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl
2658: where ((pl.start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
2659: || ' ) and (pl.end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ')))';
2660: EXECUTE immediate l_sql;
2661:

Line 2664: FROM cn_srp_quota_assigns_all qa

2660: EXECUTE immediate l_sql;
2661:
2662: SELECT COUNT(*)
2663: INTO l_row_count
2664: FROM cn_srp_quota_assigns_all qa
2665: WHERE qa.srp_plan_assign_id IN
2666: (SELECT DISTINCT pl.srp_plan_assign_id
2667: FROM cn_srp_plan_assigns_all pl
2668: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)

Line 2674: insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2670: );
2671: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2672: x_msg_count := x_msg_count + 1;
2673: p_tot_rows_count := p_tot_rows_count + l_row_count;
2674: insert_archive(cn_srp_quota_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2675: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:2 x_msg_data ' || x_msg_data);
2676: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:2 x_return_status ' || x_return_status);
2677:
2678: l_table_name := 'cn_srp_rate_asn' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');