[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select b.jtf_note_id
FROM jtf_notes_b b
WHERE b.source_object_id IN
(select quote_header_id from aso_quote_headers_all
where quote_number = (select quote_number from aso_quote_headers_all
where quote_header_id = p_object_id))
AND b.source_object_code = 'ASO_QUOTE';
p_last_update_date => l_sysdate ,
p_last_updated_by => FND_Global.USER_ID ,
p_creation_date => l_sysdate ,
p_created_by => FND_Global.USER_ID ,
p_last_update_login => FND_GLOBAL.LOGIN_ID ,
p_note_context_type_id => p_new_object_id ,
p_note_context_type => p_new_object_type_code ,
x_note_context_id => lx_jtf_note_context_id
);
select b.jtf_note_id
FROM jtf_notes_b b, jtf_notes_tl t
WHERE b.source_object_id = p_object_id
AND b.source_object_code = p_object_type_code
AND b.jtf_note_id = t.jtf_note_id
AND t.language = USERENV('LANG')
AND ( EXISTS ( SELECT o.object_id
FROM jtf_object_mappings o
WHERE o.object_id = b.note_type
AND o.source_object_code = 'ASO_QUOTE' )
OR NOT EXISTS ( SELECT om.object_id
FROM JTF_OBJECT_MAPPINGS om
WHERE om.object_id = b.note_type )
);
p_last_update_date => l_sysdate ,
p_last_updated_by => FND_Global.USER_ID ,
p_creation_date => l_sysdate ,
p_created_by => FND_Global.USER_ID ,
p_last_update_login => FND_GLOBAL.LOGIN_ID ,
p_note_context_type_id => p_new_object_id ,
p_note_context_type => p_new_object_type_code ,
x_note_context_id => lx_jtf_note_context_id
);
SELECT b.parent_note_id,
b.jtf_note_id ,
t.notes ,
b.note_status ,
b.attribute1 ,
b.attribute2 ,
b.attribute3 ,
b.attribute4 ,
b.attribute5 ,
b.attribute6 ,
b.attribute7 ,
b.attribute8 ,
b.attribute9 ,
b.attribute10 ,
b.attribute11 ,
b.attribute12 ,
b.attribute13 ,
b.attribute14 ,
b.attribute15 ,
b.context ,
b.note_type
FROM jtf_notes_b b, jtf_notes_tl t
WHERE b.source_object_id IN
(select quote_header_id from aso_quote_headers_all
where quote_number = (select quote_number from aso_quote_headers_all
where quote_header_id = p_object_id))
AND b.source_object_code = p_object_type_code
AND b.jtf_note_id = t.jtf_note_id
AND t.language = USERENV('LANG');
p_last_update_date => l_sysdate ,
p_last_updated_by => FND_Global.USER_ID ,
p_creation_date => l_sysdate ,
p_attribute1 => l_note_rec.attribute1 ,
p_attribute2 => l_note_rec.attribute2 ,
p_attribute3 => l_note_rec.attribute3 ,
p_attribute4 => l_note_rec.attribute4 ,
p_attribute5 => l_note_rec.attribute5 ,
p_attribute6 => l_note_rec.attribute6 ,
p_attribute7 => l_note_rec.attribute7 ,
p_attribute8 => l_note_rec.attribute8 ,
p_attribute9 => l_note_rec.attribute9 ,
p_attribute10 => l_note_rec.attribute10 ,
p_attribute11 => l_note_rec.attribute11 ,
p_attribute12 => l_note_rec.attribute12 ,
p_attribute13 => l_note_rec.attribute13 ,
p_attribute14 => l_note_rec.attribute14 ,
p_attribute15 => l_note_rec.attribute15 ,
p_context => l_note_rec.context ,
p_note_type => l_note_rec.note_type ,
p_jtf_note_contexts_tab => l_jtf_note_contexts_tab
);