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_QUOTE_TMPL_PVT dependencies on ASO_QUOTE_PUB

Line 26: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

22: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
23: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
25: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
26: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
27: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
28: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
29: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
30: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 27: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,

23: P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
25: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
26: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
27: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
28: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
29: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
30: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 28: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

24: P_UPDATE_FLAG IN VARCHAR2 := 'Y',
25: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
26: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
27: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
28: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
29: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
30: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 29: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,

25: P_TEMPLATE_ID_TBL IN ASO_QUOTE_TMPL_INT.LIST_TEMPLATE_TBL_TYPE,
26: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
27: P_CONTROL_REC IN ASO_QUOTE_PUB.CONTROL_REC_TYPE := ASO_QUOTE_PUB.G_MISS_control_REC,
28: x_Qte_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
29: x_Qte_Line_Dtl_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type,
30: X_RETURN_STATUS OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY /* file.sql.39 change */ NUMBER,
32: X_MSG_DATA OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33: )

Line 55: l_temp_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

51: lx_line_relationship_id NUMBER;
52:
53: l_dropped_line_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type := ASO_QUOTE_TMPL_INT.G_Miss_List_Template_Tbl;
54: l_search_line_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type := ASO_QUOTE_TMPL_INT.G_Miss_List_Template_Tbl;
55: l_temp_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
56: l_cfg_control_rec ASO_CFG_INT.Control_rec_Type := ASO_CFG_INT.G_Miss_Control_Rec;
57: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
58:
59: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()

Line 57: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;

53: l_dropped_line_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type := ASO_QUOTE_TMPL_INT.G_Miss_List_Template_Tbl;
54: l_search_line_id_tbl ASO_QUOTE_TMPL_INT.List_Template_Tbl_Type := ASO_QUOTE_TMPL_INT.G_Miss_List_Template_Tbl;
55: l_temp_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
56: l_cfg_control_rec ASO_CFG_INT.Control_rec_Type := ASO_CFG_INT.G_Miss_Control_Rec;
57: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
58:
59: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
60: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type;
61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

Line 61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

57: l_line_rltship_rec ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
58:
59: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
60: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type;
61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

58:
59: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
60: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type;
61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

59: -- Variables to hold values to be passed to ASO_VALIDATE_PRICING_PVT.Validate_Pricing_Order()
60: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type;
61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

60: l_pricing_control_rec ASO_PRICING_INT.Pricing_Control_Rec_Type;
61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:

Line 65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

61: lp_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()

Line 66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

62: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

Line 67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

63: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
64: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

Line 69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()

65: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;

66: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

67: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

68:
69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

69: -- Variables to hold values to be passed to ASO_QUOTE_PUB.Update_Quote()
70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

70: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec;
71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

71: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

72: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

73: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

74: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

Line 79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

75: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

76: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

77: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

Line 82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

78: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

79: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

80: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

81: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

82: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;
83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
90: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

83: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
90: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
91: lx_orig_item_id_tbl CZ_API_PUB.number_tbl_type;

Line 88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

84: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
90: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
91: lx_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
92: lx_new_item_id_tbl CZ_API_PUB.number_tbl_type;

Line 89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

85: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;
86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
90: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
91: lx_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
92: lx_new_item_id_tbl CZ_API_PUB.number_tbl_type;
93:

Line 90: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

86: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
87: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
88: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
89: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
90: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
91: lx_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
92: lx_new_item_id_tbl CZ_API_PUB.number_tbl_type;
93:
94: TYPE search_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 229: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

225: lp_qte_line_tbl(l_template_line_count).org_id:=l_qte_header_rec.org_id;
226: end if;
227: end if;
228: END LOOP;
229: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
230: END LOOP;
231:
232: l_pricing_control_rec.request_type := 'ASO';
233: l_pricing_control_rec.pricing_event := 'BATCH';

Line 336: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;

332: END IF;
333:
334: FOR i IN 1..l_qte_line_tbl.count LOOP
335: IF l_qte_line_tbl(i).item_type_code IN ('MDL','CFG') THEN
336: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
337: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
338:
339: IF l_temp_line_dtl_tbl.count > 0 THEN
340: l_template_line_count := l_template_line_count + 1;

Line 371: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;

367: l_service_flag := service_items_rec.service_item_flag;
368: END LOOP;
369:
370: IF l_service_flag = 'Y' THEN
371: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
372: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
373:
374: IF l_temp_line_dtl_tbl.count > 0 THEN
375: l_template_line_count := l_template_line_count + 1;

Line 503: ASO_QUOTE_PUB.Update_Quote(

499:
500: END IF;
501:
502: --mo_global.set_policy_context('S', l_qte_header_rec.org_id);
503: ASO_QUOTE_PUB.Update_Quote(
504: P_Api_Version_Number => 1.0,
505: P_Init_Msg_List => FND_API.G_FALSE,
506: P_Commit => FND_API.G_FALSE,
507: P_Control_Rec => p_control_rec,

Line 547: /* x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
544: END IF;
545:
546: -- Commented for bug no 6731701 so that only the record for newly inserted line go into relationship table
547: /* x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
548: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
549: */
550: IF aso_debug_pub.g_debug_flag = 'Y' THEN
551: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP

Line 561: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;

557: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');
558: END IF;
559:
560: FOR i in 1..x_qte_line_tbl.count LOOP
561: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
562: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
563: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
564:
565: IF x_qte_line_dtl_tbl.count > 0 THEN

Line 562: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;

558: END IF;
559:
560: FOR i in 1..x_qte_line_tbl.count LOOP
561: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
562: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
563: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
564:
565: IF x_qte_line_dtl_tbl.count > 0 THEN
566:

Line 678: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

674: END Add_Template_To_Quote;
675:
676: -- 9433340 Suner2
677: FUNCTION Validate_Item(
678: p_qte_header_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
679: p_quote_line_id IN NUMBER,
680: p_inventory_item_id IN NUMBER,
681: --p_organization_id IN NUMBER,
682: p_quantity IN NUMBER,