APPS.PON_ATTACHMENTS dependencies on FND_ATTACHED_DOCUMENTS

Line 19: FROM fnd_attached_documents

15: BEGIN
16:
17: SELECT decode(count(1), 0, 'N', 'Y')
18: INTO l_has_attachments
19: FROM fnd_attached_documents
20: WHERE entity_name = p_entity_name AND
21: decode(p_pk1_value, null, -1, pk1_value) = decode(p_pk1_value, null, -1, p_pk1_value) AND
22: decode(p_pk2_value, null, -1, pk2_value) = decode(p_pk2_value, null, -1, p_pk2_value) AND
23: decode(p_pk3_value, null, -1, pk3_value) = decode(p_pk3_value, null, -1, p_pk3_value) AND

Line 148: SELECT fnd_attached_documents_s.nextval

144: l_created_by := p_user_id;
145: l_last_updated_by := l_created_by;
146:
147: -- Attached Document Id has to be populated from the sequence.
148: SELECT fnd_attached_documents_s.nextval
149: INTO l_attached_document_id
150: FROM sys.dual;
151:
152: -- Set the language parameter

Line 158: fnd_attached_documents_pkg.insert_row (

154: INTO l_lang
155: FROM dual;
156:
157: -- Call the server side package for adding the attachment and documents.
158: fnd_attached_documents_pkg.insert_row (
159: x_rowid => l_rowid ,
160: x_attached_document_id => l_attached_document_id ,
161: x_document_id => l_document_id ,
162: x_creation_date => l_creation_date ,

Line 284: SELECT fnd_attached_documents_s.nextval

280: l_last_updated_by := l_created_by;
281:
282: -- Attached Document Id has to be populated from the sequence.
283: l_progress := 3;
284: SELECT fnd_attached_documents_s.nextval
285: INTO l_attached_document_id
286: FROM sys.dual;
287:
288: -- Set the language parameter

Line 296: fnd_attached_documents_pkg.insert_row (

292: FROM dual;
293:
294: -- Call the server side package for adding the attachment and documents.
295: l_progress := 5;
296: fnd_attached_documents_pkg.insert_row (
297: x_rowid => l_rowid ,
298: x_attached_document_id => l_attached_document_id ,
299: x_document_id => l_document_id ,
300: x_creation_date => l_creation_date ,

Line 452: Select FND_ATTACHED_DOCUMENTS_S.nextval

448: From Dual;
449:
450: -- Attached Document ID population from sequence.
451: l_progress := 2;
452: Select FND_ATTACHED_DOCUMENTS_S.nextval
453: Into l_attached_document_id
454: From Dual
455: ;
456:

Line 508: fnd_attached_documents_pkg.insert_row (

504: End If;
505:
506: -- Call FND Procedure to create the attachment.
507: l_progress := 6;
508: fnd_attached_documents_pkg.insert_row (
509: x_rowid => l_rowid ,
510: x_attached_document_id => l_attached_document_id ,
511: x_document_id => l_document_id ,
512: x_creation_date => l_creation_date ,

Line 664: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%Type

660: p_column1 IN VARCHAR2,
661: x_attached_document_id out nocopy NUMBER,
662: x_file_id out nocopy NUMBER
663: ) IS
664: l_attached_document_id FND_ATTACHED_DOCUMENTS.ATTACHED_DOCUMENT_ID%Type
665: := 0;
666: l_file_id FND_DOCUMENTS_TL.MEDIA_ID%Type
667: := 0;
668: l_datatype_id FND_DOCUMENTS.DATATYPE_ID%Type

Line 789: From Fnd_Attached_Documents att

785: From Fnd_Documents doc
786: Where doc.Document_Id =
787: (
788: Select att.Document_Id
789: From Fnd_Attached_Documents att
790: Where att.Attached_Document_Id = l_attached_document_id
791: );
792:
793: Select Count(*) Into l_attached_count

Line 794: From Fnd_Attached_Documents

790: Where att.Attached_Document_Id = l_attached_document_id
791: );
792:
793: Select Count(*) Into l_attached_count
794: From Fnd_Attached_Documents
795: Where Document_Id =
796: (
797: Select a.Document_Id
798: From Fnd_Attached_Documents a

Line 798: From Fnd_Attached_Documents a

794: From Fnd_Attached_Documents
795: Where Document_Id =
796: (
797: Select a.Document_Id
798: From Fnd_Attached_Documents a
799: Where a.Attached_Document_Id = l_attached_document_id
800: );
801:
802: If ( (l_usage_type = 'O') AND (l_attached_count <= 1) ) Then

Line 804: fnd_attached_documents3_pkg.delete_row (

800: );
801:
802: If ( (l_usage_type = 'O') AND (l_attached_count <= 1) ) Then
803: -- Call the procedure to delete the attachment and document.
804: fnd_attached_documents3_pkg.delete_row (
805: l_attached_document_id,
806: p_datatype_id,
807: 'Y'
808: );

Line 811: fnd_attached_documents3_pkg.delete_row (

807: 'Y'
808: );
809: Else
810: -- Call the procedure to delete just the attachment.
811: fnd_attached_documents3_pkg.delete_row (
812: l_attached_document_id,
813: p_datatype_id,
814: 'N'
815: );