APPS.FND_ATTACHED_DOCUMENTS3_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 1: PACKAGE BODY fnd_attached_documents3_pkg as

1: PACKAGE BODY fnd_attached_documents3_pkg as
2: /* $Header: AFAKAD3B.pls 115.9 2003/12/17 18:16:27 blash ship $ */
3:
4:
5: PROCEDURE check_unique(X_rowid VARCHAR2,

Line 18: FROM fnd_attached_documents

14: BEGIN
15:
16: IF (X_pkey2 is not null) and (X_pkey3 is not null) THEN
17: SELECT COUNT(1) INTO DUMMY
18: FROM fnd_attached_documents
19: WHERE seq_num = X_seq_num
20: AND entity_name = X_entity_name
21: AND pk1_value = X_pkey1
22: AND pk2_value = X_pkey2

Line 33: FROM fnd_attached_documents

29:
30: ELSE IF (X_pkey2 is not null) THEN
31:
32: SELECT COUNT(1) INTO DUMMY
33: FROM fnd_attached_documents
34: WHERE seq_num = X_seq_num
35: AND entity_name = X_entity_name
36: AND pk1_value = X_pkey1
37: AND pk2_value = X_pkey2

Line 47: FROM fnd_attached_documents

43: AND ( (X_rowid IS NULL) OR (rowid <> X_rowid) );
44: ELSE
45:
46: SELECT COUNT(1) INTO DUMMY
47: FROM fnd_attached_documents
48: WHERE seq_num = X_seq_num
49: AND entity_name = X_entity_name
50: AND pk1_value = X_pkey1
51: AND (X_pkey2 IS NULL)

Line 76: FROM fnd_attached_documents

72: BEGIN
73:
74: SELECT count(*)
75: INTO reference_count
76: FROM fnd_attached_documents
77: WHERE document_id = X_document_id;
78:
79: IF (reference_count > 0) THEN
80: RETURN(TRUE);

Line 97: -- Get the document_id from fnd_attached_documents.

93: BEGIN
94: -- Get the Document Id before deleting the reference.
95:
96: IF (delete_document_flag = 'Y') THEN
97: -- Get the document_id from fnd_attached_documents.
98:
99: SELECT document_id
100: INTO X_document_id
101: FROM fnd_attached_documents

Line 101: FROM fnd_attached_documents

97: -- Get the document_id from fnd_attached_documents.
98:
99: SELECT document_id
100: INTO X_document_id
101: FROM fnd_attached_documents
102: WHERE attached_document_id = X_attached_document_id;
103:
104: END IF;
105:

Line 108: DELETE FROM fnd_attached_documents

104: END IF;
105:
106:
107: -- Delete the reference
108: DELETE FROM fnd_attached_documents
109: WHERE attached_document_id = X_attached_document_id;
110:
111: -- Delete the document if the delete document flag is Y.
112: IF (delete_document_flag = 'Y') THEN

Line 125: END fnd_attached_documents3_pkg;

121: END IF; /* Delete Document */
122:
123: END delete_row ;
124:
125: END fnd_attached_documents3_pkg;