[Home] [Help]
65: attach.PROGRAM_UPDATE_DATE,
66: attach.REQUEST_ID,
67: attach.CATEGORY_ID,
68: ORIG_ATTACH_DOC_ID
69: FROM fnd_attached_documents attach, fnd_documents_tl doc
70: WHERE pk1_value = l_attachment_pk1
71: AND attach.document_id = doc.document_id
72: AND doc.title = p_input_url
73: AND doc.LANGUAGE = 'US'
76: CURSOR c_last_attachment IS
77: SELECT * from
78: (SELECT ATTACHED_DOCUMENT_ID,
79: DOCUMENT_ID
80: FROM fnd_attached_documents
81: WHERE pk1_value = To_Char(p_document_id)
82: AND Nvl(pk2_value,'-1') = Nvl(To_Char(p_draft_id),'-1')
83: ORDER BY last_update_date DESC)
84: WHERE ROWNUM=1;
89: x_document_id NUMBER:=NULL;
90:
91: CURSOR c_get_max_attach_seq IS
92: SELECT Nvl(Max(seq_num),0) maxseq
93: FROM fnd_attached_documents
94: WHERE pk1_value = l_attachment_pk1;
95:
96: l_seq_num number := 0;
97: l_media_id NUMBER;
153: ELSE
154: l_attachment_pk1 := p_document_id||'-'||p_draft_id;
155: END IF;
156:
157: SELECT fnd_attached_documents_s.nextval
158: INTO x_attached_document_id
159: FROM dual;
160:
161: open c_get_max_attach_seq;
165: l_seq_num := l_seq_num + 1;
166:
167: select decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
168:
169: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
170: X_attached_document_id => x_attached_document_id,
171: X_document_id => X_document_id,
172: X_creation_date => SYSDATE,
173: X_created_by => Fnd_Global.User_Id,
311: attach.PROGRAM_UPDATE_DATE,
312: attach.REQUEST_ID,
313: attach.CATEGORY_ID,
314: ORIG_ATTACH_DOC_ID
315: FROM fnd_attached_documents attach, fnd_documents_tl doc
316: WHERE pk1_value = l_attachment_pk1
317: AND attach.document_id = doc.document_id
318: AND doc.title = l_input_url
319: AND doc.LANGUAGE = 'US'
322: CURSOR c_last_attachment IS
323: SELECT * from
324: (SELECT ATTACHED_DOCUMENT_ID,
325: DOCUMENT_ID
326: FROM fnd_attached_documents
327: WHERE pk1_value = To_Char(l_doc_id)
328: AND Nvl(pk2_value,'-1') = Nvl(To_Char(l_draft_id),'-1')
329: ORDER BY last_update_date DESC)
330: WHERE ROWNUM=1;
335: x_document_id NUMBER:=NULL;
336:
337: CURSOR c_get_max_attach_seq IS
338: SELECT Max(seq_num) maxseq
339: FROM fnd_attached_documents
340: WHERE pk1_value = l_attachment_pk1;
341:
342: l_seq_num number := 0;
343: l_media_id NUMBER;
356: ELSE
357: l_attachment_pk1 := l_doc_id||'-'||l_draft_id;
358: END IF;
359:
360: SELECT fnd_attached_documents_s.nextval
361: INTO x_attached_document_id
362: FROM dual;
363:
364: open c_get_max_attach_seq;
369:
370: select decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
371:
372:
373: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
374: X_attached_document_id => x_attached_document_id,
375: X_document_id => X_document_id,
376: X_creation_date => SYSDATE,
377: X_created_by => Fnd_Global.User_Id,
405: FOR c IN c_get_WDOL_attachment LOOP
406:
407: l_attachment_found := 'Y';
408:
409: fnd_attached_documents2_pkg.copy_attachments(
410: X_from_entity_name => c.ENTITY_NAME,
411: X_from_pk1_value => c.pk1_value,
412: X_from_pk2_value => c.pk2_value,
413: X_from_pk3_value => c.pk3_value,
550: l_enable_wdol VARCHAR2(1);
551:
552: CURSOR c_wdol_attachment_exists IS
553: SELECT 'Y'
554: FROM fnd_attached_documents attach, fnd_documents_tl doc
555: WHERE pk1_value = To_Char(p_auction_header_id)
556: AND attach.document_id = doc.document_id
557: AND doc.title = 'Wage Determination Statement'
558: AND doc.description = 'WD Statement URL'