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_WORKSHEET_QG_DTLS_ALL

Line 345: elsif (p_table_name = 'CN_WORKSHEET_QG_DTLS_ALL') THEN

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
346: DELETE
347: /*+ ROWID (cnh) */
348: FROM cn_worksheet_qg_dtls_all cnh
349: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id

Line 348: FROM cn_worksheet_qg_dtls_all cnh

344: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
345: elsif (p_table_name = 'CN_WORKSHEET_QG_DTLS_ALL') THEN
346: DELETE
347: /*+ ROWID (cnh) */
348: FROM cn_worksheet_qg_dtls_all cnh
349: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id
350: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
351: elsif (p_table_name = 'CN_PAYMENT_WORKSHEETS_ALL') THEN
352: DELETE

Line 1140: l_table_name := 'cn_worksheet_qg_dtls_all';

1136: p_addnl_para => '',
1137: x_row_to_process_flag => l_any_rows_to_process,
1138: x_return_status => x_return_status );
1139:
1140: l_table_name := 'cn_worksheet_qg_dtls_all';
1141:
1142: delete_table ( p_start_period_id => p_start_period_id,
1143: p_end_period_id => p_end_period_id,
1144: x_start_date => x_start_date,

Line 1362: l_table_name := 'cn_worksheet_qg_dtls_all';

1358: p_tot_rows_count := p_tot_rows_count + l_row_count;
1359: insert_archive(cn_pay_approval_flow_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1360: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:4 x_msg_data ' || x_msg_data);
1361:
1362: l_table_name := 'cn_worksheet_qg_dtls_all';
1363: SELECT COUNT(*)
1364: INTO l_row_count
1365: FROM cn_worksheet_qg_dtls_all
1366: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;

Line 1365: FROM cn_worksheet_qg_dtls_all

1361:
1362: l_table_name := 'cn_worksheet_qg_dtls_all';
1363: SELECT COUNT(*)
1364: INTO l_row_count
1365: FROM cn_worksheet_qg_dtls_all
1366: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1367:
1368: x_msg_data := x_msg_data || 'cn_worksheet_qg_dtls_all count ' || l_row_count || ' : ';
1369:

Line 1368: x_msg_data := x_msg_data || 'cn_worksheet_qg_dtls_all count ' || l_row_count || ' : ';

1364: INTO l_row_count
1365: FROM cn_worksheet_qg_dtls_all
1366: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
1367:
1368: x_msg_data := x_msg_data || 'cn_worksheet_qg_dtls_all count ' || l_row_count || ' : ';
1369:
1370: x_msg_count := x_msg_count + 1;
1371: p_tot_rows_count := p_tot_rows_count + l_row_count;
1372: insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1372: insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1368: x_msg_data := x_msg_data || 'cn_worksheet_qg_dtls_all count ' || l_row_count || ' : ';
1369:
1370: x_msg_count := x_msg_count + 1;
1371: p_tot_rows_count := p_tot_rows_count + l_row_count;
1372: insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1373: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:5 x_msg_data ' || x_msg_data);
1374:
1375: l_table_name := 'cn_payment_worksheets_all';
1376: SELECT COUNT(*)

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

2441: l_sql := 'Create table ' || l_table_name ;
2442: if(p_table_space is not null) Then
2443: l_sql := l_sql || ' TABLESPACE "' || p_table_space || '"';
2444: end if;
2445: l_sql := l_sql || ' as select * from cn_worksheet_qg_dtls_all where period_id between ' || p_start_period_id || ' and ' || p_end_period_id;
2446: EXECUTE immediate l_sql;
2447:
2448: SELECT COUNT(*)
2449: INTO l_row_count

Line 2450: FROM cn_worksheet_qg_dtls_all

2446: EXECUTE immediate l_sql;
2447:
2448: SELECT COUNT(*)
2449: INTO l_row_count
2450: FROM cn_worksheet_qg_dtls_all
2451: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2452: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2453: x_msg_count := x_msg_count + 1;
2454: p_tot_rows_count := p_tot_rows_count + l_row_count;

Line 2455: insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2451: WHERE period_id BETWEEN p_start_period_id AND p_end_period_id;
2452: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2453: x_msg_count := x_msg_count + 1;
2454: p_tot_rows_count := p_tot_rows_count + l_row_count;
2455: insert_archive(cn_worksheet_qg_dtls_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2456: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:6 x_msg_data ' || x_msg_data);
2457: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:6 x_return_status ' || x_return_status);
2458:
2459: l_table_name := 'cn_pymnt_wkshts' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');