APPS.JTFB_AK_REGIONS_PKG SQL Statements

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

Line: 5

procedure INSERT_ROW (
X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_REGION_APPLICATION_ID in NUMBER,
X_REGION_CODE in VARCHAR2,
X_DATABASE_OBJECT_NAME in VARCHAR2,
X_REGION_STYLE in VARCHAR2,
X_NUM_COLUMNS in NUMBER,
X_ICX_CUSTOM_CALL in VARCHAR2,
X_NAME in VARCHAR2,
X_DESCRIPTION in VARCHAR2,
X_REGION_DEFAULTING_API_PKG in VARCHAR2,
X_REGION_DEFAULTING_API_PROC in VARCHAR2,
X_REGION_VALIDATION_API_PKG in VARCHAR2,
X_REGION_VALIDATION_API_PROC in VARCHAR2,
X_APPL_MODULE_OBJECT_TYPE in VARCHAR2,
X_NUM_ROWS_DISPLAY in NUMBER,
X_REGION_OBJECT_TYPE in VARCHAR2,
X_IMAGE_FILE_NAME in VARCHAR2,
X_ISFORM_FLAG in VARCHAR2,
X_HELP_TARGET in VARCHAR2,
X_STYLE_SHEET_FILENAME in VARCHAR2,
X_VERSION in VARCHAR2,
X_APPLICATIONMODULE_USAGE_NAME in VARCHAR2,
X_ADD_INDEXED_CHILDREN in VARCHAR2 := NULL,
X_STATEFUL_FLAG in VARCHAR2 := NULL,
X_FUNCTION_NAME in VARCHAR2 := NULL,
X_CHILDREN_VIEW_USAGE_NAME in VARCHAR2 := NULL,
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,
X_ATTRIBUTE_CATEGORY in VARCHAR2,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2
) is
cursor C is select ROWID from AK_REGIONS
where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
and REGION_CODE = X_REGION_CODE;

Line: 58

insert into AK_REGIONS (
REGION_APPLICATION_ID,
REGION_CODE,
DATABASE_OBJECT_NAME,
REGION_STYLE,
NUM_COLUMNS,
ICX_CUSTOM_CALL,
REGION_DEFAULTING_API_PKG,
REGION_DEFAULTING_API_PROC,
REGION_VALIDATION_API_PKG,
REGION_VALIDATION_API_PROC,
APPLICATIONMODULE_OBJECT_TYPE,
NUM_ROWS_DISPLAY,
REGION_OBJECT_TYPE,
ISFORM_FLAG,
IMAGE_FILE_NAME,
HELP_TARGET,
STYLE_SHEET_FILENAME,
VERSION,
APPLICATIONMODULE_USAGE_NAME,
ADD_INDEXED_CHILDREN,
STATEFUL_FLAG,
FUNCTION_NAME,
CHILDREN_VIEW_USAGE_NAME,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
STANDALONE
) values (
X_REGION_APPLICATION_ID,
X_REGION_CODE,
X_DATABASE_OBJECT_NAME,
X_REGION_STYLE,
X_NUM_COLUMNS,
X_ICX_CUSTOM_CALL,
X_REGION_DEFAULTING_API_PKG,
X_REGION_DEFAULTING_API_PROC,
X_REGION_VALIDATION_API_PKG,
X_REGION_VALIDATION_API_PROC,
X_APPL_MODULE_OBJECT_TYPE,
X_NUM_ROWS_DISPLAY,
X_REGION_OBJECT_TYPE,
X_ISFORM_FLAG,
X_IMAGE_FILE_NAME,
X_HELP_TARGET,
X_STYLE_SHEET_FILENAME,
X_VERSION,
X_APPLICATIONMODULE_USAGE_NAME,
X_ADD_INDEXED_CHILDREN,
X_STATEFUL_FLAG,
X_FUNCTION_NAME,
X_CHILDREN_VIEW_USAGE_NAME,

sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,

X_ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1,
X_ATTRIBUTE2,
X_ATTRIBUTE3,
X_ATTRIBUTE4,
X_ATTRIBUTE5,
X_ATTRIBUTE6,
X_ATTRIBUTE7,
X_ATTRIBUTE8,
X_ATTRIBUTE9,
X_ATTRIBUTE10,
X_ATTRIBUTE11,
X_ATTRIBUTE12,
X_ATTRIBUTE13,
X_ATTRIBUTE14,
X_ATTRIBUTE15,
'Y'      -- STANDALONE
);

