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_NUMBER_TABLE

Line 25: , a3 JTF_NUMBER_TABLE

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
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE

Line 27: , a5 JTF_NUMBER_TABLE

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
31: , a9 JTF_NUMBER_TABLE

Line 28: , a6 JTF_NUMBER_TABLE

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
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE

Line 29: , a7 JTF_NUMBER_TABLE

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
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE

Line 30: , a8 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
31: , a9 JTF_NUMBER_TABLE
32: , a10 JTF_NUMBER_TABLE
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_VARCHAR2_TABLE_100

Line 31: , a9 JTF_NUMBER_TABLE

27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
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

Line 32: , a10 JTF_NUMBER_TABLE

28: , a6 JTF_NUMBER_TABLE
29: , a7 JTF_NUMBER_TABLE
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

Line 33: , a11 JTF_NUMBER_TABLE

29: , a7 JTF_NUMBER_TABLE
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

Line 72: , a3 out nocopy JTF_NUMBER_TABLE

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
75: , a6 out nocopy JTF_NUMBER_TABLE
76: , a7 out nocopy JTF_NUMBER_TABLE

Line 74: , a5 out nocopy JTF_NUMBER_TABLE

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
78: , a9 out nocopy JTF_NUMBER_TABLE

Line 75: , a6 out nocopy JTF_NUMBER_TABLE

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
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE

Line 76: , a7 out nocopy JTF_NUMBER_TABLE

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
78: , a9 out nocopy JTF_NUMBER_TABLE
79: , a10 out nocopy JTF_NUMBER_TABLE
80: , a11 out nocopy JTF_NUMBER_TABLE

Line 77: , a8 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
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

Line 78: , a9 out nocopy JTF_NUMBER_TABLE

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
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

Line 79: , a10 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
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

Line 80: , a11 out nocopy JTF_NUMBER_TABLE

76: , a7 out nocopy JTF_NUMBER_TABLE
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

Line 91: a3 := JTF_NUMBER_TABLE();

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();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();

Line 93: a5 := JTF_NUMBER_TABLE();

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();
97: a9 := JTF_NUMBER_TABLE();

Line 94: a6 := JTF_NUMBER_TABLE();

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();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();

Line 95: a7 := JTF_NUMBER_TABLE();

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();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();

Line 96: a8 := 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();
97: a9 := JTF_NUMBER_TABLE();
98: a10 := JTF_NUMBER_TABLE();
99: a11 := JTF_NUMBER_TABLE();
100: a12 := JTF_VARCHAR2_TABLE_100();

Line 97: a9 := JTF_NUMBER_TABLE();

93: a5 := JTF_NUMBER_TABLE();
94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
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();

Line 98: a10 := JTF_NUMBER_TABLE();

94: a6 := JTF_NUMBER_TABLE();
95: a7 := JTF_NUMBER_TABLE();
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();

Line 99: a11 := JTF_NUMBER_TABLE();

95: a7 := JTF_NUMBER_TABLE();
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

Line 107: a3 := JTF_NUMBER_TABLE();

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();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();

Line 109: a5 := JTF_NUMBER_TABLE();

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();
113: a9 := JTF_NUMBER_TABLE();

Line 110: a6 := JTF_NUMBER_TABLE();

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();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();

Line 111: a7 := JTF_NUMBER_TABLE();

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();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();

Line 112: a8 := 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();
113: a9 := JTF_NUMBER_TABLE();
114: a10 := JTF_NUMBER_TABLE();
115: a11 := JTF_NUMBER_TABLE();
116: a12 := JTF_VARCHAR2_TABLE_100();

Line 113: a9 := JTF_NUMBER_TABLE();

109: a5 := JTF_NUMBER_TABLE();
110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
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();

Line 114: a10 := JTF_NUMBER_TABLE();

110: a6 := JTF_NUMBER_TABLE();
111: a7 := JTF_NUMBER_TABLE();
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();

Line 115: a11 := JTF_NUMBER_TABLE();

111: a7 := JTF_NUMBER_TABLE();
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

