DBA Data[Home] [Help]

APPS.HR_TAB_PAGE_PROPERTIES_PKG SQL Statements

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

Line: 6

procedure UPDATE_COPIES (
  X_TAB_PAGE_PROPERTY_ID in NUMBER,
  X_FORM_TAB_PAGE_ID in NUMBER,
  X_TEMPLATE_TAB_PAGE_ID in NUMBER,
  X_NAVIGATION_DIRECTION in VARCHAR2,
  X_VISIBLE in NUMBER,
  X_LABEL in VARCHAR2,
  X_INFORMATION_CATEGORY in VARCHAR2,
  X_INFORMATION1 in VARCHAR2,
  X_INFORMATION2 in VARCHAR2,
  X_INFORMATION3 in VARCHAR2,
  X_INFORMATION4 in VARCHAR2,
  X_INFORMATION5 in VARCHAR2,
  X_INFORMATION6 in VARCHAR2,
  X_INFORMATION7 in VARCHAR2,
  X_INFORMATION8 in VARCHAR2,
  X_INFORMATION9 in VARCHAR2,
  X_INFORMATION10 in VARCHAR2,
  X_INFORMATION11 in VARCHAR2,
  X_INFORMATION12 in VARCHAR2,
  X_INFORMATION13 in VARCHAR2,
  X_INFORMATION14 in VARCHAR2,
  X_INFORMATION15 in VARCHAR2,
  X_INFORMATION16 in VARCHAR2,
  X_INFORMATION17 in VARCHAR2,
  X_INFORMATION18 in VARCHAR2,
  X_INFORMATION19 in VARCHAR2,
  X_INFORMATION20 in VARCHAR2,
  X_INFORMATION21 in VARCHAR2,
  X_INFORMATION22 in VARCHAR2,
  X_INFORMATION23 in VARCHAR2,
  X_INFORMATION24 in VARCHAR2,
  X_INFORMATION25 in VARCHAR2,
  X_INFORMATION26 in VARCHAR2,
  X_INFORMATION27 in VARCHAR2,
  X_INFORMATION28 in VARCHAR2,
  X_INFORMATION29 in VARCHAR2,
  X_INFORMATION30 in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor csr_original is
    select *
      from HR_TAB_PAGE_PROPERTIES_VL
     where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
Line: 54

    select tpp.tab_page_property_id
      from HR_TAB_PAGE_PROPERTIES_B tpp
          ,HR_TEMPLATE_TAB_PAGES_B ttp
          ,HR_TEMPLATE_CANVASES_B tcn
          ,HR_TEMPLATE_WINDOWS_B twn
          ,HR_TEMPLATE_TAB_PAGES_B tto
     where tpp.TEMPLATE_TAB_PAGE_ID = ttp.TEMPLATE_TAB_PAGE_ID
       and ttp.TEMPLATE_CANVAS_ID = tcn.TEMPLATE_CANVAS_ID
       and tcn.TEMPLATE_WINDOW_ID = twn.TEMPLATE_WINDOW_ID
       and twn.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
                                      from HR_SOURCE_FORM_TEMPLATES sft
                                start with sft.FORM_TEMPLATE_ID_FROM = (select tw1.FORM_TEMPLATE_ID
                                                                          from HR_TEMPLATE_WINDOWS_B tw1
                                                                              ,HR_TEMPLATE_CANVASES_B tc1
                                                                         where tw1.TEMPLATE_WINDOW_ID = tc1.TEMPLATE_WINDOW_ID
                                                                           and tc1.TEMPLATE_CANVAS_ID = tto.TEMPLATE_CANVAS_ID)
                                connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO)
       and ttp.FORM_TAB_PAGE_ID = tto.FORM_TAB_PAGE_ID
       and tto.TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID;
