APPS.AR_BPA_CONTENT_AREAS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_CONTENT_AREA_ID in NUMBER,
  X_DISPLAY_LEVEL in VARCHAR2,
  X_CONTENT_TYPE in NUMBER,
  X_CONTENT_ORIENTATION in NUMBER,
  X_TEMPLATE_ID in NUMBER,
  X_CONTENT_STYLE_ID in NUMBER,
  X_ITEM_ID in NUMBER,
  X_URL_ID in NUMBER,
  X_DISPLAY_SEQUENCE in NUMBER,
  X_CONTENT_AREA_WIDTH in VARCHAR2,
  X_CONTENT_AREA_LEFT_SPACE in NUMBER,
  X_CONTENT_AREA_RIGHT_SPACE in NUMBER,
  X_CONTENT_AREA_TOP_SPACE in NUMBER,
  X_CONTENT_AREA_BOTTOM_SPACE in NUMBER,
  X_CONTENT_COUNT in NUMBER,
  X_LINE_REGION_FLAG in VARCHAR2,
  X_ITEM_LABEL_STYLE in VARCHAR2,
  X_CONTENT_DISP_PROMPT_STYLE in VARCHAR2,
  X_ITEM_VALUE_STYLE in VARCHAR2,
  X_INVOICE_LINE_TYPE in VARCHAR2,
  X_AREA_CODE in VARCHAR2,
  X_PARENT_AREA_CODE in VARCHAR2,
  X_ITEM_COLUMN_WIDTH in NUMBER,
  X_CONTENT_AREA_NAME in VARCHAR2,
  X_CONTENT_DISPLAY_PROMPT 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
  cursor C is select ROWID from AR_BPA_CONTENT_AREAS_B
    where CONTENT_AREA_ID = X_CONTENT_AREA_ID
    ;

