DBA Data[Home] [Help]

APPS.HR_ORG_INFORMATION_TYPES_PKG SQL Statements

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

Line: 10

    select APPLICATION_ID
    from   FND_APPLICATION
    where  APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
Line: 25

  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: 32

    X_LAST_UPDATED_BY := 1;
Line: 35

    X_LAST_UPDATED_BY := 0;
Line: 38

  X_LAST_UPDATE_DATE := sysdate;
Line: 39

  X_LAST_UPDATE_LOGIN := 0;
Line: 42

procedure INSERT_ROW (
  X_ORG_INFORMATION_TYPE in VARCHAR2,
  X_DESTINATION in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2,
  X_NAVIGATION_METHOD in VARCHAR2,
  X_FND_APPLICATION_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_DISPLAYED_ORG_INFORMATION_TP 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_ORG_INFORMATION_TYPES (
    ORG_INFORMATION_TYPE,
    DESTINATION,
    LEGISLATION_CODE,
    NAVIGATION_METHOD,
    FND_APPLICATION_ID,
    DESCRIPTION,
    DISPLAYED_ORG_INFORMATION_TYPE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_ORG_INFORMATION_TYPE,
    X_DESTINATION,
    X_LEGISLATION_CODE,
    X_NAVIGATION_METHOD,
    X_FND_APPLICATION_ID,
    X_DESCRIPTION,
    X_DISPLAYED_ORG_INFORMATION_TP,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 85

  insert into HR_ORG_INFORMATION_TYPES_TL (
    ORG_INFORMATION_TYPE,
    DISPLAYED_ORG_INFORMATION_TYPE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_ORG_INFORMATION_TYPE,
    X_DISPLAYED_ORG_INFORMATION_TP,
    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_ORG_INFORMATION_TYPES_TL T
    where T.ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 113

end INSERT_ROW;
Line: 127

    select DESTINATION
          ,LEGISLATION_CODE
          ,NAVIGATION_METHOD
          ,FND_APPLICATION_ID
          ,DESCRIPTION
    from   HR_ORG_INFORMATION_TYPES
    where  ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
    for update of ORG_INFORMATION_TYPE nowait;
Line: 138

    select DISPLAYED_ORG_INFORMATION_TYPE,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from HR_ORG_INFORMATION_TYPES_TL
    where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ORG_INFORMATION_TYPE nowait;
Line: 150

    fnd_message.set_name('FND','FORM_RECORD_DELETED');
Line: 187

procedure UPDATE_ROW (
  X_ORG_INFORMATION_TYPE in VARCHAR2,
  X_DESTINATION in VARCHAR2,
  X_LEGISLATION_CODE in VARCHAR2,
  X_NAVIGATION_METHOD in VARCHAR2,
  X_FND_APPLICATION_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_DISPLAYED_ORG_INFORMATION_TP in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_ORG_INFORMATION_TYPES set
    DESTINATION = X_DESTINATION,
    LEGISLATION_CODE = X_LEGISLATION_CODE,
    NAVIGATION_METHOD = X_NAVIGATION_METHOD,
    FND_APPLICATION_ID = X_FND_APPLICATION_ID,
    DESCRIPTION = X_DESCRIPTION,
    DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
Line: 215

  update HR_ORG_INFORMATION_TYPES_TL set
    DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 228

end UPDATE_ROW;
Line: 230

procedure DELETE_ROW (
  X_ORG_INFORMATION_TYPE in VARCHAR2
) is
begin
  delete from HR_ORG_INFORMATION_TYPES_TL
  where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
Line: 241

  delete from HR_ORG_INFORMATION_TYPES
  where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
Line: 246

end DELETE_ROW;
Line: 251

  delete from HR_ORG_INFORMATION_TYPES_TL T
  where not exists
    (select NULL
    from HR_ORG_INFORMATION_TYPES B
    where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
    );
Line: 258

  update HR_ORG_INFORMATION_TYPES_TL T set (
      DISPLAYED_ORG_INFORMATION_TYPE
    ) = (select
      B.DISPLAYED_ORG_INFORMATION_TYPE
    from HR_ORG_INFORMATION_TYPES_TL B
    where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.ORG_INFORMATION_TYPE,
      T.LANGUAGE
  ) in (select
      SUBT.ORG_INFORMATION_TYPE,
      SUBT.LANGUAGE
    from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT
    where SUBB.ORG_INFORMATION_TYPE = SUBT.ORG_INFORMATION_TYPE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DISPLAYED_ORG_INFORMATION_TYPE <> SUBT.DISPLAYED_ORG_INFORMATION_TYPE
      or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)
      or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is not null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is null)
  ));
Line: 279

  insert into HR_ORG_INFORMATION_TYPES_TL (
    ORG_INFORMATION_TYPE,
    DISPLAYED_ORG_INFORMATION_TYPE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.ORG_INFORMATION_TYPE,
    B.DISPLAYED_ORG_INFORMATION_TYPE,
    B.CREATED_BY,
    B.CREATION_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from HR_ORG_INFORMATION_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_ORG_INFORMATION_TYPES_TL T
    where T.ORG_INFORMATION_TYPE = B.ORG_INFORMATION_TYPE
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 319

  X_LAST_UPDATE_DATE IN varchar2 default sysdate,
  X_CUSTOM_MODE IN VARCHAR2 default null
) is
  X_CREATION_DATE DATE;
Line: 324

  X_LAST_UPDATED_BY NUMBER;
Line: 325

  X_LAST_UPDATE_LOGIN NUMBER;
Line: 328

  f_ludate  date;    -- entity update date in file
Line: 330

  db_ludate date;    -- entity update date in db
Line: 337

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );*/
Line: 346

 f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
