APPS.CN_PURGE_TABLES_PVT dependencies on CN_PAYMENT_WORKSHEETS_ALL

Line 351: elsif (p_table_name = 'CN_PAYMENT_WORKSHEETS_ALL') THEN

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
353: /*+ ROWID (pw) */
354: FROM cn_payment_worksheets_all pw
355: WHERE pw.payrun_id IN

Line 354: FROM cn_payment_worksheets_all pw

350: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
351: elsif (p_table_name = 'CN_PAYMENT_WORKSHEETS_ALL') THEN
352: DELETE
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

Line 387: elsif (p_table_name = 'CN_PAYMENT_WORKSHEETS_ALL') THEN

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
388: DELETE
389: /*+ ROWID (pw) */
390: FROM cn_payment_worksheets_all pw
391: WHERE pw.payrun_id IN

Line 390: FROM cn_payment_worksheets_all pw

386: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
387: elsif (p_table_name = 'CN_PAYMENT_WORKSHEETS_ALL') THEN
388: DELETE
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

Line 1156: l_table_name := 'cn_payment_worksheets_all';

1152: p_addnl_para => '',
1153: x_row_to_process_flag => l_any_rows_to_process,
1154: x_return_status => x_return_status );
1155:
1156: l_table_name := 'cn_payment_worksheets_all';
1157:
1158: delete_table ( p_start_period_id => p_start_period_id,
1159: p_end_period_id => p_end_period_id,
1160: x_start_date => x_start_date,

Line 1375: l_table_name := 'cn_payment_worksheets_all';

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(*)
1377: INTO l_row_count
1378: FROM cn_payment_worksheets_all pw
1379: WHERE pw.payrun_id IN

Line 1378: FROM cn_payment_worksheets_all pw

1374:
1375: l_table_name := 'cn_payment_worksheets_all';
1376: SELECT COUNT(*)
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

Line 1385: x_msg_data := x_msg_data || 'cn_payment_worksheets_all count ' || l_row_count || ' : ';

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 || ' : ';
1386:
1387: x_msg_count := x_msg_count + 1;
1388: p_tot_rows_count := p_tot_rows_count + l_row_count;
1389: insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

Line 1389: insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

1385: x_msg_data := x_msg_data || 'cn_payment_worksheets_all count ' || l_row_count || ' : ';
1386:
1387: x_msg_count := x_msg_count + 1;
1388: p_tot_rows_count := p_tot_rows_count + l_row_count;
1389: insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
1390: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_subledgers:6 x_msg_data ' || x_msg_data);
1391:
1392: l_table_name := 'cn_ledger_journal_entries_all';
1393: SELECT COUNT(*)

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 2469: FROM cn_payment_worksheets_all pw

2465: EXECUTE immediate l_sql;
2466:
2467: SELECT COUNT(*)
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

Line 2478: insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);

2474: );
2475: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2476: x_msg_count := x_msg_count + 1;
2477: p_tot_rows_count := p_tot_rows_count + l_row_count;
2478: insert_archive(cn_payment_worksheets_all_id,p_cn_archive_all_s,upper(l_table_name),l_row_count,l_any_rows_to_process);
2479: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:7 x_msg_data ' || x_msg_data);
2480: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:7 x_return_status ' || x_return_status);
2481:
2482: l_table_name := 'cn_ldgr_jrnl_en' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');