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