1: PACKAGE OE_Set_Util AUTHID CURRENT_USER AS
2: /* $Header: OEXUSETS.pls 120.5.12020000.1 2012/06/26 09:47:35 appldev ship $ */
3:
4: g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
1: PACKAGE OE_Set_Util AUTHID CURRENT_USER AS
2: /* $Header: OEXUSETS.pls 120.5.12020000.1 2012/06/26 09:47:35 appldev ship $ */
3:
4: g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
2: /* $Header: OEXUSETS.pls 120.5.12020000.1 2012/06/26 09:47:35 appldev ship $ */
3:
4: g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
10: G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
3:
4: g_delivery_set_rec OE_ORDER_PUB.set_rec_type;
5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
10: G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
11: G_Set_Recursive_Flag BOOLEAN := FALSE;
6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;
7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_type;
8: G_Create_Ship_set VARCHAR2(30) := FND_API.G_FALSE;
9: G_Create_Arrival_set VARCHAR2(30) := FND_API.G_FALSE;
10: G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_Type;
11: G_Set_Recursive_Flag BOOLEAN := FALSE;
12:
13: --Bug 4080531
14: g_set_rec OE_ORDER_CACHE.set_rec_type;
68: -- to figure out if there are any set requests and populate the
69: -- global tables that get accessed in post lines process
70:
71: PROCEDURE get_set_id(
72: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
73: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
74: p_Index IN NUmber);
75:
76: -- This Procedure is designed to be called from form controller for a
69: -- global tables that get accessed in post lines process
70:
71: PROCEDURE get_set_id(
72: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_rec_type,
73: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,
74: p_Index IN NUmber);
75:
76: -- This Procedure is designed to be called from form controller for a
77: -- multiselect case and user using the right mouse click button to do
121: -- User chooses to default the preference of set from the header rec
122: -- This dependes on the customer preference set code
123:
124: Procedure Insert_Into_Set
125: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,
126: p_Push_Set_Date IN VARCHAR2 := FND_API.G_FALSE,
127: X_Return_Status OUT NOCOPY VARCHAR2,
128:
129: x_msg_count OUT NOCOPY NUMBER,
200:
201: -- To query all the lines in the set
202:
203: PROCEDURE Query_Set_Rows(p_set_id IN NUMBER,
204: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);
205:
206: -- To create a line set
207: Procedure Create_line_Set(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE);
208:
203: PROCEDURE Query_Set_Rows(p_set_id IN NUMBER,
204: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);
205:
206: -- To create a line set
207: Procedure Create_line_Set(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE);
208:
209: -- To process the sets from the global table populated by get set id api
210: -- this is called from post line process and get executed when the proces is
211: -- set to true
208:
209: -- To process the sets from the global table populated by get set id api
210: -- this is called from post line process and get executed when the proces is
211: -- set to true
212: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_TYPE);
213:
214: -- To remove from fullifllment set
215: Procedure Remove_from_fulfillment(p_line_id NUMBER);
216:
221: p_set_id NUMBER);
222:
223: -- Add new procedure Default line set for set and scheduling revamping
224: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY
225: oe_order_pub.line_rec_type,
226: p_old_line_rec IN oe_order_pub.line_rec_type);
227: -- 4026756
228: -- To delete set
229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
222:
223: -- Add new procedure Default line set for set and scheduling revamping
224: Procedure Default_Line_Set(p_x_line_rec IN OUT NOCOPY
225: oe_order_pub.line_rec_type,
226: p_old_line_rec IN oe_order_pub.line_rec_type);
227: -- 4026756
228: -- To delete set
229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
230: x_return_status OUT NOCOPY VARCHAR2);
225: oe_order_pub.line_rec_type,
226: p_old_line_rec IN oe_order_pub.line_rec_type);
227: -- 4026756
228: -- To delete set
229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,
230: x_return_status OUT NOCOPY VARCHAR2);
231:
232: --Standalone
233: FUNCTION Stand_Alone_set_exists (p_ship_set_id IN NUMBER,