DBA Data[Home] [Help]

APPS.JTF_UM_SUBSCRIPTION_INFO_W dependencies on JTF_VARCHAR2_TABLE_1000

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