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 JTF_NUMBER_TABLE

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 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 101: a0 := JTF_NUMBER_TABLE();

97: begin
98: if t is null then
99: a0 := null;
100: elsif t.count = 0 then
101: a0 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);

Line 103: a0 := JTF_NUMBER_TABLE();

99: a0 := null;
100: elsif t.count = 0 then
101: a0 := JTF_NUMBER_TABLE();
102: else
103: a0 := JTF_NUMBER_TABLE();
104: if t.count > 0 then
105: a0.extend(t.count);
106: ddindx := t.first;
107: indx := 1;

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 121: , a1 JTF_NUMBER_TABLE

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
125: ) as

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 152: , a1 out nocopy JTF_NUMBER_TABLE

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
156: ) as

Line 166: a0 := JTF_NUMBER_TABLE();

162: a2 := null;
163: a3 := null;
164: a4 := null;
165: elsif t.count = 0 then
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_100();

Line 167: a1 := JTF_NUMBER_TABLE();

163: a3 := null;
164: a4 := null;
165: elsif t.count = 0 then
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_NUMBER_TABLE();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_100();
171: else

Line 172: a0 := JTF_NUMBER_TABLE();

168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_100();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_VARCHAR2_TABLE_100();

Line 173: a1 := JTF_NUMBER_TABLE();

169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_100();
171: else
172: a0 := JTF_NUMBER_TABLE();
173: a1 := JTF_NUMBER_TABLE();
174: a2 := JTF_VARCHAR2_TABLE_100();
175: a3 := JTF_VARCHAR2_TABLE_100();
176: a4 := JTF_VARCHAR2_TABLE_100();
177: if t.count > 0 then

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 203: , a2 JTF_NUMBER_TABLE

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
206: , a5 JTF_DATE_TABLE
207: , a6 JTF_DATE_TABLE

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 238: , a2 out nocopy JTF_NUMBER_TABLE

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
241: , a5 out nocopy JTF_DATE_TABLE
242: , a6 out nocopy JTF_DATE_TABLE

Line 255: a0 := JTF_NUMBER_TABLE();

251: a4 := null;
252: a5 := null;
253: a6 := null;
254: elsif t.count = 0 then
255: a0 := JTF_NUMBER_TABLE();
256: a1 := JTF_VARCHAR2_TABLE_100();
257: a2 := JTF_NUMBER_TABLE();
258: a3 := JTF_VARCHAR2_TABLE_300();
259: a4 := JTF_VARCHAR2_TABLE_2000();

Line 257: a2 := JTF_NUMBER_TABLE();

253: a6 := null;
254: elsif t.count = 0 then
255: a0 := JTF_NUMBER_TABLE();
256: a1 := JTF_VARCHAR2_TABLE_100();
257: a2 := JTF_NUMBER_TABLE();
258: a3 := JTF_VARCHAR2_TABLE_300();
259: a4 := JTF_VARCHAR2_TABLE_2000();
260: a5 := JTF_DATE_TABLE();
261: a6 := JTF_DATE_TABLE();

Line 263: a0 := JTF_NUMBER_TABLE();

259: a4 := JTF_VARCHAR2_TABLE_2000();
260: a5 := JTF_DATE_TABLE();
261: a6 := JTF_DATE_TABLE();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_VARCHAR2_TABLE_300();
267: a4 := JTF_VARCHAR2_TABLE_2000();

Line 265: a2 := JTF_NUMBER_TABLE();

261: a6 := JTF_DATE_TABLE();
262: else
263: a0 := JTF_NUMBER_TABLE();
264: a1 := JTF_VARCHAR2_TABLE_100();
265: a2 := JTF_NUMBER_TABLE();
266: a3 := JTF_VARCHAR2_TABLE_300();
267: a4 := JTF_VARCHAR2_TABLE_2000();
268: a5 := JTF_DATE_TABLE();
269: a6 := JTF_DATE_TABLE();

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 299: , a1 JTF_NUMBER_TABLE

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
303: , a5 JTF_VARCHAR2_TABLE_100

Line 301: , a3 JTF_NUMBER_TABLE

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
303: , a5 JTF_VARCHAR2_TABLE_100
304: , a6 JTF_DATE_TABLE
305: , a7 JTF_DATE_TABLE

Line 302: , a4 JTF_NUMBER_TABLE

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
303: , a5 JTF_VARCHAR2_TABLE_100
304: , a6 JTF_DATE_TABLE
305: , a7 JTF_DATE_TABLE
306: , a8 JTF_VARCHAR2_TABLE_100

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 352: , a1 out nocopy JTF_NUMBER_TABLE

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
356: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 354: , a3 out nocopy JTF_NUMBER_TABLE

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
356: , a5 out nocopy JTF_VARCHAR2_TABLE_100
357: , a6 out nocopy JTF_DATE_TABLE
358: , a7 out nocopy JTF_DATE_TABLE

