DBA Data[Home] [Help]

APPS.POR_IFT_INFO_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 137: from fnd_attached_documents attach, fnd_documents doc

133: BEGIN
134: -- update existing attachment
135: select attach.attached_document_id,attach.seq_num
136: into l_attachment_id,l_seq_num --Get l_seq_num to pass it to update_attachment 2451462.
137: from fnd_attached_documents attach, fnd_documents doc
138: where attach.document_id = doc.document_id
139: and doc.category_id = 33
140: and attach.entity_name = 'REQ_LINES'
141: and attach.pk1_value=to_char(c_req_id_cur.requisition_line_id)

Line 170: FROM fnd_attached_documents

166: l_seq_num := 0;
167:
168: SELECT MAX(seq_num)
169: INTO l_seq_num
170: FROM fnd_attached_documents
171: WHERE pk1_value = to_char(c_req_id_cur.requisition_line_id)
172: AND entity_name = 'REQ_LINES';
173:
174: IF l_seq_num is null THEN

Line 206: from fnd_attached_documents attach, fnd_documents doc

202: BEGIN
203: -- update existing attachment
204: select attach.attached_document_id,attach.seq_num
205: into l_attachment_id,l_seq_num --Get l_seq_num to pass it to update_attachment 2451462.
206: from fnd_attached_documents attach, fnd_documents doc
207: where attach.document_id = doc.document_id
208: and doc.category_id = 34 -- to buyer
209: and attach.entity_name = 'REQ_LINES'
210: and attach.pk1_value=to_char(c_req_id_cur.requisition_line_id)

Line 239: FROM fnd_attached_documents

235: l_seq_num := 0;
236:
237: SELECT MAX(seq_num)
238: INTO l_seq_num
239: FROM fnd_attached_documents
240: WHERE pk1_value = to_char(c_req_id_cur.requisition_line_id)
241: AND entity_name = 'REQ_LINES';
242:
243: IF l_seq_num is null THEN