1 PACKAGE csp_pick_serial_lots_PUB AUTHID CURRENT_USER AS
2 /* $Header: cspptsls.pls 120.1 2006/07/20 05:49:49 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : csp_pick_serial_lots_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:psl_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- ROW_ID
19 -- PICKLIST_SERIAL_LOT_ID
20 -- CREATED_BY
21 -- CREATION_DATE
22 -- LAST_UPDATED_BY
23 -- LAST_UPDATE_DATE
24 -- LAST_UPDATE_LOGIN
25 -- PICKLIST_LINE_ID
26 -- ORGANIZATION_ID
27 -- INVENTORY_ITEM_ID
28 -- QUANTITY
29 -- LOT_NUMBER
30 -- SERIAL_NUMBER
31 --
32 -- Required:
33 -- Defaults:
34 -- Note: This is automatic generated record definition, it includes all columns
35 -- defined in the table, developer must manually add or delete some of the attributes.
36 --
37 -- End of Comments
38
39 TYPE psl_Rec_Type IS RECORD
40 (
41 ROW_ID ROWID := FND_API.G_MISS_CHAR,
42 PICKLIST_SERIAL_LOT_ID NUMBER := FND_API.G_MISS_NUM,
43 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
44 CREATION_DATE DATE := FND_API.G_MISS_DATE,
45 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
46 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
47 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
48 PICKLIST_LINE_ID NUMBER := FND_API.G_MISS_NUM,
49 ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
50 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
51 QUANTITY NUMBER := FND_API.G_MISS_NUM,
52 LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
53 SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR
54 );
55
56 G_MISS_psl_REC psl_Rec_Type;
57 TYPE psl_Tbl_Type IS TABLE OF psl_Rec_Type
58 INDEX BY BINARY_INTEGER;
59 G_MISS_psl_TBL psl_Tbl_Type;
60
61 TYPE psl_sort_rec_type IS RECORD
62 (
63 -- Please define your own sort by record here.
64 PICKLIST_SERIAL_LOT_ID NUMBER := NULL
65 );
66
67 -- *******************************************************
68 -- Start of Comments
69 -- *******************************************************
70 -- API Name: Create_pick_serial_lots
71 -- Type : Public
72 -- Pre-Req :
73 -- Parameters:
74 -- IN
75 -- p_api_version_number IN NUMBER Required
76 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
78 -- P_psl_Rec IN psl_Rec_Type Required
79 --
80 -- OUT:
81 -- x_return_status OUT NOCOPY VARCHAR2
82 -- x_msg_count OUT NOCOPY NUMBER
83 -- x_msg_data OUT NOCOPY VARCHAR2
84 -- Version : Current version 2.0
85 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
86 -- and basic operation, developer must manually add parameters and business logic as necessary.
87 --
88 -- End of Comments
89 --
90 PROCEDURE Create_pick_serial_lots(
91 P_Api_Version_Number IN NUMBER,
92 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
94 P_psl_Rec IN psl_Rec_Type := G_MISS_psl_REC,
95 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
96 X_PICKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,
97 X_Return_Status OUT NOCOPY VARCHAR2,
98 X_Msg_Count OUT NOCOPY NUMBER,
99 X_Msg_Data OUT NOCOPY VARCHAR2
100 );
101
102 -- *******************************************************
103 -- Start of Comments
104 -- *******************************************************
105 -- API Name: Update_pick_serial_lots
106 -- Type : Public
107 -- Pre-Req :
108 -- Parameters:
109 -- IN
110 -- p_api_version_number IN NUMBER Required
111 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
114 -- P_psl_Rec IN psl_Rec_Type Required
115 --
116 -- OUT:
117 -- x_return_status OUT NOCOPY VARCHAR2
118 -- x_msg_count OUT NOCOPY NUMBER
119 -- x_msg_data OUT NOCOPY VARCHAR2
120 -- Version : Current version 2.0
121 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
122 -- and basic operation, developer must manually add parameters and business logic as necessary.
123 --
124 -- End of Comments
125 --
126 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
127 PROCEDURE Update_pick_serial_lots(
128 P_Api_Version_Number IN NUMBER,
129 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131 P_Identity_Salesforce_Id IN NUMBER := NULL,
132 P_psl_Rec IN psl_Rec_Type,
133 X_Return_Status OUT NOCOPY VARCHAR2,
134 X_Msg_Count OUT NOCOPY NUMBER,
135 X_Msg_Data OUT NOCOPY VARCHAR2
136 );
137
138 -- *******************************************************
139 -- Start of Comments
140 -- *******************************************************
141 -- API Name: Delete_pick_serial_lots
142 -- Type : Public
143 -- Pre-Req :
144 -- Parameters:
145 -- IN
146 -- p_api_version_number IN NUMBER Required
147 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
148 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
149 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
150 -- P_psl_Rec IN psl_Rec_Type Required
151 --
152 -- OUT:
153 -- x_return_status OUT NOCOPY VARCHAR2
154 -- x_msg_count OUT NOCOPY NUMBER
155 -- x_msg_data OUT NOCOPY VARCHAR2
156 -- Version : Current version 2.0
157 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
158 -- and basic operation, developer must manually add parameters and business logic as necessary.
159 --
160 -- End of Comments
161 --
162 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
163 -- The Master delete procedure may not be needed depends on different business requirements.
164 PROCEDURE Delete_pick_serial_lots(
165 P_Api_Version_Number IN NUMBER,
166 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
167 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
168 P_identity_salesforce_id IN NUMBER := NULL,
169 P_psl_Rec IN psl_Rec_Type,
170 X_Return_Status OUT NOCOPY VARCHAR2,
171 X_Msg_Count OUT NOCOPY NUMBER,
172 X_Msg_Data OUT NOCOPY VARCHAR2
173 );
174
175 -- *******************************************************
176 -- Start of Comments
177 -- *******************************************************
178 -- API Name: Get_pick_serial_lots
179 -- Type : Public
180 -- Pre-Req :
181 -- Parameters:
182 -- IN
183 -- p_api_version_number IN NUMBER Required
184 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
185 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
186 -- P_psl_Rec IN psl_Rec_Type Required
187 -- Hint: Add List of bind variables here
188 -- p_rec_requested IN NUMBER Optional Default = 30
189 -- p_start_rec_ptr IN NUMBER Optional Default = 1
190 --
191 -- Return Total Records Count Flag. This flag controls whether the total record count
192 -- and total record amount is returned.
193 --
194 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
195 -- Hint: User defined record type
196 -- p_order_by_tbl IN JTF_PLSQL_API.UTIL_ORDER_BY_TBL_TYPE;
197 --
198 -- OUT:
199 -- x_return_status OUT NOCOPY VARCHAR2
200 -- x_msg_count OUT NOCOPY NUMBER
201 -- x_msg_data OUT NOCOPY VARCHAR2
202 -- X_psl_Tbl OUT NOCOPY psl_Rec_Type
203 -- x_returned_rec_count OUT NOCOPY NUMBER
204 -- x_next_rec_ptr OUT NOCOPY NUMBER
205 -- x_tot_rec_count OUT NOCOPY NUMBER
206 -- other optional OUT NOCOPY parameters
207 -- x_tot_rec_amount OUT NOCOPY NUMBER
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 PROCEDURE Get_pick_serial_lots(
215 P_Api_Version_Number IN NUMBER,
216 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217 P_identity_salesforce_id IN NUMBER := NULL,
218 P_psl_Rec IN csp_pick_serial_lots_PUB.psl_Rec_Type,
219 -- Hint: Add list of bind variables here
220 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
221 p_start_rec_prt IN NUMBER := 1,
222 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
223 -- Hint: user defined record type
224 p_order_by_rec IN csp_pick_serial_lots_PUB.psl_sort_rec_type,
225 x_return_status OUT NOCOPY VARCHAR2,
226 x_msg_count OUT NOCOPY NUMBER,
227 x_msg_data OUT NOCOPY VARCHAR2,
228 X_psl_Tbl OUT NOCOPY csp_pick_serial_lots_PUB.psl_Tbl_Type,
229 x_returned_rec_count OUT NOCOPY NUMBER,
230 x_next_rec_ptr OUT NOCOPY NUMBER,
231 x_tot_rec_count OUT NOCOPY NUMBER
232 -- other optional parameters
233 -- x_tot_rec_amount OUT NOCOPY NUMBER
234 );
235
236 End csp_pick_serial_lots_PUB;