eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_MYCHANNEL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE) as

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

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

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

Line 52: a0 := JTF_NUMBER_TABLE();

48: begin
49: if t is null then
50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: if t.count > 0 then
56: a0.extend(t.count);

Line 54: a0 := JTF_NUMBER_TABLE();

50: a0 := null;
51: elsif t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: else
54: a0 := JTF_NUMBER_TABLE();
55: if t.count > 0 then
56: a0.extend(t.count);
57: ddindx := t.first;
58: indx := 1;

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

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

Line 72: , a1 JTF_NUMBER_TABLE

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

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

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

Line 99: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 109: a0 := JTF_NUMBER_TABLE();

105: a0 := null;
106: a1 := null;
107: a2 := null;
108: elsif t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_300();
112: else
113: a0 := JTF_NUMBER_TABLE();

Line 110: a1 := JTF_NUMBER_TABLE();

106: a1 := null;
107: a2 := null;
108: elsif t.count = 0 then
109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_300();
112: else
113: a0 := JTF_NUMBER_TABLE();
114: a1 := JTF_NUMBER_TABLE();

Line 113: a0 := JTF_NUMBER_TABLE();

109: a0 := JTF_NUMBER_TABLE();
110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_300();
112: else
113: a0 := JTF_NUMBER_TABLE();
114: a1 := JTF_NUMBER_TABLE();
115: a2 := JTF_VARCHAR2_TABLE_300();
116: if t.count > 0 then
117: a0.extend(t.count);

Line 114: a1 := JTF_NUMBER_TABLE();

110: a1 := JTF_NUMBER_TABLE();
111: a2 := JTF_VARCHAR2_TABLE_300();
112: else
113: a0 := JTF_NUMBER_TABLE();
114: a1 := JTF_NUMBER_TABLE();
115: a2 := JTF_VARCHAR2_TABLE_300();
116: if t.count > 0 then
117: a0.extend(t.count);
118: a1.extend(t.count);

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

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

Line 139: , a3 JTF_NUMBER_TABLE

135:
136: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_VARCHAR2_TABLE_100
138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100

Line 141: , a5 JTF_NUMBER_TABLE

137: , a1 JTF_VARCHAR2_TABLE_100
138: , a2 JTF_VARCHAR2_TABLE_100
139: , a3 JTF_NUMBER_TABLE
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100

Line 144: , a8 JTF_NUMBER_TABLE

140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_VARCHAR2_TABLE_100
147: , a11 JTF_VARCHAR2_TABLE_100
148: ) as

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

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

Line 184: , a3 out nocopy JTF_NUMBER_TABLE

180: end rosetta_table_copy_in_p6;
181: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
182: , a1 out nocopy JTF_VARCHAR2_TABLE_100
183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 186: , a5 out nocopy JTF_NUMBER_TABLE

182: , a1 out nocopy JTF_VARCHAR2_TABLE_100
183: , a2 out nocopy JTF_VARCHAR2_TABLE_100
184: , a3 out nocopy JTF_NUMBER_TABLE
185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 189: , a8 out nocopy JTF_NUMBER_TABLE

185: , a4 out nocopy JTF_VARCHAR2_TABLE_100
186: , a5 out nocopy JTF_NUMBER_TABLE
187: , a6 out nocopy JTF_VARCHAR2_TABLE_100
188: , a7 out nocopy JTF_VARCHAR2_TABLE_100
189: , a8 out nocopy JTF_NUMBER_TABLE
190: , a9 out nocopy JTF_VARCHAR2_TABLE_100
191: , a10 out nocopy JTF_VARCHAR2_TABLE_100
192: , a11 out nocopy JTF_VARCHAR2_TABLE_100
193: ) as

Line 210: a0 := JTF_NUMBER_TABLE();

206: a9 := null;
207: a10 := null;
208: a11 := null;
209: elsif t.count = 0 then
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();

Line 213: a3 := JTF_NUMBER_TABLE();

209: elsif t.count = 0 then
210: a0 := JTF_NUMBER_TABLE();
211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();

Line 215: a5 := JTF_NUMBER_TABLE();

211: a1 := JTF_VARCHAR2_TABLE_100();
212: a2 := JTF_VARCHAR2_TABLE_100();
213: a3 := JTF_NUMBER_TABLE();
214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();

Line 218: a8 := JTF_NUMBER_TABLE();

214: a4 := JTF_VARCHAR2_TABLE_100();
215: a5 := JTF_NUMBER_TABLE();
216: a6 := JTF_VARCHAR2_TABLE_100();
217: a7 := JTF_VARCHAR2_TABLE_100();
218: a8 := JTF_NUMBER_TABLE();
219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: else

