5: p_request_id IN NUMBER
6: ,p_order_source_id IN NUMBER
7: ,p_orig_sys_document_ref IN VARCHAR2
8: ,p_change_sequence IN VARCHAR2
9: ,x_rejected_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
10: ,x_rejected_line_val_tbl OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
11: ,x_rejected_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,p_header_id IN NUMBER
6: ,p_order_source_id IN NUMBER
7: ,p_orig_sys_document_ref IN VARCHAR2
8: ,p_change_sequence IN VARCHAR2
9: ,x_rejected_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
10: ,x_rejected_line_val_tbl OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
11: ,x_rejected_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,p_header_id IN NUMBER
14: ,p_sold_to_org IN VARCHAR2
7: ,p_orig_sys_document_ref IN VARCHAR2
8: ,p_change_sequence IN VARCHAR2
9: ,x_rejected_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
10: ,x_rejected_line_val_tbl OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
11: ,x_rejected_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
12: ,x_return_status OUT NOCOPY VARCHAR2
13: ,p_header_id IN NUMBER
14: ,p_sold_to_org IN VARCHAR2
15: ,p_sold_to_org_id IN NUMBER
14: ,p_sold_to_org IN VARCHAR2
15: ,p_sold_to_org_id IN NUMBER
16: ) is
17:
18: l_line_rec OE_Order_Pub.Line_Rec_Type;
19: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
15: ,p_sold_to_org_id IN NUMBER
16: ) is
17:
18: l_line_rec OE_Order_Pub.Line_Rec_Type;
19: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
23: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
16: ) is
17:
18: l_line_rec OE_Order_Pub.Line_Rec_Type;
19: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
23: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
24:
17:
18: l_line_rec OE_Order_Pub.Line_Rec_Type;
19: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
23: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
24:
25: l_request_id NUMBER := p_request_id;
18: l_line_rec OE_Order_Pub.Line_Rec_Type;
19: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
23: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
24:
25: l_request_id NUMBER := p_request_id;
26: l_order_source_id NUMBER := p_order_source_id;
19: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_Type;
21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
23: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
24:
25: l_request_id NUMBER := p_request_id;
26: l_order_source_id NUMBER := p_order_source_id;
27: l_orig_sys_document_ref VARCHAR2(50) := p_orig_sys_document_ref;
467: IF l_debug_level > 0 THEN
468: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;
469: END IF;
470:
471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;
473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;
474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;
475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;
468: oe_debug_pub.add( 'BEFORE INITIALIZATION' ) ;
469: END IF;
470:
471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;
473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;
474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;
475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;
476: l_lot_serial_tbl := OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
469: END IF;
470:
471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;
473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;
474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;
475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;
476: l_lot_serial_tbl := OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
477:
470:
471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;
473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;
474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;
475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;
476: l_lot_serial_tbl := OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
477:
478:
471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;
473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;
474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;
475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;
476: l_lot_serial_tbl := OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
477:
478:
479: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;
473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;
474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;
475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;
476: l_lot_serial_tbl := OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;
477:
478:
479: If OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' Then
480: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);