1 PACKAGE AMS_Ps_Posting_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsppsts.pls 115.4 2002/11/25 20:47:28 ryedator ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ps_Posting_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- ps_posting_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- row_id
26 -- created_by
27 -- creation_date
28 -- last_updated_by
29 -- last_update_date
30 -- last_update_login
31 -- object_version_number
32 -- posting_id
33 -- max_no_contents
34 -- posting_type
35 -- content_type
36 -- default_content_id
37 -- status_code
38 -- posting_name
39 -- posting_description
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE ps_posting_rec_type IS RECORD
52 (
53 row_id ROWID := FND_API.G_MISS_CHAR,
54 created_by NUMBER := FND_API.G_MISS_NUM,
55 creation_date DATE := FND_API.G_MISS_DATE,
56 last_updated_by NUMBER := FND_API.G_MISS_NUM,
57 last_update_date DATE := FND_API.G_MISS_DATE,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 posting_id NUMBER := FND_API.G_MISS_NUM,
61 max_no_contents NUMBER := FND_API.G_MISS_NUM,
62 posting_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 default_content_id NUMBER := FND_API.G_MISS_NUM,
65 status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
66 posting_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
67 posting_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
68 );
69
70 g_miss_ps_posting_rec ps_posting_rec_type;
71 TYPE ps_posting_tbl_type IS TABLE OF ps_posting_rec_type INDEX BY BINARY_INTEGER;
72 g_miss_ps_posting_tbl ps_posting_tbl_type;
73
74 TYPE ps_posting_sort_rec_type IS RECORD
75 (
76 -- Please define your own sort by record here.
77 created_by NUMBER := NULL
78 );
79
80 -- ==============================================================================
81 -- Start of Comments
82 -- ==============================================================================
83 -- API Name
84 -- Create_Ps_Posting
85 -- Type
86 -- Public
87 -- Pre-Req
88 --
89 -- Parameters
90 --
91 -- IN
92 -- p_api_version_number IN NUMBER Required
93 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
94 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
95 -- p_ps_posting_rec IN ps_posting_rec_type Required
96 --
97 -- OUT
98 -- x_return_status OUT VARCHAR2
99 -- x_msg_count OUT NUMBER
100 -- x_msg_data OUT VARCHAR2
101 -- Version : Current version 1.0
102 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
103 -- and basic operation, developer must manually add parameters and business logic as necessary.
104 --
105 -- End of Comments
106 -- ==============================================================================
107 --
108
109 PROCEDURE Create_Ps_Posting(
110 p_api_version_number IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117
118 p_ps_posting_rec IN ps_posting_rec_type := g_miss_ps_posting_rec,
119 x_posting_id OUT NOCOPY NUMBER
120 );
121
122 -- ==============================================================================
123 -- Start of Comments
124 -- ==============================================================================
125 -- API Name
126 -- Update_Ps_Posting
127 -- Type
128 -- Public
129 -- Pre-Req
130 --
131 -- Parameters
132 --
133 -- IN
134 -- p_api_version_number IN NUMBER Required
135 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
136 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
137 -- p_ps_posting_rec IN ps_posting_rec_type Required
138 --
139 -- OUT
140 -- x_return_status OUT VARCHAR2
141 -- x_msg_count OUT NUMBER
142 -- x_msg_data OUT VARCHAR2
143 -- Version : Current version 1.0
144 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
145 -- and basic operation, developer must manually add parameters and business logic as necessary.
146 --
147 -- End of Comments
148 -- ==============================================================================
149 --
150
151 PROCEDURE Update_Ps_Posting(
152 p_api_version_number IN NUMBER,
153 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE,
155
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159
160 p_ps_posting_rec IN ps_posting_rec_type,
161 x_object_version_number OUT NOCOPY NUMBER
162 );
163
164 -- ==============================================================================
165 -- Start of Comments
166 -- ==============================================================================
167 -- API Name
168 -- Delete_Ps_Posting
169 -- Type
170 -- Public
171 -- Pre-Req
172 --
173 -- Parameters
174 --
175 -- IN
176 -- p_api_version_number IN NUMBER Required
177 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
178 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
179 -- p_POSTING_ID IN NUMBER
180 -- p_object_version_number IN NUMBER Optional Default = NULL
181 --
182 -- OUT
183 -- x_return_status OUT VARCHAR2
184 -- x_msg_count OUT NUMBER
185 -- x_msg_data OUT VARCHAR2
186 -- Version : Current version 1.0
187 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
188 -- and basic operation, developer must manually add parameters and business logic as necessary.
189 --
190 -- End of Comments
191 -- ==============================================================================
192 --
193
194 PROCEDURE Delete_Ps_Posting(
195 p_api_version_number IN NUMBER,
196 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197 p_commit IN VARCHAR2 := FND_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_posting_id IN NUMBER,
202 p_object_version_number IN NUMBER
203 );
204
205 -- ==============================================================================
206 -- Start of Comments
207 -- ==============================================================================
208 -- API Name
209 -- Lock_Ps_Posting
210 -- Type
211 -- Public
212 -- Pre-Req
213 --
214 -- Parameters
215 --
216 -- IN
217 -- p_api_version_number IN NUMBER Required
218 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
219 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
220 -- p_ps_posting_rec IN ps_posting_rec_type Required
221 --
222 -- OUT
223 -- x_return_status OUT VARCHAR2
224 -- x_msg_count OUT NUMBER
225 -- x_msg_data OUT VARCHAR2
226 -- Version : Current version 1.0
227 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
228 -- and basic operation, developer must manually add parameters and business logic as necessary.
229 --
230 -- End of Comments
231 -- ==============================================================================
232 --
233
234 PROCEDURE Lock_Ps_Posting(
235 p_api_version_number IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240
241 p_posting_id IN NUMBER,
242 p_object_version IN NUMBER
243 );
244
245 END AMS_Ps_Posting_PUB;