APPS.AMV_CATEGORY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 6: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);

2: /* $Header: amvwcats.pls 120.2 2005/06/30 07:44 appldev ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy amv_category_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p2(t amv_category_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE

Line 7: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);

3: procedure rosetta_table_copy_in_p2(t out nocopy amv_category_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4: procedure rosetta_table_copy_out_p2(t amv_category_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5:
6: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_NUMBER_TABLE

Line 9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE

5:
6: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_NUMBER_TABLE

Line 10: , a1 JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_VARCHAR2_TABLE_100

Line 11: , a2 JTF_NUMBER_TABLE

7: procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8:
9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_VARCHAR2_TABLE_100
15: , a6 JTF_VARCHAR2_TABLE_2000

Line 12: , a3 JTF_NUMBER_TABLE

8:
9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_VARCHAR2_TABLE_100
15: , a6 JTF_VARCHAR2_TABLE_2000
16: , a7 JTF_NUMBER_TABLE

Line 13: , a4 JTF_NUMBER_TABLE

9: procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10: , a1 JTF_NUMBER_TABLE
11: , a2 JTF_NUMBER_TABLE
12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_VARCHAR2_TABLE_100
15: , a6 JTF_VARCHAR2_TABLE_2000
16: , a7 JTF_NUMBER_TABLE
17: );

Line 16: , a7 JTF_NUMBER_TABLE

12: , a3 JTF_NUMBER_TABLE
13: , a4 JTF_NUMBER_TABLE
14: , a5 JTF_VARCHAR2_TABLE_100
15: , a6 JTF_VARCHAR2_TABLE_2000
16: , a7 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE

Line 18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE

14: , a5 JTF_VARCHAR2_TABLE_100
15: , a6 JTF_VARCHAR2_TABLE_2000
16: , a7 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE

Line 19: , a1 out nocopy JTF_NUMBER_TABLE

15: , a6 JTF_VARCHAR2_TABLE_2000
16: , a7 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 20: , a2 out nocopy JTF_NUMBER_TABLE

16: , a7 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 21: , a3 out nocopy JTF_NUMBER_TABLE

17: );
18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a7 out nocopy JTF_NUMBER_TABLE

Line 22: , a4 out nocopy JTF_NUMBER_TABLE

18: procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a7 out nocopy JTF_NUMBER_TABLE
26: );

Line 25: , a7 out nocopy JTF_NUMBER_TABLE

21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_NUMBER_TABLE
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a7 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE

Line 28: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE

24: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
25: , a7 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_300
31: );
32: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

Line 29: , a1 JTF_NUMBER_TABLE

25: , a7 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_300
31: );
32: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE

Line 32: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE

28: procedure rosetta_table_copy_in_p10(t out nocopy amv_category_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_300
31: );
32: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_300
35: );
36:

Line 33: , a1 out nocopy JTF_NUMBER_TABLE

29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_VARCHAR2_TABLE_300
31: );
32: procedure rosetta_table_copy_out_p10(t amv_category_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_300
35: );
36:
37: procedure reorder_category(p_api_version NUMBER

Line 46: , p_category_id_array JTF_NUMBER_TABLE

42: , x_msg_count out nocopy NUMBER
43: , x_msg_data out nocopy VARCHAR2
44: , p_check_login_user VARCHAR2
45: , p_application_id NUMBER
46: , p_category_id_array JTF_NUMBER_TABLE
47: , p_category_new_order JTF_NUMBER_TABLE
48: );
49: procedure find_categories(p_api_version NUMBER
50: , p_init_msg_list VARCHAR2

Line 47: , p_category_new_order JTF_NUMBER_TABLE

43: , x_msg_data out nocopy VARCHAR2
44: , p_check_login_user VARCHAR2
45: , p_application_id NUMBER
46: , p_category_id_array JTF_NUMBER_TABLE
47: , p_category_new_order JTF_NUMBER_TABLE
48: );
49: procedure find_categories(p_api_version NUMBER
50: , p_init_msg_list VARCHAR2
51: , p_validation_level NUMBER

Line 64: , p14_a0 out nocopy JTF_NUMBER_TABLE

60: , p_ignore_hierarchy VARCHAR2
61: , p13_a0 out nocopy NUMBER
62: , p13_a1 out nocopy NUMBER
63: , p13_a2 out nocopy NUMBER
64: , p14_a0 out nocopy JTF_NUMBER_TABLE
65: , p14_a1 out nocopy JTF_NUMBER_TABLE
66: , p14_a2 out nocopy JTF_NUMBER_TABLE
67: , p14_a3 out nocopy JTF_NUMBER_TABLE
68: , p14_a4 out nocopy JTF_NUMBER_TABLE

Line 65: , p14_a1 out nocopy JTF_NUMBER_TABLE

61: , p13_a0 out nocopy NUMBER
62: , p13_a1 out nocopy NUMBER
63: , p13_a2 out nocopy NUMBER
64: , p14_a0 out nocopy JTF_NUMBER_TABLE
65: , p14_a1 out nocopy JTF_NUMBER_TABLE
66: , p14_a2 out nocopy JTF_NUMBER_TABLE
67: , p14_a3 out nocopy JTF_NUMBER_TABLE
68: , p14_a4 out nocopy JTF_NUMBER_TABLE
69: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , p14_a2 out nocopy JTF_NUMBER_TABLE

62: , p13_a1 out nocopy NUMBER
63: , p13_a2 out nocopy NUMBER
64: , p14_a0 out nocopy JTF_NUMBER_TABLE
65: , p14_a1 out nocopy JTF_NUMBER_TABLE
66: , p14_a2 out nocopy JTF_NUMBER_TABLE
67: , p14_a3 out nocopy JTF_NUMBER_TABLE
68: , p14_a4 out nocopy JTF_NUMBER_TABLE
69: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 67: , p14_a3 out nocopy JTF_NUMBER_TABLE

63: , p13_a2 out nocopy NUMBER
64: , p14_a0 out nocopy JTF_NUMBER_TABLE
65: , p14_a1 out nocopy JTF_NUMBER_TABLE
66: , p14_a2 out nocopy JTF_NUMBER_TABLE
67: , p14_a3 out nocopy JTF_NUMBER_TABLE
68: , p14_a4 out nocopy JTF_NUMBER_TABLE
69: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
71: , p14_a7 out nocopy JTF_NUMBER_TABLE

Line 68: , p14_a4 out nocopy JTF_NUMBER_TABLE

64: , p14_a0 out nocopy JTF_NUMBER_TABLE
65: , p14_a1 out nocopy JTF_NUMBER_TABLE
66: , p14_a2 out nocopy JTF_NUMBER_TABLE
67: , p14_a3 out nocopy JTF_NUMBER_TABLE
68: , p14_a4 out nocopy JTF_NUMBER_TABLE
69: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
71: , p14_a7 out nocopy JTF_NUMBER_TABLE
72: , p12_a0 NUMBER := 0-1962.0724

Line 71: , p14_a7 out nocopy JTF_NUMBER_TABLE

67: , p14_a3 out nocopy JTF_NUMBER_TABLE
68: , p14_a4 out nocopy JTF_NUMBER_TABLE
69: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
70: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
71: , p14_a7 out nocopy JTF_NUMBER_TABLE
72: , p12_a0 NUMBER := 0-1962.0724
73: , p12_a1 NUMBER := 0-1962.0724
74: , p12_a2 VARCHAR2 := fnd_api.g_miss_char
75: );

Line 85: , p9_a0 out nocopy JTF_NUMBER_TABLE

81: , x_msg_data out nocopy VARCHAR2
82: , p_check_login_user VARCHAR2
83: , p_category_id NUMBER
84: , p_include_subcats VARCHAR2
85: , p9_a0 out nocopy JTF_NUMBER_TABLE
86: , p9_a1 out nocopy JTF_NUMBER_TABLE
87: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
88: );
89: procedure get_itemspercategory(p_api_version NUMBER

Line 86: , p9_a1 out nocopy JTF_NUMBER_TABLE

82: , p_check_login_user VARCHAR2
83: , p_category_id NUMBER
84: , p_include_subcats VARCHAR2
85: , p9_a0 out nocopy JTF_NUMBER_TABLE
86: , p9_a1 out nocopy JTF_NUMBER_TABLE
87: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
88: );
89: procedure get_itemspercategory(p_api_version NUMBER
90: , p_init_msg_list VARCHAR2

Line 98: , p9_a0 out nocopy JTF_NUMBER_TABLE

94: , x_msg_data out nocopy VARCHAR2
95: , p_check_login_user VARCHAR2
96: , p_category_id NUMBER
97: , p_include_subcats VARCHAR2
98: , p9_a0 out nocopy JTF_NUMBER_TABLE
99: , p9_a1 out nocopy JTF_NUMBER_TABLE
100: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
101: );
102: procedure get_itemspercategory(p_api_version NUMBER

Line 99: , p9_a1 out nocopy JTF_NUMBER_TABLE

95: , p_check_login_user VARCHAR2
96: , p_category_id NUMBER
97: , p_include_subcats VARCHAR2
98: , p9_a0 out nocopy JTF_NUMBER_TABLE
99: , p9_a1 out nocopy JTF_NUMBER_TABLE
100: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
101: );
102: procedure get_itemspercategory(p_api_version NUMBER
103: , p_init_msg_list VARCHAR2

Line 114: , p12_a0 out nocopy JTF_NUMBER_TABLE

110: , p_include_subcats VARCHAR2
111: , p11_a0 out nocopy NUMBER
112: , p11_a1 out nocopy NUMBER
113: , p11_a2 out nocopy NUMBER
114: , p12_a0 out nocopy JTF_NUMBER_TABLE
115: , p12_a1 out nocopy JTF_NUMBER_TABLE
116: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
117: , p9_a0 NUMBER := 0-1962.0724
118: , p9_a1 NUMBER := 0-1962.0724

Line 115: , p12_a1 out nocopy JTF_NUMBER_TABLE

111: , p11_a0 out nocopy NUMBER
112: , p11_a1 out nocopy NUMBER
113: , p11_a2 out nocopy NUMBER
114: , p12_a0 out nocopy JTF_NUMBER_TABLE
115: , p12_a1 out nocopy JTF_NUMBER_TABLE
116: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
117: , p9_a0 NUMBER := 0-1962.0724
118: , p9_a1 NUMBER := 0-1962.0724
119: , p9_a2 VARCHAR2 := fnd_api.g_miss_char

Line 131: , p8_a0 out nocopy JTF_NUMBER_TABLE

127: , x_msg_count out nocopy NUMBER
128: , x_msg_data out nocopy VARCHAR2
129: , p_check_login_user VARCHAR2
130: , p_category_id NUMBER
131: , p8_a0 out nocopy JTF_NUMBER_TABLE
132: , p8_a1 out nocopy JTF_NUMBER_TABLE
133: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
134: );
135: procedure get_catchildrenhierarchy(p_api_version NUMBER

Line 132: , p8_a1 out nocopy JTF_NUMBER_TABLE

128: , x_msg_data out nocopy VARCHAR2
129: , p_check_login_user VARCHAR2
130: , p_category_id NUMBER
131: , p8_a0 out nocopy JTF_NUMBER_TABLE
132: , p8_a1 out nocopy JTF_NUMBER_TABLE
133: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
134: );
135: procedure get_catchildrenhierarchy(p_api_version NUMBER
136: , p_init_msg_list VARCHAR2

Line 143: , p8_a0 out nocopy JTF_NUMBER_TABLE

139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p_check_login_user VARCHAR2
142: , p_category_id NUMBER
143: , p8_a0 out nocopy JTF_NUMBER_TABLE
144: , p8_a1 out nocopy JTF_NUMBER_TABLE
145: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: );
147: procedure get_chncategoryhierarchy(p_api_version NUMBER

Line 144: , p8_a1 out nocopy JTF_NUMBER_TABLE

140: , x_msg_data out nocopy VARCHAR2
141: , p_check_login_user VARCHAR2
142: , p_category_id NUMBER
143: , p8_a0 out nocopy JTF_NUMBER_TABLE
144: , p8_a1 out nocopy JTF_NUMBER_TABLE
145: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
146: );
147: procedure get_chncategoryhierarchy(p_api_version NUMBER
148: , p_init_msg_list VARCHAR2

Line 156: , p9_a0 out nocopy JTF_NUMBER_TABLE

152: , x_msg_data out nocopy VARCHAR2
153: , p_check_login_user VARCHAR2
154: , p_channel_id NUMBER
155: , x_channel_name out nocopy VARCHAR2
156: , p9_a0 out nocopy JTF_NUMBER_TABLE
157: , p9_a1 out nocopy JTF_NUMBER_TABLE
158: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
159: );
160: end amv_category_pvt_w;

Line 157: , p9_a1 out nocopy JTF_NUMBER_TABLE

153: , p_check_login_user VARCHAR2
154: , p_channel_id NUMBER
155: , x_channel_name out nocopy VARCHAR2
156: , p9_a0 out nocopy JTF_NUMBER_TABLE
157: , p9_a1 out nocopy JTF_NUMBER_TABLE
158: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
159: );
160: end amv_category_pvt_w;