APPS.AMV_CATEGORY_GRP_W dependencies on JTF_VARCHAR2_TABLE_300

Line 52: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

48: , p_category_id NUMBER
49: , p_include_subcats VARCHAR2
50: , p9_a0 out nocopy JTF_NUMBER_TABLE
51: , p9_a1 out nocopy JTF_NUMBER_TABLE
52: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
53: );
54: procedure get_catparentshierarchy(p_api_version NUMBER
55: , p_init_msg_list VARCHAR2
56: , p_validation_level NUMBER

Line 64: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

60: , p_check_login_user VARCHAR2
61: , p_category_id NUMBER
62: , p8_a0 out nocopy JTF_NUMBER_TABLE
63: , p8_a1 out nocopy JTF_NUMBER_TABLE
64: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
65: );
66: procedure get_catchildrenhierarchy(p_api_version NUMBER
67: , p_init_msg_list VARCHAR2
68: , p_validation_level NUMBER

Line 76: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300

72: , p_check_login_user VARCHAR2
73: , p_category_id NUMBER
74: , p8_a0 out nocopy JTF_NUMBER_TABLE
75: , p8_a1 out nocopy JTF_NUMBER_TABLE
76: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_300
77: );
78: procedure get_chncategoryhierarchy(p_api_version NUMBER
79: , p_init_msg_list VARCHAR2
80: , p_validation_level NUMBER

Line 89: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300

85: , p_channel_id NUMBER
86: , x_channel_name out nocopy VARCHAR2
87: , p9_a0 out nocopy JTF_NUMBER_TABLE
88: , p9_a1 out nocopy JTF_NUMBER_TABLE
89: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_300
90: );
91: procedure get_itemspercategory(p_api_version NUMBER
92: , p_init_msg_list VARCHAR2
93: , p_validation_level NUMBER

Line 105: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300

101: , p11_a1 out nocopy NUMBER
102: , p11_a2 out nocopy NUMBER
103: , p12_a0 out nocopy JTF_NUMBER_TABLE
104: , p12_a1 out nocopy JTF_NUMBER_TABLE
105: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_300
106: , p9_a0 NUMBER := 0-1962.0724
107: , p9_a1 NUMBER := 0-1962.0724
108: , p9_a2 VARCHAR2 := fnd_api.g_miss_char
109: , p10_a0 VARCHAR2 := fnd_api.g_miss_char