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_FORM_PROPERTIES_PKG SQL Statements

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

Line: 6


procedure UPDATE_COPIES (
  X_FORM_PROPERTY_ID in NUMBER,
  X_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_FORM_TEMPLATE_ID in NUMBER,
  X_HELP_TARGET 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_FORM_PROPERTIES
     where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;

Line: 53


    select fmp.form_property_id
      from HR_FORM_PROPERTIES fmp
     where fmp.FORM_TEMPLATE_ID in (select sft.FORM_TEMPLATE_ID_TO
                                      from HR_SOURCE_FORM_TEMPLATES sft
                                start with sft.FORM_TEMPLATE_ID_FROM = X_FORM_TEMPLATE_ID
                                connect by sft.FORM_TEMPLATE_ID_FROM = prior sft.FORM_TEMPLATE_ID_TO);

Line: 66


        update HR_FORM_PROPERTIES set
          HELP_TARGET = decode(nvl(HELP_TARGET,hr_api.g_varchar2),nvl(l_original.HELP_TARGET,hr_api.g_varchar2),X_HELP_TARGET,HELP_TARGET),
          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 FORM_PROPERTY_ID = l_copy.FORM_PROPERTY_ID;

Line: 111


end UPDATE_COPIES;

Line: 117


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


    X_LAST_UPDATED_BY := 1;

Line: 127


    X_LAST_UPDATED_BY := 0;

Line: 130


  X_LAST_UPDATE_DATE := sysdate;

Line: 131


  X_LAST_UPDATE_LOGIN := 0;

Line: 134


procedure INSERT_ROW (
  X_ROWID in out nocopy VARCHAR2,
  X_FORM_PROPERTY_ID in NUMBER,
  X_INFORMATION29 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_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_FORM_TEMPLATE_ID in NUMBER,
  X_HELP_TARGET 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_INFORMATION30 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_FORM_PROPERTIES
    where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID
    ;

Line: 182


  insert into HR_FORM_PROPERTIES (
    INFORMATION30,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    CREATED_BY,
    CREATION_DATE,
    INFORMATION29,
    INFORMATION16,
    INFORMATION17,
    INFORMATION18,
    INFORMATION19,
    INFORMATION20,
    INFORMATION21,
    INFORMATION22,
    INFORMATION23,
    INFORMATION24,
    INFORMATION25,
    INFORMATION26,
    INFORMATION27,
    INFORMATION28,
    FORM_PROPERTY_ID,
    APPLICATION_ID,
    FORM_ID,
    FORM_TEMPLATE_ID,
    HELP_TARGET,
    INFORMATION_CATEGORY,
    INFORMATION1,
    INFORMATION2,
    INFORMATION3,
    INFORMATION4,
    INFORMATION5,
    INFORMATION6,
    INFORMATION7,
    INFORMATION8,
    INFORMATION9,
    INFORMATION10,
    INFORMATION11,
    INFORMATION12,
    INFORMATION13,
    INFORMATION14,
    INFORMATION15
  )
    VALUES( X_INFORMATION30,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_INFORMATION29,
    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_FORM_PROPERTY_ID,
    X_APPLICATION_ID,
    X_FORM_ID,
    X_FORM_TEMPLATE_ID,
    X_HELP_TARGET,
    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);

Line: 275


end INSERT_ROW;

Line: 315


  cursor c1 is select
      INFORMATION29,
      INFORMATION16,
      INFORMATION17,
      INFORMATION18,
      INFORMATION19,
      INFORMATION20,
      INFORMATION21,
      INFORMATION22,
      INFORMATION23,
      INFORMATION24,
      INFORMATION25,
      INFORMATION26,
      INFORMATION27,
      INFORMATION28,
      APPLICATION_ID,
      FORM_ID,
      FORM_TEMPLATE_ID,
      HELP_TARGET,
      INFORMATION_CATEGORY,
      INFORMATION1,
      INFORMATION2,
      INFORMATION3,
      INFORMATION4,
      INFORMATION5,
      INFORMATION6,
      INFORMATION7,
      INFORMATION8,
      INFORMATION9,
      INFORMATION10,
      INFORMATION11,
      INFORMATION12,
      INFORMATION13,
      INFORMATION14,
      INFORMATION15,
      INFORMATION30
    from HR_FORM_PROPERTIES
    where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID
    for update of FORM_PROPERTY_ID nowait;

Line: 436


procedure UPDATE_ROW (
  X_FORM_PROPERTY_ID in NUMBER,
  X_INFORMATION29 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_APPLICATION_ID in NUMBER,
  X_FORM_ID in NUMBER,
  X_FORM_TEMPLATE_ID in NUMBER,
  X_HELP_TARGET 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_INFORMATION30 in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update HR_FORM_PROPERTIES set
    INFORMATION29 = X_INFORMATION29,
    INFORMATION16 = X_INFORMATION16,
    INFORMATION17 = X_INFORMATION17,
    INFORMATION18 = X_INFORMATION18,
    INFORMATION19 = X_INFORMATION19,
    INFORMATION20 = X_INFORMATION20,
    INFORMATION21 = X_INFORMATION21,
    INFORMATION22 = X_INFORMATION22,
    INFORMATION23 = X_INFORMATION23,
    INFORMATION24 = X_INFORMATION24,
    INFORMATION25 = X_INFORMATION25,
    INFORMATION26 = X_INFORMATION26,
    INFORMATION27 = X_INFORMATION27,
    INFORMATION28 = X_INFORMATION28,
    APPLICATION_ID = X_APPLICATION_ID,
    FORM_ID = X_FORM_ID,
    FORM_TEMPLATE_ID = X_FORM_TEMPLATE_ID,
    HELP_TARGET = X_HELP_TARGET,
    INFORMATION_CATEGORY = X_INFORMATION_CATEGORY,
    INFORMATION1 = X_INFORMATION1,
    INFORMATION2 = X_INFORMATION2,
    INFORMATION3 = X_INFORMATION3,
    INFORMATION4 = X_INFORMATION4,
    INFORMATION5 = X_INFORMATION5,
    INFORMATION6 = X_INFORMATION6,
    INFORMATION7 = X_INFORMATION7,
    INFORMATION8 = X_INFORMATION8,
    INFORMATION9 = X_INFORMATION9,
    INFORMATION10 = X_INFORMATION10,
    INFORMATION11 = X_INFORMATION11,
    INFORMATION12 = X_INFORMATION12,
    INFORMATION13 = X_INFORMATION13,
    INFORMATION14 = X_INFORMATION14,
    INFORMATION15 = X_INFORMATION15,
    INFORMATION30 = X_INFORMATION30,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;

Line: 522


end UPDATE_ROW;

Line: 524


procedure DELETE_ROW (
  X_FORM_PROPERTY_ID in NUMBER
) is
begin
  delete from HR_FORM_PROPERTIES
  where FORM_PROPERTY_ID = X_FORM_PROPERTY_ID;

Line: 535


end DELETE_ROW;

Line: 579


  X_LAST_UPDATE_DATE DATE;

Line: 580


  X_LAST_UPDATED_BY NUMBER;

Line: 581


  X_LAST_UPDATE_LOGIN NUMBER;

Line: 591


    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 596


 select application_id
 into X_APPLICATION_ID
 from fnd_application
 where application_short_name = X_APPLICATION_SHORT_NAME;

Line: 601


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

Line: 609


 select form_template_id
 into x_form_template_id
 from hr_form_templates_b
 where application_id = X_APPLICATION_ID
 and form_id = X_FORM_ID
 and template_name = X_TEMPLATE_NAME
 and (  (legislation_code is null and x_territory_short_name is null)
     or (legislation_code = x_territory_short_name) );

Line: 628


   select form_property_id
   into x_form_property_id
   from hr_form_properties
   where nvl(form_id,hr_api.g_number) = nvl(x_form_id,hr_api.g_number)
   and nvl(application_id,hr_api.g_number) = nvl(x_application_id,hr_api.g_number)
   and nvl(form_template_id,hr_api.g_number) = nvl(x_form_template_id,hr_api.g_number);

Line: 637


     select hr_form_properties_s.nextval
     into x_form_property_id
     from dual;

Line: 644


  UPDATE_COPIES (
  X_FORM_PROPERTY_ID,
  X_APPLICATION_ID,
  X_FORM_ID,
  X_FORM_TEMPLATE_ID,
  X_HELP_TARGET,
  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,
  X_LAST_UPDATE_DATE,
  X_LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN
  );

Line: 686


  UPDATE_ROW (
  X_FORM_PROPERTY_ID,
  X_INFORMATION29,
  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_APPLICATION_ID,
  X_FORM_ID,
  X_FORM_TEMPLATE_ID,
  X_HELP_TARGET,
  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_INFORMATION30,
  X_LAST_UPDATE_DATE,
  X_LAST_UPDATED_BY,
  X_LAST_UPDATE_LOGIN);

Line: 728


     INSERT_ROW (
       X_ROWID,
       X_FORM_PROPERTY_ID,
       X_INFORMATION29,
       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_APPLICATION_ID,
       X_FORM_ID,
       X_FORM_TEMPLATE_ID,
       X_HELP_TARGET,
       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_INFORMATION30,
       X_CREATION_DATE,
       X_CREATED_BY,
       X_LAST_UPDATE_DATE,
       X_LAST_UPDATED_BY,
       X_LAST_UPDATE_LOGIN);