[Home] [Help]
PACKAGE: APPS.AMV_CATEGORY_PVT_W
Source
1 package amv_category_pvt_w as
2 /* $Header: amvwcats.pls 120.2 2005/06/30 07:44 appldev ship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy amv_category_pvt.amv_char_varray_type, a0 JTF_VARCHAR2_TABLE_4000);
4 procedure rosetta_table_copy_out_p2(t amv_category_pvt.amv_char_varray_type, a0 out nocopy JTF_VARCHAR2_TABLE_4000);
5
6 procedure rosetta_table_copy_in_p3(t out nocopy amv_category_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
7 procedure rosetta_table_copy_out_p3(t amv_category_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
8
9 procedure rosetta_table_copy_in_p7(t out nocopy amv_category_pvt.amv_category_varray_type, a0 JTF_NUMBER_TABLE
10 , a1 JTF_NUMBER_TABLE
11 , a2 JTF_NUMBER_TABLE
12 , a3 JTF_NUMBER_TABLE
13 , a4 JTF_NUMBER_TABLE
14 , a5 JTF_VARCHAR2_TABLE_100
15 , a6 JTF_VARCHAR2_TABLE_2000
16 , a7 JTF_NUMBER_TABLE
17 );
18 procedure rosetta_table_copy_out_p7(t amv_category_pvt.amv_category_varray_type, a0 out nocopy JTF_NUMBER_TABLE
19 , a1 out nocopy JTF_NUMBER_TABLE
20 , a2 out nocopy JTF_NUMBER_TABLE
21 , a3 out nocopy JTF_NUMBER_TABLE
22 , a4 out nocopy JTF_NUMBER_TABLE
23 , a5 out nocopy JTF_VARCHAR2_TABLE_100
24 , a6 out nocopy JTF_VARCHAR2_TABLE_2000
25 , a7 out nocopy JTF_NUMBER_TABLE
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
35 );
36
37 procedure reorder_category(p_api_version NUMBER
38 , p_init_msg_list VARCHAR2
39 , p_commit VARCHAR2
40 , p_validation_level NUMBER
41 , x_return_status out nocopy VARCHAR2
42 , x_msg_count out nocopy NUMBER
43 , x_msg_data out nocopy VARCHAR2
44 , p_check_login_user VARCHAR2
45 , p_application_id NUMBER
46 , p_category_id_array JTF_NUMBER_TABLE
47 , p_category_new_order JTF_NUMBER_TABLE
48 );
49 procedure find_categories(p_api_version NUMBER
50 , p_init_msg_list VARCHAR2
51 , p_validation_level NUMBER
52 , x_return_status out nocopy VARCHAR2
53 , x_msg_count out nocopy NUMBER
54 , x_msg_data out nocopy VARCHAR2
55 , p_check_login_user VARCHAR2
56 , p_application_id NUMBER
57 , p_category_name VARCHAR2
58 , p_parent_category_id NUMBER
59 , p_parent_category_name VARCHAR2
60 , p_ignore_hierarchy VARCHAR2
61 , p13_a0 out nocopy NUMBER
62 , p13_a1 out nocopy NUMBER
63 , p13_a2 out nocopy NUMBER
64 , p14_a0 out nocopy JTF_NUMBER_TABLE
65 , p14_a1 out nocopy JTF_NUMBER_TABLE
66 , p14_a2 out nocopy JTF_NUMBER_TABLE
67 , p14_a3 out nocopy JTF_NUMBER_TABLE
68 , p14_a4 out nocopy JTF_NUMBER_TABLE
69 , p14_a5 out nocopy JTF_VARCHAR2_TABLE_100
70 , p14_a6 out nocopy JTF_VARCHAR2_TABLE_2000
71 , p14_a7 out nocopy JTF_NUMBER_TABLE
72 , p12_a0 NUMBER := 0-1962.0724
73 , p12_a1 NUMBER := 0-1962.0724
74 , p12_a2 VARCHAR2 := fnd_api.g_miss_char
75 );
76 procedure get_channelspercategory(p_api_version NUMBER
77 , p_init_msg_list VARCHAR2
78 , p_validation_level NUMBER
79 , x_return_status out nocopy VARCHAR2
80 , x_msg_count out nocopy NUMBER
81 , x_msg_data out nocopy VARCHAR2
82 , p_check_login_user VARCHAR2
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
92 , x_return_status out nocopy VARCHAR2
93 , x_msg_count out nocopy NUMBER
94 , x_msg_data out nocopy VARCHAR2
95 , p_check_login_user VARCHAR2
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
105 , x_return_status out nocopy VARCHAR2
106 , x_msg_count out nocopy NUMBER
107 , x_msg_data out nocopy VARCHAR2
108 , p_check_login_user VARCHAR2
109 , p_category_id NUMBER
110 , p_include_subcats VARCHAR2
111 , p11_a0 out nocopy NUMBER
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
121 , p10_a1 VARCHAR2 := fnd_api.g_miss_char
122 );
123 procedure get_catparentshierarchy(p_api_version NUMBER
124 , p_init_msg_list VARCHAR2
125 , p_validation_level NUMBER
126 , x_return_status out nocopy VARCHAR2
127 , x_msg_count out nocopy NUMBER
128 , x_msg_data out nocopy VARCHAR2
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
138 , x_return_status out nocopy VARCHAR2
139 , x_msg_count out nocopy NUMBER
140 , x_msg_data out nocopy VARCHAR2
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
150 , x_return_status out nocopy VARCHAR2
151 , x_msg_count out nocopy NUMBER
152 , x_msg_data out nocopy VARCHAR2
153 , p_check_login_user VARCHAR2
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;