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.IEM_KNOWLEDGEBASE_PUB_W dependencies on IEM_KNOWLEDGEBASE_PUB

Line 1: package body iem_knowledgebase_pub_w as

1: package body iem_knowledgebase_pub_w as
2: /* $Header: IEMVKBSB.pls 115.10 2003/08/04 15:11:28 ukari ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 13: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy iem_knowledgebase_pub.emsgresp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100

Line 44: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p2;
44: procedure rosetta_table_copy_out_p2(t iem_knowledgebase_pub.emsgresp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
45: , a1 out nocopy JTF_VARCHAR2_TABLE_100
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 98: procedure rosetta_table_copy_in_p3(t out nocopy iem_knowledgebase_pub.kbcat_tbl_type, a0 JTF_VARCHAR2_TABLE_100

94: end if;
95: end if;
96: end rosetta_table_copy_out_p2;
97:
98: procedure rosetta_table_copy_in_p3(t out nocopy iem_knowledgebase_pub.kbcat_tbl_type, a0 JTF_VARCHAR2_TABLE_100
99: , a1 JTF_VARCHAR2_TABLE_100
100: , a2 JTF_NUMBER_TABLE
101: , a3 JTF_NUMBER_TABLE
102: , a4 JTF_NUMBER_TABLE

Line 125: procedure rosetta_table_copy_out_p3(t iem_knowledgebase_pub.kbcat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

121: end loop;
122: end if;
123: end if;
124: end rosetta_table_copy_in_p3;
125: procedure rosetta_table_copy_out_p3(t iem_knowledgebase_pub.kbcat_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
126: , a1 out nocopy JTF_VARCHAR2_TABLE_100
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE

Line 188: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;

184: , p9_a6 out nocopy JTF_DATE_TABLE
185: )
186:
187: as
188: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;
189: ddindx binary_integer; indx binary_integer;
190: begin
191:
192: -- copy data to the local IN or IN-OUT args, if any

Line 204: iem_knowledgebase_pub.get_suggresponse(p_api_version_number,

200:
201:
202:
203: -- here's the delegated call to the old PL/SQL routine
204: iem_knowledgebase_pub.get_suggresponse(p_api_version_number,
205: p_init_msg_list,
206: p_commit,
207: p_email_account_id,
208: p_message_id,

Line 225: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p9_a0

221:
222:
223:
224:
225: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p9_a0
226: , p9_a1
227: , p9_a2
228: , p9_a3
229: , p9_a4

Line 251: ddx_kb_cat_tbl iem_knowledgebase_pub.kbcat_tbl_type;

247: , p8_a4 out nocopy JTF_NUMBER_TABLE
248: )
249:
250: as
251: ddx_kb_cat_tbl iem_knowledgebase_pub.kbcat_tbl_type;
252: ddindx binary_integer; indx binary_integer;
253: begin
254:
255: -- copy data to the local IN or IN-OUT args, if any

Line 266: iem_knowledgebase_pub.get_kbcategories(p_api_version_number,

262:
263:
264:
265: -- here's the delegated call to the old PL/SQL routine
266: iem_knowledgebase_pub.get_kbcategories(p_api_version_number,
267: p_init_msg_list,
268: p_commit,
269: p_email_account_id,
270: p_level,

Line 285: iem_knowledgebase_pub_w.rosetta_table_copy_out_p3(ddx_kb_cat_tbl, p8_a0

281:
282:
283:
284:
285: iem_knowledgebase_pub_w.rosetta_table_copy_out_p3(ddx_kb_cat_tbl, p8_a0
286: , p8_a1
287: , p8_a2
288: , p8_a3
289: , p8_a4

Line 312: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;

308: , p9_a6 out nocopy JTF_DATE_TABLE
309: )
310:
311: as
312: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;
313: ddindx binary_integer; indx binary_integer;
314: begin
315:
316: -- copy data to the local IN or IN-OUT args, if any

Line 328: iem_knowledgebase_pub.get_kb_suggresponse(p_api_version_number,

324:
325:
326:
327: -- here's the delegated call to the old PL/SQL routine
328: iem_knowledgebase_pub.get_kb_suggresponse(p_api_version_number,
329: p_init_msg_list,
330: p_commit,
331: p_email_account_id,
332: p_message_id,

Line 349: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p9_a0

345:
346:
347:
348:
349: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p9_a0
350: , p9_a1
351: , p9_a2
352: , p9_a3
353: , p9_a4

Line 378: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;

374: , p9_a6 out nocopy JTF_DATE_TABLE
375: )
376:
377: as
378: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;
379: ddindx binary_integer; indx binary_integer;
380: begin
381:
382: -- copy data to the local IN or IN-OUT args, if any

Line 394: iem_knowledgebase_pub.get_suggresponse_dtl(p_api_version_number,

390:
391:
392:
393: -- here's the delegated call to the old PL/SQL routine
394: iem_knowledgebase_pub.get_suggresponse_dtl(p_api_version_number,
395: p_init_msg_list,
396: p_commit,
397: p_email_account_id,
398: p_message_id,

Line 415: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p9_a0

411:
412:
413:
414:
415: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p9_a0
416: , p9_a1
417: , p9_a2
418: , p9_a3
419: , p9_a4

Line 443: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;

439: , p8_a6 out nocopy JTF_DATE_TABLE
440: )
441:
442: as
443: ddx_email_suggresp_tbl iem_knowledgebase_pub.emsgresp_tbl_type;
444: ddindx binary_integer; indx binary_integer;
445: begin
446:
447: -- copy data to the local IN or IN-OUT args, if any

Line 458: iem_knowledgebase_pub.get_suggresponse_dtl(p_api_version_number,

454:
455:
456:
457: -- here's the delegated call to the old PL/SQL routine
458: iem_knowledgebase_pub.get_suggresponse_dtl(p_api_version_number,
459: p_init_msg_list,
460: p_commit,
461: p_email_account_id,
462: p_message_id,

Line 477: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p8_a0

473:
474:
475:
476:
477: iem_knowledgebase_pub_w.rosetta_table_copy_out_p2(ddx_email_suggresp_tbl, p8_a0
478: , p8_a1
479: , p8_a2
480: , p8_a3
481: , p8_a4

Line 487: end iem_knowledgebase_pub_w;

483: , p8_a6
484: );
485: end;
486:
487: end iem_knowledgebase_pub_w;