APPS.IBE_PHY_MEDIA_PVT dependencies on IBE_DSP_OBJ_LGL_CTNT

Line 14: p_pid IN ibe_dsp_obj_lgl_ctnt.object_id%TYPE,

10: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
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,

Line 15: p_catgid IN ibe_dsp_obj_lgl_ctnt.object_id%TYPE,

11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
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,

Line 32: l_logid ibe_dsp_obj_lgl_ctnt.item_id%TYPE;

28:
29: -- modified by Guigen Zhang 04-04-2001 16:46
30: l_fileid jtf_amv_attachments.file_id%TYPE;
31:
32: l_logid ibe_dsp_obj_lgl_ctnt.item_id%TYPE;
33: l_api_name CONSTANT varchar2(30) := 'get_media';
34: l_logmed_found boolean := false;
35: l_phymed_found boolean := false;
36: BEGIN

Line 64: ibe_dsp_obj_lgl_ctnt a,

60:
61: select a.item_id
62: into l_logid
63: from
64: ibe_dsp_obj_lgl_ctnt a,
65: ibe_dsp_context_b b
66: where
67: a.object_id = p_pid and
68: a.context_id = b.context_id and

Line 87: ibe_dsp_obj_lgl_ctnt a,

83: ---dbms_output.put_line(' try at catg and dc level');
84: select a.item_id
85: into l_logid
86: from
87: ibe_dsp_obj_lgl_ctnt a,
88: ibe_dsp_context_b b
89: where
90: a.object_id = p_catgid and
91: a.context_id = b.context_id and