APPS.AMV_MYCHANNEL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a1 JTF_VARCHAR2_TABLE_100

12: , a2 out nocopy JTF_VARCHAR2_TABLE_300
13: );
14:
15: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
16: , a1 JTF_VARCHAR2_TABLE_100
17: , a2 JTF_VARCHAR2_TABLE_100
18: , a3 JTF_NUMBER_TABLE
19: , a4 JTF_VARCHAR2_TABLE_100
20: , a5 JTF_NUMBER_TABLE

Line 17: , a2 JTF_VARCHAR2_TABLE_100

13: );
14:
15: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
16: , a1 JTF_VARCHAR2_TABLE_100
17: , a2 JTF_VARCHAR2_TABLE_100
18: , a3 JTF_NUMBER_TABLE
19: , a4 JTF_VARCHAR2_TABLE_100
20: , a5 JTF_NUMBER_TABLE
21: , a6 JTF_VARCHAR2_TABLE_100

Line 19: , a4 JTF_VARCHAR2_TABLE_100

15: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
16: , a1 JTF_VARCHAR2_TABLE_100
17: , a2 JTF_VARCHAR2_TABLE_100
18: , a3 JTF_NUMBER_TABLE
19: , a4 JTF_VARCHAR2_TABLE_100
20: , a5 JTF_NUMBER_TABLE
21: , a6 JTF_VARCHAR2_TABLE_100
22: , a7 JTF_VARCHAR2_TABLE_100
23: , a8 JTF_NUMBER_TABLE

Line 21: , a6 JTF_VARCHAR2_TABLE_100

17: , a2 JTF_VARCHAR2_TABLE_100
18: , a3 JTF_NUMBER_TABLE
19: , a4 JTF_VARCHAR2_TABLE_100
20: , a5 JTF_NUMBER_TABLE
21: , a6 JTF_VARCHAR2_TABLE_100
22: , a7 JTF_VARCHAR2_TABLE_100
23: , a8 JTF_NUMBER_TABLE
24: , a9 JTF_VARCHAR2_TABLE_100
25: , a10 JTF_VARCHAR2_TABLE_100

Line 22: , a7 JTF_VARCHAR2_TABLE_100

18: , a3 JTF_NUMBER_TABLE
19: , a4 JTF_VARCHAR2_TABLE_100
20: , a5 JTF_NUMBER_TABLE
21: , a6 JTF_VARCHAR2_TABLE_100
22: , a7 JTF_VARCHAR2_TABLE_100
23: , a8 JTF_NUMBER_TABLE
24: , a9 JTF_VARCHAR2_TABLE_100
25: , a10 JTF_VARCHAR2_TABLE_100
26: , a11 JTF_VARCHAR2_TABLE_100

Line 24: , a9 JTF_VARCHAR2_TABLE_100

20: , a5 JTF_NUMBER_TABLE
21: , a6 JTF_VARCHAR2_TABLE_100
22: , a7 JTF_VARCHAR2_TABLE_100
23: , a8 JTF_NUMBER_TABLE
24: , a9 JTF_VARCHAR2_TABLE_100
25: , a10 JTF_VARCHAR2_TABLE_100
26: , a11 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 25: , a10 JTF_VARCHAR2_TABLE_100

21: , a6 JTF_VARCHAR2_TABLE_100
22: , a7 JTF_VARCHAR2_TABLE_100
23: , a8 JTF_NUMBER_TABLE
24: , a9 JTF_VARCHAR2_TABLE_100
25: , a10 JTF_VARCHAR2_TABLE_100
26: , a11 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 26: , a11 JTF_VARCHAR2_TABLE_100

22: , a7 JTF_VARCHAR2_TABLE_100
23: , a8 JTF_NUMBER_TABLE
24: , a9 JTF_VARCHAR2_TABLE_100
25: , a10 JTF_VARCHAR2_TABLE_100
26: , a11 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 29: , a1 out nocopy JTF_VARCHAR2_TABLE_100

25: , a10 JTF_VARCHAR2_TABLE_100
26: , a11 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100
33: , a5 out nocopy JTF_NUMBER_TABLE

Line 30: , a2 out nocopy JTF_VARCHAR2_TABLE_100

26: , a11 JTF_VARCHAR2_TABLE_100
27: );
28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 32: , a4 out nocopy JTF_VARCHAR2_TABLE_100

28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_VARCHAR2_TABLE_100
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_VARCHAR2_TABLE_100
35: , a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , a8 out nocopy JTF_NUMBER_TABLE

Line 34: , a6 out nocopy JTF_VARCHAR2_TABLE_100

30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_VARCHAR2_TABLE_100
35: , a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , a8 out nocopy JTF_NUMBER_TABLE
37: , a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , a7 out nocopy JTF_VARCHAR2_TABLE_100

31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_VARCHAR2_TABLE_100
35: , a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , a8 out nocopy JTF_NUMBER_TABLE
37: , a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , a10 out nocopy JTF_VARCHAR2_TABLE_100
39: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a9 out nocopy JTF_VARCHAR2_TABLE_100

33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_VARCHAR2_TABLE_100
35: , a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , a8 out nocopy JTF_NUMBER_TABLE
37: , a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , a10 out nocopy JTF_VARCHAR2_TABLE_100
39: , a11 out nocopy JTF_VARCHAR2_TABLE_100
40: );
41:

Line 38: , a10 out nocopy JTF_VARCHAR2_TABLE_100

34: , a6 out nocopy JTF_VARCHAR2_TABLE_100
35: , a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , a8 out nocopy JTF_NUMBER_TABLE
37: , a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , a10 out nocopy JTF_VARCHAR2_TABLE_100
39: , a11 out nocopy JTF_VARCHAR2_TABLE_100
40: );
41:
42: procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE

