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

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

Line: 53


  X_LAST_UPDATE_DATE  VARCHAR2 DEFAULT NULL
) AS
--
l_user_id number := fnd_load_util.owner_id(x_owner);

Line: 68


f_ludate  date;    -- entity update date in file

Line: 70


db_ludate date;    -- entity update date in db

Line: 90


    f_ludate := to_date(nvl(x_last_update_date,sysdate ), 'YYYY/MM/DD');

Line: 96


    select LAST_UPDATED_BY, LAST_UPDATE_DATE
      into db_luby, db_ludate
      FROM JTF_AMV_ATTACHMENTS
     where ATTACHMENT_ID = X_ATTACHMENT_ID;

Line: 103


     UPDATE_ROW (
            X_ATTACHMENT_ID => l_ATTACHMENT_ID,
            X_LAST_UPDATE_DATE => f_ludate,
            X_LAST_UPDATED_BY => f_luby,
            X_LAST_UPDATE_LOGIN => l_user_id,
            X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
            X_OWNER_USER_ID => X_OWNER_USER_ID,
            X_ATTACHMENT_USED_BY_ID => l_ATTACHMENT_USED_BY_ID,
            X_ATTACHMENT_USED_BY => X_ATTACHMENT_USED_BY,
            X_VERSION => X_VERSION,
            X_ENABLED_FLAG => X_ENABLED_FLAG,
            X_CAN_FULFILL_ELECTRONIC_FLAG => X_CAN_FULFILL_ELECTRONIC_FLAG,
            X_FILE_ID => l_FILE_ID,
            X_FILE_NAME => X_FILE_NAME,
            X_FILE_EXTENSION => X_FILE_EXTENSION,
            X_KEYWORDS => X_KEYWORDS,
            X_DISPLAY_WIDTH => l_DISPLAY_WIDTH,
            X_DISPLAY_HEIGHT => l_DISPLAY_HEIGHT,
            X_DISPLAY_LOCATION => X_DISPLAY_LOCATION,
            X_LINK_TO => X_LINK_TO,
            X_LINK_URL => X_LINK_URL,
            X_SEND_FOR_PREVIEW_FLAG => X_SEND_FOR_PREVIEW_FLAG,
            X_ATTACHMENT_TYPE => X_ATTACHMENT_TYPE,
            X_LANGUAGE_CODE => X_LANGUAGE_CODE,
            X_APPLICATION_ID => l_APPLICATION_ID,
            X_DESCRIPTION => X_DESCRIPTION,
            X_DEFAULT_STYLE_SHEET => X_DEFAULT_STYLE_SHEET,
            X_DISPLAY_URL => X_DISPLAY_URL,
            X_DISPLAY_RULE_ID => l_DISPLAY_RULE_ID,
            X_DISPLAY_PROGRAM => X_DISPLAY_PROGRAM,
            X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
            X_ATTRIBUTE1 => X_ATTRIBUTE1,
            X_ATTRIBUTE2 => X_ATTRIBUTE2,
            X_ATTRIBUTE3 => X_ATTRIBUTE3,
            X_ATTRIBUTE4 => X_ATTRIBUTE4,
            X_ATTRIBUTE5 => X_ATTRIBUTE5,
            X_ATTRIBUTE6 => X_ATTRIBUTE6,
            X_ATTRIBUTE7 => X_ATTRIBUTE7,
            X_ATTRIBUTE8 => X_ATTRIBUTE8,
            X_ATTRIBUTE9 => X_ATTRIBUTE9,
            X_ATTRIBUTE10 => X_ATTRIBUTE10,
            X_ATTRIBUTE11 => X_ATTRIBUTE11,
            X_ATTRIBUTE12 => X_ATTRIBUTE12,
            X_ATTRIBUTE13 => X_ATTRIBUTE13,
            X_ATTRIBUTE14 => X_ATTRIBUTE14,
            X_ATTRIBUTE15 => X_ATTRIBUTE15,
            X_DISPLAY_TEXT => X_DISPLAY_TEXT,
            X_ALTERNATE_TEXT => X_ALTERNATE_TEXT,
            X_ATTACHMENT_SUB_TYPE => X_ATTACHMENT_SUB_TYPE,
            X_DOCUMENT_ID => l_DOCUMENT_ID,
            X_SECURED_FLAG => X_SECURED_FLAG
     );

