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 23: P_QTE_HEADER_REC IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

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

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

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

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

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

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

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

Line 52: l_temp_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

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

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

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

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

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

Line 59: lpx_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

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

Line 60: lpx_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

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

Line 61: lpx_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

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

Line 62: lpx_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

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

Line 63: lpx_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

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

Line 64: lpx_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

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

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

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

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

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

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

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

Line 69: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

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

Line 70: X_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

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

Line 71: --X_Qte_Line_Tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

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

Line 72: --X_Qte_Line_Dtl_Tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

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

Line 73: X_Hd_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 74: X_Hd_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

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

Line 75: X_Hd_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

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

Line 76: X_Hd_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

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

Line 77: X_Hd_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

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

Line 78: X_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

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

Line 79: X_line_rltship_tbl ASO_QUOTE_PUB.Line_Rltship_Tbl_Type;

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

Line 80: X_Price_Adjustment_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

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

Line 81: X_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

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

Line 82: X_Price_Adj_Rltship_Tbl ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type;

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

Line 83: X_Ln_Price_Attributes_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

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

Line 84: X_Ln_Payment_Tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

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

Line 85: X_Ln_Shipment_Tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

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

Line 86: X_Ln_Freight_Charge_Tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

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

Line 87: X_Ln_Tax_Detail_Tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

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

Line 178: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

174: FOR j IN 1..l_qte_line_tbl.count LOOP
175: l_template_line_count := l_template_line_count + 1;
176: lp_qte_line_tbl(l_template_line_count) := l_qte_line_tbl(j);
177: END LOOP;
178: l_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
179: END LOOP;
180:
181: l_pricing_control_rec.request_type := 'ASO';
182: l_pricing_control_rec.pricing_event := 'BATCH';

Line 285: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;

281: END IF;
282:
283: FOR i IN 1..l_qte_line_tbl.count LOOP
284: IF l_qte_line_tbl(i).item_type_code IN ('MDL','CFG') THEN
285: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
286: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
287:
288: IF l_temp_line_dtl_tbl.count > 0 THEN
289: l_template_line_count := l_template_line_count + 1;

Line 308: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;

304: l_service_flag := service_items_rec.service_item_flag;
305: END LOOP;
306:
307: IF l_service_flag = 'Y' THEN
308: l_temp_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
309: l_temp_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
310:
311: IF l_temp_line_dtl_tbl.count > 0 THEN
312: l_template_line_count := l_template_line_count + 1;

Line 439: ASO_QUOTE_PUB.Update_Quote(

435: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: before Update_Quote', 1, 'Y');
436:
437: END IF;
438:
439: ASO_QUOTE_PUB.Update_Quote(
440: P_Api_Version_Number => 1.0,
441: P_Init_Msg_List => FND_API.G_FALSE,
442: P_Commit => FND_API.G_FALSE,
443: P_Control_Rec => p_control_rec,

Line 480: x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;

476: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: END IF;
479:
480: x_qte_line_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Tbl;
481: x_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows_sort(p_qte_header_rec.quote_header_id);
482:
483: IF aso_debug_pub.g_debug_flag = 'Y' THEN
484: For l in x_qte_line_tbl.FIRST..x_qte_line_tbl.LAST LOOP

Line 494: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;

490: aso_debug_pub.add('ASO_QUOTE_TMPL_PVT: start line relationships loop', 1, 'Y');
491: END IF;
492:
493: FOR i in 1..x_qte_line_tbl.count LOOP
494: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
495: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
496: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
497:
498: IF x_qte_line_dtl_tbl.count > 0 THEN

Line 495: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;

491: END IF;
492:
493: FOR i in 1..x_qte_line_tbl.count LOOP
494: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
495: x_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_Miss_Qte_Line_Dtl_Tbl;
496: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
497:
498: IF x_qte_line_dtl_tbl.count > 0 THEN
499: