eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_MAP_QUOTE_ORDER_INT dependencies on OE_ORDER_PUB

Line 64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type

60: := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type

Line 65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type

61: P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type

Line 66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type

62: := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

Line 67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type

63: P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type

Line 68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type

64: , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type

Line 69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type

65: , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type

Line 70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

66: , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type

Line 71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type

67: , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type

Line 72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type

68: , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type

Line 73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type

69: , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type

Line 74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type

70: , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type

Line 75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type

71: , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type

Line 76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type

72: , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

Line 77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type

73: , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type

Line 78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type

74: , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type

Line 79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type

75: , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type

Line 80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

76: , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type

Line 81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type

77: , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
85: , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type

Line 82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type

78: , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
85: , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
86: )

Line 83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type

79: , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
85: , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
86: )
87: IS

Line 84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type

80: , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
85: , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
86: )
87: IS
88:

Line 85: , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type

81: , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82: , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83: , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84: , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
85: , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
86: )
87: IS
88:
89: CURSOR c_functional_currency (X_set_of_books_id NUMBER) IS

Line 138: l_header_rec OE_Order_PUB.Header_Rec_Type;

134: l_api_version_number CONSTANT NUMBER := 1.0;
135: l_api_name CONSTANT VARCHAR2(30):= 'MAP_QUOTE_TO_Order';
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_return_status VARCHAR2(1);
138: l_header_rec OE_Order_PUB.Header_Rec_Type;
139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

Line 139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

135: l_api_name CONSTANT VARCHAR2(30):= 'MAP_QUOTE_TO_Order';
136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_return_status VARCHAR2(1);
138: l_header_rec OE_Order_PUB.Header_Rec_Type;
139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

136: l_control_rec OE_GLOBALS.Control_Rec_Type;
137: l_return_status VARCHAR2(1);
138: l_header_rec OE_Order_PUB.Header_Rec_Type;
139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

Line 141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

137: l_return_status VARCHAR2(1);
138: l_header_rec OE_Order_PUB.Header_Rec_Type;
139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

138: l_header_rec OE_Order_PUB.Header_Rec_Type;
139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

Line 143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

139: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

Line 144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

140: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

Line 145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

141: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

142: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

143: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
151: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

144: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
151: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
152:

Line 149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

145: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
151: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
152:
153:

Line 150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

146: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
151: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
152:
153:
154: -- declaration for line and header level value record types

Line 151: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

147: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
148: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
149: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
150: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
151: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
152:
153:
154: -- declaration for line and header level value record types
155: l_return_values varchar2(50);

Line 156: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

152:
153:
154: -- declaration for line and header level value record types
155: l_return_values varchar2(50);
156: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
157: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

Line 157: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

153:
154: -- declaration for line and header level value record types
155: l_return_values varchar2(50);
156: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
157: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change

Line 158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

154: -- declaration for line and header level value record types
155: l_return_values varchar2(50);
156: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
157: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

155: l_return_values varchar2(50);
156: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
157: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

156: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
157: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
164: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

Line 162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

158: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
164: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
166: l_msg_count number;

Line 163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
164: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
166: l_msg_count number;
167: l_msg_data varchar2(2000);

Line 164: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

160: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
164: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
166: l_msg_count number;
167: l_msg_data varchar2(2000);
168: l_invoice_cust_account_id number;

Line 165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

161: --Line Payments change
162: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
163: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
164: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
166: l_msg_count number;
167: l_msg_data varchar2(2000);
168: l_invoice_cust_account_id number;
169: l_ship_cust_account_id number;

Line 247: l_Header_Payment_Tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

243: l_ln_end_cust_acct_site NUMBER;
244:
245: l_Line_Price_Adj_rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
246:
247: l_Header_Payment_Tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;
248:
249: pay_count NUMBER := 1;
250:
251: CURSOR salesrep( p_resource_id NUMBER) IS

Line 3071: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type

3067: PROCEDURE map_header_price_attr(
3068: p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3069: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3070: p_operation IN VARCHAR2,
3071: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
3072: )
3073: IS
3074: i NUMBER;
3075: p_att_count NUMBER := 1;

Line 3076: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3072: )
3073: IS
3074: i NUMBER;
3075: p_att_count NUMBER := 1;
3076: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3077: BEGIN
3078: FOR i in 1..p_header_price_attributes_tbl.count LOOP
3079: l_header_price_att_tbl(p_att_count).pricing_context
3080: := p_header_price_attributes_tbl(i).pricing_context;

Line 3342: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type

3338: PROCEDURE map_header_price_adj(
3339: p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3340: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3341: p_operation IN VARCHAR2 ,
3342: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
3343: )
3344: IS
3345: i NUMBER;
3346: adj_count NUMBER :=1;

Line 3347: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type

3343: )
3344: IS
3345: i NUMBER;
3346: adj_count NUMBER :=1;
3347: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type
3348: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL;
3349: BEGIN
3350:
3351: FOR i in 1..p_header_price_adj_tbl.count LOOP

Line 3348: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL;

3344: IS
3345: i NUMBER;
3346: adj_count NUMBER :=1;
3347: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type
3348: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL;
3349: BEGIN
3350:
3351: FOR i in 1..p_header_price_adj_tbl.count LOOP
3352: l_header_adj_tbl(adj_count).attribute1

Line 3507: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type

3503:
3504: PROCEDURE map_header_price_adj_attr(
3505: p_header_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
3506: p_operation IN VARCHAR2,
3507: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
3508: )
3509: IS
3510:
3511: j NUMBER;

