APPS.FA_RX_ATTRSETS_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_REPORT_ID in NUMBER,
  X_ATTRIBUTE_SET in VARCHAR2,
  X_PAGE_WIDTH in NUMBER,
  X_PAGE_HEIGHT in NUMBER,
  X_PRINT_SOB_FLAG in VARCHAR2,
  X_PRINT_FUNC_CURR_FLAG in VARCHAR2,
  X_PRINT_TITLE in VARCHAR2,
  X_PRINT_SUBMISSION_DATE in VARCHAR2,
  X_PRINT_CURRENT_PAGE in VARCHAR2,
  X_PRINT_TOTAL_PAGES in VARCHAR2,
  X_PRINT_PARAMETERS in VARCHAR2,
  X_PRINT_PAGE_BREAK_COLS in VARCHAR2,
  X_GROUP_DISPLAY_TYPE in VARCHAR2,
  X_PUBLIC_FLAG in VARCHAR2,
  X_SYSTEM_FLAG in VARCHAR2,
  X_DEFAULT_DATE_FORMAT in VARCHAR2,
  X_DEFAULT_DATE_TIME_FORMAT in VARCHAR2,
  X_REPORT_TITLE in VARCHAR2,
  X_USER_ATTRIBUTE_SET 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 FA_RX_ATTRSETS_B
    where REPORT_ID = X_REPORT_ID
    and ATTRIBUTE_SET = X_ATTRIBUTE_SET
    ;

