APPS.PAY_ELEMENT_INFO_TYPES_PKG SQL Statements

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

Line: 9

procedure INSERT_ROW (
  P_ROWID                    in out nocopy VARCHAR2,
  P_INFORMATION_TYPE         in VARCHAR2,
  P_ACTIVE_INACTIVE_FLAG     in VARCHAR2,
  P_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
  P_LEGISLATION_CODE         in VARCHAR2,
  P_OBJECT_VERSION_NUMBER    in NUMBER,
  P_DESCRIPTION              in VARCHAR2
) is
  cursor C is select ROWID from PAY_ELEMENT_TYPE_INFO_TYPES
    where INFORMATION_TYPE = P_INFORMATION_TYPE;

Line: 22

  insert into PAY_ELEMENT_TYPE_INFO_TYPES
  (
    INFORMATION_TYPE,
    ACTIVE_INACTIVE_FLAG,
    MULTIPLE_OCCURENCES_FLAG,
    LEGISLATION_CODE,
    OBJECT_VERSION_NUMBER,
    DESCRIPTION
  )
  values
  (
    P_INFORMATION_TYPE,
    P_ACTIVE_INACTIVE_FLAG,
    P_MULTIPLE_OCCURENCES_FLAG,
    P_LEGISLATION_CODE,
    P_OBJECT_VERSION_NUMBER,
    P_DESCRIPTION
  );

Line: 49

end INSERT_ROW;

Line: 51

procedure UPDATE_ROW (
  P_INFORMATION_TYPE         in VARCHAR2,
  P_ACTIVE_INACTIVE_FLAG     in VARCHAR2,
  P_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
  P_LEGISLATION_CODE         in VARCHAR2,
  P_OBJECT_VERSION_NUMBER    in NUMBER,
  P_DESCRIPTION              in VARCHAR2
) is
begin
  --
  update PAY_ELEMENT_TYPE_INFO_TYPES set
    ACTIVE_INACTIVE_FLAG     = P_ACTIVE_INACTIVE_FLAG,
    MULTIPLE_OCCURENCES_FLAG = P_MULTIPLE_OCCURENCES_FLAG,
    LEGISLATION_CODE         = P_LEGISLATION_CODE,
    OBJECT_VERSION_NUMBER    = P_OBJECT_VERSION_NUMBER,
    DESCRIPTION              = P_DESCRIPTION
  where INFORMATION_TYPE     = P_INFORMATION_TYPE;

Line: 73

end UPDATE_ROW;

Line: 102

    UPDATE_ROW
      (P_INFORMATION_TYPE         => P_INFORMATION_TYPE
      ,P_ACTIVE_INACTIVE_FLAG     => P_ACTIVE_INACTIVE_FLAG
      ,P_MULTIPLE_OCCURENCES_FLAG => P_MULTIPLE_OCCURENCES_FLAG
      ,P_DESCRIPTION              => P_DESCRIPTION
      ,P_LEGISLATION_CODE         => P_LEGISLATION_CODE
      ,P_OBJECT_VERSION_NUMBER    => P_OBJECT_VERSION_NUMBER
      );

Line: 112

      INSERT_ROW
        (P_ROWID                    => l_rowid
        ,P_INFORMATION_TYPE         => P_INFORMATION_TYPE
        ,P_ACTIVE_INACTIVE_FLAG     => P_ACTIVE_INACTIVE_FLAG
        ,P_MULTIPLE_OCCURENCES_FLAG => P_MULTIPLE_OCCURENCES_FLAG
        ,P_DESCRIPTION              => P_DESCRIPTION
        ,P_LEGISLATION_CODE         => P_LEGISLATION_CODE
        ,P_OBJECT_VERSION_NUMBER    => P_OBJECT_VERSION_NUMBER
        );

Line: 145

  update pay_element_type_info_types
     set description = p_description
   where userenv('LANG') = (select language_code from fnd_languages
                            where installed_flag = 'B')
     AND information_type = p_information_type;