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.CS_CF_SOURCE_CXT_TARGETS_PKG SQL Statements

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

Line: 3


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_SOURCE_CONTEXT_TARGET_ID in NUMBER,
  X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
  X_CONTEXT_VALUE1 in VARCHAR2,
  X_CONTEXT_VALUE2 in VARCHAR2,
  X_CONTEXT_VALUE3 in VARCHAR2,
  X_CONTEXT_VALUE4 in VARCHAR2,
  X_CONTEXT_VALUE5 in VARCHAR2,
  X_SEED_TARGET_VALUE1 in VARCHAR2,
  X_SEED_TARGET_VALUE2 in VARCHAR2,
  X_CUST_TARGET_VALUE1 in VARCHAR2,
  X_CUST_TARGET_VALUE2 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER 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,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ADDITIONAL_INFO1 in VARCHAR2,
  X_ADDITIONAL_INFO2 in VARCHAR2,
  X_ADDITIONAL_INFO3 in VARCHAR2,
  X_ADDITIONAL_INFO4 in VARCHAR2,
  X_ADDITIONAL_INFO5 in VARCHAR2,
  X_ADDITIONAL_INFO6 in VARCHAR2,
  X_ADDITIONAL_INFO7 in VARCHAR2,
  X_ADDITIONAL_INFO8 in VARCHAR2,
  X_ADDITIONAL_INFO9 in VARCHAR2,
  X_ADDITIONAL_INFO10 in VARCHAR2,
  X_ADDITIONAL_INFO11 in VARCHAR2,
  X_ADDITIONAL_INFO12 in VARCHAR2,
  X_ADDITIONAL_INFO13 in VARCHAR2,
  X_ADDITIONAL_INFO14 in VARCHAR2,
  X_ADDITIONAL_INFO15 in VARCHAR2

) is
  cursor C is select ROWID from CS_CF_SOURCE_CXT_TARGETS
    where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;

Line: 60


  insert into CS_CF_SOURCE_CXT_TARGETS (
    SOURCE_CONTEXT_TARGET_ID,
    SOURCE_CONTEXT_TYPE_ID,
    CONTEXT_VALUE1,
    CONTEXT_VALUE2,
    CONTEXT_VALUE3,
    CONTEXT_VALUE4,
    CONTEXT_VALUE5,
    SEED_TARGET_VALUE1,
    SEED_TARGET_VALUE2,
    CUST_TARGET_VALUE1,
    CUST_TARGET_VALUE2,
    OBJECT_VERSION_NUMBER,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ADDITIONAL_INFO1,
    ADDITIONAL_INFO2,
    ADDITIONAL_INFO3,
    ADDITIONAL_INFO4,
    ADDITIONAL_INFO5,
    ADDITIONAL_INFO6,
    ADDITIONAL_INFO7,
    ADDITIONAL_INFO8,
    ADDITIONAL_INFO9,
    ADDITIONAL_INFO10,
    ADDITIONAL_INFO11,
    ADDITIONAL_INFO12,
    ADDITIONAL_INFO13,
    ADDITIONAL_INFO14,
    ADDITIONAL_INFO15
  ) values (
    X_SOURCE_CONTEXT_TARGET_ID,
    X_SOURCE_CONTEXT_TYPE_ID,
    X_CONTEXT_VALUE1,
    X_CONTEXT_VALUE2,
    X_CONTEXT_VALUE3,
    X_CONTEXT_VALUE4,
    X_CONTEXT_VALUE5,
    X_SEED_TARGET_VALUE1,
    X_SEED_TARGET_VALUE2,
    X_CUST_TARGET_VALUE1,
    X_CUST_TARGET_VALUE2,
    X_OBJECT_VERSION_NUMBER,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_ATTRIBUTE_CATEGORY,
    X_ATTRIBUTE1,
    X_ATTRIBUTE2,
    X_ATTRIBUTE3,
    X_ATTRIBUTE4,
    X_ATTRIBUTE5,
    X_ATTRIBUTE6,
    X_ATTRIBUTE7,
    X_ATTRIBUTE8,
    X_ATTRIBUTE9,
    X_ATTRIBUTE10,
    X_ATTRIBUTE11,
    X_ATTRIBUTE12,
    X_ATTRIBUTE13,
    X_ATTRIBUTE14,
    X_ATTRIBUTE15,
    X_ADDITIONAL_INFO1,
    X_ADDITIONAL_INFO2,
    X_ADDITIONAL_INFO3,
    X_ADDITIONAL_INFO4,
    X_ADDITIONAL_INFO5,
    X_ADDITIONAL_INFO6,
    X_ADDITIONAL_INFO7,
    X_ADDITIONAL_INFO8,
    X_ADDITIONAL_INFO9,
    X_ADDITIONAL_INFO10,
    X_ADDITIONAL_INFO11,
    X_ADDITIONAL_INFO12,
    X_ADDITIONAL_INFO13,
    X_ADDITIONAL_INFO14,
    X_ADDITIONAL_INFO15
  );

