eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PHY_MEDIA_PVT dependencies on JTF_AMV_ATTACHMENTS

Line 19: x_filename OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_name%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,
21:
22: -- added by Guigen Zhang 04-04-2001 16:46
23: x_fileid OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_id%TYPE) IS

Line 23: x_fileid OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_id%TYPE) IS

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,
21:
22: -- added by Guigen Zhang 04-04-2001 16:46
23: x_fileid OUT NOCOPY /* file.sql.39 change */ 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';

Line 26: l_filename jtf_amv_attachments.file_name%TYPE;

22: -- added by Guigen Zhang 04-04-2001 16:46
23: x_fileid OUT NOCOPY /* file.sql.39 change */ 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;

Line 30: l_fileid jtf_amv_attachments.file_id%TYPE;

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:
32: l_logid jtf_dsp_obj_lgl_ctnt.item_id%TYPE;
33: l_api_name CONSTANT varchar2(30) := 'get_media';
34: l_logmed_found boolean := false;

Line 141: jtf_amv_attachments a,

137: select a.file_name, b.description, a.file_id
138: into l_filename, l_description, l_fileid
139:
140: from
141: jtf_amv_attachments a,
142: jtf_amv_items_vl b,
143: jtf_dsp_lgl_phys_map c
144: where
145: c.item_id = l_logid and

Line 171: jtf_amv_attachments a,

167: select a.file_name, b.description, a.file_id
168: into l_filename, l_description, l_fileid
169:
170: from
171: jtf_amv_attachments a,
172: jtf_amv_items_vl b,
173: jtf_dsp_lgl_phys_map c
174: where
175: c.item_id = l_logid and

Line 202: jtf_amv_attachments a,

198: select a.file_name, b.description, a.file_id
199: into l_filename, l_description, l_fileid
200:
201: from
202: jtf_amv_attachments a,
203: jtf_amv_items_vl b,
204: jtf_dsp_lgl_phys_map c
205: where
206: c.item_id = l_logid and

Line 233: jtf_amv_attachments a,

229: select a.file_name, b.description, a.file_id
230: into l_filename, l_description, l_fileid
231:
232: from
233: jtf_amv_attachments a,
234: jtf_amv_items_vl b,
235: jtf_dsp_lgl_phys_map c
236: where
237: c.item_id = l_logid and