[Home] [Help]
PACKAGE: APPS.JTF_ATTACHMENT_GRP
Source
1 PACKAGE JTF_Attachment_GRP AUTHID CURRENT_USER AS
2 /* $Header: JTFGATHS.pls 115.10 2004/07/09 18:49:16 applrt ship $ */
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 );
51
52 TYPE ATTACHMENT_TBL_TYPE IS TABLE OF ATTACHMENT_REC_TYPE
53 INDEX BY BINARY_INTEGER;
54 -- TYPE ATTACHMENT_TBL_TYPE IS TABLE OF ATTACHMENT_REC_TYPE;
55
56 TYPE ATH_ID_VER_REC_TYPE IS RECORD (
57 attachment_id NUMBER,
58 file_name VARCHAR2(240),
59 object_version_number NUMBER,
60 x_action_status VARCHAR2(1)
61 );
62
63 TYPE ATH_ID_VER_TBL_TYPE IS TABLE OF ATH_ID_VER_REC_TYPE
64 INDEX BY BINARY_INTEGER;
65
66 TYPE NUMBER_TABLE IS TABLE OF NUMBER;
67
68 TYPE VARCHAR2_TABLE_300 IS TABLE OF VARCHAR2(300);
69
70 --added by G. Zhang 04/30/2001 11:18AM
71 TYPE VARCHAR2_TABLE_20 IS TABLE OF VARCHAR2(20);
72
73 G_API_VERSION CONSTANT NUMBER := 1.0;
74 G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_Attachment_GRP';
75
76 PROCEDURE list_attachment (
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
79 x_return_status OUT VARCHAR2,
80 x_msg_count OUT NUMBER,
81 x_msg_data OUT VARCHAR2,
82
83 --added by G. Zhang 04/30/2001 11:18AM
84 p_appl_id IN NUMBER := 671,
85
86 p_deliverable_id IN NUMBER,
87 p_start_id IN NUMBER,
88 p_batch_size IN NUMBER,
89 x_row_count OUT NUMBER,
90 x_ath_id_tbl OUT NUMBER_TABLE,
91 x_dlv_id_tbl OUT NUMBER_TABLE,
92 x_file_name_tbl OUT VARCHAR2_TABLE_300,
93
94 --added by G. Zhang 04/30/2001 11:18AM
95 x_file_id_tbl OUT NUMBER_TABLE,
96 x_file_ext_tbl OUT VARCHAR2_TABLE_20,
97 x_dsp_width_tbl OUT NUMBER_TABLE,
98 x_dsp_height_tbl OUT NUMBER_TABLE,
99
100 x_version_tbl OUT NUMBER_TABLE );
101
102 -- Start of comments
103 -- API name: save_attachment
104 -- Type: Private
105 -- Function: Create a physical attachment
106 -- Pre-reqs: None
107 -- Parameters:
108 -- IN:
109 -- p_api_version IN NUMBER Required
110 -- p_init_msg_list IN VARCHAR2 Optional
111 -- Default = FND_API.g_false
112 -- p_commit IN VARCHAR2 Optional
113 -- Default = FND_API.g_false
114 -- x_return_status OUT VARCHAR2
115 -- x_msg_count OUT NUMBER
116 -- x_msg_data OUT VARCHAR2
117 -- p_attachment_rec IN OUT ATTACHMENT_REC_TYPE
118 -- Required
119 -- Version: Current Version 1.0
120 -- Initial version 1.0
121 -- Notes: None
122 -- End of comments
123
124 PROCEDURE save_attachment (
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
127 p_commit IN VARCHAR2 := FND_API.g_false,
128 x_return_status OUT VARCHAR2,
129 x_msg_count OUT NUMBER,
130 x_msg_data OUT VARCHAR2,
131 p_attachment_rec IN OUT ATTACHMENT_REC_TYPE );
132
133
134 -- Start of comments
135 -- API name: save_attachment
136 -- Type: Private
137 -- Function: Create a collection of physical attachments
138 -- Pre-reqs: None
139 -- Parameters:
140 -- IN:
141 -- p_api_version IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Optional
143 -- Default = FND_API.g_false
144 -- p_commit IN VARCHAR2 Optional
145 -- Default = FND_API.g_false
146 -- x_return_status OUT VARCHAR2
147 -- x_msg_count OUT NUMBER
148 -- x_msg_data OUT VARCHAR2
149 -- p_attachment_tbl IN OUT ATTACHMENT_TBL_TYPE
150 -- Required
151 -- Version: Current Version 1.0
152 -- Initial version 1.0
153 -- Notes: None
154 -- End of comments
155
156 PROCEDURE save_attachment (
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
159 p_commit IN VARCHAR2 := FND_API.g_false,
160 x_return_status OUT VARCHAR2,
161 x_msg_count OUT NUMBER,
162 x_msg_data OUT VARCHAR2,
163 p_attachment_tbl IN OUT ATTACHMENT_TBL_TYPE );
164
165
166 -- Start of comments
167 -- API name: delete_attachment
168 -- Type: Private
169 -- Function: Delete a collection of physical attachments and associated
170 -- physical_site_language mappings
171 -- Pre-reqs: None
172 -- Parameters:
173 -- IN:
174 -- p_api_version IN NUMBER Required
175 -- p_init_msg_list IN VARCHAR2 Optional
176 -- Default = FND_API.g_false
177 -- p_commit IN VARCHAR2 Optional
178 -- Default = FND_API.g_false
179 -- x_return_status OUT VARCHAR2
180 -- x_msg_count OUT NUMBER
181 -- x_msg_data OUT VARCHAR2
182 -- p_ath_id_ver_tbl IN OUT ATH_ID_VER_TBL_TYPE
183 -- Required
184 -- Version: Current Version 1.0
185 -- Initial version 1.0
186 -- Notes: None
187 -- End of comments
188
189 PROCEDURE delete_attachment (
190 p_api_version IN NUMBER,
191 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
192 p_commit IN VARCHAR2 := FND_API.g_false,
193 x_return_status OUT VARCHAR2,
194 x_msg_count OUT NUMBER,
195 x_msg_data OUT VARCHAR2,
196 p_ath_id_ver_tbl IN OUT ATH_ID_VER_TBL_TYPE );
197
198
199 END JTF_Attachment_GRP;