Line: 80

        update HR_TAB_PAGE_PROPERTIES_B set
          NAVIGATION_DIRECTION = decode(nvl(NAVIGATION_DIRECTION,hr_api.g_varchar2),nvl(l_original.NAVIGATION_DIRECTION,hr_api.g_varchar2),X_NAVIGATION_DIRECTION,NAVIGATION_DIRECTION),
          VISIBLE = decode(nvl(VISIBLE,hr_api.g_number),nvl(l_original.VISIBLE,hr_api.g_number),X_VISIBLE,VISIBLE),
          INFORMATION_CATEGORY = decode(nvl(INFORMATION_CATEGORY,hr_api.g_varchar2),nvl(l_original.INFORMATION_CATEGORY,hr_api.g_varchar2),X_INFORMATION_CATEGORY,INFORMATION_CATEGORY),
          INFORMATION1  = decode(nvl(INFORMATION1 ,hr_api.g_varchar2),nvl(l_original.INFORMATION1 ,hr_api.g_varchar2),X_INFORMATION1 ,INFORMATION1 ),
          INFORMATION2  = decode(nvl(INFORMATION2 ,hr_api.g_varchar2),nvl(l_original.INFORMATION2 ,hr_api.g_varchar2),X_INFORMATION2 ,INFORMATION2 ),
          INFORMATION3  = decode(nvl(INFORMATION3 ,hr_api.g_varchar2),nvl(l_original.INFORMATION3 ,hr_api.g_varchar2),X_INFORMATION3 ,INFORMATION3 ),
          INFORMATION4  = decode(nvl(INFORMATION4 ,hr_api.g_varchar2),nvl(l_original.INFORMATION4 ,hr_api.g_varchar2),X_INFORMATION4 ,INFORMATION4 ),
          INFORMATION5  = decode(nvl(INFORMATION5 ,hr_api.g_varchar2),nvl(l_original.INFORMATION5 ,hr_api.g_varchar2),X_INFORMATION5 ,INFORMATION5 ),
          INFORMATION6  = decode(nvl(INFORMATION6 ,hr_api.g_varchar2),nvl(l_original.INFORMATION6 ,hr_api.g_varchar2),X_INFORMATION6 ,INFORMATION6 ),
          INFORMATION7  = decode(nvl(INFORMATION7 ,hr_api.g_varchar2),nvl(l_original.INFORMATION7 ,hr_api.g_varchar2),X_INFORMATION7 ,INFORMATION7 ),
          INFORMATION8  = decode(nvl(INFORMATION8 ,hr_api.g_varchar2),nvl(l_original.INFORMATION8 ,hr_api.g_varchar2),X_INFORMATION8 ,INFORMATION8 ),
          INFORMATION9  = decode(nvl(INFORMATION9 ,hr_api.g_varchar2),nvl(l_original.INFORMATION9 ,hr_api.g_varchar2),X_INFORMATION9 ,INFORMATION9 ),
          INFORMATION10 = decode(nvl(INFORMATION10,hr_api.g_varchar2),nvl(l_original.INFORMATION10,hr_api.g_varchar2),X_INFORMATION10,INFORMATION10),
          INFORMATION11 = decode(nvl(INFORMATION11,hr_api.g_varchar2),nvl(l_original.INFORMATION11,hr_api.g_varchar2),X_INFORMATION11,INFORMATION11),
          INFORMATION12 = decode(nvl(INFORMATION12,hr_api.g_varchar2),nvl(l_original.INFORMATION12,hr_api.g_varchar2),X_INFORMATION12,INFORMATION12),
          INFORMATION13 = decode(nvl(INFORMATION13,hr_api.g_varchar2),nvl(l_original.INFORMATION13,hr_api.g_varchar2),X_INFORMATION13,INFORMATION13),
          INFORMATION14 = decode(nvl(INFORMATION14,hr_api.g_varchar2),nvl(l_original.INFORMATION14,hr_api.g_varchar2),X_INFORMATION14,INFORMATION14),
          INFORMATION15 = decode(nvl(INFORMATION15,hr_api.g_varchar2),nvl(l_original.INFORMATION15,hr_api.g_varchar2),X_INFORMATION15,INFORMATION15),
          INFORMATION16 = decode(nvl(INFORMATION16,hr_api.g_varchar2),nvl(l_original.INFORMATION16,hr_api.g_varchar2),X_INFORMATION16,INFORMATION16),
          INFORMATION17 = decode(nvl(INFORMATION17,hr_api.g_varchar2),nvl(l_original.INFORMATION17,hr_api.g_varchar2),X_INFORMATION17,INFORMATION17),
          INFORMATION18 = decode(nvl(INFORMATION18,hr_api.g_varchar2),nvl(l_original.INFORMATION18,hr_api.g_varchar2),X_INFORMATION18,INFORMATION18),
          INFORMATION19 = decode(nvl(INFORMATION19,hr_api.g_varchar2),nvl(l_original.INFORMATION19,hr_api.g_varchar2),X_INFORMATION19,INFORMATION19),
          INFORMATION20 = decode(nvl(INFORMATION20,hr_api.g_varchar2),nvl(l_original.INFORMATION20,hr_api.g_varchar2),X_INFORMATION20,INFORMATION20),
          INFORMATION21 = decode(nvl(INFORMATION21,hr_api.g_varchar2),nvl(l_original.INFORMATION21,hr_api.g_varchar2),X_INFORMATION21,INFORMATION21),
          INFORMATION22 = decode(nvl(INFORMATION22,hr_api.g_varchar2),nvl(l_original.INFORMATION22,hr_api.g_varchar2),X_INFORMATION22,INFORMATION22),
          INFORMATION23 = decode(nvl(INFORMATION23,hr_api.g_varchar2),nvl(l_original.INFORMATION23,hr_api.g_varchar2),X_INFORMATION23,INFORMATION23),
          INFORMATION24 = decode(nvl(INFORMATION24,hr_api.g_varchar2),nvl(l_original.INFORMATION24,hr_api.g_varchar2),X_INFORMATION24,INFORMATION24),
          INFORMATION25 = decode(nvl(INFORMATION25,hr_api.g_varchar2),nvl(l_original.INFORMATION25,hr_api.g_varchar2),X_INFORMATION25,INFORMATION25),
          INFORMATION26 = decode(nvl(INFORMATION26,hr_api.g_varchar2),nvl(l_original.INFORMATION26,hr_api.g_varchar2),X_INFORMATION26,INFORMATION26),
          INFORMATION27 = decode(nvl(INFORMATION27,hr_api.g_varchar2),nvl(l_original.INFORMATION27,hr_api.g_varchar2),X_INFORMATION27,INFORMATION27),
          INFORMATION28 = decode(nvl(INFORMATION28,hr_api.g_varchar2),nvl(l_original.INFORMATION28,hr_api.g_varchar2),X_INFORMATION28,INFORMATION28),
          INFORMATION29 = decode(nvl(INFORMATION29,hr_api.g_varchar2),nvl(l_original.INFORMATION29,hr_api.g_varchar2),X_INFORMATION29,INFORMATION29),
          INFORMATION30 = decode(nvl(INFORMATION30,hr_api.g_varchar2),nvl(l_original.INFORMATION30,hr_api.g_varchar2),X_INFORMATION30,INFORMATION30),
          LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
          LAST_UPDATED_BY = X_LAST_UPDATED_BY,
          LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
        where TAB_PAGE_PROPERTY_ID = l_copy.TAB_PAGE_PROPERTY_ID;
