APPS.AMV_CATEGORY_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 30: , a2 JTF_VARCHAR2_TABLE_300

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
34: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 34: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 87: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
91: , p_validation_level NUMBER

Line 100: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
104: , p_validation_level NUMBER

Line 116: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
120: , p10_a0 VARCHAR2 := fnd_api.g_miss_char

Line 133: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
137: , p_validation_level NUMBER

Line 145: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
149: , p_validation_level NUMBER

Line 158: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

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;