APPS.CSL_SETUP_HOOKS SQL Statements

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

Line: 53

     SELECT EXECUTE_FLAG
	 ,      HOOK_PACKAGE
	 ,      HOOK_API
	 FROM JTF_HOOKS_DATA
	 WHERE PRODUCT_CODE    = 'CSL'
	 AND   PACKAGE_NAME    = b_package_name
	 AND   API_NAME        = b_api_name
	 AND   HOOK_TYPE       = b_hook_type
	 AND   PROCESSING_TYPE = b_process_type
	 AND   EXECUTE_FLAG    = 'Y';

Line: 69

  hookTable(1).apiName := 'DELETE_ROW' ;

Line: 74

  hookTable(2).apiName := 'DELETE_ROW' ;

Line: 79

  hookTable(3).apiName := 'INSERT_ROW' ;

Line: 84

  hookTable(4).apiName := 'INSERT_ROW' ;

Line: 89

  hookTable(5).apiName := 'UPDATE_ROW' ;

Line: 94

  hookTable(6).apiName := 'UPDATE_ROW' ;

Line: 99

  hookTable(7).apiName := 'DELETE_ROW' ;

Line: 104

  hookTable(8).apiName := 'INSERT_ROW' ;

Line: 109

  hookTable(9).apiName := 'UPDATE_ROW' ;

Line: 114

  hookTable(10).apiName := 'UPDATE_ROW' ;

Line: 119

  hookTable(11).apiName := 'INSERT_ROW' ;

Line: 124

  hookTable(12).apiName := 'UPDATE_ROW' ;

Line: 129

  hookTable(13).apiName := 'INSERT_ROW' ;

Line: 134

  hookTable(14).apiName := 'UPDATE_ROW' ;

Line: 144

  hookTable(16).apiName := 'UPDATE_LOCATION' ;

Line: 159

  hookTable(19).apiName := 'Update_ServiceRequest' ;

Line: 164

  hookTable(20).apiName := 'Update_ServiceRequest' ;

Line: 179

  hookTable(23).apiName := 'DELETE_TASK' ;

Line: 184

  hookTable(24).apiName := 'DELETE_TASK' ;

Line: 189

  hookTable(25).apiName := 'UPDATE_TASK' ;

Line: 194

  hookTable(26).apiName := 'UPDATE_TASK' ;

Line: 209

  hookTable(29).apiName := 'DELETE_TASK_ASSIGNMENT' ;

Line: 214

  hookTable(30).apiName := 'DELETE_TASK_ASSIGNMENT' ;

Line: 219

  hookTable(31).apiName := 'UPDATE_TASK_ASSIGNMENT' ;

Line: 224

  hookTable(32).apiName := 'UPDATE_TASK_ASSIGNMENT' ;

Line: 244

  hookTable(36).apiName := 'DELETE_COUNTER' ;

Line: 249

  hookTable(37).apiName := 'DELETE_CTR_PROP' ;

Line: 254

  hookTable(38).apiName := 'UPDATE_COUNTER' ;

Line: 259

  hookTable(39).apiName := 'UPDATE_CTR_GRP' ;

Line: 264

  hookTable(40).apiName := 'UPDATE_CTR_PROP' ;

Line: 279

  hookTable(43).apiName := 'UPDATE_COUNTER_READING' ;

Line: 284

  hookTable(44).apiName := 'UPDATE_COUNTER_READING' ;

Line: 299

  hookTable(47).apiName := 'UPDATE_NOTE' ;

Line: 309

  hookTable(49).apiName := 'DELETE_RESOURCE_GROUP_MEMBERS' ;