Line: 35

  insert into FA_RX_ATTRSETS_B (
    PAGE_WIDTH,
    PAGE_HEIGHT,
    PRINT_SOB_FLAG,
    PRINT_FUNC_CURR_FLAG,
    PRINT_TITLE,
    PRINT_SUBMISSION_DATE,
    PRINT_CURRENT_PAGE,
    PRINT_TOTAL_PAGES,
    PRINT_PARAMETERS,
    PRINT_PAGE_BREAK_COLS,
    GROUP_DISPLAY_TYPE,
    REPORT_ID,
    ATTRIBUTE_SET,
    PUBLIC_FLAG,
    SYSTEM_FLAG,
    DEFAULT_DATE_FORMAT,
    DEFAULT_DATE_TIME_FORMAT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PAGE_WIDTH,
    X_PAGE_HEIGHT,
    X_PRINT_SOB_FLAG,
    X_PRINT_FUNC_CURR_FLAG,
    X_PRINT_TITLE,
    X_PRINT_SUBMISSION_DATE,
    X_PRINT_CURRENT_PAGE,
    X_PRINT_TOTAL_PAGES,
    X_PRINT_PARAMETERS,
    X_PRINT_PAGE_BREAK_COLS,
    X_GROUP_DISPLAY_TYPE,
    X_REPORT_ID,
    X_ATTRIBUTE_SET,
    X_PUBLIC_FLAG,
    X_SYSTEM_FLAG,
    X_DEFAULT_DATE_FORMAT,
    X_DEFAULT_DATE_TIME_FORMAT,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 83

  insert into FA_RX_ATTRSETS_TL (
    REPORT_ID,
    ATTRIBUTE_SET,
    REPORT_TITLE,
    USER_ATTRIBUTE_SET,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATED_BY,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_REPORT_ID,
    X_ATTRIBUTE_SET,
    X_REPORT_TITLE,
    X_USER_ATTRIBUTE_SET,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATED_BY,
    X_CREATED_BY,
    X_CREATION_DATE,
    L.LANGUAGE_CODE,
    userenv('LANG')
  from FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and not exists
    (select NULL
    from FA_RX_ATTRSETS_TL T
    where T.REPORT_ID = X_REPORT_ID
    and T.ATTRIBUTE_SET = X_ATTRIBUTE_SET
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 124

end INSERT_ROW;

Line: 147

  cursor c is select
      PAGE_WIDTH,
      PAGE_HEIGHT,
      PRINT_SOB_FLAG,
      PRINT_FUNC_CURR_FLAG,
      PRINT_TITLE,
      PRINT_SUBMISSION_DATE,
      PRINT_CURRENT_PAGE,
      PRINT_TOTAL_PAGES,
      PRINT_PARAMETERS,
      PRINT_PAGE_BREAK_COLS,
      GROUP_DISPLAY_TYPE,
      PUBLIC_FLAG,
      SYSTEM_FLAG,
      DEFAULT_DATE_FORMAT,
      DEFAULT_DATE_TIME_FORMAT
    from FA_RX_ATTRSETS_B
    where REPORT_ID = X_REPORT_ID
    and ATTRIBUTE_SET = X_ATTRIBUTE_SET
    for update of REPORT_ID nowait;

Line: 169

  cursor c1 is select
      REPORT_TITLE,
      USER_ATTRIBUTE_SET,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from FA_RX_ATTRSETS_TL
    where REPORT_ID = X_REPORT_ID
    and ATTRIBUTE_SET = X_ATTRIBUTE_SET
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of REPORT_ID nowait;

Line: 183

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

Line: 243

procedure UPDATE_ROW (
  X_REPORT_ID in NUMBER,
  X_ATTRIBUTE_SET in VARCHAR2,
  X_PAGE_WIDTH in NUMBER,
  X_PAGE_HEIGHT in NUMBER,
  X_PRINT_SOB_FLAG in VARCHAR2,
  X_PRINT_FUNC_CURR_FLAG in VARCHAR2,
  X_PRINT_TITLE in VARCHAR2,
  X_PRINT_SUBMISSION_DATE in VARCHAR2,
  X_PRINT_CURRENT_PAGE in VARCHAR2,
  X_PRINT_TOTAL_PAGES in VARCHAR2,
  X_PRINT_PARAMETERS in VARCHAR2,
  X_PRINT_PAGE_BREAK_COLS in VARCHAR2,
  X_GROUP_DISPLAY_TYPE in VARCHAR2,
  X_PUBLIC_FLAG in VARCHAR2,
  X_SYSTEM_FLAG in VARCHAR2,
  X_DEFAULT_DATE_FORMAT in VARCHAR2,
  X_DEFAULT_DATE_TIME_FORMAT in VARCHAR2,
  X_REPORT_TITLE in VARCHAR2,
  X_USER_ATTRIBUTE_SET in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update FA_RX_ATTRSETS_B set
    PAGE_WIDTH = X_PAGE_WIDTH,
    PAGE_HEIGHT = X_PAGE_HEIGHT,
    PRINT_SOB_FLAG = X_PRINT_SOB_FLAG,
    PRINT_FUNC_CURR_FLAG = X_PRINT_FUNC_CURR_FLAG,
    PRINT_TITLE = X_PRINT_TITLE,
    PRINT_SUBMISSION_DATE = X_PRINT_SUBMISSION_DATE,
    PRINT_CURRENT_PAGE = X_PRINT_CURRENT_PAGE,
    PRINT_TOTAL_PAGES = X_PRINT_TOTAL_PAGES,
    PRINT_PARAMETERS = X_PRINT_PARAMETERS,
    PRINT_PAGE_BREAK_COLS = X_PRINT_PAGE_BREAK_COLS,
    GROUP_DISPLAY_TYPE = X_GROUP_DISPLAY_TYPE,
    PUBLIC_FLAG = X_PUBLIC_FLAG,
    SYSTEM_FLAG = X_SYSTEM_FLAG,
    DEFAULT_DATE_FORMAT = X_DEFAULT_DATE_FORMAT,
    DEFAULT_DATE_TIME_FORMAT = X_DEFAULT_DATE_TIME_FORMAT,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where REPORT_ID = X_REPORT_ID
  and ATTRIBUTE_SET = X_ATTRIBUTE_SET;

Line: 294

  update FA_RX_ATTRSETS_TL set
    REPORT_TITLE = X_REPORT_TITLE,
    USER_ATTRIBUTE_SET = X_USER_ATTRIBUTE_SET,
    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 REPORT_ID = X_REPORT_ID
  and ATTRIBUTE_SET = X_ATTRIBUTE_SET
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 308

end UPDATE_ROW;

Line: 310

procedure DELETE_ROW (
  X_REPORT_ID in NUMBER,
  X_ATTRIBUTE_SET in VARCHAR2
) is
begin
  delete from FA_RX_ATTRSETS_TL
  where REPORT_ID = X_REPORT_ID
  and ATTRIBUTE_SET = X_ATTRIBUTE_SET;

Line: 323

  delete from FA_RX_ATTRSETS_B
  where REPORT_ID = X_REPORT_ID
  and ATTRIBUTE_SET = X_ATTRIBUTE_SET;

Line: 330

end DELETE_ROW;

Line: 335

  delete from FA_RX_ATTRSETS_TL T
  where not exists
    (select NULL
    from FA_RX_ATTRSETS_B B
    where B.REPORT_ID = T.REPORT_ID
    and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
    );

Line: 343

  update FA_RX_ATTRSETS_TL T set (
      REPORT_TITLE,
      USER_ATTRIBUTE_SET
    ) = (select
      B.REPORT_TITLE,
      B.USER_ATTRIBUTE_SET
    from FA_RX_ATTRSETS_TL B
    where B.REPORT_ID = T.REPORT_ID
    and B.ATTRIBUTE_SET = T.ATTRIBUTE_SET
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.REPORT_ID,
      T.ATTRIBUTE_SET,
      T.LANGUAGE
  ) in (select
      SUBT.REPORT_ID,
      SUBT.ATTRIBUTE_SET,
      SUBT.LANGUAGE
    from FA_RX_ATTRSETS_TL SUBB, FA_RX_ATTRSETS_TL SUBT
    where SUBB.REPORT_ID = SUBT.REPORT_ID
    and SUBB.ATTRIBUTE_SET = SUBT.ATTRIBUTE_SET
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.REPORT_TITLE <> SUBT.REPORT_TITLE
      or (SUBB.REPORT_TITLE is null and SUBT.REPORT_TITLE is not null)
      or (SUBB.REPORT_TITLE is not null and SUBT.REPORT_TITLE is null)
      or SUBB.USER_ATTRIBUTE_SET <> SUBT.USER_ATTRIBUTE_SET
      or (SUBB.USER_ATTRIBUTE_SET is null and SUBT.USER_ATTRIBUTE_SET is not null)
      or (SUBB.USER_ATTRIBUTE_SET is not null and SUBT.USER_ATTRIBUTE_SET is null)
  ));

Line: 373

  insert into FA_RX_ATTRSETS_TL (
    REPORT_ID,
    ATTRIBUTE_SET,
    REPORT_TITLE,
    USER_ATTRIBUTE_SET,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    LAST_UPDATED_BY,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.REPORT_ID,
    B.ATTRIBUTE_SET,
    B.REPORT_TITLE,
    B.USER_ATTRIBUTE_SET,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATE_LOGIN,
    B.LAST_UPDATED_BY,
    B.CREATED_BY,
    B.CREATION_DATE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from FA_RX_ATTRSETS_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from FA_RX_ATTRSETS_TL T
    where T.REPORT_ID = B.REPORT_ID
    and T.ATTRIBUTE_SET = B.ATTRIBUTE_SET
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 452

	  X_Last_Update_Date => Null ,
	  X_CUSTOM_MODE => Null
  );

Line: 478

  X_Last_Update_Date VARCHAR2,
  X_CUSTOM_MODE in VARCHAR2
  )
is
	--* Bug#5102292, rravunny
	--* Begin
	--*
			f_luby number;  -- entity owner in file

Line: 486

			f_ludate date;  -- entity update date in file

Line: 488

			db_ludate date; -- entity update date in db

Line: 490

			db_ludate_tl date; -- entity update date in db

Line: 505

		-- Translate char last_update_date to date
		f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);

Line: 508

		select	LAST_UPDATED_BY, LAST_UPDATE_DATE
		into	db_luby, db_ludate
		from	fa_rx_attrsets_b
		where	report_id = X_Report_Id
		and     ATTRIBUTE_SET = X_ATTRIBUTE_SET;

Line: 515

			select	LAST_UPDATED_BY, LAST_UPDATE_DATE
			into	db_luby_tl, db_ludate_tl
			from	fa_rx_attrsets_tl
			where	report_id = X_Report_Id
			and     ATTRIBUTE_SET = X_ATTRIBUTE_SET
			and     language = userenv('LANG');

Line: 536

	    UPDATE_ROW (
		X_REPORT_ID =>			X_REPORT_ID,
		X_ATTRIBUTE_SET =>		X_ATTRIBUTE_SET,
		X_PAGE_WIDTH =>			X_PAGE_WIDTH,
		X_PAGE_HEIGHT =>		X_PAGE_HEIGHT,
		X_PRINT_SOB_FLAG =>		X_PRINT_SOB_FLAG,
		X_PRINT_FUNC_CURR_FLAG =>	X_PRINT_FUNC_CURR_FLAG,
		X_PRINT_TITLE =>		X_PRINT_TITLE,
		X_PRINT_SUBMISSION_DATE =>	X_PRINT_SUBMISSION_DATE,
		X_PRINT_CURRENT_PAGE =>		X_PRINT_CURRENT_PAGE,
		X_PRINT_TOTAL_PAGES =>		X_PRINT_TOTAL_PAGES,
		X_PRINT_PARAMETERS =>		X_PRINT_PARAMETERS,
		X_PRINT_PAGE_BREAK_COLS =>	X_PRINT_PAGE_BREAK_COLS,
		X_GROUP_DISPLAY_TYPE =>		X_GROUP_DISPLAY_TYPE,
		X_PUBLIC_FLAG =>		X_PUBLIC_FLAG,
		X_SYSTEM_FLAG =>		X_SYSTEM_FLAG,
		X_DEFAULT_DATE_FORMAT =>	X_DEFAULT_DATE_FORMAT,
		X_DEFAULT_DATE_TIME_FORMAT =>	X_DEFAULT_DATE_TIME_FORMAT,
		X_REPORT_TITLE =>		X_REPORT_TITLE,
		X_USER_ATTRIBUTE_SET =>		X_USER_ATTRIBUTE_SET,
		X_LAST_UPDATE_DATE =>		f_ludate,
		X_LAST_UPDATED_BY =>		f_luby,
		X_LAST_UPDATE_LOGIN =>		0);

Line: 563

    INSERT_ROW(
	X_ROWID =>			row_id,
	X_REPORT_ID =>			X_REPORT_ID,
	X_ATTRIBUTE_SET =>		X_ATTRIBUTE_SET,
	X_PAGE_WIDTH =>			X_PAGE_WIDTH,
	X_PAGE_HEIGHT =>		X_PAGE_HEIGHT,
	X_PRINT_SOB_FLAG =>		X_PRINT_SOB_FLAG,
	X_PRINT_FUNC_CURR_FLAG =>	X_PRINT_FUNC_CURR_FLAG,
	X_PRINT_TITLE =>		X_PRINT_TITLE,
	X_PRINT_SUBMISSION_DATE =>	X_PRINT_SUBMISSION_DATE,
	X_PRINT_CURRENT_PAGE =>		X_PRINT_CURRENT_PAGE,
	X_PRINT_TOTAL_PAGES =>		X_PRINT_TOTAL_PAGES,
	X_PRINT_PARAMETERS =>		X_PRINT_PARAMETERS,
	X_PRINT_PAGE_BREAK_COLS =>	X_PRINT_PAGE_BREAK_COLS,
	X_GROUP_DISPLAY_TYPE =>		X_GROUP_DISPLAY_TYPE,
	X_PUBLIC_FLAG =>		X_PUBLIC_FLAG,
	X_SYSTEM_FLAG =>		X_SYSTEM_FLAG,
	X_DEFAULT_DATE_FORMAT =>	X_DEFAULT_DATE_FORMAT,
	X_DEFAULT_DATE_TIME_FORMAT =>	X_DEFAULT_DATE_TIME_FORMAT,
	X_REPORT_TITLE =>		X_REPORT_TITLE,
	X_USER_ATTRIBUTE_SET =>		X_USER_ATTRIBUTE_SET,
	X_CREATION_DATE =>		f_ludate,
	X_CREATED_BY =>			f_luby,
	X_LAST_UPDATE_DATE =>		f_ludate,
	X_LAST_UPDATED_BY =>		f_luby,
	X_LAST_UPDATE_LOGIN =>		0);

Line: 605

	  X_LAST_UPDATE_DATE => null,
	  X_CUSTOM_MODE=>null);

Line: 615

  X_Last_Update_Date VARCHAR2,
  X_CUSTOM_MODE in VARCHAR2
  )
is
  f_luby number;  -- entity owner in file

Line: 620

  f_ludate date;  -- entity update date in file

Line: 628

	-- Translate char last_update_date to date
	f_ludate := nvl(to_date(X_Last_Update_Date, 'YYYY/MM/DD HH24:MI:SS'), sysdate);

Line: 633

	  update fa_rx_attrsets_tl
	  set	 user_attribute_set = X_USER_ATTRIBUTE_SET,
		 report_title = X_REPORT_TITLE,
		 LAST_UPDATE_DATE = f_ludate,
		 LAST_UPDATED_BY = f_luby,
		 LAST_UPDATE_LOGIN = 0 ,
		 SOURCE_LANG = userenv('LANG')
	  where REPORT_ID = X_REPORT_ID
	  and ATTRIBUTE_SET = X_ATTRIBUTE_SET
	  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);