APPS.CSD_FLOW_STATUSES_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  -- P_ROWID in out nocopy VARCHAR2,
  PX_FLOW_STATUS_ID in out nocopy NUMBER,
  P_FLOW_STATUS_CODE in VARCHAR2,
  P_STATUS_CODE in VARCHAR2,
  P_SEEDED_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_EXTERNAL_DISPLAY_STATUS in VARCHAR2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2,
  P_CREATION_DATE in DATE,
  P_CREATED_BY in NUMBER,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER
) is

  cursor C is
    select ROWID
    from   CSD_FLOW_STATUSES_B
    where  FLOW_STATUS_ID = PX_FLOW_STATUS_ID;

Line: 44

  select CSD_FLOW_STATUSES_S1.nextval
  into PX_FLOW_STATUS_ID
  from dual;

Line: 48

  insert into CSD_FLOW_STATUSES_B (
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    FLOW_STATUS_ID,
    FLOW_STATUS_CODE,
    STATUS_CODE,
    SEEDED_FLAG,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE7,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    P_ATTRIBUTE10,
    P_ATTRIBUTE11,
    P_ATTRIBUTE12,
    P_ATTRIBUTE13,
    P_ATTRIBUTE14,
    P_ATTRIBUTE15,
    PX_FLOW_STATUS_ID,
    P_FLOW_STATUS_CODE,
    P_STATUS_CODE,
    P_SEEDED_FLAG,
    P_ATTRIBUTE8,
    P_ATTRIBUTE9,
    P_ATTRIBUTE7,
    P_ATTRIBUTE_CATEGORY,
    P_ATTRIBUTE1,
    P_ATTRIBUTE2,
    P_ATTRIBUTE3,
    P_ATTRIBUTE4,
    P_ATTRIBUTE5,
    P_ATTRIBUTE6,
    P_OBJECT_VERSION_NUMBER,
    P_CREATION_DATE,
    P_CREATED_BY,
    P_LAST_UPDATE_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_LOGIN
  );