Line 355: , a4 out nocopy JTF_NUMBER_TABLE

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
356: , a5 out nocopy JTF_VARCHAR2_TABLE_100
357: , a6 out nocopy JTF_DATE_TABLE
358: , a7 out nocopy JTF_DATE_TABLE
359: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 388: a0 := JTF_NUMBER_TABLE();

384: a13 := null;
385: a14 := null;
386: a15 := null;
387: elsif t.count = 0 then
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_VARCHAR2_TABLE_100();
391: a3 := JTF_NUMBER_TABLE();
392: a4 := JTF_NUMBER_TABLE();

Line 389: a1 := JTF_NUMBER_TABLE();

385: a14 := null;
386: a15 := null;
387: elsif t.count = 0 then
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_VARCHAR2_TABLE_100();
391: a3 := JTF_NUMBER_TABLE();
392: a4 := JTF_NUMBER_TABLE();
393: a5 := JTF_VARCHAR2_TABLE_100();

Line 391: a3 := JTF_NUMBER_TABLE();

387: elsif t.count = 0 then
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_VARCHAR2_TABLE_100();
391: a3 := JTF_NUMBER_TABLE();
392: a4 := JTF_NUMBER_TABLE();
393: a5 := JTF_VARCHAR2_TABLE_100();
394: a6 := JTF_DATE_TABLE();
395: a7 := JTF_DATE_TABLE();

Line 392: a4 := JTF_NUMBER_TABLE();

388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_VARCHAR2_TABLE_100();
391: a3 := JTF_NUMBER_TABLE();
392: a4 := JTF_NUMBER_TABLE();
393: a5 := JTF_VARCHAR2_TABLE_100();
394: a6 := JTF_DATE_TABLE();
395: a7 := JTF_DATE_TABLE();
396: a8 := JTF_VARCHAR2_TABLE_100();

Line 405: a0 := JTF_NUMBER_TABLE();

401: a13 := JTF_VARCHAR2_TABLE_100();
402: a14 := JTF_VARCHAR2_TABLE_100();
403: a15 := JTF_VARCHAR2_TABLE_100();
404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_NUMBER_TABLE();
409: a4 := JTF_NUMBER_TABLE();

Line 406: a1 := JTF_NUMBER_TABLE();

402: a14 := JTF_VARCHAR2_TABLE_100();
403: a15 := JTF_VARCHAR2_TABLE_100();
404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_NUMBER_TABLE();
409: a4 := JTF_NUMBER_TABLE();
410: a5 := JTF_VARCHAR2_TABLE_100();

Line 408: a3 := JTF_NUMBER_TABLE();

404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_NUMBER_TABLE();
409: a4 := JTF_NUMBER_TABLE();
410: a5 := JTF_VARCHAR2_TABLE_100();
411: a6 := JTF_DATE_TABLE();
412: a7 := JTF_DATE_TABLE();

Line 409: a4 := JTF_NUMBER_TABLE();

405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: a2 := JTF_VARCHAR2_TABLE_100();
408: a3 := JTF_NUMBER_TABLE();
409: a4 := JTF_NUMBER_TABLE();
410: a5 := JTF_VARCHAR2_TABLE_100();
411: a6 := JTF_DATE_TABLE();
412: a7 := JTF_DATE_TABLE();
413: a8 := JTF_VARCHAR2_TABLE_100();

Line 482: , p14_a0 out nocopy JTF_NUMBER_TABLE

478: , p_first_name VARCHAR2
479: , p13_a0 out nocopy NUMBER
480: , p13_a1 out nocopy NUMBER
481: , p13_a2 out nocopy NUMBER
482: , p14_a0 out nocopy JTF_NUMBER_TABLE
483: , p14_a1 out nocopy JTF_NUMBER_TABLE
484: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
485: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
486: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 483: , p14_a1 out nocopy JTF_NUMBER_TABLE

479: , p13_a0 out nocopy NUMBER
480: , p13_a1 out nocopy NUMBER
481: , p13_a2 out nocopy NUMBER
482: , p14_a0 out nocopy JTF_NUMBER_TABLE
483: , p14_a1 out nocopy JTF_NUMBER_TABLE
484: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
485: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
486: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
487: , p12_a0 NUMBER := 0-1962.0724

Line 573: , p11_a0 out nocopy JTF_NUMBER_TABLE

