[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ATT.DESCRIPTION,
decode(ATB.FLEX_VALUE_SET_ID, null, INFO.ATTRIBUTE_VALUE,
(select VTL.FLEX_VALUE_MEANING
from FND_FLEX_VALUES VAL,
FND_FLEX_VALUES_TL VTL
where INFO.ATTRIBUTE_VALUE = VAL.FLEX_VALUE
AND VAL.FLEX_VALUE_SET_ID = ATB.FLEX_VALUE_SET_ID
AND VAL.FLEX_VALUE_ID = VTL.FLEX_VALUE_ID
AND VTL.LANGUAGE = NVL(p_preparer_language, USERENV('LANG')))) value,
TMPT.TEMPLATE_NAME
FROM POR_TEMPLATE_INFO INFO,
POR_TEMPLATES_ALL_B TMPB,
POR_TEMPLATES_ALL_TL TMPT,
POR_TEMPLATE_ATTRIBUTES_B ATB,
POR_TEMPLATE_ATTRIBUTES_TL ATT
WHERE INFO.REQUISITION_LINE_ID = p_requisition_line_id
AND INFO.ATTRIBUTE_CODE = ATB.ATTRIBUTE_CODE
AND TMPB.ATTACHMENT_CATEGORY_ID = p_category_id
AND TMPB.TEMPLATE_CODE = TMPT.TEMPLATE_CODE
AND TMPT.LANGUAGE = NVL(p_preparer_language, USERENV('LANG'))
AND TMPB.TEMPLATE_CODE = ATB.TEMPLATE_CODE
AND ATB.ATTRIBUTE_CODE = ATT.ATTRIBUTE_CODE
AND ATT.LANGUAGE = NVL(p_preparer_language, USERENV('LANG'))
ORDER BY
TMPB.TEMPLATE_CODE, ATB.SEQUENCE;
SELECT porl.requisition_header_id,
porl.requisition_line_id,
NVL(MAX(porl.created_by), 1) AS created_by
FROM por_template_info pti,
po_requisition_lines_all porl
WHERE porl.requisition_header_id = p_req_header_id
AND porl.requisition_line_id = pti.requisition_line_id
GROUP BY porl.requisition_header_id,
porl.requisition_line_id;
select attach.attached_document_id,attach.seq_num
into l_attachment_id,l_seq_num --Get l_seq_num to pass it to update_attachment 2451462.
from fnd_attached_documents attach, fnd_documents doc
where attach.document_id = doc.document_id
and doc.category_id = 33
and attach.entity_name = 'REQ_LINES'
and attach.pk1_value=to_char(c_req_id_cur.requisition_line_id)
and attach.pk2_value='INFO_TEMPLATE';
fnd_webattch.update_attachment(
seq_num => l_seq_num ,
category_id => 33 , -- to supplier
document_description => l_to_supplier_name ,
datatype_id => 2 ,
text => l_to_supplier_text ,
file_name => l_file_name ,
url => NULL ,
function_name => 'PO_POXRQERQ' ,
entity_name => 'REQ_LINES' ,
pk1_value => to_char(c_req_id_cur.requisition_line_id) ,
pk2_value => 'INFO_TEMPLATE' ,
pk3_value => NULL ,
pk4_value => NULL ,
pk5_value => NULL ,
media_id => NULL ,
user_id => c_req_id_cur.created_by ,
ATTACHED_DOCUMENT_ID => l_attachment_id);
SELECT MAX(seq_num)
INTO l_seq_num
FROM fnd_attached_documents
WHERE pk1_value = to_char(c_req_id_cur.requisition_line_id)
AND entity_name = 'REQ_LINES';
select attach.attached_document_id,attach.seq_num
into l_attachment_id,l_seq_num --Get l_seq_num to pass it to update_attachment 2451462.
from fnd_attached_documents attach, fnd_documents doc
where attach.document_id = doc.document_id
and doc.category_id = 34 -- to buyer
and attach.entity_name = 'REQ_LINES'
and attach.pk1_value=to_char(c_req_id_cur.requisition_line_id)
and attach.pk2_value='INFO_TEMPLATE';
fnd_webattch.update_attachment(
seq_num => l_seq_num ,
category_id => 34 ,
document_description => l_to_buyer_name ,
datatype_id => 2 ,
text => l_to_buyer_text ,
file_name => l_file_name ,
url => NULL ,
function_name => 'PO_POXRQERQ' ,
entity_name => 'REQ_LINES' ,
pk1_value => to_char(c_req_id_cur.requisition_line_id) ,
pk2_value => 'INFO_TEMPLATE' ,
pk3_value => NULL ,
pk4_value => NULL ,
pk5_value => NULL ,
media_id => NULL ,
user_id => c_req_id_cur.created_by ,
ATTACHED_DOCUMENT_ID => l_attachment_id);
SELECT MAX(seq_num)
INTO l_seq_num
FROM fnd_attached_documents
WHERE pk1_value = to_char(c_req_id_cur.requisition_line_id)
AND entity_name = 'REQ_LINES';