1 PACKAGE CSP_TASK_PART_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspptaps.pls 115.2 2002/11/26 06:18:29 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_TASK_PART_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9 -- Default number of records fetch per call
10 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11 -- *******************************************************
12 -- Start of Comments
13 -- -------------------------------------------------------
14 -- Record name:TASK_PART_Rec_Type
15 -- -------------------------------------------------------
16 -- Parameters:
17 -- TASK_PART_ID
18 -- PRODUCT_TASK_ID
19 -- INVENTORY_ITEM_ID
20 -- MANUAL_QUANTITY
21 -- MANUAL_PERCENTAGE
22 -- QUANTITY_USED
23 -- ACTUAL_TIMES_USED
24 -- CALCULATED_QUANTITY
25 -- PART_PERCENTAGE
26 -- CREATED_BY
27 -- CREATION_DATE
28 -- LAST_UPDATED_BY
29 -- LAST_UPDATE_DATE
30 -- LAST_UPDATE_LOGIN
31 -- ATTRIBUTE_CATEGORY
32 -- ATTRIBUTE1
33 -- ATTRIBUTE2
34 -- ATTRIBUTE3
35 -- ATTRIBUTE4
36 -- ATTRIBUTE5
37 -- ATTRIBUTE6
38 -- ATTRIBUTE7
39 -- ATTRIBUTE8
40 -- ATTRIBUTE9
41 -- ATTRIBUTE10
42 -- ATTRIBUTE11
43 -- ATTRIBUTE12
44 -- ATTRIBUTE13
45 -- ATTRIBUTE14
46 -- ATTRIBUTE15
47 -- PRIMARY_UOM_CODE
48 -- REVISION
49 -- START_DATE
50 -- END_DATE
51 --
52 -- Required:
53 -- Defaults:
54 -- Note: This is automatic generated record definition, it includes all columns
55 -- defined in the table, developer must manually add or delete some of the attributes.
56 --
57 -- End of Comments
58 TYPE TASK_PART_Rec_Type IS RECORD
59 (
60 TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
61 PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
62 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
63 MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
64 MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
65 QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
66 ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
67 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
68 CREATION_DATE DATE := FND_API.G_MISS_DATE,
69 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
70 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
71 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
72 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88 PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
89 REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
90 START_DATE DATE := FND_API.G_MISS_DATE,
91 END_DATE DATE := FND_API.G_MISS_DATE,
92 ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
93 ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
94 SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
95 );
96 G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
97 TYPE TASK_PART_Tbl_Type IS TABLE OF TASK_PART_Rec_Type
98 INDEX BY BINARY_INTEGER;
99 G_MISS_TASK_PART_TBL TASK_PART_Tbl_Type;
100 TYPE TASK_PART_sort_rec_type IS RECORD
101 (
102 -- Please define your own sort by record here.
103 PRODUCT_TASK_ID NUMBER := NULL
104 );
105 -- *******************************************************
106 -- Start of Comments
107 -- *******************************************************
108 -- API Name: Create_task_part
109 -- Type : Public
110 -- Pre-Req :
111 -- Parameters:
112 -- IN
113 -- p_api_version_number IN NUMBER Required
114 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
115 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
117 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
118 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
119 -- p_admin_group_id IN NUMBER Required
120 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
121 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
122 --
123 -- OUT:
124 -- x_return_status OUT NOCOPY VARCHAR2
125 -- x_msg_count OUT NOCOPY NUMBER
126 -- x_msg_data OUT NOCOPY VARCHAR2
127 -- Version : Current version 2.0
128 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
129 -- and basic operation, developer must manually add parameters and business logic as necessary.
130 --
131 -- End of Comments
132 --
133 PROCEDURE Create_task_part(
134 P_Api_Version_Number IN NUMBER,
135 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
136 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
137 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
138 P_TASK_PART_Rec IN TASK_PART_Rec_Type := G_MISS_TASK_PART_REC,
139 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
140 X_TASK_PART_ID OUT NOCOPY NUMBER,
141 X_Return_Status OUT NOCOPY VARCHAR2,
142 X_Msg_Count OUT NOCOPY NUMBER,
143 X_Msg_Data OUT NOCOPY VARCHAR2
144 );
145 -- *******************************************************
146 -- Start of Comments
147 -- *******************************************************
148 -- API Name: Update_task_part
149 -- Type : Public
150 -- Pre-Req :
151 -- Parameters:
152 -- IN
153 -- p_api_version_number IN NUMBER Required
154 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
155 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
156 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
157 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
158 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
159 -- p_admin_group_id IN NUMBER Required
160 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
161 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
162 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
163 --
164 -- OUT:
165 -- x_return_status OUT NOCOPY VARCHAR2
166 -- x_msg_count OUT NOCOPY NUMBER
167 -- x_msg_data OUT NOCOPY VARCHAR2
168 -- Version : Current version 2.0
169 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
170 -- and basic operation, developer must manually add parameters and business logic as necessary.
171 --
172 -- End of Comments
173 --
174 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
175 PROCEDURE Update_task_part(
176 P_Api_Version_Number IN NUMBER,
177 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
178 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
179 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180 P_TASK_PART_Rec IN TASK_PART_Rec_Type,
181 X_Return_Status OUT NOCOPY VARCHAR2,
182 X_Msg_Count OUT NOCOPY NUMBER,
183 X_Msg_Data OUT NOCOPY VARCHAR2
184 );
185 -- *******************************************************
186 -- Start of Comments
187 -- *******************************************************
188 -- API Name: Delete_task_part
189 -- Type : Public
190 -- Pre-Req :
191 -- Parameters:
192 -- IN
193 -- p_api_version_number IN NUMBER Required
194 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
195 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
196 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
197 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
198 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
199 -- p_admin_group_id IN NUMBER Required
200 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
201 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
202 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
203 --
204 -- OUT:
205 -- x_return_status OUT NOCOPY VARCHAR2
206 -- x_msg_count OUT NOCOPY NUMBER
207 -- x_msg_data OUT NOCOPY VARCHAR2
208 -- Version : Current version 2.0
209 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
210 -- and basic operation, developer must manually add parameters and business logic as necessary.
211 --
212 -- End of Comments
213 --
214 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
215 -- The Master delete procedure may not be needed depends on different business requirements.
216 PROCEDURE Delete_task_part(
217 P_Api_Version_Number IN NUMBER,
218 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
219 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
220 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221 P_TASK_PART_Rec IN TASK_PART_Rec_Type,
222 X_Return_Status OUT NOCOPY VARCHAR2,
223 X_Msg_Count OUT NOCOPY NUMBER,
224 X_Msg_Data OUT NOCOPY VARCHAR2
225 );
226 -- *******************************************************
227 -- Start of Comments
228 -- *******************************************************
229 -- API Name: Get_task_part
230 -- Type : Public
231 -- Pre-Req :
232 -- Parameters:
233 -- IN
234 -- p_api_version_number IN NUMBER Required
235 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
236 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
237 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
238 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
239 -- p_admin_group_id IN NUMBER Required
240 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
241 -- P_TASK_PART_Rec IN TASK_PART_Rec_Type Required
242 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
243 -- Hint: Add List of bind variables here
244 -- p_rec_requested IN NUMBER Optional Default = 30
245 -- p_start_rec_ptr IN NUMBER Optional Default = 1
246 --
247 -- Return Total Records Count Flag. This flag controls whether the total record count
248 -- and total record amount is returned.
249 --
250 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
251 -- Hint: User defined record type
252 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
253 --
254 -- OUT:
255 -- x_return_status OUT NOCOPY VARCHAR2
256 -- x_msg_count OUT NOCOPY NUMBER
257 -- x_msg_data OUT NOCOPY VARCHAR2
258 -- X_TASK_PART_Tbl OUT NOCOPY TASK_PART_Rec_Type
259 -- x_returned_rec_count OUT NOCOPY NUMBER
260 -- x_next_rec_ptr OUT NOCOPY NUMBER
261 -- x_tot_rec_count OUT NOCOPY NUMBER
262 -- other optional OUT NOCOPY parameters
263 -- x_tot_rec_amount OUT NOCOPY NUMBER
264 -- Version : Current version 2.0
265 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
266 -- and basic operation, developer must manually add parameters and business logic as necessary.
267 --
268 -- End of Comments
269 --
270 PROCEDURE Get_task_part(
271 P_Api_Version_Number IN NUMBER,
272 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 P_TASK_PART_Rec IN CSP_task_part_PUB.TASK_PART_Rec_Type,
275 -- Hint: Add list of bind variables here
276 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
277 p_start_rec_prt IN NUMBER := 1,
278 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
279 -- Hint: user defined record type
280 p_order_by_rec IN CSP_task_part_PUB.TASK_PART_sort_rec_type,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 X_TASK_PART_Tbl OUT NOCOPY CSP_task_part_PUB.TASK_PART_Tbl_Type,
285 x_returned_rec_count OUT NOCOPY NUMBER,
286 x_next_rec_ptr OUT NOCOPY NUMBER,
287 x_tot_rec_count OUT NOCOPY NUMBER
288 -- other optional parameters
289 -- x_tot_rec_amount OUT NOCOPY NUMBER
290 );
291 End CSP_TASK_PART_PUB;