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