569: , p_resource_name VARCHAR2
570: , p10_a0 out nocopy NUMBER
571: , p10_a1 out nocopy NUMBER
572: , p10_a2 out nocopy NUMBER
573: , p11_a0 out nocopy JTF_NUMBER_TABLE
574: , p11_a1 out nocopy JTF_NUMBER_TABLE
575: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
576: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
577: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 574: , p11_a1 out nocopy JTF_NUMBER_TABLE

570: , p10_a0 out nocopy NUMBER
571: , p10_a1 out nocopy NUMBER
572: , p10_a2 out nocopy NUMBER
573: , p11_a0 out nocopy JTF_NUMBER_TABLE
574: , p11_a1 out nocopy JTF_NUMBER_TABLE
575: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_100
576: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
577: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
578: , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000

Line 658: , p_role_id_varray JTF_NUMBER_TABLE

654: , x_msg_count out nocopy NUMBER
655: , x_msg_data out nocopy VARCHAR2
656: , p_check_login_user VARCHAR2
657: , p_resource_id NUMBER
658: , p_role_id_varray JTF_NUMBER_TABLE
659: )
660:
661: as
662: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

Line 711: , p_role_id_varray JTF_NUMBER_TABLE

707: , x_msg_count out nocopy NUMBER
708: , x_msg_data out nocopy VARCHAR2
709: , p_check_login_user VARCHAR2
710: , p_resource_id NUMBER
711: , p_role_id_varray JTF_NUMBER_TABLE
712: )
713:
714: as
715: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

Line 764: , p_role_id_varray JTF_NUMBER_TABLE

760: , x_msg_count out nocopy NUMBER
761: , x_msg_data out nocopy VARCHAR2
762: , p_check_login_user VARCHAR2
763: , p_resource_id NUMBER
764: , p_role_id_varray JTF_NUMBER_TABLE
765: )
766:
767: as
768: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

Line 816: , x_role_id_varray out nocopy JTF_NUMBER_TABLE

812: , x_msg_count out nocopy NUMBER
813: , x_msg_data out nocopy VARCHAR2
814: , p_check_login_user VARCHAR2
815: , p_resource_id NUMBER
816: , x_role_id_varray out nocopy JTF_NUMBER_TABLE
817: , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
818: )
819:
820: as

Line 872: , p_role_id_varray JTF_NUMBER_TABLE

868: , x_msg_count out nocopy NUMBER
869: , x_msg_data out nocopy VARCHAR2
870: , p_check_login_user VARCHAR2
871: , p_group_id NUMBER
872: , p_role_id_varray JTF_NUMBER_TABLE
873: )
874:
875: as
876: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

Line 925: , p_role_id_varray JTF_NUMBER_TABLE

921: , x_msg_count out nocopy NUMBER
922: , x_msg_data out nocopy VARCHAR2
923: , p_check_login_user VARCHAR2
924: , p_group_id NUMBER
925: , p_role_id_varray JTF_NUMBER_TABLE
926: )
927:
928: as
929: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

Line 978: , p_role_id_varray JTF_NUMBER_TABLE

974: , x_msg_count out nocopy NUMBER
975: , x_msg_data out nocopy VARCHAR2
976: , p_check_login_user VARCHAR2
977: , p_group_id NUMBER
978: , p_role_id_varray JTF_NUMBER_TABLE
979: )
980:
981: as
982: ddp_role_id_varray amv_user_pvt.amv_number_varray_type;

Line 1031: , x_role_id_varray out nocopy JTF_NUMBER_TABLE

1027: , x_msg_data out nocopy VARCHAR2
1028: , p_check_login_user VARCHAR2
1029: , p_group_id NUMBER
1030: , p_check_effective_date VARCHAR2
1031: , x_role_id_varray out nocopy JTF_NUMBER_TABLE
1032: , x_role_code_varray out nocopy JTF_VARCHAR2_TABLE_4000
1033: )
1034:
1035: as

Line 1307: , p14_a0 out nocopy JTF_NUMBER_TABLE

1303: , p_group_usage VARCHAR2
1304: , p13_a0 out nocopy NUMBER
1305: , p13_a1 out nocopy NUMBER
1306: , p13_a2 out nocopy NUMBER
1307: , p14_a0 out nocopy JTF_NUMBER_TABLE
1308: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p14_a2 out nocopy JTF_NUMBER_TABLE
1310: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_300
1311: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1309: , p14_a2 out nocopy JTF_NUMBER_TABLE