Line: 168


end INSERT_ROW;

Line: 215


  cursor c is select
	 SOURCE_CONTEXT_TYPE_ID,
	 CONTEXT_VALUE1,
	 CONTEXT_VALUE2,
	 CONTEXT_VALUE3,
	 CONTEXT_VALUE4,
	 CONTEXT_VALUE5,
	 SEED_TARGET_VALUE1,
         SEED_TARGET_VALUE2,
         CUST_TARGET_VALUE1,
         CUST_TARGET_VALUE2,
         OBJECT_VERSION_NUMBER,
	 ATTRIBUTE_CATEGORY,
	 ATTRIBUTE1,
	 ATTRIBUTE2,
	 ATTRIBUTE3,
	 ATTRIBUTE4,
	 ATTRIBUTE5,
	 ATTRIBUTE6,
	 ATTRIBUTE7,
	 ATTRIBUTE8,
	 ATTRIBUTE9,
	 ATTRIBUTE10,
	 ATTRIBUTE11,
	 ATTRIBUTE12,
	 ATTRIBUTE13,
	 ATTRIBUTE14,
	 ATTRIBUTE15,
	 ADDITIONAL_INFO1,
	 ADDITIONAL_INFO2,
	 ADDITIONAL_INFO3,
	 ADDITIONAL_INFO4,
	 ADDITIONAL_INFO5,
	 ADDITIONAL_INFO6,
	 ADDITIONAL_INFO7,
	 ADDITIONAL_INFO8,
	 ADDITIONAL_INFO9,
	 ADDITIONAL_INFO10,
	 ADDITIONAL_INFO11,
	 ADDITIONAL_INFO12,
	 ADDITIONAL_INFO13,
	 ADDITIONAL_INFO14,
	 ADDITIONAL_INFO15
    from CS_CF_SOURCE_CXT_TARGETS
    where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID
    for update of SOURCE_CONTEXT_TARGET_ID nowait;

Line: 268


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 366


