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.JTF_UM_SUBSCRIPTION_INFO_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_2000
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_NUMBER_TABLE

Line 34: , a12 JTF_VARCHAR2_TABLE_100

30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100
35: , a13 JTF_VARCHAR2_TABLE_300
36: , a14 JTF_VARCHAR2_TABLE_300
37: ) as
38: ddindx binary_integer; indx binary_integer;

Line 69: procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000

65: end loop;
66: end if;
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , a1 out nocopy JTF_VARCHAR2_TABLE_100

66: end if;
67: end if;
68: end rosetta_table_copy_in_p2;
69: procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE

Line 73: , a4 out nocopy JTF_VARCHAR2_TABLE_100

69: procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000
70: , a1 out nocopy JTF_VARCHAR2_TABLE_100
71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
72: , a3 out nocopy JTF_NUMBER_TABLE
73: , a4 out nocopy JTF_VARCHAR2_TABLE_100
74: , a5 out nocopy JTF_NUMBER_TABLE
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE
77: , a8 out nocopy JTF_NUMBER_TABLE

Line 81: , a12 out nocopy JTF_VARCHAR2_TABLE_100

77: , a8 out nocopy JTF_NUMBER_TABLE
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE
81: , a12 out nocopy JTF_VARCHAR2_TABLE_100
82: , a13 out nocopy JTF_VARCHAR2_TABLE_300
83: , a14 out nocopy JTF_VARCHAR2_TABLE_300
84: ) as
85: ddindx binary_integer; indx binary_integer;

Line 88: a0 := JTF_VARCHAR2_TABLE_1000();

84: ) as
85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
88: a0 := JTF_VARCHAR2_TABLE_1000();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_2000();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();

Line 89: a1 := JTF_VARCHAR2_TABLE_100();

85: ddindx binary_integer; indx binary_integer;
86: begin
87: if t is null or t.count = 0 then
88: a0 := JTF_VARCHAR2_TABLE_1000();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_2000();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();

Line 92: a4 := JTF_VARCHAR2_TABLE_100();

88: a0 := JTF_VARCHAR2_TABLE_1000();
89: a1 := JTF_VARCHAR2_TABLE_100();
90: a2 := JTF_VARCHAR2_TABLE_2000();
91: a3 := JTF_NUMBER_TABLE();
92: a4 := JTF_VARCHAR2_TABLE_100();
93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
96: a8 := JTF_NUMBER_TABLE();

Line 100: a12 := JTF_VARCHAR2_TABLE_100();

96: a8 := JTF_NUMBER_TABLE();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
103: else
104: a0 := JTF_VARCHAR2_TABLE_1000();

Line 104: a0 := JTF_VARCHAR2_TABLE_1000();

100: a12 := JTF_VARCHAR2_TABLE_100();
101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
103: else
104: a0 := JTF_VARCHAR2_TABLE_1000();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_VARCHAR2_TABLE_2000();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();

Line 105: a1 := JTF_VARCHAR2_TABLE_100();

101: a13 := JTF_VARCHAR2_TABLE_300();
102: a14 := JTF_VARCHAR2_TABLE_300();
103: else
104: a0 := JTF_VARCHAR2_TABLE_1000();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_VARCHAR2_TABLE_2000();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();

Line 108: a4 := JTF_VARCHAR2_TABLE_100();

104: a0 := JTF_VARCHAR2_TABLE_1000();
105: a1 := JTF_VARCHAR2_TABLE_100();
106: a2 := JTF_VARCHAR2_TABLE_2000();
107: a3 := JTF_NUMBER_TABLE();
108: a4 := JTF_VARCHAR2_TABLE_100();
109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
112: a8 := JTF_NUMBER_TABLE();

Line 116: a12 := JTF_VARCHAR2_TABLE_100();

112: a8 := JTF_NUMBER_TABLE();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();
117: a13 := JTF_VARCHAR2_TABLE_300();
118: a14 := JTF_VARCHAR2_TABLE_300();
119: if t.count > 0 then
120: a0.extend(t.count);

Line 209: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000

205:
206: procedure get_usertype_sub_info(p_usertype_id NUMBER
207: , p_user_id NUMBER
208: , p_is_admin NUMBER
209: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000
210: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 210: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

206: procedure get_usertype_sub_info(p_usertype_id NUMBER
207: , p_user_id NUMBER
208: , p_is_admin NUMBER
209: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000
210: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

209: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000
210: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
212: , p3_a3 out nocopy JTF_NUMBER_TABLE
213: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
214: , p3_a5 out nocopy JTF_NUMBER_TABLE
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE
217: , p3_a8 out nocopy JTF_NUMBER_TABLE

Line 221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

217: , p3_a8 out nocopy JTF_NUMBER_TABLE
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE
221: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
222: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
223: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
224: )
225:

Line 269: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000

265: , p_is_admin NUMBER
266: , p_logged_in_user_id NUMBER
267: , p_administrator NUMBER
268: , p_sub_status VARCHAR2
269: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 270: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100

266: , p_logged_in_user_id NUMBER
267: , p_administrator NUMBER
268: , p_sub_status VARCHAR2
269: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

269: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
272: , p5_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a5 out nocopy JTF_NUMBER_TABLE
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE
277: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

277: , p5_a8 out nocopy JTF_NUMBER_TABLE
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE
281: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
282: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
283: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
284: )
285:

Line 336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000

332: , p_is_admin NUMBER
333: , p_admin_id NUMBER
334: , p_administrator NUMBER
335: , p5_a0 JTF_NUMBER_TABLE
336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

333: , p_admin_id NUMBER
334: , p_administrator NUMBER
335: , p5_a0 JTF_NUMBER_TABLE
336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

336: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
337: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
339: , p6_a3 out nocopy JTF_NUMBER_TABLE
340: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a5 out nocopy JTF_NUMBER_TABLE
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE
344: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100

344: , p6_a8 out nocopy JTF_NUMBER_TABLE
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE
348: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
350: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
351: )
352:

Line 408: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000

404: , p_user_id NUMBER
405: , p_is_admin NUMBER
406: , p_admin_id NUMBER
407: , p4_a0 JTF_NUMBER_TABLE
408: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100

405: , p_is_admin NUMBER
406: , p_admin_id NUMBER
407: , p4_a0 JTF_NUMBER_TABLE
408: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

408: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
409: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
411: , p5_a3 out nocopy JTF_NUMBER_TABLE
412: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
413: , p5_a5 out nocopy JTF_NUMBER_TABLE
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE
416: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100

416: , p5_a8 out nocopy JTF_NUMBER_TABLE
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE
420: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
421: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
422: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
423: )
424: