[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT FND_ATTACHED_DOCUMENTS_S.NEXTVAL
FROM DUAL;
SELECT CATEGORY_ID INTO L_CATEGORY_ID
FROM
FND_DOCUMENT_CATEGORIES
WHERE
NAME = L_CATEGORY_NAME;
FND_ATTACHED_DOCUMENTS_PKG.INSERT_ROW(
X_ROWID=>L_ROW_ID,
X_ATTACHED_DOCUMENT_ID=>L_ATTACHED_DOCUMENT_ID,
X_DOCUMENT_ID=>L_FND_DOCUMENT_ID,
X_CREATION_DATE=>SYSDATE,
X_CREATED_BY=>FND_GLOBAL.USER_ID,
X_LAST_UPDATE_DATE=>SYSDATE,
X_LAST_UPDATED_BY=>FND_GLOBAL.USER_ID,
X_LAST_UPDATE_LOGIN=>FND_GLOBAL.USER_ID,
X_SEQ_NUM=>1,
X_ENTITY_NAME=>'EDR_XSLFO_TEMPLATE',
X_COLUMN1=>NULL,
X_PK1_VALUE=>L_EVENT_KEY,
X_PK2_VALUE=>NULL,
X_PK3_VALUE=>NULL,
X_PK4_VALUE=>NULL,
X_PK5_VALUE=>NULL,
X_AUTOMATICALLY_ADDED_FLAG=>'N',
X_DATATYPE_ID=>6,
X_CATEGORY_ID=>L_CATEGORY_ID,
X_SECURITY_TYPE=>1,
X_SECURITY_ID=>-1,
X_PUBLISH_FLAG=>'N',
X_STORAGE_TYPE=>1,
X_USAGE_TYPE=>'S',
X_LANGUAGE=>USERENV('LANG'),
X_DESCRIPTION=>'XSL FO TEMPLATE',
X_FILE_NAME=>L_FILE_NAME,
X_MEDIA_ID=>L_MEDIA_ID,
X_DOC_ATTRIBUTE_CATEGORY=>NULL,
X_DOC_ATTRIBUTE1=>NULL,
X_DOC_ATTRIBUTE2=>NULL,
X_DOC_ATTRIBUTE3=>NULL,
X_DOC_ATTRIBUTE4=>NULL,
X_DOC_ATTRIBUTE5=>NULL,
X_DOC_ATTRIBUTE6=>NULL,
X_DOC_ATTRIBUTE7=>NULL,
X_DOC_ATTRIBUTE8=>NULL,
X_DOC_ATTRIBUTE9=>NULL,
X_DOC_ATTRIBUTE10=>NULL,
X_CREATE_DOC=>'N');