procedure UPDATE_ROW (
  X_SOURCE_CONTEXT_TARGET_ID in NUMBER,
  X_SOURCE_CONTEXT_TYPE_ID in NUMBER,
  X_CONTEXT_VALUE1 in VARCHAR2,
  X_CONTEXT_VALUE2 in VARCHAR2,
  X_CONTEXT_VALUE3 in VARCHAR2,
  X_CONTEXT_VALUE4 in VARCHAR2,
  X_CONTEXT_VALUE5 in VARCHAR2,
  X_SEED_TARGET_VALUE1 in VARCHAR2,
  X_SEED_TARGET_VALUE2 in VARCHAR2,
  X_CUST_TARGET_VALUE1 in VARCHAR2,
  X_CUST_TARGET_VALUE2 in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_ATTRIBUTE_CATEGORY in VARCHAR2,
  X_ATTRIBUTE1 in VARCHAR2,
  X_ATTRIBUTE2 in VARCHAR2,
  X_ATTRIBUTE3 in VARCHAR2,
  X_ATTRIBUTE4 in VARCHAR2,
  X_ATTRIBUTE5 in VARCHAR2,
  X_ATTRIBUTE6 in VARCHAR2,
  X_ATTRIBUTE7 in VARCHAR2,
  X_ATTRIBUTE8 in VARCHAR2,
  X_ATTRIBUTE9 in VARCHAR2,
  X_ATTRIBUTE10 in VARCHAR2,
  X_ATTRIBUTE11 in VARCHAR2,
  X_ATTRIBUTE12 in VARCHAR2,
  X_ATTRIBUTE13 in VARCHAR2,
  X_ATTRIBUTE14 in VARCHAR2,
  X_ATTRIBUTE15 in VARCHAR2,
  X_ADDITIONAL_INFO1 in VARCHAR2,
  X_ADDITIONAL_INFO2 in VARCHAR2,
  X_ADDITIONAL_INFO3 in VARCHAR2,
  X_ADDITIONAL_INFO4 in VARCHAR2,
  X_ADDITIONAL_INFO5 in VARCHAR2,
  X_ADDITIONAL_INFO6 in VARCHAR2,
  X_ADDITIONAL_INFO7 in VARCHAR2,
  X_ADDITIONAL_INFO8 in VARCHAR2,
  X_ADDITIONAL_INFO9 in VARCHAR2,
  X_ADDITIONAL_INFO10 in VARCHAR2,
  X_ADDITIONAL_INFO11 in VARCHAR2,
  X_ADDITIONAL_INFO12 in VARCHAR2,
  X_ADDITIONAL_INFO13 in VARCHAR2,
  X_ADDITIONAL_INFO14 in VARCHAR2,
  X_ADDITIONAL_INFO15 in VARCHAR2
) is


begin


  update CS_CF_SOURCE_CXT_TARGETS set
    SOURCE_CONTEXT_TYPE_ID = X_SOURCE_CONTEXT_TYPE_ID,
    CONTEXT_VALUE1 = X_CONTEXT_VALUE1,
    CONTEXT_VALUE2 = X_CONTEXT_VALUE2,
    CONTEXT_VALUE3 = X_CONTEXT_VALUE3,
    CONTEXT_VALUE4 = X_CONTEXT_VALUE4,
    CONTEXT_VALUE5 = X_CONTEXT_VALUE5,
    SEED_TARGET_VALUE1 = X_SEED_TARGET_VALUE1,
    SEED_TARGET_VALUE2 = X_SEED_TARGET_VALUE2,
    CUST_TARGET_VALUE1 = X_CUST_TARGET_VALUE1,
    CUST_TARGET_VALUE2 = X_CUST_TARGET_VALUE2,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
    ATTRIBUTE1 = X_ATTRIBUTE1,
    ATTRIBUTE2 = X_ATTRIBUTE2,
    ATTRIBUTE3 = X_ATTRIBUTE3,
    ATTRIBUTE4 = X_ATTRIBUTE4,
    ATTRIBUTE5 = X_ATTRIBUTE5,
    ATTRIBUTE6 = X_ATTRIBUTE6,
    ATTRIBUTE7 = X_ATTRIBUTE7,
    ATTRIBUTE8 = X_ATTRIBUTE8,
    ATTRIBUTE9 = X_ATTRIBUTE9,
    ATTRIBUTE10 = X_ATTRIBUTE10,
    ATTRIBUTE11 = X_ATTRIBUTE11,
    ATTRIBUTE12 = X_ATTRIBUTE12,
    ATTRIBUTE13 = X_ATTRIBUTE13,
    ATTRIBUTE14 = X_ATTRIBUTE14,
    ATTRIBUTE15 = X_ATTRIBUTE15,
    ADDITIONAL_INFO1 = X_ADDITIONAL_INFO1,
    ADDITIONAL_INFO2 = X_ADDITIONAL_INFO2,
    ADDITIONAL_INFO3 = X_ADDITIONAL_INFO3,
    ADDITIONAL_INFO4 = X_ADDITIONAL_INFO4,
    ADDITIONAL_INFO5 = X_ADDITIONAL_INFO5,
    ADDITIONAL_INFO6 = X_ADDITIONAL_INFO6,
    ADDITIONAL_INFO7 = X_ADDITIONAL_INFO7,
    ADDITIONAL_INFO8 = X_ADDITIONAL_INFO8,
    ADDITIONAL_INFO9 = X_ADDITIONAL_INFO9,
    ADDITIONAL_INFO10 = X_ADDITIONAL_INFO10,
    ADDITIONAL_INFO11 = X_ADDITIONAL_INFO11,
    ADDITIONAL_INFO12 = X_ADDITIONAL_INFO12,
    ADDITIONAL_INFO13 = X_ADDITIONAL_INFO13,
    ADDITIONAL_INFO14 = X_ADDITIONAL_INFO14,
    ADDITIONAL_INFO15 = X_ADDITIONAL_INFO15
  where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;

