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_PLAN_ASSIGNS_ALL

Line 264: FROM cn_srp_plan_assigns_all pl

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

Line 275: FROM cn_srp_plan_assigns_all pl

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)
277: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
278: )
279: AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line 289: FROM cn_srp_plan_assigns_all pl

285: (SELECT DISTINCT qr.srp_quota_rule_id
286: FROM cn_srp_quota_rules_all qr
287: WHERE qr.srp_plan_assign_id IN
288: (SELECT DISTINCT pl.srp_plan_assign_id
289: FROM cn_srp_plan_assigns_all pl
290: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
291: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
292: )
293: )

Line 301: FROM cn_srp_plan_assigns_all pl

297: /*+ ROWID (ra) */
298: FROM cn_srp_quota_rules_all ra
299: WHERE ra.srp_plan_assign_id IN
300: (SELECT DISTINCT pl.srp_plan_assign_id
301: FROM cn_srp_plan_assigns_all pl
302: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
303: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
304: )
305: AND rowid BETWEEN l_start_rowid AND l_end_rowid;

Line 306: elsif (p_table_name = 'CN_SRP_PLAN_ASSIGNS_ALL') THEN

302: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
303: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
304: )
305: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
306: elsif (p_table_name = 'CN_SRP_PLAN_ASSIGNS_ALL') THEN
307: DELETE
308: /*+ ROWID (cnh) */
309: FROM cn_srp_plan_assigns_all cnh
310: WHERE ((start_date BETWEEN x_start_date AND x_end_date)

Line 309: FROM cn_srp_plan_assigns_all cnh

305: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
306: elsif (p_table_name = 'CN_SRP_PLAN_ASSIGNS_ALL') THEN
307: DELETE
308: /*+ ROWID (cnh) */
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

Line 1594: l_table_name := 'cn_srp_plan_assigns_all';

1590: p_addnl_para => '',
1591: x_row_to_process_flag => l_any_rows_to_process,
1592: x_return_status => x_return_status );
1593:
1594: l_table_name := 'cn_srp_plan_assigns_all';
1595:
1596: delete_table ( p_start_period_id => p_start_period_id,
1597: p_end_period_id => p_end_period_id,
1598: x_start_date => x_start_date,

Line 1669: FROM cn_srp_plan_assigns_all pl

1665: (SELECT DISTINCT qa.srp_quota_assign_id
1666: FROM cn_srp_period_quotas_all qa
1667: WHERE qa.srp_plan_assign_id IN
1668: (SELECT DISTINCT pl.srp_plan_assign_id
1669: FROM cn_srp_plan_assigns_all pl
1670: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
1671: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
1672: )
1673: );

Line 1688: FROM cn_srp_plan_assigns_all pl

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)
1690: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
1691: );
1692:

Line 1706: FROM cn_srp_plan_assigns_all pl

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)
1708: AND pl.end_date BETWEEN x_start_date AND x_end_date)
1709: );
1710:

Line 1727: FROM cn_srp_plan_assigns_all pl

1723: (SELECT DISTINCT qr.srp_quota_rule_id
1724: FROM cn_srp_quota_rules_all qr
1725: WHERE qr.srp_plan_assign_id IN
1726: (SELECT DISTINCT pl.srp_plan_assign_id
1727: FROM cn_srp_plan_assigns_all pl
1728: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
1729: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
1730: )
1731: );

Line 1746: FROM cn_srp_plan_assigns_all pl

1742: INTO l_row_count
1743: FROM cn_srp_quota_rules_all ra
1744: WHERE ra.srp_plan_assign_id IN
1745: (SELECT DISTINCT pl.srp_plan_assign_id
1746: FROM cn_srp_plan_assigns_all pl
1747: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
1748: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
1749: );
1750:

Line 1758: l_table_name := 'cn_srp_plan_assigns_all';

