DBA Data[Home] [Help]

APPS.OE_SYNC_ORDER_PVT dependencies on OE_ORDER_PUB

Line 106: P_HEADER_REC OE_Order_PUB.Header_Rec_Type,

102:
103:
104: PROCEDURE INSERT_SYNC_HEADER
105: (
106: P_HEADER_REC OE_Order_PUB.Header_Rec_Type,
107: P_CHANGE_TYPE VARCHAR2,
108: p_req_id NUMBER,
109: X_RETURN_STATUS OUT NOCOPY VARCHAR2
110:

Line 215: p_line_rec oe_order_pub.line_rec_type,

211: END;
212:
213: PROCEDURE INSERT_SYNC_LINE
214: (
215: p_line_rec oe_order_pub.line_rec_type,
216: p_change_type varchar2,
217: p_req_id number,
218: x_return_status out NOCOPY varchar2
219: )

Line 222: l_parent_rec oe_order_pub.line_rec_type;

218: x_return_status out NOCOPY varchar2
219: )
220: IS
221: l_itemkey number;
222: l_parent_rec oe_order_pub.line_rec_type;
223: l_tmp_flow_status_code varchar2(256);
224: l_count number;
225: l_debug_level CONSTANT number := oe_debug_pub.g_debug_level;
226:

Line 434: PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type

430: END IF;
431:
432: END;
433:
434: PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type
435: ,p_line_rec IN OE_Order_PUB.Line_Rec_Type
436: ,p_hdr_req_id IN NUMBER DEFAULT NULL
437: ,p_lin_req_id IN NUMBER DEFAULT NULL
438: ,p_change_type IN VARCHAR2 DEFAULT NULL

Line 435: ,p_line_rec IN OE_Order_PUB.Line_Rec_Type

431:
432: END;
433:
434: PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type
435: ,p_line_rec IN OE_Order_PUB.Line_Rec_Type
436: ,p_hdr_req_id IN NUMBER DEFAULT NULL
437: ,p_lin_req_id IN NUMBER DEFAULT NULL
438: ,p_change_type IN VARCHAR2 DEFAULT NULL
439: ,p_hold_source_id IN NUMBER DEFAULT NULL

Line 478: l_line_rec OE_Order_PUB.Line_Rec_Type;

474: AND h.order_source_id = 28
475: AND ooh.order_hold_id = p_order_hold_id;
476:
477:
478: l_line_rec OE_Order_PUB.Line_Rec_Type;
479: l_header_rec OE_Order_PUB.Header_Rec_Type;
480: l_prev_header_id NUMBER;
481:
482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 479: l_header_rec OE_Order_PUB.Header_Rec_Type;

475: AND ooh.order_hold_id = p_order_hold_id;
476:
477:
478: l_line_rec OE_Order_PUB.Line_Rec_Type;
479: l_header_rec OE_Order_PUB.Header_Rec_Type;
480: l_prev_header_id NUMBER;
481:
482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
483: l_itemkey number;