38: PROCEDURE Process_Acknowledgment
39: (p_api_version_number IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
39: (p_api_version_number IN NUMBER
40: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
40: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
41:
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
42: ,p_header_rec IN OE_Order_Pub.Header_Rec_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
43: OE_Order_Pub.G_MISS_HEADER_REC
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
44: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
45: OE_Order_Pub.G_MISS_HEADER_VAL_REC
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
46: ,p_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
47: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
48: ,p_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
49: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
50: ,p_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
51: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
52: ,p_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
53: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
54: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
55: OE_Order_Pub.G_MISS_LINE_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
56: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
57: OE_Order_Pub.G_MISS_LINE_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
58: ,p_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
59: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
60: ,p_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
61: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
62: ,p_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
63: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
64: ,p_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
65: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
66: ,p_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
67: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
68: ,p_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
69: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
70: ,p_action_request_tbl IN OE_Order_Pub.Request_Tbl_Type :=
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
71: OE_Order_Pub.G_MISS_REQUEST_TBL
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
72:
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
73: ,p_old_header_rec IN OE_Order_Pub.Header_Rec_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
74: OE_Order_Pub.G_MISS_HEADER_REC
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
75: ,p_old_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
76: OE_Order_Pub.G_MISS_HEADER_VAL_REC
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
77: ,p_old_Header_Adj_tbl IN OE_Order_Pub.Header_Adj_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
78: OE_Order_Pub.G_MISS_HEADER_ADJ_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
79: ,p_old_Header_Adj_val_tbl IN OE_Order_Pub.Header_Adj_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
80: OE_Order_Pub.G_MISS_HEADER_ADJ_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
81: ,p_old_Header_Scredit_tbl IN OE_Order_Pub.Header_Scredit_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
82: OE_Order_Pub.G_MISS_HEADER_SCREDIT_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
83: ,p_old_Header_Scredit_val_tbl IN OE_Order_Pub.Header_Scredit_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
84: OE_Order_Pub.G_MISS_HEADER_SCREDIT_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
85: ,p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
86: OE_Order_Pub.G_MISS_LINE_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
87: ,p_old_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
88: OE_Order_Pub.G_MISS_LINE_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
89: ,p_old_Line_Adj_tbl IN OE_Order_Pub.Line_Adj_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
90: OE_Order_Pub.G_MISS_LINE_ADJ_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
91: ,p_old_Line_Adj_val_tbl IN OE_Order_Pub.Line_Adj_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
92: OE_Order_Pub.G_MISS_LINE_ADJ_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
93: ,p_old_Line_Scredit_tbl IN OE_Order_Pub.Line_Scredit_Tbl_Type :=
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
94: OE_Order_Pub.G_MISS_LINE_SCREDIT_TBL
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
102: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
95: ,p_old_Line_Scredit_val_tbl IN OE_Order_Pub.Line_Scredit_Val_Tbl_Type :=
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
102: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
103: ,p_reject_order IN VARCHAR2 DEFAULT 'N'
96: OE_Order_Pub.G_MISS_LINE_SCREDIT_VAL_TBL
97: ,p_old_Lot_Serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type :=
98: OE_Order_Pub.G_MISS_LOT_SERIAL_TBL
99: ,p_old_Lot_Serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type :=
100: OE_Order_Pub.G_MISS_LOT_SERIAL_VAL_TBL
101:
102: ,p_buyer_seller_flag IN VARCHAR2 DEFAULT 'B'
103: ,p_reject_order IN VARCHAR2 DEFAULT 'N'
104:
112: p_change_sequence IN Varchar2 := NULL,
113: p_msg_id IN Number := NULL,
114: p_request_id IN Number := Null,
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
113: p_msg_id IN Number := NULL,
114: p_request_id IN Number := Null,
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
121:
114: p_request_id IN Number := Null,
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
121:
122: PROCEDURE Process_Xml_Acknowledgment
115: p_xml_transaction_type_code IN Varchar2 := NULL,
116: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Rec_Type,
117: x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Header_Val_Rec_Type,
118: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Tbl_Type,
119: x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_Pub.Line_Val_Tbl_Type
120: );
121:
122: PROCEDURE Process_Xml_Acknowledgment
123: ( p_api_version_number IN NUMBER := 1,
138:
139: PROCEDURE Process_SSO
140: ( p_api_version_number IN NUMBER := 1,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139: PROCEDURE Process_SSO
140: ( p_api_version_number IN NUMBER := 1,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147: );
140: ( p_api_version_number IN NUMBER := 1,
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147: );
148:
141: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
142: p_header_rec IN OE_Order_Pub.Header_Rec_Type,
143: p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
144: p_old_header_rec IN OE_Order_Pub.Header_Rec_Type,
145: p_old_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
146: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
147: );
148:
149: Procedure Raise_Event_Showso
262: , x_return_status OUT NOCOPY VARCHAR2
263: );
264:
265: Procedure Process_3A8
266: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
267: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
268: , x_return_status OUT NOCOPY VARCHAR2
269: );
270:
263: );
264:
265: Procedure Process_3A8
266: ( p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
267: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
268: , x_return_status OUT NOCOPY VARCHAR2
269: );
270:
271: Function EM_Transaction_Type
273: ) RETURN VARCHAR2;
274:
275: --SUN OIP ER
276: FUNCTION Get_Line_Index
277: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type,
278: p_line_id IN Number
279: )
280: RETURN NUMBER;
281: --End of SUN OIP ER