Line: 121

        update HR_TAB_PAGE_PROPERTIES_TL set
          LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
          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 TAB_PAGE_PROPERTY_ID = l_copy.TAB_PAGE_PROPERTY_ID
          and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 137

end UPDATE_COPIES;
Line: 143

  X_LAST_UPDATE_DATE out nocopy DATE,
  X_LAST_UPDATED_BY out nocopy NUMBER,
  X_LAST_UPDATE_LOGIN out nocopy NUMBER
) is
begin
  if X_OWNER = 'SEED' then
    X_CREATED_BY := 1;
Line: 150

    X_LAST_UPDATED_BY := 1;
Line: 153

    X_LAST_UPDATED_BY := 0;
Line: 156

  X_LAST_UPDATE_DATE := sysdate;
Line: 157

  X_LAST_UPDATE_LOGIN := 0;
Line: 159

procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_TAB_PAGE_PROPERTY_ID in NUMBER,
  X_FORM_TAB_PAGE_ID in NUMBER,
  X_TEMPLATE_TAB_PAGE_ID in NUMBER,
  X_NAVIGATION_DIRECTION in VARCHAR2,
  X_VISIBLE in NUMBER,
  X_INFORMATION_CATEGORY in VARCHAR2,
  X_INFORMATION9 in VARCHAR2,
  X_INFORMATION10 in VARCHAR2,
  X_INFORMATION11 in VARCHAR2,
  X_INFORMATION12 in VARCHAR2,
  X_INFORMATION13 in VARCHAR2,
  X_INFORMATION14 in VARCHAR2,
  X_INFORMATION15 in VARCHAR2,
  X_INFORMATION16 in VARCHAR2,
  X_INFORMATION17 in VARCHAR2,
  X_INFORMATION18 in VARCHAR2,
  X_INFORMATION19 in VARCHAR2,
  X_INFORMATION20 in VARCHAR2,
  X_INFORMATION21 in VARCHAR2,
  X_INFORMATION7 in VARCHAR2,
  X_INFORMATION8 in VARCHAR2,
  X_INFORMATION29 in VARCHAR2,
  X_INFORMATION30 in VARCHAR2,
  X_INFORMATION6 in VARCHAR2,
  X_INFORMATION1 in VARCHAR2,
  X_INFORMATION2 in VARCHAR2,
  X_INFORMATION3 in VARCHAR2,
  X_INFORMATION4 in VARCHAR2,
  X_INFORMATION5 in VARCHAR2,
  X_INFORMATION22 in VARCHAR2,
  X_INFORMATION23 in VARCHAR2,
  X_INFORMATION24 in VARCHAR2,
  X_INFORMATION25 in VARCHAR2,
  X_INFORMATION26 in VARCHAR2,
  X_INFORMATION27 in VARCHAR2,
  X_INFORMATION28 in VARCHAR2,
  X_LABEL 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 HR_TAB_PAGE_PROPERTIES_B
    where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
    ;
