APPS.IBE_PHY_MEDIA_PVT dependencies on JTF_AMV_ITEMS_VL

Line 20: x_description OUT NOCOPY jtf_amv_items_vl.description%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
23: x_fileid OUT NOCOPY jtf_amv_attachments.file_id%TYPE) IS
24:

Line 27: l_description jtf_amv_items_vl.description%TYPE := 'description';

23: x_fileid OUT NOCOPY jtf_amv_attachments.file_id%TYPE) IS
24:
25:
26: l_filename jtf_amv_attachments.file_name%TYPE;
27: l_description jtf_amv_items_vl.description%TYPE := 'description';
28:
29: -- modified by Guigen Zhang 04-04-2001 16:46
30: l_fileid jtf_amv_attachments.file_id%TYPE;
31:

Line 142: jtf_amv_items_vl b,

138: into l_filename, l_description, l_fileid
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

Line 172: jtf_amv_items_vl b,

168: into l_filename, l_description, l_fileid
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

Line 203: jtf_amv_items_vl b,

199: into l_filename, l_description, l_fileid
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

Line 234: jtf_amv_items_vl b,

230: into l_filename, l_description, l_fileid
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