[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
B.TABLE_NAME,
B.PARAGRAPH_CODE,
B.SUB_PARACODE,
B.PARA_DESC
FROM SY_PARA_CDS_VL B
WHERE B.TABLE_NAME=x_table_name;
SELECT
T.LANG_CODE,
T.PARA_DESC,
T.SOURCE_LANG,
T.LANGUAGE
FROM SY_PARA_CDS_TL T, FND_LANGUAGES L
WHERE t.TABLE_NAME=x_table_name
AND t.paragraph_code = x_paragraph_code
AND t.sub_paracode = x_sub_paracode
AND t.language = l.language_code
ORDER BY installed_flag;
SELECT attachment_function_id
into l_attachment_function_id
FROM fnd_attachment_functions
WHERE attachment_function_id
in(SELECT attachment_function_id
from fnd_attachment_blocks
WHERE attachment_blk_id
in(SELECT attachment_Blk_id
from fnd_attachment_blk_entities
WHERE data_object_code
in(SELECT data_object_code
from fnd_document_entities
WHERE UPPER(table_name) in(p_table_name)
)
)
)
AND upper(FUNCTION_NAME)=p_form_short_name
AND FUNCTION_TYPE='O';
SELECT
L.LANGUAGE_CODE,
B.PARAGRAPH_CODE,
B.SUB_PARACODE,
B.PARA_DESC,
B.language
FROM SY_PARA_CDS_TL B, FND_LANGUAGES L
WHERE L.INSTALLED_FLAG IN ('B')
AND B.PARAGRAPH_CODE=x_paragraph_code
AND B.SUB_PARACODE=x_sub_paracode
AND B.TABLE_NAME=x_table_name --'IC_ITEM_MST'
AND B.LANGUAGE=L.LANGUAGE_CODE;
SELECT
DOCUMENT_ID,
FILE_NAME,
MEDIA_ID
FROM FND_DOCUMENTS
WHERE FILE_NAME=x_filename;
select PK1_FIELD,
PK2_FIELD,
PK3_FIELD,
PK4_FIELD,
PK5_FIELD
into p_pk1_value,
p_pk2_value,
p_pk3_value,
p_pk4_value,
p_pk5_value
from fnd_attachment_blk_entities
where data_object_code=p_table_name
and attachment_blk_id=
(SELECT attachment_blk_id
FROM fnd_attachment_blocks
WHERE attachment_function_id=p_attachment_function_id
AND block_name=p_table_name);
l_sql_stmt := 'SELECT DISTINCT language,
paragraph_code,
sub_paracode,
lang_code
FROM '||P_text_tl_table||'
WHERE text_code=:P_text_code
AND paragraph_code=:P_paragraph_code
AND sub_paracode=:P_sub_paracode
ORDER BY LANGUAGE';
l_sql_stmt1 := 'SELECT filename,
FROM FND_DOCUMENT_TL
WHERE filename=:P_filename
AND language=:P_language';
UPDATE FND_LANGUAGES
set installed_flag='I'
WHERE
language_code=l_language
AND installed_flag not in('I','B');
SELECT category_id,
application_id
INTO l_category_id,
l_application_id
FROM fnd_document_categories_vl
WHERE user_name = p_user_name;
SELECT fnd_document_categories_s.nextval
INTO l_category_id
FROM dual;
fnd_doc_categories_pkg.insert_row
(
X_ROWID => l_Rowid,
X_CATEGORY_ID => l_category_id,
X_APPLICATION_ID => l_application_id,
X_NAME => p_category_name,
X_START_DATE_ACTIVE => null,
X_END_DATE_ACTIVE => null,
X_ATTRIBUTE_CATEGORY => null,
X_ATTRIBUTE1 => l_attribute1_value,
X_ATTRIBUTE2 => l_attribute2_value,
X_ATTRIBUTE3 => l_attribute3_value,
X_ATTRIBUTE4 => l_attribute4_value,
X_ATTRIBUTE5 => l_attribute5_value,
X_ATTRIBUTE6 => l_attribute6_value,
X_ATTRIBUTE7 => l_attribute7_value,
X_ATTRIBUTE8 => l_attribute8_value,
X_ATTRIBUTE9 => l_attribute9_value,
X_ATTRIBUTE10 => l_attribute10_value,
X_ATTRIBUTE11 => l_attribute11_value,
X_ATTRIBUTE12 => l_attribute12_value,
X_ATTRIBUTE13 => l_attribute13_value,
X_ATTRIBUTE14 => l_attribute14_value,
X_ATTRIBUTE15 => l_attribute15_value,
X_DEFAULT_DATATYPE_ID => 1, -- Short Text
X_USER_NAME => l_user_name,
X_CREATION_DATE => l_sysdate,
X_CREATED_BY => FND_GLOBAL.login_id,
X_LAST_UPDATE_DATE => l_sysdate,
X_LAST_UPDATED_BY => FND_GLOBAL.login_id,
X_LAST_UPDATE_LOGIN => FND_GLOBAL.login_id);
select doc_category_usage_id
INTO l_doc_category_usage_id
from fnd_doc_category_usages
WHERE category_id = p_category_id
and attachment_function_id=p_attachment_function_id;
select fnd_doc_category_usages_s.nextval
into l_doc_category_usage_id
from dual;
INSERT INTO FND_DOC_CATEGORY_USAGES
(DOC_CATEGORY_USAGE_ID,
CATEGORY_ID,
ATTACHMENT_FUNCTION_ID,
ENABLED_FLAG,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_LOGIN)
VALUES (l_doc_category_usage_id,
p_category_id,
p_attachment_function_id,
'Y',
l_sysdate,
l_user_id,
l_sysdate,
l_user_id,
l_user_id);
SELECT FND_ATTACHED_DOCUMENTS_S.nextval
FROM dual;
SELECT 1
FROM FND_ATTACHED_DOCUMENTS
WHERE document_id = l_id;
fnd_attached_documents_pkg.Insert_Row
( x_rowid => l_row_id,
X_attached_document_id => l_attached_document_ID,
X_document_id => x_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.CONC_LOGIN_ID,
X_seq_num => p_sequence_num,
X_entity_name => p_entity_name, --'GMA Migration',
x_column1 => null,
X_pk1_value => p_pk1_value,
X_pk2_value => p_pk2_value,
X_pk3_value => p_pk3_value,
X_pk4_value => p_pk4_value,
X_pk5_value => p_pk5_value,
X_automatically_added_flag => 'N',
X_datatype_id => 1,
X_category_id => l_category_id,
X_security_type => 1,
X_publish_flag => 'Y',
X_usage_type => 'O', -- May be changed as checked for attachment
X_language => null,
X_description => x_description, --'General Text',
X_file_name => p_file_name,
X_media_id => x_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_doc_attribute11 => null,
X_doc_attribute12 => null,
X_doc_attribute13 => null,
X_doc_attribute14 => null,
X_doc_attribute15 => null
);
l_sql_stmt := 'SELECT text '||
' FROM ' || p_text_tl_table ||
' WHERE text_code= :x_Text_Code '||
' AND paragraph_code=:x_paragraph_code'||
' AND sub_paracode= :x_sub_paracode '||
' AND language= :x_language '||
' AND line_no>-1' ||
' ORDER BY line_no';
INSERT INTO
fnd_documents_short_text
(
MEDIA_ID,
APP_SOURCE_VERSION,
SHORT_TEXT
)
VALUES
(
l_file_id,
NULL,
l_long_text
);
l_sql_stmt := ' SELECT 1 '||
' FROM '||P_text_tl_table||
' WHERE text_code=:1 '||
' AND paragraph_code=:2 '||
' AND sub_paracode=:3';