APPS.AMV_MYCHANNEL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

1: package amv_mychannel_pvt_w as
2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE

Line 4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

1: package amv_mychannel_pvt_w as
2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300

Line 6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE

2: /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
9: );
10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 7: , a1 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
9: );
10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE

Line 10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
9: );
10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_VARCHAR2_TABLE_300
13: );
14:

Line 11: , a1 out nocopy JTF_NUMBER_TABLE

7: , a1 JTF_NUMBER_TABLE
8: , a2 JTF_VARCHAR2_TABLE_300
9: );
10: procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
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

Line 15: procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE

11: , a1 out nocopy JTF_NUMBER_TABLE
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

Line 18: , a3 JTF_NUMBER_TABLE

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
22: , a7 JTF_VARCHAR2_TABLE_100

Line 20: , a5 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
24: , a9 JTF_VARCHAR2_TABLE_100

Line 23: , a8 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
27: );

Line 28: procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy 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
31: , a3 out nocopy JTF_NUMBER_TABLE
32: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 31: , a3 out nocopy JTF_NUMBER_TABLE

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
35: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: , a5 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
37: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a8 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
40: );

Line 42: procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE

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
44: , a2 JTF_DATE_TABLE
45: , a3 JTF_DATE_TABLE
46: , a4 JTF_DATE_TABLE

Line 48: , a6 JTF_NUMBER_TABLE

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
52: , a1 out nocopy JTF_VARCHAR2_TABLE_4000

Line 51: procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_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
54: , a3 out nocopy JTF_DATE_TABLE
55: , a4 out nocopy JTF_DATE_TABLE

Line 57: , a6 out nocopy JTF_NUMBER_TABLE

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:
61: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE

Line 61: procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE

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
63: , a2 JTF_VARCHAR2_TABLE_2000
64: , a3 JTF_VARCHAR2_TABLE_100
65: );

Line 66: procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy 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
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: );

Line 123: , p8_a0 out nocopy JTF_NUMBER_TABLE

119: , x_msg_count out nocopy NUMBER
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

Line 126: , p8_a3 out nocopy JTF_NUMBER_TABLE

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
130: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , p8_a5 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
132: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , p8_a8 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
135: );

Line 145: , x_channel_array out nocopy JTF_NUMBER_TABLE

141: , x_msg_data out nocopy VARCHAR2
142: , p_check_login_user VARCHAR2
143: , p_user_id NUMBER
144: , p_category_id NUMBER
145: , x_channel_array out nocopy JTF_NUMBER_TABLE
146: );
147: procedure get_mynotifications(p_api_version NUMBER
148: , p_init_msg_list VARCHAR2
149: , p_validation_level NUMBER

Line 159: , p12_a0 out nocopy JTF_NUMBER_TABLE

155: , p_user_id NUMBER
156: , p_user_name VARCHAR2
157: , p_notification_type VARCHAR2
158: , x_notification_url out nocopy VARCHAR2
159: , p12_a0 out nocopy JTF_NUMBER_TABLE
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

Line 165: , p12_a6 out nocopy JTF_NUMBER_TABLE

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
169: , p_init_msg_list VARCHAR2

Line 179: , p10_a0 out nocopy JTF_NUMBER_TABLE

175: , p_user_id NUMBER
176: , p9_a0 out nocopy NUMBER
177: , p9_a1 out nocopy NUMBER
178: , p9_a2 out nocopy NUMBER
179: , p10_a0 out nocopy JTF_NUMBER_TABLE
180: , p10_a1 out nocopy JTF_NUMBER_TABLE
181: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
182: , p8_a0 NUMBER := 0-1962.0724
183: , p8_a1 NUMBER := 0-1962.0724

Line 180: , p10_a1 out nocopy JTF_NUMBER_TABLE

176: , p9_a0 out nocopy NUMBER
177: , p9_a1 out nocopy NUMBER
178: , p9_a2 out nocopy NUMBER
179: , p10_a0 out nocopy JTF_NUMBER_TABLE
180: , p10_a1 out nocopy JTF_NUMBER_TABLE
181: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
182: , p8_a0 NUMBER := 0-1962.0724
183: , p8_a1 NUMBER := 0-1962.0724
184: , p8_a2 VARCHAR2 := fnd_api.g_miss_char

Line 198: , p11_a0 out nocopy JTF_NUMBER_TABLE

194: , p_user_id NUMBER
195: , p10_a0 out nocopy NUMBER
196: , p10_a1 out nocopy NUMBER
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