21: Procedure: Pre_Process
22: -----------------------------------------------------------
23: */
24: PROCEDURE Pre_Process(
25: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
26: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
22: -----------------------------------------------------------
23: */
24: PROCEDURE Pre_Process(
25: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
26: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
23: */
24: PROCEDURE Pre_Process(
25: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
26: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
24: PROCEDURE Pre_Process(
25: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
26: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
25: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
26: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
26: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
27: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
28: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
29: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
37: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
30: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
37: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
38: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
31: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
37: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
38: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
39: ,p_return_status OUT NOCOPY VARCHAR2
32: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
37: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
38: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
39: ,p_return_status OUT NOCOPY VARCHAR2
40:
33: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
37: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
38: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
39: ,p_return_status OUT NOCOPY VARCHAR2
40:
41: ) IS
34: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
35: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
36: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
37: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
38: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
39: ,p_return_status OUT NOCOPY VARCHAR2
40:
41: ) IS
42: l_header_rec OE_Order_Pub.Header_Rec_Type;
38: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
39: ,p_return_status OUT NOCOPY VARCHAR2
40:
41: ) IS
42: l_header_rec OE_Order_Pub.Header_Rec_Type;
43: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
39: ,p_return_status OUT NOCOPY VARCHAR2
40:
41: ) IS
42: l_header_rec OE_Order_Pub.Header_Rec_Type;
43: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
40:
41: ) IS
42: l_header_rec OE_Order_Pub.Header_Rec_Type;
43: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
41: ) IS
42: l_header_rec OE_Order_Pub.Header_Rec_Type;
43: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
42: l_header_rec OE_Order_Pub.Header_Rec_Type;
43: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
43: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
44: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
45: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
46: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
47: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
55: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
48: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
55: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
56: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
49:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
55: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
56: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
57:
50: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
55: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
56: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
57:
58: l_line_exists VARCHAR2(1);
51: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
55: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
56: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
57:
58: l_line_exists VARCHAR2(1);
59: l_change_sequence VARCHAR2(50);
52: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
53: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
54: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
55: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
56: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
57:
58: l_line_exists VARCHAR2(1);
59: l_change_sequence VARCHAR2(50);
60: l_orig_sys_line_ref VARCHAR2(50);
480: Procedure: Post_Process
481: -----------------------------------------------------------
482: */
483: PROCEDURE Post_Process(
484: p_header_rec IN OE_Order_Pub.Header_Rec_Type
485: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
481: -----------------------------------------------------------
482: */
483: PROCEDURE Post_Process(
484: p_header_rec IN OE_Order_Pub.Header_Rec_Type
485: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
482: */
483: PROCEDURE Post_Process(
484: p_header_rec IN OE_Order_Pub.Header_Rec_Type
485: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
483: PROCEDURE Post_Process(
484: p_header_rec IN OE_Order_Pub.Header_Rec_Type
485: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
484: p_header_rec IN OE_Order_Pub.Header_Rec_Type
485: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
485: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
486: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
487: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
488: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
489: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
497: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
490: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
497: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
498: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
491:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
497: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
498: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
499:
492: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
497: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
498: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
499:
500: ,p_return_status OUT NOCOPY VARCHAR2
493: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
497: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
498: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
499:
500: ,p_return_status OUT NOCOPY VARCHAR2
501:
494: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
495: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
496: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
497: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
498: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
499:
500: ,p_return_status OUT NOCOPY VARCHAR2
501:
502: ) IS
499:
500: ,p_return_status OUT NOCOPY VARCHAR2
501:
502: ) IS
503: l_header_rec OE_Order_Pub.Header_Rec_Type;
504: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
500: ,p_return_status OUT NOCOPY VARCHAR2
501:
502: ) IS
503: l_header_rec OE_Order_Pub.Header_Rec_Type;
504: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
501:
502: ) IS
503: l_header_rec OE_Order_Pub.Header_Rec_Type;
504: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
502: ) IS
503: l_header_rec OE_Order_Pub.Header_Rec_Type;
504: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
503: l_header_rec OE_Order_Pub.Header_Rec_Type;
504: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
504: l_header_adj_tbl OE_Order_Pub.Header_Adj_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
505: l_header_scredit_tbl OE_Order_Pub.Header_Scredit_Tbl_Type;
506: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
507: l_line_adj_tbl OE_Order_Pub.Line_Adj_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
508: l_line_scredit_tbl OE_Order_Pub.Line_Scredit_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
516: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
509: l_lot_serial_tbl OE_Order_Pub.Lot_Serial_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
516: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
517: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
510:
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
516: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
517: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
518: BEGIN
511: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
516: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
517: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
518: BEGIN
519:
512: l_header_adj_val_tbl OE_Order_Pub.Header_Adj_Val_Tbl_Type;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
516: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
517: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
518: BEGIN
519:
520: l_header_rec := p_header_rec;
513: l_header_scredit_val_tbl OE_Order_Pub.Header_Scredit_Val_Tbl_Type;
514: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
515: l_line_adj_val_tbl OE_Order_Pub.Line_Adj_Val_Tbl_Type;
516: l_line_scredit_val_tbl OE_Order_Pub.Line_Scredit_Val_Tbl_Type;
517: l_lot_serial_val_tbl OE_Order_Pub.Lot_Serial_Val_Tbl_Type;
518: BEGIN
519:
520: l_header_rec := p_header_rec;
521: l_header_adj_tbl := p_header_adj_tbl;