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_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_ITEM_CONTEXT_ID in NUMBER,
  X_SEGMENT1 in VARCHAR2,
  X_SEGMENT2 in VARCHAR2,
  X_SEGMENT3 in VARCHAR2,
  X_SEGMENT4 in VARCHAR2,
  X_SEGMENT5 in VARCHAR2,
  X_SEGMENT6 in VARCHAR2,
  X_SEGMENT7 in VARCHAR2,
  X_SEGMENT8 in VARCHAR2,
  X_SEGMENT9 in VARCHAR2,
  X_SEGMENT10 in VARCHAR2,
  X_SEGMENT11 in VARCHAR2,
  X_SEGMENT12 in VARCHAR2,
  X_SEGMENT13 in VARCHAR2,
  X_SEGMENT14 in VARCHAR2,
  X_SEGMENT15 in VARCHAR2,
  X_SEGMENT16 in VARCHAR2,
  X_SEGMENT17 in VARCHAR2,
  X_SEGMENT18 in VARCHAR2,
  X_SEGMENT19 in VARCHAR2,
  X_SEGMENT20 in VARCHAR2,
  X_SEGMENT21 in VARCHAR2,
  X_SEGMENT22 in VARCHAR2,
  X_SEGMENT23 in VARCHAR2,
  X_SEGMENT24 in VARCHAR2,
  X_SEGMENT25 in VARCHAR2,
  X_SEGMENT26 in VARCHAR2,
  X_SEGMENT27 in VARCHAR2,
  X_SUMMARY_FLAG in VARCHAR2,
  X_ID_FLEX_NUM in NUMBER,
  X_END_DATE_ACTIVE in DATE,
  X_SEGMENT28 in VARCHAR2,
  X_SEGMENT29 in VARCHAR2,
  X_SEGMENT30 in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_ENABLED_FLAG 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_ITEM_CONTEXTS
    where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID
    ;

Line: 71


  insert into HR_ITEM_CONTEXTS (
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    SEGMENT1,
    SEGMENT2,
    SEGMENT3,
    SEGMENT4,
    SEGMENT5,
    SEGMENT6,
    SEGMENT7,
    SEGMENT8,
    SEGMENT9,
    SEGMENT10,
    SEGMENT11,
    SEGMENT12,
    SEGMENT13,
    SEGMENT14,
    SEGMENT15,
    SEGMENT16,
    SEGMENT17,
    SEGMENT18,
    SEGMENT19,
    SEGMENT20,
    SEGMENT21,
    SEGMENT22,
    SEGMENT23,
    SEGMENT24,
    SEGMENT25,
    SEGMENT26,
    SEGMENT27,
    SUMMARY_FLAG,
    ITEM_CONTEXT_ID,
    ID_FLEX_NUM,
    END_DATE_ACTIVE,
    SEGMENT28,
    SEGMENT29,
    SEGMENT30,
    LAST_UPDATE_DATE,
    START_DATE_ACTIVE,
    ENABLED_FLAG
  ) values(
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_SEGMENT1,
    X_SEGMENT2,
    X_SEGMENT3,
    X_SEGMENT4,
    X_SEGMENT5,
    X_SEGMENT6,
    X_SEGMENT7,
    X_SEGMENT8,
    X_SEGMENT9,
    X_SEGMENT10,
    X_SEGMENT11,
    X_SEGMENT12,
    X_SEGMENT13,
    X_SEGMENT14,
    X_SEGMENT15,
    X_SEGMENT16,
    X_SEGMENT17,
    X_SEGMENT18,
    X_SEGMENT19,
    X_SEGMENT20,
    X_SEGMENT21,
    X_SEGMENT22,
    X_SEGMENT23,
    X_SEGMENT24,
    X_SEGMENT25,
    X_SEGMENT26,
    X_SEGMENT27,
    X_SUMMARY_FLAG,
    X_ITEM_CONTEXT_ID,
    X_ID_FLEX_NUM,
    X_END_DATE_ACTIVE,
    X_SEGMENT28,
    X_SEGMENT29,
    X_SEGMENT30,
    X_LAST_UPDATE_DATE,
    X_START_DATE_ACTIVE,
    X_ENABLED_FLAG);

Line: 164


end INSERT_ROW;