Line 39: , a11 out nocopy JTF_VARCHAR2_TABLE_100

35: , a7 out nocopy JTF_VARCHAR2_TABLE_100
36: , a8 out nocopy JTF_NUMBER_TABLE
37: , a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , a10 out nocopy JTF_VARCHAR2_TABLE_100
39: , a11 out nocopy JTF_VARCHAR2_TABLE_100
40: );
41:
42: procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE
43: , a1 JTF_VARCHAR2_TABLE_4000

Line 47: , a5 JTF_VARCHAR2_TABLE_100

43: , a1 JTF_VARCHAR2_TABLE_4000
44: , a2 JTF_DATE_TABLE
45: , a3 JTF_DATE_TABLE
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_NUMBER_TABLE
49: , a7 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 49: , a7 JTF_VARCHAR2_TABLE_100

45: , a3 JTF_DATE_TABLE
46: , a4 JTF_DATE_TABLE
47: , a5 JTF_VARCHAR2_TABLE_100
48: , a6 JTF_NUMBER_TABLE
49: , a7 JTF_VARCHAR2_TABLE_100
50: );
51: procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
53: , a2 out nocopy JTF_DATE_TABLE

Line 56: , a5 out nocopy JTF_VARCHAR2_TABLE_100

52: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
53: , a2 out nocopy JTF_DATE_TABLE
54: , a3 out nocopy JTF_DATE_TABLE
55: , a4 out nocopy JTF_DATE_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:

Line 58: , a7 out nocopy JTF_VARCHAR2_TABLE_100

54: , a3 out nocopy JTF_DATE_TABLE
55: , a4 out nocopy JTF_DATE_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60:
61: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_300

Line 64: , a3 JTF_VARCHAR2_TABLE_100

60:
61: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_300
63: , a2 JTF_VARCHAR2_TABLE_2000
64: , a3 JTF_VARCHAR2_TABLE_100
65: );
66: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_VARCHAR2_TABLE_300
68: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 69: , a3 out nocopy JTF_VARCHAR2_TABLE_100

65: );
66: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_VARCHAR2_TABLE_300
68: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: );
71:
72: procedure add_subscription(p_api_version NUMBER
73: , p_init_msg_list VARCHAR2

Line 124: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100

120: , x_msg_data out nocopy VARCHAR2
121: , p_check_login_user VARCHAR2
122: , p_user_id NUMBER
123: , p8_a0 out nocopy JTF_NUMBER_TABLE
124: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p8_a3 out nocopy JTF_NUMBER_TABLE
127: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p8_a5 out nocopy JTF_NUMBER_TABLE

Line 125: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

121: , p_check_login_user VARCHAR2
122: , p_user_id NUMBER
123: , p8_a0 out nocopy JTF_NUMBER_TABLE
124: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p8_a3 out nocopy JTF_NUMBER_TABLE
127: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p8_a5 out nocopy JTF_NUMBER_TABLE
129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 127: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

123: , p8_a0 out nocopy JTF_NUMBER_TABLE
124: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p8_a3 out nocopy JTF_NUMBER_TABLE
127: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p8_a5 out nocopy JTF_NUMBER_TABLE
129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , p8_a8 out nocopy JTF_NUMBER_TABLE

Line 129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

125: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p8_a3 out nocopy JTF_NUMBER_TABLE
127: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p8_a5 out nocopy JTF_NUMBER_TABLE
129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , p8_a8 out nocopy JTF_NUMBER_TABLE
132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

126: , p8_a3 out nocopy JTF_NUMBER_TABLE
127: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p8_a5 out nocopy JTF_NUMBER_TABLE
129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , p8_a8 out nocopy JTF_NUMBER_TABLE
132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

128: , p8_a5 out nocopy JTF_NUMBER_TABLE
129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , p8_a8 out nocopy JTF_NUMBER_TABLE
132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
135: );
136: procedure get_mychannelspercategory(p_api_version NUMBER

Line 133: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100

129: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , p8_a8 out nocopy JTF_NUMBER_TABLE
132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
135: );
136: procedure get_mychannelspercategory(p_api_version NUMBER
137: , p_init_msg_list VARCHAR2

Line 134: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100

130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131: , p8_a8 out nocopy JTF_NUMBER_TABLE
132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
133: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
135: );
136: procedure get_mychannelspercategory(p_api_version NUMBER
137: , p_init_msg_list VARCHAR2
138: , p_validation_level NUMBER

Line 164: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

160: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_4000
161: , p12_a2 out nocopy JTF_DATE_TABLE
162: , p12_a3 out nocopy JTF_DATE_TABLE
163: , p12_a4 out nocopy JTF_DATE_TABLE
164: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
165: , p12_a6 out nocopy JTF_NUMBER_TABLE
166: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168: procedure get_itemsperuser(p_api_version NUMBER

Line 166: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

162: , p12_a3 out nocopy JTF_DATE_TABLE
163: , p12_a4 out nocopy JTF_DATE_TABLE
164: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
165: , p12_a6 out nocopy JTF_NUMBER_TABLE
166: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
167: );
168: procedure get_itemsperuser(p_api_version NUMBER
169: , p_init_msg_list VARCHAR2
170: , p_validation_level NUMBER

Line 201: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

197: , p10_a2 out nocopy NUMBER
198: , p11_a0 out nocopy JTF_NUMBER_TABLE
199: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_300
200: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_2000
201: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
202: , p9_a0 NUMBER := 0-1962.0724
203: , p9_a1 NUMBER := 0-1962.0724
204: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
205: );