APPS.CSM_SETUP_HOOK SQL Statements

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

Line: 58

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

Line: 63

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

Line: 68

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

Line: 73

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

Line: 78

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

Line: 83

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

Line: 88

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

Line: 98

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

Line: 103

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

Line: 108

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

Line: 113

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

Line: 118

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

Line: 128

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

Line: 138

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

Line: 148

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

Line: 158

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

Line: 173

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

Line: 183

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

Line: 188

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

Line: 193

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

Line: 198

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

Line: 203

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

Line: 208

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

Line: 213

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

Line: 219

                select 'Y'
                  into hookExists
                  from jtf_hooks_data
                 where package_name = hookTable(i).packageName
                   and api_name = hookTable(i).apiName
                   and hook_type = hookTable(i).hookType
                   and processing_type = hookTable(i).processingType
                   and execute_flag = 'Y'
                   and product_code = 'CSM' ;