DBA Data[Home] [Help]

APPS.OE_SET_UTIL dependencies on OE_ORDER_PUB

Line 4: g_delivery_set_rec OE_ORDER_PUB.set_rec_type;

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;

Line 5: g_invoice_set_rec OE_ORDER_PUB.set_rec_type;

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;

Line 6: g_ship_set_rec OE_ORDER_PUB.set_rec_type;

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;

Line 7: g_fullfillment_set_rec OE_ORDER_PUB.set_rec_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;

Line 10: G_Set_Request_Tbl OE_ORDER_PUB.Request_Tbl_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;
12:
13: --Bug 4080531
14: g_set_rec OE_ORDER_CACHE.set_rec_type;

Line 72: p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.line_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

Line 73: p_old_line_rec IN OE_ORDER_PUB.line_rec_type,

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

Line 125: (p_Set_request_tbl oe_order_pub.Request_Tbl_Type,

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,

Line 204: x_line_tbl OUT NOCOPY OE_Order_PUB.Line_Tbl_Type);

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:

Line 207: Procedure Create_line_Set(p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.LINE_REC_TYPE);

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

Line 212: Procedure Process_Sets(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.LINE_TBL_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
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:

Line 225: oe_order_pub.line_rec_type,

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,

Line 226: p_old_line_rec IN oe_order_pub.line_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);

Line 229: Procedure Delete_Set(p_request_rec IN OE_ORDER_PUB.request_rec_type,

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,