[Home] [Help]
PACKAGE: APPS.AMV_MYCHANNEL_PVT_W
Source
1 package amv_mychannel_pvt_w as
2 /* $Header: amvwmycs.pls 120.2 2005/06/30 08:21 appldev ship $ */
3 procedure rosetta_table_copy_in_p0(t out nocopy amv_mychannel_pvt.amv_number_varray_type, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p0(t amv_mychannel_pvt.amv_number_varray_type, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p4(t out nocopy amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 JTF_NUMBER_TABLE
7 , a1 JTF_NUMBER_TABLE
8 , a2 JTF_VARCHAR2_TABLE_300
9 );
10 procedure rosetta_table_copy_out_p4(t amv_mychannel_pvt.amv_cat_hierarchy_varray_type, a0 out nocopy JTF_NUMBER_TABLE
11 , a1 out nocopy JTF_NUMBER_TABLE
12 , a2 out nocopy JTF_VARCHAR2_TABLE_300
13 );
14
15 procedure rosetta_table_copy_in_p6(t out nocopy amv_mychannel_pvt.amv_my_channel_varray_type, a0 JTF_NUMBER_TABLE
16 , a1 JTF_VARCHAR2_TABLE_100
17 , a2 JTF_VARCHAR2_TABLE_100
18 , a3 JTF_NUMBER_TABLE
19 , a4 JTF_VARCHAR2_TABLE_100
20 , a5 JTF_NUMBER_TABLE
21 , a6 JTF_VARCHAR2_TABLE_100
22 , a7 JTF_VARCHAR2_TABLE_100
23 , a8 JTF_NUMBER_TABLE
24 , a9 JTF_VARCHAR2_TABLE_100
25 , a10 JTF_VARCHAR2_TABLE_100
26 , a11 JTF_VARCHAR2_TABLE_100
27 );
28 procedure rosetta_table_copy_out_p6(t amv_mychannel_pvt.amv_my_channel_varray_type, a0 out nocopy JTF_NUMBER_TABLE
29 , a1 out nocopy JTF_VARCHAR2_TABLE_100
30 , a2 out nocopy JTF_VARCHAR2_TABLE_100
31 , a3 out nocopy JTF_NUMBER_TABLE
32 , a4 out nocopy JTF_VARCHAR2_TABLE_100
33 , a5 out nocopy JTF_NUMBER_TABLE
34 , a6 out nocopy JTF_VARCHAR2_TABLE_100
35 , a7 out nocopy JTF_VARCHAR2_TABLE_100
36 , a8 out nocopy JTF_NUMBER_TABLE
37 , a9 out nocopy JTF_VARCHAR2_TABLE_100
38 , a10 out nocopy JTF_VARCHAR2_TABLE_100
39 , a11 out nocopy JTF_VARCHAR2_TABLE_100
40 );
41
42 procedure rosetta_table_copy_in_p8(t out nocopy amv_mychannel_pvt.amv_wf_notif_varray_type, a0 JTF_NUMBER_TABLE
43 , a1 JTF_VARCHAR2_TABLE_4000
44 , a2 JTF_DATE_TABLE
45 , a3 JTF_DATE_TABLE
46 , a4 JTF_DATE_TABLE
47 , a5 JTF_VARCHAR2_TABLE_100
48 , a6 JTF_NUMBER_TABLE
49 , a7 JTF_VARCHAR2_TABLE_100
50 );
51 procedure rosetta_table_copy_out_p8(t amv_mychannel_pvt.amv_wf_notif_varray_type, a0 out nocopy JTF_NUMBER_TABLE
52 , a1 out nocopy JTF_VARCHAR2_TABLE_4000
53 , a2 out nocopy JTF_DATE_TABLE
54 , a3 out nocopy JTF_DATE_TABLE
55 , a4 out nocopy JTF_DATE_TABLE
56 , a5 out nocopy JTF_VARCHAR2_TABLE_100
57 , a6 out nocopy JTF_NUMBER_TABLE
58 , a7 out nocopy JTF_VARCHAR2_TABLE_100
59 );
60
61 procedure rosetta_table_copy_in_p10(t out nocopy amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 JTF_NUMBER_TABLE
62 , a1 JTF_VARCHAR2_TABLE_300
63 , a2 JTF_VARCHAR2_TABLE_2000
64 , a3 JTF_VARCHAR2_TABLE_100
65 );
66 procedure rosetta_table_copy_out_p10(t amv_mychannel_pvt.amv_itemdisplay_varray_type, a0 out nocopy JTF_NUMBER_TABLE
67 , a1 out nocopy JTF_VARCHAR2_TABLE_300
68 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
69 , a3 out nocopy JTF_VARCHAR2_TABLE_100
70 );
71
72 procedure add_subscription(p_api_version NUMBER
73 , p_init_msg_list VARCHAR2
74 , p_commit VARCHAR2
75 , p_validation_level NUMBER
76 , x_return_status out nocopy VARCHAR2
77 , x_msg_count out nocopy NUMBER
78 , x_msg_data out nocopy VARCHAR2
79 , p_check_login_user VARCHAR2
80 , x_mychannel_id out nocopy NUMBER
81 , p8_a0 NUMBER := 0-1962.0724
82 , p8_a1 VARCHAR2 := fnd_api.g_miss_char
83 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
84 , p8_a3 NUMBER := 0-1962.0724
85 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
86 , p8_a5 NUMBER := 0-1962.0724
87 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
88 , p8_a7 VARCHAR2 := fnd_api.g_miss_char
89 , p8_a8 NUMBER := 0-1962.0724
90 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
91 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
92 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
93 );
94 procedure update_mychannel(p_api_version NUMBER
95 , p_init_msg_list VARCHAR2
96 , p_commit VARCHAR2
97 , p_validation_level NUMBER
98 , x_return_status out nocopy VARCHAR2
99 , x_msg_count out nocopy NUMBER
100 , x_msg_data out nocopy VARCHAR2
101 , p_check_login_user VARCHAR2
102 , p8_a0 NUMBER := 0-1962.0724
103 , p8_a1 VARCHAR2 := fnd_api.g_miss_char
104 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
105 , p8_a3 NUMBER := 0-1962.0724
106 , p8_a4 VARCHAR2 := fnd_api.g_miss_char
107 , p8_a5 NUMBER := 0-1962.0724
108 , p8_a6 VARCHAR2 := fnd_api.g_miss_char
109 , p8_a7 VARCHAR2 := fnd_api.g_miss_char
110 , p8_a8 NUMBER := 0-1962.0724
111 , p8_a9 VARCHAR2 := fnd_api.g_miss_char
112 , p8_a10 VARCHAR2 := fnd_api.g_miss_char
113 , p8_a11 VARCHAR2 := fnd_api.g_miss_char
114 );
115 procedure get_mychannels(p_api_version NUMBER
116 , p_init_msg_list VARCHAR2
117 , p_validation_level NUMBER
118 , x_return_status out nocopy VARCHAR2
119 , x_msg_count out nocopy NUMBER
120 , x_msg_data out nocopy VARCHAR2
121 , p_check_login_user VARCHAR2
122 , p_user_id NUMBER
123 , p8_a0 out nocopy JTF_NUMBER_TABLE
124 , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
125 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
126 , p8_a3 out nocopy JTF_NUMBER_TABLE
127 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
128 , p8_a5 out nocopy JTF_NUMBER_TABLE
129 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
130 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
131 , p8_a8 out nocopy JTF_NUMBER_TABLE
132 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
133 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
134 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_100
135 );
136 procedure get_mychannelspercategory(p_api_version NUMBER
137 , p_init_msg_list VARCHAR2
138 , p_validation_level NUMBER
139 , x_return_status out nocopy VARCHAR2
140 , x_msg_count out nocopy NUMBER
141 , x_msg_data out nocopy VARCHAR2
142 , p_check_login_user VARCHAR2
143 , p_user_id NUMBER
144 , p_category_id NUMBER
145 , x_channel_array out nocopy JTF_NUMBER_TABLE
146 );
147 procedure get_mynotifications(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_resource_id NUMBER
155 , p_user_id NUMBER
156 , p_user_name VARCHAR2
157 , p_notification_type VARCHAR2
158 , x_notification_url out nocopy VARCHAR2
159 , p12_a0 out nocopy JTF_NUMBER_TABLE
160 , p12_a1 out nocopy JTF_VARCHAR2_TABLE_4000
161 , p12_a2 out nocopy JTF_DATE_TABLE
162 , p12_a3 out nocopy JTF_DATE_TABLE
163 , p12_a4 out nocopy JTF_DATE_TABLE
164 , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
165 , p12_a6 out nocopy JTF_NUMBER_TABLE
166 , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
167 );
168 procedure get_itemsperuser(p_api_version NUMBER
169 , p_init_msg_list VARCHAR2
170 , p_validation_level NUMBER
171 , x_return_status out nocopy VARCHAR2
172 , x_msg_count out nocopy NUMBER
173 , x_msg_data out nocopy VARCHAR2
174 , p_check_login_user VARCHAR2
175 , p_user_id NUMBER
176 , p9_a0 out nocopy NUMBER
177 , p9_a1 out nocopy NUMBER
178 , p9_a2 out nocopy NUMBER
179 , p10_a0 out nocopy JTF_NUMBER_TABLE
180 , p10_a1 out nocopy JTF_NUMBER_TABLE
181 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_300
182 , p8_a0 NUMBER := 0-1962.0724
183 , p8_a1 NUMBER := 0-1962.0724
184 , p8_a2 VARCHAR2 := fnd_api.g_miss_char
185 );
186 procedure get_useritems(p_api_version NUMBER
187 , p_init_msg_list VARCHAR2
188 , p_validation_level NUMBER
189 , x_return_status out nocopy VARCHAR2
190 , x_msg_count out nocopy NUMBER
191 , x_msg_data out nocopy VARCHAR2
192 , p_check_login_user VARCHAR2
193 , p_application_id NUMBER
194 , p_user_id NUMBER
195 , p10_a0 out nocopy NUMBER
196 , p10_a1 out nocopy NUMBER
197 , p10_a2 out nocopy NUMBER
198 , p11_a0 out nocopy JTF_NUMBER_TABLE
199 , p11_a1 out nocopy JTF_VARCHAR2_TABLE_300
200 , p11_a2 out nocopy JTF_VARCHAR2_TABLE_2000
201 , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
202 , p9_a0 NUMBER := 0-1962.0724
203 , p9_a1 NUMBER := 0-1962.0724
204 , p9_a2 VARCHAR2 := fnd_api.g_miss_char
205 );
206 end amv_mychannel_pvt_w;