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_PAYRUNS_ALL

Line 341: FROM cn_payruns_all pa

337: /*+ ROWID (af) */
338: FROM cn_pay_approval_flow_all af
339: WHERE af.payrun_id IN
340: (SELECT DISTINCT pa.payrun_id
341: FROM cn_payruns_all pa
342: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
343: )
344: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
345: elsif (p_table_name = 'CN_WORKSHEET_QG_DTLS_ALL') THEN

Line 357: FROM cn_payruns_all pa

353: /*+ ROWID (pw) */
354: FROM cn_payment_worksheets_all pw
355: WHERE pw.payrun_id IN
356: (SELECT DISTINCT pa.payrun_id
357: FROM cn_payruns_all pa
358: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
359: )
360: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
361: elsif (p_table_name = 'CN_LEDGER_JOURNAL_ENTRIES_ALL') THEN

Line 383: FROM cn_payruns_all pa

379: /*+ ROWID (wb) */
380: FROM cn_worksheet_bonuses_all wb
381: WHERE wb.payrun_id IN
382: (SELECT DISTINCT pa.payrun_id
383: FROM cn_payruns_all pa
384: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
385: )
386: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
387: elsif (p_table_name = 'CN_PAYMENT_WORKSHEETS_ALL') THEN

Line 393: FROM cn_payruns_all pa

389: /*+ ROWID (pw) */
390: FROM cn_payment_worksheets_all pw
391: WHERE pw.payrun_id IN
392: (SELECT DISTINCT pa.payrun_id
393: FROM cn_payruns_all pa
394: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
395: )
396: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
397: elsif (p_table_name = 'CN_PAYRUNS_ALL') THEN

Line 397: elsif (p_table_name = 'CN_PAYRUNS_ALL') THEN

393: FROM cn_payruns_all pa
394: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
395: )
396: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
397: elsif (p_table_name = 'CN_PAYRUNS_ALL') THEN
398: DELETE
399: /*+ ROWID (cnh) */
400: FROM cn_payruns_all cnh
401: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id

Line 400: FROM cn_payruns_all cnh

396: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
397: elsif (p_table_name = 'CN_PAYRUNS_ALL') THEN
398: DELETE
399: /*+ ROWID (cnh) */
400: FROM cn_payruns_all cnh
401: WHERE pay_period_id BETWEEN p_start_period_id AND p_end_period_id
402: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
403: elsif (p_table_name = 'CN_SRP_PERIODS_ALL') THEN
404: DELETE

Line 1221: l_table_name := 'cn_payruns_all';