Line: 208

  insert into HR_TAB_PAGE_PROPERTIES_B (
    TAB_PAGE_PROPERTY_ID,
    FORM_TAB_PAGE_ID,
    TEMPLATE_TAB_PAGE_ID,
    NAVIGATION_DIRECTION,
    VISIBLE,
    INFORMATION_CATEGORY,
    INFORMATION9,
    INFORMATION10,
    INFORMATION11,
    INFORMATION12,
    INFORMATION13,
    INFORMATION14,
    INFORMATION15,
    INFORMATION16,
    INFORMATION17,
    INFORMATION18,
    INFORMATION19,
    INFORMATION20,
    INFORMATION21,
    INFORMATION7,
    INFORMATION8,
    INFORMATION29,
    INFORMATION30,
    INFORMATION6,
    INFORMATION1,
    INFORMATION2,
    INFORMATION3,
    INFORMATION4,
    INFORMATION5,
    INFORMATION22,
    INFORMATION23,
    INFORMATION24,
    INFORMATION25,
    INFORMATION26,
    INFORMATION27,
    INFORMATION28,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_TAB_PAGE_PROPERTY_ID,
    X_FORM_TAB_PAGE_ID,
    X_TEMPLATE_TAB_PAGE_ID,
    X_NAVIGATION_DIRECTION,
    X_VISIBLE,
    X_INFORMATION_CATEGORY,
    X_INFORMATION9,
    X_INFORMATION10,
    X_INFORMATION11,
    X_INFORMATION12,
    X_INFORMATION13,
    X_INFORMATION14,
    X_INFORMATION15,
    X_INFORMATION16,
    X_INFORMATION17,
    X_INFORMATION18,
    X_INFORMATION19,
    X_INFORMATION20,
    X_INFORMATION21,
    X_INFORMATION7,
    X_INFORMATION8,
    X_INFORMATION29,
    X_INFORMATION30,
    X_INFORMATION6,
    X_INFORMATION1,
    X_INFORMATION2,
    X_INFORMATION3,
    X_INFORMATION4,
    X_INFORMATION5,
    X_INFORMATION22,
    X_INFORMATION23,
    X_INFORMATION24,
    X_INFORMATION25,
    X_INFORMATION26,
    X_INFORMATION27,
    X_INFORMATION28,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );
