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 140: l_header_rec OE_Order_PUB.Header_Rec_Type;

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

Line 141: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

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

Line 142: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;

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

Line 143: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;

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

Line 144: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;

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

Line 145: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

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

Line 146: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

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

Line 147: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

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

Line 148: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;

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

Line 149: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;

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

Line 150: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;

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

Line 151: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

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

Line 152: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

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

Line 153: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;

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

Line 158: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;

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

Line 159: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;

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

Line 160: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;

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

Line 161: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;

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

Line 162: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;

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

Line 164: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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

Line 165: l_final_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

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

Line 166: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;

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

Line 167: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;

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

Line 249: l_Header_Payment_Tbl OE_ORDER_PUB.Header_Payment_Tbl_Type;

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

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

3123: PROCEDURE map_header_price_attr(
3124: p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3125: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3126: p_operation IN VARCHAR2,
3127: x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
3128: )
3129: IS
3130: i NUMBER;
3131: p_att_count NUMBER := 1;

Line 3132: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

3128: )
3129: IS
3130: i NUMBER;
3131: p_att_count NUMBER := 1;
3132: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
3133: BEGIN
3134: FOR i in 1..p_header_price_attributes_tbl.count LOOP
3135: l_header_price_att_tbl(p_att_count).pricing_context
3136: := p_header_price_attributes_tbl(i).pricing_context;

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

3394: PROCEDURE map_header_price_adj(
3395: p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
3396: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3397: p_operation IN VARCHAR2 ,
3398: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
3399: )
3400: IS
3401: i NUMBER;
3402: adj_count NUMBER :=1;

Line 3403: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type

3399: )
3400: IS
3401: i NUMBER;
3402: adj_count NUMBER :=1;
3403: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type
3404: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL;
3405: BEGIN
3406:
3407: FOR i in 1..p_header_price_adj_tbl.count LOOP

Line 3404: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL;

3400: IS
3401: i NUMBER;
3402: adj_count NUMBER :=1;
3403: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type
3404: := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL;
3405: BEGIN
3406:
3407: FOR i in 1..p_header_price_adj_tbl.count LOOP
3408: l_header_adj_tbl(adj_count).attribute1

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

3559:
3560: PROCEDURE map_header_price_adj_attr(
3561: p_header_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
3562: p_operation IN VARCHAR2,
3563: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
3564: )
3565: IS
3566:
3567: j NUMBER;

Line 3569: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

3565: IS
3566:
3567: j NUMBER;
3568: attr_count NUMBER := 1;
3569: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
3570:
3571: BEGIN
3572:
3573: FOR j in 1..p_header_price_adj_attr_tbl.count LOOP

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

3614:
3615: PROCEDURE map_header_price_adj_rltn(
3616: P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
3617: P_operation IN VARCHAR2,
3618: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
3619: )
3620: IS
3621: j NUMBER;
3622: i NUMBER := 1;

Line 3623: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

3619: )
3620: IS
3621: j NUMBER;
3622: i NUMBER := 1;
3623: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
3624:
3625: BEGIN
3626:
3627: FOR j in 1..P_header_Price_Adj_rltship_Tbl.count LOOP

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

3655: P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
3656: p_operation IN VARCHAR2,
3657: p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
3658: p_header_operation IN VARCHAR2,
3659: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
3660: )
3661: IS
3662:
3663: l_header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 3663: l_header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

3659: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
3660: )
3661: IS
3662:
3663: l_header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
3664: j NUMBER;
3665: sc_count NUMBER := 1;
3666:
3667: CURSOR salesrep( p_resource_id NUMBER) IS

Line 3759: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type

3755: p_line_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
3756: p_line_index IN NUMBER,
3757: p_qte_line_index IN NUMBER,
3758: p_operation IN VARCHAR2,
3759: x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
3760: )
3761: IS
3762:
3763: l NUMBER;

Line 3765: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

3761: IS
3762:
3763: l NUMBER;
3764: i NUMBER;
3765: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
3766: p_att_count NUMBER := 1;
3767:
3768: BEGIN
3769:

Line 4050: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,

