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 418: l_line_tbl OE_ORDER_PUB.Line_TBL_Type;

414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2
416: )
417: IS
418: l_line_tbl OE_ORDER_PUB.Line_TBL_Type;
419: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;
420: l_msg_count NUMBER;
421: l_msg_data VARCHAR2(2000);
422: l_check_hold_result VARCHAR2(30);

Line 419: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;

415: ,x_msg_data OUT NOCOPY VARCHAR2
416: )
417: IS
418: l_line_tbl OE_ORDER_PUB.Line_TBL_Type;
419: l_old_line_tbl OE_ORDER_PUB.Line_TBL_Type;
420: l_msg_count NUMBER;
421: l_msg_data VARCHAR2(2000);
422: l_check_hold_result VARCHAR2(30);
423: on_hold_error EXCEPTION;

Line 427: l_header_rec OE_Order_PUB.Header_Rec_Type;

423: on_hold_error EXCEPTION;
424: l_notify_index NUMBER; -- jolin
425: -- GENESIS --
426: l_itemkey_sso NUMBER;
427: l_header_rec OE_Order_PUB.Header_Rec_Type;
428: l_return_status_gen VARCHAR2(30);
429: -- GENESIS --
430: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
431: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

Line 435: l_line_rec OE_ORDER_PUB.Line_rec_type;

431: l_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
432: l_org_id oe_order_lines_all.org_id%TYPE;
433: /* Customer Acceptance */
434: l_pending_acceptance VARCHAR2(1) := 'N';
435: l_line_rec OE_ORDER_PUB.Line_rec_type;
436: --
437: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
438: --
439: BEGIN