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_USER_PVT_W dependencies on AMV_USER_PVT

Line 1: package body amv_user_pvt_w as

1: package body amv_user_pvt_w as
2: /* $Header: amvwusrb.pls 120.2 2005/06/30 08:50 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_p31(t out nocopy amv_user_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000) as

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

Line 28: t := amv_user_pvt.amv_char_varray_type();

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

Line 31: t := amv_user_pvt.amv_char_varray_type();

27: elsif a0.count = 0 then
28: t := amv_user_pvt.amv_char_varray_type();
29: else
30: if a0.count > 0 then
31: t := amv_user_pvt.amv_char_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_p31(t amv_user_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p31;
46: procedure rosetta_table_copy_out_p31(t amv_user_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000) 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_p32(t out nocopy amv_user_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

67: end if;
68: end if;
69: end rosetta_table_copy_out_p31;
70:
71: procedure rosetta_table_copy_in_p32(t out nocopy amv_user_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as
72: ddindx binary_integer; indx binary_integer;
73: begin
74: if a0 is null then
75: t := null;

Line 77: t := amv_user_pvt.amv_number_varray_type();

73: begin
74: if a0 is null then
75: t := null;
76: elsif a0.count = 0 then
77: t := amv_user_pvt.amv_number_varray_type();
78: else
79: if a0.count > 0 then
80: t := amv_user_pvt.amv_number_varray_type();
81: t.extend(a0.count);

Line 80: t := amv_user_pvt.amv_number_varray_type();

76: elsif a0.count = 0 then
77: t := amv_user_pvt.amv_number_varray_type();
78: else
79: if a0.count > 0 then
80: t := amv_user_pvt.amv_number_varray_type();
81: t.extend(a0.count);
82: indx := a0.first;
83: ddindx := 1;
84: while true loop

Line 95: procedure rosetta_table_copy_out_p32(t amv_user_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p32;
95: procedure rosetta_table_copy_out_p32(t amv_user_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if t is null then
99: a0 := null;

Line 120: procedure rosetta_table_copy_in_p36(t out nocopy amv_user_pvt.amv_resource_obj_varray, a0 JTF_NUMBER_TABLE

116: end if;
117: end if;
118: end rosetta_table_copy_out_p32;
119:
120: procedure rosetta_table_copy_in_p36(t out nocopy amv_user_pvt.amv_resource_obj_varray, a0 JTF_NUMBER_TABLE
121: , a1 JTF_NUMBER_TABLE
122: , a2 JTF_VARCHAR2_TABLE_100
123: , a3 JTF_VARCHAR2_TABLE_100
124: , a4 JTF_VARCHAR2_TABLE_100

Line 129: t := amv_user_pvt.amv_resource_obj_varray();

125: ) as
126: ddindx binary_integer; indx binary_integer;
127: begin
128: if a0 is not null and a0.count=0 then
129: t := amv_user_pvt.amv_resource_obj_varray();
130: elsif a0 is not null and a0.count > 0 then
131: if a0.count > 0 then
132: t := amv_user_pvt.amv_resource_obj_varray();
133: t.extend(a0.count);

Line 132: t := amv_user_pvt.amv_resource_obj_varray();

128: if a0 is not null and a0.count=0 then
129: t := amv_user_pvt.amv_resource_obj_varray();
130: elsif a0 is not null and a0.count > 0 then
131: if a0.count > 0 then
132: t := amv_user_pvt.amv_resource_obj_varray();
133: t.extend(a0.count);
134: indx := a0.first;
135: ddindx := 1;
136: while true loop

Line 151: procedure rosetta_table_copy_out_p36(t amv_user_pvt.amv_resource_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

147: end loop;
148: end if;
149: end if;
150: end rosetta_table_copy_in_p36;
151: procedure rosetta_table_copy_out_p36(t amv_user_pvt.amv_resource_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
152: , a1 out nocopy JTF_NUMBER_TABLE
153: , a2 out nocopy JTF_VARCHAR2_TABLE_100
154: , a3 out nocopy JTF_VARCHAR2_TABLE_100
155: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: procedure rosetta_table_copy_in_p38(t out nocopy amv_user_pvt.amv_group_obj_varray, a0 JTF_NUMBER_TABLE

197: end if;
198: end if;
199: end rosetta_table_copy_out_p36;
200:
201: procedure rosetta_table_copy_in_p38(t out nocopy amv_user_pvt.amv_group_obj_varray, a0 JTF_NUMBER_TABLE
202: , a1 JTF_VARCHAR2_TABLE_100
203: , a2 JTF_NUMBER_TABLE
204: , a3 JTF_VARCHAR2_TABLE_300
205: , a4 JTF_VARCHAR2_TABLE_2000

Line 212: t := amv_user_pvt.amv_group_obj_varray();

208: ) as
209: ddindx binary_integer; indx binary_integer;
210: begin
211: if a0 is not null and a0.count=0 then
212: t := amv_user_pvt.amv_group_obj_varray();
213: elsif a0 is not null and a0.count > 0 then
214: if a0.count > 0 then
215: t := amv_user_pvt.amv_group_obj_varray();
216: t.extend(a0.count);

Line 215: t := amv_user_pvt.amv_group_obj_varray();

211: if a0 is not null and a0.count=0 then
212: t := amv_user_pvt.amv_group_obj_varray();
213: elsif a0 is not null and a0.count > 0 then
214: if a0.count > 0 then
215: t := amv_user_pvt.amv_group_obj_varray();
216: t.extend(a0.count);
217: indx := a0.first;
218: ddindx := 1;
219: while true loop

Line 236: procedure rosetta_table_copy_out_p38(t amv_user_pvt.amv_group_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

232: end loop;
233: end if;
234: end if;
235: end rosetta_table_copy_in_p38;
236: procedure rosetta_table_copy_out_p38(t amv_user_pvt.amv_group_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
237: , a1 out nocopy JTF_VARCHAR2_TABLE_100
238: , a2 out nocopy JTF_NUMBER_TABLE
239: , a3 out nocopy JTF_VARCHAR2_TABLE_300
240: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 298: procedure rosetta_table_copy_in_p40(t out nocopy amv_user_pvt.amv_access_obj_varray, a0 JTF_NUMBER_TABLE

294: end if;
295: end if;
296: end rosetta_table_copy_out_p38;
297:
298: procedure rosetta_table_copy_in_p40(t out nocopy amv_user_pvt.amv_access_obj_varray, a0 JTF_NUMBER_TABLE
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_VARCHAR2_TABLE_100
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_NUMBER_TABLE

Line 318: t := amv_user_pvt.amv_access_obj_varray();

314: ) as
315: ddindx binary_integer; indx binary_integer;
316: begin
317: if a0 is not null and a0.count=0 then
318: t := amv_user_pvt.amv_access_obj_varray();
319: elsif a0 is not null and a0.count > 0 then
320: if a0.count > 0 then
321: t := amv_user_pvt.amv_access_obj_varray();
322: t.extend(a0.count);

Line 321: t := amv_user_pvt.amv_access_obj_varray();

317: if a0 is not null and a0.count=0 then
318: t := amv_user_pvt.amv_access_obj_varray();
319: elsif a0 is not null and a0.count > 0 then
320: if a0.count > 0 then
321: t := amv_user_pvt.amv_access_obj_varray();
322: t.extend(a0.count);
323: indx := a0.first;
324: ddindx := 1;
325: while true loop

Line 351: procedure rosetta_table_copy_out_p40(t amv_user_pvt.amv_access_obj_varray, a0 out nocopy JTF_NUMBER_TABLE

347: end loop;
348: end if;
349: end if;
350: end rosetta_table_copy_in_p40;
351: procedure rosetta_table_copy_out_p40(t amv_user_pvt.amv_access_obj_varray, a0 out nocopy JTF_NUMBER_TABLE
352: , a1 out nocopy JTF_NUMBER_TABLE
353: , a2 out nocopy JTF_VARCHAR2_TABLE_100
354: , a3 out nocopy JTF_NUMBER_TABLE
355: , a4 out nocopy JTF_NUMBER_TABLE

Line 493: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;

489: , p12_a2 VARCHAR2 := fnd_api.g_miss_char
490: )
491:
492: as
493: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
494: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
495: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
496: ddindx binary_integer; indx binary_integer;
497: begin

Line 494: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;

490: )
491:
492: as
493: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
494: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
495: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
496: ddindx binary_integer; indx binary_integer;
497: begin
498:

Line 495: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;

491:
492: as
493: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
494: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
495: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
496: ddindx binary_integer; indx binary_integer;
497: begin
498:
499: -- copy data to the local IN or IN-OUT args, if any

Line 519: amv_user_pvt.find_resource(p_api_version,

515:
516:
517:
518: -- here's the delegated call to the old PL/SQL routine
519: amv_user_pvt.find_resource(p_api_version,
520: p_init_msg_list,
521: p_validation_level,
522: x_return_status,
523: x_msg_count,

Line 553: amv_user_pvt_w.rosetta_table_copy_out_p36(ddx_resource_obj_array, p14_a0

549: p13_a0 := rosetta_g_miss_num_map(ddx_subset_return_obj.returned_record_count);
550: p13_a1 := rosetta_g_miss_num_map(ddx_subset_return_obj.next_record_position);
551: p13_a2 := rosetta_g_miss_num_map(ddx_subset_return_obj.total_record_count);
552:
553: amv_user_pvt_w.rosetta_table_copy_out_p36(ddx_resource_obj_array, p14_a0
554: , p14_a1
555: , p14_a2
556: , p14_a3
557: , p14_a4

Line 585: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;

581: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
582: )
583:
584: as
585: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
586: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
587: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
588: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
589: ddindx binary_integer; indx binary_integer;

Line 586: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;

582: )
583:
584: as
585: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
586: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
587: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
588: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
589: ddindx binary_integer; indx binary_integer;
590: begin

Line 587: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;

583:
584: as
585: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
586: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
587: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
588: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
589: ddindx binary_integer; indx binary_integer;
590: begin
591:

Line 588: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;

584: as
585: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
586: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
587: ddx_resource_obj_array amv_user_pvt.amv_resource_obj_varray;
588: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
589: ddindx binary_integer; indx binary_integer;
590: begin
591:
592: -- copy data to the local IN or IN-OUT args, if any

Line 610: amv_user_pvt.find_resource(p_api_version,

606:
607:
608:
609: -- here's the delegated call to the old PL/SQL routine
610: amv_user_pvt.find_resource(p_api_version,
611: p_init_msg_list,
612: p_validation_level,
613: x_return_status,
614: x_msg_count,

Line 639: amv_user_pvt_w.rosetta_table_copy_out_p36(ddx_resource_obj_array, p11_a0

635: p10_a0 := rosetta_g_miss_num_map(ddx_subset_return_obj.returned_record_count);
636: p10_a1 := rosetta_g_miss_num_map(ddx_subset_return_obj.next_record_position);
637: p10_a2 := rosetta_g_miss_num_map(ddx_subset_return_obj.total_record_count);
638:
639: amv_user_pvt_w.rosetta_table_copy_out_p36(ddx_resource_obj_array, p11_a0
640: , p11_a1
641: , p11_a2
642: , p11_a3
643: , p11_a4

Line 646: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);

642: , p11_a3
643: , p11_a4
644: );
645:
646: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);
647: end;
648:
649: procedure add_resourcerole(p_api_version NUMBER
650: , p_init_msg_list VARCHAR2

Line 662: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

658: , p_role_id_varray JTF_NUMBER_TABLE
659: )
660:
661: as
662: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;
663: ddindx binary_integer; indx binary_integer;
664: begin
665:
666: -- copy data to the local IN or IN-OUT args, if any

Line 676: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);

672:
673:
674:
675:
676: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
677:
678: -- here's the delegated call to the old PL/SQL routine
679: amv_user_pvt.add_resourcerole(p_api_version,
680: p_init_msg_list,

Line 679: amv_user_pvt.add_resourcerole(p_api_version,

675:
676: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
677:
678: -- here's the delegated call to the old PL/SQL routine
679: amv_user_pvt.add_resourcerole(p_api_version,
680: p_init_msg_list,
681: p_commit,
682: p_validation_level,
683: x_return_status,

Line 715: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

711: , p_role_id_varray JTF_NUMBER_TABLE
712: )
713:
714: as
715: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;
716: ddindx binary_integer; indx binary_integer;
717: begin
718:
719: -- copy data to the local IN or IN-OUT args, if any

Line 729: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);

725:
726:
727:
728:
729: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
730:
731: -- here's the delegated call to the old PL/SQL routine
732: amv_user_pvt.remove_resourcerole(p_api_version,
733: p_init_msg_list,

Line 732: amv_user_pvt.remove_resourcerole(p_api_version,

728:
729: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
730:
731: -- here's the delegated call to the old PL/SQL routine
732: amv_user_pvt.remove_resourcerole(p_api_version,
733: p_init_msg_list,
734: p_commit,
735: p_validation_level,
736: x_return_status,

Line 768: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

764: , p_role_id_varray JTF_NUMBER_TABLE
765: )
766:
767: as
768: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;
769: ddindx binary_integer; indx binary_integer;
770: begin
771:
772: -- copy data to the local IN or IN-OUT args, if any

Line 782: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);

778:
779:
780:
781:
782: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
783:
784: -- here's the delegated call to the old PL/SQL routine
785: amv_user_pvt.replace_resourcerole(p_api_version,
786: p_init_msg_list,

Line 785: amv_user_pvt.replace_resourcerole(p_api_version,

781:
782: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
783:
784: -- here's the delegated call to the old PL/SQL routine
785: amv_user_pvt.replace_resourcerole(p_api_version,
786: p_init_msg_list,
787: p_commit,
788: p_validation_level,
789: x_return_status,

Line 821: ddx_role_id_varray amv_user_pvt.amv_number_varray_type;

817: , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
818: )
819:
820: as
821: ddx_role_id_varray amv_user_pvt.amv_number_varray_type;
822: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
823: ddindx binary_integer; indx binary_integer;
824: begin
825:

Line 822: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;

818: )
819:
820: as
821: ddx_role_id_varray amv_user_pvt.amv_number_varray_type;
822: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
823: ddindx binary_integer; indx binary_integer;
824: begin
825:
826: -- copy data to the local IN or IN-OUT args, if any

Line 838: amv_user_pvt.get_resourceroles(p_api_version,

834:
835:
836:
837: -- here's the delegated call to the old PL/SQL routine
838: amv_user_pvt.get_resourceroles(p_api_version,
839: p_init_msg_list,
840: p_validation_level,
841: x_return_status,
842: x_msg_count,

Line 858: amv_user_pvt_w.rosetta_table_copy_out_p32(ddx_role_id_varray, x_role_id_varray);

854:
855:
856:
857:
858: amv_user_pvt_w.rosetta_table_copy_out_p32(ddx_role_id_varray, x_role_id_varray);
859:
860: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);
861: end;
862:

Line 860: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);

856:
857:
858: amv_user_pvt_w.rosetta_table_copy_out_p32(ddx_role_id_varray, x_role_id_varray);
859:
860: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);
861: end;
862:
863: procedure add_grouprole(p_api_version NUMBER
864: , p_init_msg_list VARCHAR2

Line 876: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

872: , p_role_id_varray JTF_NUMBER_TABLE
873: )
874:
875: as
876: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;
877: ddindx binary_integer; indx binary_integer;
878: begin
879:
880: -- copy data to the local IN or IN-OUT args, if any

Line 890: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);

886:
887:
888:
889:
890: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
891:
892: -- here's the delegated call to the old PL/SQL routine
893: amv_user_pvt.add_grouprole(p_api_version,
894: p_init_msg_list,

Line 893: amv_user_pvt.add_grouprole(p_api_version,

889:
890: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
891:
892: -- here's the delegated call to the old PL/SQL routine
893: amv_user_pvt.add_grouprole(p_api_version,
894: p_init_msg_list,
895: p_commit,
896: p_validation_level,
897: x_return_status,

Line 929: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

925: , p_role_id_varray JTF_NUMBER_TABLE
926: )
927:
928: as
929: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;
930: ddindx binary_integer; indx binary_integer;
931: begin
932:
933: -- copy data to the local IN or IN-OUT args, if any

Line 943: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);

939:
940:
941:
942:
943: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
944:
945: -- here's the delegated call to the old PL/SQL routine
946: amv_user_pvt.remove_grouprole(p_api_version,
947: p_init_msg_list,

Line 946: amv_user_pvt.remove_grouprole(p_api_version,

942:
943: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
944:
945: -- here's the delegated call to the old PL/SQL routine
946: amv_user_pvt.remove_grouprole(p_api_version,
947: p_init_msg_list,
948: p_commit,
949: p_validation_level,
950: x_return_status,

Line 982: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

978: , p_role_id_varray JTF_NUMBER_TABLE
979: )
980:
981: as
982: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;
983: ddindx binary_integer; indx binary_integer;
984: begin
985:
986: -- copy data to the local IN or IN-OUT args, if any

Line 996: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);

992:
993:
994:
995:
996: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
997:
998: -- here's the delegated call to the old PL/SQL routine
999: amv_user_pvt.replace_grouprole(p_api_version,
1000: p_init_msg_list,

Line 999: amv_user_pvt.replace_grouprole(p_api_version,

995:
996: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_role_id_varray, p_role_id_varray);
997:
998: -- here's the delegated call to the old PL/SQL routine
999: amv_user_pvt.replace_grouprole(p_api_version,
1000: p_init_msg_list,
1001: p_commit,
1002: p_validation_level,
1003: x_return_status,

Line 1036: ddx_role_id_varray amv_user_pvt.amv_number_varray_type;

1032: , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
1033: )
1034:
1035: as
1036: ddx_role_id_varray amv_user_pvt.amv_number_varray_type;
1037: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1040:

Line 1037: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;

1033: )
1034:
1035: as
1036: ddx_role_id_varray amv_user_pvt.amv_number_varray_type;
1037: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1040:
1041: -- copy data to the local IN or IN-OUT args, if any

Line 1054: amv_user_pvt.get_grouproles(p_api_version,

1050:
1051:
1052:
1053: -- here's the delegated call to the old PL/SQL routine
1054: amv_user_pvt.get_grouproles(p_api_version,
1055: p_init_msg_list,
1056: p_validation_level,
1057: x_return_status,
1058: x_msg_count,

Line 1076: amv_user_pvt_w.rosetta_table_copy_out_p32(ddx_role_id_varray, x_role_id_varray);

1072:
1073:
1074:
1075:
1076: amv_user_pvt_w.rosetta_table_copy_out_p32(ddx_role_id_varray, x_role_id_varray);
1077:
1078: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);
1079: end;
1080:

Line 1078: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);

1074:
1075:
1076: amv_user_pvt_w.rosetta_table_copy_out_p32(ddx_role_id_varray, x_role_id_varray);
1077:
1078: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);
1079: end;
1080:
1081: procedure add_group(p_api_version NUMBER
1082: , p_init_msg_list VARCHAR2

Line 1123: amv_user_pvt.add_group(p_api_version,

1119: ddp_end_date := rosetta_g_miss_date_in_map(p_end_date);
1120:
1121:
1122: -- here's the delegated call to the old PL/SQL routine
1123: amv_user_pvt.add_group(p_api_version,
1124: p_init_msg_list,
1125: p_commit,
1126: p_validation_level,
1127: x_return_status,

Line 1198: amv_user_pvt.update_group(p_api_version,

1194:
1195: ddp_new_end_date := rosetta_g_miss_date_in_map(p_new_end_date);
1196:
1197: -- here's the delegated call to the old PL/SQL routine
1198: amv_user_pvt.update_group(p_api_version,
1199: p_init_msg_list,
1200: p_commit,
1201: p_validation_level,
1202: x_return_status,

Line 1249: ddx_group_obj amv_user_pvt.amv_group_obj_type;

1245: , p8_a6 out nocopy DATE
1246: )
1247:
1248: as
1249: ddx_group_obj amv_user_pvt.amv_group_obj_type;
1250: ddindx binary_integer; indx binary_integer;
1251: begin
1252:
1253: -- copy data to the local IN or IN-OUT args, if any

Line 1264: amv_user_pvt.get_group(p_api_version,

1260:
1261:
1262:
1263: -- here's the delegated call to the old PL/SQL routine
1264: amv_user_pvt.get_group(p_api_version,
1265: p_init_msg_list,
1266: p_validation_level,
1267: x_return_status,
1268: x_msg_count,

Line 1320: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;

1316: , p12_a2 VARCHAR2 := fnd_api.g_miss_char
1317: )
1318:
1319: as
1320: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1321: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1322: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1323: ddindx binary_integer; indx binary_integer;
1324: begin

Line 1321: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;

1317: )
1318:
1319: as
1320: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1321: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1322: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1323: ddindx binary_integer; indx binary_integer;
1324: begin
1325:

Line 1322: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;

1318:
1319: as
1320: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1321: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1322: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1323: ddindx binary_integer; indx binary_integer;
1324: begin
1325:
1326: -- copy data to the local IN or IN-OUT args, if any

Line 1346: amv_user_pvt.find_group(p_api_version,

1342:
1343:
1344:
1345: -- here's the delegated call to the old PL/SQL routine
1346: amv_user_pvt.find_group(p_api_version,
1347: p_init_msg_list,
1348: p_validation_level,
1349: x_return_status,
1350: x_msg_count,

Line 1380: amv_user_pvt_w.rosetta_table_copy_out_p38(ddx_group_obj_array, p14_a0

1376: p13_a0 := rosetta_g_miss_num_map(ddx_subset_return_obj.returned_record_count);
1377: p13_a1 := rosetta_g_miss_num_map(ddx_subset_return_obj.next_record_position);
1378: p13_a2 := rosetta_g_miss_num_map(ddx_subset_return_obj.total_record_count);
1379:
1380: amv_user_pvt_w.rosetta_table_copy_out_p38(ddx_group_obj_array, p14_a0
1381: , p14_a1
1382: , p14_a2
1383: , p14_a3
1384: , p14_a4

Line 1417: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;

1413: , p10_a2 VARCHAR2 := fnd_api.g_miss_char
1414: )
1415:
1416: as
1417: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1418: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1419: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1420: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
1421: ddindx binary_integer; indx binary_integer;

Line 1418: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;

1414: )
1415:
1416: as
1417: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1418: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1419: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1420: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
1421: ddindx binary_integer; indx binary_integer;
1422: begin

Line 1419: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;

1415:
1416: as
1417: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1418: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1419: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1420: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
1421: ddindx binary_integer; indx binary_integer;
1422: begin
1423:

Line 1420: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;

1416: as
1417: ddp_subset_request_obj amv_user_pvt.amv_request_obj_type;
1418: ddx_subset_return_obj amv_user_pvt.amv_return_obj_type;
1419: ddx_group_obj_array amv_user_pvt.amv_group_obj_varray;
1420: ddx_role_code_varray amv_user_pvt.amv_char_varray_type;
1421: ddindx binary_integer; indx binary_integer;
1422: begin
1423:
1424: -- copy data to the local IN or IN-OUT args, if any

Line 1443: amv_user_pvt.find_group(p_api_version,

1439:
1440:
1441:
1442: -- here's the delegated call to the old PL/SQL routine
1443: amv_user_pvt.find_group(p_api_version,
1444: p_init_msg_list,
1445: p_validation_level,
1446: x_return_status,
1447: x_msg_count,

Line 1474: amv_user_pvt_w.rosetta_table_copy_out_p38(ddx_group_obj_array, p12_a0

1470: p11_a0 := rosetta_g_miss_num_map(ddx_subset_return_obj.returned_record_count);
1471: p11_a1 := rosetta_g_miss_num_map(ddx_subset_return_obj.next_record_position);
1472: p11_a2 := rosetta_g_miss_num_map(ddx_subset_return_obj.total_record_count);
1473:
1474: amv_user_pvt_w.rosetta_table_copy_out_p38(ddx_group_obj_array, p12_a0
1475: , p12_a1
1476: , p12_a2
1477: , p12_a3
1478: , p12_a4

Line 1483: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);

1479: , p12_a5
1480: , p12_a6
1481: );
1482:
1483: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_role_code_varray, x_role_code_varray);
1484: end;
1485:
1486: procedure add_groupmember(p_api_version NUMBER
1487: , p_init_msg_list VARCHAR2

Line 1499: ddp_resource_id_varray amv_user_pvt.amv_number_varray_type;

1495: , p_resource_id_varray JTF_NUMBER_TABLE
1496: )
1497:
1498: as
1499: ddp_resource_id_varray amv_user_pvt.amv_number_varray_type;
1500: ddindx binary_integer; indx binary_integer;
1501: begin
1502:
1503: -- copy data to the local IN or IN-OUT args, if any

Line 1513: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_resource_id_varray, p_resource_id_varray);

1509:
1510:
1511:
1512:
1513: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_resource_id_varray, p_resource_id_varray);
1514:
1515: -- here's the delegated call to the old PL/SQL routine
1516: amv_user_pvt.add_groupmember(p_api_version,
1517: p_init_msg_list,

Line 1516: amv_user_pvt.add_groupmember(p_api_version,

1512:
1513: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_resource_id_varray, p_resource_id_varray);
1514:
1515: -- here's the delegated call to the old PL/SQL routine
1516: amv_user_pvt.add_groupmember(p_api_version,
1517: p_init_msg_list,
1518: p_commit,
1519: p_validation_level,
1520: x_return_status,

Line 1552: ddp_resource_id_varray amv_user_pvt.amv_number_varray_type;

1548: , p_resource_id_varray JTF_NUMBER_TABLE
1549: )
1550:
1551: as
1552: ddp_resource_id_varray amv_user_pvt.amv_number_varray_type;
1553: ddindx binary_integer; indx binary_integer;
1554: begin
1555:
1556: -- copy data to the local IN or IN-OUT args, if any

Line 1566: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_resource_id_varray, p_resource_id_varray);

1562:
1563:
1564:
1565:
1566: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_resource_id_varray, p_resource_id_varray);
1567:
1568: -- here's the delegated call to the old PL/SQL routine
1569: amv_user_pvt.remove_groupmember(p_api_version,
1570: p_init_msg_list,

Line 1569: amv_user_pvt.remove_groupmember(p_api_version,

1565:
1566: amv_user_pvt_w.rosetta_table_copy_in_p32(ddp_resource_id_varray, p_resource_id_varray);
1567:
1568: -- here's the delegated call to the old PL/SQL routine
1569: amv_user_pvt.remove_groupmember(p_api_version,
1570: p_init_msg_list,
1571: p_commit,
1572: p_validation_level,
1573: x_return_status,

Line 1619: ddp_access_obj amv_user_pvt.amv_access_obj_type;

1615: , p8_a15 VARCHAR2 := fnd_api.g_miss_char
1616: )
1617:
1618: as
1619: ddp_access_obj amv_user_pvt.amv_access_obj_type;
1620: ddindx binary_integer; indx binary_integer;
1621: begin
1622:
1623: -- copy data to the local IN or IN-OUT args, if any

Line 1650: amv_user_pvt.update_access(p_api_version,

1646: ddp_access_obj.chl_required_flag := p8_a14;
1647: ddp_access_obj.chl_required_need_notif_flag := p8_a15;
1648:
1649: -- here's the delegated call to the old PL/SQL routine
1650: amv_user_pvt.update_access(p_api_version,
1651: p_init_msg_list,
1652: p_commit,
1653: p_validation_level,
1654: x_return_status,

Line 1698: ddp_access_obj_array amv_user_pvt.amv_access_obj_varray;

1694: , p8_a15 JTF_VARCHAR2_TABLE_100
1695: )
1696:
1697: as
1698: ddp_access_obj_array amv_user_pvt.amv_access_obj_varray;
1699: ddindx binary_integer; indx binary_integer;
1700: begin
1701:
1702: -- copy data to the local IN or IN-OUT args, if any

Line 1711: amv_user_pvt_w.rosetta_table_copy_in_p40(ddp_access_obj_array, p8_a0

1707:
1708:
1709:
1710:
1711: amv_user_pvt_w.rosetta_table_copy_in_p40(ddp_access_obj_array, p8_a0
1712: , p8_a1
1713: , p8_a2
1714: , p8_a3
1715: , p8_a4

Line 1730: amv_user_pvt.update_access(p_api_version,

1726: , p8_a15
1727: );
1728:
1729: -- here's the delegated call to the old PL/SQL routine
1730: amv_user_pvt.update_access(p_api_version,
1731: p_init_msg_list,
1732: p_commit,
1733: p_validation_level,
1734: x_return_status,

Line 1772: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

1768: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
1769: )
1770:
1771: as
1772: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
1773: ddindx binary_integer; indx binary_integer;
1774: begin
1775:
1776: -- copy data to the local IN or IN-OUT args, if any

Line 1797: amv_user_pvt.update_resourceapplaccess(p_api_version,

1793: ddp_access_flag_obj.chl_required_flag := p10_a6;
1794: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
1795:
1796: -- here's the delegated call to the old PL/SQL routine
1797: amv_user_pvt.update_resourceapplaccess(p_api_version,
1798: p_init_msg_list,
1799: p_commit,
1800: p_validation_level,
1801: x_return_status,

Line 1843: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

1839: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
1840: )
1841:
1842: as
1843: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
1844: ddindx binary_integer; indx binary_integer;
1845: begin
1846:
1847: -- copy data to the local IN or IN-OUT args, if any

Line 1868: amv_user_pvt.update_resourcechanaccess(p_api_version,

1864: ddp_access_flag_obj.chl_required_flag := p10_a6;
1865: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
1866:
1867: -- here's the delegated call to the old PL/SQL routine
1868: amv_user_pvt.update_resourcechanaccess(p_api_version,
1869: p_init_msg_list,
1870: p_commit,
1871: p_validation_level,
1872: x_return_status,

Line 1914: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

1910: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
1911: )
1912:
1913: as
1914: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
1915: ddindx binary_integer; indx binary_integer;
1916: begin
1917:
1918: -- copy data to the local IN or IN-OUT args, if any

Line 1939: amv_user_pvt.update_resourcecateaccess(p_api_version,

1935: ddp_access_flag_obj.chl_required_flag := p10_a6;
1936: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
1937:
1938: -- here's the delegated call to the old PL/SQL routine
1939: amv_user_pvt.update_resourcecateaccess(p_api_version,
1940: p_init_msg_list,
1941: p_commit,
1942: p_validation_level,
1943: x_return_status,

Line 1985: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

1981: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
1982: )
1983:
1984: as
1985: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
1986: ddindx binary_integer; indx binary_integer;
1987: begin
1988:
1989: -- copy data to the local IN or IN-OUT args, if any

Line 2010: amv_user_pvt.update_resourceitemaccess(p_api_version,

2006: ddp_access_flag_obj.chl_required_flag := p10_a6;
2007: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
2008:
2009: -- here's the delegated call to the old PL/SQL routine
2010: amv_user_pvt.update_resourceitemaccess(p_api_version,
2011: p_init_msg_list,
2012: p_commit,
2013: p_validation_level,
2014: x_return_status,

Line 2057: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2053: , p11_a7 VARCHAR2 := fnd_api.g_miss_char
2054: )
2055:
2056: as
2057: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2058: ddindx binary_integer; indx binary_integer;
2059: begin
2060:
2061: -- copy data to the local IN or IN-OUT args, if any

Line 2083: amv_user_pvt.update_groupapplaccess(p_api_version,

2079: ddp_access_flag_obj.chl_required_flag := p11_a6;
2080: ddp_access_flag_obj.chl_required_need_notif_flag := p11_a7;
2081:
2082: -- here's the delegated call to the old PL/SQL routine
2083: amv_user_pvt.update_groupapplaccess(p_api_version,
2084: p_init_msg_list,
2085: p_commit,
2086: p_validation_level,
2087: x_return_status,

Line 2131: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2127: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
2128: )
2129:
2130: as
2131: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2132: ddindx binary_integer; indx binary_integer;
2133: begin
2134:
2135: -- copy data to the local IN or IN-OUT args, if any

Line 2156: amv_user_pvt.update_groupchanaccess(p_api_version,

2152: ddp_access_flag_obj.chl_required_flag := p10_a6;
2153: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
2154:
2155: -- here's the delegated call to the old PL/SQL routine
2156: amv_user_pvt.update_groupchanaccess(p_api_version,
2157: p_init_msg_list,
2158: p_commit,
2159: p_validation_level,
2160: x_return_status,

Line 2202: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2198: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
2199: )
2200:
2201: as
2202: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2203: ddindx binary_integer; indx binary_integer;
2204: begin
2205:
2206: -- copy data to the local IN or IN-OUT args, if any

Line 2227: amv_user_pvt.update_groupcateaccess(p_api_version,

2223: ddp_access_flag_obj.chl_required_flag := p10_a6;
2224: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
2225:
2226: -- here's the delegated call to the old PL/SQL routine
2227: amv_user_pvt.update_groupcateaccess(p_api_version,
2228: p_init_msg_list,
2229: p_commit,
2230: p_validation_level,
2231: x_return_status,

Line 2273: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2269: , p10_a7 VARCHAR2 := fnd_api.g_miss_char
2270: )
2271:
2272: as
2273: ddp_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2274: ddindx binary_integer; indx binary_integer;
2275: begin
2276:
2277: -- copy data to the local IN or IN-OUT args, if any

Line 2298: amv_user_pvt.update_groupitemaccess(p_api_version,

2294: ddp_access_flag_obj.chl_required_flag := p10_a6;
2295: ddp_access_flag_obj.chl_required_need_notif_flag := p10_a7;
2296:
2297: -- here's the delegated call to the old PL/SQL routine
2298: amv_user_pvt.update_groupitemaccess(p_api_version,
2299: p_init_msg_list,
2300: p_commit,
2301: p_validation_level,
2302: x_return_status,

Line 2353: ddx_access_obj amv_user_pvt.amv_access_obj_type;

2349: , p11_a15 out nocopy VARCHAR2
2350: )
2351:
2352: as
2353: ddx_access_obj amv_user_pvt.amv_access_obj_type;
2354: ddindx binary_integer; indx binary_integer;
2355: begin
2356:
2357: -- copy data to the local IN or IN-OUT args, if any

Line 2371: amv_user_pvt.get_businessobjectaccess(p_api_version,

2367:
2368:
2369:
2370: -- here's the delegated call to the old PL/SQL routine
2371: amv_user_pvt.get_businessobjectaccess(p_api_version,
2372: p_init_msg_list,
2373: p_validation_level,
2374: x_return_status,
2375: x_msg_count,

Line 2443: ddx_channel_name_varray amv_user_pvt.amv_char_varray_type;

2439: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
2440: )
2441:
2442: as
2443: ddx_channel_name_varray amv_user_pvt.amv_char_varray_type;
2444: ddx_access_obj_varray amv_user_pvt.amv_access_obj_varray;
2445: ddindx binary_integer; indx binary_integer;
2446: begin
2447:

Line 2444: ddx_access_obj_varray amv_user_pvt.amv_access_obj_varray;

2440: )
2441:
2442: as
2443: ddx_channel_name_varray amv_user_pvt.amv_char_varray_type;
2444: ddx_access_obj_varray amv_user_pvt.amv_access_obj_varray;
2445: ddindx binary_integer; indx binary_integer;
2446: begin
2447:
2448: -- copy data to the local IN or IN-OUT args, if any

Line 2461: amv_user_pvt.get_channelaccess(p_api_version,

2457:
2458:
2459:
2460: -- here's the delegated call to the old PL/SQL routine
2461: amv_user_pvt.get_channelaccess(p_api_version,
2462: p_init_msg_list,
2463: p_validation_level,
2464: x_return_status,
2465: x_msg_count,

Line 2483: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_channel_name_varray, x_channel_name_varray);

2479:
2480:
2481:
2482:
2483: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_channel_name_varray, x_channel_name_varray);
2484:
2485: amv_user_pvt_w.rosetta_table_copy_out_p40(ddx_access_obj_varray, p10_a0
2486: , p10_a1
2487: , p10_a2

Line 2485: amv_user_pvt_w.rosetta_table_copy_out_p40(ddx_access_obj_varray, p10_a0

2481:
2482:
2483: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_channel_name_varray, x_channel_name_varray);
2484:
2485: amv_user_pvt_w.rosetta_table_copy_out_p40(ddx_access_obj_varray, p10_a0
2486: , p10_a1
2487: , p10_a2
2488: , p10_a3
2489: , p10_a4

Line 2533: ddx_name_varray amv_user_pvt.amv_char_varray_type;

2529: , p10_a15 out nocopy JTF_VARCHAR2_TABLE_100
2530: )
2531:
2532: as
2533: ddx_name_varray amv_user_pvt.amv_char_varray_type;
2534: ddx_access_obj_varray amv_user_pvt.amv_access_obj_varray;
2535: ddindx binary_integer; indx binary_integer;
2536: begin
2537:

Line 2534: ddx_access_obj_varray amv_user_pvt.amv_access_obj_varray;

2530: )
2531:
2532: as
2533: ddx_name_varray amv_user_pvt.amv_char_varray_type;
2534: ddx_access_obj_varray amv_user_pvt.amv_access_obj_varray;
2535: ddindx binary_integer; indx binary_integer;
2536: begin
2537:
2538: -- copy data to the local IN or IN-OUT args, if any

Line 2551: amv_user_pvt.get_accessperchannel(p_api_version,

2547:
2548:
2549:
2550: -- here's the delegated call to the old PL/SQL routine
2551: amv_user_pvt.get_accessperchannel(p_api_version,
2552: p_init_msg_list,
2553: p_validation_level,
2554: x_return_status,
2555: x_msg_count,

Line 2573: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_name_varray, x_name_varray);

2569:
2570:
2571:
2572:
2573: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_name_varray, x_name_varray);
2574:
2575: amv_user_pvt_w.rosetta_table_copy_out_p40(ddx_access_obj_varray, p10_a0
2576: , p10_a1
2577: , p10_a2

Line 2575: amv_user_pvt_w.rosetta_table_copy_out_p40(ddx_access_obj_varray, p10_a0

2571:
2572:
2573: amv_user_pvt_w.rosetta_table_copy_out_p31(ddx_name_varray, x_name_varray);
2574:
2575: amv_user_pvt_w.rosetta_table_copy_out_p40(ddx_access_obj_varray, p10_a0
2576: , p10_a1
2577: , p10_a2
2578: , p10_a3
2579: , p10_a4

Line 2618: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2614: , p13_a7 out nocopy VARCHAR2
2615: )
2616:
2617: as
2618: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2619: ddindx binary_integer; indx binary_integer;
2620: begin
2621:
2622: -- copy data to the local IN or IN-OUT args, if any

Line 2638: amv_user_pvt.get_businessobjectaccess(p_api_version,

2634:
2635:
2636:
2637: -- here's the delegated call to the old PL/SQL routine
2638: amv_user_pvt.get_businessobjectaccess(p_api_version,
2639: p_init_msg_list,
2640: p_validation_level,
2641: x_return_status,
2642: x_msg_count,

Line 2698: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2694: , p10_a7 out nocopy VARCHAR2
2695: )
2696:
2697: as
2698: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2699: ddindx binary_integer; indx binary_integer;
2700: begin
2701:
2702: -- copy data to the local IN or IN-OUT args, if any

Line 2715: amv_user_pvt.get_resourceapplaccess(p_api_version,

2711:
2712:
2713:
2714: -- here's the delegated call to the old PL/SQL routine
2715: amv_user_pvt.get_resourceapplaccess(p_api_version,
2716: p_init_msg_list,
2717: p_validation_level,
2718: x_return_status,
2719: x_msg_count,

Line 2769: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2765: , p10_a7 out nocopy VARCHAR2
2766: )
2767:
2768: as
2769: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2770: ddindx binary_integer; indx binary_integer;
2771: begin
2772:
2773: -- copy data to the local IN or IN-OUT args, if any

Line 2786: amv_user_pvt.get_resourcechanaccess(p_api_version,

2782:
2783:
2784:
2785: -- here's the delegated call to the old PL/SQL routine
2786: amv_user_pvt.get_resourcechanaccess(p_api_version,
2787: p_init_msg_list,
2788: p_validation_level,
2789: x_return_status,
2790: x_msg_count,

Line 2840: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2836: , p10_a7 out nocopy VARCHAR2
2837: )
2838:
2839: as
2840: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2841: ddindx binary_integer; indx binary_integer;
2842: begin
2843:
2844: -- copy data to the local IN or IN-OUT args, if any

Line 2857: amv_user_pvt.get_resourcecateaccess(p_api_version,

2853:
2854:
2855:
2856: -- here's the delegated call to the old PL/SQL routine
2857: amv_user_pvt.get_resourcecateaccess(p_api_version,
2858: p_init_msg_list,
2859: p_validation_level,
2860: x_return_status,
2861: x_msg_count,

Line 2911: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2907: , p10_a7 out nocopy VARCHAR2
2908: )
2909:
2910: as
2911: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2912: ddindx binary_integer; indx binary_integer;
2913: begin
2914:
2915: -- copy data to the local IN or IN-OUT args, if any

Line 2928: amv_user_pvt.get_resourceitemaccess(p_api_version,

2924:
2925:
2926:
2927: -- here's the delegated call to the old PL/SQL routine
2928: amv_user_pvt.get_resourceitemaccess(p_api_version,
2929: p_init_msg_list,
2930: p_validation_level,
2931: x_return_status,
2932: x_msg_count,

Line 2981: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

2977: , p9_a7 out nocopy VARCHAR2
2978: )
2979:
2980: as
2981: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
2982: ddindx binary_integer; indx binary_integer;
2983: begin
2984:
2985: -- copy data to the local IN or IN-OUT args, if any

Line 2997: amv_user_pvt.get_groupapplaccess(p_api_version,

2993:
2994:
2995:
2996: -- here's the delegated call to the old PL/SQL routine
2997: amv_user_pvt.get_groupapplaccess(p_api_version,
2998: p_init_msg_list,
2999: p_validation_level,
3000: x_return_status,
3001: x_msg_count,

Line 3048: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

3044: , p9_a7 out nocopy VARCHAR2
3045: )
3046:
3047: as
3048: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
3049: ddindx binary_integer; indx binary_integer;
3050: begin
3051:
3052: -- copy data to the local IN or IN-OUT args, if any

Line 3064: amv_user_pvt.get_groupchanaccess(p_api_version,

3060:
3061:
3062:
3063: -- here's the delegated call to the old PL/SQL routine
3064: amv_user_pvt.get_groupchanaccess(p_api_version,
3065: p_init_msg_list,
3066: p_validation_level,
3067: x_return_status,
3068: x_msg_count,

Line 3115: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

3111: , p9_a7 out nocopy VARCHAR2
3112: )
3113:
3114: as
3115: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
3116: ddindx binary_integer; indx binary_integer;
3117: begin
3118:
3119: -- copy data to the local IN or IN-OUT args, if any

Line 3131: amv_user_pvt.get_groupcateaccess(p_api_version,

3127:
3128:
3129:
3130: -- here's the delegated call to the old PL/SQL routine
3131: amv_user_pvt.get_groupcateaccess(p_api_version,
3132: p_init_msg_list,
3133: p_validation_level,
3134: x_return_status,
3135: x_msg_count,

Line 3182: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;

3178: , p9_a7 out nocopy VARCHAR2
3179: )
3180:
3181: as
3182: ddx_access_flag_obj amv_user_pvt.amv_access_flag_obj_type;
3183: ddindx binary_integer; indx binary_integer;
3184: begin
3185:
3186: -- copy data to the local IN or IN-OUT args, if any

Line 3198: amv_user_pvt.get_resourceitemaccess(p_api_version,

3194:
3195:
3196:
3197: -- here's the delegated call to the old PL/SQL routine
3198: amv_user_pvt.get_resourceitemaccess(p_api_version,
3199: p_init_msg_list,
3200: p_validation_level,
3201: x_return_status,
3202: x_msg_count,

Line 3229: end amv_user_pvt_w;

3225: p9_a6 := ddx_access_flag_obj.chl_required_flag;
3226: p9_a7 := ddx_access_flag_obj.chl_required_need_notif_flag;
3227: end;
3228:
3229: end amv_user_pvt_w;