[Home] [Help]
PACKAGE: APPS.JTF_AMV_ITEM_PUB_W
Source
1 package jtf_amv_item_pub_w as
2 /* $Header: jtfpitws.pls 120.3 2005/09/13 11:09:59 vimohan ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy jtf_amv_item_pub.number_tab_type, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p1(t jtf_amv_item_pub.number_tab_type, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p2(t out nocopy jtf_amv_item_pub.char_tab_type, a0 JTF_VARCHAR2_TABLE_200);
7 procedure rosetta_table_copy_out_p2(t jtf_amv_item_pub.char_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_200);
8
9 procedure create_item(p_api_version NUMBER
10 , p_init_msg_list VARCHAR2
11 , p_commit VARCHAR2
12 , x_return_status out nocopy VARCHAR2
13 , x_msg_count out nocopy NUMBER
14 , x_msg_data out nocopy VARCHAR2
15 , x_item_id out nocopy NUMBER
16 , p6_a0 NUMBER := 0-1962.0724
17 , p6_a1 DATE := fnd_api.g_miss_date
18 , p6_a2 NUMBER := 0-1962.0724
19 , p6_a3 DATE := fnd_api.g_miss_date
20 , p6_a4 NUMBER := 0-1962.0724
21 , p6_a5 NUMBER := 0-1962.0724
22 , p6_a6 NUMBER := 0-1962.0724
23 , p6_a7 NUMBER := 0-1962.0724
24 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
25 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
26 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
27 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
28 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
29 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
30 , p6_a14 DATE := fnd_api.g_miss_date
31 , p6_a15 DATE := fnd_api.g_miss_date
32 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
33 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
34 , p6_a18 DATE := fnd_api.g_miss_date
35 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
36 , p6_a20 NUMBER := 0-1962.0724
37 , p6_a21 NUMBER := 0-1962.0724
38 , p6_a22 NUMBER := 0-1962.0724
39 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
40 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
41 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
42 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
43 );
44 procedure update_item(p_api_version NUMBER
45 , p_init_msg_list VARCHAR2
46 , p_commit VARCHAR2
47 , x_return_status out nocopy VARCHAR2
48 , x_msg_count out nocopy NUMBER
49 , x_msg_data out nocopy VARCHAR2
50 , p6_a0 NUMBER := 0-1962.0724
51 , p6_a1 DATE := fnd_api.g_miss_date
52 , p6_a2 NUMBER := 0-1962.0724
53 , p6_a3 DATE := fnd_api.g_miss_date
54 , p6_a4 NUMBER := 0-1962.0724
55 , p6_a5 NUMBER := 0-1962.0724
56 , p6_a6 NUMBER := 0-1962.0724
57 , p6_a7 NUMBER := 0-1962.0724
58 , p6_a8 VARCHAR2 := fnd_api.g_miss_char
59 , p6_a9 VARCHAR2 := fnd_api.g_miss_char
60 , p6_a10 VARCHAR2 := fnd_api.g_miss_char
61 , p6_a11 VARCHAR2 := fnd_api.g_miss_char
62 , p6_a12 VARCHAR2 := fnd_api.g_miss_char
63 , p6_a13 VARCHAR2 := fnd_api.g_miss_char
64 , p6_a14 DATE := fnd_api.g_miss_date
65 , p6_a15 DATE := fnd_api.g_miss_date
66 , p6_a16 VARCHAR2 := fnd_api.g_miss_char
67 , p6_a17 VARCHAR2 := fnd_api.g_miss_char
68 , p6_a18 DATE := fnd_api.g_miss_date
69 , p6_a19 VARCHAR2 := fnd_api.g_miss_char
70 , p6_a20 NUMBER := 0-1962.0724
71 , p6_a21 NUMBER := 0-1962.0724
72 , p6_a22 NUMBER := 0-1962.0724
73 , p6_a23 VARCHAR2 := fnd_api.g_miss_char
74 , p6_a24 VARCHAR2 := fnd_api.g_miss_char
75 , p6_a25 VARCHAR2 := fnd_api.g_miss_char
76 , p6_a26 VARCHAR2 := fnd_api.g_miss_char
77 );
78 procedure get_item(p_api_version NUMBER
79 , p_init_msg_list VARCHAR2
80 , x_return_status out nocopy VARCHAR2
81 , x_msg_count out nocopy NUMBER
82 , x_msg_data out nocopy VARCHAR2
83 , p_item_id NUMBER
84 , p6_a0 out nocopy NUMBER
85 , p6_a1 out nocopy DATE
86 , p6_a2 out nocopy NUMBER
87 , p6_a3 out nocopy DATE
88 , p6_a4 out nocopy NUMBER
89 , p6_a5 out nocopy NUMBER
90 , p6_a6 out nocopy NUMBER
91 , p6_a7 out nocopy NUMBER
92 , p6_a8 out nocopy VARCHAR2
93 , p6_a9 out nocopy VARCHAR2
94 , p6_a10 out nocopy VARCHAR2
95 , p6_a11 out nocopy VARCHAR2
96 , p6_a12 out nocopy VARCHAR2
97 , p6_a13 out nocopy VARCHAR2
98 , p6_a14 out nocopy DATE
99 , p6_a15 out nocopy DATE
100 , p6_a16 out nocopy VARCHAR2
101 , p6_a17 out nocopy VARCHAR2
102 , p6_a18 out nocopy DATE
103 , p6_a19 out nocopy VARCHAR2
104 , p6_a20 out nocopy NUMBER
105 , p6_a21 out nocopy NUMBER
106 , p6_a22 out nocopy NUMBER
107 , p6_a23 out nocopy VARCHAR2
108 , p6_a24 out nocopy VARCHAR2
109 , p6_a25 out nocopy VARCHAR2
110 , p6_a26 out nocopy VARCHAR2
111 );
112 procedure add_itemkeyword(p_api_version NUMBER
113 , p_init_msg_list VARCHAR2
114 , p_commit VARCHAR2
115 , x_return_status out nocopy VARCHAR2
116 , x_msg_count out nocopy NUMBER
117 , x_msg_data out nocopy VARCHAR2
118 , p_item_id NUMBER
119 , p_keyword_tab JTF_VARCHAR2_TABLE_200
120 );
121 procedure delete_itemkeyword(p_api_version NUMBER
122 , p_init_msg_list VARCHAR2
123 , p_commit VARCHAR2
124 , x_return_status out nocopy VARCHAR2
125 , x_msg_count out nocopy NUMBER
126 , x_msg_data out nocopy VARCHAR2
127 , p_item_id NUMBER
128 , p_keyword_tab JTF_VARCHAR2_TABLE_200
129 );
130 procedure replace_itemkeyword(p_api_version NUMBER
131 , p_init_msg_list VARCHAR2
132 , p_commit VARCHAR2
133 , x_return_status out nocopy VARCHAR2
134 , x_msg_count out nocopy NUMBER
135 , x_msg_data out nocopy VARCHAR2
136 , p_item_id NUMBER
137 , p_keyword_tab JTF_VARCHAR2_TABLE_200
138 );
139 procedure get_itemkeyword(p_api_version NUMBER
140 , p_init_msg_list VARCHAR2
141 , x_return_status out nocopy VARCHAR2
142 , x_msg_count out nocopy NUMBER
143 , x_msg_data out nocopy VARCHAR2
144 , p_item_id NUMBER
145 , x_keyword_tab out nocopy JTF_VARCHAR2_TABLE_200
146 );
147 procedure add_itemauthor(p_api_version NUMBER
148 , p_init_msg_list VARCHAR2
149 , p_commit VARCHAR2
150 , x_return_status out nocopy VARCHAR2
151 , x_msg_count out nocopy NUMBER
152 , x_msg_data out nocopy VARCHAR2
153 , p_item_id NUMBER
154 , p_author_tab JTF_VARCHAR2_TABLE_200
155 );
156 procedure delete_itemauthor(p_api_version NUMBER
157 , p_init_msg_list VARCHAR2
158 , p_commit VARCHAR2
159 , x_return_status out nocopy VARCHAR2
160 , x_msg_count out nocopy NUMBER
161 , x_msg_data out nocopy VARCHAR2
162 , p_item_id NUMBER
163 , p_author_tab JTF_VARCHAR2_TABLE_200
164 );
165 procedure replace_itemauthor(p_api_version NUMBER
166 , p_init_msg_list VARCHAR2
167 , p_commit VARCHAR2
168 , x_return_status out nocopy VARCHAR2
169 , x_msg_count out nocopy NUMBER
170 , x_msg_data out nocopy VARCHAR2
171 , p_item_id NUMBER
172 , p_author_tab JTF_VARCHAR2_TABLE_200
173 );
174 procedure get_itemauthor(p_api_version NUMBER
175 , p_init_msg_list VARCHAR2
176 , x_return_status out nocopy VARCHAR2
177 , x_msg_count out nocopy NUMBER
178 , x_msg_data out nocopy VARCHAR2
179 , p_item_id NUMBER
180 , x_author_tab out nocopy JTF_VARCHAR2_TABLE_200
181 );
182 end jtf_amv_item_pub_w;