Line 3513: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3509: IS
3510:
3511: j NUMBER;
3512: attr_count NUMBER := 1;
3513: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3514:
3515: BEGIN
3516:
3517: FOR j in 1..p_header_price_adj_attr_tbl.count LOOP

Line 3562: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

3558:
3559: PROCEDURE map_header_price_adj_rltn(
3560: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
3561: P_operation IN VARCHAR2,
3562: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
3563: )
3564: IS
3565: j NUMBER;
3566: i NUMBER := 1;

Line 3567: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3563: )
3564: IS
3565: j NUMBER;
3566: i NUMBER := 1;
3567: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3568:
3569: BEGIN
3570:
3571: FOR j in 1..P_header_Price_Adj_rltship_Tbl.count LOOP

Line 3603: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type

3599: P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
3600: p_operation IN VARCHAR2,
3601: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3602: p_header_operation IN VARCHAR2,
3603: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
3604: )
3605: IS
3606:
3607: l_header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3607: l_header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3603: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
3604: )
3605: IS
3606:
3607: l_header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3608: j NUMBER;
3609: sc_count NUMBER := 1;
3610:
3611: CURSOR salesrep( p_resource_id NUMBER) IS

Line 3692: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

3688: p_line_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3689: p_line_index IN NUMBER,
3690: p_qte_line_index IN NUMBER,
3691: p_operation IN VARCHAR2,
3692: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
3693: )
3694: IS
3695:
3696: l NUMBER;

Line 3698: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3694: IS
3695:
3696: l NUMBER;
3697: i NUMBER;
3698: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3699: p_att_count NUMBER := 1;
3700:
3701: BEGIN
3702:

Line 3983: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,

3979: p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
3980: p_line_index IN NUMBER,
3981: p_qte_line_index IN NUMBER,
3982: p_operation IN VARCHAR2,
3983: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
3984: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
3985: lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3986: )
3987: IS

Line 3984: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,

3980: p_line_index IN NUMBER,
3981: p_qte_line_index IN NUMBER,
3982: p_operation IN VARCHAR2,
3983: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
3984: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
3985: lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
3986: )
3987: IS
3988:

Line 3995: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type

3991: i NUMBER;
3992: j NUMBER;
3993: adj_count NUMBER := 1;
3994: attr_count NUMBER := 1;
3995: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type
3996: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
3997: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3998:
3999: BEGIN

Line 3996: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;

3992: j NUMBER;
3993: adj_count NUMBER := 1;
3994: attr_count NUMBER := 1;
3995: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type
3996: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
3997: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3998:
3999: BEGIN
4000:

Line 3997: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

3993: adj_count NUMBER := 1;
3994: attr_count NUMBER := 1;
3995: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type
3996: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
3997: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
3998:
3999: BEGIN
4000:
4001: FOR pad_count in 1..p_line_price_adj_tbl.count LOOP

Line 4164: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

4160: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
4161: p_line_index IN NUMBER,
4162: p_qte_line_index IN NUMBER,
4163: p_operation IN VARCHAR2,
4164: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
4165: )
4166: IS
4167:
4168: l NUMBER;

Line 4171: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

4167:
4168: l NUMBER;
4169: i NUMBER;
4170: adj_rlt_count NUMBER := 1;
4171: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4172:
4173: BEGIN
4174:
4175: FOR l in 1..P_Line_Price_Adj_rltship_Tbl.count LOOP

Line 4220: x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

4216: p_line_index IN NUMBER,
4217: p_qte_line_index IN NUMBER,
4218: p_line_operation IN VARCHAR2,
4219: p_operation IN VARCHAR2,
4220: x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
4221: )
4222: IS
4223:
4224: l NUMBER;

Line 4227: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4223:
4224: l NUMBER;
4225: i NUMBER;
4226: sc_count NUMBER := 1;
4227: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4228:
4229: CURSOR salesrep( p_resource_id NUMBER) IS
4230: select salesrep_id
4231: -- from jtf_rs_srp_vl Commented Code Yogeshwar (MOAC)

Line 4319: x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,

4315: p_line_index IN NUMBER,
4316: p_qte_line_index IN NUMBER,
4317: p_line_operation IN VARCHAR2,
4318: p_operation IN VARCHAR2,
4319: x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
4320: x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
4321: )
4322: IS
4323: i NUMBER;

Line 4320: x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type

4316: p_qte_line_index IN NUMBER,
4317: p_line_operation IN VARCHAR2,
4318: p_operation IN VARCHAR2,
4319: x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
4320: x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
4321: )
4322: IS
4323: i NUMBER;
4324: pay_count NUMBER := 1;

Line 4325: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4321: )
4322: IS
4323: i NUMBER;
4324: pay_count NUMBER := 1;
4325: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4326: l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;
4327: l_om_defaulting_prof VARCHAR2(2)
4328: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
4329: Begin

Line 4326: l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;

4322: IS
4323: i NUMBER;
4324: pay_count NUMBER := 1;
4325: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4326: l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;
4327: l_om_defaulting_prof VARCHAR2(2)
4328: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
4329: Begin
4330: FOR i in 1..P_Line_Payment_Tbl.count LOOP

Line 4406: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type

4402: P_lot_serial_tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
4403: p_operation IN VARCHAR2,
4404: p_line_index IN NUMBER,
4405: p_qte_line_index IN NUMBER,
4406: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
4407: )
4408: IS
4409:
4410: l NUMBER;

Line 4412: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

4408: IS
4409:
4410: l NUMBER;
4411: lot_srl_count NUMBER :=1;
4412: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4413:
4414: BEGIN
4415:
4416: For l in 1..P_lot_serial_tbl.count LOOP