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_PERIOD_QUOTAS_ALL

Line 319: FROM cn_srp_period_quotas_all qa

315: /*+ ROWID (qe) */
316: FROM cn_srp_period_quotas_ext_all qe
317: WHERE qe.srp_period_quota_id IN
318: (SELECT DISTINCT qa.srp_period_quota_id
319: FROM cn_srp_period_quotas_all qa
320: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
321: )
322: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
323: elsif (p_table_name = 'CN_SRP_PER_QUOTA_RC_ALL') THEN

Line 329: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_ALL') THEN

325: /*+ ROWID (cnh) */
326: FROM cn_srp_per_quota_rc_all cnh
327: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
328: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
329: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_ALL') THEN
330: DELETE
331: /*+ ROWID (cnh) */
332: FROM cn_srp_period_quotas_all cnh
333: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 332: FROM cn_srp_period_quotas_all cnh

328: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
329: elsif (p_table_name = 'CN_SRP_PERIOD_QUOTAS_ALL') THEN
330: DELETE
331: /*+ ROWID (cnh) */
332: FROM cn_srp_period_quotas_all cnh
333: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
334: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
335: elsif (p_table_name = 'CN_PAY_APPROVAL_FLOW_ALL') THEN
336: DELETE

Line 1107: l_table_name := 'cn_srp_period_quotas_all';

1103: p_addnl_para => '',
1104: x_row_to_process_flag => l_any_rows_to_process,
1105: x_return_status => x_return_status );
1106:
1107: l_table_name := 'cn_srp_period_quotas_all';
1108:
1109: delete_table ( p_start_period_id => p_start_period_id,
1110: p_end_period_id => p_end_period_id,
1111: x_start_date => x_start_date,

Line 1308: FROM cn_srp_period_quotas_all qa

1304: INTO l_row_count
1305: FROM cn_srp_period_quotas_ext_all qe
1306: WHERE qe.srp_period_quota_id IN
1307: (SELECT DISTINCT qa.srp_period_quota_id
1308: FROM cn_srp_period_quotas_all qa
1309: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
1310: );
1311:
1312: x_msg_data := x_msg_data || 'cn_srp_period_quotas_ext_all count ' || l_row_count || ' : ';

Line 1332: l_table_name := 'cn_srp_period_quotas_all';

1328: p_tot_rows_count := p_tot_rows_count + l_row_count;
1329: insert_archive(cn_srp_per_quota_rc_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1330: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:2 x_msg_data ' || x_msg_data);
1331:
1332: l_table_name := 'cn_srp_period_quotas_all';
1333: SELECT COUNT(*)
1334: INTO l_row_count
1335: FROM cn_srp_period_quotas_all
1336: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1335: FROM cn_srp_period_quotas_all

1331:
1332: l_table_name := 'cn_srp_period_quotas_all';
1333: SELECT COUNT(*)
1334: INTO l_row_count
1335: FROM cn_srp_period_quotas_all
1336: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1337:
1338: x_msg_data := x_msg_data || 'cn_srp_period_quotas_all count ' || l_row_count || ' : ';
1339:

Line 1338: x_msg_data := x_msg_data || 'cn_srp_period_quotas_all count ' || l_row_count || ' : ';

1334: INTO l_row_count
1335: FROM cn_srp_period_quotas_all
1336: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1337:
1338: x_msg_data := x_msg_data || 'cn_srp_period_quotas_all count ' || l_row_count || ' : ';
1339:
1340: x_msg_count := x_msg_count + 1;
1341: p_tot_rows_count := p_tot_rows_count + l_row_count;
1342: insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1342: insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1338: x_msg_data := x_msg_data || 'cn_srp_period_quotas_all count ' || l_row_count || ' : ';
1339:
1340: x_msg_count := x_msg_count + 1;
1341: p_tot_rows_count := p_tot_rows_count + l_row_count;
1342: insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1343: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:3 x_msg_data ' || x_msg_data);
1344:
1345: l_table_name := 'cn_pay_approval_flow_all';
1346: SELECT COUNT(*)

Line 1666: FROM cn_srp_period_quotas_all qa

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

Line 2359: ' qe.srp_period_quota_id in (Select distinct qa.srp_period_quota_id from cn_srp_period_quotas_all qa where qa.period_id between ' ||

2355: if(p_table_space is not null) Then
2356: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2357: end if;
2358: l_sql := l_sql || ' as select * from cn_srp_period_quotas_ext_all qe where ' ||
2359: ' qe.srp_period_quota_id in (Select distinct qa.srp_period_quota_id from cn_srp_period_quotas_all qa where qa.period_id between ' ||
2360: p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2361: EXECUTE immediate l_sql;
2362:
2363: SELECT COUNT(*)

Line 2368: FROM cn_srp_period_quotas_all qa

2364: INTO l_row_count
2365: FROM cn_srp_period_quotas_ext_all qe
2366: WHERE qe.srp_period_quota_id IN
2367: (SELECT DISTINCT qa.srp_period_quota_id
2368: FROM cn_srp_period_quotas_all qa
2369: WHERE qa.period_id BETWEEN p_start_period_id AND p_end_period_id
2370: );
2371: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2372: x_msg_count := x_msg_count + 1;

Line 2403: l_sql := l_sql || ' as select * from cn_srp_period_quotas_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;

2399: l_sql := 'Create table ' || l_table_name ;
2400: if(p_table_space is not null) Then
2401: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2402: end if;
2403: l_sql := l_sql || ' as select * from cn_srp_period_quotas_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2404: EXECUTE immediate l_sql;
2405:
2406: SELECT COUNT(*)
2407: INTO l_row_count

Line 2408: FROM cn_srp_period_quotas_all

2404: EXECUTE immediate l_sql;
2405:
2406: SELECT COUNT(*)
2407: INTO l_row_count
2408: FROM cn_srp_period_quotas_all
2409: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2410: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2411: x_msg_count := x_msg_count + 1;
2412: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2413: insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2409: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2410: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2411: x_msg_count := x_msg_count + 1;
2412: p_tot_rows_count := p_tot_rows_count + l_row_count;
2413: insert_archive(cn_srp_period_quotas_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2414: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:4 x_msg_data ' || x_msg_data);
2415: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:4 x_return_status ' || x_return_status);
2416:
2417: l_table_name := 'cn_pay_aprv_flw' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');

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 2636: FROM cn_srp_period_quotas_all qa

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