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