APPS.JTF_DPF_LOGICAL_PAGES_PKG SQL Statements

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

Line: 6

	x_application_id number) is select logical_page_id
    from jtf_dpf_logical_pages_b
    where application_id = x_application_id and
      logical_page_name=x_logical_page_name;

Line: 11

procedure INSERT_ROW (
  X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
  X_LOGICAL_PAGE_ID in NUMBER,
  X_LOGICAL_PAGE_NAME in VARCHAR2,
  X_LOGICAL_PAGE_TYPE in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_PAGE_CONTROLLER_CLASS in VARCHAR2,
  X_PAGE_PERMISSION_NAME in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LOGICAL_PAGE_DESCRIPTION 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 JTF_DPF_LOGICAL_PAGES_B
    where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
    ;

Line: 32

  insert into JTF_DPF_LOGICAL_PAGES_B (
    LOGICAL_PAGE_ID,
    LOGICAL_PAGE_NAME,
    LOGICAL_PAGE_TYPE,
    APPLICATION_ID,
    ENABLED_FLAG,
    PAGE_CONTROLLER_CLASS,
    PAGE_PERMISSION_NAME,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_LOGICAL_PAGE_ID,
    X_LOGICAL_PAGE_NAME,
    X_LOGICAL_PAGE_TYPE,
    X_APPLICATION_ID,
    X_ENABLED_FLAG,
    X_PAGE_CONTROLLER_CLASS,
    X_PAGE_PERMISSION_NAME,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 62

  insert into JTF_DPF_LOGICAL_PAGES_TL (
    LOGICAL_PAGE_ID,
    LOGICAL_PAGE_DESCRIPTION,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_LOGICAL_PAGE_ID,
    X_LOGICAL_PAGE_DESCRIPTION,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    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 JTF_DPF_LOGICAL_PAGES_TL T
    where T.LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 96

end INSERT_ROW;

Line: 109

  cursor c is select
      LOGICAL_PAGE_NAME,
      LOGICAL_PAGE_TYPE,
      APPLICATION_ID,
      ENABLED_FLAG,
      PAGE_CONTROLLER_CLASS,
      PAGE_PERMISSION_NAME,
      OBJECT_VERSION_NUMBER
    from JTF_DPF_LOGICAL_PAGES_B
    where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
    for update of LOGICAL_PAGE_ID nowait;

Line: 122

  cursor c1 is select
      LOGICAL_PAGE_DESCRIPTION,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from JTF_DPF_LOGICAL_PAGES_TL
    where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of LOGICAL_PAGE_ID nowait;

Line: 134

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

Line: 170

procedure UPDATE_ROW (
  X_LOGICAL_PAGE_ID in NUMBER,
  X_LOGICAL_PAGE_NAME in VARCHAR2,
  X_LOGICAL_PAGE_TYPE in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_ENABLED_FLAG in VARCHAR2,
  X_PAGE_CONTROLLER_CLASS in VARCHAR2,
  X_PAGE_PERMISSION_NAME in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LOGICAL_PAGE_DESCRIPTION in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update JTF_DPF_LOGICAL_PAGES_B set
    LOGICAL_PAGE_NAME = X_LOGICAL_PAGE_NAME,
    LOGICAL_PAGE_TYPE = X_LOGICAL_PAGE_TYPE,
    APPLICATION_ID = X_APPLICATION_ID,
    ENABLED_FLAG = X_ENABLED_FLAG,
    PAGE_CONTROLLER_CLASS = X_PAGE_CONTROLLER_CLASS,
    PAGE_PERMISSION_NAME = X_PAGE_PERMISSION_NAME,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID;

Line: 202

  update JTF_DPF_LOGICAL_PAGES_TL set
    LOGICAL_PAGE_DESCRIPTION = X_LOGICAL_PAGE_DESCRIPTION,
    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 LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 214

end UPDATE_ROW;

Line: 216

procedure DELETE_ROW (
  X_LOGICAL_PAGE_ID in NUMBER
) is
begin
  delete from JTF_DPF_LOGICAL_PAGES_TL
  where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID;

Line: 227

  delete from JTF_DPF_LOGICAL_PAGES_B
  where LOGICAL_PAGE_ID = X_LOGICAL_PAGE_ID;

Line: 233

end DELETE_ROW;

Line: 238

  delete from JTF_DPF_LOGICAL_PAGES_TL T
  where not exists
    (select NULL
    from JTF_DPF_LOGICAL_PAGES_B B
    where B.LOGICAL_PAGE_ID = T.LOGICAL_PAGE_ID
    );

Line: 245

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

Line: 266

  insert into JTF_DPF_LOGICAL_PAGES_TL (
    LOGICAL_PAGE_ID,
    LOGICAL_PAGE_DESCRIPTION,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.LOGICAL_PAGE_ID,
    B.LOGICAL_PAGE_DESCRIPTION,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from JTF_DPF_LOGICAL_PAGES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from JTF_DPF_LOGICAL_PAGES_TL T
    where T.LOGICAL_PAGE_ID = B.LOGICAL_PAGE_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);

Line: 307

    update jtf_dpf_logical_pages_tl set
	logical_page_description = x_logical_page_description,
	last_updated_by = l_user_id,
	last_update_date = sysdate,
	last_update_login = 0,
	source_lang = userenv('LANG')
      where userenv('LANG') in (LANGUAGE, SOURCE_LANG) and
        logical_page_id = l_lid;

Line: 322

    X_FORCE_UPDATE_FLAG VARCHAR2) is
    l_do_it boolean := false;

Line: 335

    if x_force_update_flag = 'TRUE' then l_do_it := true; end if;

Line: 341

        select last_updated_by into l_owner_of_l2p
          from jtf_dpf_lgcl_phy_rules
          where logical_page_id = l_logical_page_id and
	    default_page_flag = 'T';

Line: 353

      delete from jtf_dpf_lgcl_phy_rules
        where logical_page_id = l_logical_page_id and
	  default_page_flag = 'F' and
	  rule_eval_sequence > x_num_non_def_rules;

Line: 390

      select JTF_DPF_LOGICAL_PAGES_S.nextval into t_new_logical_id from dual;

Line: 401

      insert_row(
	X_ROWID				=> t_rowid,
	X_LOGICAL_PAGE_ID		=> t_new_logical_id,
	X_LOGICAL_PAGE_NAME		=> x_logical_page_name,
	X_LOGICAL_PAGE_TYPE		=> x_logical_page_type,
	X_APPLICATION_ID		=> x_application_id,
	X_ENABLED_FLAG			=> x_enabled_flag,
	X_PAGE_CONTROLLER_CLASS		=> x_page_controller_class,
	X_PAGE_PERMISSION_NAME		=> x_page_permission_name,
	X_OBJECT_VERSION_NUMBER		=> 1,
	X_LOGICAL_PAGE_DESCRIPTION	=> x_logical_page_description,
	X_CREATION_DATE			=> sysdate,
	X_CREATED_BY			=> t_user,
	X_LAST_UPDATE_DATE		=> sysdate,
	X_LAST_UPDATED_BY		=> t_user,
	X_LAST_UPDATE_LOGIN		=> 0
      );

Line: 422

      update_row(
	X_LOGICAL_PAGE_ID		=> t_old_logical_id,
	X_LOGICAL_PAGE_NAME		=> x_logical_page_name,
	X_LOGICAL_PAGE_TYPE		=> x_logical_page_type,
	X_APPLICATION_ID		=> x_application_id,
	X_ENABLED_FLAG			=> x_enabled_flag,
	X_PAGE_CONTROLLER_CLASS		=> x_page_controller_class,
	X_PAGE_PERMISSION_NAME		=> x_page_permission_name,
	X_OBJECT_VERSION_NUMBER		=> 1,
	X_LOGICAL_PAGE_DESCRIPTION	=> x_logical_page_description,
	X_LAST_UPDATE_DATE		=> sysdate,
	X_LAST_UPDATED_BY		=> t_user,
	X_LAST_UPDATE_LOGIN		=> 0
      );

Line: 461

    x_force_update_flag			varchar2) is
    l_last_updated_by number;

Line: 468

    l_is_update varchar2(1);

Line: 473

      select logical_physical_id
	from jtf_dpf_lgcl_phy_rules
	where logical_page_id=p_logical_page_id and
	  default_page_flag='T';

Line: 478

      select logical_physical_id
	from jtf_dpf_lgcl_phy_rules
	where logical_page_id=p_logical_page_id and
	  default_page_flag='F' and
	  rule_eval_sequence = p_seq;

Line: 494

    if x_force_update_flag = 'TRUE' then l_do_it := true; end if;

Line: 500

        select last_updated_by into l_owner_of_l2p
          from jtf_dpf_lgcl_phy_rules
          where logical_page_id = l_logical_id and
	    default_page_flag = 'T';

Line: 533

      select JTF_DPF_LGCL_PHY_RULES_S.nextval into t_new_lpid from dual;

Line: 543

      insert into jtf_dpf_lgcl_phy_rules(
	logical_physical_id,
	logical_page_id,
	rule_eval_sequence,
	default_page_flag,
	physical_page_id,
	rule_id,
		object_version_number,
		created_by,
		creation_date,
		last_update_date,
		last_updated_by,
		last_update_login)
      values (
	t_new_lpid,
	l_logical_id,
	x_rule_eval_sequence,
	x_default_page_flag,
	l_physical_id,
	l_rule_id,
	1,
	l_user_id,
	sysdate,
	sysdate,
	l_user_id,
	0);

Line: 572

      select last_updated_by into l_last_updated_by
	from jtf_dpf_lgcl_phy_rules
        where logical_physical_id = l_lpid;

Line: 575

      if l_last_updated_by = l_user_id or
	  x_force_update_flag = 'TRUE' then
        update jtf_dpf_lgcl_phy_rules set
	  physical_page_id = l_physical_id,
	  rule_id = l_rule_id,
		object_version_number = object_version_number +1,
		last_update_date = sysdate,
		last_updated_by = l_user_id,
		last_update_login = 0
        where logical_physical_id = l_lpid;