1305: , p13_a1 out nocopy NUMBER
1306: , p13_a2 out nocopy NUMBER
1307: , p14_a0 out nocopy JTF_NUMBER_TABLE
1308: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
1309: , p14_a2 out nocopy JTF_NUMBER_TABLE
1310: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_300
1311: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1312: , p14_a5 out nocopy JTF_DATE_TABLE
1313: , p14_a6 out nocopy JTF_DATE_TABLE

Line 1403: , p12_a0 out nocopy JTF_NUMBER_TABLE

1399: , p_group_usage VARCHAR2
1400: , p11_a0 out nocopy NUMBER
1401: , p11_a1 out nocopy NUMBER
1402: , p11_a2 out nocopy NUMBER
1403: , p12_a0 out nocopy JTF_NUMBER_TABLE
1404: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
1405: , p12_a2 out nocopy JTF_NUMBER_TABLE
1406: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_300
1407: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 1405: , p12_a2 out nocopy JTF_NUMBER_TABLE

1401: , p11_a1 out nocopy NUMBER
1402: , p11_a2 out nocopy NUMBER
1403: , p12_a0 out nocopy JTF_NUMBER_TABLE
1404: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
1405: , p12_a2 out nocopy JTF_NUMBER_TABLE
1406: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_300
1407: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_2000
1408: , p12_a5 out nocopy JTF_DATE_TABLE
1409: , p12_a6 out nocopy JTF_DATE_TABLE

Line 1495: , p_resource_id_varray JTF_NUMBER_TABLE

1491: , x_msg_count out nocopy NUMBER
1492: , x_msg_data out nocopy VARCHAR2
1493: , p_check_login_user VARCHAR2
1494: , p_group_id NUMBER
1495: , p_resource_id_varray JTF_NUMBER_TABLE
1496: )
1497:
1498: as
1499: ddp_resource_id_varray amv_user_pvt.amv_number_varray_type;

Line 1548: , p_resource_id_varray JTF_NUMBER_TABLE

1544: , x_msg_count out nocopy NUMBER
1545: , x_msg_data out nocopy VARCHAR2
1546: , p_check_login_user VARCHAR2
1547: , p_group_id NUMBER
1548: , p_resource_id_varray JTF_NUMBER_TABLE
1549: )
1550:
1551: as
1552: ddp_resource_id_varray amv_user_pvt.amv_number_varray_type;

Line 1679: , p8_a0 JTF_NUMBER_TABLE

1675: , x_return_status out nocopy VARCHAR2
1676: , x_msg_count out nocopy NUMBER
1677: , x_msg_data out nocopy VARCHAR2
1678: , p_check_login_user VARCHAR2
1679: , p8_a0 JTF_NUMBER_TABLE
1680: , p8_a1 JTF_NUMBER_TABLE
1681: , p8_a2 JTF_VARCHAR2_TABLE_100
1682: , p8_a3 JTF_NUMBER_TABLE
1683: , p8_a4 JTF_NUMBER_TABLE

Line 1680: , p8_a1 JTF_NUMBER_TABLE

1676: , x_msg_count out nocopy NUMBER
1677: , x_msg_data out nocopy VARCHAR2
1678: , p_check_login_user VARCHAR2
1679: , p8_a0 JTF_NUMBER_TABLE
1680: , p8_a1 JTF_NUMBER_TABLE
1681: , p8_a2 JTF_VARCHAR2_TABLE_100
1682: , p8_a3 JTF_NUMBER_TABLE
1683: , p8_a4 JTF_NUMBER_TABLE
1684: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 1682: , p8_a3 JTF_NUMBER_TABLE

1678: , p_check_login_user VARCHAR2
1679: , p8_a0 JTF_NUMBER_TABLE
1680: , p8_a1 JTF_NUMBER_TABLE
1681: , p8_a2 JTF_VARCHAR2_TABLE_100
1682: , p8_a3 JTF_NUMBER_TABLE
1683: , p8_a4 JTF_NUMBER_TABLE
1684: , p8_a5 JTF_VARCHAR2_TABLE_100
1685: , p8_a6 JTF_DATE_TABLE
1686: , p8_a7 JTF_DATE_TABLE

Line 1683: , p8_a4 JTF_NUMBER_TABLE

1679: , p8_a0 JTF_NUMBER_TABLE
1680: , p8_a1 JTF_NUMBER_TABLE
1681: , p8_a2 JTF_VARCHAR2_TABLE_100
1682: , p8_a3 JTF_NUMBER_TABLE
1683: , p8_a4 JTF_NUMBER_TABLE
1684: , p8_a5 JTF_VARCHAR2_TABLE_100
1685: , p8_a6 JTF_DATE_TABLE
1686: , p8_a7 JTF_DATE_TABLE
1687: , p8_a8 JTF_VARCHAR2_TABLE_100

