APPS.WF_DIRECTORY_PARTITIONS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_ORIG_SYSTEM in VARCHAR2,
  X_PARTITION_ID in NUMBER,
  X_DISPLAY_NAME in VARCHAR2
) is
  cursor C is select ROWID from WF_DIRECTORY_PARTITIONS
    where ORIG_SYSTEM = X_ORIG_SYSTEM
    ;

Line: 15

    insert into WF_DIRECTORY_PARTITIONS (
      PARTITION_ID,
      ORIG_SYSTEM
    ) values (
      X_PARTITION_ID,
      X_ORIG_SYSTEM
    );

Line: 29

  insert into WF_DIRECTORY_PARTITIONS_TL (
    ORIG_SYSTEM,
    DISPLAY_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_ORIG_SYSTEM,
    X_DISPLAY_NAME,
    L.CODE,
    userenv('LANG')
  from WF_LANGUAGES L
  where L.INSTALLED_FLAG = 'Y'
  and not exists
    (select NULL
    from WF_DIRECTORY_PARTITIONS_TL T
    where T.ORIG_SYSTEM = X_ORIG_SYSTEM
    and T.LANGUAGE = L.CODE);

Line: 57

    wf_core.context('Wf_Directory_Partitions_Pkg','Insert_Row',x_orig_system);

Line: 59

end INSERT_ROW;

Line: 66

  cursor c is select
      PARTITION_ID
    from WF_DIRECTORY_PARTITIONS
    where ORIG_SYSTEM = X_ORIG_SYSTEM
    for update of ORIG_SYSTEM nowait;

Line: 73

  cursor c1 is select
      DISPLAY_NAME,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from WF_DIRECTORY_PARTITIONS_TL
    where ORIG_SYSTEM = X_ORIG_SYSTEM
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of ORIG_SYSTEM nowait;

Line: 86

    wf_core.raise('WF_RECORD_DELETED');

Line: 115

procedure UPDATE_ROW (
  X_ORIG_SYSTEM in VARCHAR2,
  X_PARTITION_ID in NUMBER,
  X_DISPLAY_NAME in VARCHAR2
) is
begin
  update WF_DIRECTORY_PARTITIONS set
    PARTITION_ID = X_PARTITION_ID
  where ORIG_SYSTEM = X_ORIG_SYSTEM;

Line: 129

  update WF_DIRECTORY_PARTITIONS_TL set
    DISPLAY_NAME = X_DISPLAY_NAME,
    SOURCE_LANG = userenv('LANG')
  where ORIG_SYSTEM = X_ORIG_SYSTEM
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 141

    wf_core.context('Wf_Directory_Partitions_Pkg','Update_Row',x_orig_system);

Line: 143

end UPDATE_ROW;

Line: 145

procedure DELETE_ROW (
  X_ORIG_SYSTEM in VARCHAR2
) is
begin
  delete from WF_DIRECTORY_PARTITIONS_TL
  where ORIG_SYSTEM = X_ORIG_SYSTEM;

Line: 156

  delete from WF_DIRECTORY_PARTITIONS
  where ORIG_SYSTEM = X_ORIG_SYSTEM;

Line: 165

    wf_core.context('Wf_Directory_Partitions_Pkg','Delete_Row',x_orig_system);

Line: 167

end DELETE_ROW;

Line: 172

  delete from WF_DIRECTORY_PARTITIONS_TL T
  where not exists
    (select NULL
    from WF_DIRECTORY_PARTITIONS B
    where B.ORIG_SYSTEM = T.ORIG_SYSTEM
    );

Line: 179

  update WF_DIRECTORY_PARTITIONS_TL T set (
      DISPLAY_NAME
    ) = (select
      B.DISPLAY_NAME
    from WF_DIRECTORY_PARTITIONS_TL B
    where B.ORIG_SYSTEM = T.ORIG_SYSTEM
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.ORIG_SYSTEM,
      T.LANGUAGE
  ) in (select
      SUBT.ORIG_SYSTEM,
      SUBT.LANGUAGE
    from WF_DIRECTORY_PARTITIONS_TL SUBB, WF_DIRECTORY_PARTITIONS_TL SUBT
    where SUBB.ORIG_SYSTEM = SUBT.ORIG_SYSTEM
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
  ));

Line: 198

  insert into WF_DIRECTORY_PARTITIONS_TL (
    ORIG_SYSTEM,
    DISPLAY_NAME,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.ORIG_SYSTEM,
    B.DISPLAY_NAME,
    L.CODE,
    B.SOURCE_LANG
  from WF_DIRECTORY_PARTITIONS_TL B, WF_LANGUAGES L
  where L.INSTALLED_FLAG = 'Y'
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from WF_DIRECTORY_PARTITIONS_TL T
    where T.ORIG_SYSTEM = B.ORIG_SYSTEM
    and T.LANGUAGE = L.CODE);

Line: 233

     wf_directory_partitions_pkg.Update_row(
         X_ORIG_SYSTEM => l_orig_system,
         X_PARTITION_ID => X_PARTITION_ID,
         X_DISPLAY_NAME => X_DISPLAY_NAME);

Line: 239

        wf_directory_partitions_pkg.Insert_Row(
            X_ROWID => l_rowid,
            X_ORIG_SYSTEM => X_ORIG_SYSTEM,
            X_PARTITION_ID => X_PARTITION_ID,
            X_DISPLAY_NAME => X_DISPLAY_NAME);

Line: 257

  update WF_DIRECTORY_PARTITIONS_TL
  set    DISPLAY_NAME = X_DISPLAY_NAME,
         SOURCE_LANG = userenv('LANG')
  where  ORIG_SYSTEM = X_ORIG_SYSTEM
  and    userenv('LANG') in (language, source_lang);

Line: 269

procedure UPDATE_VIEW_NAMES (
  X_ORIG_SYSTEM    in VARCHAR2,
  X_PARTITION_ID   in NUMBER,
  X_ROLE_VIEW      in VARCHAR2,
  X_USER_ROLE_VIEW in VARCHAR2,
  X_ROLE_TL_VIEW   in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE
) is
begin
  update WF_DIRECTORY_PARTITIONS wdp
  set
    wdp.ROLE_VIEW        = nvl(X_ROLE_VIEW, wdp.ROLE_VIEW),
    wdp.USER_ROLE_VIEW   = nvl(X_USER_ROLE_VIEW, wdp.USER_ROLE_VIEW),
    wdp.ROLE_TL_VIEW     = nvl(X_ROLE_TL_VIEW, wdp.ROLE_TL_VIEW),
    wdp.LAST_UPDATE_DATE = nvl(X_LAST_UPDATE_DATE, trunc(sysdate))
  where wdp.ORIG_SYSTEM  = X_ORIG_SYSTEM
  and   wdp.PARTITION_ID = X_PARTITION_ID;

Line: 293

    wf_core.context('Wf_Directory_Partitions_Pkg','Update_View_Names',
                    x_orig_system);

Line: 296

end UPDATE_VIEW_NAMES;