Line: 104

  insert into CSD_FLOW_STATUSES_TL (
    FLOW_STATUS_ID,
    EXTERNAL_DISPLAY_STATUS,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    PX_FLOW_STATUS_ID,
    P_EXTERNAL_DISPLAY_STATUS,
    P_CREATED_BY,
    P_CREATION_DATE,
    P_LAST_UPDATED_BY,
    P_LAST_UPDATE_DATE,
    P_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 CSD_FLOW_STATUSES_TL T
    where T.FLOW_STATUS_ID = PX_FLOW_STATUS_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 140

end INSERT_ROW;

Line: 170

  cursor c is select
      OBJECT_VERSION_NUMBER
    from CSD_FLOW_STATUSES_B
    where FLOW_STATUS_ID = P_FLOW_STATUS_ID
    for update of FLOW_STATUS_ID nowait;

Line: 183

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

Line: 213

procedure UPDATE_ROW (
  P_FLOW_STATUS_ID in NUMBER,
  P_FLOW_STATUS_CODE in VARCHAR2,
  P_STATUS_CODE in VARCHAR2,
  P_SEEDED_FLAG in VARCHAR2,
  P_OBJECT_VERSION_NUMBER in NUMBER,
  P_EXTERNAL_DISPLAY_STATUS in VARCHAR2,
  P_ATTRIBUTE_CATEGORY in VARCHAR2,
  P_ATTRIBUTE1 in VARCHAR2,
  P_ATTRIBUTE2 in VARCHAR2,
  P_ATTRIBUTE3 in VARCHAR2,
  P_ATTRIBUTE4 in VARCHAR2,
  P_ATTRIBUTE5 in VARCHAR2,
  P_ATTRIBUTE6 in VARCHAR2,
  P_ATTRIBUTE7 in VARCHAR2,
  P_ATTRIBUTE8 in VARCHAR2,
  P_ATTRIBUTE9 in VARCHAR2,
  P_ATTRIBUTE10 in VARCHAR2,
  P_ATTRIBUTE11 in VARCHAR2,
  P_ATTRIBUTE12 in VARCHAR2,
  P_ATTRIBUTE13 in VARCHAR2,
  P_ATTRIBUTE14 in VARCHAR2,
  P_ATTRIBUTE15 in VARCHAR2,
  P_LAST_UPDATE_DATE in DATE,
  P_LAST_UPDATED_BY in NUMBER,
  P_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update CSD_FLOW_STATUSES_B set
    ATTRIBUTE10 = P_ATTRIBUTE10,
    ATTRIBUTE11 = P_ATTRIBUTE11,
    ATTRIBUTE12 = P_ATTRIBUTE12,
    ATTRIBUTE13 = P_ATTRIBUTE13,
    ATTRIBUTE14 = P_ATTRIBUTE14,
    ATTRIBUTE15 = P_ATTRIBUTE15,
    FLOW_STATUS_CODE = P_FLOW_STATUS_CODE,
    STATUS_CODE = P_STATUS_CODE,
    SEEDED_FLAG = P_SEEDED_FLAG,
    ATTRIBUTE8 = P_ATTRIBUTE8,
    ATTRIBUTE9 = P_ATTRIBUTE9,
    ATTRIBUTE7 = P_ATTRIBUTE7,
    ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = P_ATTRIBUTE1,
    ATTRIBUTE2 = P_ATTRIBUTE2,
    ATTRIBUTE3 = P_ATTRIBUTE3,
    ATTRIBUTE4 = P_ATTRIBUTE4,
    ATTRIBUTE5 = P_ATTRIBUTE5,
    ATTRIBUTE6 = P_ATTRIBUTE6,
    OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER + 1,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
  where FLOW_STATUS_ID = P_FLOW_STATUS_ID AND
        OBJECT_VERSION_NUMBER = P_OBJECT_VERSION_NUMBER;

Line: 272

  update CSD_FLOW_STATUSES_TL set
    EXTERNAL_DISPLAY_STATUS = P_EXTERNAL_DISPLAY_STATUS,
    LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = P_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN,
    SOURCE_LANG = userenv('LANG')
  where FLOW_STATUS_ID = P_FLOW_STATUS_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 284

end UPDATE_ROW;

Line: 286

procedure DELETE_ROW (
  P_FLOW_STATUS_ID in NUMBER
) is
begin
  delete from CSD_FLOW_STATUSES_TL
  where FLOW_STATUS_ID = P_FLOW_STATUS_ID;

Line: 297

  delete from CSD_FLOW_STATUSES_B
  where FLOW_STATUS_ID = P_FLOW_STATUS_ID;

Line: 303

end DELETE_ROW;

Line: 308

  delete from CSD_FLOW_STATUSES_TL T
  where not exists
    (select NULL
    from CSD_FLOW_STATUSES_B B
    where B.FLOW_STATUS_ID = T.FLOW_STATUS_ID
    );

Line: 315

  update CSD_FLOW_STATUSES_TL T set (
      EXTERNAL_DISPLAY_STATUS
    ) = (select
      B.EXTERNAL_DISPLAY_STATUS
    from CSD_FLOW_STATUSES_TL B
    where B.FLOW_STATUS_ID = T.FLOW_STATUS_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.FLOW_STATUS_ID,
      T.LANGUAGE
  ) in (select
      SUBT.FLOW_STATUS_ID,
      SUBT.LANGUAGE
    from CSD_FLOW_STATUSES_TL SUBB, CSD_FLOW_STATUSES_TL SUBT
    where SUBB.FLOW_STATUS_ID = SUBT.FLOW_STATUS_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.EXTERNAL_DISPLAY_STATUS <> SUBT.EXTERNAL_DISPLAY_STATUS
      or (SUBB.EXTERNAL_DISPLAY_STATUS is null and SUBT.EXTERNAL_DISPLAY_STATUS is not null)
      or (SUBB.EXTERNAL_DISPLAY_STATUS is not null and SUBT.EXTERNAL_DISPLAY_STATUS is null)
  ));

Line: 336

  insert into CSD_FLOW_STATUSES_TL (
    FLOW_STATUS_ID,
    EXTERNAL_DISPLAY_STATUS,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.FLOW_STATUS_ID,
    B.EXTERNAL_DISPLAY_STATUS,
    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 CSD_FLOW_STATUSES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from CSD_FLOW_STATUSES_TL T
    where T.FLOW_STATUS_ID = B.FLOW_STATUS_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);