APPS.HR_DOCUMENT_TYPES_PKG SQL Statements

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

Line: 14

    select HDT.DOCUMENT_TYPE_ID
    from   HR_DOCUMENT_TYPES HDT
    where  HDT.SYSTEM_DOCUMENT_TYPE = X_SYS_DOC_TYPE
      and  ((X_LEG_CODE is NULL and HDT.LEGISLATION_CODE is NULL)
             or
            (X_LEG_CODE = HDT.LEGISLATION_CODE));

Line: 22

    select HR_DOCUMENT_TYPES_S.nextval
    from   dual;

Line: 41

  X_LAST_UPDATE_DATE out nocopy DATE,
  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  if X_OWNER = 'SEED' then
    X_CREATED_BY := 1;

Line: 48

    X_LAST_UPDATED_BY := 1;

Line: 51

    X_LAST_UPDATED_BY := 0;

Line: 54

  X_LAST_UPDATE_DATE := sysdate;

Line: 55

  X_LAST_UPDATE_LOGIN := 0;

Line: 58

procedure INSERT_ROW (
  X_DOCUMENT_TYPE_ID in NUMBER,
  X_SYSTEM_DOCUMENT_TYPE in VARCHAR2,
  X_CATEGORY_CODE in VARCHAR2,
  X_SUB_CATEGORY_CODE in VARCHAR2,
  X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
  X_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2,
  X_AUTHORIZATION_REQUIRED in VARCHAR2,
  X_WARNING_PERIOD in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_DOCUMENT_TYPE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  --
  insert into HR_DOCUMENT_TYPES (
    DOCUMENT_TYPE_ID,
    SYSTEM_DOCUMENT_TYPE,
    CATEGORY_CODE,
    SUB_CATEGORY_CODE,
    ACTIVE_INACTIVE_FLAG,
    MULTIPLE_OCCURENCES_FLAG,
    LEGISLATION_CODE,
    AUTHORIZATION_REQUIRED,
    WARNING_PERIOD,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN)
  values (
    X_DOCUMENT_TYPE_ID,
    X_SYSTEM_DOCUMENT_TYPE,
    X_CATEGORY_CODE,
    X_SUB_CATEGORY_CODE,
    X_ACTIVE_INACTIVE_FLAG,
    X_MULTIPLE_OCCURENCES_FLAG,
    X_LEGISLATION_CODE,
    X_AUTHORIZATION_REQUIRED,
    X_WARNING_PERIOD,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 113

  insert into HR_DOCUMENT_TYPES_TL (
    DOCUMENT_TYPE_ID,
    DOCUMENT_TYPE,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANGUAGE
  ) select
    X_DOCUMENT_TYPE_ID,
    X_DOCUMENT_TYPE,
    X_DESCRIPTION,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from HR_DOCUMENT_TYPES_TL T
    where T.DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 143

end INSERT_ROW;

Line: 145

procedure UPDATE_ROW (
  X_DOCUMENT_TYPE_ID in NUMBER,
  X_SYSTEM_DOCUMENT_TYPE in VARCHAR2,
  X_CATEGORY_CODE in VARCHAR2,
  X_SUB_CATEGORY_CODE in VARCHAR2,
  X_ACTIVE_INACTIVE_FLAG in VARCHAR2,
  X_MULTIPLE_OCCURENCES_FLAG in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2,
  X_AUTHORIZATION_REQUIRED in VARCHAR2,
  X_WARNING_PERIOD in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_DOCUMENT_TYPE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_DOCUMENT_TYPES set
         CATEGORY_CODE = X_CATEGORY_CODE,
         SUB_CATEGORY_CODE = X_SUB_CATEGORY_CODE,
         ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
         MULTIPLE_OCCURENCES_FLAG = X_MULTIPLE_OCCURENCES_FLAG,
         LEGISLATION_CODE = X_LEGISLATION_CODE,
         AUTHORIZATION_REQUIRED = X_AUTHORIZATION_REQUIRED,
         WARNING_PERIOD = X_WARNING_PERIOD,
         OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
         LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
         LAST_UPDATED_BY = X_LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where  DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;

Line: 181

  update HR_DOCUMENT_TYPES_TL set
         DOCUMENT_TYPE = X_DOCUMENT_TYPE,
         DESCRIPTION = X_DESCRIPTION,
         LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
         LAST_UPDATED_BY = X_LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
         SOURCE_LANGUAGE = userenv('LANG')
  where  DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANGUAGE);

Line: 195

end UPDATE_ROW;

Line: 197

procedure DELETE_ROW (
  X_DOCUMENT_TYPE_ID in NUMBER
) is
begin
  delete from HR_DOCUMENT_TYPES_TL
  where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;

Line: 208

  delete from HR_DOCUMENT_TYPES
  where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID;

Line: 213

end DELETE_ROW;

Line: 218

  delete from HR_DOCUMENT_TYPES_TL T
  where not exists
    (select NULL
    from HR_DOCUMENT_TYPES B
    where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
    );

Line: 225

  update HR_DOCUMENT_TYPES_TL T set (
      DOCUMENT_TYPE
    ) = (select
      B.DOCUMENT_TYPE
    from HR_DOCUMENT_TYPES_TL B
    where B.DOCUMENT_TYPE_ID = T.DOCUMENT_TYPE_ID
    and B.LANGUAGE = T.SOURCE_LANGUAGE)
  where (
      T.DOCUMENT_TYPE_ID,
      T.LANGUAGE
  ) in (select
      SUBT.DOCUMENT_TYPE_ID,
      SUBT.LANGUAGE
    from HR_DOCUMENT_TYPES_TL SUBB, HR_DOCUMENT_TYPES_TL SUBT
    where SUBB.DOCUMENT_TYPE_ID = SUBT.DOCUMENT_TYPE_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANGUAGE
    and (SUBB.DOCUMENT_TYPE <> SUBT.DOCUMENT_TYPE
  ));

Line: 244

  insert into HR_DOCUMENT_TYPES_TL (
    DOCUMENT_TYPE_ID,
    DOCUMENT_TYPE,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANGUAGE
  ) select
    B.DOCUMENT_TYPE_ID,
    B.DOCUMENT_TYPE,
    B.DESCRIPTION,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANGUAGE
  from HR_DOCUMENT_TYPES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from HR_DOCUMENT_TYPES_TL T
    where T.DOCUMENT_TYPE_ID = B.DOCUMENT_TYPE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 293

  X_LAST_UPDATE_DATE DATE;

Line: 294

  X_LAST_UPDATED_BY NUMBER;

Line: 295

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 309

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 315

    UPDATE_ROW (
      X_DOCUMENT_TYPE_ID,
      X_SYSTEM_DOCUMENT_TYPE,
      X_CATEGORY_CODE,
      X_SUB_CATEGORY_CODE,
      X_ACTIVE_INACTIVE_FLAG,
      X_MULTIPLE_OCCURENCES_FLAG,
      X_LEGISLATION_CODE,
      X_AUTHORIZATION_REQUIRED,
      X_WARNING_PERIOD,
      X_OBJECT_VERSION_NUMBER,
      X_DOCUMENT_TYPE,
      X_DESCRIPTION,
      X_LAST_UPDATE_DATE,
      X_LAST_UPDATED_BY,
      X_LAST_UPDATE_LOGIN
    );

Line: 334

      INSERT_ROW (
        X_DOCUMENT_TYPE_ID,
        X_SYSTEM_DOCUMENT_TYPE,
        X_CATEGORY_CODE,
        X_SUB_CATEGORY_CODE,
        X_ACTIVE_INACTIVE_FLAG,
        X_MULTIPLE_OCCURENCES_FLAG,
        X_LEGISLATION_CODE,
        X_AUTHORIZATION_REQUIRED,
        X_WARNING_PERIOD,
        X_OBJECT_VERSION_NUMBER,
        X_DOCUMENT_TYPE,
        X_DESCRIPTION,
        X_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_LAST_UPDATE_LOGIN
      );

Line: 365

  X_LAST_UPDATE_DATE DATE;

Line: 366

  X_LAST_UPDATED_BY NUMBER;

Line: 367

  X_LAST_UPDATE_LOGIN NUMBER;

Line: 381

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 386

  update HR_DOCUMENT_TYPES_TL
     set DOCUMENT_TYPE = X_DOCUMENT_TYPE,
         DESCRIPTION = X_DESCRIPTION,
         LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
         LAST_UPDATED_BY = X_LAST_UPDATED_BY,
         LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
         SOURCE_LANGUAGE = userenv('LANG')
  where DOCUMENT_TYPE_ID = X_DOCUMENT_TYPE_ID
    and userenv('LANG') in (LANGUAGE,SOURCE_LANGUAGE);