1 PACKAGE OE_SYNC_ORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVGNOS.pls 120.1.12010000.1 2008/07/25 08:00:00 appldev ship $ */
3
4 PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type
5 ,p_line_rec IN OE_Order_PUB.Line_Rec_Type
6 ,p_hdr_req_id IN NUMBER DEFAULT NULL
7 ,p_lin_req_id IN NUMBER DEFAULT NULL
8 ,p_change_type IN VARCHAR2 DEFAULT NULL
9 ,p_hold_source_id IN NUMBER DEFAULT NULL
10 ,p_order_hold_id IN NUMBER DEFAULT NULL
11 ,p_hold_release_id IN NUMBER DEFAULT NULL);
12
13 PROCEDURE INSERT_SYNC_LINE(
14 P_LINE_REC OE_Order_PUB.Line_Rec_Type,
15 P_CHANGE_TYPE VARCHAR2,
16 p_req_id NUMBER,
17 X_RETURN_STATUS OUT NOCOPY VARCHAR2
18 );
19
20 PROCEDURE process_order_sync(p_header_id IN NUMBER DEFAULT NULL
21 ,p_hdr_req_id IN NUMBER DEFAULT NULL
22 ,p_line_id IN NUMBER DEFAULT NULL
23 ,p_lin_req_id IN NUMBER DEFAULT NULL
24 ,p_hold_source_id IN NUMBER DEFAULT NULL
25 ,p_order_hold_id IN NUMBER DEFAULT NULL
26 ,p_change_type IN VARCHAR2 DEFAULT NULL
27 ,p_hdr_ack_tbl OUT NOCOPY oe_acknowledgment_pub.header_ack_tbl_type
28 ,p_line_ack_tbl OUT NOCOPY oe_acknowledgment_pub.line_ack_tbl_type
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33
34 PROCEDURE raise_bpel_out_event(p_header_id IN NUMBER DEFAULT NULL
35 ,p_line_id IN NUMBER DEFAULT NULL
36 ,p_hdr_req_id IN NUMBER DEFAULT NULL
37 ,p_lin_req_id IN NUMBER DEFAULT NULL
38 ,p_change_type IN VARCHAR2 DEFAULT NULL
39 ,p_hold_source_id IN NUMBER DEFAULT NULL
40 ,p_order_hold_id IN NUMBER DEFAULT NULL);
41 END OE_SYNC_ORDER_PVT;