APPS.CN_PURGE_TABLES_PVT dependencies on DUAL

Line 136: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

132: (
133: 'CN_PURGE_TABLES_PVT.delete_table:p_batch_size ' || p_batch_size
134: )
135: ;
136: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;
137:
138: debugmsg('CN_PURGE_TABLES_PVT.delete_table: delete start l_time ' || l_time );
139:
140: ad_parallel_updates_pkg.initialize_rowid_range( ad_parallel_updates_pkg.ROWID_RANGE, p_table_owner, p_table_name, p_script_name, p_worker_id, p_no_of_workers, p_batch_size, 0);

Line 456: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;

452: ad_parallel_updates_pkg.get_rowid_range( l_start_rowid, l_end_rowid, l_any_rows_to_process, p_batch_size, FALSE);
453:
454: END LOOP;
455:
456: SELECT TO_CHAR(sysdate,'dd-mm-rr:hh:mi:ss') INTO l_time FROM dual;
457: debugmsg('CN_PURGE_TABLES_PVT.delete_table: delete end l_time ' || l_time );
458: debugmsg('CN_PURGE_TABLES_PVT.delete_table:end final ' );
459: EXCEPTION
460: WHEN OTHERS THEN

Line 2896: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

2892: elsif (p_run_mode = 'P') Then
2893: l_run_mode := 'PURGE';
2894: end if;
2895:
2896: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;
2897: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: l_cn_archive_all_s : ' || l_cn_archive_all_s);
2898: debugmsg('CN_PURGE_TABLES_PVT.archive_cn_tables before archive_cn_tables_transactions ');
2899:
2900: archive_cn_tables_transactions ( p_start_period_id => p_start_period_id,

Line 3039: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

3035: elsif (p_run_mode = 'P') Then
3036: l_run_mode := 'PURGE';
3037: end if;
3038:
3039: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;
3040:
3041: debugmsg('CN_PURGE_TABLES_PVT.purge_cn_tables: l_cn_archive_all_s : ' || l_cn_archive_all_s);
3042:
3043:

Line 3173: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;

3169:
3170: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: x_start_date: ' || x_start_date);
3171: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: x_end_date: ' || x_end_date);
3172:
3173: SELECT CN_ARC_AUDIT_ALL_S.nextval INTO l_cn_archive_all_s FROM dual;
3174:
3175: debugmsg('CN_PURGE_TABLES_PVT.audit_purge_cn_tables: l_cn_archive_all_s : ' || l_cn_archive_all_s);
3176:
3177: