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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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:
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: