1 PACKAGE IBE_Order_Save_pvt AUTHID CURRENT_USER AS
2 /* $Header: IBEVORDS.pls 120.1 2005/09/09 02:40:36 appldev ship $ */
3
4 -- Different SaveTypes to identify the flow.
5 SAVE_ADDITEMS NUMBER := 0;
6 SAVE_NORMAL NUMBER := 1;
7 SAVE_REMOVEITEMS NUMBER := 2;
8 CHECK_CONSTRAINTS NUMBER := 3;
9
10 TYPE x_qtyfail_LineType IS TABLE OF VARCHAR2(240)
11 INDEX BY BINARY_INTEGER;
12
13
14 PROCEDURE Save(
15 p_api_version_number IN NUMBER := 1
16 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
17 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
18 ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC
19 ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL
20 ,p_submit_control_rec IN IBE_Order_W1_PVT.Control_Rec_Type := IBE_Order_W1_PVT.G_MISS_Control_Rec
21 ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
22 ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
23 ,p_shipto_partysite_id IN NUMBER := FND_API.G_MISS_NUM
24 ,p_billto_partysite_id IN NUMBER := FND_API.G_MISS_NUM
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_msg_count OUT NOCOPY NUMBER
27 ,x_msg_data OUT NOCOPY VARCHAR2
28 ,x_order_header_id OUT NOCOPY NUMBER
29 ,x_order_number OUT NOCOPY NUMBER
30 ,x_flow_status_code OUT NOCOPY VARCHAR2
31 ,x_last_update_date OUT NOCOPY DATE
32 ,X_failed_line_ids OUT NOCOPY JTF_VARCHAR2_TABLE_300 --3272918
33 );
34
35 PROCEDURE CheckConstraint(
36 p_api_version_number IN NUMBER := 1
37 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
38 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
39 ,p_order_header_rec IN OE_Order_PUB.Header_Rec_Type := OE_Order_PUB.G_MISS_HEADER_REC
40 ,p_order_line_tbl IN OE_Order_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL
41 ,p_submit_control_rec IN IBE_Order_W1_PVT.Control_Rec_Type := IBE_Order_W1_PVT.G_MISS_Control_Rec
42 ,p_combine_same_lines IN VARCHAR2 := FND_API.G_MISS_CHAR
43 ,p_party_id IN NUMBER
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 ,x_error_lineids OUT NOCOPY JTF_VARCHAR2_TABLE_300
48 ,x_last_update_date OUT NOCOPY DATE
49 );
50
51
52 PROCEDURE UpdateLineShippingBilling(
53 p_api_version_number IN NUMBER := 1
54 ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
55 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
56 ,x_return_status OUT NOCOPY VARCHAR2
57 ,x_msg_count OUT NOCOPY NUMBER
58 ,x_msg_data OUT NOCOPY VARCHAR2
59 ,p_order_header_id IN NUMBER := FND_API.G_MISS_NUM
60 ,p_order_line_id IN NUMBER := FND_API.G_MISS_NUM
61 ,p_billto_party_id IN NUMBER := FND_API.G_MISS_NUM
62 ,p_billto_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM
63 ,p_billto_party_site_id IN NUMBER := FND_API.G_MISS_NUM
64 ,p_shipto_party_id IN NUMBER := FND_API.G_MISS_NUM
65 ,p_shipto_cust_acct_id IN NUMBER := FND_API.G_MISS_NUM
66 ,p_shipto_party_site_id IN NUMBER := FND_API.G_MISS_NUM
67 ,p_last_update_date IN DATE
68 );
69
70
71 PROCEDURE Retrieve_OE_Messages;
72
73 END IBE_Order_Save_pvt;