APPS.HR_LEGISLATION_SUBGROUPS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_LEGISLATION_CODE in VARCHAR2,
  X_LEGISLATION_SUBGROUP in VARCHAR2,
  X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
  X_LEGISLATION_SUBGROUP_NAME in VARCHAR2
) is
begin
  insert into HR_LEGISLATION_SUBGROUPS (
    LEGISLATION_CODE,
    LEGISLATION_SUBGROUP,
    ACTIVE_INACTIVE_FLAG,
    LEGISLATION_SUBGROUP_NAME
  ) values (
    X_LEGISLATION_CODE,
    X_LEGISLATION_SUBGROUP,
    X_ACTIVE_INACTIVE_FLAG,
    X_LEGISLATION_SUBGROUP_NAME
  );

Line: 21

end INSERT_ROW;

Line: 32

    select ACTIVE_INACTIVE_FLAG,
           LEGISLATION_SUBGROUP_NAME
    from   HR_LEGISLATION_SUBGROUPS
    where  LEGISLATION_CODE = X_LEGISLATION_CODE
    and    LEGISLATION_SUBGROUP = X_LEGISLATION_SUBGROUP
    for update of LEGISLATION_CODE nowait;

Line: 44

    fnd_message.set_name('FND','FORM_RECORD_DELETED');

Line: 58

procedure UPDATE_ROW (
  X_LEGISLATION_CODE in VARCHAR2,
  X_LEGISLATION_SUBGROUP in VARCHAR2,
  X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
  X_LEGISLATION_SUBGROUP_NAME in VARCHAR2
) is
begin
  update HR_LEGISLATION_SUBGROUPS set
    ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
    LEGISLATION_SUBGROUP_NAME = X_LEGISLATION_SUBGROUP_NAME
  where LEGISLATION_CODE = X_LEGISLATION_CODE
  and   LEGISLATION_SUBGROUP = X_LEGISLATION_SUBGROUP;

Line: 73

end UPDATE_ROW;

Line: 75

procedure DELETE_ROW (
  X_LEGISLATION_CODE in VARCHAR2,
  X_LEGISLATION_SUBGROUP in VARCHAR2
) is
begin
  delete from HR_LEGISLATION_SUBGROUPS
  where LEGISLATION_CODE = X_LEGISLATION_CODE
  and   LEGISLATION_SUBGROUP = X_LEGISLATION_SUBGROUP;

Line: 86

end DELETE_ROW;

Line: 97

    UPDATE_ROW (
      X_LEGISLATION_CODE,
      X_LEGISLATION_SUBGROUP,
      X_ACTIVE_INACTIVE_FLAG,
      X_LEGISLATION_SUBGROUP_NAME
    );

Line: 105

      INSERT_ROW (
        X_LEGISLATION_CODE,
        X_LEGISLATION_SUBGROUP,
        X_ACTIVE_INACTIVE_FLAG,
        X_LEGISLATION_SUBGROUP_NAME
      );

Line: 121

  update HR_LEGISLATION_SUBGROUPS set
    LEGISLATION_SUBGROUP_NAME = X_LEGISLATION_SUBGROUP_NAME
  where LEGISLATION_CODE = X_LEGISLATION_CODE
  and   LEGISLATION_SUBGROUP = X_LEGISLATION_SUBGROUP
  and   userenv('LANG') = (select LANGUAGE_CODE
                           from   FND_LANGUAGES
                           where  INSTALLED_FLAG = 'B');