Line 223: a0 := JTF_NUMBER_TABLE();

219: a9 := JTF_VARCHAR2_TABLE_100();
220: a10 := JTF_VARCHAR2_TABLE_100();
221: a11 := JTF_VARCHAR2_TABLE_100();
222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();

Line 226: a3 := JTF_NUMBER_TABLE();

222: else
223: a0 := JTF_NUMBER_TABLE();
224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();

Line 228: a5 := JTF_NUMBER_TABLE();

224: a1 := JTF_VARCHAR2_TABLE_100();
225: a2 := JTF_VARCHAR2_TABLE_100();
226: a3 := JTF_NUMBER_TABLE();
227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();

Line 231: a8 := JTF_NUMBER_TABLE();

227: a4 := JTF_VARCHAR2_TABLE_100();
228: a5 := JTF_NUMBER_TABLE();
229: a6 := JTF_VARCHAR2_TABLE_100();
230: a7 := JTF_VARCHAR2_TABLE_100();
231: a8 := JTF_NUMBER_TABLE();
232: a9 := JTF_VARCHAR2_TABLE_100();
233: a10 := JTF_VARCHAR2_TABLE_100();
234: a11 := JTF_VARCHAR2_TABLE_100();
235: if t.count > 0 then

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

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

Line 279: , a6 JTF_NUMBER_TABLE

275: , a2 JTF_DATE_TABLE
276: , a3 JTF_DATE_TABLE
277: , a4 JTF_DATE_TABLE
278: , a5 JTF_VARCHAR2_TABLE_100
279: , a6 JTF_NUMBER_TABLE
280: , a7 JTF_VARCHAR2_TABLE_100
281: ) as
282: ddindx binary_integer; indx binary_integer;
283: begin

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

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

Line 316: , a6 out nocopy JTF_NUMBER_TABLE

312: , a2 out nocopy JTF_DATE_TABLE
313: , a3 out nocopy JTF_DATE_TABLE
314: , a4 out nocopy JTF_DATE_TABLE
315: , a5 out nocopy JTF_VARCHAR2_TABLE_100
316: , a6 out nocopy JTF_NUMBER_TABLE
317: , a7 out nocopy JTF_VARCHAR2_TABLE_100
318: ) as
319: ddindx binary_integer; indx binary_integer;
320: begin

Line 331: a0 := JTF_NUMBER_TABLE();

327: a5 := null;
328: a6 := null;
329: a7 := null;
330: elsif t.count = 0 then
331: a0 := JTF_NUMBER_TABLE();
332: a1 := JTF_VARCHAR2_TABLE_4000();
333: a2 := JTF_DATE_TABLE();
334: a3 := JTF_DATE_TABLE();
335: a4 := JTF_DATE_TABLE();

Line 337: a6 := JTF_NUMBER_TABLE();

333: a2 := JTF_DATE_TABLE();
334: a3 := JTF_DATE_TABLE();
335: a4 := JTF_DATE_TABLE();
336: a5 := JTF_VARCHAR2_TABLE_100();
337: a6 := JTF_NUMBER_TABLE();
338: a7 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_VARCHAR2_TABLE_4000();

Line 340: a0 := JTF_NUMBER_TABLE();

336: a5 := JTF_VARCHAR2_TABLE_100();
337: a6 := JTF_NUMBER_TABLE();
338: a7 := JTF_VARCHAR2_TABLE_100();
339: else
340: a0 := JTF_NUMBER_TABLE();
341: a1 := JTF_VARCHAR2_TABLE_4000();
342: a2 := JTF_DATE_TABLE();
343: a3 := JTF_DATE_TABLE();
344: a4 := JTF_DATE_TABLE();

Line 346: a6 := JTF_NUMBER_TABLE();

342: a2 := JTF_DATE_TABLE();
343: a3 := JTF_DATE_TABLE();
344: a4 := JTF_DATE_TABLE();
345: a5 := JTF_VARCHAR2_TABLE_100();
346: a6 := JTF_NUMBER_TABLE();
347: a7 := JTF_VARCHAR2_TABLE_100();
348: if t.count > 0 then
349: a0.extend(t.count);
350: a1.extend(t.count);

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

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

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

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

Line 420: a0 := JTF_NUMBER_TABLE();

416: a1 := null;
417: a2 := null;
418: a3 := null;
419: elsif t.count = 0 then
420: a0 := JTF_NUMBER_TABLE();
421: a1 := JTF_VARCHAR2_TABLE_300();
422: a2 := JTF_VARCHAR2_TABLE_2000();
423: a3 := JTF_VARCHAR2_TABLE_100();
424: else