1754: p_tot_rows_count := p_tot_rows_count + l_row_count;
1755: insert_archive(cn_srp_quota_rules_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1756: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:5 x_msg_data ' || x_msg_data);
1757:
1758: l_table_name := 'cn_srp_plan_assigns_all';
1759: SELECT COUNT(*)
1760: INTO l_row_count
1761: FROM cn_srp_plan_assigns_all
1762: WHERE ((start_date BETWEEN x_start_date AND x_end_date)

Line 1761: FROM cn_srp_plan_assigns_all

1757:
1758: l_table_name := 'cn_srp_plan_assigns_all';
1759: SELECT COUNT(*)
1760: INTO l_row_count
1761: FROM cn_srp_plan_assigns_all
1762: WHERE ((start_date BETWEEN x_start_date AND x_end_date)
1763: AND (end_date BETWEEN x_start_date AND x_end_date));
1764:
1765: x_msg_data := x_msg_data || 'cn_srp_plan_assigns_all count ' || l_row_count || ' : ';

Line 1765: x_msg_data := x_msg_data || 'cn_srp_plan_assigns_all count ' || l_row_count || ' : ';

1761: FROM cn_srp_plan_assigns_all
1762: WHERE ((start_date BETWEEN x_start_date AND x_end_date)
1763: AND (end_date BETWEEN x_start_date AND x_end_date));
1764:
1765: x_msg_data := x_msg_data || 'cn_srp_plan_assigns_all count ' || l_row_count || ' : ';
1766:
1767: x_msg_count := x_msg_count + 1;
1768: p_tot_rows_count := p_tot_rows_count + l_row_count;
1769: insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1769: insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1765: x_msg_data := x_msg_data || 'cn_srp_plan_assigns_all count ' || l_row_count || ' : ';
1766:
1767: x_msg_count := x_msg_count + 1;
1768: p_tot_rows_count := p_tot_rows_count + l_row_count;
1769: insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1770: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:6 x_msg_data ' || x_msg_data);
1771:
1772: EXCEPTION
1773: WHEN OTHERS THEN

Line 2627: from cn_srp_plan_assigns_all pl where ((pl.start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''

2623: if(p_table_space is not null) Then
2624: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2625: end if;
2626: l_sql := l_sql || ' as select * from cn_srp_payee_assigns_all pa where pa.srp_quota_assign_id in (Select distinct qa.srp_quota_assign_id from cn_srp_period_quotas_all qa where qa.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id
2627: from cn_srp_plan_assigns_all pl where ((pl.start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
2628: || ' ) and (pl.end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || '))))';
2629: EXECUTE immediate l_sql;
2630:
2631: SELECT COUNT(*)

Line 2639: FROM cn_srp_plan_assigns_all pl

2635: (SELECT DISTINCT qa.srp_quota_assign_id
2636: FROM cn_srp_period_quotas_all qa
2637: WHERE qa.srp_plan_assign_id IN
2638: (SELECT DISTINCT pl.srp_plan_assign_id
2639: FROM cn_srp_plan_assigns_all pl
2640: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
2641: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
2642: )
2643: );

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 2667: FROM cn_srp_plan_assigns_all pl

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)
2669: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
2670: );
2671: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_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 2693: FROM cn_srp_plan_assigns_all pl

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)
2695: AND pl.end_date BETWEEN x_start_date AND x_end_date)
2696: );
2697: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';

Line 2711: ' where qr.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl ' ||

2707: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2708: end if;
2709: l_sql := l_sql || ' as select * from cn_srp_rule_uplifts_all ru ' ||
2710: ' where ru.srp_quota_rule_id in (Select distinct qr.srp_quota_rule_id from cn_srp_quota_rules_all qr ' ||
2711: ' where qr.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl ' ||
2712: ' where ((pl.start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
2713: || ' ) and (pl.end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || '))))';
2714: EXECUTE immediate l_sql;
2715:

Line 2724: FROM cn_srp_plan_assigns_all pl

2720: (SELECT DISTINCT qr.srp_quota_rule_id
2721: FROM cn_srp_quota_rules_all qr
2722: WHERE qr.srp_plan_assign_id IN
2723: (SELECT DISTINCT pl.srp_plan_assign_id
2724: FROM cn_srp_plan_assigns_all pl
2725: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
2726: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
2727: )
2728: );

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

2737: l_sql := 'Create table ' || l_table_name ;
2738: if(p_table_space is not null) Then
2739: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2740: end if;
2741: l_sql := l_sql || ' as select * from cn_srp_quota_rules_all ra where ra.srp_plan_assign_id in (Select distinct pl.srp_plan_assign_id from cn_srp_plan_assigns_all pl
2742: where ((pl.start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||''''
2743: || ' ) and (pl.end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ')))';
2744: EXECUTE immediate l_sql;
2745:

Line 2751: FROM cn_srp_plan_assigns_all pl

2747: INTO l_row_count
2748: FROM cn_srp_quota_rules_all ra
2749: WHERE ra.srp_plan_assign_id IN
2750: (SELECT DISTINCT pl.srp_plan_assign_id
2751: FROM cn_srp_plan_assigns_all pl
2752: WHERE ((pl.start_date BETWEEN x_start_date AND x_end_date)
2753: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
2754: );
2755: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';

Line 2767: l_sql := l_sql || ' as select * from cn_srp_plan_assigns_all where ((start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ') and (end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ' ))';

2763: l_sql := 'Create table ' || l_table_name ;
2764: if(p_table_space is not null) Then
2765: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2766: end if;
2767: l_sql := l_sql || ' as select * from cn_srp_plan_assigns_all where ((start_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ') and (end_date between ''' || x_start_date ||'''' || ' and ''' || x_end_date ||'''' || ' ))';
2768: EXECUTE immediate l_sql;
2769:
2770: SELECT COUNT(*)
2771: INTO l_row_count

Line 2772: FROM cn_srp_plan_assigns_all

2768: EXECUTE immediate l_sql;
2769:
2770: SELECT COUNT(*)
2771: INTO l_row_count
2772: FROM cn_srp_plan_assigns_all
2773: WHERE ((start_date BETWEEN x_start_date AND x_end_date)
2774: AND (end_date BETWEEN x_start_date AND x_end_date));
2775: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2776: x_msg_count := x_msg_count + 1;

Line 2778: insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2774: AND (end_date BETWEEN x_start_date AND x_end_date));
2775: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2776: x_msg_count := x_msg_count + 1;
2777: p_tot_rows_count := p_tot_rows_count + l_row_count;
2778: insert_archive(cn_srp_plan_assigns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2779: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:6 x_msg_data ' || x_msg_data);
2780: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:6 x_return_status ' || x_return_status);
2781:
2782: EXCEPTION