Line 2424: , p10_a0 out nocopy JTF_NUMBER_TABLE

2420: , p_check_login_user VARCHAR2
2421: , p_user_or_group_id NUMBER
2422: , p_user_or_group_type VARCHAR2
2423: , x_channel_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
2424: , p10_a0 out nocopy JTF_NUMBER_TABLE
2425: , p10_a1 out nocopy JTF_NUMBER_TABLE
2426: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2427: , p10_a3 out nocopy JTF_NUMBER_TABLE
2428: , p10_a4 out nocopy JTF_NUMBER_TABLE

Line 2425: , p10_a1 out nocopy JTF_NUMBER_TABLE

2421: , p_user_or_group_id NUMBER
2422: , p_user_or_group_type VARCHAR2
2423: , x_channel_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
2424: , p10_a0 out nocopy JTF_NUMBER_TABLE
2425: , p10_a1 out nocopy JTF_NUMBER_TABLE
2426: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2427: , p10_a3 out nocopy JTF_NUMBER_TABLE
2428: , p10_a4 out nocopy JTF_NUMBER_TABLE
2429: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 2427: , p10_a3 out nocopy JTF_NUMBER_TABLE

2423: , x_channel_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
2424: , p10_a0 out nocopy JTF_NUMBER_TABLE
2425: , p10_a1 out nocopy JTF_NUMBER_TABLE
2426: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2427: , p10_a3 out nocopy JTF_NUMBER_TABLE
2428: , p10_a4 out nocopy JTF_NUMBER_TABLE
2429: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
2430: , p10_a6 out nocopy JTF_DATE_TABLE
2431: , p10_a7 out nocopy JTF_DATE_TABLE

Line 2428: , p10_a4 out nocopy JTF_NUMBER_TABLE

2424: , p10_a0 out nocopy JTF_NUMBER_TABLE
2425: , p10_a1 out nocopy JTF_NUMBER_TABLE
2426: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2427: , p10_a3 out nocopy JTF_NUMBER_TABLE
2428: , p10_a4 out nocopy JTF_NUMBER_TABLE
2429: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
2430: , p10_a6 out nocopy JTF_DATE_TABLE
2431: , p10_a7 out nocopy JTF_DATE_TABLE
2432: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 2514: , p10_a0 out nocopy JTF_NUMBER_TABLE

2510: , p_check_login_user VARCHAR2
2511: , p_channel_id NUMBER
2512: , p_user_or_group_type VARCHAR2
2513: , x_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
2514: , p10_a0 out nocopy JTF_NUMBER_TABLE
2515: , p10_a1 out nocopy JTF_NUMBER_TABLE
2516: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2517: , p10_a3 out nocopy JTF_NUMBER_TABLE
2518: , p10_a4 out nocopy JTF_NUMBER_TABLE

Line 2515: , p10_a1 out nocopy JTF_NUMBER_TABLE

2511: , p_channel_id NUMBER
2512: , p_user_or_group_type VARCHAR2
2513: , x_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
2514: , p10_a0 out nocopy JTF_NUMBER_TABLE
2515: , p10_a1 out nocopy JTF_NUMBER_TABLE
2516: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2517: , p10_a3 out nocopy JTF_NUMBER_TABLE
2518: , p10_a4 out nocopy JTF_NUMBER_TABLE
2519: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 2517: , p10_a3 out nocopy JTF_NUMBER_TABLE

2513: , x_name_varray out nocopy JTF_VARCHAR2_TABLE_4000
2514: , p10_a0 out nocopy JTF_NUMBER_TABLE
2515: , p10_a1 out nocopy JTF_NUMBER_TABLE
2516: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2517: , p10_a3 out nocopy JTF_NUMBER_TABLE
2518: , p10_a4 out nocopy JTF_NUMBER_TABLE
2519: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
2520: , p10_a6 out nocopy JTF_DATE_TABLE
2521: , p10_a7 out nocopy JTF_DATE_TABLE

Line 2518: , p10_a4 out nocopy JTF_NUMBER_TABLE

2514: , p10_a0 out nocopy JTF_NUMBER_TABLE
2515: , p10_a1 out nocopy JTF_NUMBER_TABLE
2516: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
2517: , p10_a3 out nocopy JTF_NUMBER_TABLE
2518: , p10_a4 out nocopy JTF_NUMBER_TABLE
2519: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
2520: , p10_a6 out nocopy JTF_DATE_TABLE
2521: , p10_a7 out nocopy JTF_DATE_TABLE
2522: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100