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_QUEUE_MANAGEMENT_PVT_W dependencies on IEM_QUEUE_MANAGEMENT_PVT

Line 1: package body iem_queue_management_pvt_w as

1: package body iem_queue_management_pvt_w as
2: /* $Header: IEMPQUMB.pls 120.1 2006/02/13 14:33 chtang noship $ */
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_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE

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_p1(t out nocopy iem_queue_management_pvt.message_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_VARCHAR2_TABLE_2000
17: , a4 JTF_VARCHAR2_TABLE_100

Line 52: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE

48: end loop;
49: end if;
50: end if;
51: end rosetta_table_copy_in_p1;
52: procedure rosetta_table_copy_out_p1(t iem_queue_management_pvt.message_tbl, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_NUMBER_TABLE
54: , a2 out nocopy JTF_VARCHAR2_TABLE_300
55: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
56: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE

122: end if;
123: end if;
124: end rosetta_table_copy_out_p1;
125:
126: procedure rosetta_table_copy_in_p3(t out nocopy iem_queue_management_pvt.temp_message_tbl, a0 JTF_NUMBER_TABLE
127: , a1 JTF_NUMBER_TABLE
128: , a2 JTF_VARCHAR2_TABLE_300
129: , a3 JTF_VARCHAR2_TABLE_2000
130: , a4 JTF_VARCHAR2_TABLE_100

Line 163: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE

159: end loop;
160: end if;
161: end if;
162: end rosetta_table_copy_in_p3;
163: procedure rosetta_table_copy_out_p3(t iem_queue_management_pvt.temp_message_tbl, a0 out nocopy JTF_NUMBER_TABLE
164: , a1 out nocopy JTF_NUMBER_TABLE
165: , a2 out nocopy JTF_VARCHAR2_TABLE_300
166: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
167: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 232: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE

228: end if;
229: end if;
230: end rosetta_table_copy_out_p3;
231:
232: procedure rosetta_table_copy_in_p5(t out nocopy iem_queue_management_pvt.resource_count_tbl, a0 JTF_NUMBER_TABLE
233: , a1 JTF_VARCHAR2_TABLE_200
234: , a2 JTF_NUMBER_TABLE
235: , a3 JTF_VARCHAR2_TABLE_500
236: ) as

Line 257: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

253: end loop;
254: end if;
255: end if;
256: end rosetta_table_copy_in_p5;
257: procedure rosetta_table_copy_out_p5(t iem_queue_management_pvt.resource_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
258: , a1 out nocopy JTF_VARCHAR2_TABLE_200
259: , a2 out nocopy JTF_NUMBER_TABLE
260: , a3 out nocopy JTF_VARCHAR2_TABLE_500
261: ) as

Line 296: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE

292: end if;
293: end if;
294: end rosetta_table_copy_out_p5;
295:
296: procedure rosetta_table_copy_in_p7(t out nocopy iem_queue_management_pvt.resource_group_count_tbl, a0 JTF_NUMBER_TABLE
297: , a1 JTF_VARCHAR2_TABLE_200
298: , a2 JTF_NUMBER_TABLE
299: , a3 JTF_NUMBER_TABLE
300: ) as

Line 321: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE

317: end loop;
318: end if;
319: end if;
320: end rosetta_table_copy_in_p7;
321: procedure rosetta_table_copy_out_p7(t iem_queue_management_pvt.resource_group_count_tbl, a0 out nocopy JTF_NUMBER_TABLE
322: , a1 out nocopy JTF_VARCHAR2_TABLE_200
323: , a2 out nocopy JTF_NUMBER_TABLE
324: , a3 out nocopy JTF_NUMBER_TABLE
325: ) as

Line 391: ddx_message_tbl iem_queue_management_pvt.message_tbl;

387: , x_msg_data out nocopy VARCHAR2
388: )
389:
390: as
391: ddx_message_tbl iem_queue_management_pvt.message_tbl;
392: ddindx binary_integer; indx binary_integer;
393: begin
394:
395: -- copy data to the local IN or IN-OUT args, if any

Line 415: iem_queue_management_pvt.search_messages_in_queue(p_api_version_number,

411:
412:
413:
414: -- here's the delegated call to the old PL/SQL routine
415: iem_queue_management_pvt.search_messages_in_queue(p_api_version_number,
416: p_init_msg_list,
417: p_commit,
418: p_email_account_id,
419: p_classification_id,

Line 449: iem_queue_management_pvt_w.rosetta_table_copy_out_p1(ddx_message_tbl, p14_a0

445:
446:
447:
448:
449: iem_queue_management_pvt_w.rosetta_table_copy_out_p1(ddx_message_tbl, p14_a0
450: , p14_a1
451: , p14_a2
452: , p14_a3
453: , p14_a4

Line 482: ddx_resource_count iem_queue_management_pvt.resource_count_tbl;

478: , x_msg_data out nocopy VARCHAR2
479: )
480:
481: as
482: ddx_resource_count iem_queue_management_pvt.resource_count_tbl;
483: ddindx binary_integer; indx binary_integer;
484: begin
485:
486: -- copy data to the local IN or IN-OUT args, if any

Line 498: iem_queue_management_pvt.show_agent_list(p_api_version_number,

494:
495:
496:
497: -- here's the delegated call to the old PL/SQL routine
498: iem_queue_management_pvt.show_agent_list(p_api_version_number,
499: p_init_msg_list,
500: p_commit,
501: p_email_account_id,
502: p_sort_column,

Line 516: iem_queue_management_pvt_w.rosetta_table_copy_out_p5(ddx_resource_count, p6_a0

512:
513:
514:
515:
516: iem_queue_management_pvt_w.rosetta_table_copy_out_p5(ddx_resource_count, p6_a0
517: , p6_a1
518: , p6_a2
519: , p6_a3
520: );

Line 542: ddx_resource_group_count iem_queue_management_pvt.resource_group_count_tbl;

538: , x_msg_data out nocopy VARCHAR2
539: )
540:
541: as
542: ddx_resource_group_count iem_queue_management_pvt.resource_group_count_tbl;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:
546: -- copy data to the local IN or IN-OUT args, if any

Line 558: iem_queue_management_pvt.show_resource_group_list(p_api_version_number,

554:
555:
556:
557: -- here's the delegated call to the old PL/SQL routine
558: iem_queue_management_pvt.show_resource_group_list(p_api_version_number,
559: p_init_msg_list,
560: p_commit,
561: p_email_account_id,
562: p_sort_column,

Line 576: iem_queue_management_pvt_w.rosetta_table_copy_out_p7(ddx_resource_group_count, p6_a0

572:
573:
574:
575:
576: iem_queue_management_pvt_w.rosetta_table_copy_out_p7(ddx_resource_group_count, p6_a0
577: , p6_a1
578: , p6_a2
579: , p6_a3
580: );

Line 586: end iem_queue_management_pvt_w;

582:
583:
584: end;
585:
586: end iem_queue_management_pvt_w;