4046: p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
4047: p_line_index IN NUMBER,
4048: p_qte_line_index IN NUMBER,
4049: p_operation IN VARCHAR2,
4050: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
4051: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
4052: lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
4053: )
4054: IS

Line 4051: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,

4047: p_line_index IN NUMBER,
4048: p_qte_line_index IN NUMBER,
4049: p_operation IN VARCHAR2,
4050: x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
4051: x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
4052: lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
4053: )
4054: IS
4055:

Line 4062: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type

4058: i NUMBER;
4059: j NUMBER;
4060: adj_count NUMBER := 1;
4061: attr_count NUMBER := 1;
4062: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type
4063: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
4064: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4065:
4066: BEGIN

Line 4063: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;

4059: j NUMBER;
4060: adj_count NUMBER := 1;
4061: attr_count NUMBER := 1;
4062: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type
4063: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
4064: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4065:
4066: BEGIN
4067:

Line 4064: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

4060: adj_count NUMBER := 1;
4061: attr_count NUMBER := 1;
4062: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type
4063: := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL;
4064: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
4065:
4066: BEGIN
4067:
4068: FOR pad_count in 1..p_line_price_adj_tbl.count LOOP

Line 4231: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

4227: P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
4228: p_line_index IN NUMBER,
4229: p_qte_line_index IN NUMBER,
4230: p_operation IN VARCHAR2,
4231: x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
4232: )
4233: IS
4234:
4235: l NUMBER;

Line 4238: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

4234:
4235: l NUMBER;
4236: i NUMBER;
4237: adj_rlt_count NUMBER := 1;
4238: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
4239:
4240: BEGIN
4241:
4242: FOR l in 1..P_Line_Price_Adj_rltship_Tbl.count LOOP

Line 4287: x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type

4283: p_line_index IN NUMBER,
4284: p_qte_line_index IN NUMBER,
4285: p_line_operation IN VARCHAR2,
4286: p_operation IN VARCHAR2,
4287: x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
4288: )
4289: IS
4290:
4291: l NUMBER;

Line 4294: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

4290:
4291: l NUMBER;
4292: i NUMBER;
4293: sc_count NUMBER := 1;
4294: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
4295:
4296: CURSOR salesrep( p_resource_id NUMBER) IS
4297: select salesrep_id
4298: -- from jtf_rs_srp_vl Commented Code Yogeshwar (MOAC)

Line 4397: x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,

4393: p_line_index IN NUMBER,
4394: p_qte_line_index IN NUMBER,
4395: p_line_operation IN VARCHAR2,
4396: p_operation IN VARCHAR2,
4397: x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
4398: x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
4399: )
4400: IS
4401: i NUMBER;

Line 4398: x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type

4394: p_qte_line_index IN NUMBER,
4395: p_line_operation IN VARCHAR2,
4396: p_operation IN VARCHAR2,
4397: x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
4398: x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
4399: )
4400: IS
4401: i NUMBER;
4402: pay_count NUMBER := 1;

Line 4403: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

4399: )
4400: IS
4401: i NUMBER;
4402: pay_count NUMBER := 1;
4403: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4404: --bug8775480
4405: --l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;
4406: l_om_defaulting_prof VARCHAR2(2)
4407: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');

Line 4405: --l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;

4401: i NUMBER;
4402: pay_count NUMBER := 1;
4403: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
4404: --bug8775480
4405: --l_line_tbl OE_Order_PUB.Line_Tbl_Type := x_Line_tbl;
4406: l_om_defaulting_prof VARCHAR2(2)
4407: := NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N');
4408: Begin
4409: FOR i in 1..P_Line_Payment_Tbl.count LOOP

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

4501: P_lot_serial_tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
4502: p_operation IN VARCHAR2,
4503: p_line_index IN NUMBER,
4504: p_qte_line_index IN NUMBER,
4505: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
4506: )
4507: IS
4508:
4509: l NUMBER;

Line 4511: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

4507: IS
4508:
4509: l NUMBER;
4510: lot_srl_count NUMBER :=1;
4511: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
4512:
4513: BEGIN
4514:
4515: For l in 1..P_lot_serial_tbl.count LOOP