Line: 294

  insert into HR_TAB_PAGE_PROPERTIES_TL (
    TAB_PAGE_PROPERTY_ID,
    LABEL,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    X_TAB_PAGE_PROPERTY_ID,
    X_LABEL,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    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 HR_TAB_PAGE_PROPERTIES_TL T
    where T.TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 330

end INSERT_ROW;
Line: 371

  cursor c is select
      FORM_TAB_PAGE_ID,
      TEMPLATE_TAB_PAGE_ID,
      NAVIGATION_DIRECTION,
      VISIBLE,
      INFORMATION_CATEGORY,
      INFORMATION9,
      INFORMATION10,
      INFORMATION11,
      INFORMATION12,
      INFORMATION13,
      INFORMATION14,
      INFORMATION15,
      INFORMATION16,
      INFORMATION17,
      INFORMATION18,
      INFORMATION19,
      INFORMATION20,
      INFORMATION21,
      INFORMATION7,
      INFORMATION8,
      INFORMATION29,
      INFORMATION30,
      INFORMATION6,
      INFORMATION1,
      INFORMATION2,
      INFORMATION3,
      INFORMATION4,
      INFORMATION5,
      INFORMATION22,
      INFORMATION23,
      INFORMATION24,
      INFORMATION25,
      INFORMATION26,
      INFORMATION27,
      INFORMATION28
    from HR_TAB_PAGE_PROPERTIES_B
    where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
    for update of TAB_PAGE_PROPERTY_ID nowait;
Line: 412

  cursor c1 is select
      LABEL,
      decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
    from HR_TAB_PAGE_PROPERTIES_TL
    where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
    and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
    for update of TAB_PAGE_PROPERTY_ID nowait;
Line: 424

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
Line: 520

procedure UPDATE_ROW (
  X_TAB_PAGE_PROPERTY_ID in NUMBER,
  X_FORM_TAB_PAGE_ID in NUMBER,
  X_TEMPLATE_TAB_PAGE_ID in NUMBER,
  X_NAVIGATION_DIRECTION in VARCHAR2,
  X_VISIBLE in NUMBER,
  X_INFORMATION_CATEGORY in VARCHAR2,
  X_INFORMATION9 in VARCHAR2,
  X_INFORMATION10 in VARCHAR2,
  X_INFORMATION11 in VARCHAR2,
  X_INFORMATION12 in VARCHAR2,
  X_INFORMATION13 in VARCHAR2,
  X_INFORMATION14 in VARCHAR2,
  X_INFORMATION15 in VARCHAR2,
  X_INFORMATION16 in VARCHAR2,
  X_INFORMATION17 in VARCHAR2,
  X_INFORMATION18 in VARCHAR2,
  X_INFORMATION19 in VARCHAR2,
  X_INFORMATION20 in VARCHAR2,
  X_INFORMATION21 in VARCHAR2,
  X_INFORMATION7 in VARCHAR2,
  X_INFORMATION8 in VARCHAR2,
  X_INFORMATION29 in VARCHAR2,
  X_INFORMATION30 in VARCHAR2,
  X_INFORMATION6 in VARCHAR2,
  X_INFORMATION1 in VARCHAR2,
  X_INFORMATION2 in VARCHAR2,
  X_INFORMATION3 in VARCHAR2,
  X_INFORMATION4 in VARCHAR2,
  X_INFORMATION5 in VARCHAR2,
  X_INFORMATION22 in VARCHAR2,
  X_INFORMATION23 in VARCHAR2,
  X_INFORMATION24 in VARCHAR2,
  X_INFORMATION25 in VARCHAR2,
  X_INFORMATION26 in VARCHAR2,
  X_INFORMATION27 in VARCHAR2,
  X_INFORMATION28 in VARCHAR2,
  X_LABEL in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_TAB_PAGE_PROPERTIES_B set
    FORM_TAB_PAGE_ID = X_FORM_TAB_PAGE_ID,
    TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
    NAVIGATION_DIRECTION = X_NAVIGATION_DIRECTION,
    VISIBLE = X_VISIBLE,
    INFORMATION_CATEGORY = X_INFORMATION_CATEGORY,
    INFORMATION9 = X_INFORMATION9,
    INFORMATION10 = X_INFORMATION10,
    INFORMATION11 = X_INFORMATION11,
    INFORMATION12 = X_INFORMATION12,
    INFORMATION13 = X_INFORMATION13,
    INFORMATION14 = X_INFORMATION14,
    INFORMATION15 = X_INFORMATION15,
    INFORMATION16 = X_INFORMATION16,
    INFORMATION17 = X_INFORMATION17,
    INFORMATION18 = X_INFORMATION18,
    INFORMATION19 = X_INFORMATION19,
    INFORMATION20 = X_INFORMATION20,
    INFORMATION21 = X_INFORMATION21,
    INFORMATION7 = X_INFORMATION7,
    INFORMATION8 = X_INFORMATION8,
    INFORMATION29 = X_INFORMATION29,
    INFORMATION30 = X_INFORMATION30,
    INFORMATION6 = X_INFORMATION6,
    INFORMATION1 = X_INFORMATION1,
    INFORMATION2 = X_INFORMATION2,
    INFORMATION3 = X_INFORMATION3,
    INFORMATION4 = X_INFORMATION4,
    INFORMATION5 = X_INFORMATION5,
    INFORMATION22 = X_INFORMATION22,
    INFORMATION23 = X_INFORMATION23,
    INFORMATION24 = X_INFORMATION24,
    INFORMATION25 = X_INFORMATION25,
    INFORMATION26 = X_INFORMATION26,
    INFORMATION27 = X_INFORMATION27,
    INFORMATION28 = X_INFORMATION28,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
Line: 608

  update HR_TAB_PAGE_PROPERTIES_TL set
    LABEL = X_LABEL,
    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 TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID
  and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
Line: 620

end UPDATE_ROW;
Line: 622

procedure DELETE_ROW (
  X_TAB_PAGE_PROPERTY_ID in NUMBER
) is
begin
  delete from HR_TAB_PAGE_PROPERTIES_TL
  where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
Line: 633

  delete from HR_TAB_PAGE_PROPERTIES_B
  where TAB_PAGE_PROPERTY_ID = X_TAB_PAGE_PROPERTY_ID;
Line: 639

end DELETE_ROW;
Line: 644

  delete from HR_TAB_PAGE_PROPERTIES_TL T
  where not exists
    (select NULL
    from HR_TAB_PAGE_PROPERTIES_B B
    where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
    );
Line: 651

  update HR_TAB_PAGE_PROPERTIES_TL T set (
      LABEL
    ) = (select
      B.LABEL
    from HR_TAB_PAGE_PROPERTIES_TL B
    where B.TAB_PAGE_PROPERTY_ID = T.TAB_PAGE_PROPERTY_ID
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TAB_PAGE_PROPERTY_ID,
      T.LANGUAGE
  ) in (select
      SUBT.TAB_PAGE_PROPERTY_ID,
      SUBT.LANGUAGE
    from HR_TAB_PAGE_PROPERTIES_TL SUBB, HR_TAB_PAGE_PROPERTIES_TL SUBT
    where SUBB.TAB_PAGE_PROPERTY_ID = SUBT.TAB_PAGE_PROPERTY_ID
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.LABEL <> SUBT.LABEL
      or (SUBB.LABEL is null and SUBT.LABEL is not null)
      or (SUBB.LABEL is not null and SUBT.LABEL is null)
  ));
Line: 672

  insert into HR_TAB_PAGE_PROPERTIES_TL (
    TAB_PAGE_PROPERTY_ID,
    LABEL,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    LANGUAGE,
    SOURCE_LANG
  ) select
    B.TAB_PAGE_PROPERTY_ID,
    B.LABEL,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    B.CREATED_BY,
    B.CREATION_DATE,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from HR_TAB_PAGE_PROPERTIES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from HR_TAB_PAGE_PROPERTIES_TL T
    where T.TAB_PAGE_PROPERTY_ID = B.TAB_PAGE_PROPERTY_ID
    and T.LANGUAGE = L.LANGUAGE_CODE);
