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_PAYEE_ASSIGNS_ALL

Line 1513: l_table_name := 'cn_srp_payee_assigns_all';

1509: END IF;
1510:
1511: x_return_status := 'S';
1512:
1513: l_table_name := 'cn_srp_payee_assigns_all';
1514: delete_table ( p_start_period_id => p_start_period_id,
1515: p_end_period_id => p_end_period_id,
1516: x_start_date => x_start_date,
1517: x_end_date => x_end_date,

Line 1660: l_table_name := 'cn_srp_payee_assigns_all';

1656:
1657: x_return_status := 'S';
1658: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_refrences:0 x_msg_data ' || x_msg_data);
1659:
1660: l_table_name := 'cn_srp_payee_assigns_all';
1661: SELECT COUNT(*)
1662: INTO l_row_count
1663: FROM cn_srp_payee_assigns_all pa
1664: WHERE pa.srp_quota_assign_id IN

Line 1663: FROM cn_srp_payee_assigns_all pa

1659:
1660: l_table_name := 'cn_srp_payee_assigns_all';
1661: SELECT COUNT(*)
1662: INTO l_row_count
1663: FROM cn_srp_payee_assigns_all pa
1664: WHERE pa.srp_quota_assign_id IN
1665: (SELECT DISTINCT qa.srp_quota_assign_id
1666: FROM cn_srp_period_quotas_all qa
1667: WHERE qa.srp_plan_assign_id IN

Line 1675: x_msg_data := x_msg_data || 'cn_srp_payee_assigns_all count ' || l_row_count || ' : ';

1671: AND (pl.end_date BETWEEN x_start_date AND x_end_date))
1672: )
1673: );
1674:
1675: x_msg_data := x_msg_data || 'cn_srp_payee_assigns_all count ' || l_row_count || ' : ';
1676:
1677: x_msg_count := x_msg_count + 1;
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);

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

1675: x_msg_data := x_msg_data || 'cn_srp_payee_assigns_all count ' || l_row_count || ' : ';
1676:
1677: x_msg_count := x_msg_count + 1;
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(*)

Line 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

2622: l_sql := 'Create table ' || l_table_name ;
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:

Line 2633: FROM cn_srp_payee_assigns_all pa

2629: EXECUTE immediate l_sql;
2630:
2631: SELECT COUNT(*)
2632: INTO l_row_count
2633: FROM cn_srp_payee_assigns_all pa
2634: WHERE pa.srp_quota_assign_id IN
2635: (SELECT DISTINCT qa.srp_quota_assign_id
2636: FROM cn_srp_period_quotas_all qa
2637: WHERE qa.srp_plan_assign_id IN

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

2643: );
2644: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2645: x_msg_count := x_msg_count + 1;
2646: p_tot_rows_count := p_tot_rows_count + l_row_count;
2647: 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);
2648: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:2 x_msg_data ' || x_msg_data);
2649: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_references:2 x_return_status ' || x_return_status);
2650:
2651: l_table_name := 'cn_srp_quta_asn' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');