eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_TCP_PKG SQL Statements

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

Line: 7


  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: 14


    X_LAST_UPDATED_BY := 1;

Line: 17


    X_LAST_UPDATED_BY := 0;

Line: 20


  X_LAST_UPDATE_DATE := sysdate;

Line: 21


  X_LAST_UPDATE_LOGIN := 0;

Line: 23


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_TEMPLATE_ITEM_CONTEXT_ID in NUMBER,
  X_TEMPLATE_ITEM_CONTEXT_PAGE_I in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_TEMPLATE_TAB_PAGE_ID in NUMBER,
  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_TEMPLATE_ITEM_CONTEXT_PAGES
    where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
    ;

Line: 39


  insert into HR_TEMPLATE_ITEM_CONTEXT_PAGES (
    CREATION_DATE,
    TEMPLATE_ITEM_CONTEXT_PAGE_ID,
    OBJECT_VERSION_NUMBER,
    TEMPLATE_ITEM_CONTEXT_ID,
    TEMPLATE_TAB_PAGE_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY
  ) values(
    X_CREATION_DATE,
    X_TEMPLATE_ITEM_CONTEXT_PAGE_I,
    X_OBJECT_VERSION_NUMBER,
    X_TEMPLATE_ITEM_CONTEXT_ID,
    X_TEMPLATE_TAB_PAGE_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY);

Line: 68


end INSERT_ROW;

Line: 76


  cursor c1 is select
      TEMPLATE_ITEM_CONTEXT_PAGE_ID,
      OBJECT_VERSION_NUMBER,
      TEMPLATE_TAB_PAGE_ID
    from HR_TEMPLATE_ITEM_CONTEXT_PAGES
    where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
    for update of TEMPLATE_ITEM_CONTEXT_ID nowait;

Line: 98