Line: 347

        select LAST_UPDATED_BY, LAST_UPDATE_DATE
        into db_luby, db_ludate
        from HR_ORG_INFORMATION_TYPES
        where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
Line: 356

                   HR_ORG_INFORMATION_TYPES_PKG.Update_Row(
                                  X_ORG_INFORMATION_TYPE,
                                  X_DESTINATION,
                                  X_LEGISLATION_CODE,
                                  X_NAVIGATION_METHOD,
                                  X_APPLICATION_ID,
                                  X_DESCRIPTION,
                                  X_DISPLAYED_ORG_INFORMATION_TP,
                                  f_ludate,
                                  f_luby,
                                  0);
Line: 371

                HR_ORG_INFORMATION_TYPES_PKG.Insert_Row(
                                 X_ORG_INFORMATION_TYPE,
                                 X_DESTINATION,
                                 X_LEGISLATION_CODE,
                                 X_NAVIGATION_METHOD,
                                 X_APPLICATION_ID,
                                 X_DESCRIPTION,
                                 X_DISPLAYED_ORG_INFORMATION_TP,
                                 f_ludate,
                                 f_luby,
                                 f_ludate,
                                 f_luby,
                                 0);
Line: 392

  X_LAST_UPDATE_DATE in VARCHAR2 default sysdate,
  X_CUSTOM_MODE IN VARCHAR2 default null
) is
  X_CREATION_DATE DATE;
Line: 397

  X_LAST_UPDATED_BY NUMBER;
Line: 398

  X_LAST_UPDATE_LOGIN NUMBER;
Line: 400

  f_ludate  date;    -- entity update date in file
Line: 402

  db_ludate date;    -- entity update date in db
Line: 409

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );*/
Line: 416

 f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
Line: 421

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_ORG_INFORMATION_TYPES_TL
          where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
          and LANGUAGE=userenv('LANG');
Line: 432

             update HR_ORG_INFORMATION_TYPES_TL
                  set DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP
                   , LAST_UPDATE_DATE = f_ludate
                   , LAST_UPDATED_BY = f_luby
                   , LAST_UPDATE_LOGIN = 0
                   , SOURCE_LANG = userenv('LANG')
                  where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
                  and userenv('LANG') in (LANGUAGE,SOURCE_LANG);