APPS.PJM_TASK_ATTRIBUTES_PKG SQL Statements

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

Line: 29

    UPDATE pjm_task_attributes_tl
    SET    form_field_name  = X_Form_Field_Name
    ,      last_update_date = sysdate
    ,      last_updated_by  = user_id
    WHERE  assignment_type  = X_Assignment_Type
    AND    attribute_code   = X_Attribute_Code;

Line: 39

    UPDATE pjm_task_attributes_tl
    SET    attribute_name   = X_Attribute_Name
    ,      source_lang      = userenv('LANG')
    WHERE  assignment_type  = X_Assignment_Type
    AND    attribute_code   = X_Attribute_Code
    AND    userenv('LANG') in ( language , source_lang );

Line: 49

    UPDATE pjm_task_attr_usages_tl
    SET    prompt           = X_Attribute_Name
    ,      last_update_date = sysdate
    ,      last_updated_by  = user_id
    ,      source_lang      = userenv('LANG')
    WHERE  assignment_type  = X_Assignment_Type
    AND    attribute_code   = X_Attribute_Code
    AND    language         = userenv('LANG')
    AND    source_lang <> language;

Line: 62

    INSERT INTO pjm_task_attributes_tl
    (      assignment_type
    ,      attribute_code
    ,      last_update_date
    ,      last_updated_by
    ,      creation_date
    ,      created_by
    ,      last_update_login
    ,      attribute_name
    ,      form_field_name
    ,      language
    ,      source_lang )
    SELECT X_Assignment_Type
    ,      X_Attribute_Code
    ,      sysdate
    ,      user_id
    ,      sysdate
    ,      user_id
    ,      -1
    ,      X_Attribute_Name
    ,      X_Form_Field_Name
    ,      L.language_code
    ,      userenv('LANG')
    FROM   fnd_languages L
    WHERE  L.installed_flag in ('I' , 'B')
    AND NOT EXISTS (
        SELECT null
        FROM   pjm_task_attributes_tl
        WHERE  assignment_type = X_Assignment_Type
        AND    attribute_code = X_Attribute_Code
        AND    language = L.language_code
    );

Line: 123

  UPDATE pjm_task_attributes_tl
  SET    attribute_name   = X_Attribute_Name
  ,      last_update_date = sysdate
  ,      last_updated_by  = user_id
  ,      source_lang      = userenv('LANG')
  WHERE  assignment_type  = X_Assignment_Type
  AND    attribute_code   = X_Attribute_Code
  AND    userenv('LANG') in ( language , source_lang );

Line: 135

  UPDATE pjm_task_attr_usages_tl
  SET    prompt           = X_Attribute_Name
  ,      last_update_date = sysdate
  ,      last_updated_by  = user_id
  ,      source_lang      = userenv('LANG')
  WHERE  assignment_type  = X_Assignment_Type
  AND    attribute_code   = X_Attribute_Code
  AND    language         = userenv('LANG')
  AND    source_lang <> language;

Line: 156

  INSERT INTO pjm_task_attributes_tl
  ( assignment_type
  , attribute_code
  , creation_date
  , created_by
  , last_update_date
  , last_updated_by
  , last_update_login
  , form_field_name
  , attribute_name
  , language
  , source_lang
  )
  SELECT M.assignment_type
  ,      M.attribute_code
  ,      M.creation_date
  ,      M.created_by
  ,      M.last_update_date
  ,      M.last_updated_by
  ,      M.last_update_login
  ,      M.form_field_name
  ,      M.attribute_name
  ,      L.language_code
  ,      M.source_lang
  FROM   pjm_task_attributes_tl M
  ,      fnd_languages L
  WHERE  M.language = userenv('LANG')
  AND    L.installed_flag in ( 'I' , 'B' )
  AND NOT EXISTS (
      SELECT null
      FROM   pjm_task_attributes_tl
      WHERE  assignment_type = M.assignment_type
      AND    attribute_code = M.attribute_code
      AND    language = L.language_code );