procedure UPDATE_ROW (
  X_TEMPLATE_ITEM_CONTEXT_ID in NUMBER,
  X_TEMPLATE_ITEM_CONTEXT_PAGE_I in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_TEMPLATE_TAB_PAGE_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_TEMPLATE_ITEM_CONTEXT_PAGES set
    TEMPLATE_ITEM_CONTEXT_PAGE_ID = X_TEMPLATE_ITEM_CONTEXT_PAGE_I,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID;

Line: 120


end UPDATE_ROW;

Line: 122


procedure DELETE_ROW (
  X_TEMPLATE_ITEM_CONTEXT_ID in NUMBER
) is
begin
  delete from HR_TEMPLATE_ITEM_CONTEXT_PAGES
  where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID;

Line: 133


end DELETE_ROW;

Line: 182


  X_LAST_UPDATE_DATE DATE;

Line: 183


  X_LAST_UPDATED_BY NUMBER;

Line: 184


  X_LAST_UPDATE_LOGIN NUMBER;

Line: 205


    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 211


 merged the following 3 SELECT into one, after this commented section

 select application_id
 into x_application_id
 from fnd_application
 where application_short_name = x_application_short_name;

Line: 218


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

Line: 224


 select form_item_id
 into x_form_item_id
 from hr_form_items_b
 where full_item_name = x_full_item_name
 and application_id = x_application_id
 and form_id = x_form_id
 and (  radio_button_name = x_radio_button_name
     or (radio_button_name is null and x_radio_button_name is null) );

Line: 234


select a.application_id,
       f.form_id,
       fi.form_item_id
into   x_application_id,
       x_form_id,
       x_form_item_id
from   fnd_application a,
       fnd_form f,
       hr_form_items_b fi
 where a.application_short_name = x_application_short_name
 and   f.form_name = x_form_name
 and   f.application_id = a.application_id
 and   fi.full_item_name = x_full_item_name
 and   fi.application_id = f.application_id
 and   fi.form_id = f.form_id
 and  (fi.radio_button_name = x_radio_button_name
 or   (fi.radio_button_name is null and x_radio_button_name is null));

Line: 253


 select hti.template_item_id
 into x_template_item_id
 from hr_form_templates_b hft
      ,hr_template_items_b hti
 where hti.form_item_id = x_form_item_id
 and hti.form_template_id = hft.form_template_id
 and hft.form_id = x_form_id
 and hft.application_id = x_application_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: 265


 select item_context_id
 into x_item_context_id
 from hr_item_contexts hic
      ,fnd_id_flex_structures fifs
 where nvl(hic.segment1,hr_api.g_varchar2) = nvl(x_segment1,hr_api.g_varchar2)
 and nvl(hic.segment2,hr_api.g_varchar2) = nvl(x_segment2,hr_api.g_varchar2)
 and nvl(hic.segment3,hr_api.g_varchar2) = nvl(x_segment3,hr_api.g_varchar2)
 and nvl(hic.segment4,hr_api.g_varchar2) = nvl(x_segment4,hr_api.g_varchar2)
 and nvl(hic.segment5,hr_api.g_varchar2) = nvl(x_segment5,hr_api.g_varchar2)
 and nvl(hic.segment6,hr_api.g_varchar2) = nvl(x_segment6,hr_api.g_varchar2)
 and nvl(hic.segment7,hr_api.g_varchar2) = nvl(x_segment7,hr_api.g_varchar2)
 and nvl(hic.segment8,hr_api.g_varchar2) = nvl(x_segment8,hr_api.g_varchar2)
 and nvl(hic.segment9,hr_api.g_varchar2) = nvl(x_segment9,hr_api.g_varchar2)
 and nvl(hic.segment10,hr_api.g_varchar2) = nvl(x_segment10,hr_api.g_varchar2)
 and nvl(hic.segment11,hr_api.g_varchar2) = nvl(x_segment11,hr_api.g_varchar2)
 and nvl(hic.segment12,hr_api.g_varchar2) = nvl(x_segment12,hr_api.g_varchar2)
 and nvl(hic.segment13,hr_api.g_varchar2) = nvl(x_segment13,hr_api.g_varchar2)
 and nvl(hic.segment14,hr_api.g_varchar2) = nvl(x_segment14,hr_api.g_varchar2)
 and nvl(hic.segment15,hr_api.g_varchar2) = nvl(x_segment15,hr_api.g_varchar2)
 and nvl(hic.segment16,hr_api.g_varchar2) = nvl(x_segment16,hr_api.g_varchar2)
 and nvl(hic.segment17,hr_api.g_varchar2) = nvl(x_segment17,hr_api.g_varchar2)
 and nvl(hic.segment18,hr_api.g_varchar2) = nvl(x_segment18,hr_api.g_varchar2)
 and nvl(hic.segment19,hr_api.g_varchar2) = nvl(x_segment19,hr_api.g_varchar2)
 and nvl(hic.segment20,hr_api.g_varchar2) = nvl(x_segment20,hr_api.g_varchar2)
 and nvl(hic.segment21,hr_api.g_varchar2) = nvl(x_segment21,hr_api.g_varchar2)
 and nvl(hic.segment22,hr_api.g_varchar2) = nvl(x_segment22,hr_api.g_varchar2)
 and nvl(hic.segment23,hr_api.g_varchar2) = nvl(x_segment23,hr_api.g_varchar2)
 and nvl(hic.segment24,hr_api.g_varchar2) = nvl(x_segment24,hr_api.g_varchar2)
 and nvl(hic.segment25,hr_api.g_varchar2) = nvl(x_segment25,hr_api.g_varchar2)
 and nvl(hic.segment26,hr_api.g_varchar2) = nvl(x_segment26,hr_api.g_varchar2)
 and nvl(hic.segment27,hr_api.g_varchar2) = nvl(x_segment27,hr_api.g_varchar2)
 and nvl(hic.segment28,hr_api.g_varchar2) = nvl(x_segment28,hr_api.g_varchar2)
 and nvl(hic.segment29,hr_api.g_varchar2) = nvl(x_segment29,hr_api.g_varchar2)
 and nvl(hic.segment30,hr_api.g_varchar2) = nvl(x_segment30,hr_api.g_varchar2)
 and hic.id_flex_num = fifs.id_flex_num
 and fifs.application_id = x_application_id
 and fifs.id_flex_structure_code = x_id_flex_structure_code
 and fifs.id_flex_code = x_id_flex_code;

Line: 304


 select template_item_context_id
 into x_template_item_context_id
 from hr_template_item_contexts_b ticb
 where ticb.template_item_id = x_template_item_id
 and ticb.context_type = x_context_type
 and ticb.item_context_id = x_item_context_id;

Line: 312


 merged the following 7 SELECT into one, after this commented section

 select form_window_id
 into x_form_window_id
 from hr_form_windows_b
 where window_name =  x_window_name
 and application_id = x_application_id
 and form_id = x_form_id;

Line: 321


 select form_template_id
 into x_form_template_id
 from hr_form_templates_b
 where (  (legislation_code is null and x_territory_short_name is null)
       or (legislation_code = x_territory_short_name) )
 and template_name =  x_template_name
 and application_id = x_application_id
 and form_id = x_form_id;

Line: 330


 select template_window_id
 into x_template_window_id
 from hr_template_windows_b
 where form_template_id = x_form_template_id
 and form_window_id = x_form_window_id;

Line: 336


 select form_canvas_id
 into x_form_canvas_id
 from hr_form_canvases_b
 where canvas_name = x_canvas_name
 and form_window_id = x_form_window_id;

Line: 342


 select template_canvas_id
 into x_template_canvas_id
 from hr_template_canvases_b
 where form_canvas_id = x_form_canvas_id
 and template_window_id = x_template_window_id;

Line: 348


 select form_tab_page_id
 into x_form_tab_page_id
 from hr_form_tab_pages_b
 where tab_page_name = x_form_tab_page_name
 and form_canvas_id = x_form_canvas_id;

Line: 354


 select template_tab_page_id
 into x_template_tab_page_id
 from hr_template_tab_pages_b
 where template_canvas_id = x_template_canvas_id
 and form_tab_page_id = x_form_tab_page_id;

Line: 361


 select  hfw.form_window_id,
         hft.form_template_id,
         htw.template_window_id,
         hfc.form_canvas_id,
         htc.template_canvas_id,
         hftp.form_tab_page_id,
         htpb.template_tab_page_id
 into    x_form_window_id,
         x_form_template_id,
         x_template_window_id,
         x_form_canvas_id,
         x_template_canvas_id,
         x_form_tab_page_id,
         x_template_tab_page_id
 from    hr_form_windows_b hfw,
         hr_form_templates_b hft,
         hr_template_windows_b htw,
         hr_form_canvases_b hfc,
         hr_template_canvases_b htc,
         hr_form_tab_pages_b hftp,
         hr_template_tab_pages_b htpb
 where   hfw.window_name =  x_window_name
 and     hfw.application_id = x_application_id
 and     hfw.form_id = x_form_id
 and     hft.application_id = hfw.application_id
 and     hft.form_id = hfw.form_id
 and     hft.template_name =  x_template_name
 and   ((hft.legislation_code = x_territory_short_name)
 or     (hft.legislation_code is null and x_territory_short_name is null))
 and     htw.form_template_id = hft.form_template_id
 and     htw.form_window_id = hfw.form_window_id
 and     hfc.canvas_name = x_canvas_name
 and     hfc.form_window_id = hfw.form_window_id
 and     htc.form_canvas_id = hfc.form_canvas_id
 and     htc.template_window_id = htw.template_window_id
 and     hftp.tab_page_name = x_form_tab_page_name
 and     hftp.form_canvas_id = htc.form_canvas_id
 and     htpb.template_canvas_id = htc.template_canvas_id
 and     htpb.form_tab_page_id = hftp.form_tab_page_id;

Line: 403


  select template_item_context_page_id
  into x_tcp_id
  from hr_template_item_context_pages
  where template_tab_page_id = x_template_tab_page_id
  and template_item_context_id = x_template_item_context_id;

Line: 409


    update HR_TEMPLATE_ITEM_CONTEXT_PAGES
    set    TEMPLATE_ITEM_CONTEXT_PAGE_ID = x_tcp_id,
	   OBJECT_VERSION_NUMBER = TO_NUMBER (x_object_version_number),
	   TEMPLATE_TAB_PAGE_ID = X_TEMPLATE_TAB_PAGE_ID,
	   LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	   LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	   LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where  TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID;

Line: 420


    insert into HR_TEMPLATE_ITEM_CONTEXT_PAGES (
    CREATION_DATE,
    TEMPLATE_ITEM_CONTEXT_PAGE_ID,
    OBJECT_VERSION_NUMBER,
    TEMPLATE_ITEM_CONTEXT_ID,
    TEMPLATE_TAB_PAGE_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY)
    values(
    X_CREATION_DATE,
    hr_tcp_s.nextval,
    TO_NUMBER(x_object_version_number),
    X_TEMPLATE_ITEM_CONTEXT_ID,
    X_TEMPLATE_TAB_PAGE_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY);

Line: 446


   UPDATE_ROW (
     X_TEMPLATE_ITEM_CONTEXT_ID,
     X_TCP_ID,
     to_number(X_OBJECT_VERSION_NUMBER),
     X_TEMPLATE_TAB_PAGE_ID,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_LOGIN
   );

Line: 457


     INSERT_ROW (
       X_ROWID,
       X_TEMPLATE_ITEM_CONTEXT_ID,
       X_TCP_ID,
       to_number(X_OBJECT_VERSION_NUMBER),
       X_TEMPLATE_TAB_PAGE_ID,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN );