APPS.IBE_PHY_MEDIA_PVT dependencies on IBE_DSP_LGL_PHYS_MAP

Line 17: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,

13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_pid IN ibe_dsp_obj_lgl_ctnt.object_id%TYPE,
15: p_catgid IN ibe_dsp_obj_lgl_ctnt.object_id%TYPE,
16: p_dcname IN ibe_dsp_context_b.access_name%TYPE,
17: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
18: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
19: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
20: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
21:

Line 18: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,

14: p_pid IN ibe_dsp_obj_lgl_ctnt.object_id%TYPE,
15: p_catgid IN ibe_dsp_obj_lgl_ctnt.object_id%TYPE,
16: p_dcname IN ibe_dsp_context_b.access_name%TYPE,
17: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
18: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
19: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
20: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
21:
22: -- added by Guigen Zhang 04-04-2001 16:46

Line 143: ibe_dsp_lgl_phys_map c

139:
140: from
141: jtf_amv_attachments a,
142: jtf_amv_items_vl b,
143: ibe_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

Line 173: ibe_dsp_lgl_phys_map c

169:
170: from
171: jtf_amv_attachments a,
172: jtf_amv_items_vl b,
173: ibe_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

Line 204: ibe_dsp_lgl_phys_map c

200:
201: from
202: jtf_amv_attachments a,
203: jtf_amv_items_vl b,
204: ibe_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

Line 235: ibe_dsp_lgl_phys_map c

231:
232: from
233: jtf_amv_attachments a,
234: jtf_amv_items_vl b,
235: ibe_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