APPS.JTF_PHY_MEDIA_PVT dependencies on JTF_DSP_CONTEXT_B

Line 16: p_dcname IN jtf_dsp_context_b.access_name%TYPE,

12: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
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,

Line 65: jtf_dsp_context_b b

61: select a.item_id
62: into l_logid
63: from
64: jtf_dsp_obj_lgl_ctnt a,
65: jtf_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: jtf_dsp_context_b b

84: select a.item_id
85: into l_logid
86: from
87: jtf_dsp_obj_lgl_ctnt a,
88: jtf_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: jtf_dsp_context_b

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