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