1217: p_addnl_para => '',
1218: x_row_to_process_flag => l_any_rows_to_process,
1219: x_return_status => x_return_status );
1220:
1221: l_table_name := 'cn_payruns_all';
1222:
1223: delete_table ( p_start_period_id => p_start_period_id,
1224: p_end_period_id => p_end_period_id,
1225: x_start_date => x_start_date,

Line 1351: FROM cn_payruns_all pa

1347: INTO l_row_count
1348: FROM cn_pay_approval_flow_all af
1349: WHERE af.payrun_id IN
1350: (SELECT DISTINCT pa.payrun_id
1351: FROM cn_payruns_all pa
1352: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
1353: );
1354:
1355: x_msg_data := x_msg_data || 'cn_pay_approval_flow_all count ' || l_row_count || ' : ';

Line 1381: FROM cn_payruns_all pa

1377: INTO l_row_count
1378: FROM cn_payment_worksheets_all pw
1379: WHERE pw.payrun_id IN
1380: (SELECT DISTINCT pa.payrun_id
1381: FROM cn_payruns_all pa
1382: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
1383: );
1384:
1385: x_msg_data := x_msg_data || 'cn_payment_worksheets_all count ' || l_row_count || ' : ';

Line 1428: FROM cn_payruns_all pa

1424: INTO l_row_count
1425: FROM cn_worksheet_bonuses_all wb
1426: WHERE wb.payrun_id IN
1427: (SELECT DISTINCT pa.payrun_id
1428: FROM cn_payruns_all pa
1429: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
1430: );
1431:
1432: x_msg_data := x_msg_data || 'cn_worksheet_bonuses_all count ' || l_row_count || ' : ';

Line 1439: l_table_name := 'cn_payruns_all';

1435: p_tot_rows_count := p_tot_rows_count + l_row_count;
1436: insert_archive(cn_worksheet_bonuses_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1437: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:9 x_msg_data ' || x_msg_data);
1438:
1439: l_table_name := 'cn_payruns_all';
1440: SELECT COUNT(*)
1441: INTO l_row_count
1442: FROM cn_payruns_all
1443: WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;

Line 1442: FROM cn_payruns_all

1438:
1439: l_table_name := 'cn_payruns_all';
1440: SELECT COUNT(*)
1441: INTO l_row_count
1442: FROM cn_payruns_all
1443: WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;
1444:
1445: x_msg_data := x_msg_data || 'cn_payruns_all count ' || l_row_count || ' : ';
1446:

Line 1445: x_msg_data := x_msg_data || 'cn_payruns_all count ' || l_row_count || ' : ';

1441: INTO l_row_count
1442: FROM cn_payruns_all
1443: WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;
1444:
1445: x_msg_data := x_msg_data || 'cn_payruns_all count ' || l_row_count || ' : ';
1446:
1447: x_msg_count := x_msg_count + 1;
1448: p_tot_rows_count := p_tot_rows_count + l_row_count;
1449: insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1449: insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1445: x_msg_data := x_msg_data || 'cn_payruns_all count ' || l_row_count || ' : ';
1446:
1447: x_msg_count := x_msg_count + 1;
1448: p_tot_rows_count := p_tot_rows_count + l_row_count;
1449: insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1450: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:10 x_msg_data ' || x_msg_data);
1451:
1452: l_table_name := 'cn_srp_periods_all';
1453: SELECT COUNT(*)

Line 2422: l_sql := l_sql || ' as select * from cn_pay_approval_flow_all af where af.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

2418: l_sql := 'Create table ' || l_table_name ;
2419: if(p_table_space is not null) Then
2420: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2421: end if;
2422: l_sql := l_sql || ' as select * from cn_pay_approval_flow_all af where af.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2423: EXECUTE immediate l_sql;
2424:
2425: SELECT COUNT(*)
2426: INTO l_row_count

Line 2430: FROM cn_payruns_all pa

2426: INTO l_row_count
2427: FROM cn_pay_approval_flow_all af
2428: WHERE af.payrun_id IN
2429: (SELECT DISTINCT pa.payrun_id
2430: FROM cn_payruns_all pa
2431: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
2432: );
2433: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2434: x_msg_count := x_msg_count + 1;

Line 2464: l_sql := l_sql || ' as select * from cn_payment_worksheets_all pw where pw.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

2460: l_sql := 'Create table ' || l_table_name ;
2461: if(p_table_space is not null) Then
2462: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2463: end if;
2464: l_sql := l_sql || ' as select * from cn_payment_worksheets_all pw where pw.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2465: EXECUTE immediate l_sql;
2466:
2467: SELECT COUNT(*)
2468: INTO l_row_count

Line 2472: FROM cn_payruns_all pa

2468: INTO l_row_count
2469: FROM cn_payment_worksheets_all pw
2470: WHERE pw.payrun_id IN
2471: (SELECT DISTINCT pa.payrun_id
2472: FROM cn_payruns_all pa
2473: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
2474: );
2475: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2476: x_msg_count := x_msg_count + 1;

Line 2529: l_sql := l_sql || ' as select * from cn_worksheet_bonuses_all wb where wb.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';

2525: l_sql := 'Create table ' || l_table_name ;
2526: if(p_table_space is not null) Then
2527: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2528: end if;
2529: l_sql := l_sql || ' as select * from cn_worksheet_bonuses_all wb where wb.payrun_id in (Select distinct pa.payrun_id from cn_payruns_all pa where pa.PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id || ' ) ';
2530: EXECUTE immediate l_sql;
2531:
2532: SELECT COUNT(*)
2533: INTO l_row_count

Line 2537: FROM cn_payruns_all pa

2533: INTO l_row_count
2534: FROM cn_worksheet_bonuses_all wb
2535: WHERE wb.payrun_id IN
2536: (SELECT DISTINCT pa.payrun_id
2537: FROM cn_payruns_all pa
2538: WHERE pa.PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id
2539: );
2540: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2541: x_msg_count := x_msg_count + 1;

Line 2552: l_sql := l_sql || ' as select * from cn_payruns_all where PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id;

2548: l_sql := 'Create table ' || l_table_name ;
2549: if(p_table_space is not null) Then
2550: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2551: end if;
2552: l_sql := l_sql || ' as select * from cn_payruns_all where PAY_PERIOD_ID between ' || p_start_period_id || ' and ' || p_end_period_id;
2553: EXECUTE immediate l_sql;
2554:
2555: SELECT COUNT(*)
2556: INTO l_row_count

Line 2557: FROM cn_payruns_all

2553: EXECUTE immediate l_sql;
2554:
2555: SELECT COUNT(*)
2556: INTO l_row_count
2557: FROM cn_payruns_all
2558: WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;
2559: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2560: x_msg_count := x_msg_count + 1;
2561: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2562: insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2558: WHERE PAY_PERIOD_ID BETWEEN p_start_period_id AND p_end_period_id;
2559: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2560: x_msg_count := x_msg_count + 1;
2561: p_tot_rows_count := p_tot_rows_count + l_row_count;
2562: insert_archive(cn_payruns_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2563: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:11 x_msg_data ' || x_msg_data);
2564: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:11 x_return_status ' || x_return_status);
2565:
2566: l_table_name := 'cn_srp_periods' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');