APPS.JTF_UM_SUBSCRIPTION_INFO_W dependencies on JTF_VARCHAR2_TABLE_300

Line 16: , a13 JTF_VARCHAR2_TABLE_300

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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

Line 17: , a14 JTF_VARCHAR2_TABLE_300

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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

Line 32: , a13 out nocopy JTF_VARCHAR2_TABLE_300

28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_300
33: , a14 out nocopy JTF_VARCHAR2_TABLE_300
34: );
35:
36: procedure rosetta_table_copy_in_p3(t out nocopy jtf_um_subscription_info.subscription_list, a0 JTF_NUMBER_TABLE

Line 33: , a14 out nocopy JTF_VARCHAR2_TABLE_300

29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_300
33: , a14 out nocopy JTF_VARCHAR2_TABLE_300
34: );
35:
36: procedure rosetta_table_copy_in_p3(t out nocopy jtf_um_subscription_info.subscription_list, a0 JTF_NUMBER_TABLE
37: );

Line 57: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300

53: , p3_a9 out nocopy JTF_NUMBER_TABLE
54: , p3_a10 out nocopy JTF_NUMBER_TABLE
55: , p3_a11 out nocopy JTF_NUMBER_TABLE
56: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
58: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
59: );
60: procedure get_user_sub_info(p_user_id NUMBER
61: , p_is_admin NUMBER

Line 58: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300

54: , p3_a10 out nocopy JTF_NUMBER_TABLE
55: , p3_a11 out nocopy JTF_NUMBER_TABLE
56: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_300
58: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_300
59: );
60: procedure get_user_sub_info(p_user_id NUMBER
61: , p_is_admin NUMBER
62: , p_logged_in_user_id NUMBER

Line 78: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300

74: , p5_a9 out nocopy JTF_NUMBER_TABLE
75: , p5_a10 out nocopy JTF_NUMBER_TABLE
76: , p5_a11 out nocopy JTF_NUMBER_TABLE
77: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
78: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
79: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
80: );
81: procedure get_conf_sub_info(p_user_id NUMBER
82: , p_usertype_id NUMBER

Line 79: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300

75: , p5_a10 out nocopy JTF_NUMBER_TABLE
76: , p5_a11 out nocopy JTF_NUMBER_TABLE
77: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
78: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
79: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
80: );
81: procedure get_conf_sub_info(p_user_id NUMBER
82: , p_usertype_id NUMBER
83: , p_is_admin NUMBER

Line 100: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300

96: , p6_a9 out nocopy JTF_NUMBER_TABLE
97: , p6_a10 out nocopy JTF_NUMBER_TABLE
98: , p6_a11 out nocopy JTF_NUMBER_TABLE
99: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
101: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
102: );
103: procedure get_usertype_sub(p_usertype_id NUMBER
104: , p_user_id NUMBER

Line 101: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300

97: , p6_a10 out nocopy JTF_NUMBER_TABLE
98: , p6_a11 out nocopy JTF_NUMBER_TABLE
99: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
100: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_300
101: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_300
102: );
103: procedure get_usertype_sub(p_usertype_id NUMBER
104: , p_user_id NUMBER
105: , p_is_admin NUMBER

Line 121: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300

117: , p5_a9 out nocopy JTF_NUMBER_TABLE
118: , p5_a10 out nocopy JTF_NUMBER_TABLE
119: , p5_a11 out nocopy JTF_NUMBER_TABLE
120: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
122: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
123: );
124: end jtf_um_subscription_info_w;

Line 122: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300

118: , p5_a10 out nocopy JTF_NUMBER_TABLE
119: , p5_a11 out nocopy JTF_NUMBER_TABLE
120: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_100
121: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_300
122: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_300
123: );
124: end jtf_um_subscription_info_w;