[Home] [Help]
PACKAGE: APPS.OE_FND_ATTACHMENTS_PUB
Source
1 PACKAGE oe_fnd_attachments_pub AS
2 /* $Header: OEXPATTS.pls 120.0 2005/06/01 01:17:45 appldev noship $ */
3 -- document data types
4 G_DATATYPE_SHORT_TEXT constant number:= 1;
5 G_DATATYPE_LONG_TEXT constant number:= 2;
6 G_DATATYPE_IMAGE constant number:= 3;
7 G_DATATYPE_OLE_OBJECT constant number:= 4;
8 G_DATATYPE_WEB_PAGE constant number:= 5;
9
10 -- document security types
11 G_SECURITY_TYPE_ORG constant number := 1;
12 G_SECURITY_TYPE_SOB constant number := 2;
13 G_SECURITY_TYPE_BU constant number := 3;
14 G_SECURITY_TYPE_NONE constant number := 4;
15
16 -- api process flags
17 G_RETURN_ON_ERROR constant varchar2(20) := 'RETURN_ON_ERROR';
18 G_CONTINUE_ON_ERROR constant varchar2(20) := 'CONTINUE_ON_ERROR';
19 -------------------------------------------------------
20
21 -- Start of Comments
22 -- API name Add_Attachments_Automatic
23 -- Type Public
24 -- Function
25 --
26 -- Pre-reqs
27 --
28 -- Parameters
29 --
30 -- Version Current version = 1.0
31 -- Initial version = 1.0
32 --
33 -- Notes
34 --
35 -- End of Comments
36
37 PROCEDURE Add_Attachments_Automatic
38 (
39 p_api_version in number,
40 p_entity_name in varchar2,
41 p_pk1_value in varchar2,
42 p_pk2_value in varchar2 default null,
43 p_pk3_value in varchar2 default null,
44 p_pk4_value in varchar2 default null,
45 p_pk5_value in varchar2 default null,
46 p_commit in varchar2 default fnd_api.G_FALSE,
47 x_attachment_count out NOCOPY /* file.sql.39 change */ number,
48 x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
49 x_msg_count out NOCOPY /* file.sql.39 change */ number,
50 x_msg_data out NOCOPY /* file.sql.39 change */ varchar2
51 );
52 -------------------------------------------------------
53
54 -- Start of Comments
55 -- API name Add_Attachment
56 -- Type Public
57 -- Function
58 --
59 -- Pre-reqs
60 --
61 -- Parameters
62 --
63 -- Version Current version = 1.0
64 -- Initial version = 1.0
65 --
66 -- Notes
67 --
68 -- End of Comments
69
70 PROCEDURE Add_Attachment
71 (
72 p_api_version in number,
73 p_entity_name in varchar,
74 p_pk1_value in varchar2,
75 p_pk2_value in varchar2 default null,
76 p_pk3_value in varchar2 default null,
77 p_pk4_value in varchar2 default null,
78 p_pk5_value in varchar2 default null,
79 p_automatic_flag in varchar2 default 'N',
80 p_commit in varchar2 default fnd_api.G_FALSE,
81 p_document_id in number,
82 x_attachment_id out NOCOPY /* file.sql.39 change */ number,
83 x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
84 x_msg_count out NOCOPY /* file.sql.39 change */ number,
85 x_msg_data out NOCOPY /* file.sql.39 change */ varchar2
86 );
87
88
89 TYPE Documet_Rec_Type IS RECORD
90 (
91 document_id number,
92 datatype_id number,
93 content_short_text varchar2(2000),
94 category_id number,
95 security_type number default G_SECURITY_TYPE_NONE,
96 security_id number default NULL,
97 publish_flag varchar2(1) default 'Y',
98 image_type varchar2(10) default NULL,
99 storage_type number default NULL,
100 usage_type varchar2(1),
101 language varchar2(30),
102 description varchar2(255),
103 file_name varchar2(255) default NULL,
104 start_date_active date default sysdate,
105 end_date_active date default null,
106 attachment_id number
107 );
108
109 TYPE Documet_Tbl_Type IS TABLE OF Documet_Rec_Type
110 INDEX BY BINARY_INTEGER;
111
112 -- Start of Comments
113 -- API name Add_Attachments
114 -- Type Public
115 -- Function
116 --
117 -- Pre-reqs
118 --
119 -- Parameters
120 --
121 -- Version Current version = 1.0
122 -- Initial version = 1.0
123 --
124 -- Notes
125 --
126 -- End of Comments
127
128
129 PROCEDURE Add_Attachments
130 (
131 p_api_version in number,
132 p_entity_name in varchar2,
133 p_pk1_value in varchar2,
134 p_pk2_value in varchar2 default null,
135 p_pk3_value in varchar2 default null,
136 p_pk4_value in varchar2 default null,
137 p_pk5_value in varchar2 default null,
138 p_process_flag in varchar2 default G_RETURN_ON_ERROR,
139 p_automatic_attachment in varchar2 default 'N',
140 p_commit in varchar2 default fnd_api.G_FALSE,
141 p_document_tbl in out NOCOPY /* file.sql.39 change */ Documet_Tbl_Type,
142 x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
143 x_msg_count out NOCOPY /* file.sql.39 change */ number,
144 x_msg_data out NOCOPY /* file.sql.39 change */ varchar2
145 );
146
147 -------------------------------------
148 -- Start of Comments
149 -- API name Create_Short_Text_Document
150 -- Type Public
151 -- Function
152 --
153 -- Pre-reqs
154 --
155 -- Parameters
156 --
157 -- Version Current version = 1.0
158 -- Initial version = 1.0
159 --
160 -- Notes
161 --
162 -- End of Comments
163
164
165 PROCEDURE Create_Short_Text_Document
166 (
167 p_api_version in number,
168 p_document_text in varchar2,
169 p_document_category in number,
170 p_document_description in varchar2,
171 p_language in varchar2 default null,
172 p_security_type in number default G_SECURITY_TYPE_NONE,
173 p_security_id in number default null,
174 p_publish_flag in varchar2 default 'Y',
175 p_usage_type in varchar2,
176 p_start_date_active in date default sysdate,
177 p_end_date_active in date default null,
178 p_commit in varchar2 default fnd_api.G_FALSE,
179 x_document_id out NOCOPY /* file.sql.39 change */ number,
180 x_return_status out NOCOPY /* file.sql.39 change */ varchar2,
181 x_msg_count out NOCOPY /* file.sql.39 change */ number,
182 x_msg_data out NOCOPY /* file.sql.39 change */ varchar2
183 );
184 ----------------------------------------
185 TYPE Copy_Attachments_Rec_Type IS RECORD
186 ( from_entity_name varchar2(30),
187 from_pk1_value varchar2(30),
188 from_pk2_value varchar2(30) default null,
189 from_pk3_value varchar2(30) default null,
190 from_pk4_value varchar2(30) default null,
191 from_pk5_value varchar2(30) default null,
192 to_entity_name varchar2(30),
193 to_pk1_value varchar2(30),
194 to_pk2_value varchar2(30) default null,
195 to_pk3_value varchar2(30) default null,
196 to_pk4_value varchar2(30) default null,
197 to_pk5_value varchar2(30) default null
198 );
199
200 TYPE Copy_Attachments_Tbl_Type IS TABLE OF Copy_Attachments_Rec_Type
201 INDEX BY BINARY_INTEGER;
202
203 -------------------------------------
204 -- Start of Comments
205 -- API name Copy_Attachments
206 -- Type Private
207 -- Function
208 --
209 -- Pre-reqs
210 --
211 -- Parameters
212 --
213 -- Version Current version = 1.0
214 -- Initial version = 1.0
215 --
216 -- Notes
217 --
218 -- End of Comments
219
220
221 PROCEDURE Copy_Attachments
222 (
223 p_api_version in number,
224 p_copy_attachments_tbl in Copy_Attachments_Tbl_Type
225 );
226
227 END oe_fnd_attachments_pub;
228