APPS.AD_TRACKABLE_ENTITIES_PKG SQL Statements

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

Line: 24

     insert into AD_TRACKABLE_ENTITIES (
                      abbreviation, name, type, baseline, codelevel,
                      used_flag, load_flag)
     values ( p_trackable_entity_name, p_desc, p_type, '0', '0',
                     'F' ,'F' );

Line: 49

       select baseline, codelevel
       into x_baseline, x_te_level
       from AD_TRACKABLE_ENTITIES
       where abbreviation = p_trackable_entity_name;

Line: 76

     update AD_TRACKABLE_ENTITIES
     set codelevel =  p_te_level ,
         baseline =  p_baseline
     where abbreviation = p_trackable_entity_name;

Line: 105

       select baseline, codelevel, used_flag
       into x_baseline, x_te_level, x_used_status
       from AD_TRACKABLE_ENTITIES
       where abbreviation = p_trackable_entity_name;

Line: 129

     update AD_TRACKABLE_ENTITIES
     set used_flag = p_used_status
     where abbreviation = p_trackable_entity_name;

Line: 157

       select baseline, codelevel, load_flag
       into x_baseline, x_te_level, x_load_status
       from AD_TRACKABLE_ENTITIES
       where abbreviation = p_trackable_entity_name;

Line: 180

     update AD_TRACKABLE_ENTITIES
     set load_flag =  p_load_status
     where abbreviation = p_trackable_entity_name;

Line: 212

       select name, type, baseline, codelevel, used_flag, load_flag
       into x_desc, x_type, x_baseline, x_te_level, x_used_status, x_load_status
       from AD_TRACKABLE_ENTITIES
       where abbreviation = p_trackable_entity_name;

Line: 241

     UPDATE AD_TRACKABLE_ENTITIES
     set name = p_trackable_entity_desc,
         type = p_type,
         baseline = p_baseline,
         codelevel = p_te_level,
         used_flag = p_used_status,
         load_flag = p_load_status
     where abbreviation = p_trackable_entity_name;

Line: 251

     insert into AD_TRACKABLE_ENTITIES
         (abbreviation, name, type, baseline, codelevel, used_flag, load_flag)
     values (p_trackable_entity_name, p_trackable_entity_desc, p_type, p_te_level,
             p_baseline, p_used_status, p_load_status);