DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_PUB

Line 28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

24: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
25: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
26: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
27: /* Code change for Quoting Usability Sun ER Start */
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
29: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
30: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
31: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
32: /* Code change for Quoting Usability Sun ER End */

Line 29: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,

25: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
26: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
27: /* Code change for Quoting Usability Sun ER Start */
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
29: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
30: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
31: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
32: /* Code change for Quoting Usability Sun ER End */
33: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 30: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,

26: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
27: /* Code change for Quoting Usability Sun ER Start */
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
29: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
30: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
31: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
32: /* Code change for Quoting Usability Sun ER End */
33: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
34: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 31: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,

27: /* Code change for Quoting Usability Sun ER Start */
28: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
29: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
30: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
31: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
32: /* Code change for Quoting Usability Sun ER End */
33: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
34: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
35: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 44: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,

40: PROCEDURE Copy_Header_Rows(
41: P_Api_Version_Number IN NUMBER,
42: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
43: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
45: /* Code change for Quoting Usability Sun ER Start */
46: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
47: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
48: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,

Line 46: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,

42: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
43: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
45: /* Code change for Quoting Usability Sun ER Start */
46: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
47: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
48: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
49: /* Code change for Quoting Usability Sun ER End */
50: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,

Line 47: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,

43: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
44: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
45: /* Code change for Quoting Usability Sun ER Start */
46: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
47: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
48: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
49: /* Code change for Quoting Usability Sun ER End */
50: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
51: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 48: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,

44: P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
45: /* Code change for Quoting Usability Sun ER Start */
46: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
47: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
48: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
49: /* Code change for Quoting Usability Sun ER End */
50: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
51: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
52: X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,

Line 66: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

62: P_New_Qte_Header_Id IN NUMBER,
63: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
64: P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
65: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
66: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
67: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
68: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 67: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

63: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
64: P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
65: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
66: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
67: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
68: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
69: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
70: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
71: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );

Line 135: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

131: PROCEDURE Split_Model_Line (
132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
136: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
137: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
138: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
139: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 136: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

132: P_Api_Version_Number IN NUMBER,
133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
136: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
137: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
138: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
139: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 137: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

133: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
136: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
137: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
138: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
139: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 138: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

134: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
135: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
136: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
137: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
138: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
139: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );

Line 139: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

135: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
136: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
137: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
138: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
139: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
140: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
141: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
142: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
143:

Line 160: PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,

156:
157:
158:
159:
160: PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
161: x_return_status OUT NOCOPY varchar2,
162: x_msg_count OUT NOCOPY number,
163: x_msg_data OUT NOCOPY varchar2);
164: End ASO_COPY_QUOTE_PVT;