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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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
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
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