APPS.OE_SYNC_ORDER_PVT dependencies on OE_ORDER_PUB

Line 125: P_HEADER_REC OE_Order_PUB.Header_Rec_Type,

121:
122:
123: PROCEDURE INSERT_SYNC_HEADER
124: (
125: P_HEADER_REC OE_Order_PUB.Header_Rec_Type,
126: P_CHANGE_TYPE VARCHAR2,
127: p_req_id NUMBER,
128: X_RETURN_STATUS OUT NOCOPY VARCHAR2
129:

Line 242: p_line_rec oe_order_pub.line_rec_type,

238: END;
239:
240: PROCEDURE INSERT_SYNC_LINE
241: (
242: p_line_rec oe_order_pub.line_rec_type,
243: p_change_type varchar2,
244: p_req_id number,
245: x_return_status out NOCOPY varchar2
246: )

Line 249: l_parent_rec oe_order_pub.line_rec_type;

245: x_return_status out NOCOPY varchar2
246: )
247: IS
248: l_itemkey number;
249: l_parent_rec oe_order_pub.line_rec_type;
250: l_tmp_flow_status_code varchar2(256);
251: l_count number;
252: l_debug_level CONSTANT number := oe_debug_pub.g_debug_level;
253:

Line 493: PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type

489: END IF;
490:
491: END;
492:
493: PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type
494: ,p_line_rec IN OE_Order_PUB.Line_Rec_Type
495: ,p_hdr_req_id IN NUMBER DEFAULT NULL
496: ,p_lin_req_id IN NUMBER DEFAULT NULL
497: ,p_change_type IN VARCHAR2 DEFAULT NULL

Line 494: ,p_line_rec IN OE_Order_PUB.Line_Rec_Type

490:
491: END;
492:
493: PROCEDURE sync_header_line(p_header_rec IN OE_Order_Pub.Header_Rec_Type
494: ,p_line_rec IN OE_Order_PUB.Line_Rec_Type
495: ,p_hdr_req_id IN NUMBER DEFAULT NULL
496: ,p_lin_req_id IN NUMBER DEFAULT NULL
497: ,p_change_type IN VARCHAR2 DEFAULT NULL
498: ,p_hold_source_id IN NUMBER DEFAULT NULL

Line 543: l_line_rec OE_Order_PUB.Line_Rec_Type;

539: AND osrc.aia_enabled_flag = 'Y'
540: AND ooh.order_hold_id = p_order_hold_id;
541:
542:
543: l_line_rec OE_Order_PUB.Line_Rec_Type;
544: l_header_rec OE_Order_PUB.Header_Rec_Type;
545: l_prev_header_id NUMBER;
546:
547: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 544: l_header_rec OE_Order_PUB.Header_Rec_Type;

540: AND ooh.order_hold_id = p_order_hold_id;
541:
542:
543: l_line_rec OE_Order_PUB.Line_Rec_Type;
544: l_header_rec OE_Order_PUB.Header_Rec_Type;
545: l_prev_header_id NUMBER;
546:
547: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
548: l_itemkey number;