Line: 472


end UPDATE_ROW;

Line: 474


procedure DELETE_ROW (
  X_SOURCE_CONTEXT_TARGET_ID in NUMBER
) is
begin

  delete from CS_CF_SOURCE_CXT_TARGETS
  where SOURCE_CONTEXT_TARGET_ID = X_SOURCE_CONTEXT_TARGET_ID;

Line: 485


end DELETE_ROW;

Line: 500


  X_LAST_UPDATE_DATE in DATE,
  X_CUSTOM_MODE in VARCHAR2,
  X_ADDITIONAL_INFO1 in VARCHAR2,
  X_ADDITIONAL_INFO2 in VARCHAR2,
  X_ADDITIONAL_INFO3 in VARCHAR2,
  X_ADDITIONAL_INFO4 in VARCHAR2,
  X_ADDITIONAL_INFO5 in VARCHAR2,
  X_ADDITIONAL_INFO6 in VARCHAR2,
  X_ADDITIONAL_INFO7 in VARCHAR2,
  X_ADDITIONAL_INFO8 in VARCHAR2,
  X_ADDITIONAL_INFO9 in VARCHAR2,
  X_ADDITIONAL_INFO10 in VARCHAR2,
  X_ADDITIONAL_INFO11 in VARCHAR2,
  X_ADDITIONAL_INFO12 in VARCHAR2,
  X_ADDITIONAL_INFO13 in VARCHAR2,
  X_ADDITIONAL_INFO14 in VARCHAR2,
  X_ADDITIONAL_INFO15 in VARCHAR2
) AS

  f_luby number ; -- entity owner in file

Line: 520


  f_ludate date ; -- entity update date in file

Line: 522


  db_ludate date; -- entity update date in db

Line: 547


  f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);

Line: 550


  select LAST_UPDATED_BY, LAST_UPDATE_DATE
  into db_luby, db_ludate
  from CS_CF_SOURCE_CXT_TARGETS
  where source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID;

Line: 557


    SELECT object_version_number, rowid,
		 attribute_category,
		 attribute1,
		 attribute2,
		 attribute3,
		 attribute4,
		 attribute5,
		 attribute6,
		 attribute7,
		 attribute8,
		 attribute9,
		 attribute10,
		 attribute11,
		 attribute12,
		 attribute13,
		 attribute14,
		 attribute15
    INTO l_object_version_number, l_rowid,
	    l_attribute_category,
	    l_attribute1,
	    l_attribute2,
	    l_attribute3,
	    l_attribute4,
	    l_attribute5,
	    l_attribute6,
	    l_attribute7,
	    l_attribute8,
	    l_attribute9,
	    l_attribute10,
	    l_attribute11,
	    l_attribute12,
	    l_attribute13,
	    l_attribute14,
	    l_attribute15
    FROM CS_CF_SOURCE_CXT_TARGETS
    WHERE source_context_target_id = X_SOURCE_CONTEXT_TARGET_ID
    FOR UPDATE ;

