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_TEMPLATE_ITEM_CONTEXTS_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_OBJECT_VERSION_NUMBER in NUMBER,
  X_TEMPLATE_ITEM_ID in NUMBER,
  X_CONTEXT_TYPE in VARCHAR2,
  X_ITEM_CONTEXT_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_CONTEXTS_B
    where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
    ;

Line: 40


  insert into HR_TEMPLATE_ITEM_CONTEXTS_B (
    TEMPLATE_ITEM_CONTEXT_ID,
    OBJECT_VERSION_NUMBER,
    TEMPLATE_ITEM_ID,
    CONTEXT_TYPE,
    ITEM_CONTEXT_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE
  ) values(
    X_TEMPLATE_ITEM_CONTEXT_ID,
    X_OBJECT_VERSION_NUMBER,
    X_TEMPLATE_ITEM_ID,
    X_CONTEXT_TYPE,
    X_ITEM_CONTEXT_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY,
    X_CREATION_DATE);

Line: 71


end INSERT_ROW;

Line: 80


  cursor c1 is select
      OBJECT_VERSION_NUMBER,
      TEMPLATE_ITEM_ID,
      CONTEXT_TYPE,
      ITEM_CONTEXT_ID
    from HR_TEMPLATE_ITEM_CONTEXTS_B
    where TEMPLATE_ITEM_CONTEXT_ID = X_TEMPLATE_ITEM_CONTEXT_ID
    for update of TEMPLATE_ITEM_CONTEXT_ID nowait;

Line: 104


procedure UPDATE_ROW (
  X_TEMPLATE_ITEM_CONTEXT_ID in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_TEMPLATE_ITEM_ID in NUMBER,
  X_CONTEXT_TYPE in VARCHAR2,
  X_ITEM_CONTEXT_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_CONTEXTS_B set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    TEMPLATE_ITEM_ID = X_TEMPLATE_ITEM_ID,
    CONTEXT_TYPE = X_CONTEXT_TYPE,
    ITEM_CONTEXT_ID = X_ITEM_CONTEXT_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: 128


end UPDATE_ROW;

Line: 130


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

Line: 141


end DELETE_ROW;

Line: 188


  X_LAST_UPDATE_DATE DATE;

Line: 189


  X_LAST_UPDATED_BY NUMBER;

Line: 190


  X_LAST_UPDATE_LOGIN NUMBER;

Line: 203


    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 208


 select application_id
 into x_application_id
 from fnd_application
 where application_short_name = x_application_short_name;

Line: 213


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

Line: 219


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


 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 (  (legislation_code is null and x_territory_short_name is null)
     or (legislation_code = x_territory_short_name) )
 and hft.template_name = x_template_name;

Line: 240


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


  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.item_context_id = x_item_context_id;

Line: 287


     select hr_template_item_contexts_b_s.nextval
     into x_template_item_context_id
     from dual;

Line: 293


   UPDATE_ROW (
     X_TEMPLATE_ITEM_CONTEXT_ID,
     to_number(X_OBJECT_VERSION_NUMBER),
     X_TEMPLATE_ITEM_ID,
     X_CONTEXT_TYPE,
     X_ITEM_CONTEXT_ID,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_LOGIN
   );

Line: 306


     INSERT_ROW (
       X_ROWID,
       X_TEMPLATE_ITEM_CONTEXT_ID,
       to_number(X_OBJECT_VERSION_NUMBER),
       X_TEMPLATE_ITEM_ID,
       X_CONTEXT_TYPE,
       X_ITEM_CONTEXT_ID,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN);