DBA Data[Home] [Help]

APPS.WF_RESOURCE_LOAD SQL Statements

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

Line: 26

    select PROTECT_LEVEL, CUSTOM_LEVEL
    into protection_level, customization_level
    from WF_RESOURCES
    where NAME = x_name
    and TYPE = x_type
    and LANGUAGE = userenv('LANG');
Line: 46

    Wf_Resources_Pkg.Update_Row (
      x_type => x_type,
      x_name => x_name,
      x_protect_level => x_protect_level,
      x_custom_level => x_custom_level,
      x_id => x_id,
      x_text => x_text
    );
Line: 71

      Wf_Resources_Pkg.Insert_Row (
        x_rowid => row_id,
        x_type => x_type,
        x_name => x_name,
        x_protect_level => x_protect_level,
        x_custom_level => x_custom_level,
        x_id => x_id,
        x_text => x_text
      );