Line: 711

  X_LAST_UPDATE_DATE in VARCHAR2 default sysdate,
  X_CUSTOM_MODE IN VARCHAR2 default null,
  X_LABEL in VARCHAR2) is
  X_ROWID ROWID;
Line: 718

  X_LAST_UPDATED_BY NUMBER;
Line: 719

  X_LAST_UPDATE_LOGIN NUMBER;
Line: 729

  f_ludate  date;    -- entity update date in file
Line: 731

  db_ludate date;    -- entity update date in db
Line: 739

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );*/
Line: 744

 select application_id
 into x_application_id
 from fnd_application
 where application_short_name = x_application_short_name;
Line: 749

 select form_id
 into x_form_id
 from fnd_form
 where form_name = x_form_name
 and application_id = x_application_id;
Line: 756

 select hfc.form_canvas_id, hfw.form_window_id
 into x_form_canvas_id,x_form_window_id
 from hr_form_canvases_b hfc
      , hr_form_windows_b hfw
 where hfc.canvas_name = x_canvas_name
 and hfw.application_id = x_application_id
 and hfw.form_id = x_form_id
 and hfw.window_name = x_window_name;
Line: 765

 select form_tab_page_id
 into x_form_tab_page_id
 from hr_form_tab_pages_b
 where form_canvas_id = x_form_canvas_id
 and tab_page_name = x_tab_page_name;
Line: 773

 select htc.template_canvas_id
 into x_template_canvas_id
 from hr_template_canvases_b htc
      ,hr_template_windows_b htw
      , hr_form_templates hft
 where htc.form_canvas_id = x_form_canvas_id
 and htc.template_window_id = htw.template_window_id
 and htw.form_window_id = x_form_window_id
 and htw.form_template_id = hft.form_template_id
 and hft.application_id = x_application_id
 and hft.form_id = x_form_id
 and (  (hft.legislation_code is null and x_territory_short_name is null)
     or (hft.legislation_code = x_territory_short_name) )
 and hft.template_name = x_template_name;
Line: 789

 select template_tab_page_id
 into x_template_tab_page_id
 from hr_template_tab_pages
 where template_canvas_id = x_template_canvas_id
 and form_tab_page_id = x_form_tab_page_id;
Line: 802

   select tab_page_property_id
   into x_tab_page_property_id
   from hr_tab_page_properties_b
   where nvl(form_tab_page_id,hr_api.g_number) =  nvl(x_form_tab_page_id,hr_api.g_number)
   and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
Line: 812

 f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
Line: 814

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_TAB_PAGE_PROPERTIES_TL
          where tab_page_property_id = x_tab_page_property_id
          and LANGUAGE=userenv('LANG');
