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_RULES_ALL

Line 286: FROM cn_srp_quota_rules_all qr

282: /*+ ROWID (ru) */
283: FROM cn_srp_rule_uplifts_all ru
284: WHERE ru.srp_quota_rule_id IN
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)

Line 295: elsif (p_table_name = 'CN_SRP_QUOTA_RULES_ALL') THEN

291: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
292: )
293: )
294: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
295: elsif (p_table_name = 'CN_SRP_QUOTA_RULES_ALL') THEN
296: DELETE
297: /*+ ROWID (ra) */
298: FROM cn_srp_quota_rules_all ra
299: WHERE ra.srp_plan_assign_id IN

Line 298: FROM cn_srp_quota_rules_all ra

294: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
295: elsif (p_table_name = 'CN_SRP_QUOTA_RULES_ALL') THEN
296: DELETE
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)

Line 1578: l_table_name := 'cn_srp_quota_rules_all';

1574: x_row_to_process_flag => l_any_rows_to_process,
1575: x_return_status => x_return_status );
1576:
1577:
1578: l_table_name := 'cn_srp_quota_rules_all';
1579:
1580: delete_table ( p_start_period_id => p_start_period_id,
1581: p_end_period_id => p_end_period_id,
1582: x_start_date => x_start_date,

Line 1724: FROM cn_srp_quota_rules_all qr

1720: INTO l_row_count
1721: FROM cn_srp_rule_uplifts_all ru
1722: WHERE ru.srp_quota_rule_id IN
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)

Line 1740: l_table_name := 'cn_srp_quota_rules_all';

1736: p_tot_rows_count := p_tot_rows_count + l_row_count;
1737: insert_archive(cn_srp_rule_uplifts_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1738: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:4 x_msg_data ' || x_msg_data);
1739:
1740: l_table_name := 'cn_srp_quota_rules_all';
1741: SELECT COUNT(*)
1742: INTO l_row_count
1743: FROM cn_srp_quota_rules_all ra
1744: WHERE ra.srp_plan_assign_id IN

Line 1743: FROM cn_srp_quota_rules_all ra

1739:
1740: l_table_name := 'cn_srp_quota_rules_all';
1741: SELECT COUNT(*)
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)

Line 1751: x_msg_data := x_msg_data || 'cn_srp_quota_rules_all count ' || l_row_count || ' : ';

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:
1751: x_msg_data := x_msg_data || 'cn_srp_quota_rules_all count ' || l_row_count || ' : ';
1752:
1753: x_msg_count := x_msg_count + 1;
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);

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

1751: x_msg_data := x_msg_data || 'cn_srp_quota_rules_all count ' || l_row_count || ' : ';
1752:
1753: x_msg_count := x_msg_count + 1;
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(*)

Line 2710: ' where ru.srp_quota_rule_id in (Select distinct qr.srp_quota_rule_id from cn_srp_quota_rules_all qr ' ||

2706: if(p_table_space is not null) Then
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;

Line 2721: FROM cn_srp_quota_rules_all qr

2717: INTO l_row_count
2718: FROM cn_srp_rule_uplifts_all ru
2719: WHERE ru.srp_quota_rule_id IN
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)

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 2748: FROM cn_srp_quota_rules_all ra

2744: EXECUTE immediate l_sql;
2745:
2746: SELECT COUNT(*)
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)

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

2754: );
2755: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2756: x_msg_count := x_msg_count + 1;
2757: p_tot_rows_count := p_tot_rows_count + l_row_count;
2758: 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);
2759: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:5 x_msg_data ' || x_msg_data);
2760: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:5 x_return_status ' || x_return_status);
2761:
2762: l_table_name := 'cn_srp_plan_asn' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');