Line 425: a0 := JTF_NUMBER_TABLE();

421: a1 := JTF_VARCHAR2_TABLE_300();
422: a2 := JTF_VARCHAR2_TABLE_2000();
423: a3 := JTF_VARCHAR2_TABLE_100();
424: else
425: a0 := JTF_NUMBER_TABLE();
426: a1 := JTF_VARCHAR2_TABLE_300();
427: a2 := JTF_VARCHAR2_TABLE_2000();
428: a3 := JTF_VARCHAR2_TABLE_100();
429: if t.count > 0 then

Line 605: , p8_a0 out nocopy JTF_NUMBER_TABLE

601: , x_msg_count out nocopy NUMBER
602: , x_msg_data out nocopy VARCHAR2
603: , p_check_login_user VARCHAR2
604: , p_user_id NUMBER
605: , p8_a0 out nocopy JTF_NUMBER_TABLE
606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 608: , p8_a3 out nocopy JTF_NUMBER_TABLE

604: , p_user_id NUMBER
605: , p8_a0 out nocopy JTF_NUMBER_TABLE
606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 610: , p8_a5 out nocopy JTF_NUMBER_TABLE

606: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
607: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
608: , p8_a3 out nocopy JTF_NUMBER_TABLE
609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 613: , p8_a8 out nocopy JTF_NUMBER_TABLE

609: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
610: , p8_a5 out nocopy JTF_NUMBER_TABLE
611: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
612: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
613: , p8_a8 out nocopy JTF_NUMBER_TABLE
614: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
615: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
616: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
617: )

Line 678: , x_channel_array out nocopy JTF_NUMBER_TABLE

674: , x_msg_data out nocopy VARCHAR2
675: , p_check_login_user VARCHAR2
676: , p_user_id NUMBER
677: , p_category_id NUMBER
678: , x_channel_array out nocopy JTF_NUMBER_TABLE
679: )
680:
681: as
682: ddx_channel_array amv_mychannel_pvt.amv_number_varray_type;

Line 734: , p12_a0 out nocopy JTF_NUMBER_TABLE

730: , p_user_id NUMBER
731: , p_user_name VARCHAR2
732: , p_notification_type VARCHAR2
733: , x_notification_url out nocopy VARCHAR2
734: , p12_a0 out nocopy JTF_NUMBER_TABLE
735: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_4000
736: , p12_a2 out nocopy JTF_DATE_TABLE
737: , p12_a3 out nocopy JTF_DATE_TABLE
738: , p12_a4 out nocopy JTF_DATE_TABLE

Line 740: , p12_a6 out nocopy JTF_NUMBER_TABLE

736: , p12_a2 out nocopy JTF_DATE_TABLE
737: , p12_a3 out nocopy JTF_DATE_TABLE
738: , p12_a4 out nocopy JTF_DATE_TABLE
739: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
740: , p12_a6 out nocopy JTF_NUMBER_TABLE
741: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
742: )
743:
744: as

Line 813: , p10_a0 out nocopy JTF_NUMBER_TABLE

809: , p_user_id NUMBER
810: , p9_a0 out nocopy NUMBER
811: , p9_a1 out nocopy NUMBER
812: , p9_a2 out nocopy NUMBER
813: , p10_a0 out nocopy JTF_NUMBER_TABLE
814: , p10_a1 out nocopy JTF_NUMBER_TABLE
815: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
816: , p8_a0 NUMBER := 0-1962.0724
817: , p8_a1 NUMBER := 0-1962.0724

Line 814: , p10_a1 out nocopy JTF_NUMBER_TABLE

810: , p9_a0 out nocopy NUMBER
811: , p9_a1 out nocopy NUMBER
812: , p9_a2 out nocopy NUMBER
813: , p10_a0 out nocopy JTF_NUMBER_TABLE
814: , p10_a1 out nocopy JTF_NUMBER_TABLE
815: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
816: , p8_a0 NUMBER := 0-1962.0724
817: , p8_a1 NUMBER := 0-1962.0724
818: , p8_a2 VARCHAR2 := fnd_api.g_miss_char

Line 888: , p11_a0 out nocopy JTF_NUMBER_TABLE

884: , p_user_id NUMBER
885: , p10_a0 out nocopy NUMBER
886: , p10_a1 out nocopy NUMBER
887: , p10_a2 out nocopy NUMBER
888: , p11_a0 out nocopy JTF_NUMBER_TABLE
889: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_300
890: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_2000
891: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
892: , p9_a0 NUMBER := 0-1962.0724