Line: 40

  insert into AR_BPA_CONTENT_AREAS_B (
    CONTENT_AREA_ID,
    DISPLAY_LEVEL,
    CONTENT_TYPE,
    CONTENT_ORIENTATION,
    TEMPLATE_ID,
    CONTENT_STYLE_ID,
    ITEM_ID,
    URL_ID,
    DISPLAY_SEQUENCE,
    CONTENT_AREA_WIDTH,
    CONTENT_AREA_LEFT_SPACE,
    CONTENT_AREA_RIGHT_SPACE,
    CONTENT_AREA_TOP_SPACE,
    CONTENT_AREA_BOTTOM_SPACE,
    CONTENT_COUNT,
    LINE_REGION_FLAG,
    ITEM_LABEL_STYLE,
    CONTENT_DISP_PROMPT_STYLE,
    ITEM_VALUE_STYLE,
    INVOICE_LINE_TYPE,
    AREA_CODE,
    PARENT_AREA_CODE,
    ITEM_COLUMN_WIDTH,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_CONTENT_AREA_ID,
    X_DISPLAY_LEVEL,
    X_CONTENT_TYPE,
    X_CONTENT_ORIENTATION,
    X_TEMPLATE_ID,
    X_CONTENT_STYLE_ID,
    X_ITEM_ID,
    X_URL_ID,
    X_DISPLAY_SEQUENCE,
    X_CONTENT_AREA_WIDTH,
    X_CONTENT_AREA_LEFT_SPACE,
    X_CONTENT_AREA_RIGHT_SPACE,
    X_CONTENT_AREA_TOP_SPACE,
    X_CONTENT_AREA_BOTTOM_SPACE,
    X_CONTENT_COUNT,
    X_LINE_REGION_FLAG,
    X_ITEM_LABEL_STYLE,
    X_CONTENT_DISP_PROMPT_STYLE,
    X_ITEM_VALUE_STYLE,
    X_INVOICE_LINE_TYPE,
    X_AREA_CODE,
    X_PARENT_AREA_CODE,
    X_ITEM_COLUMN_WIDTH,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 100

  insert into AR_BPA_CONTENT_AREAS_TL (
    CONTENT_AREA_ID,
    CONTENT_AREA_NAME,
    CONTENT_DISPLAY_PROMPT,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_CONTENT_AREA_ID,
    X_CONTENT_AREA_NAME,
    X_CONTENT_DISPLAY_PROMPT,
    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 AR_BPA_CONTENT_AREAS_TL T
    where T.CONTENT_AREA_ID = X_CONTENT_AREA_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 138

end INSERT_ROW;

Line: 167

  cursor c is select
      DISPLAY_LEVEL,
      CONTENT_TYPE,
      CONTENT_ORIENTATION,
      TEMPLATE_ID,
      CONTENT_STYLE_ID,
      ITEM_ID,
      URL_ID,
      DISPLAY_SEQUENCE,
      CONTENT_AREA_WIDTH,
      CONTENT_AREA_LEFT_SPACE,
      CONTENT_AREA_RIGHT_SPACE,
      CONTENT_AREA_TOP_SPACE,
      CONTENT_AREA_BOTTOM_SPACE,
      CONTENT_COUNT,
      LINE_REGION_FLAG,
      ITEM_LABEL_STYLE,
      CONTENT_DISP_PROMPT_STYLE,
      ITEM_VALUE_STYLE,
      INVOICE_LINE_TYPE,
      AREA_CODE,
      PARENT_AREA_CODE,
      ITEM_COLUMN_WIDTH
    from AR_BPA_CONTENT_AREAS_B
    where CONTENT_AREA_ID = X_CONTENT_AREA_ID
    for update of CONTENT_AREA_ID nowait;

Line: 195

  cursor c1 is select
      CONTENT_AREA_NAME,
      CONTENT_DISPLAY_PROMPT,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AR_BPA_CONTENT_AREAS_TL
    where CONTENT_AREA_ID = X_CONTENT_AREA_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of CONTENT_AREA_ID nowait;

Line: 208

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

Line: 276

procedure UPDATE_ROW (
  X_CONTENT_AREA_ID in NUMBER,
  X_DISPLAY_LEVEL in VARCHAR2,
  X_CONTENT_TYPE in NUMBER,
  X_CONTENT_ORIENTATION in NUMBER,
  X_TEMPLATE_ID in NUMBER,
  X_CONTENT_STYLE_ID in NUMBER,
  X_ITEM_ID in NUMBER,
  X_URL_ID in NUMBER,
  X_DISPLAY_SEQUENCE in NUMBER,
  X_CONTENT_AREA_WIDTH in VARCHAR2,
  X_CONTENT_AREA_LEFT_SPACE in NUMBER,
  X_CONTENT_AREA_RIGHT_SPACE in NUMBER,
  X_CONTENT_AREA_TOP_SPACE in NUMBER,
  X_CONTENT_AREA_BOTTOM_SPACE in NUMBER,
  X_CONTENT_COUNT in NUMBER,
  X_LINE_REGION_FLAG in VARCHAR2,
  X_ITEM_LABEL_STYLE in VARCHAR2,
  X_CONTENT_DISP_PROMPT_STYLE in VARCHAR2,
  X_ITEM_VALUE_STYLE in VARCHAR2,
  X_INVOICE_LINE_TYPE in VARCHAR2,
  X_AREA_CODE in VARCHAR2,
  X_PARENT_AREA_CODE in VARCHAR2,
  X_ITEM_COLUMN_WIDTH in NUMBER,
  X_CONTENT_AREA_NAME in VARCHAR2,
  X_CONTENT_DISPLAY_PROMPT in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AR_BPA_CONTENT_AREAS_B set
    DISPLAY_LEVEL = X_DISPLAY_LEVEL,
    CONTENT_TYPE = X_CONTENT_TYPE,
    CONTENT_ORIENTATION = X_CONTENT_ORIENTATION,
    TEMPLATE_ID = X_TEMPLATE_ID,
    CONTENT_STYLE_ID = X_CONTENT_STYLE_ID,
    ITEM_ID = X_ITEM_ID,
    URL_ID = X_URL_ID,
    DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
    CONTENT_AREA_WIDTH = X_CONTENT_AREA_WIDTH,
    CONTENT_AREA_LEFT_SPACE = X_CONTENT_AREA_LEFT_SPACE,
    CONTENT_AREA_RIGHT_SPACE = X_CONTENT_AREA_RIGHT_SPACE,
    CONTENT_AREA_TOP_SPACE = X_CONTENT_AREA_TOP_SPACE,
    CONTENT_AREA_BOTTOM_SPACE = X_CONTENT_AREA_BOTTOM_SPACE,
    CONTENT_COUNT = X_CONTENT_COUNT,
    LINE_REGION_FLAG = X_LINE_REGION_FLAG,
    ITEM_LABEL_STYLE = X_ITEM_LABEL_STYLE,
    CONTENT_DISP_PROMPT_STYLE = X_CONTENT_DISP_PROMPT_STYLE,
    ITEM_VALUE_STYLE = X_ITEM_VALUE_STYLE,
    INVOICE_LINE_TYPE = X_INVOICE_LINE_TYPE,
    AREA_CODE = X_AREA_CODE,
    PARENT_AREA_CODE = X_PARENT_AREA_CODE,
    ITEM_COLUMN_WIDTH = X_ITEM_COLUMN_WIDTH,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where CONTENT_AREA_ID = X_CONTENT_AREA_ID;

Line: 339

  update AR_BPA_CONTENT_AREAS_TL set
    CONTENT_AREA_NAME = X_CONTENT_AREA_NAME,
    CONTENT_DISPLAY_PROMPT = X_CONTENT_DISPLAY_PROMPT,
    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 CONTENT_AREA_ID = X_CONTENT_AREA_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 352

end UPDATE_ROW;

Line: 354

procedure DELETE_ROW (
  X_CONTENT_AREA_ID in NUMBER
) is
begin
  delete from AR_BPA_CONTENT_AREAS_TL
  where CONTENT_AREA_ID = X_CONTENT_AREA_ID;

Line: 365

  delete from AR_BPA_CONTENT_AREAS_B
  where CONTENT_AREA_ID = X_CONTENT_AREA_ID;

Line: 371

end DELETE_ROW;

Line: 376

  delete from AR_BPA_CONTENT_AREAS_TL T
  where not exists
    (select NULL
    from AR_BPA_CONTENT_AREAS_B B
    where B.CONTENT_AREA_ID = T.CONTENT_AREA_ID
    );

Line: 383

  update AR_BPA_CONTENT_AREAS_TL T set (
      CONTENT_AREA_NAME,
      CONTENT_DISPLAY_PROMPT
    ) = (select
      B.CONTENT_AREA_NAME,
      B.CONTENT_DISPLAY_PROMPT
    from AR_BPA_CONTENT_AREAS_TL B
    where B.CONTENT_AREA_ID = T.CONTENT_AREA_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.CONTENT_AREA_ID,
      T.LANGUAGE
  ) in (select
      SUBT.CONTENT_AREA_ID,
      SUBT.LANGUAGE
    from AR_BPA_CONTENT_AREAS_TL SUBB, AR_BPA_CONTENT_AREAS_TL SUBT
    where SUBB.CONTENT_AREA_ID = SUBT.CONTENT_AREA_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.CONTENT_AREA_NAME <> SUBT.CONTENT_AREA_NAME
      or (SUBB.CONTENT_AREA_NAME is null and SUBT.CONTENT_AREA_NAME is not null)
      or (SUBB.CONTENT_AREA_NAME is not null and SUBT.CONTENT_AREA_NAME is null)
      or SUBB.CONTENT_DISPLAY_PROMPT <> SUBT.CONTENT_DISPLAY_PROMPT
      or (SUBB.CONTENT_DISPLAY_PROMPT is null and SUBT.CONTENT_DISPLAY_PROMPT is not null)
      or (SUBB.CONTENT_DISPLAY_PROMPT is not null and SUBT.CONTENT_DISPLAY_PROMPT is null)
  ));

Line: 409

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

Line: 448

    update AR_BPA_CONTENT_AREAS_TL
      set CONTENT_AREA_NAME = X_CONTENT_AREA_NAME,
          CONTENT_DISPLAY_PROMPT = X_CONTENT_DISPLAY_PROMPT,
          source_lang = userenv('LANG'),
          last_update_date = sysdate,
          last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
          last_update_login = 0
    where CONTENT_AREA_ID = X_CONTENT_AREA_ID
    and   userenv('LANG') in (language, source_lang);

Line: 497

    AR_BPA_CONTENT_AREAS_PKG.UPDATE_ROW (
		X_CONTENT_AREA_ID 		=> X_CONTENT_AREA_ID,
		X_ITEM_LABEL_STYLE 		=> X_ITEM_LABEL_STYLE,
		X_ITEM_VALUE_STYLE 		=> X_ITEM_VALUE_STYLE,
		X_CONTENT_DISP_PROMPT_STYLE 	=> X_CONTENT_DISP_PROMPT_STYLE,
		X_INVOICE_LINE_TYPE 		=> X_INVOICE_LINE_TYPE,
		X_AREA_CODE 			=> X_AREA_CODE,
		X_PARENT_AREA_CODE 		=> X_PARENT_AREA_CODE,
		X_LINE_REGION_FLAG 		=> X_LINE_REGION_FLAG,
		X_CONTENT_COUNT 		=> X_CONTENT_COUNT,
		X_CONTENT_AREA_RIGHT_SPACE 	=> X_CONTENT_AREA_RIGHT_SPACE,
		X_CONTENT_AREA_TOP_SPACE 	=> X_CONTENT_AREA_TOP_SPACE,
		X_CONTENT_AREA_BOTTOM_SPACE 	=> X_CONTENT_AREA_BOTTOM_SPACE,
		X_DISPLAY_LEVEL 		=> X_DISPLAY_LEVEL,
		X_CONTENT_TYPE 			=> X_CONTENT_TYPE,
		X_CONTENT_ORIENTATION 		=> X_CONTENT_ORIENTATION,
		X_TEMPLATE_ID 			=> X_TEMPLATE_ID,
		X_CONTENT_STYLE_ID 		=> X_CONTENT_STYLE_ID,
		X_ITEM_ID 			=> X_ITEM_ID,
		X_URL_ID 			=> X_URL_ID,
		X_DISPLAY_SEQUENCE 		=> X_DISPLAY_SEQUENCE,
		X_CONTENT_AREA_WIDTH 		=> X_CONTENT_AREA_WIDTH,
		X_CONTENT_AREA_LEFT_SPACE 	=> X_CONTENT_AREA_LEFT_SPACE,
		X_CONTENT_AREA_NAME 		=> X_CONTENT_AREA_NAME,
		X_CONTENT_DISPLAY_PROMPT 	=> X_CONTENT_DISPLAY_PROMPT,
            X_ITEM_COLUMN_WIDTH           => X_ITEM_COLUMN_WIDTH,
		X_LAST_UPDATE_DATE 	=> sysdate,
		X_LAST_UPDATED_BY 	=> user_id,
		X_LAST_UPDATE_LOGIN 	=> 0);

Line: 528

           AR_BPA_CONTENT_AREAS_PKG.INSERT_ROW (
		X_ROWID 			=> row_id,
		X_CONTENT_AREA_ID 		=> X_CONTENT_AREA_ID,
		X_ITEM_LABEL_STYLE 		=> X_ITEM_LABEL_STYLE,
		X_ITEM_VALUE_STYLE 		=> X_ITEM_VALUE_STYLE,
		X_CONTENT_DISP_PROMPT_STYLE 	=> X_CONTENT_DISP_PROMPT_STYLE,
		X_INVOICE_LINE_TYPE 		=> X_INVOICE_LINE_TYPE,
		X_AREA_CODE 			=> X_AREA_CODE,
		X_PARENT_AREA_CODE 		=> X_PARENT_AREA_CODE,
		X_LINE_REGION_FLAG 		=> X_LINE_REGION_FLAG,
		X_CONTENT_COUNT 		=> X_CONTENT_COUNT,
		X_CONTENT_AREA_RIGHT_SPACE 	=> X_CONTENT_AREA_RIGHT_SPACE,
		X_CONTENT_AREA_TOP_SPACE 	=> X_CONTENT_AREA_TOP_SPACE,
		X_CONTENT_AREA_BOTTOM_SPACE 	=> X_CONTENT_AREA_BOTTOM_SPACE,
		X_DISPLAY_LEVEL 		=> X_DISPLAY_LEVEL,
		X_CONTENT_TYPE 			=> X_CONTENT_TYPE,
		X_CONTENT_ORIENTATION 		=> X_CONTENT_ORIENTATION,
		X_TEMPLATE_ID 			=> X_TEMPLATE_ID,
		X_CONTENT_STYLE_ID 		=> X_CONTENT_STYLE_ID,
		X_ITEM_ID 			=> X_ITEM_ID,
		X_URL_ID 			=> X_URL_ID,
		X_DISPLAY_SEQUENCE 		=> X_DISPLAY_SEQUENCE,
		X_CONTENT_AREA_WIDTH 		=> X_CONTENT_AREA_WIDTH,
		X_CONTENT_AREA_LEFT_SPACE 	=> X_CONTENT_AREA_LEFT_SPACE,
		X_CONTENT_AREA_NAME 		=> X_CONTENT_AREA_NAME,
		X_CONTENT_DISPLAY_PROMPT 	=> X_CONTENT_DISPLAY_PROMPT,
            X_ITEM_COLUMN_WIDTH           => X_ITEM_COLUMN_WIDTH,
		X_CREATION_DATE 	=> sysdate,
                X_CREATED_BY 		=> user_id,
                X_LAST_UPDATE_DATE 	=> sysdate,
                X_LAST_UPDATED_BY 	=> user_id,
                X_LAST_UPDATE_LOGIN 	=> 0);