1 PACKAGE JTF_PhysicalMap_GRP AUTHID CURRENT_USER AS
2 /* $Header: JTFGPSLS.pls 115.5 2004/07/09 18:50:16 applrt ship $ */
3 -- Declare externally visible types, cursor, exception
4
5 /*
6 TYPE LANGUAGE_CODE_TBL_TYPE IS TABLE OF VARCHAR2(4)
7 INDEX BY BINARY_INTEGER;
8 */
9 TYPE LANGUAGE_CODE_TBL_TYPE IS TABLE OF VARCHAR2(4);
10
11 TYPE MSITE_LANG_REC_TYPE IS RECORD (
12 msite_id NUMBER,
13 lang_count NUMBER
14 );
15
16 TYPE MSITE_LANG_TBL_TYPE IS TABLE OF MSITE_LANG_REC_TYPE
17 INDEX BY BINARY_INTEGER;
18
19 TYPE LGL_PHYS_MAP_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
20
21 TYPE MSITE_ID_TBL_TYPE IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
22
23 g_api_version CONSTANT NUMBER := 1.0;
24 g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_PhysicalMap_GRP';
25
26 -- Declare externally callable subprograms
27
28 -- Start of comments
29 -- API name: save_physicalmap
30 -- Type: Private
31 -- Function: Save a collection of Physical_Mappings for a physical attachment
32 -- and one mini-site
33 -- Pre_reqs: None
34 -- Parameters:
35 -- IN:
36 -- p_api_version IN NUMBER Required
37 -- p_init_msg_list IN VARCHAR2 Optional
38 -- Default = FND_API.g_false
39 -- p_commit IN VARCHAR2 Optional
40 -- Default = FND_API.g_false
41 -- x_return_status OUT VARCHAR2
42 -- x_msg_count OUT NUMBER
43 -- x_msg_data OUT VARCHAR2
44 -- p_attachment_id IN NUMBER Required
45 -- p_msite_id IN NUMBER Required
46 -- p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE
47 -- Required
48 -- Version: Current Version 1.0
49 -- Initial version 1.0
50 -- Notes: None
51 -- End of comments
52
53 PROCEDURE save_physicalmap (
54 p_api_version IN NUMBER,
55 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
56 p_commit IN VARCHAR2 := FND_API.g_false,
57 x_return_status OUT VARCHAR2,
58 x_msg_count OUT NUMBER,
59 x_msg_data OUT VARCHAR2,
60 p_attachment_id IN NUMBER,
61 p_msite_id IN NUMBER,
62 p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE);
63
64
65 -- Start of comments
66 -- API name: save_physicalmap
67 -- Type: Private
68 -- Function: Save a collection of Physical_Mappings for a physical attachment
69 -- and multiple mini-sites
70 -- Pre_reqs: None
71 -- Parameters:
72 -- IN:
73 -- p_api_version IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional
75 -- Default = FND_API.g_false
76 -- p_commit IN VARCHAR2 Optional
77 -- Default = FND_API.g_false
78 -- x_return_status OUT VARCHAR2
79 -- x_msg_count OUT NUMBER
80 -- x_msg_data OUT VARCHAR2
81 -- p_attachment_id IN NUMBER Required
82 -- p_msite_lang_tbl IN MSITE_LANG_TBL_TYPE
83 -- Required
84 -- p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE
85 -- Required
86 -- Version: Current Version 1.0
87 -- Initial version 1.0
88 -- Notes: None
89 -- End of comments
90
91 PROCEDURE save_physicalmap (
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
94 p_commit IN VARCHAR2 := FND_API.g_false,
95 x_return_status OUT VARCHAR2,
96 x_msg_count OUT NUMBER,
97 x_msg_data OUT VARCHAR2,
98 p_attachment_id IN NUMBER,
99 p_msite_lang_tbl IN MSITE_LANG_TBL_TYPE,
100 p_language_code_tbl IN LANGUAGE_CODE_TBL_TYPE);
101
102
103 -- Start of comments
104 -- API name: delete_physicalmap
105 -- Type: Private
106 -- Function: Delete a collection of Physical_Mappings
107 -- Pre_reqs: None
108 -- Parameters:
109 -- IN:
110 -- p_api_version IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional
112 -- Default = FND_API.g_false
113 -- p_commit IN VARCHAR2 Optional
114 -- Default = FND_API.g_false
115 -- x_return_status OUT VARCHAR2
116 -- x_msg_count OUT NUMBER
117 -- x_msg_data OUT VARCHAR2
118 -- p_lgl_phys_map_id_tbl IN LGL_PHYS_MAP_ID_TBL_TYPE
119 -- Required
120 -- Version: Current Version 1.0
121 -- Initial version 1.0
122 -- Notes: None
123 -- End of comments
124
125 PROCEDURE delete_physicalmap(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
128 p_commit IN VARCHAR2 := FND_API.g_false,
129 x_return_status OUT VARCHAR2,
130 x_msg_count OUT NUMBER,
131 x_msg_data OUT VARCHAR2,
132 p_lgl_phys_map_id_tbl IN LGL_PHYS_MAP_ID_TBL_TYPE);
133
134
135 -- Start of comments
136 -- API name: delete_attachment
137 -- Type: Private
138 -- Function: Delete all the Physical_Mappings for the given attachment
139 -- Pre_reqs: None
140 -- Parameters:
141 -- IN:
142 -- p_attachment_id IN NUMBER Required
143 -- Version: Current Version 1.0
144 -- Initial version 1.0
145 -- Notes: None
146 -- End of comments
147
148 PROCEDURE delete_attachment(
149 p_attachment_id IN NUMBER);
150
151
152 -- Start of comments
153 -- API name: delete_deliverable
154 -- Type: Private
155 -- Function: Delete all the Physical_Mappings for the given deliverable
156 -- Pre_reqs: None
157 -- Parameters:
158 -- IN:
159 -- p_deliverable_id IN NUMBER Required
160 -- Version: Current Version 1.0
161 -- Initial version 1.0
162 -- Notes: None
163 -- End of comments
164
165 PROCEDURE delete_deliverable(
166 p_deliverable_id IN NUMBER);
167
168
169 -- Start of comments
170 -- API name: delete_msite
171 -- Type: Private
172 -- Function: Delete all the Physical_Mappings for the given mini-site
173 -- Pre_reqs: None
174 -- Parameters:
175 -- IN:
176 -- p_msite_id IN NUMBER Required
177 -- Version: Current Version 1.0
178 -- Initial version 1.0
179 -- Notes: None
180 -- End of comments
181
182 PROCEDURE delete_msite(
183 p_msite_id IN NUMBER);
184
185
186 -- Start of comments
187 -- API name: delete_msite_language
188 -- Type: Private
189 -- Function: Delete all the Physical_Mappings involved the given mini-site
190 -- and the languages which have been de-supported at the mini-site
191 -- Pre_reqs: None
192 -- Parameters:
193 -- IN:
194 -- p_msite_id IN NUMBER Required
195 -- Version: Current Version 1.0
196 -- Initial version 1.0
197 -- Notes: None
198 -- End of comments
199
200 PROCEDURE delete_msite_language(
201 p_msite_id IN NUMBER);
202
203
204 -- Start of comments
205 -- API name: delete_attachment_msite
206 -- Type: Private
207 -- Function: Delete all the Physical_Mappings for the given attachment
208 -- and mini-sites
209 -- Pre_reqs: None
210 -- Parameters:
211 -- IN:
212 -- p_api_version IN NUMBER Required
213 -- p_init_msg_list IN VARCHAR2 Optional
214 -- Default = FND_API.g_false
215 -- p_commit IN VARCHAR2 Optional
216 -- Default = FND_API.g_false
217 -- x_return_status OUT VARCHAR2
218 -- x_msg_count OUT NUMBER
219 -- x_msg_data OUT VARCHAR2
220 -- p_attachment_id IN NUMBETR Required
221 -- p_msite_id_tbl IN MSITE_ID_TBL_TYPE
222 -- Required
223 -- Version: Current Version 1.0
224 -- Initial version 1.0
225 -- Notes: None
226 -- End of comments
227
228 PROCEDURE delete_attachment_msite(
229 p_api_version IN NUMBER,
230 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231 p_commit IN VARCHAR2 := FND_API.g_false,
232 x_return_status OUT VARCHAR2,
233 x_msg_count OUT NUMBER,
234 x_msg_data OUT VARCHAR2,
235 p_attachment_id IN NUMBER,
236 p_msite_id_tbl IN MSITE_ID_TBL_TYPE);
237
238
239 -- Start of comments
240 -- API name: delete_dlv_all_all
241 -- Type: Private
242 -- Function: Delete the all-site and all-language mappings for the given
243 -- deliverable
244 -- Pre_reqs: None
245 -- Parameters:
246 -- IN:
247 -- p_deliverable_id IN NUMBETR Required
248 -- Version: Current Version 1.0
249 -- Initial version 1.0
250 -- Notes: None
251 -- End of comments
252
253 PROCEDURE delete_dlv_all_all(
254 p_deliverable_id IN NUMBER);
255
256
257 END JTF_PhysicalMap_GRP;