Line 163: procedure rosetta_table_copy_in_p3(t out nocopy jtf_um_subscription_info.subscription_list, a0 JTF_NUMBER_TABLE

159: end if;
160: end if;
161: end rosetta_table_copy_out_p2;
162:
163: procedure rosetta_table_copy_in_p3(t out nocopy jtf_um_subscription_info.subscription_list, a0 JTF_NUMBER_TABLE
164: ) as
165: ddindx binary_integer; indx binary_integer;
166: begin
167: if a0 is not null and a0.count > 0 then

Line 182: procedure rosetta_table_copy_out_p3(t jtf_um_subscription_info.subscription_list, a0 out nocopy JTF_NUMBER_TABLE

178: end loop;
179: end if;
180: end if;
181: end rosetta_table_copy_in_p3;
182: procedure rosetta_table_copy_out_p3(t jtf_um_subscription_info.subscription_list, a0 out nocopy JTF_NUMBER_TABLE
183: ) as
184: ddindx binary_integer; indx binary_integer;
185: begin
186: if t is null or t.count = 0 then

Line 187: a0 := JTF_NUMBER_TABLE();

183: ) as
184: ddindx binary_integer; indx binary_integer;
185: begin
186: if t is null or t.count = 0 then
187: a0 := JTF_NUMBER_TABLE();
188: else
189: a0 := JTF_NUMBER_TABLE();
190: if t.count > 0 then
191: a0.extend(t.count);

Line 189: a0 := JTF_NUMBER_TABLE();

185: begin
186: if t is null or t.count = 0 then
187: a0 := JTF_NUMBER_TABLE();
188: else
189: a0 := JTF_NUMBER_TABLE();
190: if t.count > 0 then
191: a0.extend(t.count);
192: ddindx := t.first;
193: indx := 1;

Line 212: , p3_a3 out nocopy JTF_NUMBER_TABLE

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
215: , p3_a6 out nocopy JTF_NUMBER_TABLE
216: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 214: , p3_a5 out nocopy JTF_NUMBER_TABLE

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
218: , p3_a9 out nocopy JTF_NUMBER_TABLE

Line 215: , p3_a6 out nocopy JTF_NUMBER_TABLE

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
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 216: , p3_a7 out nocopy JTF_NUMBER_TABLE

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
218: , p3_a9 out nocopy JTF_NUMBER_TABLE
219: , p3_a10 out nocopy JTF_NUMBER_TABLE
220: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 217: , p3_a8 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
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

Line 218: , p3_a9 out nocopy JTF_NUMBER_TABLE

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
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

Line 219: , p3_a10 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
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

Line 220: , p3_a11 out nocopy JTF_NUMBER_TABLE

216: , p3_a7 out nocopy JTF_NUMBER_TABLE
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: )

Line 272: , p5_a3 out nocopy JTF_NUMBER_TABLE

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
275: , p5_a6 out nocopy JTF_NUMBER_TABLE
276: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 274: , p5_a5 out nocopy JTF_NUMBER_TABLE

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
278: , p5_a9 out nocopy JTF_NUMBER_TABLE

Line 275: , p5_a6 out nocopy JTF_NUMBER_TABLE

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
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE

Line 276: , p5_a7 out nocopy JTF_NUMBER_TABLE

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
278: , p5_a9 out nocopy JTF_NUMBER_TABLE
279: , p5_a10 out nocopy JTF_NUMBER_TABLE
280: , p5_a11 out nocopy JTF_NUMBER_TABLE

Line 277: , p5_a8 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
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

Line 278: , p5_a9 out nocopy JTF_NUMBER_TABLE

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
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

Line 279: , p5_a10 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
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

Line 280: , p5_a11 out nocopy JTF_NUMBER_TABLE

276: , p5_a7 out nocopy JTF_NUMBER_TABLE
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: )

Line 335: , p5_a0 JTF_NUMBER_TABLE

331: , p_usertype_id NUMBER
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

Line 339: , p6_a3 out nocopy JTF_NUMBER_TABLE

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
342: , p6_a6 out nocopy JTF_NUMBER_TABLE
343: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 341: , p6_a5 out nocopy JTF_NUMBER_TABLE

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
345: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 342: , p6_a6 out nocopy JTF_NUMBER_TABLE

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
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 343: , p6_a7 out nocopy JTF_NUMBER_TABLE

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
345: , p6_a9 out nocopy JTF_NUMBER_TABLE
346: , p6_a10 out nocopy JTF_NUMBER_TABLE
347: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 344: , p6_a8 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
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

Line 345: , p6_a9 out nocopy JTF_NUMBER_TABLE

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
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

Line 346: , p6_a10 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
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

Line 347: , p6_a11 out nocopy JTF_NUMBER_TABLE

343: , p6_a7 out nocopy JTF_NUMBER_TABLE
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: )

Line 407: , p4_a0 JTF_NUMBER_TABLE

403: procedure get_usertype_sub(p_usertype_id NUMBER
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

Line 411: , p5_a3 out nocopy JTF_NUMBER_TABLE

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
414: , p5_a6 out nocopy JTF_NUMBER_TABLE
415: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 413: , p5_a5 out nocopy JTF_NUMBER_TABLE

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
417: , p5_a9 out nocopy JTF_NUMBER_TABLE

Line 414: , p5_a6 out nocopy JTF_NUMBER_TABLE

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
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE

Line 415: , p5_a7 out nocopy JTF_NUMBER_TABLE

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
417: , p5_a9 out nocopy JTF_NUMBER_TABLE
418: , p5_a10 out nocopy JTF_NUMBER_TABLE
419: , p5_a11 out nocopy JTF_NUMBER_TABLE

Line 416: , p5_a8 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
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

Line 417: , p5_a9 out nocopy JTF_NUMBER_TABLE

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
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

Line 418: , p5_a10 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
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

Line 419: , p5_a11 out nocopy JTF_NUMBER_TABLE

415: , p5_a7 out nocopy JTF_NUMBER_TABLE
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: )