Line: 158


         INSERT_ROW (
            X_ROWID => l_row_id,
            X_ATTACHMENT_ID => l_ATTACHMENT_ID,
            X_LAST_UPDATE_DATE => f_ludate,
            X_LAST_UPDATED_BY => f_luby,
            X_CREATION_DATE => f_ludate,
            X_CREATED_BY => f_luby,
            X_LAST_UPDATE_LOGIN => l_user_id,
            X_OBJECT_VERSION_NUMBER => l_OBJECT_VERSION_NUMBER,
            X_OWNER_USER_ID => X_OWNER_USER_ID,
            X_ATTACHMENT_USED_BY_ID => l_ATTACHMENT_USED_BY_ID,
            X_ATTACHMENT_USED_BY => X_ATTACHMENT_USED_BY,
            X_VERSION => X_VERSION,
            X_ENABLED_FLAG => X_ENABLED_FLAG,
            X_CAN_FULFILL_ELECTRONIC_FLAG => X_CAN_FULFILL_ELECTRONIC_FLAG,
            X_FILE_ID => l_FILE_ID,
            X_FILE_NAME => X_FILE_NAME,
            X_FILE_EXTENSION => X_FILE_EXTENSION,
            X_KEYWORDS => X_KEYWORDS,
            X_DISPLAY_WIDTH => l_DISPLAY_WIDTH,
            X_DISPLAY_HEIGHT => l_DISPLAY_HEIGHT,
            X_DISPLAY_LOCATION => X_DISPLAY_LOCATION,
            X_LINK_TO => X_LINK_TO,
            X_LINK_URL => X_LINK_URL,
            X_SEND_FOR_PREVIEW_FLAG => X_SEND_FOR_PREVIEW_FLAG,
            X_ATTACHMENT_TYPE => X_ATTACHMENT_TYPE,
            X_LANGUAGE_CODE => X_LANGUAGE_CODE,
            X_APPLICATION_ID => l_APPLICATION_ID,
            X_DESCRIPTION => X_DESCRIPTION,
            X_DEFAULT_STYLE_SHEET => X_DEFAULT_STYLE_SHEET,
            X_DISPLAY_URL => X_DISPLAY_URL,
            X_DISPLAY_RULE_ID => l_DISPLAY_RULE_ID,
            X_DISPLAY_PROGRAM => X_DISPLAY_PROGRAM,
            X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
            X_ATTRIBUTE1 => X_ATTRIBUTE1,
            X_ATTRIBUTE2 => X_ATTRIBUTE2,
            X_ATTRIBUTE3 => X_ATTRIBUTE3,
            X_ATTRIBUTE4 => X_ATTRIBUTE4,
            X_ATTRIBUTE5 => X_ATTRIBUTE5,
            X_ATTRIBUTE6 => X_ATTRIBUTE6,
            X_ATTRIBUTE7 => X_ATTRIBUTE7,
            X_ATTRIBUTE8 => X_ATTRIBUTE8,
            X_ATTRIBUTE9 => X_ATTRIBUTE9,
            X_ATTRIBUTE10 => X_ATTRIBUTE10,
            X_ATTRIBUTE11 => X_ATTRIBUTE11,
            X_ATTRIBUTE12 => X_ATTRIBUTE12,
            X_ATTRIBUTE13 => X_ATTRIBUTE13,
            X_ATTRIBUTE14 => X_ATTRIBUTE14,
            X_ATTRIBUTE15 => X_ATTRIBUTE15,
            X_DISPLAY_TEXT => X_DISPLAY_TEXT,
            X_ALTERNATE_TEXT => X_ALTERNATE_TEXT,
            X_ATTACHMENT_SUB_TYPE => X_ATTACHMENT_SUB_TYPE,
            X_DOCUMENT_ID => l_DOCUMENT_ID,
            X_SECURED_FLAG => X_SECURED_FLAG
         );

