APPS.PA_ADW_COLLECT_MAIN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 151

     UPDATE PA_TASKS SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 154

     UPDATE PA_PROJECTS SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 157

     UPDATE PA_PROJECT_TYPES SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 160

     UPDATE PA_EXPENDITURE_TYPES SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 163

     UPDATE PA_CLASS_CATEGORIES SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 166

     UPDATE PA_CLASS_CODES SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 169

     UPDATE PA_PROJECT_CLASSES SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 172

     UPDATE PA_BUDGET_TYPES SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 175

     UPDATE PA_RESOURCE_LIST_MEMBERS SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 178

     UPDATE PA_RESOURCE_LISTS SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 181

     UPDATE PA_TXN_ACCUM SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 184

     UPDATE PA_RESOURCE_ACCUM_DETAILS SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 187

     UPDATE PA_BUDGET_VERSIONS SET ADW_NOTIFY_FLAG='Y'
     WHERE ADW_NOTIFY_FLAG = 'N';

Line: 215

     DELETE FROM PA_TOP_TASKS_IT;

Line: 216

     DELETE FROM PA_PROJECTS_IT;

Line: 217

     DELETE FROM PA_PRJ_TYPES_IT;

Line: 218

     DELETE FROM PA_EXP_TYPES_IT;

Line: 219

     DELETE FROM PA_PRJ_CLASSES_IT;

Line: 220

     DELETE FROM PA_CLASS_CATGS_IT;

Line: 221

     DELETE FROM PA_CLASS_CODES_IT;

Line: 222

     DELETE FROM PA_LOWEST_RLMEM_IT;

Line: 223

     DELETE FROM PA_TOP_RLMEM_IT;

Line: 224

     DELETE FROM PA_RES_LISTS_IT;

Line: 225

     DELETE FROM PA_SRVC_TYPES_IT;

Line: 226

     DELETE FROM PA_PERIODS_IT;

Line: 227

     DELETE FROM PA_ORGS_IT;

Line: 228

     DELETE FROM PA_BGT_TYPES_IT;

Line: 229

     DELETE FROM PA_TSK_ACT_CMT_IT;

Line: 230

     DELETE FROM PA_PRJ_ACT_CMT_IT;

Line: 231

     DELETE FROM PA_TSK_BGT_LINES_IT;

Line: 232

     DELETE FROM PA_PRJ_BGT_LINES_IT;

Line: 233

     DELETE FROM PA_OLD_RES_ACCUM_DTLS;

Line: 234

     DELETE FROM PA_OPER_UNITS_IT;

Line: 235

     DELETE FROM PA_GL_PERIODS_IT;

Line: 236

     DELETE FROM PA_FINANCIAL_QTRS_IT;

Line: 237

     DELETE FROM PA_FINANCIAL_YRS_IT;

Line: 238

     DELETE FROM PA_ALL_FINANCIAL_YRS_IT;

Line: 239

     DELETE FROM PA_ALL_EXP_TYPES_IT;

Line: 240

     DELETE FROM PA_ALL_SRVC_TYPES_IT;

Line: 241

     DELETE FROM PA_ALL_PRJ_TYPES_IT;

Line: 242

     DELETE FROM PA_PRJ_ORGS_IT;

Line: 243

     DELETE FROM PA_PRJ_BUSINESS_GRPS_IT;

Line: 244

     DELETE FROM PA_EXP_ORGS_IT;

Line: 245

     DELETE FROM PA_EXP_BUSINESS_GRPS_IT;

Line: 246

     DELETE FROM PA_SET_OF_BOOKS_IT;

Line: 247

     DELETE FROM PA_LEGAL_ENTITY_IT;

Line: 265

                          x_wh_update_date       IN DATE)
   IS
     sql_command   VARCHAR2(1024);

Line: 269

     rows_deleted  integer;

Line: 277

                    'DELETE FROM '|| x_table_name
                     || ' WHERE WH_UPDATE_DATE <= :x_wh_update_date';

