The following lines contain the word 'select', 'insert', 'update' or 'delete':
UPDATE PA_TASKS SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_PROJECTS SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_PROJECT_TYPES SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_EXPENDITURE_TYPES SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_CLASS_CATEGORIES SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_CLASS_CODES SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_PROJECT_CLASSES SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_BUDGET_TYPES SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_RESOURCE_LIST_MEMBERS SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_RESOURCE_LISTS SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_TXN_ACCUM SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_RESOURCE_ACCUM_DETAILS SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
UPDATE PA_BUDGET_VERSIONS SET ADW_NOTIFY_FLAG='Y'
WHERE ADW_NOTIFY_FLAG = 'N';
DELETE FROM PA_TOP_TASKS_IT;
DELETE FROM PA_PROJECTS_IT;
DELETE FROM PA_PRJ_TYPES_IT;
DELETE FROM PA_EXP_TYPES_IT;
DELETE FROM PA_PRJ_CLASSES_IT;
DELETE FROM PA_CLASS_CATGS_IT;
DELETE FROM PA_CLASS_CODES_IT;
DELETE FROM PA_LOWEST_RLMEM_IT;
DELETE FROM PA_TOP_RLMEM_IT;
DELETE FROM PA_RES_LISTS_IT;
DELETE FROM PA_SRVC_TYPES_IT;
DELETE FROM PA_PERIODS_IT;
DELETE FROM PA_ORGS_IT;
DELETE FROM PA_BGT_TYPES_IT;
DELETE FROM PA_TSK_ACT_CMT_IT;
DELETE FROM PA_PRJ_ACT_CMT_IT;
DELETE FROM PA_TSK_BGT_LINES_IT;
DELETE FROM PA_PRJ_BGT_LINES_IT;
DELETE FROM PA_OLD_RES_ACCUM_DTLS;
DELETE FROM PA_OPER_UNITS_IT;
DELETE FROM PA_GL_PERIODS_IT;
DELETE FROM PA_FINANCIAL_QTRS_IT;
DELETE FROM PA_FINANCIAL_YRS_IT;
DELETE FROM PA_ALL_FINANCIAL_YRS_IT;
DELETE FROM PA_ALL_EXP_TYPES_IT;
DELETE FROM PA_ALL_SRVC_TYPES_IT;
DELETE FROM PA_ALL_PRJ_TYPES_IT;
DELETE FROM PA_PRJ_ORGS_IT;
DELETE FROM PA_PRJ_BUSINESS_GRPS_IT;
DELETE FROM PA_EXP_ORGS_IT;
DELETE FROM PA_EXP_BUSINESS_GRPS_IT;
DELETE FROM PA_SET_OF_BOOKS_IT;
DELETE FROM PA_LEGAL_ENTITY_IT;
x_wh_update_date IN DATE)
IS
sql_command VARCHAR2(1024);
rows_deleted integer;
'DELETE FROM '|| x_table_name
|| ' WHERE WH_UPDATE_DATE <= :x_wh_update_date';
dbms_sql.bind_variable(source_cursor, 'x_wh_update_date', x_wh_update_date);
rows_deleted := dbms_sql.execute(source_cursor);
pa_debug.debug('Rows deleted:= ' || to_char(rows_deleted));
/* Get the Warehouse Update DATE */
/* Get the warehouse update date using a dynamic SQL, since
WH_RT_VERSIONS_V2 is available in the OADW Warehouse Database */
oadw_wh_cursor := dbms_sql.open_cursor;
'SELECT earliest_collect_time FROM wh_rt_versions_v2@PA_TO_WH',dbms_sql.native);
DELETE FROM PA_TOP_TASKS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PROJECTS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PRJ_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_EXP_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PRJ_CLASSES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_CLASS_CATGS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_CLASS_CODES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_LOWEST_RLMEM_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_TOP_RLMEM_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_RES_LISTS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_SRVC_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PERIODS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_ORGS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_BGT_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_TSK_ACT_CMT_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PRJ_ACT_CMT_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_TSK_BGT_LINES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PRJ_BGT_LINES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_OPER_UNITS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_GL_PERIODS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_FINANCIAL_QTRS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_FINANCIAL_YRS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_ALL_FINANCIAL_YRS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_ALL_EXP_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_ALL_SRVC_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_ALL_PRJ_TYPES_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PRJ_ORGS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_PRJ_BUSINESS_GRPS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_EXP_ORGS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_EXP_BUSINESS_GRPS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_SET_OF_BOOKS_IT
WHERE STATUS_CODE = 'T';
DELETE FROM PA_LEGAL_ENTITY_IT
WHERE STATUS_CODE = 'T';