PACKAGE: APPS.OE_ORDER_IMPORT_UTIL_PVT

Source

1 PACKAGE OE_ORDER_IMPORT_UTIL_PVT AS
2 /* $Header: OEXVIMUS.pls 120.1 2005/08/05 15:29:24 sphatarp noship $ */
3 
4 --  Start of Comments
5 --  API name    Order Import Utilities
6 --  Type        Private
7 --  Function
8 --  Pre-reqs
9 --  Parameters
10 --  Version     Current version = 1.0
11 --              Initial version = 1.0
12 --  Notes
13 --  End of Comments
14 
15 G_PKG_NAME         VARCHAR2(30) := 'OE_ORDER_IMPORT_UTIL_PVT';
16 
17 PROCEDURE Delete_Order(
18    p_request_id			IN  NUMBER
19   ,p_order_source_id     	IN  NUMBER
20   ,p_orig_sys_document_ref     	IN  VARCHAR2
21   ,p_sold_to_org_id             IN  NUMBER   := NULL
22   ,p_sold_to_org                IN  VARCHAR2 := NULL
23   ,p_change_sequence		IN  VARCHAR2 := NULL
24   ,p_return_status OUT NOCOPY VARCHAR2
25 
26 );
27 
28 PROCEDURE Delete_Messages(
29    p_request_id     		IN  NUMBER
30   ,p_order_source_id     	IN  NUMBER
31   ,p_orig_sys_document_ref 	IN  VARCHAR2
32   ,p_sold_to_org_id             IN  NUMBER   := NULL
33   ,p_sold_to_org             IN  VARCHAR2   := NULL
34   ,p_change_sequence 		IN  VARCHAR2 := NULL
35   ,p_org_id                     IN  VARCHAR2 := Null
36   ,p_return_status OUT NOCOPY VARCHAR2
37 
38 );
39 
40 FUNCTION Get_Line_Index(
41    p_line_tbl			IN OE_Order_Pub.Line_Tbl_Type
42   ,p_orig_sys_line_ref 		IN VARCHAR2
43   ,p_orig_sys_shipment_ref	IN VARCHAR2
44 )
45 RETURN NUMBER;
46 
47 
48 END OE_ORDER_IMPORT_UTIL_PVT;