Line: 214


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ATTACHMENT_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OWNER_USER_ID in NUMBER,
  X_ATTACHMENT_USED_BY_ID in NUMBER,
  X_ATTACHMENT_USED_BY in VARCHAR2,
  X_VERSION in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
  X_FILE_ID in NUMBER,
  X_FILE_NAME in VARCHAR2,
  X_FILE_EXTENSION in VARCHAR2,
  X_KEYWORDS in VARCHAR2,
  X_DISPLAY_WIDTH in NUMBER,
  X_DISPLAY_HEIGHT in NUMBER,
  X_DISPLAY_LOCATION in VARCHAR2,
  X_LINK_TO in VARCHAR2,
  X_LINK_URL in VARCHAR2,
  X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
  X_ATTACHMENT_TYPE in VARCHAR2,
  X_LANGUAGE_CODE in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_DEFAULT_STYLE_SHEET in VARCHAR2,
  X_DISPLAY_URL in VARCHAR2,
  X_DISPLAY_RULE_ID in NUMBER,
  X_DISPLAY_PROGRAM in VARCHAR2,
  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_DISPLAY_TEXT in VARCHAR2 := NULL,
  X_ALTERNATE_TEXT in VARCHAR2 := NULL,
  X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
  X_DOCUMENT_ID in NUMBER := NULL,
  X_SECURED_FLAG in VARCHAR2 := NULL
) AS
  cursor C is select ROWID from JTF_AMV_ATTACHMENTS
    where attachment_id = x_attachment_id
    ;

Line: 273


   insert into JTF_AMV_ATTACHMENTS
     (
        ATTACHMENT_ID,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_LOGIN,
        OBJECT_VERSION_NUMBER,
        OWNER_USER_ID,
        ATTACHMENT_USED_BY_ID,
        ATTACHMENT_USED_BY,
        VERSION,
        ENABLED_FLAG,
        CAN_FULFILL_ELECTRONIC_FLAG,
        FILE_ID,
        FILE_NAME,
        FILE_EXTENSION,
        KEYWORDS,
        DISPLAY_WIDTH,
        DISPLAY_HEIGHT,
        DISPLAY_LOCATION,
        LINK_TO,
        LINK_URL,
        SEND_FOR_PREVIEW_FLAG,
        ATTACHMENT_TYPE,
        LANGUAGE_CODE,
        APPLICATION_ID,
        DESCRIPTION,
        DEFAULT_STYLE_SHEET,
        DISPLAY_URL,
        DISPLAY_RULE_ID,
        DISPLAY_PROGRAM,
        ATTRIBUTE_CATEGORY,
        ATTRIBUTE1,
        ATTRIBUTE2,
        ATTRIBUTE3,
        ATTRIBUTE4,
        ATTRIBUTE5,
        ATTRIBUTE6,
        ATTRIBUTE7,
        ATTRIBUTE8,
        ATTRIBUTE9,
        ATTRIBUTE10,
        ATTRIBUTE11,
        ATTRIBUTE12,
        ATTRIBUTE13,
        ATTRIBUTE14,
        ATTRIBUTE15,
        DISPLAY_TEXT,
	   ALTERNATE_TEXT,
	   ATTACHMENT_SUB_TYPE,
    DOCUMENT_ID,
    SECURED_FLAG
    ) VALUES (
        X_ATTACHMENT_ID,
        X_LAST_UPDATE_DATE,
        X_LAST_UPDATED_BY,
        X_CREATION_DATE,
        X_CREATED_BY,
        X_LAST_UPDATE_LOGIN,
        X_OBJECT_VERSION_NUMBER,
        X_OWNER_USER_ID,
        X_ATTACHMENT_USED_BY_ID,
        X_ATTACHMENT_USED_BY,
        X_VERSION,
        X_ENABLED_FLAG,
        X_CAN_FULFILL_ELECTRONIC_FLAG,
        X_FILE_ID,
        X_FILE_NAME,
        X_FILE_EXTENSION,
        X_KEYWORDS,
        X_DISPLAY_WIDTH,
        X_DISPLAY_HEIGHT,
        X_DISPLAY_LOCATION,
        X_LINK_TO,
        X_LINK_URL,
        X_SEND_FOR_PREVIEW_FLAG,
        X_ATTACHMENT_TYPE,
        X_LANGUAGE_CODE,
        X_APPLICATION_ID,
        X_DESCRIPTION,
        X_DEFAULT_STYLE_SHEET,
        X_DISPLAY_URL,
        X_DISPLAY_RULE_ID,
        X_DISPLAY_PROGRAM,
        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_DISPLAY_TEXT,
	   X_ALTERNATE_TEXT,
	   X_ATTACHMENT_SUB_TYPE,
    X_DOCUMENT_ID,
    X_SECURED_FLAG
    );

Line: 390


