[Home] [Help]
Skip to content
PACKAGE: APPS.ASO_COPY_QUOTE_PVT
Source
1 PACKAGE ASO_COPY_QUOTE_PVT as
2 /* $Header: asovcpys.pls 120.2 2005/08/16 14:10:25 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_COPY_QUOTE_PVT
5 -- Purpose :
6 -- This package contains specification for pl/sql records and tables and the
7 -- Private API of Order Capture.
8 --
9 -- Procedures:
10 -- Copy_Quote
11 --
12 -- History :
13 -- NOTE :
14 --
15 -- End of Comments
16 --
17
18
19 PROCEDURE Copy_Quote(
20 P_Api_Version_Number IN NUMBER,
21 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23 P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
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 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
28 X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
29 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
30 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
31 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
32
33
34 PROCEDURE Copy_Header_Rows(
35 P_Api_Version_Number IN NUMBER,
36 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38 P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type,
39 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
40 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
41 X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
42 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
43 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
44 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
45
46 PROCEDURE Copy_Line_Rows(
47 P_Api_Version_Number IN NUMBER,
48 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
49 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
50 P_Qte_Header_Id IN NUMBER,
51 P_New_Qte_Header_Id IN NUMBER,
52 P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM,
53 P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
54 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
55 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
56 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
57 X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
58 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
59 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
60 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
61
62
63
64 PROCEDURE config_copy(
65 p_old_config_header_id IN NUMBER,
66 p_old_config_revision_num IN NUMBER,
67 p_config_header_id IN NUMBER,
68 p_config_revision_num IN NUMBER,
69 p_new_qte_header_id IN NUMBER,
70 p_qte_header_id IN NUMBER,
71 p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
72 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
73 lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
74 lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
75 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
76 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
77 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
78 p_line_quantity IN NUMBER := FND_API.G_MISS_NUM );
79
80 PROCEDURE service_copy(
81 p_qte_line_id IN NUMBER,
82 p_copy_quote_control_rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
83 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
84 p_new_qte_header_id IN NUMBER,
85 p_qte_header_id IN NUMBER,
86 lx_line_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
87 lx_price_index_link_tbl IN OUT NOCOPY ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type,
88 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
89 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
90 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
91 p_line_quantity IN NUMBER := FND_API.G_MISS_NUM);
92
93 PROCEDURE Get_Quote_Exp_Date(
94 X_Quote_Exp_Date OUT NOCOPY /* file.sql.39 change */ DATE,
95 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
96 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
97 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
98
99 PROCEDURE COPY_SALES_SUPPLEMENT
100 (
101 P_Api_Version_Number IN NUMBER,
102 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
103 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
104 p_old_quote_header_id IN NUMBER,
105 p_new_quote_header_id IN NUMBER,
106 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
108 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
109
110
111 PROCEDURE Copy_Opp_Quote(
112 p_api_version_number IN NUMBER := 1.0,
113 p_qte_header_id IN NUMBER,
114 p_new_qte_header_id IN NUMBER,
115 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
117 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
118
119
120 PROCEDURE Split_Model_Line (
121 P_Api_Version_Number IN NUMBER,
122 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
123 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
124 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
125 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
126 P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
127 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
128 X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
129 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
131 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
132
133
134 -- added for sales supp enhancements as per bug 2940126
135 PROCEDURE INSERT_SALES_SUPP_DATA
136 (
137 P_Api_Version_Number IN NUMBER,
138 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
139 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
140 P_OLD_QUOTE_LINE_ID IN NUMBER,
141 P_NEW_QUOTE_LINE_ID IN NUMBER,
142 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
143 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
144 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
145
146
147
148
149 PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
150 x_return_status OUT NOCOPY varchar2,
151 x_msg_count OUT NOCOPY number,
152 x_msg_data OUT NOCOPY varchar2);
153 End ASO_COPY_QUOTE_PVT;