APPS.IBE_PHY_MEDIA_PVT dependencies on IBE_DSP_CONTEXT_B

Line 16: p_dcname IN ibe_dsp_context_b.access_name%TYPE,

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,
20: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,

Line 65: ibe_dsp_context_b b

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
69: b.access_name = p_dcname and

Line 88: ibe_dsp_context_b b

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
92: b.access_name = p_dcname and

Line 110: ibe_dsp_context_b

106: ---dbms_output.put_line(' try at the dc level');
107: select item_id
108: into l_logid
109: from
110: ibe_dsp_context_b
111: where
112: access_name = p_dcname;
113: EXCEPTION
114: WHEN NO_DATA_FOUND THEN