DBA Data[Home] [Help]

APPS.JTF_UM_SUBSCRIPTION_INFO_W dependencies on JTF_VARCHAR2_TABLE_2000

Line 24: , a2 JTF_VARCHAR2_TABLE_2000

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

Line 71: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 90: a2 := JTF_VARCHAR2_TABLE_2000();

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

Line 106: a2 := JTF_VARCHAR2_TABLE_2000();

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

Line 211: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 271: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 338: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000

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

Line 410: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000

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