Line: 823

                 update HR_TAB_PAGE_PROPERTIES_TL set
                        LABEL = X_LABEL,
                        LAST_UPDATE_DATE = f_ludate,
                        LAST_UPDATED_BY = f_luby,
                        LAST_UPDATE_LOGIN = 0,
                        SOURCE_LANG = userenv('LANG')
                    where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
                    and tab_page_property_id = x_tab_page_property_id;
Line: 848

  X_LAST_UPDATE_DATE IN varchar2 default sysdate,
  X_CUSTOM_MODE IN VARCHAR2 default null,
  X_NAVIGATION_DIRECTION in VARCHAR2,
  X_VISIBLE     in VARCHAR2,
  X_INFORMATION_CATEGORY in VARCHAR2,
  X_INFORMATION1 in VARCHAR2,
  X_INFORMATION2 in VARCHAR2,
  X_INFORMATION3 in VARCHAR2,
  X_INFORMATION4 in VARCHAR2,
  X_INFORMATION5 in VARCHAR2,
  X_INFORMATION6 in VARCHAR2,
  X_INFORMATION7 in VARCHAR2,
  X_INFORMATION8 in VARCHAR2,
  X_INFORMATION9 in VARCHAR2,
  X_INFORMATION10 in VARCHAR2,
  X_INFORMATION11 in VARCHAR2,
  X_INFORMATION12 in VARCHAR2,
  X_INFORMATION13 in VARCHAR2,
  X_INFORMATION14 in VARCHAR2,
  X_INFORMATION15 in VARCHAR2,
  X_INFORMATION16 in VARCHAR2,
  X_INFORMATION17 in VARCHAR2,
  X_INFORMATION18 in VARCHAR2,
  X_INFORMATION19 in VARCHAR2,
  X_INFORMATION20 in VARCHAR2,
  X_INFORMATION21 in VARCHAR2,
  X_INFORMATION22 in VARCHAR2,
  X_INFORMATION23 in VARCHAR2,
  X_INFORMATION24 in VARCHAR2,
  X_INFORMATION25 in VARCHAR2,
  X_INFORMATION26 in VARCHAR2,
  X_INFORMATION27 in VARCHAR2,
  X_INFORMATION28 in VARCHAR2,
  X_INFORMATION29 in VARCHAR2,
  X_INFORMATION30 in VARCHAR2,
  X_LABEL in VARCHAR2) is
  X_ROWID ROWID;
Line: 888

  X_LAST_UPDATED_BY NUMBER;
Line: 889

  X_LAST_UPDATE_LOGIN NUMBER;
Line: 899

  f_ludate  date;    -- entity update date in file
Line: 901

  db_ludate date;    -- entity update date in db
Line: 908

    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );*/
Line: 918

 select application_id
 into x_application_id
 from fnd_application
 where application_short_name = x_application_short_name;
Line: 923

 select form_id
 into x_form_id
 from fnd_form
 where form_name = x_form_name
 and application_id = x_application_id;
Line: 929

 select hfc.form_canvas_id,hfw.form_window_id
 into x_form_canvas_id,x_form_window_id
 from hr_form_canvases_b hfc
      , hr_form_windows_b hfw
 where hfc.canvas_name = x_canvas_name
 and hfw.application_id = x_application_id
 and hfw.form_id = x_form_id
 and hfw.window_name = x_window_name;
Line: 938

 select form_tab_page_id
 into x_form_tab_page_id
 from hr_form_tab_pages_b
 where form_canvas_id = x_form_canvas_id
 and tab_page_name = x_tab_page_name;
Line: 946

 select htc.template_canvas_id
 into x_template_canvas_id
 from hr_template_canvases_b htc
      ,hr_template_windows_b htw
      , hr_form_templates hft
 where htc.form_canvas_id = x_form_canvas_id
 and htc.template_window_id = htw.template_window_id
 and htw.form_window_id = x_form_window_id
 and htw.form_template_id = hft.form_template_id
 and hft.application_id = x_application_id
 and hft.form_id = x_form_id
 and (  (hft.legislation_code is null and x_territory_short_name is null)
     or (hft.legislation_code = x_territory_short_name) )
 and hft.template_name = x_template_name;
Line: 961

 select template_tab_page_id
 into x_template_tab_page_id
 from hr_template_tab_pages
 where template_canvas_id = x_template_canvas_id
 and form_tab_page_id = x_form_tab_page_id;
Line: 974

   select tab_page_property_id
   into x_tab_page_property_id
   from hr_tab_page_properties_b
   where nvl(form_tab_page_id,hr_api.g_number) =  nvl(x_form_tab_page_id,hr_api.g_number)
   and nvl(template_tab_page_id,hr_api.g_number) = nvl(x_template_tab_page_id,hr_api.g_number);