Line: 280

     dbms_sql.bind_variable(source_cursor, 'x_wh_update_date', x_wh_update_date);

Line: 281

     rows_deleted := dbms_sql.execute(source_cursor);

Line: 282

     pa_debug.debug('Rows deleted:= ' || to_char(rows_deleted));

Line: 318

         /* 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;

Line: 324

         'SELECT earliest_collect_time FROM wh_rt_versions_v2@PA_TO_WH',dbms_sql.native);

Line: 425

     DELETE FROM PA_TOP_TASKS_IT
     WHERE STATUS_CODE = 'T';

Line: 428

     DELETE FROM PA_PROJECTS_IT
     WHERE STATUS_CODE = 'T';

Line: 431

     DELETE FROM PA_PRJ_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 434

     DELETE FROM PA_EXP_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 437

     DELETE FROM PA_PRJ_CLASSES_IT
     WHERE STATUS_CODE = 'T';

Line: 440

     DELETE FROM PA_CLASS_CATGS_IT
     WHERE STATUS_CODE = 'T';

Line: 443

     DELETE FROM PA_CLASS_CODES_IT
     WHERE STATUS_CODE = 'T';

Line: 446

     DELETE FROM PA_LOWEST_RLMEM_IT
     WHERE STATUS_CODE = 'T';

Line: 449

     DELETE FROM PA_TOP_RLMEM_IT
     WHERE STATUS_CODE = 'T';

Line: 452

     DELETE FROM PA_RES_LISTS_IT
     WHERE STATUS_CODE = 'T';

Line: 455

     DELETE FROM PA_SRVC_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 458

     DELETE FROM PA_PERIODS_IT
     WHERE STATUS_CODE = 'T';

Line: 461

     DELETE FROM PA_ORGS_IT
     WHERE STATUS_CODE = 'T';

Line: 464

     DELETE FROM PA_BGT_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 467

     DELETE FROM PA_TSK_ACT_CMT_IT
     WHERE STATUS_CODE = 'T';

Line: 470

     DELETE FROM PA_PRJ_ACT_CMT_IT
     WHERE STATUS_CODE = 'T';

Line: 473

     DELETE FROM PA_TSK_BGT_LINES_IT
     WHERE STATUS_CODE = 'T';

Line: 476

     DELETE FROM PA_PRJ_BGT_LINES_IT
     WHERE STATUS_CODE = 'T';

Line: 479

     DELETE FROM PA_OPER_UNITS_IT
     WHERE STATUS_CODE = 'T';

Line: 482

     DELETE FROM PA_GL_PERIODS_IT
     WHERE STATUS_CODE = 'T';

Line: 485

     DELETE FROM PA_FINANCIAL_QTRS_IT
     WHERE STATUS_CODE = 'T';

Line: 488

     DELETE FROM PA_FINANCIAL_YRS_IT
     WHERE STATUS_CODE = 'T';

Line: 491

     DELETE FROM PA_ALL_FINANCIAL_YRS_IT
     WHERE STATUS_CODE = 'T';

Line: 494

     DELETE FROM PA_ALL_EXP_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 497

     DELETE FROM PA_ALL_SRVC_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 500

     DELETE FROM PA_ALL_PRJ_TYPES_IT
     WHERE STATUS_CODE = 'T';

Line: 503

     DELETE FROM PA_PRJ_ORGS_IT
     WHERE STATUS_CODE = 'T';

Line: 506

     DELETE FROM PA_PRJ_BUSINESS_GRPS_IT
     WHERE STATUS_CODE = 'T';

Line: 509

     DELETE FROM PA_EXP_ORGS_IT
     WHERE STATUS_CODE = 'T';

Line: 512

     DELETE FROM PA_EXP_BUSINESS_GRPS_IT
     WHERE STATUS_CODE = 'T';

Line: 515

     DELETE FROM PA_SET_OF_BOOKS_IT
     WHERE STATUS_CODE = 'T';

Line: 518

     DELETE FROM PA_LEGAL_ENTITY_IT
     WHERE STATUS_CODE = 'T';