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.AMV_MYCHANNEL_PVT_W dependencies on AMV_MYCHANNEL_PVT

Line 1: package body amv_mychannel_pvt_w as

1: package body amv_mychannel_pvt_w as
2: /* $Header: amvwmycb.pls 120.2 2005/06/30 08:22 appldev 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 22: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 28: t := amv_mychannel_pvt.amv_number_varray_type();

24: begin
25: if a0 is null then
26: t := null;
27: elsif a0.count = 0 then
28: t := amv_mychannel_pvt.amv_number_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_mychannel_pvt.amv_number_varray_type();
32: t.extend(a0.count);

Line 31: t := amv_mychannel_pvt.amv_number_varray_type();

27: elsif a0.count = 0 then
28: t := amv_mychannel_pvt.amv_number_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_mychannel_pvt.amv_number_varray_type();
32: t.extend(a0.count);
33: indx := a0.first;
34: ddindx := 1;
35: while true loop

Line 46: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p0;
46: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 71: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_out_p0;
70:
71: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_NUMBER_TABLE
73: , a2 JTF_VARCHAR2_TABLE_300
74: ) as
75: ddindx binary_integer; indx binary_integer;

Line 78: t := amv_mychannel_pvt.amv_cat_hierarchy_varray_type();

74: ) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if a0 is not null and a0.count=0 then
78: t := amv_mychannel_pvt.amv_cat_hierarchy_varray_type();
79: elsif a0 is not null and a0.count > 0 then
80: if a0.count > 0 then
81: t := amv_mychannel_pvt.amv_cat_hierarchy_varray_type();
82: t.extend(a0.count);

Line 81: t := amv_mychannel_pvt.amv_cat_hierarchy_varray_type();

77: if a0 is not null and a0.count=0 then
78: t := amv_mychannel_pvt.amv_cat_hierarchy_varray_type();
79: elsif a0 is not null and a0.count > 0 then
80: if a0.count > 0 then
81: t := amv_mychannel_pvt.amv_cat_hierarchy_varray_type();
82: t.extend(a0.count);
83: indx := a0.first;
84: ddindx := 1;
85: while true loop

Line 98: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p4;
98: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_NUMBER_TABLE
100: , a2 out nocopy JTF_VARCHAR2_TABLE_300
101: ) as
102: ddindx binary_integer; indx binary_integer;

Line 136: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE

132: end if;
133: end if;
134: end rosetta_table_copy_out_p4;
135:
136: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_VARCHAR2_TABLE_100
138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100

Line 152: t := amv_mychannel_pvt.amv_my_channel_varray_type();

148: ) as
149: ddindx binary_integer; indx binary_integer;
150: begin
151: if a0 is not null and a0.count=0 then
152: t := amv_mychannel_pvt.amv_my_channel_varray_type();
153: elsif a0 is not null and a0.count > 0 then
154: if a0.count > 0 then
155: t := amv_mychannel_pvt.amv_my_channel_varray_type();
156: t.extend(a0.count);

Line 155: t := amv_mychannel_pvt.amv_my_channel_varray_type();

151: if a0 is not null and a0.count=0 then
152: t := amv_mychannel_pvt.amv_my_channel_varray_type();
153: elsif a0 is not null and a0.count > 0 then
154: if a0.count > 0 then
155: t := amv_mychannel_pvt.amv_my_channel_varray_type();
156: t.extend(a0.count);
157: indx := a0.first;
158: ddindx := 1;
159: while true loop

Line 181: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE

177: end loop;
178: end if;
179: end if;
180: end rosetta_table_copy_in_p6;
181: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_VARCHAR2_TABLE_100
183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 273: procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE

269: end if;
270: end if;
271: end rosetta_table_copy_out_p6;
272:
273: procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE
274: , a1 JTF_VARCHAR2_TABLE_4000
275: , a2 JTF_DATE_TABLE
276: , a3 JTF_DATE_TABLE
277: , a4 JTF_DATE_TABLE

Line 285: t := amv_mychannel_pvt.amv_wf_notif_varray_type();

281: ) as
282: ddindx binary_integer; indx binary_integer;
283: begin
284: if a0 is not null and a0.count=0 then
285: t := amv_mychannel_pvt.amv_wf_notif_varray_type();
286: elsif a0 is not null and a0.count > 0 then
287: if a0.count > 0 then
288: t := amv_mychannel_pvt.amv_wf_notif_varray_type();
289: t.extend(a0.count);

Line 288: t := amv_mychannel_pvt.amv_wf_notif_varray_type();

284: if a0 is not null and a0.count=0 then
285: t := amv_mychannel_pvt.amv_wf_notif_varray_type();
286: elsif a0 is not null and a0.count > 0 then
287: if a0.count > 0 then
288: t := amv_mychannel_pvt.amv_wf_notif_varray_type();
289: t.extend(a0.count);
290: indx := a0.first;
291: ddindx := 1;
292: while true loop

Line 310: procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_TABLE

306: end loop;
307: end if;
308: end if;
309: end rosetta_table_copy_in_p8;
310: procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_TABLE
311: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
312: , a2 out nocopy JTF_DATE_TABLE
313: , a3 out nocopy JTF_DATE_TABLE
314: , a4 out nocopy JTF_DATE_TABLE

Line 378: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE

374: end if;
375: end if;
376: end rosetta_table_copy_out_p8;
377:
378: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE
379: , a1 JTF_VARCHAR2_TABLE_300
380: , a2 JTF_VARCHAR2_TABLE_2000
381: , a3 JTF_VARCHAR2_TABLE_100
382: ) as

Line 386: t := amv_mychannel_pvt.amv_itemdisplay_varray_type();

382: ) as
383: ddindx binary_integer; indx binary_integer;
384: begin
385: if a0 is not null and a0.count=0 then
386: t := amv_mychannel_pvt.amv_itemdisplay_varray_type();
387: elsif a0 is not null and a0.count > 0 then
388: if a0.count > 0 then
389: t := amv_mychannel_pvt.amv_itemdisplay_varray_type();
390: t.extend(a0.count);

Line 389: t := amv_mychannel_pvt.amv_itemdisplay_varray_type();

385: if a0 is not null and a0.count=0 then
386: t := amv_mychannel_pvt.amv_itemdisplay_varray_type();
387: elsif a0 is not null and a0.count > 0 then
388: if a0.count > 0 then
389: t := amv_mychannel_pvt.amv_itemdisplay_varray_type();
390: t.extend(a0.count);
391: indx := a0.first;
392: ddindx := 1;
393: while true loop

Line 407: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE

403: end loop;
404: end if;
405: end if;
406: end rosetta_table_copy_in_p10;
407: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE
408: , a1 out nocopy JTF_VARCHAR2_TABLE_300
409: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
410: , a3 out nocopy JTF_VARCHAR2_TABLE_100
411: ) as

Line 475: ddp_mychannel_obj amv_mychannel_pvt.amv_my_channel_obj_type;

471: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
472: )
473:
474: as
475: ddp_mychannel_obj amv_mychannel_pvt.amv_my_channel_obj_type;
476: ddindx binary_integer; indx binary_integer;
477: begin
478:
479: -- copy data to the local IN or IN-OUT args, if any

Line 503: amv_mychannel_pvt.add_subscription(p_api_version,

499: ddp_mychannel_obj.notification_interval_type := p8_a11;
500:
501:
502: -- here's the delegated call to the old PL/SQL routine
503: amv_mychannel_pvt.add_subscription(p_api_version,
504: p_init_msg_list,
505: p_commit,
506: p_validation_level,
507: x_return_status,

Line 549: ddp_mychannel_obj amv_mychannel_pvt.amv_my_channel_obj_type;

545: , p8_a11 VARCHAR2 := fnd_api.g_miss_char
546: )
547:
548: as
549: ddp_mychannel_obj amv_mychannel_pvt.amv_my_channel_obj_type;
550: ddindx binary_integer; indx binary_integer;
551: begin
552:
553: -- copy data to the local IN or IN-OUT args, if any

Line 576: amv_mychannel_pvt.update_mychannel(p_api_version,

572: ddp_mychannel_obj.notify_flag := p8_a10;
573: ddp_mychannel_obj.notification_interval_type := p8_a11;
574:
575: -- here's the delegated call to the old PL/SQL routine
576: amv_mychannel_pvt.update_mychannel(p_api_version,
577: p_init_msg_list,
578: p_commit,
579: p_validation_level,
580: x_return_status,

Line 620: ddx_mychannel_array amv_mychannel_pvt.amv_my_channel_varray_type;

616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
617: )
618:
619: as
620: ddx_mychannel_array amv_mychannel_pvt.amv_my_channel_varray_type;
621: ddindx binary_integer; indx binary_integer;
622: begin
623:
624: -- copy data to the local IN or IN-OUT args, if any

Line 635: amv_mychannel_pvt.get_mychannels(p_api_version,

631:
632:
633:
634: -- here's the delegated call to the old PL/SQL routine
635: amv_mychannel_pvt.get_mychannels(p_api_version,
636: p_init_msg_list,
637: p_validation_level,
638: x_return_status,
639: x_msg_count,

Line 654: amv_mychannel_pvt_w.rosetta_table_copy_out_p6(ddx_mychannel_array, p8_a0

650:
651:
652:
653:
654: amv_mychannel_pvt_w.rosetta_table_copy_out_p6(ddx_mychannel_array, p8_a0
655: , p8_a1
656: , p8_a2
657: , p8_a3
658: , p8_a4

Line 682: ddx_channel_array amv_mychannel_pvt.amv_number_varray_type;

678: , x_channel_array out nocopy JTF_NUMBER_TABLE
679: )
680:
681: as
682: ddx_channel_array amv_mychannel_pvt.amv_number_varray_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:
686: -- copy data to the local IN or IN-OUT args, if any

Line 698: amv_mychannel_pvt.get_mychannelspercategory(p_api_version,

694:
695:
696:
697: -- here's the delegated call to the old PL/SQL routine
698: amv_mychannel_pvt.get_mychannelspercategory(p_api_version,
699: p_init_msg_list,
700: p_validation_level,
701: x_return_status,
702: x_msg_count,

Line 719: amv_mychannel_pvt_w.rosetta_table_copy_out_p0(ddx_channel_array, x_channel_array);

715:
716:
717:
718:
719: amv_mychannel_pvt_w.rosetta_table_copy_out_p0(ddx_channel_array, x_channel_array);
720: end;
721:
722: procedure get_mynotifications(p_api_version NUMBER
723: , p_init_msg_list VARCHAR2

Line 745: ddx_notifications_array amv_mychannel_pvt.amv_wf_notif_varray_type;

741: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: )
743:
744: as
745: ddx_notifications_array amv_mychannel_pvt.amv_wf_notif_varray_type;
746: ddindx binary_integer; indx binary_integer;
747: begin
748:
749: -- copy data to the local IN or IN-OUT args, if any

Line 764: amv_mychannel_pvt.get_mynotifications(p_api_version,

760:
761:
762:
763: -- here's the delegated call to the old PL/SQL routine
764: amv_mychannel_pvt.get_mynotifications(p_api_version,
765: p_init_msg_list,
766: p_validation_level,
767: x_return_status,
768: x_msg_count,

Line 791: amv_mychannel_pvt_w.rosetta_table_copy_out_p8(ddx_notifications_array, p12_a0

787:
788:
789:
790:
791: amv_mychannel_pvt_w.rosetta_table_copy_out_p8(ddx_notifications_array, p12_a0
792: , p12_a1
793: , p12_a2
794: , p12_a3
795: , p12_a4

Line 822: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;

818: , p8_a2 VARCHAR2 := fnd_api.g_miss_char
819: )
820:
821: as
822: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;
823: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;
824: ddx_items_array amv_mychannel_pvt.amv_cat_hierarchy_varray_type;
825: ddindx binary_integer; indx binary_integer;
826: begin

Line 823: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;

819: )
820:
821: as
822: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;
823: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;
824: ddx_items_array amv_mychannel_pvt.amv_cat_hierarchy_varray_type;
825: ddindx binary_integer; indx binary_integer;
826: begin
827:

Line 824: ddx_items_array amv_mychannel_pvt.amv_cat_hierarchy_varray_type;

820:
821: as
822: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;
823: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;
824: ddx_items_array amv_mychannel_pvt.amv_cat_hierarchy_varray_type;
825: ddindx binary_integer; indx binary_integer;
826: begin
827:
828: -- copy data to the local IN or IN-OUT args, if any

Line 844: amv_mychannel_pvt.get_itemsperuser(p_api_version,

840:
841:
842:
843: -- here's the delegated call to the old PL/SQL routine
844: amv_mychannel_pvt.get_itemsperuser(p_api_version,
845: p_init_msg_list,
846: p_validation_level,
847: x_return_status,
848: x_msg_count,

Line 870: amv_mychannel_pvt_w.rosetta_table_copy_out_p4(ddx_items_array, p10_a0

866: p9_a0 := rosetta_g_miss_num_map(ddx_return_obj.returned_record_count);
867: p9_a1 := rosetta_g_miss_num_map(ddx_return_obj.next_record_position);
868: p9_a2 := rosetta_g_miss_num_map(ddx_return_obj.total_record_count);
869:
870: amv_mychannel_pvt_w.rosetta_table_copy_out_p4(ddx_items_array, p10_a0
871: , p10_a1
872: , p10_a2
873: );
874: end;

Line 898: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;

894: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
895: )
896:
897: as
898: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;
899: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;
900: ddx_items_array amv_mychannel_pvt.amv_itemdisplay_varray_type;
901: ddindx binary_integer; indx binary_integer;
902: begin

Line 899: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;

895: )
896:
897: as
898: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;
899: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;
900: ddx_items_array amv_mychannel_pvt.amv_itemdisplay_varray_type;
901: ddindx binary_integer; indx binary_integer;
902: begin
903:

Line 900: ddx_items_array amv_mychannel_pvt.amv_itemdisplay_varray_type;

896:
897: as
898: ddp_request_obj amv_mychannel_pvt.amv_request_obj_type;
899: ddx_return_obj amv_mychannel_pvt.amv_return_obj_type;
900: ddx_items_array amv_mychannel_pvt.amv_itemdisplay_varray_type;
901: ddindx binary_integer; indx binary_integer;
902: begin
903:
904: -- copy data to the local IN or IN-OUT args, if any

Line 921: amv_mychannel_pvt.get_useritems(p_api_version,

917:
918:
919:
920: -- here's the delegated call to the old PL/SQL routine
921: amv_mychannel_pvt.get_useritems(p_api_version,
922: p_init_msg_list,
923: p_validation_level,
924: x_return_status,
925: x_msg_count,

Line 949: amv_mychannel_pvt_w.rosetta_table_copy_out_p10(ddx_items_array, p11_a0

945: p10_a0 := rosetta_g_miss_num_map(ddx_return_obj.returned_record_count);
946: p10_a1 := rosetta_g_miss_num_map(ddx_return_obj.next_record_position);
947: p10_a2 := rosetta_g_miss_num_map(ddx_return_obj.total_record_count);
948:
949: amv_mychannel_pvt_w.rosetta_table_copy_out_p10(ddx_items_array, p11_a0
950: , p11_a1
951: , p11_a2
952: , p11_a3
953: );

Line 956: end amv_mychannel_pvt_w;

952: , p11_a3
953: );
954: end;
955:
956: end amv_mychannel_pvt_w;