[Home] [Help]
149: -- Version : Current version 11.5
150: -- Notes :
151: -- The p_order_relationship argument take the
152: -- following enumerated Constant value:
153: -- XDP_TYPES.IS_PREREQUISITE_OF
154: -- Related order will not get executed
155: -- until the current order is completed.
156: -- If the current order is canceled, the
157: -- related order will also be canceled.
154: -- Related order will not get executed
155: -- until the current order is completed.
156: -- If the current order is canceled, the
157: -- related order will also be canceled.
158: -- XDP_TYPES.COMES_BEFORE
159: -- Related order will not get executed
160: -- until the current order is completed
161: -- or the current order is canceled.
162: -- XDP_TYPES.COMES_AFTER
158: -- XDP_TYPES.COMES_BEFORE
159: -- Related order will not get executed
160: -- until the current order is completed
161: -- or the current order is canceled.
162: -- XDP_TYPES.COMES_AFTER
163: -- Current order will not get executed
164: -- until the related order is
165: -- completed or the related order is
166: -- canceled.
163: -- Current order will not get executed
164: -- until the related order is
165: -- completed or the related order is
166: -- canceled.
167: -- XDP_TYPES.IS_CHILD_OF
168: -- Current order is the child order of
169: -- the related order.
170: --
171: -- End of comments
185: -- Version : Current version 11.5
186: -- Notes :
187: -- The p_wi_relationship argument take the
188: -- following enumerated Constant value:
189: -- XDP_TYPES.MERGED_INTO
190: -- Related workitem is merged into the
191: -- current workitem. If the current
192: -- workitem is completed, then the
193: -- related workitem is completed.
209: -- Version : Current version 11.5
210: -- Notes :
211: -- End of comments
212: FUNCTION Get_Order_Header(p_sdp_order_id IN NUMBER)
213: return XDP_TYPES.ORDER_HEADER;
214:
215:
216: -- Start of comments
217: -- API name : Get_Order_Lines
222: -- Version : Current version 11.5
223: -- Notes :
224: -- End of comments
225: FUNCTION Get_Order_Lines( p_sdp_order_id IN NUMBER)
226: return XDP_TYPES.ORDER_LINE_LIST;
227:
228: -- Start of comments
229: -- API name : Get_LineRec
230: -- Type : Public
234: -- Version : Current version 11.5
235: -- Notes :
236: -- End of comments
237: FUNCTION Get_LineRec( p_line_item_id IN NUMBER)
238: return XDP_TYPES.LINE_ITEM;
239:
240: -- Start of comments
241: -- API name : Get_WorkitemRec
242: -- Type : Public
246: -- Version : Current version 11.5
247: -- Notes :
248: -- End of comments
249: FUNCTION Get_WorkitemRec( p_wi_instance_id IN NUMBER)
250: return XDP_TYPES.workitem_rec ;
251:
252: -- Start of comments
253: -- API name : Get_Order_Workitems
254: -- Type : Public
258: -- Version : Current version 11.5
259: -- Notes :
260: -- End of comments
261: FUNCTION Get_Order_Workitems( p_sdp_order_id IN NUMBER)
262: return XDP_TYPES.Workitem_List;
263:
264: -- Start of comments
265: -- API name : Find_Orders
266: -- Type : Public
282: -- 'JD_CALLERID', he/she can specify the search criteria as:
283: --
284: -- declare
285: -- lv_where varchar2(8000);
286: -- lv_list XDP_TYPES.ORDER_HEADER_LIST;
287: -- lv_ret number;
288: -- lv_str varchar2(800);
289: -- begin
290: --
303: -- p_order_list to see if there is any match found.
304: -- End of comments
305: PROCEDURE Find_Orders(
306: p_where IN OUT NOCOPY Varchar2,
307: p_order_list OUT NOCOPY XDP_TYPES.ORDER_HEADER_LIST,
308: return_code OUT NOCOPY number,
309: error_description OUT NOCOPY varchar2);
310:
311: -- Start of comments
330: -- can specify the search criteria as:
331: --
332: -- declare
333: -- lv_where varchar2(8000);
334: -- lv_list XDP_TYPES.ORDER_LINE_LIST;
335: -- lv_ret number;
336: -- lv_str varchar2(800);
337: -- lv_index number;
338: -- begin
355: -- End of comments
356: PROCEDURE Find_Lines(
357: p_sdp_order_id IN NUMBER,
358: p_where IN OUT NOCOPY Varchar2,
359: p_order_line_list OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
360: return_code OUT NOCOPY number,
361: error_description OUT NOCOPY varchar2);
362:
363: -- Start of comments
383: -- criteria as:
384: --
385: -- declare
386: -- lv_where varchar2(8000);
387: -- lv_list XDP_TYPES.WORKITEM_LIST;
388: -- lv_ret number;
389: -- lv_str varchar2(800);
390: -- lv_index number;
391: -- begin
410: -- End of comments
411: PROCEDURE Find_Workitems(
412: p_sdp_order_id IN NUMBER,
413: p_where IN OUT NOCOPY Varchar2,
414: p_workitem_list OUT NOCOPY XDP_TYPES.Workitem_LIST,
415: return_code OUT NOCOPY number,
416: error_description OUT NOCOPY varchar2);
417:
418: -- Start of comments
430: -- End of comments
431: PROCEDURE Copy_Line(
432: p_src_sdp_order_id IN NUMBER,
433: p_src_line_item_id IN NUMBER,
434: p_copy_mode IN BINARY_INTEGER default XDP_TYPES.APPEND_TO,
435: p_order_line_list IN OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
436: p_line_parameter_list IN OUT NOCOPY XDP_TYPES.LINE_PARAM_LIST,
437: return_code OUT NOCOPY NUMBER,
438: error_description OUT NOCOPY VARCHAR2);
431: PROCEDURE Copy_Line(
432: p_src_sdp_order_id IN NUMBER,
433: p_src_line_item_id IN NUMBER,
434: p_copy_mode IN BINARY_INTEGER default XDP_TYPES.APPEND_TO,
435: p_order_line_list IN OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
436: p_line_parameter_list IN OUT NOCOPY XDP_TYPES.LINE_PARAM_LIST,
437: return_code OUT NOCOPY NUMBER,
438: error_description OUT NOCOPY VARCHAR2);
439:
432: p_src_sdp_order_id IN NUMBER,
433: p_src_line_item_id IN NUMBER,
434: p_copy_mode IN BINARY_INTEGER default XDP_TYPES.APPEND_TO,
435: p_order_line_list IN OUT NOCOPY XDP_TYPES.ORDER_LINE_LIST,
436: p_line_parameter_list IN OUT NOCOPY XDP_TYPES.LINE_PARAM_LIST,
437: return_code OUT NOCOPY NUMBER,
438: error_description OUT NOCOPY VARCHAR2);
439:
440: --