[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wd.name
, o.name
FROM oke_k_form_headers kfh
, wsh_deliveries wd
, hr_all_organization_units_tl o
WHERE kfh.form_header_id = C_Form_Header_ID
AND wd.delivery_id = kfh.reference1
AND o.organization_id = wd.organization_id
AND o.language = userenv('LANG');
SELECT form_header_number
, print_form_code
, k_header_id
, fnd_attached_documents_s.nextval attached_document_id
FROM oke_k_form_headers
WHERE form_header_id = FormHeaderID;
SELECT nvl(max(seq_num) , 0) + 1
INTO SeqNum
FROM fnd_attached_documents
WHERE entity_name = 'OKE_K_FORM_HEADERS'
AND pk1_value = frec.print_form_code
AND pk2_value = to_char(frec.k_header_id)
AND pk3_value is null;
fnd_attached_documents_pkg.insert_row
( X_ROWID => RowID
, X_ATTACHED_DOCUMENT_ID => frec.attached_document_id
, X_DOCUMENT_ID => DocumentID
, 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.login_id
, X_SEQ_NUM => SeqNum
, X_ENTITY_NAME => 'OKE_K_FORM_HEADERS'
, X_COLUMN1 => NULL
, X_PK1_VALUE => frec.print_form_code
, X_PK2_VALUE => frec.k_header_id
, X_PK3_VALUE => NULL
, X_PK4_VALUE => NULL
, X_PK5_VALUE => NULL
, X_AUTOMATICALLY_ADDED_FLAG => 'Y'
, X_DATATYPE_ID => 5
, X_CATEGORY_ID => 1
, X_SECURITY_TYPE => 4
, X_PUBLISH_FLAG => 'Y'
, X_USAGE_TYPE => 'O'
, X_LANGUAGE => userenv('LANG')
, X_DESCRIPTION => AttachmentDesc
, X_FILE_NAME => FileName
, X_MEDIA_ID => MediaID
, X_CREATE_DOC => 'Y'
);