Line: 595


    CS_CF_SOURCE_CXT_TARGETS_PKG.Update_Row(
	 X_SOURCE_CONTEXT_TARGET_ID => to_number(X_SOURCE_CONTEXT_TARGET_ID),
	 X_SOURCE_CONTEXT_TYPE_ID => to_number(X_SOURCE_CONTEXT_TYPE_ID),
	 X_CONTEXT_VALUE1 => X_CONTEXT_VALUE1,
	 X_CONTEXT_VALUE2 => X_CONTEXT_VALUE2,
	 X_CONTEXT_VALUE3 => X_CONTEXT_VALUE3,
	 X_CONTEXT_VALUE4 => X_CONTEXT_VALUE4,
	 X_CONTEXT_VALUE5 => X_CONTEXT_VALUE5,
	 X_SEED_TARGET_VALUE1 => X_SEED_TARGET_VALUE1,
	 X_SEED_TARGET_VALUE2 => X_SEED_TARGET_VALUE2,
	 X_CUST_TARGET_VALUE1 => X_CUST_TARGET_VALUE1,
	 X_CUST_TARGET_VALUE2 => X_CUST_TARGET_VALUE2,
	 X_OBJECT_VERSION_NUMBER => l_object_version_number + 1,
	 X_ATTRIBUTE_CATEGORY => l_attribute_category,
	 X_ATTRIBUTE1 => l_attribute1,
	 X_ATTRIBUTE2 => l_attribute2,
	 X_ATTRIBUTE3 => l_attribute3,
	 X_ATTRIBUTE4 => l_attribute4,
	 X_ATTRIBUTE5 => l_attribute5,
	 X_ATTRIBUTE6 => l_attribute6,
	 X_ATTRIBUTE7 => l_attribute7,
	 X_ATTRIBUTE8 => l_attribute8,
	 X_ATTRIBUTE9 => l_attribute9,
	 X_ATTRIBUTE10 => l_attribute10,
	 X_ATTRIBUTE11 => l_attribute11,
	 X_ATTRIBUTE12 => l_attribute12,
	 X_ATTRIBUTE13 => l_attribute13,
	 X_ATTRIBUTE14 => l_attribute14,
	 X_ATTRIBUTE15 => l_attribute15,
	 X_ADDITIONAL_INFO1 => X_ADDITIONAL_INFO1,
	 X_ADDITIONAL_INFO2 => X_ADDITIONAL_INFO2,
	 X_ADDITIONAL_INFO3 => X_ADDITIONAL_INFO3,
	 X_ADDITIONAL_INFO4 => X_ADDITIONAL_INFO4,
	 X_ADDITIONAL_INFO5 => X_ADDITIONAL_INFO5,
	 X_ADDITIONAL_INFO6 => X_ADDITIONAL_INFO6,
	 X_ADDITIONAL_INFO7 => X_ADDITIONAL_INFO7,
	 X_ADDITIONAL_INFO8 => X_ADDITIONAL_INFO8,
	 X_ADDITIONAL_INFO9 => X_ADDITIONAL_INFO9,
	 X_ADDITIONAL_INFO10 => X_ADDITIONAL_INFO10,
	 X_ADDITIONAL_INFO11 => X_ADDITIONAL_INFO11,
	 X_ADDITIONAL_INFO12 => X_ADDITIONAL_INFO12,
	 X_ADDITIONAL_INFO13 => X_ADDITIONAL_INFO13,
	 X_ADDITIONAL_INFO14 => X_ADDITIONAL_INFO14,
	 X_ADDITIONAL_INFO15 => X_ADDITIONAL_INFO15,
	 X_LAST_UPDATE_DATE => f_ludate,
	 X_LAST_UPDATED_BY => f_luby,
	 X_LAST_UPDATE_LOGIN => 0);

