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.IBE_LOG_TO_PHY_PVT dependencies on IBE_DSP_LGL_PHYS_MAP

Line 15: p_siteid IN ibe_dsp_lgl_phys_map.msite_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_logicalid IN ibe_dsp_obj_lgl_ctnt.item_id%TYPE,
15: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
16: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
17: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
18: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
19:

Line 16: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,

12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2,
14: p_logicalid IN ibe_dsp_obj_lgl_ctnt.item_id%TYPE,
15: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
16: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
17: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
18: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
19:
20: -- added by Guigen Zhang 04-04-2001 16:46

Line 66: ibe_dsp_lgl_phys_map c

62: into l_filename, l_description, l_fileid
63: from
64: jtf_amv_attachments a,
65: jtf_amv_items_vl b,
66: ibe_dsp_lgl_phys_map c
67: where
68: c.item_id = l_logid and
69: c.msite_id = p_siteid and
70: c.language_code = p_langcode and

Line 95: ibe_dsp_lgl_phys_map c

91: into l_filename, l_description, l_fileid
92: from
93: jtf_amv_attachments a,
94: jtf_amv_items_vl b,
95: ibe_dsp_lgl_phys_map c
96: where
97: c.item_id = l_logid and
98: c.default_site = 'Y' and
99: c.language_code = p_langcode and

Line 125: ibe_dsp_lgl_phys_map c

121: into l_filename, l_description, l_fileid
122: from
123: jtf_amv_attachments a,
124: jtf_amv_items_vl b,
125: ibe_dsp_lgl_phys_map c
126: where
127: c.item_id = l_logid and
128: c.msite_id = p_siteid and
129: c.default_site = 'N' and

Line 154: ibe_dsp_lgl_phys_map c

150: into l_filename, l_description, l_fileid
151: from
152: jtf_amv_attachments a,
153: jtf_amv_items_vl b,
154: ibe_dsp_lgl_phys_map c
155: where
156: c.item_id = l_logid and
157: c.default_site = 'Y' and
158: c.default_language = 'Y' and

Line 222: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,

218: x_return_status OUT NOCOPY VARCHAR2,
219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_access_name IN jtf_amv_items_vl.access_name%TYPE,
222: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
223: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
224: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
225: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
226:

Line 223: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,

219: x_msg_count OUT NOCOPY NUMBER,
220: x_msg_data OUT NOCOPY VARCHAR2,
221: p_access_name IN jtf_amv_items_vl.access_name%TYPE,
222: p_siteid IN ibe_dsp_lgl_phys_map.msite_id%TYPE,
223: p_langcode IN ibe_dsp_lgl_phys_map.language_code%TYPE,
224: x_filename OUT NOCOPY jtf_amv_attachments.file_name%TYPE,
225: x_description OUT NOCOPY jtf_amv_items_vl.description%TYPE,
226:
227: -- added by Guigen Zhang 04-04-2001 16:46

Line 274: ibe_dsp_lgl_phys_map c

270:
271: from
272: jtf_amv_attachments a,
273: jtf_amv_items_vl b,
274: ibe_dsp_lgl_phys_map c
275: where
276: b.access_name = l_accessname and
277: c.msite_id = p_siteid and
278: c.language_code = p_langcode and

Line 304: ibe_dsp_lgl_phys_map c

300:
301: from
302: jtf_amv_attachments a,
303: jtf_amv_items_vl b,
304: ibe_dsp_lgl_phys_map c
305: where
306: b.access_name = l_accessname and
307: c.default_site = 'Y' and
308: c.language_code = p_langcode and

Line 334: ibe_dsp_lgl_phys_map c

330:
331: from
332: jtf_amv_attachments a,
333: jtf_amv_items_vl b,
334: ibe_dsp_lgl_phys_map c
335: where
336: b.access_name = l_accessname and
337: c.msite_id = p_siteid and
338: c.default_site = 'N' and

Line 365: ibe_dsp_lgl_phys_map c

361:
362: from
363: jtf_amv_attachments a,
364: jtf_amv_items_vl b,
365: ibe_dsp_lgl_phys_map c
366: where
367: b.access_name = l_accessname and
368: c.default_site = 'Y' and
369: c.default_language = 'Y' and