procedure UPDATE_ROW (
  X_ATTACHMENT_ID in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_OWNER_USER_ID in NUMBER,
  X_ATTACHMENT_USED_BY_ID in NUMBER,
  X_ATTACHMENT_USED_BY in VARCHAR2,
  X_VERSION in VARCHAR2,
  X_ENABLED_FLAG in VARCHAR2,
  X_CAN_FULFILL_ELECTRONIC_FLAG in VARCHAR2,
  X_FILE_ID in NUMBER,
  X_FILE_NAME in VARCHAR2,
  X_FILE_EXTENSION in VARCHAR2,
  X_KEYWORDS in VARCHAR2,
  X_DISPLAY_WIDTH in NUMBER,
  X_DISPLAY_HEIGHT in NUMBER,
  X_DISPLAY_LOCATION in VARCHAR2,
  X_LINK_TO in VARCHAR2,
  X_LINK_URL in VARCHAR2,
  X_SEND_FOR_PREVIEW_FLAG in VARCHAR2,
  X_ATTACHMENT_TYPE in VARCHAR2,
  X_LANGUAGE_CODE in VARCHAR2,
  X_APPLICATION_ID in NUMBER,
  X_DESCRIPTION in VARCHAR2,
  X_DEFAULT_STYLE_SHEET in VARCHAR2,
  X_DISPLAY_URL in VARCHAR2,
  X_DISPLAY_RULE_ID in NUMBER,
  X_DISPLAY_PROGRAM in VARCHAR2,
  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_DISPLAY_TEXT in VARCHAR2 := NULL,
  X_ALTERNATE_TEXT in VARCHAR2 := NULL,
  X_ATTACHMENT_SUB_TYPE in VARCHAR2 := NULL,
  X_DOCUMENT_ID in NUMBER := NULL,
  X_SECURED_FLAG in VARCHAR2 := NULL
) AS
BEGIN
   Update JTF_AMV_ATTACHMENTS SET
        LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
        LAST_UPDATED_BY = X_LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
        OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
        OWNER_USER_ID = X_OWNER_USER_ID,
        ATTACHMENT_USED_BY_ID = X_ATTACHMENT_USED_BY_ID,
        ATTACHMENT_USED_BY = X_ATTACHMENT_USED_BY,
        VERSION = X_VERSION,
        ENABLED_FLAG = X_ENABLED_FLAG,
        CAN_FULFILL_ELECTRONIC_FLAG = X_CAN_FULFILL_ELECTRONIC_FLAG,
--        FILE_ID = X_FILE_ID,
        FILE_NAME = X_FILE_NAME,
        FILE_EXTENSION = X_FILE_EXTENSION,
        KEYWORDS = X_KEYWORDS,
        DISPLAY_WIDTH = X_DISPLAY_WIDTH,
        DISPLAY_HEIGHT = X_DISPLAY_HEIGHT,
        DISPLAY_LOCATION = X_DISPLAY_LOCATION,
        LINK_TO = X_LINK_TO,
        LINK_URL = X_LINK_URL,
        SEND_FOR_PREVIEW_FLAG = X_SEND_FOR_PREVIEW_FLAG,
        ATTACHMENT_TYPE = X_ATTACHMENT_TYPE,
        LANGUAGE_CODE = X_LANGUAGE_CODE,
        APPLICATION_ID = X_APPLICATION_ID,
        DESCRIPTION = X_DESCRIPTION,
        DEFAULT_STYLE_SHEET = X_DEFAULT_STYLE_SHEET,
        DISPLAY_URL = X_DISPLAY_URL,
        DISPLAY_RULE_ID = X_DISPLAY_RULE_ID,
        DISPLAY_PROGRAM = X_DISPLAY_PROGRAM,
        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,
	   DISPLAY_TEXT = X_DISPLAY_TEXT,
	   ALTERNATE_TEXT = X_ALTERNATE_TEXT,
	   ATTACHMENT_SUB_TYPE = X_ATTACHMENT_SUB_TYPE,
    DOCUMENT_ID = X_DOCUMENT_ID,
    SECURED_FLAG = X_SECURED_FLAG
    where ATTACHMENT_ID = X_ATTACHMENT_ID;

Line: 551


x_last_update_date in varchar2)
is
         v_db_owner_id number;

Line: 610


	    x_last_update_date=> x_last_update_date
           );

Line: 669


	    x_last_update_date=>x_last_update_date
      );