[Home] [Help]
PACKAGE: APPS.IBE_ATTACHMENT_GRP
Source
1 PACKAGE IBE_Attachment_GRP AS
2 /* $Header: IBEGATHS.pls 120.0 2005/05/30 02:46:10 appldev noship $ */
3 TYPE ATTACHMENT_REC_TYPE IS RECORD (
4 attachment_id NUMBER,
5 deliverable_id NUMBER,
6 file_name VARCHAR2(240),
7 object_version_number NUMBER,
8 x_action_status VARCHAR2(1),
9
10 -- added by G. Zhang
11 attachment_used_by VARCHAR2(30),
12 enabled_flag VARCHAR2(1),
13 can_fulfill_electronic_flag VARCHAR2(1),
14 file_id NUMBER,
15 file_extension VARCHAR2(20),
16 keywords VARCHAR2(240),
17 display_width NUMBER,
18 display_height NUMBER,
19 display_location VARCHAR2(2000),
20 link_to VARCHAR2(2000),
21 link_URL VARCHAR2(2000),
22 send_for_preview_flag VARCHAR2(1),
23 attachment_type VARCHAR2(30),
24 language_code VARCHAR2(4),
25 application_id NUMBER,
26 description VARCHAR2(2000),
27 default_style_sheet VARCHAR2(240),
28 display_url VARCHAR2(1024),
29 display_rule_id NUMBER,
30 display_program VARCHAR2(240),
31 attribute_category VARCHAR2(30),
32 attribute1 VARCHAR2(150),
33 attribute2 VARCHAR2(150),
34 attribute3 VARCHAR2(150),
35 attribute4 VARCHAR2(150),
36 attribute5 VARCHAR2(150),
37 attribute6 VARCHAR2(150),
38 attribute7 VARCHAR2(150),
39 attribute8 VARCHAR2(150),
40 attribute9 VARCHAR2(150),
41 attribute10 VARCHAR2(150),
42 attribute11 VARCHAR2(150),
43 attribute12 VARCHAR2(150),
44 attribute13 VARCHAR2(150),
45 attribute14 VARCHAR2(150),
46 attribute15 VARCHAR2(150),
47 display_text VARCHAR2(2000),
48 alternate_text VARCHAR2(1000),
49 attachment_sub_type VARCHAR2(30)
50 --bug 2633722
51 , secured_flag VARCHAR2(1)
52 );
53
54 TYPE ATTACHMENT_TBL_TYPE IS TABLE OF ATTACHMENT_REC_TYPE
55 INDEX BY BINARY_INTEGER;
56 -- TYPE ATTACHMENT_TBL_TYPE IS TABLE OF ATTACHMENT_REC_TYPE;
57
58 TYPE ATH_ID_VER_REC_TYPE IS RECORD (
59 attachment_id NUMBER,
60 file_name VARCHAR2(240),
61 object_version_number NUMBER,
62 x_action_status VARCHAR2(1)
63 );
64
65 TYPE ATH_ID_VER_TBL_TYPE IS TABLE OF ATH_ID_VER_REC_TYPE
66 INDEX BY BINARY_INTEGER;
67
68 TYPE NUMBER_TABLE IS TABLE OF NUMBER;
69
70 TYPE VARCHAR2_TABLE_300 IS TABLE OF VARCHAR2(300);
71
72 --added by G. Zhang 04/30/2001 11:18AM
73 TYPE VARCHAR2_TABLE_20 IS TABLE OF VARCHAR2(20);
74
75 G_API_VERSION CONSTANT NUMBER := 1.0;
76 G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Attachment_GRP';
77
78 PROCEDURE list_attachment (
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84
85 --added by G. Zhang 04/30/2001 11:18AM
86 p_appl_id IN NUMBER := 671,
87
88 p_deliverable_id IN NUMBER,
89 p_start_id IN NUMBER,
90 p_batch_size IN NUMBER,
91 x_row_count OUT NOCOPY NUMBER,
92 x_ath_id_tbl OUT NOCOPY NUMBER_TABLE,
93 x_dlv_id_tbl OUT NOCOPY NUMBER_TABLE,
94 x_file_name_tbl OUT NOCOPY VARCHAR2_TABLE_300,
95
96 --added by G. Zhang 04/30/2001 11:18AM
97 x_file_id_tbl OUT NOCOPY NUMBER_TABLE,
98 x_file_ext_tbl OUT NOCOPY VARCHAR2_TABLE_20,
99 x_dsp_width_tbl OUT NOCOPY NUMBER_TABLE,
100 x_dsp_height_tbl OUT NOCOPY NUMBER_TABLE,
101
102 x_version_tbl OUT NOCOPY NUMBER_TABLE );
103
104 -- Start of comments
105 -- API name: save_attachment
106 -- Type: Private
107 -- Function: Create a physical attachment
108 -- Pre-reqs: None
109 -- Parameters:
110 -- IN:
111 -- p_api_version IN NUMBER Required
112 -- p_init_msg_list IN VARCHAR2 Optional
113 -- Default = FND_API.g_false
114 -- p_commit IN VARCHAR2 Optional
115 -- Default = FND_API.g_false
116 -- x_return_status OUT VARCHAR2
117 -- x_msg_count OUT NUMBER
118 -- x_msg_data OUT VARCHAR2
119 -- p_attachment_rec IN OUT ATTACHMENT_REC_TYPE
120 -- Required
121 -- Version: Current Version 1.0
122 -- Initial version 1.0
123 -- Notes: None
124 -- End of comments
125
126 PROCEDURE save_attachment (
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129 p_commit IN VARCHAR2 := FND_API.g_false,
130 x_return_status OUT NOCOPY VARCHAR2,
131 x_msg_count OUT NOCOPY NUMBER,
132 x_msg_data OUT NOCOPY VARCHAR2,
133 p_attachment_rec IN OUT NOCOPY ATTACHMENT_REC_TYPE );
134
135
136 -- Start of comments
137 -- API name: save_attachment
138 -- Type: Private
139 -- Function: Create a collection of physical attachments
140 -- Pre-reqs: None
141 -- Parameters:
142 -- IN:
143 -- p_api_version IN NUMBER Required
144 -- p_init_msg_list IN VARCHAR2 Optional
145 -- Default = FND_API.g_false
146 -- p_commit IN VARCHAR2 Optional
147 -- Default = FND_API.g_false
148 -- x_return_status OUT VARCHAR2
149 -- x_msg_count OUT NUMBER
150 -- x_msg_data OUT VARCHAR2
151 -- p_attachment_tbl IN OUT ATTACHMENT_TBL_TYPE
152 -- Required
153 -- Version: Current Version 1.0
154 -- Initial version 1.0
155 -- Notes: None
156 -- End of comments
157
158 PROCEDURE save_attachment (
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161 p_commit IN VARCHAR2 := FND_API.g_false,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_attachment_tbl IN OUT NOCOPY ATTACHMENT_TBL_TYPE );
166
167
168 -- Start of comments
169 -- API name: delete_attachment
170 -- Type: Private
171 -- Function: Delete a collection of physical attachments and associated
172 -- physical_site_language mappings
173 -- Pre-reqs: None
174 -- Parameters:
175 -- IN:
176 -- p_api_version IN NUMBER Required
177 -- p_init_msg_list IN VARCHAR2 Optional
178 -- Default = FND_API.g_false
179 -- p_commit IN VARCHAR2 Optional
180 -- Default = FND_API.g_false
181 -- x_return_status OUT VARCHAR2
182 -- x_msg_count OUT NUMBER
183 -- x_msg_data OUT VARCHAR2
184 -- p_ath_id_ver_tbl IN OUT ATH_ID_VER_TBL_TYPE
185 -- Required
186 -- Version: Current Version 1.0
187 -- Initial version 1.0
188 -- Notes: None
189 -- End of comments
190
191 PROCEDURE delete_attachment (
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
194 p_commit IN VARCHAR2 := FND_API.g_false,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_ath_id_ver_tbl IN OUT NOCOPY ATH_ID_VER_TBL_TYPE );
199
200
201
202
203 END IBE_Attachment_GRP;