1 PACKAGE DOM_ATTACHMENT_UTIL_PKG AUTHID CURRENT_USER AS
2 /* $Header: DOMAUTLS.pls 120.5 2006/09/20 19:03:05 sabatra noship $ */
3 /*---------------------------------------------------------------------------+
4 | This package contains public APIs for Attachments functionality |
5 +---------------------------------------------------------------------------*/
6
7
8 Procedure Attach (
9 p_Document_id IN Number
10 , p_Entity_name IN Varchar2
11 , p_Pk1_value IN Varchar2
12 , p_Pk2_value IN Varchar2 DEFAULT NULL
13 , p_Pk3_value IN Varchar2 DEFAULT NULL
14 , p_Pk4_value IN Varchar2 DEFAULT NULL
15 , p_Pk5_value IN Varchar2 DEFAULT NULL
16 , p_category_id IN Number
17 , p_created_by IN Number
18 , p_last_update_login IN Number DEFAULT NULL
19 , x_Attached_document_id OUT NOCOPY Number
20 );
21
22 Procedure Create_Attachment (
23 p_Document_id IN Number
24 , p_Entity_name IN Varchar2
25 , p_Pk1_value IN Varchar2
26 , p_Pk2_value IN Varchar2 DEFAULT NULL
27 , p_Pk3_value IN Varchar2 DEFAULT NULL
28 , p_Pk4_value IN Varchar2 DEFAULT NULL
29 , p_Pk5_value IN Varchar2 DEFAULT NULL
30 , p_category_id IN Number
31 , p_repository_id IN NUMBER
32 , p_version_id IN NUMBER
33 , p_family_id IN NUMBER
34 , p_file_name IN VARCHAR2
35 , p_created_by IN NUMBER
36 , p_last_update_login IN NUMBER DEFAULT NULL
37 , x_Attached_document_id OUT NOCOPY NUMBER
38 );
39
40 Procedure Detach(
41 p_Attached_document_id IN Number
42 );
43
44 /* This will be called after the MODIFY action */
45 Procedure Update_Document(
46 p_Attached_document_id IN Number
47 , p_FileName IN Varchar2
48 , p_Description IN Varchar2 DEFAULT NULL
49 , p_Category IN Number
50 , p_last_updated_by IN Number
51 , p_last_update_login IN Number DEFAULT NULL
52 );
53
54 /* To be called for change attach version */
55 Procedure Change_Version(
56 p_Attached_document_id IN Number
57 , p_Document_id IN Number
58 , p_last_updated_by IN Number
59 , p_last_update_login IN Number DEFAULT NULL
60 );
61
62 /* This procedure is after approval / review to change fnd document
63 status */
64 Procedure Change_Status(
65 p_Attached_document_id IN Number
66 , p_Document_id IN Number
67 , p_Repository_id IN Number
68 , p_Status IN Varchar2
69 , p_submitted_by IN Number
70 , p_last_updated_by IN Number
71 , p_last_update_login IN Number DEFAULT NULL
72 );
73
74 /* This function returns document rendering url */
75 FUNCTION get_repos_doc_view_url
76 (
77 p_document_id IN NUMBER
78 )RETURN VARCHAR2;
79
80 -- API to delete attachments for a given entity
81 PROCEDURE delete_attachments(X_entity_name IN VARCHAR2,
82 X_pk1_value IN VARCHAR2,
83 X_pk2_value IN VARCHAR2 DEFAULT NULL,
84 X_pk3_value IN VARCHAR2 DEFAULT NULL,
85 X_pk4_value IN VARCHAR2 DEFAULT NULL,
86 X_pk5_value IN VARCHAR2 DEFAULT NULL,
87 X_delete_document_flag IN VARCHAR2 DEFAULT 'N',
88 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL);
89
90 PROCEDURE copy_documents(X_from_document_id IN OUT NOCOPY NUMBER,
91 X_created_by IN NUMBER DEFAULT NULL,
92 X_last_update_login IN NUMBER DEFAULT NULL,
93 X_program_application_id IN NUMBER DEFAULT NULL,
94 X_program_id IN NUMBER DEFAULT NULL,
95 X_request_id IN NUMBER DEFAULT NULL,
96 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
97 X_from_category_id IN NUMBER DEFAULT NULL,
98 X_to_category_id IN NUMBER DEFAULT NULL) ;
99
100 -- API to copy attachments from one record to another
101 PROCEDURE copy_attachments(X_from_entity_name IN VARCHAR2,
102 X_from_pk1_value IN VARCHAR2,
103 X_from_pk2_value IN VARCHAR2 DEFAULT NULL,
104 X_from_pk3_value IN VARCHAR2 DEFAULT NULL,
105 X_from_pk4_value IN VARCHAR2 DEFAULT NULL,
106 X_from_pk5_value IN VARCHAR2 DEFAULT NULL,
107 X_from_attachment_id IN NUMBER DEFAULT NULL,
108 X_to_entity_name IN VARCHAR2,
109 X_to_pk1_value IN VARCHAR2,
110 X_to_pk2_value IN VARCHAR2 DEFAULT NULL,
111 X_to_pk3_value IN VARCHAR2 DEFAULT NULL,
112 X_to_pk4_value IN VARCHAR2 DEFAULT NULL,
113 X_to_pk5_value IN VARCHAR2 DEFAULT NULL,
114 X_to_attachment_id IN OUT NOCOPY NUMBER,
115 X_created_by IN NUMBER DEFAULT NULL,
116 X_last_update_login IN NUMBER DEFAULT NULL,
117 X_program_application_id IN NUMBER DEFAULT NULL,
118 X_program_id IN NUMBER DEFAULT NULL,
119 X_request_id IN NUMBER DEFAULT NULL,
120 X_automatically_added_flag IN VARCHAR2 DEFAULT NULL,
121 X_from_category_id IN NUMBER DEFAULT NULL,
122 X_to_category_id IN NUMBER DEFAULT NULL );
123
124 END DOM_ATTACHMENT_UTIL_PKG;