[Home] [Help]
PACKAGE: APPS.AMV_CATEGORY_GRP_W
Source
1 package amv_category_grp_w as
2 /* $Header: amvwcags.pls 120.2 2005/06/30 07:43 appldev ship $ */
3 procedure reorder_category(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
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
17 , p_validation_level NUMBER
18 , x_return_status out nocopy VARCHAR2
19 , x_msg_count out nocopy NUMBER
20 , x_msg_data out nocopy VARCHAR2
21 , p_check_login_user VARCHAR2
22 , p_application_id NUMBER
23 , p_category_name VARCHAR2
24 , p_parent_category_id 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
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 );
41 procedure get_channelspercategory(p_api_version NUMBER
42 , p_init_msg_list VARCHAR2
43 , p_validation_level NUMBER
44 , x_return_status out nocopy VARCHAR2
45 , x_msg_count out nocopy NUMBER
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
55 , p_init_msg_list VARCHAR2
56 , p_validation_level NUMBER
57 , x_return_status out nocopy 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
67 , p_init_msg_list VARCHAR2
68 , p_validation_level NUMBER
69 , x_return_status out nocopy 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
79 , p_init_msg_list VARCHAR2
80 , p_validation_level NUMBER
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
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
92 , p_init_msg_list VARCHAR2
93 , p_validation_level NUMBER
94 , x_return_status out nocopy VARCHAR2
95 , x_msg_count out nocopy NUMBER
96 , x_msg_data out nocopy VARCHAR2
97 , p_check_login_user VARCHAR2
98 , p_category_id NUMBER
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
108 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
109 , p10_a0 VARCHAR2 := fnd_api.g_miss_char
110 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
111 );
112 end amv_category_grp_w;