APPS.JTF_UM_SUBSCRIPTION_INFO_W dependencies on JTF_VARCHAR2_TABLE_1000

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

1: package jtf_um_subscription_info_w AUTHID CURRENT_USER as
2: /* $Header: JTFWSBIS.pls 120.2 2005/09/02 18:36:20 applrt ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy jtf_um_subscription_info.subscription_info_table, a0 JTF_VARCHAR2_TABLE_1000
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

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

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_300
18: );
19: procedure rosetta_table_copy_out_p2(t jtf_um_subscription_info.subscription_info_table, a0 out nocopy JTF_VARCHAR2_TABLE_1000
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000

40:
41: procedure get_usertype_sub_info(p_usertype_id NUMBER
42: , p_user_id NUMBER
43: , p_is_admin NUMBER
44: , p3_a0 out nocopy JTF_VARCHAR2_TABLE_1000
45: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
46: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_2000
47: , p3_a3 out nocopy JTF_NUMBER_TABLE
48: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 65: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000

61: , p_is_admin NUMBER
62: , p_logged_in_user_id NUMBER
63: , p_administrator NUMBER
64: , p_sub_status VARCHAR2
65: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
66: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
67: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
68: , p5_a3 out nocopy JTF_NUMBER_TABLE
69: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000

83: , p_is_admin NUMBER
84: , p_admin_id NUMBER
85: , p_administrator NUMBER
86: , p5_a0 JTF_NUMBER_TABLE
87: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
88: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
89: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
90: , p6_a3 out nocopy JTF_NUMBER_TABLE
91: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000

104: , p_user_id NUMBER
105: , p_is_admin NUMBER
106: , p_admin_id NUMBER
107: , p4_a0 JTF_NUMBER_TABLE
108: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
109: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
110: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_2000
111: , p5_a3 out nocopy JTF_NUMBER_TABLE
112: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100