Line: 162

  insert into AK_REGIONS_TL (
    REGION_APPLICATION_ID,
    REGION_CODE,
    LANGUAGE,
    NAME,
    DESCRIPTION,
    SOURCE_LANG,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN
  ) select
    X_REGION_APPLICATION_ID,
    X_REGION_CODE,
    L.LANGUAGE_CODE,
    X_NAME,
    X_DESCRIPTION,
    userenv('LANG'),

    fnd_global.user_id,
    sysdate,
    fnd_global.user_id,
    sysdate,
    fnd_global.login_id

  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AK_REGIONS_TL T
    where T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and T.REGION_CODE = X_REGION_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 196

end INSERT_ROW;

Line: 242

  cursor c is select
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      DATABASE_OBJECT_NAME,
      REGION_STYLE,
      NUM_COLUMNS,
      ICX_CUSTOM_CALL,
      REGION_DEFAULTING_API_PKG,
      REGION_DEFAULTING_API_PROC,
      REGION_VALIDATION_API_PKG,
      REGION_VALIDATION_API_PROC,
      APPLICATIONMODULE_OBJECT_TYPE,
      NUM_ROWS_DISPLAY,
      REGION_OBJECT_TYPE,
      ISFORM_FLAG,
      IMAGE_FILE_NAME,
      HELP_TARGET,
      STYLE_SHEET_FILENAME,
      VERSION,
      APPLICATIONMODULE_USAGE_NAME,
	  ADD_INDEXED_CHILDREN,
      STATEFUL_FLAG,
      FUNCTION_NAME,
      CHILDREN_VIEW_USAGE_NAME
    from AK_REGIONS
    where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and REGION_CODE = X_REGION_CODE
    for update of REGION_APPLICATION_ID nowait;

Line: 286

  cursor c1 is select
      NAME,
      DESCRIPTION
    from AK_REGIONS_TL
    where REGION_CODE = X_REGION_CODE
    and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and LANGUAGE = userenv('LANG')
    for update of REGION_CODE nowait;

Line: 301

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

Line: 441

procedure UPDATE_ROW (
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2,
  X_DATABASE_OBJECT_NAME in VARCHAR2,
  X_REGION_STYLE in VARCHAR2,
  X_NUM_COLUMNS in NUMBER,
  X_ICX_CUSTOM_CALL in VARCHAR2,
  X_NAME in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_REGION_DEFAULTING_API_PKG in VARCHAR2,
  X_REGION_DEFAULTING_API_PROC in VARCHAR2,
  X_REGION_VALIDATION_API_PKG in VARCHAR2,
  X_REGION_VALIDATION_API_PROC in VARCHAR2,
  X_APPL_MODULE_OBJECT_TYPE in VARCHAR2,
  X_NUM_ROWS_DISPLAY in NUMBER,
  X_REGION_OBJECT_TYPE in VARCHAR2,
  X_IMAGE_FILE_NAME in VARCHAR2,
  X_ISFORM_FLAG in VARCHAR2,
  X_HELP_TARGET in VARCHAR2,
  X_STYLE_SHEET_FILENAME in VARCHAR2,
  X_VERSION in VARCHAR2,
  X_APPLICATIONMODULE_USAGE_NAME in VARCHAR2,
  X_ADD_INDEXED_CHILDREN in VARCHAR2 := NULL,
  X_STATEFUL_FLAG in VARCHAR2 := NULL,
  X_FUNCTION_NAME in VARCHAR2 := NULL,
  X_CHILDREN_VIEW_USAGE_NAME in VARCHAR2 := NULL,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2
) is
begin
    update AK_REGIONS set
      REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
      REGION_CODE = X_REGION_CODE,
      DATABASE_OBJECT_NAME = X_DATABASE_OBJECT_NAME,
      REGION_STYLE = X_REGION_STYLE,
      NUM_COLUMNS = X_NUM_COLUMNS,
      ICX_CUSTOM_CALL = X_ICX_CUSTOM_CALL,
      REGION_DEFAULTING_API_PKG = X_REGION_DEFAULTING_API_PKG,
      REGION_DEFAULTING_API_PROC = X_REGION_DEFAULTING_API_PROC,
      REGION_VALIDATION_API_PKG = X_REGION_VALIDATION_API_PKG,
      REGION_VALIDATION_API_PROC = X_REGION_VALIDATION_API_PROC,
      APPLICATIONMODULE_OBJECT_TYPE =  X_APPL_MODULE_OBJECT_TYPE,
      NUM_ROWS_DISPLAY =  X_NUM_ROWS_DISPLAY,
      REGION_OBJECT_TYPE =  X_REGION_OBJECT_TYPE,
      ISFORM_FLAG = X_ISFORM_FLAG,
      IMAGE_FILE_NAME = X_IMAGE_FILE_NAME,
      HELP_TARGET = X_HELP_TARGET,
      STYLE_SHEET_FILENAME = X_STYLE_SHEET_FILENAME,
      VERSION = X_VERSION,
      APPLICATIONMODULE_USAGE_NAME = X_APPLICATIONMODULE_USAGE_NAME,
      ADD_INDEXED_CHILDREN = X_ADD_INDEXED_CHILDREN,
      STATEFUL_FLAG = X_STATEFUL_FLAG,
      FUNCTION_NAME = X_FUNCTION_NAME,
      CHILDREN_VIEW_USAGE_NAME = X_CHILDREN_VIEW_USAGE_NAME,

      LAST_UPDATE_DATE = sysdate,
      LAST_UPDATED_BY = fnd_global.user_id,
      LAST_UPDATE_LOGIN = fnd_global.login_id,

      ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
      ATTRIBUTE1 = X_ATTRIBUTE1,
      ATTRIBUTE2 = X_ATTRIBUTE2,
      ATTRIBUTE3 = X_ATTRIBUTE3,
      ATTRIBUTE4 = X_ATTRIBUTE4,
      ATTRIBUTE5 = X_ATTRIBUTE5,
      ATTRIBUTE6 = X_ATTRIBUTE6,
      ATTRIBUTE7 = X_ATTRIBUTE7,
      ATTRIBUTE8 = X_ATTRIBUTE8,
      ATTRIBUTE9 = X_ATTRIBUTE9,
      ATTRIBUTE10 = X_ATTRIBUTE10,
      ATTRIBUTE11 = X_ATTRIBUTE11,
      ATTRIBUTE12 = X_ATTRIBUTE12,
      ATTRIBUTE13 = X_ATTRIBUTE13,
      ATTRIBUTE14 = X_ATTRIBUTE14,
      ATTRIBUTE15 = X_ATTRIBUTE15,
      STANDALONE  = 'Y'
    where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
    and REGION_CODE = X_REGION_CODE;

