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.

[Home] [Help]

APPS.CN_PURGE_TABLES_PVT dependencies on CN_SRP_RATE_ASSIGNS_ALL

Line 269: elsif (p_table_name = 'CN_SRP_RATE_ASSIGNS_ALL') THEN

265: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
266: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
267: )
268: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
269: elsif (p_table_name = 'CN_SRP_RATE_ASSIGNS_ALL') THEN
270: DELETE
271: /*+ ROWID (ra) */
272: FROM cn_srp_rate_assigns_all ra
273: WHERE ra.srp_plan_assign_id IN

Line 272: FROM cn_srp_rate_assigns_all ra

268: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
269: elsif (p_table_name = 'CN_SRP_RATE_ASSIGNS_ALL') THEN
270: DELETE
271: /*+ ROWID (ra) */
272: FROM cn_srp_rate_assigns_all ra
273: WHERE ra.srp_plan_assign_id IN
274: (SELECT DISTINCT pl.srp_plan_assign_id
275: FROM cn_srp_plan_assigns_all pl
276: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)

Line 1545: l_table_name := 'cn_srp_rate_assigns_all';

1541: p_addnl_para => '',
1542: x_row_to_process_flag => l_any_rows_to_process,
1543: x_return_status => x_return_status );
1544:
1545: l_table_name := 'cn_srp_rate_assigns_all';
1546:
1547: delete_table ( p_start_period_id => p_start_period_id,
1548: p_end_period_id => p_end_period_id,
1549: x_start_date => x_start_date,

Line 1700: l_table_name := 'cn_srp_rate_assigns_all';

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(*)
1702: INTO l_row_count
1703: FROM cn_srp_rate_assigns_all ra
1704: WHERE ra.srp_plan_assign_id IN

Line 1703: FROM cn_srp_rate_assigns_all ra

1699:
1700: l_table_name := 'cn_srp_rate_assigns_all';
1701: SELECT COUNT(*)
1702: INTO l_row_count
1703: FROM cn_srp_rate_assigns_all ra
1704: WHERE ra.srp_plan_assign_id IN
1705: (SELECT DISTINCT pl.srp_plan_assign_id
1706: FROM cn_srp_plan_assigns_all pl
1707: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)

Line 1711: x_msg_data := x_msg_data || 'cn_srp_rate_assigns_all count ' || l_row_count || ' : ';

1707: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
1708: AND pl.end_date BETWEEN x_start_date AND x_end_date)
1709: );
1710:
1711: x_msg_data := x_msg_data || 'cn_srp_rate_assigns_all count ' || l_row_count || ' : ';
1712:
1713: x_msg_count := x_msg_count + 1;
1714: p_tot_rows_count := p_tot_rows_count + l_row_count;
1715: insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1715: insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1711: x_msg_data := x_msg_data || 'cn_srp_rate_assigns_all count ' || l_row_count || ' : ';
1712:
1713: x_msg_count := x_msg_count + 1;
1714: p_tot_rows_count := p_tot_rows_count + l_row_count;
1715: insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1716: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:3 x_msg_data ' || x_msg_data);
1717:
1718: l_table_name := 'cn_srp_rule_uplifts_all';
1719: SELECT COUNT(*)

Line 2683: l_sql := l_sql || ' as select * from cn_srp_rate_assigns_all ra where ra.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl

2679: l_sql := 'Create table ' || l_table_name ;
2680: if(p_table_space is not null) Then
2681: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2682: end if;
2683: l_sql := l_sql || ' as select * from cn_srp_rate_assigns_all ra where ra.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl
2684: where ((pl.start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
2685: || ' ) and pl.end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || '))';
2686: EXECUTE immediate l_sql;
2687:

Line 2690: FROM cn_srp_rate_assigns_all ra

2686: EXECUTE immediate l_sql;
2687:
2688: SELECT COUNT(*)
2689: INTO l_row_count
2690: FROM cn_srp_rate_assigns_all ra
2691: WHERE ra.srp_plan_assign_id IN
2692: (SELECT DISTINCT pl.srp_plan_assign_id
2693: FROM cn_srp_plan_assigns_all pl
2694: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)

Line 2700: insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2696: );
2697: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2698: x_msg_count := x_msg_count + 1;
2699: p_tot_rows_count := p_tot_rows_count + l_row_count;
2700: insert_archive(cn_srp_rate_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2701: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:3 x_msg_data ' || x_msg_data);
2702: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:3 x_return_status ' || x_return_status);
2703:
2704: l_table_name := 'cn_srp_rl_uplft' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');