[Home] [Help]
13: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
14: p_pid IN jtf_dsp_obj_lgl_ctnt.object_id%TYPE,
15: p_catgid IN jtf_dsp_obj_lgl_ctnt.object_id%TYPE,
16: p_dcname IN jtf_dsp_context_b.access_name%TYPE,
17: p_siteid IN jtf_dsp_lgl_phys_map.msite_id%TYPE,
18: p_langcode IN jtf_dsp_lgl_phys_map.language_code%TYPE,
19: x_filename OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_name%TYPE,
20: x_description OUT NOCOPY /* file.sql.39 change */ jtf_amv_items_vl.description%TYPE,
21:
14: p_pid IN jtf_dsp_obj_lgl_ctnt.object_id%TYPE,
15: p_catgid IN jtf_dsp_obj_lgl_ctnt.object_id%TYPE,
16: p_dcname IN jtf_dsp_context_b.access_name%TYPE,
17: p_siteid IN jtf_dsp_lgl_phys_map.msite_id%TYPE,
18: p_langcode IN jtf_dsp_lgl_phys_map.language_code%TYPE,
19: x_filename OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_name%TYPE,
20: x_description OUT NOCOPY /* file.sql.39 change */ jtf_amv_items_vl.description%TYPE,
21:
22: -- added by Guigen Zhang 04-04-2001 16:46
139:
140: from
141: jtf_amv_attachments a,
142: jtf_amv_items_vl b,
143: jtf_dsp_lgl_phys_map c
144: where
145: c.item_id = l_logid and
146: c.msite_id = p_siteid and
147: c.language_code = p_langcode and
169:
170: from
171: jtf_amv_attachments a,
172: jtf_amv_items_vl b,
173: jtf_dsp_lgl_phys_map c
174: where
175: c.item_id = l_logid and
176: c.default_site = 'Y' and
177: c.language_code = p_langcode and
200:
201: from
202: jtf_amv_attachments a,
203: jtf_amv_items_vl b,
204: jtf_dsp_lgl_phys_map c
205: where
206: c.item_id = l_logid and
207: c.msite_id = p_siteid and
208: c.default_site = 'N' and
231:
232: from
233: jtf_amv_attachments a,
234: jtf_amv_items_vl b,
235: jtf_dsp_lgl_phys_map c
236: where
237: c.item_id = l_logid and
238: c.default_site = 'Y' and
239: c.default_language = 'Y' and