Line: 981

     select hr_tab_page_properties_b_s.nextval
     into x_tab_page_property_id
     from dual;
Line: 990

 f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
Line: 992

          select LAST_UPDATED_BY, LAST_UPDATE_DATE
          into db_luby, db_ludate
          from HR_TAB_PAGE_PROPERTIES_TL
          where tab_page_property_id = x_tab_page_property_id
          and LANGUAGE=userenv('LANG');
Line: 1000

  UPDATE_COPIES (
    X_TAB_PAGE_PROPERTY_ID,
    X_FORM_TAB_PAGE_ID,
    X_TEMPLATE_TAB_PAGE_ID,
    X_NAVIGATION_DIRECTION,
    X_VISIBLE,
    X_LABEL,
    X_INFORMATION_CATEGORY,
    X_INFORMATION1,
    X_INFORMATION2,
    X_INFORMATION3,
    X_INFORMATION4,
    X_INFORMATION5,
    X_INFORMATION6,
    X_INFORMATION7,
    X_INFORMATION8,
    X_INFORMATION9,
    X_INFORMATION10,
    X_INFORMATION11,
    X_INFORMATION12,
    X_INFORMATION13,
    X_INFORMATION14,
    X_INFORMATION15,
    X_INFORMATION16,
    X_INFORMATION17,
    X_INFORMATION18,
    X_INFORMATION19,
    X_INFORMATION20,
    X_INFORMATION21,
    X_INFORMATION22,
    X_INFORMATION23,
    X_INFORMATION24,
    X_INFORMATION25,
    X_INFORMATION26,
    X_INFORMATION27,
    X_INFORMATION28,
    X_INFORMATION29,
    X_INFORMATION30,
    f_ludate,
    f_luby,
    0
    );
Line: 1043

   UPDATE_ROW (
     X_TAB_PAGE_PROPERTY_ID,
     X_FORM_TAB_PAGE_ID,
     X_TEMPLATE_TAB_PAGE_ID,
     X_NAVIGATION_DIRECTION,
     to_number(X_VISIBLE),
     X_INFORMATION_CATEGORY,
     X_INFORMATION9,
     X_INFORMATION10,
     X_INFORMATION11,
     X_INFORMATION12,
     X_INFORMATION13,
     X_INFORMATION14,
     X_INFORMATION15,
     X_INFORMATION16,
     X_INFORMATION17,
     X_INFORMATION18,
     X_INFORMATION19,
     X_INFORMATION20,
     X_INFORMATION21,
     X_INFORMATION7,
     X_INFORMATION8,
     X_INFORMATION29,
     X_INFORMATION30,
     X_INFORMATION6,
     X_INFORMATION1,
     X_INFORMATION2,
     X_INFORMATION3,
     X_INFORMATION4,
     X_INFORMATION5,
     X_INFORMATION22,
     X_INFORMATION23,
     X_INFORMATION24,
     X_INFORMATION25,
     X_INFORMATION26,
     X_INFORMATION27,
     X_INFORMATION28,
     X_LABEL,
     f_ludate,
     f_luby,
     0);
Line: 1087

     INSERT_ROW (
       X_ROWID,
       X_TAB_PAGE_PROPERTY_ID,
       X_FORM_TAB_PAGE_ID,
       X_TEMPLATE_TAB_PAGE_ID,
       X_NAVIGATION_DIRECTION,
       to_number(X_VISIBLE),
       X_INFORMATION_CATEGORY,
       X_INFORMATION9,
       X_INFORMATION10,
       X_INFORMATION11,
       X_INFORMATION12,
       X_INFORMATION13,
       X_INFORMATION14,
       X_INFORMATION15,
       X_INFORMATION16,
       X_INFORMATION17,
       X_INFORMATION18,
       X_INFORMATION19,
       X_INFORMATION20,
       X_INFORMATION21,
       X_INFORMATION7,
       X_INFORMATION8,
       X_INFORMATION29,
       X_INFORMATION30,
       X_INFORMATION6,
       X_INFORMATION1,
       X_INFORMATION2,
       X_INFORMATION3,
       X_INFORMATION4,
       X_INFORMATION5,
       X_INFORMATION22,
       X_INFORMATION23,
       X_INFORMATION24,
       X_INFORMATION25,
       X_INFORMATION26,
       X_INFORMATION27,
       X_INFORMATION28,
       X_LABEL,
       X_CREATION_DATE,
       X_CREATED_BY,
       f_ludate,
       f_luby,
       0);