[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
fnd_documents_pkg.insert_row(:1,:2,:3,:4,:5,:6,
:7,:8,:9,:10,:11,:12,
NULL,
NULL,
:13,
NULL,
NULL,
NULL,
NULL,
NULL,
:14,
:15,
:16,
NULL,
:17,
NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL);
l_dynamic_sql_str0 := 'SELECT fnd_lobs_s.nextval FROM dual';
l_dynamic_sql_str3 := 'INSERT INTO fnd_lobs
(file_id, file_name, file_content_type, upload_date,
expiration_date, program_name, program_tag,
file_data, language, oracle_charset, file_format)
VALUES (:1, :2, :3, NULL, :4, :5, :6,
:7, :8, :9, :10)';
l_dynamic_sql_str4 := 'SELECT fnd_documents_s.nextval FROM dual';
l_dynamic_sql_str5 := 'SELECT MAX(seq_num)
FROM fnd_attached_documents
WHERE pk1_value =''' || EMBEDDED_FND_KEY1 || ''' AND
entity_name =''' || EMBEDDED_ECX_ENTITY_NAME || '''';
l_dynamic_sql_str6 := 'SELECT fnd_attached_documents_s.nextval FROM dual';
l_dynamic_sql_str7 := 'INSERT INTO fnd_attached_documents
(attached_document_id,
document_id,
creation_date,
created_by,
last_update_date,
last_updated_by,
last_update_login,
seq_num,
entity_name,
pk1_value, pk2_value, pk3_value,
pk4_value, pk5_value,
automatically_added_flag,
program_application_id, program_id,
program_update_date, request_id,
attribute_category, attribute1,
attribute2, attribute3, attribute4,
attribute5, attribute6, attribute7,
attribute8, attribute9, attribute10,
attribute11, attribute12, attribute13,
attribute14, attribute15, column1)
VALUES
(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10,
:11, NULL, NULL, NULL,
:12, :13, :14, :15, :16,
NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL,
NULL)';
l_dynamic_sql_str0 := 'SELECT file_name
FROM fnd_lobs
WHERE file_id = ' || i_file_id;
INSERT INTO ecx_attachment_maps
(msgid,
cid,
fid,
dataType,
orderIndex,
nestParentIndex)
VALUES
(i_msgid,
l_records(i).cid,
l_records(i).fid,
l_records(i).dataType,
i,
0 -- 0 refers to the main doc
);
INSERT INTO ecx_attachment_maps
(msgid,
cid,
fid,
dataType,
orderIndex,
nestParentIndex)
VALUES
(i_msgid,
l_records(i).cid,
l_records(i).fid,
l_records(i).dataType,
i,
0 -- 0 refers to the main doc
);
SELECT *
FROM ecx_attachment_maps
WHERE MSGID = msgid;
SELECT msgId
INTO l_in_aqMsgid
FROM ecx_doclogs
WHERE OUT_MSGID = i_msgid;
INSERT INTO ecx_attachment_maps (msgId,
cId,
fId,
dataType,
orderIndex,
nestParentIndex
)
VALUES
(
i_msgid,
l_map_row.cId,
l_map_row.fId,
l_map_row.dataType,
l_map_row.orderIndex,
l_map_row.nestParentIndex
);
SELECT fid, datatype
INTO l_file_id, l_datatype
FROM ecx_attachment_maps
WHERE msgid = i_msgid AND cid = i_cid;
l_dynamic_sql_str0 := 'SELECT file_name, file_content_type,
file_data, oracle_charset, file_format
FROM fnd_lobs
WHERE file_id = ' || l_file_id;
SELECT fid, datatype
INTO l_file_id, l_datatype
FROM ecx_attachment_maps
WHERE msgid = i_msgid AND cid = i_cid;
l_dynamic_sql_str0 := 'SELECT file_name, file_content_type,
file_data, oracle_charset, file_format,
language
FROM fnd_lobs
WHERE file_id = ' || l_file_id;
l_dynamic_sql_str0 := 'SELECT file_name, file_content_type,
file_data, oracle_charset, file_format,
language
FROM fnd_lobs
WHERE file_id = ' || i_file_id;
SELECT fid, datatype
INTO l_file_id, l_datatype
FROM ecx_attachment_maps
WHERE msgid = i_msgid AND cid = i_cid;
l_dynamic_sql_str1 := 'SELECT DISTINCT document_id
FROM fnd_Documents_tl
WHERE media_id = ' || l_file_id;
l_dynamic_sql_str0 := 'UPDATE fnd_attached_documents SET
entity_name = :1,
pk1_value = :2,
pk2_value = :3,
pk3_value = :4,
pk4_value = :5,
pk5_value = :6,
program_application_id = :7,
program_id = :8,
request_id = :9
WHERE document_id = :10';