APPS.AMV_CATEGORY_GRP_W dependencies on JTF_NUMBER_TABLE

Line 12: , p_category_id_array JTF_NUMBER_TABLE

8: , x_msg_count out nocopy NUMBER
9: , x_msg_data out nocopy VARCHAR2
10: , p_check_login_user VARCHAR2
11: , p_application_id NUMBER
12: , p_category_id_array JTF_NUMBER_TABLE
13: , p_category_new_order JTF_NUMBER_TABLE
14: );
15: procedure find_categories(p_api_version NUMBER
16: , p_init_msg_list VARCHAR2

Line 13: , p_category_new_order JTF_NUMBER_TABLE

9: , x_msg_data out nocopy VARCHAR2
10: , p_check_login_user VARCHAR2
11: , p_application_id NUMBER
12: , p_category_id_array JTF_NUMBER_TABLE
13: , p_category_new_order JTF_NUMBER_TABLE
14: );
15: procedure find_categories(p_api_version NUMBER
16: , p_init_msg_list VARCHAR2
17: , p_validation_level NUMBER

Line 29: , p13_a0 out nocopy JTF_NUMBER_TABLE

25: , p_ignore_hierarchy VARCHAR2
26: , p12_a0 out nocopy NUMBER
27: , p12_a1 out nocopy NUMBER
28: , p12_a2 out nocopy NUMBER
29: , p13_a0 out nocopy JTF_NUMBER_TABLE
30: , p13_a1 out nocopy JTF_NUMBER_TABLE
31: , p13_a2 out nocopy JTF_NUMBER_TABLE
32: , p13_a3 out nocopy JTF_NUMBER_TABLE
33: , p13_a4 out nocopy JTF_NUMBER_TABLE

Line 30: , p13_a1 out nocopy JTF_NUMBER_TABLE

26: , p12_a0 out nocopy NUMBER
27: , p12_a1 out nocopy NUMBER
28: , p12_a2 out nocopy NUMBER
29: , p13_a0 out nocopy JTF_NUMBER_TABLE
30: , p13_a1 out nocopy JTF_NUMBER_TABLE
31: , p13_a2 out nocopy JTF_NUMBER_TABLE
32: , p13_a3 out nocopy JTF_NUMBER_TABLE
33: , p13_a4 out nocopy JTF_NUMBER_TABLE
34: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 31: , p13_a2 out nocopy JTF_NUMBER_TABLE

27: , p12_a1 out nocopy NUMBER
28: , p12_a2 out nocopy NUMBER
29: , p13_a0 out nocopy JTF_NUMBER_TABLE
30: , p13_a1 out nocopy JTF_NUMBER_TABLE
31: , p13_a2 out nocopy JTF_NUMBER_TABLE
32: , p13_a3 out nocopy JTF_NUMBER_TABLE
33: , p13_a4 out nocopy JTF_NUMBER_TABLE
34: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 32: , p13_a3 out nocopy JTF_NUMBER_TABLE

28: , p12_a2 out nocopy NUMBER
29: , p13_a0 out nocopy JTF_NUMBER_TABLE
30: , p13_a1 out nocopy JTF_NUMBER_TABLE
31: , p13_a2 out nocopy JTF_NUMBER_TABLE
32: , p13_a3 out nocopy JTF_NUMBER_TABLE
33: , p13_a4 out nocopy JTF_NUMBER_TABLE
34: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000
36: , p13_a7 out nocopy JTF_NUMBER_TABLE

Line 33: , p13_a4 out nocopy JTF_NUMBER_TABLE

29: , p13_a0 out nocopy JTF_NUMBER_TABLE
30: , p13_a1 out nocopy JTF_NUMBER_TABLE
31: , p13_a2 out nocopy JTF_NUMBER_TABLE
32: , p13_a3 out nocopy JTF_NUMBER_TABLE
33: , p13_a4 out nocopy JTF_NUMBER_TABLE
34: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000
36: , p13_a7 out nocopy JTF_NUMBER_TABLE
37: , p11_a0 NUMBER := 0-1962.0724

Line 36: , p13_a7 out nocopy JTF_NUMBER_TABLE

32: , p13_a3 out nocopy JTF_NUMBER_TABLE
33: , p13_a4 out nocopy JTF_NUMBER_TABLE
34: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_100
35: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_2000
36: , p13_a7 out nocopy JTF_NUMBER_TABLE
37: , p11_a0 NUMBER := 0-1962.0724
38: , p11_a1 NUMBER := 0-1962.0724
39: , p11_a2 VARCHAR2 := fnd_api.g_miss_char
40: );

Line 50: , p9_a0 out nocopy JTF_NUMBER_TABLE

46: , x_msg_data out nocopy VARCHAR2
47: , p_check_login_user VARCHAR2
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

Line 51: , p9_a1 out nocopy JTF_NUMBER_TABLE

47: , p_check_login_user VARCHAR2
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

Line 62: , p8_a0 out nocopy JTF_NUMBER_TABLE

58: , x_msg_count out nocopy NUMBER
59: , x_msg_data out nocopy VARCHAR2
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

Line 63: , p8_a1 out nocopy JTF_NUMBER_TABLE

59: , x_msg_data out nocopy VARCHAR2
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

Line 74: , p8_a0 out nocopy JTF_NUMBER_TABLE

70: , x_msg_count out nocopy NUMBER
71: , x_msg_data out nocopy VARCHAR2
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

Line 75: , p8_a1 out nocopy JTF_NUMBER_TABLE

71: , x_msg_data out nocopy VARCHAR2
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

Line 87: , p9_a0 out nocopy JTF_NUMBER_TABLE

83: , x_msg_data out nocopy VARCHAR2
84: , p_check_login_user VARCHAR2
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

Line 88: , p9_a1 out nocopy JTF_NUMBER_TABLE

84: , p_check_login_user VARCHAR2
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

Line 103: , p12_a0 out nocopy JTF_NUMBER_TABLE

99: , p_include_subcats VARCHAR2
100: , p11_a0 out nocopy NUMBER
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

Line 104: , p12_a1 out nocopy JTF_NUMBER_TABLE

100: , p11_a0 out nocopy NUMBER
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