15: G_PKG_NAME VARCHAR2(30) := 'OE_EDI_PVT';
16:
17:
18: PROCEDURE PRE_PROCESS(
19: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
20: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
16:
17:
18: PROCEDURE PRE_PROCESS(
19: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
20: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
17:
18: PROCEDURE PRE_PROCESS(
19: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
20: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
18: PROCEDURE PRE_PROCESS(
19: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
20: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
19: p_header_rec IN OUT NOCOPY OE_Order_Pub.Header_Rec_Type
20: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
20: ,p_header_adj_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
21: ,p_header_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
22: ,p_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
23: ,p_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
31: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
24: ,p_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
31: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
32: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
25: ,p_lot_serial_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Tbl_Type
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
31: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
32: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
33: ,p_return_status OUT NOCOPY VARCHAR2
26: ,p_header_val_rec IN OUT NOCOPY OE_Order_Pub.Header_Val_Rec_Type
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
31: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
32: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
33: ,p_return_status OUT NOCOPY VARCHAR2
34:
27: ,p_header_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Adj_Val_Tbl_Type
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
31: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
32: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
33: ,p_return_status OUT NOCOPY VARCHAR2
34:
35: );
28: ,p_header_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Header_Scredit_Val_Tbl_Type
29: ,p_line_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Val_Tbl_Type
30: ,p_line_adj_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_Val_Tbl_Type
31: ,p_line_scredit_val_tbl IN OUT NOCOPY OE_Order_Pub.Line_Scredit_Val_Tbl_Type
32: ,p_lot_serial_val_tbl IN OUT NOCOPY OE_Order_Pub.Lot_Serial_Val_Tbl_Type
33: ,p_return_status OUT NOCOPY VARCHAR2
34:
35: );
36:
34:
35: );
36:
37: PROCEDURE POST_PROCESS(
38: p_header_rec IN OE_Order_Pub.Header_Rec_Type
39: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
35: );
36:
37: PROCEDURE POST_PROCESS(
38: p_header_rec IN OE_Order_Pub.Header_Rec_Type
39: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
36:
37: PROCEDURE POST_PROCESS(
38: p_header_rec IN OE_Order_Pub.Header_Rec_Type
39: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
37: PROCEDURE POST_PROCESS(
38: p_header_rec IN OE_Order_Pub.Header_Rec_Type
39: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
38: p_header_rec IN OE_Order_Pub.Header_Rec_Type
39: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
39: ,p_header_adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
40: ,p_header_scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type
41: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
42: ,p_line_adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
43: ,p_line_scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
51: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
44: ,p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
51: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
52: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
45:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
51: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
52: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
53:
46: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
51: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
52: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
53:
54: ,p_return_status OUT NOCOPY VARCHAR2
47: ,p_header_adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
51: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
52: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
53:
54: ,p_return_status OUT NOCOPY VARCHAR2
55:
48: ,p_header_scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type
49: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
50: ,p_line_adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type
51: ,p_line_scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type
52: ,p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
53:
54: ,p_return_status OUT NOCOPY VARCHAR2
55:
56: );