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_PAY_APPROVAL_FLOW_ALL

Line 335: elsif (p_table_name = 'CN_PAY_APPROVAL_FLOW_ALL') THEN

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
337: /*+ ROWID (af) */
338: FROM cn_pay_approval_flow_all af
339: WHERE af.payrun_id IN

Line 338: FROM cn_pay_approval_flow_all af

334: AND rowid BETWEEN l_start_rowid AND l_end_rowid;
335: elsif (p_table_name = 'CN_PAY_APPROVAL_FLOW_ALL') THEN
336: DELETE
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

Line 1124: l_table_name := 'cn_pay_approval_flow_all';

1120: x_row_to_process_flag => l_any_rows_to_process,
1121: x_return_status => x_return_status );
1122:
1123:
1124: l_table_name := 'cn_pay_approval_flow_all';
1125:
1126: delete_table ( p_start_period_id => p_start_period_id,
1127: p_end_period_id => p_end_period_id,
1128: x_start_date => x_start_date,

Line 1345: l_table_name := 'cn_pay_approval_flow_all';

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(*)
1347: INTO l_row_count
1348: FROM cn_pay_approval_flow_all af
1349: WHERE af.payrun_id IN

Line 1348: FROM cn_pay_approval_flow_all af

1344:
1345: l_table_name := 'cn_pay_approval_flow_all';
1346: SELECT COUNT(*)
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

Line 1355: x_msg_data := x_msg_data || 'cn_pay_approval_flow_all count ' || l_row_count || ' : ';

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 || ' : ';
1356:
1357: x_msg_count := x_msg_count + 1;
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);

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

1355: x_msg_data := x_msg_data || 'cn_pay_approval_flow_all count ' || l_row_count || ' : ';
1356:
1357: x_msg_count := x_msg_count + 1;
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(*)

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 2427: FROM cn_pay_approval_flow_all af

2423: EXECUTE immediate l_sql;
2424:
2425: SELECT COUNT(*)
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

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

2432: );
2433: x_msg_data := x_msg_data || l_table_name || ' count ' || l_row_count || ' : ';
2434: x_msg_count := x_msg_count + 1;
2435: p_tot_rows_count := p_tot_rows_count + l_row_count;
2436: 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);
2437: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:5 x_msg_data ' || x_msg_data);
2438: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables_subledgers:5 x_return_status ' || x_return_status);
2439:
2440: l_table_name := 'cn_wksht_qg_dtl' || '_' || to_char(sysdate, 'DDMMYYYYHH24MI');