Line: 540

  update AK_REGIONS_TL set
    NAME = X_NAME,
    DESCRIPTION = X_DESCRIPTION,

    LAST_UPDATE_DATE = sysdate,
    LAST_UPDATED_BY = fnd_global.user_id,
    LAST_UPDATE_LOGIN = fnd_global.login_id,

    SOURCE_LANG = userenv('LANG')
  where REGION_CODE = X_REGION_CODE
  and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 555

end UPDATE_ROW;

Line: 558

procedure DELETE_ROW (
  X_REGION_APPLICATION_ID in NUMBER,
  X_REGION_CODE in VARCHAR2
) is
begin
  delete from AK_REGIONS
  where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  and REGION_CODE = X_REGION_CODE;

Line: 571

  delete from AK_REGIONS_TL
  where REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
  and REGION_CODE = X_REGION_CODE;

Line: 578

end DELETE_ROW;

Line: 583

  delete from AK_REGIONS_TL T
  where not exists
    (select NULL
    from AK_REGIONS B
    where B.REGION_CODE = T.REGION_CODE
    and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
    );

Line: 591

  update AK_REGIONS_TL T set (
      NAME,
      DESCRIPTION
    ) = (select
      B.NAME,
      B.DESCRIPTION
    from AK_REGIONS_TL B
    where B.REGION_CODE = T.REGION_CODE
    and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.REGION_CODE,
      T.REGION_APPLICATION_ID,
      T.LANGUAGE
  ) in (select
      SUBT.REGION_CODE,
      SUBT.REGION_APPLICATION_ID,
      SUBT.LANGUAGE
    from AK_REGIONS_TL SUBB, AK_REGIONS_TL SUBT
    where SUBB.REGION_CODE = SUBT.REGION_CODE
    and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.NAME <> SUBT.NAME
      or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
      or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
      or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
  ));

Line: 619

  insert into AK_REGIONS_TL (
    REGION_APPLICATION_ID,
    REGION_CODE,
    NAME,
    DESCRIPTION,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.REGION_APPLICATION_ID,
    B.REGION_CODE,
    B.NAME,
    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_LANG
  from AK_REGIONS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from AK_REGIONS_TL T
    where T.REGION_CODE = B.REGION_CODE
    and T.REGION_APPLICATION_ID = B.REGION_APPLICATION_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);