DBA Data[Home] [Help]

APPS.OE_REJECTED_LINES_ACK dependencies on OE_ORDER_PUB

Line 9: ,x_rejected_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

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

Line 10: ,x_rejected_line_val_tbl OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type

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

Line 11: ,x_rejected_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type

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

Line 18: l_line_rec OE_Order_Pub.Line_Rec_Type;

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;

Line 19: l_line_tbl OE_Order_Pub.Line_Tbl_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;

Line 20: l_line_val_rec OE_Order_Pub.Line_Val_Rec_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:

Line 21: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;

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;

Line 22: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;

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;

Line 23: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_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;
27: l_orig_sys_document_ref VARCHAR2(50) := p_orig_sys_document_ref;

Line 471: l_line_rec := OE_Order_Pub.G_MISS_LINE_REC;

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;

Line 472: l_line_tbl := OE_Order_Pub.G_MISS_LINE_TBL;

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;

Line 473: l_line_val_rec := OE_Order_Pub.G_MISS_LINE_VAL_REC;

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:

Line 474: l_line_val_tbl := OE_Order_Pub.G_MISS_LINE_VAL_TBL;

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:

Line 475: l_lot_serial_rec := OE_Order_Pub.G_MISS_LOT_SERIAL_REC;

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

Line 476: l_lot_serial_tbl := OE_Order_Pub.G_MISS_LOT_SERIAL_TBL;

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);