[Home] [Help]
PACKAGE: APPS.ASO_COPY_QUOTE_PUB
Source
1 PACKAGE ASO_COPY_QUOTE_PUB AUTHID CURRENT_USER as
2 /* $Header: asopcpys.pls 120.2.12010000.3 2010/03/17 06:18:58 akushwah ship $ */
3 -- Start of Comments
4 -- Package name : ASO_COPY_QUOTE_PUB
5 -- Purpose :
6 -- This package contains specification for pl/sql records and tables and the
7 -- Public API of Order Capture.
8 --
9 -- Record Type:
10 -- Copy_Quote_Control_Rec_Type
11 -- Copy_Quote_Header_Rec_Type
12 --
13 -- Procedures:
14 -- Copy_Quote
15 --
16 -- History :
17 -- NOTE :
18 --
19 -- End of Comments
20 --
21
22
23 TYPE Copy_Quote_Control_Rec_Type IS RECORD
24 (
25 Copy_Header_Only VARCHAR2(1) := FND_API.G_FALSE,
26 New_Version VARCHAR2(1) := FND_API.G_FALSE,
27 Copy_Note VARCHAR2(1) := FND_API.G_TRUE,
28 Copy_Task VARCHAR2(1) := FND_API.G_TRUE,
29 Copy_Attachment VARCHAR2(1) := FND_API.G_TRUE,
30 Pricing_Request_Type VARCHAR2(30) := 'ASO',
31 Header_Pricing_Event VARCHAR2(30) := FND_API.G_MISS_CHAR,
32 Price_Mode VARCHAR2(30) := 'ENTIRE_QUOTE',
33 Calculate_Freight_Charge_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
34 Calculate_Tax_Flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
35 /* Code change for Quoting Usability Sun ER Start */
36 Copy_Shipping VARCHAR2(1) := FND_API.G_TRUE,
37 Copy_Billing VARCHAR2(1) := FND_API.G_TRUE,
38 Copy_Payment VARCHAR2(1) := FND_API.G_TRUE,
39 Copy_End_Customer VARCHAR2(1) := FND_API.G_TRUE,
40 Copy_Sales_Supplement VARCHAR2(1) := FND_API.G_TRUE,
41 Copy_Flexfield VARCHAR2(1) := FND_API.G_TRUE,
42 Copy_Sales_Credit VARCHAR2(1) := FND_API.G_TRUE,
43 Copy_Contract_Terms VARCHAR2(1) := FND_API.G_TRUE,
44 Copy_Sales_Team VARCHAR2(1) := FND_API.G_TRUE,
45 Copy_Line_Shipping VARCHAR2(1) := FND_API.G_TRUE,
46 Copy_Line_Billing VARCHAR2(1) := FND_API.G_TRUE,
47 Copy_Line_Payment VARCHAR2(1) := FND_API.G_TRUE,
48 Copy_Line_End_Customer VARCHAR2(1) := FND_API.G_TRUE,
49 Copy_Line_Sales_Supplement VARCHAR2(1) := FND_API.G_TRUE,
50 Copy_Line_Attachment VARCHAR2(1) := FND_API.G_TRUE,
51 Copy_Line_Flexfield VARCHAR2(1) := FND_API.G_TRUE,
52 Copy_Line_Sales_Credit VARCHAR2(1) := FND_API.G_TRUE,
53 Copy_To_Same_Customer VARCHAR2(1) := FND_API.G_TRUE
54 /* Code change for Quoting Usability Sun ER End */
55 );
56
57 G_MISS_Copy_Quote_Control_Rec Copy_Quote_Control_Rec_Type;
58
59 TYPE Copy_Quote_Header_Rec_Type IS RECORD
60 (
61 Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
62 Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
63 Quote_Number NUMBER := FND_API.G_MISS_NUM,
64 Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
65 Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
66 Resource_Id NUMBER := FND_API.G_MISS_NUM,
67 Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
68 PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
69 TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
70 PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
71 TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
72 );
73
74 G_MISS_Copy_Quote_Header_Rec Copy_Quote_Header_Rec_Type;
75
76
77 -- *******************************************************
78 -- Start of Comments
79 -- *******************************************************
80 -- API Name: Copy_Quote
81 -- Type : Public
82 -- Pre-Req :
83 -- Parameters:
84 -- IN
85 -- p_api_version_number IN NUMBER Required
86 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
87 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
88 -- P_Copy_Quote_Header_Rec IN Copy_Quote_Header_Rec_Type Default = G_MISS_Copy_Quote_Header_Rec
89 -- P_Copy_Quote_Control_Rec IN Copy_Quote_Control_Rec_Type Default = G_MISS_Copy_Quote_Control_Rec
90 --
91 -- OUT:
92 -- x_qte_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
93 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
95 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 --
97 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
98 -- and basic operation, developer must manually add parameters and business logic as necessary.
99 --
100 -- End of Comments
101 --
102
103 PROCEDURE Copy_Quote(
104 P_Api_Version_Number IN NUMBER,
105 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
107 P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
108 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
109 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
110 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
111 /* Code change for Quoting Usability Sun ER Start */
112 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
113 P_hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
114 P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
115 P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
116 /* Code change for Quoting Usability Sun ER End */
117 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
118 X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
119 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
121 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
122
123
124
125 PROCEDURE Copy_Line(
126 P_Api_Version_Number IN NUMBER,
127 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
129 P_Qte_Header_Id IN NUMBER,
130 P_Qte_Line_Id IN NUMBER := NULL,
131 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
132 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
133 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
134 X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
135 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
136 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
137 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
138
139 -- Overloaded Copy Line created for bug 4339146
140 PROCEDURE Copy_Line(
141 P_Api_Version_Number IN NUMBER,
142 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
143 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
144 P_Qte_Header_Id IN NUMBER,
145 P_Qte_Line_Id IN NUMBER := NULL,
146 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
147 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
148 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
149 X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
150 X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
151 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
152 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
153 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
154 End ASO_COPY_QUOTE_PUB;
155