APPS.AR_BPA_PAGE_SETUPS_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_PAGE_SETUP_ID in NUMBER,
  X_PAGE_WIDTH in NUMBER,
  X_PAGE_HEIGHT in NUMBER,
  X_TOP_MARGIN in NUMBER,
  X_BOTTOM_MARGIN in NUMBER,
  X_LEFT_MARGIN in NUMBER,
  X_RIGHT_MARGIN in NUMBER,
  X_PAGE_NUMBER_LOC in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_PAGE_UNIT_OF_MEASURE in VARCHAR2,
  X_PAGE_SETUP_NAME in VARCHAR2,
  X_PAGE_SETUP_DESC in VARCHAR2,
  X_PRINT_FONT_FAMILY in VARCHAR2,
  X_PRINT_FONT_SIZE  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_PAGE_SETUPS_B
    where PAGE_SETUP_ID = X_PAGE_SETUP_ID
    ;

Line: 30

  insert into AR_BPA_PAGE_SETUPS_B (
    PAGE_WIDTH,
    PAGE_HEIGHT,
    TOP_MARGIN,
    BOTTOM_MARGIN,
    LEFT_MARGIN,
    RIGHT_MARGIN,
    PAGE_NUMBER_LOC,
    PAGE_SETUP_ID,
    SEEDED_FLAG,
    PAGE_UNIT_OF_MEASURE,
    PRINT_FONT_FAMILY,
    PRINT_FONT_SIZE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PAGE_WIDTH,
    X_PAGE_HEIGHT,
    X_TOP_MARGIN,
    X_BOTTOM_MARGIN,
    X_LEFT_MARGIN,
    X_RIGHT_MARGIN,
    X_PAGE_NUMBER_LOC,
    X_PAGE_SETUP_ID,
    X_SEEDED_FLAG,
    X_PAGE_UNIT_OF_MEASURE,
    X_PRINT_FONT_FAMILY,
    X_PRINT_FONT_SIZE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 68

  insert into AR_BPA_PAGE_SETUPS_TL (
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    PAGE_SETUP_ID,
    PAGE_SETUP_NAME,
    PAGE_SETUP_DESC,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_PAGE_SETUP_ID,
    X_PAGE_SETUP_NAME,
    X_PAGE_SETUP_DESC,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from AR_BPA_PAGE_SETUPS_TL T
    where T.PAGE_SETUP_ID = X_PAGE_SETUP_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 106

end INSERT_ROW;

Line: 124

  cursor c is select
      PAGE_WIDTH,
      PAGE_HEIGHT,
      TOP_MARGIN,
      BOTTOM_MARGIN,
      LEFT_MARGIN,
      RIGHT_MARGIN,
      PAGE_NUMBER_LOC,
      SEEDED_FLAG,
      PAGE_UNIT_OF_MEASURE,
      PRINT_FONT_FAMILY,
      PRINT_FONT_SIZE
    from AR_BPA_PAGE_SETUPS_B
    where PAGE_SETUP_ID = X_PAGE_SETUP_ID
    for update of PAGE_SETUP_ID nowait;

Line: 141

  cursor c1 is select
      PAGE_SETUP_NAME,
      PAGE_SETUP_DESC,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from AR_BPA_PAGE_SETUPS_TL
    where PAGE_SETUP_ID = X_PAGE_SETUP_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of PAGE_SETUP_ID nowait;

Line: 154

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

Line: 193

procedure UPDATE_ROW (
  X_PAGE_SETUP_ID in NUMBER,
  X_PAGE_WIDTH in NUMBER,
  X_PAGE_HEIGHT in NUMBER,
  X_TOP_MARGIN in NUMBER,
  X_BOTTOM_MARGIN in NUMBER,
  X_LEFT_MARGIN in NUMBER,
  X_RIGHT_MARGIN in NUMBER,
  X_PAGE_NUMBER_LOC in VARCHAR2,
  X_SEEDED_FLAG in VARCHAR2,
  X_PAGE_UNIT_OF_MEASURE in VARCHAR2,
  X_PAGE_SETUP_NAME in VARCHAR2,
  X_PAGE_SETUP_DESC in VARCHAR2,
  X_PRINT_FONT_FAMILY in VARCHAR2,
  X_PRINT_FONT_SIZE 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_PAGE_SETUPS_B set
    PAGE_WIDTH = X_PAGE_WIDTH,
    PAGE_HEIGHT = X_PAGE_HEIGHT,
    TOP_MARGIN = X_TOP_MARGIN,
    BOTTOM_MARGIN = X_BOTTOM_MARGIN,
    LEFT_MARGIN = X_LEFT_MARGIN,
    RIGHT_MARGIN = X_RIGHT_MARGIN,
    PAGE_NUMBER_LOC = X_PAGE_NUMBER_LOC,
    SEEDED_FLAG = X_SEEDED_FLAG,
    PAGE_UNIT_OF_MEASURE = X_PAGE_UNIT_OF_MEASURE,
    PRINT_FONT_FAMILY = X_PRINT_FONT_FAMILY,
    PRINT_FONT_SIZE = X_PRINT_FONT_SIZE ,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where PAGE_SETUP_ID = X_PAGE_SETUP_ID;

Line: 234

  update AR_BPA_PAGE_SETUPS_TL set
    PAGE_SETUP_NAME = X_PAGE_SETUP_NAME,
    PAGE_SETUP_DESC = X_PAGE_SETUP_DESC,
    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 PAGE_SETUP_ID = X_PAGE_SETUP_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 247

end UPDATE_ROW;

Line: 249

procedure DELETE_ROW (
  X_PAGE_SETUP_ID in NUMBER
) is
begin
  delete from AR_BPA_PAGE_SETUPS_TL
  where PAGE_SETUP_ID = X_PAGE_SETUP_ID;

Line: 260

  delete from AR_BPA_PAGE_SETUPS_B
  where PAGE_SETUP_ID = X_PAGE_SETUP_ID;

Line: 266

end DELETE_ROW;

Line: 271

  delete from AR_BPA_PAGE_SETUPS_TL T
  where not exists
    (select NULL
    from AR_BPA_PAGE_SETUPS_B B
    where B.PAGE_SETUP_ID = T.PAGE_SETUP_ID
    );

Line: 278

  update AR_BPA_PAGE_SETUPS_TL T set (
      PAGE_SETUP_NAME,
      PAGE_SETUP_DESC
    ) = (select
      B.PAGE_SETUP_NAME,
      B.PAGE_SETUP_DESC
    from AR_BPA_PAGE_SETUPS_TL B
    where B.PAGE_SETUP_ID = T.PAGE_SETUP_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.PAGE_SETUP_ID,
      T.LANGUAGE
  ) in (select
      SUBT.PAGE_SETUP_ID,
      SUBT.LANGUAGE
    from AR_BPA_PAGE_SETUPS_TL SUBB, AR_BPA_PAGE_SETUPS_TL SUBT
    where SUBB.PAGE_SETUP_ID = SUBT.PAGE_SETUP_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.PAGE_SETUP_NAME <> SUBT.PAGE_SETUP_NAME
      or SUBB.PAGE_SETUP_DESC <> SUBT.PAGE_SETUP_DESC
      or (SUBB.PAGE_SETUP_DESC is null and SUBT.PAGE_SETUP_DESC is not null)
      or (SUBB.PAGE_SETUP_DESC is not null and SUBT.PAGE_SETUP_DESC is null)
  ));

Line: 302

  insert into AR_BPA_PAGE_SETUPS_TL (
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    PAGE_SETUP_ID,
    PAGE_SETUP_NAME,
    PAGE_SETUP_DESC,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_DATE,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.PAGE_SETUP_ID,
    B.PAGE_SETUP_NAME,
    B.PAGE_SETUP_DESC,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from AR_BPA_PAGE_SETUPS_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_PAGE_SETUPS_TL T
    where T.PAGE_SETUP_ID = B.PAGE_SETUP_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 359

    AR_BPA_PAGE_SETUPS_PKG.UPDATE_ROW (
	        X_PAGE_SETUP_ID 	=>  X_PAGE_SETUP_ID ,
		  X_PAGE_WIDTH 	=>  X_PAGE_WIDTH ,
		  X_PAGE_HEIGHT 	=>  X_PAGE_HEIGHT ,
		  X_TOP_MARGIN 	=>  X_TOP_MARGIN ,
		  X_BOTTOM_MARGIN 	=>  X_BOTTOM_MARGIN ,
		  X_LEFT_MARGIN 	=>  X_LEFT_MARGIN ,
		  X_RIGHT_MARGIN 	=>  X_RIGHT_MARGIN ,
		  X_PAGE_NUMBER_LOC 	=>  X_PAGE_NUMBER_LOC ,
		  X_SEEDED_FLAG 	=>  X_SEEDED_FLAG ,
		  X_PAGE_UNIT_OF_MEASURE 	=>  X_PAGE_UNIT_OF_MEASURE ,
		  X_PAGE_SETUP_NAME 	=>  X_PAGE_SETUP_NAME ,
		  X_PAGE_SETUP_DESC 	=>  X_PAGE_SETUP_DESC ,
              X_PRINT_FONT_FAMILY   =>  X_PRINT_FONT_FAMILY,
              X_PRINT_FONT_SIZE     =>  X_PRINT_FONT_SIZE,
              X_LAST_UPDATE_DATE 	=> sysdate,
		  X_LAST_UPDATED_BY 	=> user_id,
		  X_LAST_UPDATE_LOGIN 	=> 0);

Line: 379

           AR_BPA_PAGE_SETUPS_PKG.INSERT_ROW (
  		X_ROWID 			=> row_id,
	        X_PAGE_SETUP_ID 	=>  X_PAGE_SETUP_ID ,
		  X_PAGE_WIDTH 	=>  X_PAGE_WIDTH ,
		  X_PAGE_HEIGHT 	=>  X_PAGE_HEIGHT ,
		  X_TOP_MARGIN 	=>  X_TOP_MARGIN ,
		  X_BOTTOM_MARGIN 	=>  X_BOTTOM_MARGIN ,
		  X_LEFT_MARGIN 	=>  X_LEFT_MARGIN ,
		  X_RIGHT_MARGIN 	=>  X_RIGHT_MARGIN ,
		  X_PAGE_NUMBER_LOC 	=>  X_PAGE_NUMBER_LOC ,
		  X_SEEDED_FLAG 	=>  X_SEEDED_FLAG ,
		  X_PAGE_UNIT_OF_MEASURE 	=>  X_PAGE_UNIT_OF_MEASURE ,
		  X_PAGE_SETUP_NAME 	=>  X_PAGE_SETUP_NAME ,
		  X_PAGE_SETUP_DESC 	=>  X_PAGE_SETUP_DESC ,
              X_PRINT_FONT_FAMILY   =>  X_PRINT_FONT_FAMILY,
              X_PRINT_FONT_SIZE     =>  X_PRINT_FONT_SIZE,
  		  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);

Line: 410

    update AR_BPA_PAGE_SETUPS_TL
      set PAGE_SETUP_NAME = X_PAGE_SETUP_NAME ,
          PAGE_SETUP_DESC = X_PAGE_SETUP_DESC ,
          source_lang = userenv('LANG'),
          last_update_date = sysdate,
          last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
          last_update_login = 0
    where PAGE_SETUP_ID = X_PAGE_SETUP_ID
    and   userenv('LANG') in (language, source_lang);