Line: 204


  cursor c1 is select
      SEGMENT1,
      SEGMENT2,
      SEGMENT3,
      SEGMENT4,
      SEGMENT5,
      SEGMENT6,
      SEGMENT7,
      SEGMENT8,
      SEGMENT9,
      SEGMENT10,
      SEGMENT11,
      SEGMENT12,
      SEGMENT13,
      SEGMENT14,
      SEGMENT15,
      SEGMENT16,
      SEGMENT17,
      SEGMENT18,
      SEGMENT19,
      SEGMENT20,
      SEGMENT21,
      SEGMENT22,
      SEGMENT23,
      SEGMENT24,
      SEGMENT25,
      SEGMENT26,
      SEGMENT27,
      SUMMARY_FLAG,
      ID_FLEX_NUM,
      END_DATE_ACTIVE,
      SEGMENT28,
      SEGMENT29,
      SEGMENT30,
      START_DATE_ACTIVE,
      ENABLED_FLAG
    from HR_ITEM_CONTEXTS
    where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID
    for update of ITEM_CONTEXT_ID nowait;

Line: 322


procedure UPDATE_ROW (
  X_ITEM_CONTEXT_ID in NUMBER,
  X_SEGMENT1 in VARCHAR2,
  X_SEGMENT2 in VARCHAR2,
  X_SEGMENT3 in VARCHAR2,
  X_SEGMENT4 in VARCHAR2,
  X_SEGMENT5 in VARCHAR2,
  X_SEGMENT6 in VARCHAR2,
  X_SEGMENT7 in VARCHAR2,
  X_SEGMENT8 in VARCHAR2,
  X_SEGMENT9 in VARCHAR2,
  X_SEGMENT10 in VARCHAR2,
  X_SEGMENT11 in VARCHAR2,
  X_SEGMENT12 in VARCHAR2,
  X_SEGMENT13 in VARCHAR2,
  X_SEGMENT14 in VARCHAR2,
  X_SEGMENT15 in VARCHAR2,
  X_SEGMENT16 in VARCHAR2,
  X_SEGMENT17 in VARCHAR2,
  X_SEGMENT18 in VARCHAR2,
  X_SEGMENT19 in VARCHAR2,
  X_SEGMENT20 in VARCHAR2,
  X_SEGMENT21 in VARCHAR2,
  X_SEGMENT22 in VARCHAR2,
  X_SEGMENT23 in VARCHAR2,
  X_SEGMENT24 in VARCHAR2,
  X_SEGMENT25 in VARCHAR2,
  X_SEGMENT26 in VARCHAR2,
  X_SEGMENT27 in VARCHAR2,
  X_SUMMARY_FLAG in VARCHAR2,
  X_ID_FLEX_NUM in NUMBER,
  X_END_DATE_ACTIVE in DATE,
  X_SEGMENT28 in VARCHAR2,
  X_SEGMENT29 in VARCHAR2,
  X_SEGMENT30 in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_ENABLED_FLAG in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_ITEM_CONTEXTS set
    SEGMENT1 = X_SEGMENT1,
    SEGMENT2 = X_SEGMENT2,
    SEGMENT3 = X_SEGMENT3,
    SEGMENT4 = X_SEGMENT4,
    SEGMENT5 = X_SEGMENT5,
    SEGMENT6 = X_SEGMENT6,
    SEGMENT7 = X_SEGMENT7,
    SEGMENT8 = X_SEGMENT8,
    SEGMENT9 = X_SEGMENT9,
    SEGMENT10 = X_SEGMENT10,
    SEGMENT11 = X_SEGMENT11,
    SEGMENT12 = X_SEGMENT12,
    SEGMENT13 = X_SEGMENT13,
    SEGMENT14 = X_SEGMENT14,
    SEGMENT15 = X_SEGMENT15,
    SEGMENT16 = X_SEGMENT16,
    SEGMENT17 = X_SEGMENT17,
    SEGMENT18 = X_SEGMENT18,
    SEGMENT19 = X_SEGMENT19,
    SEGMENT20 = X_SEGMENT20,
    SEGMENT21 = X_SEGMENT21,
    SEGMENT22 = X_SEGMENT22,
    SEGMENT23 = X_SEGMENT23,
    SEGMENT24 = X_SEGMENT24,
    SEGMENT25 = X_SEGMENT25,
    SEGMENT26 = X_SEGMENT26,
    SEGMENT27 = X_SEGMENT27,
    SUMMARY_FLAG = X_SUMMARY_FLAG,
    ID_FLEX_NUM = X_ID_FLEX_NUM,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    SEGMENT28 = X_SEGMENT28,
    SEGMENT29 = X_SEGMENT29,
    SEGMENT30 = X_SEGMENT30,
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    ENABLED_FLAG = X_ENABLED_FLAG,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID;

Line: 408


end UPDATE_ROW;

Line: 410


procedure DELETE_ROW (
  X_ITEM_CONTEXT_ID in NUMBER
) is
begin
  delete from HR_ITEM_CONTEXTS
  where ITEM_CONTEXT_ID = X_ITEM_CONTEXT_ID;

Line: 421


end DELETE_ROW;

Line: 465


  X_LAST_UPDATE_DATE DATE;

Line: 466


  X_LAST_UPDATED_BY NUMBER;

Line: 467


  X_LAST_UPDATE_LOGIN NUMBER;

Line: 476


    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 481


 select application_id
 into x_application_id
 from fnd_application
 where application_short_name = x_application_short_name;

Line: 486


 select id_flex_num
 into x_id_flex_num
 from fnd_id_flex_structures fifs
 where 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: 495


 select item_context_id
 into x_item_context_id
 from hr_item_contexts hic
 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 = x_id_flex_num;

Line: 532


     select hr_item_contexts_s.nextval
     into x_item_context_id
     from dual;

Line: 538


   UPDATE_ROW (
     X_ITEM_CONTEXT_ID,
     X_SEGMENT1,
     X_SEGMENT2,
     X_SEGMENT3,
     X_SEGMENT4,
     X_SEGMENT5,
     X_SEGMENT6,
     X_SEGMENT7,
     X_SEGMENT8,
     X_SEGMENT9,
     X_SEGMENT10,
     X_SEGMENT11,
     X_SEGMENT12,
     X_SEGMENT13,
     X_SEGMENT14,
     X_SEGMENT15,
     X_SEGMENT16,
     X_SEGMENT17,
     X_SEGMENT18,
     X_SEGMENT19,
     X_SEGMENT20,
     X_SEGMENT21,
     X_SEGMENT22,
     X_SEGMENT23,
     X_SEGMENT24,
     X_SEGMENT25,
     X_SEGMENT26,
     X_SEGMENT27,
     X_SUMMARY_FLAG,
     X_ID_FLEX_NUM,
     to_date(X_END_DATE_ACTIVE,'DD/MM/YYYY'),
     X_SEGMENT28,
     X_SEGMENT29,
     X_SEGMENT30,
     to_date(X_START_DATE_ACTIVE,'DD/MM/YYYY'),
     X_ENABLED_FLAG,
     X_LAST_UPDATE_DATE,
     X_LAST_UPDATED_BY,
     X_LAST_UPDATE_LOGIN
   );

Line: 582


     INSERT_ROW (
       X_ROWID,
       X_ITEM_CONTEXT_ID,
       X_SEGMENT1,
       X_SEGMENT2,
       X_SEGMENT3,
       X_SEGMENT4,
       X_SEGMENT5,
       X_SEGMENT6,
       X_SEGMENT7,
       X_SEGMENT8,
       X_SEGMENT9,
       X_SEGMENT10,
       X_SEGMENT11,
       X_SEGMENT12,
       X_SEGMENT13,
       X_SEGMENT14,
       X_SEGMENT15,
       X_SEGMENT16,
       X_SEGMENT17,
       X_SEGMENT18,
       X_SEGMENT19,
       X_SEGMENT20,
       X_SEGMENT21,
       X_SEGMENT22,
       X_SEGMENT23,
       X_SEGMENT24,
       X_SEGMENT25,
       X_SEGMENT26,
       X_SEGMENT27,
       X_SUMMARY_FLAG,
       X_ID_FLEX_NUM,
       to_date(X_END_DATE_ACTIVE,'DD/MM/YYYY'),
       X_SEGMENT28,
       X_SEGMENT29,
       X_SEGMENT30,
       to_date(X_START_DATE_ACTIVE,'DD/MM/YYYY'),
       X_ENABLED_FLAG,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN);