[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO l_exists
FROM fnd_doc_category_usages fdcu,
fnd_documents fd,
fnd_attachment_functions af,
fnd_attached_documents fad
WHERE fad.entity_name = l_entity_name
AND fad.pk1_value = l_pkey1
AND fad.pk2_value = l_pkey2
AND fad.pk3_value = l_pkey3
AND (l_pkey4 IS NULL
OR fad.pk4_value = l_pkey4)
AND (l_pkey5 IS NULL
OR fad.pk5_value = l_pkey5)
AND fad.document_id = fd.document_id
AND fd.category_id = fdcu.category_id
AND fdcu.attachment_function_id = af.attachment_function_id
AND fdcu.enabled_flag = 'Y'
and exists (select 'x' from fnd_attachment_functions af
where af.function_type = l2_function_type
AND af.function_name = l2_function_name
AND fdcu.attachment_function_id = af.attachment_function_id)
AND ROWNUM = 1;
SELECT 'Y'
INTO l_exists
FROM fnd_doc_category_usages fdcu,
fnd_documents fd,
fnd_attached_documents fad,
fnd_attachment_functions af
WHERE fad.entity_name = l_entity_name
AND fad.pk1_value = l_pkey1
AND fad.pk2_value = l_pkey2
AND (l_pkey3 IS NULL
OR fad.pk3_value = l_pkey3)
AND (l_pkey4 IS NULL
OR fad.pk4_value = l_pkey4)
AND (l_pkey5 IS NULL
OR fad.pk5_value = l_pkey5)
AND fad.document_id = fd.document_id
AND fd.category_id = fdcu.category_id
AND fdcu.attachment_function_id = af.attachment_function_id
AND fdcu.enabled_flag = 'Y'
and exists (select 'x' from fnd_attachment_functions af
where af.function_type = l2_function_type
AND af.function_name = l2_function_name
AND fdcu.attachment_function_id = af.attachment_function_id)
AND ROWNUM = 1;
SELECT 'Y'
INTO l_exists
FROM fnd_doc_category_usages fdcu,
fnd_documents fd,
fnd_attached_documents fad,
fnd_attachment_functions af
WHERE fad.entity_name = l_entity_name
AND fad.pk1_value = l_pkey1
AND (l_pkey2 IS NULL
OR fad.pk2_value = l_pkey2)
AND (l_pkey3 IS NULL
OR fad.pk3_value = l_pkey3)
AND (l_pkey4 IS NULL
OR fad.pk4_value = l_pkey4)
AND (l_pkey5 IS NULL
OR fad.pk5_value = l_pkey5)
AND fad.document_id = fd.document_id
AND fd.category_id = fdcu.category_id
AND fdcu.attachment_function_id = af.attachment_function_id
AND fdcu.enabled_flag = 'Y'
and exists (select 'x' from fnd_attachment_functions af
where af.function_type = l2_function_type
AND af.function_name = l2_function_name
AND fdcu.attachment_function_id = af.attachment_function_id)
AND ROWNUM = 1;
l_sql_stmt := 'SELECT ''Y'' FROM dual WHERE EXISTS ('||
'SELECT 1 FROM fnd_attached_documents fad,'||
'fnd_doc_category_usages fdcu,'||
'fnd_attachment_functions af,'||
'fnd_documents fd '||
'WHERE fad.entity_name = :ename '||
'AND fad.document_id = fd.document_id '||
'AND fd.category_id = fdcu.category_id '||
'AND fdcu.attachment_function_id = af.attachment_function_id '||
'AND fdcu.enabled_flag = ''Y'' '||
'AND af.function_type = :function_type '||
'AND af.function_name = :function_name ';
SELECT count(*)
INTO m_rowcount
FROM fnd_attachment_functions
WHERE function_name = l_function_name
AND function_type = 'F';
SELECT function_name,
count(*)
INTO m_function_name,
m_rowcount
FROM fnd_attachment_functions
WHERE function_type = 'O'
AND (function_name, application_id) =
(SELECT distinct ff.form_name, ff.application_id
FROM fnd_form ff,
fnd_form_functions fff
WHERE ff.application_id = fff.application_id
AND ff.form_id = fff.form_id
AND fff.function_name = l_function_name)
GROUP BY function_name;
SELECT enabled_flag,session_context_field
INTO m_enabled_flag,m_session_context_field
FROM fnd_attachment_functions
WHERE function_name = l_function_name
AND function_type = 'F';
SELECT function_name,
enabled_flag,
session_context_field
INTO m_function_name,
m_enabled_flag,
m_session_context_field
FROM fnd_attachment_functions
WHERE function_type = 'O'
AND (function_name, application_id) =
(SELECT distinct ff.form_name, ff.application_id
FROM fnd_form ff,
fnd_form_functions fff
WHERE ff.application_id = fff.application_id
AND ff.form_id = fff.form_id
AND fff.function_name = l_function_name);
SELECT meaning
FROM fnd_lookup_values
WHERE lookup_type = 'ATCHMT_DOCUMENT_TYPE'
AND lookup_code = 'O';
SELECT user_entity_name
FROM fnd_document_entities_vl
WHERE data_object_code = X_entity_name;
SELECT category_id, user_name
FROM fnd_document_categories_vl
WHERE name = X_category_name;
'SELECT short_name FROM gl_sets_of_books '||
'WHERE set_of_books_id = :sob_id', dbms_sql.v7);
SELECT user_form_name
FROM fnd_form_vl
WHERE form_name = x_function_name
AND application_id = x_application_id;
SELECT user_function_name
FROM fnd_form_functions_vl
WHERE function_name = x_function_name;
SELECT user_concurrent_program_name
FROM fnd_concurrent_programs_vl
WHERE application_id = x_application_id
AND concurrent_program_name = x_function_name;
PROCEDURE update_file_metadata(X_file_id IN NUMBER DEFAULT NULL) IS
l_file_name varchar2(255);
select file_name,language
into l_file_name_lob, l_language
from fnd_lobs
where file_id = update_file_metadata.X_file_id ;
select document_id,file_name
into l_document_id,l_file_name_tl
from fnd_documents
where file_name like '%'||l_file_name ||'%';
update fnd_documents
set file_name = l_file_name,
media_id = update_file_metadata.X_file_id
where document_id = l_document_id;
update fnd_lobs
set file_content_type = l_content_type,
program_name = 'FNDATTCH',
file_format = fnd_gfm.set_file_format(l_content_type)
where file_id = X_file_id;
update_file_metadata.X_file_id);
END update_file_metadata;
update fnd_attached_documents
set pk1_value = p_to_fk_id
where pk1_value = p_from_fk_id
and entity_name = pen;
SELECT distinct CUSTOMER_MERGE_HEADER_ID
,PK1_VALUE
FROM FND_ATTACHED_DOCUMENTS yt, ra_customer_merges m
WHERE (
yt.PK1_VALUE = m.DUPLICATE_ID
AND yt.entity_name = 'AR_CUSTOMERS'
) AND m.process_flag = 'N'
AND m.request_id = req_id
AND m.set_number = set_num;
INSERT INTO HZ_CUSTOMER_MERGE_LOG (
MERGE_LOG_ID,
TABLE_NAME,
MERGE_HEADER_ID,
NUM_COL1_ORIG,
NUM_COL1_NEW,
ACTION_FLAG,
REQUEST_ID,
CREATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
LAST_UPDATE_DATE,
LAST_UPDATED_BY
) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
'FND_ATTACHED_DOCUMENTS',
MERGE_HEADER_ID_LIST(I),
NUM_COL1_ORIG_LIST(I),
NUM_COL1_NEW_LIST(I),
'U',
req_id,
hz_utility_pub.CREATED_BY,
hz_utility_pub.CREATION_DATE,
hz_utility_pub.LAST_UPDATE_LOGIN,
hz_utility_pub.LAST_UPDATE_DATE,
hz_utility_pub.LAST_UPDATED_BY
);
UPDATE FND_ATTACHED_DOCUMENTS yt SET
PK1_VALUE=NUM_COL1_NEW_LIST(I)
, SEQ_NUM = seq_num+1
, LAST_UPDATE_DATE=SYSDATE
, last_updated_by=arp_standard.profile.user_id
, last_update_login=arp_standard.profile.last_update_login
, REQUEST_ID=req_id
, PROGRAM_APPLICATION_ID=arp_standard.profile.program_application_id
, PROGRAM_ID=arp_standard.profile.program_id
, PROGRAM_UPDATE_DATE=SYSDATE
WHERE yt.entity_name = 'AR_CUSTOMERS'
AND yt.pk1_value = NUM_COL1_ORIG_LIST(I)
;
arp_message.set_name('AR','AR_ROWS_UPDATED');