APPS.OE_ORDER_CLOSE_UTIL dependencies on OE_ORDER_PUB

Line 138: l_header_rec OE_ORDER_PUB.Header_Rec_Type;

134: ,x_msg_data OUT NOCOPY VARCHAR2
135:
136: )
137: IS
138: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
139: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
140: l_msg_count NUMBER;
141: l_msg_data VARCHAR2(2000);
142: l_check_hold_result VARCHAR2(30);

Line 139: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;

135:
136: )
137: IS
138: l_header_rec OE_ORDER_PUB.Header_Rec_Type;
139: l_old_header_rec OE_ORDER_PUB.Header_Rec_Type;
140: l_msg_count NUMBER;
141: l_msg_data VARCHAR2(2000);
142: l_check_hold_result VARCHAR2(30);
143: on_hold_error EXCEPTION;

Line 408: l_line_tbl OE_ORDER_PUB.Line_TBL_Type;

404: ,x_msg_count OUT NOCOPY NUMBER
405: ,x_msg_data OUT NOCOPY VARCHAR2
406: )
407: IS
408: l_line_tbl OE_ORDER_PUB.Line_TBL_Type;
409: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;
410: l_msg_count NUMBER;
411: l_msg_data VARCHAR2(2000);
412: l_check_hold_result VARCHAR2(30);

Line 409: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;

405: ,x_msg_data OUT NOCOPY VARCHAR2
406: )
407: IS
408: l_line_tbl OE_ORDER_PUB.Line_TBL_Type;
409: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;
410: l_msg_count NUMBER;
411: l_msg_data VARCHAR2(2000);
412: l_check_hold_result VARCHAR2(30);
413: on_hold_error EXCEPTION;

Line 417: l_header_rec OE_Order_PUB.Header_Rec_Type;

413: on_hold_error EXCEPTION;
414: l_notify_index NUMBER; -- jolin
415: -- GENESIS --
416: l_itemkey_sso NUMBER;
417: l_header_rec OE_Order_PUB.Header_Rec_Type;
418: l_return_status_gen VARCHAR2(30);
419: -- GENESIS --
420: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
421: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

Line 425: l_line_rec OE_ORDER_PUB.Line_rec_type;

421: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
422: l_org_id oe_order_lines_all.org_id%TYPE;
423: /* Customer Acceptance */
424: l_pending_acceptance VARCHAR2(1) := 'N';
425: l_line_rec OE_ORDER_PUB.Line_rec_type;
426: --
427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
428: --
429: BEGIN