1 PACKAGE AMS_Ps_Strats_PUB AS
2 /* $Header: amspstrs.pls 120.0 2005/05/31 15:15:33 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Ps_Strats_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_strats_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 -- security_group_id
32 -- object_version_number
33 -- strategy_id
34 -- max_returned
35 -- strategy_type
36 -- content_type
37 -- strategy_ref_code
38 -- selector_class
39 -- strategy_name
40 -- strategy_description
41 --
42 -- Required
43 --
44 -- Defaults
45 --
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50
51 --===================================================================
52 TYPE ps_strats_rec_type IS RECORD
53 (
54 row_id ROWID := FND_API.G_MISS_CHAR,
55 created_by NUMBER := FND_API.G_MISS_NUM,
56 creation_date DATE := FND_API.G_MISS_DATE,
57 last_updated_by NUMBER := FND_API.G_MISS_NUM,
58 last_update_date DATE := FND_API.G_MISS_DATE,
59 last_update_login NUMBER := FND_API.G_MISS_NUM,
60 security_group_id NUMBER := FND_API.G_MISS_NUM,
61 object_version_number NUMBER := FND_API.G_MISS_NUM,
62 strategy_id NUMBER := FND_API.G_MISS_NUM,
63 max_returned NUMBER := FND_API.G_MISS_NUM,
64 strategy_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 content_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
66 strategy_ref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
67 selector_class VARCHAR2(1000) := FND_API.G_MISS_CHAR,
68 strategy_name VARCHAR2(100) := FND_API.G_MISS_CHAR,
69 strategy_description VARCHAR2(1000) := FND_API.G_MISS_CHAR
70 );
71
72 g_miss_ps_strats_rec ps_strats_rec_type;
73 TYPE ps_strats_tbl_type IS TABLE OF ps_strats_rec_type INDEX BY BINARY_INTEGER;
74 g_miss_ps_strats_tbl ps_strats_tbl_type;
75
76 TYPE ps_strats_sort_rec_type IS RECORD
77 (
78 -- Please define your own sort by record here.
79 created_by NUMBER := NULL
80 );
81
82 -- ==============================================================================
83 -- Start of Comments
84 -- ==============================================================================
85 -- API Name
86 -- Create_Ps_Strats
87 -- Type
88 -- Public
89 -- Pre-Req
90 --
91 -- Parameters
92 --
93 -- IN
94 -- p_api_version_number IN NUMBER Required
95 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
96 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
97 -- p_ps_strats_rec IN ps_strats_rec_type Required
98 --
99 -- OUT
100 -- x_return_status OUT VARCHAR2
101 -- x_msg_count OUT NUMBER
102 -- x_msg_data OUT VARCHAR2
103 -- Version : Current version 1.0
104 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
105 -- and basic operation, developer must manually add parameters and business logic as necessary.
106 --
107 -- End of Comments
108 -- ==============================================================================
109 --
110
111 PROCEDURE Create_Ps_Strats(
112 p_api_version_number IN NUMBER,
113 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
114 p_commit IN VARCHAR2 := FND_API.G_FALSE,
115
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119
120 p_ps_strats_rec IN ps_strats_rec_type := g_miss_ps_strats_rec,
121 x_strategy_id OUT NOCOPY NUMBER
122 );
123
124 -- ==============================================================================
125 -- Start of Comments
126 -- ==============================================================================
127 -- API Name
128 -- Update_Ps_Strats
129 -- Type
130 -- Public
131 -- Pre-Req
132 --
133 -- Parameters
134 --
135 -- IN
136 -- p_api_version_number IN NUMBER Required
137 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
138 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
139 -- p_ps_strats_rec IN ps_strats_rec_type Required
140 --
141 -- OUT
142 -- x_return_status OUT VARCHAR2
143 -- x_msg_count OUT NUMBER
144 -- x_msg_data OUT VARCHAR2
145 -- Version : Current version 1.0
146 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
147 -- and basic operation, developer must manually add parameters and business logic as necessary.
148 --
149 -- End of Comments
150 -- ==============================================================================
151 --
152
153 PROCEDURE Update_Ps_Strats(
154 p_api_version_number IN NUMBER,
155 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
156 p_commit IN VARCHAR2 := FND_API.G_FALSE,
157
158 x_return_status OUT NOCOPY VARCHAR2,
159 x_msg_count OUT NOCOPY NUMBER,
160 x_msg_data OUT NOCOPY VARCHAR2,
161
162 p_ps_strats_rec IN ps_strats_rec_type,
163 x_object_version_number OUT NOCOPY NUMBER
164 );
165
166 -- ==============================================================================
167 -- Start of Comments
168 -- ==============================================================================
169 -- API Name
170 -- Delete_Ps_Strats
171 -- Type
172 -- Public
173 -- Pre-Req
174 --
175 -- Parameters
176 --
177 -- IN
178 -- p_api_version_number IN NUMBER Required
179 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
180 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
181 -- p_STRATEGY_ID IN NUMBER
182 -- p_object_version_number IN NUMBER Optional Default = NULL
183 --
184 -- OUT
185 -- x_return_status OUT VARCHAR2
186 -- x_msg_count OUT NUMBER
187 -- x_msg_data OUT VARCHAR2
188 -- Version : Current version 1.0
189 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
190 -- and basic operation, developer must manually add parameters and business logic as necessary.
191 --
192 -- End of Comments
193 -- ==============================================================================
194 --
195
196 PROCEDURE Delete_Ps_Strats(
197 p_api_version_number IN NUMBER,
198 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
199 p_commit IN VARCHAR2 := FND_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_strategy_id IN NUMBER,
204 p_object_version_number IN NUMBER
205 );
206
207 -- ==============================================================================
208 -- Start of Comments
209 -- ==============================================================================
210 -- API Name
211 -- Lock_Ps_Strats
212 -- Type
213 -- Public
214 -- Pre-Req
215 --
216 -- Parameters
217 --
218 -- IN
219 -- p_api_version_number IN NUMBER Required
220 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222 -- p_ps_strats_rec IN ps_strats_rec_type Required
223 --
224 -- OUT
225 -- x_return_status OUT VARCHAR2
226 -- x_msg_count OUT NUMBER
227 -- x_msg_data OUT VARCHAR2
228 -- Version : Current version 1.0
229 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
230 -- and basic operation, developer must manually add parameters and business logic as necessary.
231 --
232 -- End of Comments
233 -- ==============================================================================
234 --
235
236 PROCEDURE Lock_Ps_Strats(
237 p_api_version_number IN NUMBER,
238 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239 x_return_status OUT NOCOPY VARCHAR2,
240 x_msg_count OUT NOCOPY NUMBER,
241 x_msg_data OUT NOCOPY VARCHAR2,
242
243 p_strategy_id IN NUMBER,
244 p_object_version IN NUMBER
245 );
246
247 END AMS_Ps_Strats_PUB;