Line: 645


	   -- Record doesn't exist -- insert in all cases
	   CS_CF_SOURCE_CXT_TARGETS_PKG.Insert_Row(
		X_ROWID => l_rowid,
		X_SOURCE_CONTEXT_TARGET_ID => X_SOURCE_CONTEXT_TARGET_ID,
		X_SOURCE_CONTEXT_TYPE_ID => X_SOURCE_CONTEXT_TYPE_ID,
		X_CONTEXT_VALUE1 => X_CONTEXT_VALUE1,
		X_CONTEXT_VALUE2 => X_CONTEXT_VALUE2,
		X_CONTEXT_VALUE3 => X_CONTEXT_VALUE3,
		X_CONTEXT_VALUE4 => X_CONTEXT_VALUE4,
		X_CONTEXT_VALUE5 => X_CONTEXT_VALUE5,
		X_SEED_TARGET_VALUE1 => X_SEED_TARGET_VALUE1,
		X_SEED_TARGET_VALUE2 => X_SEED_TARGET_VALUE2,
		X_CUST_TARGET_VALUE1 => X_CUST_TARGET_VALUE1,
		X_CUST_TARGET_VALUE2 => X_CUST_TARGET_VALUE2,
		X_OBJECT_VERSION_NUMBER => l_object_version_number,
		X_ATTRIBUTE_CATEGORY => NULL,
		X_ATTRIBUTE1 => NULL,
		X_ATTRIBUTE2 => NULL,
		X_ATTRIBUTE3 => NULL,
		X_ATTRIBUTE4 => NULL,
		X_ATTRIBUTE5 => NULL,
		X_ATTRIBUTE6 => NULL,
		X_ATTRIBUTE7 => NULL,
		X_ATTRIBUTE8 => NULL,
		X_ATTRIBUTE9 => NULL,
		X_ATTRIBUTE10 => NULL,
		X_ATTRIBUTE11 => NULL,
		X_ATTRIBUTE12 => NULL,
		X_ATTRIBUTE13 => NULL,
		X_ATTRIBUTE14 => NULL,
		X_ATTRIBUTE15 => NULL,
		X_ADDITIONAL_INFO1 => X_ADDITIONAL_INFO1,
		X_ADDITIONAL_INFO2 => X_ADDITIONAL_INFO2,
		X_ADDITIONAL_INFO3 => X_ADDITIONAL_INFO3,
		X_ADDITIONAL_INFO4 => X_ADDITIONAL_INFO4,
		X_ADDITIONAL_INFO5 => X_ADDITIONAL_INFO5,
		X_ADDITIONAL_INFO6 => X_ADDITIONAL_INFO6,
		X_ADDITIONAL_INFO7 => X_ADDITIONAL_INFO7,
		X_ADDITIONAL_INFO8 => X_ADDITIONAL_INFO8,
		X_ADDITIONAL_INFO9 => X_ADDITIONAL_INFO9,
		X_ADDITIONAL_INFO10 => X_ADDITIONAL_INFO10,
		X_ADDITIONAL_INFO11 => X_ADDITIONAL_INFO11,
		X_ADDITIONAL_INFO12 => X_ADDITIONAL_INFO12,
		X_ADDITIONAL_INFO13 => X_ADDITIONAL_INFO13,
		X_ADDITIONAL_INFO14 => X_ADDITIONAL_INFO14,
		X_ADDITIONAL_INFO15 => X_ADDITIONAL_INFO15,
		X_CREATION_DATE => sysdate,
		X_CREATED_BY => f_luby,
		X_LAST_UPDATE_DATE => f_ludate,
		X_LAST_UPDATED_BY => f_luby,
		X_LAST_UPDATE_LOGIN => 0);