DBA Data[Home] [Help]

APPS.POR_IFT_INFO_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 138: from fnd_attached_documents attach, fnd_documents doc

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

Line 177: FROM fnd_attached_documents

173: l_seq_num := 0;
174:
175: SELECT MAX(seq_num)
176: INTO l_seq_num
177: FROM fnd_attached_documents
178: WHERE pk1_value = to_char(c_req_id_cur.requisition_line_id)
179: AND entity_name = 'REQ_LINES';
180:
181: IF l_seq_num is null THEN

Line 220: from fnd_attached_documents attach, fnd_documents doc

216: BEGIN
217: -- update existing attachment
218: select attach.attached_document_id,attach.seq_num
219: into l_attachment_id,l_seq_num --Get l_seq_num to pass it to update_attachment 2451462.
220: from fnd_attached_documents attach, fnd_documents doc
221: where attach.document_id = doc.document_id
222: and doc.category_id = 34 -- to buyer
223: and attach.entity_name = 'REQ_LINES'
224: and attach.pk1_value=to_char(c_req_id_cur.requisition_line_id)

Line 259: FROM fnd_attached_documents

255: l_seq_num := 0;
256:
257: SELECT MAX(seq_num)
258: INTO l_seq_num
259: FROM fnd_attached_documents
260: WHERE pk1_value = to_char(c_req_id_cur.requisition_line_id)
261: AND entity_name = 'REQ_LINES';
262:
263: IF l_seq_num is null THEN