eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_DRAFTS_PVT dependencies on FND_ATTACHED_DOCUMENTS

Line 8211: from fnd_attached_documents fad, fnd_documents fd

8207: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8208: -- to undo the changes for these attachments. Hence skipping this category in revert
8209: cursor get_to_be_deleted_attachments(p_header_id NUMBER,p_draft_id NUMBER, p_entity_name VARCHAR2) is
8210: select fad.attached_document_id , fd.datatype_id
8211: from fnd_attached_documents fad, fnd_documents fd
8212: where fad.entity_name = p_entity_name
8213: and fad.pk1_value = to_char(p_header_id) || '-' || to_char(p_draft_id)
8214: AND fd.document_id = fad.document_id
8215: AND fad.category_id <> (SELECT category_id

Line 8273: fnd_attached_documents3_pkg.delete_row

8269: -- Bug 13938456
8270: --Delete header level attachments other tham modifictaion specific attachments
8271: FOR l_rec in get_to_be_deleted_attachments(p_po_header_id,p_draft_id,'PO_HEADERS')
8272: LOOP
8273: fnd_attached_documents3_pkg.delete_row
8274: ( X_attached_document_id => l_rec.attached_document_id,
8275: X_datatype_id => l_rec.datatype_id,
8276: delete_document_flag => 'Y'
8277: );

Line 8282: fnd_attached_documents3_pkg.delete_row

8278: END LOOP;
8279:
8280: FOR l_rec in get_to_be_deleted_attachments(p_po_header_id,p_draft_id,'PO_HEADERS_DEL')
8281: LOOP
8282: fnd_attached_documents3_pkg.delete_row
8283: ( X_attached_document_id => l_rec.attached_document_id,
8284: X_datatype_id => l_rec.datatype_id,
8285: delete_document_flag => 'Y'
8286: );

Line 8394: from fnd_attached_documents fad, fnd_documents fd

8390: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8391: -- to undo the changes for these attachments. Hence skipping this category in revert
8392: cursor get_to_be_deleted_attachments(p_line_location_id NUMBER,p_draft_id NUMBER, p_entity_name VARCHAR2) is
8393: select fad.attached_document_id , fd.datatype_id
8394: from fnd_attached_documents fad, fnd_documents fd
8395: where fad.entity_name = p_entity_name
8396: and fad.pk1_value = to_char(p_line_location_id) || '-' || to_char(p_draft_id)
8397: AND fd.document_id = fad.document_id
8398: AND fad.category_id <> (SELECT category_id

Line 8449: fnd_attached_documents3_pkg.delete_row

8445: --Bug 13938456
8446: --Delete shipment level attachments other tham modifictaion specific attachments
8447: FOR itr IN 1..po_ship_ids_tbl.Count LOOP
8448: FOR l_rec in get_to_be_deleted_attachments(po_ship_ids_tbl(itr),p_po_draft_id,'PO_SHIPMENTS') LOOP
8449: fnd_attached_documents3_pkg.delete_row
8450: ( X_attached_document_id => l_rec.attached_document_id,
8451: X_datatype_id => l_rec.datatype_id,
8452: delete_document_flag => 'Y'
8453: );

Line 8457: fnd_attached_documents3_pkg.delete_row

8453: );
8454: END LOOP;
8455:
8456: FOR l_rec in get_to_be_deleted_attachments(po_ship_ids_tbl(itr),p_po_draft_id,'PO_SHIPMENTS_DEL') LOOP
8457: fnd_attached_documents3_pkg.delete_row
8458: ( X_attached_document_id => l_rec.attached_document_id,
8459: X_datatype_id => l_rec.datatype_id,
8460: delete_document_flag => 'Y'
8461: );

Line 8496: from fnd_attached_documents fad, fnd_documents fd

8492: --Category CUSTOM5340 corresponds to Modification Specific Exception. The user can use delete option
8493: -- to undo the changes for these attachments. Hence skipping this category in revert
8494: cursor get_to_be_deleted_attachments(p_line_id NUMBER,p_draft_id NUMBER,p_entity_name VARCHAR2) is
8495: select fad.attached_document_id , fd.datatype_id
8496: from fnd_attached_documents fad, fnd_documents fd
8497: where fad.entity_name = p_entity_name
8498: and fad.pk1_value = to_char(p_line_id) || '-' || to_char(p_draft_id)
8499: AND fd.document_id = fad.document_id
8500: AND fad.category_id <> (SELECT category_id

Line 8586: fnd_attached_documents3_pkg.delete_row

8582: --Bug 13938456
8583: --Delete line level attachments other than modifictaion specific attachments
8584: FOR itr IN 1..po_line_ids_tbl.Count LOOP
8585: FOR l_rec in get_to_be_deleted_attachments(po_line_ids_tbl(itr),p_po_draft_id,'PO_LINES') LOOP
8586: fnd_attached_documents3_pkg.delete_row
8587: ( X_attached_document_id => l_rec.attached_document_id,
8588: X_datatype_id => l_rec.datatype_id,
8589: delete_document_flag => 'Y'
8590: );

Line 8594: fnd_attached_documents3_pkg.delete_row

8590: );
8591: END LOOP;
8592:
8593: FOR l_rec in get_to_be_deleted_attachments(po_line_ids_tbl(itr),p_po_draft_id,'PO_LINES_DEL') LOOP
8594: fnd_attached_documents3_pkg.delete_row
8595: ( X_attached_document_id => l_rec.attached_document_id,
8596: X_datatype_id => l_rec.datatype_id,
8597: delete_document_flag => 'Y'
8598: );

Line 8693: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

8689: AND draft_id = p_draft_id;
8690:
8691: --Bug 13938456
8692: FOR i IN 1..l_line_id_tbl.Count() LOOP
8693: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
8694: ( 'PO_LINES',
8695: l_line_id_tbl(i)||'-'||p_draft_id,
8696: '', '', '', '', '');
8697: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

Line 8697: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

8693: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
8694: ( 'PO_LINES',
8695: l_line_id_tbl(i)||'-'||p_draft_id,
8696: '', '', '', '', '');
8697: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
8698: ( 'PO_LINES_DEL',
8699: l_line_id_tbl(i)||'-'||p_draft_id,
8700: '', '', '', '', '');
8701: END LOOP;

Line 8756: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

8752: AND draft_id = p_draft_id;
8753:
8754: --Bug 13938456-
8755: FOR i IN 1..l_line_loc_id_tbl.Count() LOOP
8756: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
8757: ( 'PO_SHIPMENTS',
8758: l_line_loc_id_tbl(i)||'-'||p_draft_id,
8759: '', '', '', '', '');
8760: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

Line 8760: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

8756: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
8757: ( 'PO_SHIPMENTS',
8758: l_line_loc_id_tbl(i)||'-'||p_draft_id,
8759: '', '', '', '', '');
8760: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
8761: ( 'PO_SHIPMENTS_DEL',
8762: l_line_loc_id_tbl(i)||'-'||p_draft_id,
8763: '', '', '', '', '');
8764: END LOOP;

Line 9024: FROM FND_ATTACHED_DOCUMENTS

9020:
9021: BEGIN
9022:
9023: SELECT Count(*) INTO l_count
9024: FROM FND_ATTACHED_DOCUMENTS
9025: WHERE entity_name = p_entity_name
9026: AND pk1_value = p_po_header_id||'-'|| p_po_draft_id
9027: AND category_id <> (SELECT category_id
9028: FROM fnd_document_categories_vl

Line 9043: -- also, it call another prcedure fnd_attached_documents2_pkg.copy_attachments,

9039: --Name: copy_attachment
9040: -- Conc Mod Attachments
9041: --Function:
9042: --This procedure creates Locks in the po_locks_entity table
9043: -- also, it call another prcedure fnd_attached_documents2_pkg.copy_attachments,
9044: -- which copies the selected attachment into fnd_attached_documents table
9045: -- p_lock_entity_name --> one among 'PO_HEADER_ATTACH','PO_LINE_ATTACH'
9046: -- 'PO_SHIPMENT_ATTACH'
9047: -- p_lock_entity_pk1 --> one among po_header_id, po_line_id,line_location_id

Line 9044: -- which copies the selected attachment into fnd_attached_documents table

9040: -- Conc Mod Attachments
9041: --Function:
9042: --This procedure creates Locks in the po_locks_entity table
9043: -- also, it call another prcedure fnd_attached_documents2_pkg.copy_attachments,
9044: -- which copies the selected attachment into fnd_attached_documents table
9045: -- p_lock_entity_name --> one among 'PO_HEADER_ATTACH','PO_LINE_ATTACH'
9046: -- 'PO_SHIPMENT_ATTACH'
9047: -- p_lock_entity_pk1 --> one among po_header_id, po_line_id,line_location_id
9048: -- p_lock_entity_pk3 --> null

Line 9121: fnd_attached_documents2_pkg.copy_attachments

9117: IF (PO_LOG.d_proc) THEN
9118: PO_LOG.proc_end(d_module, 'number of rows updated', SQL%ROWCOUNT);
9119: END IF;
9120:
9121: fnd_attached_documents2_pkg.copy_attachments
9122: ( X_from_entity_name => p_from_entity_name,
9123: X_from_pk1_value => p_lock_entity_pk1,
9124: X_to_entity_name => p_to_entity_name,
9125: X_to_pk1_value => p_lock_entity_pk1 || '-' || TO_CHAR(p_lock_by_draft_id),