[Home] [Help]
PACKAGE: APPS.ASO_COPY_QUOTE_PUB
Source
1 PACKAGE ASO_COPY_QUOTE_PUB as
2 /* $Header: asopcpys.pls 120.2 2005/11/01 14:54:27 skulkarn 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 );
36
37 G_MISS_Copy_Quote_Control_Rec Copy_Quote_Control_Rec_Type;
38
39
40 TYPE Copy_Quote_Header_Rec_Type IS RECORD
41 (
42 Quote_Header_Id NUMBER := FND_API.G_MISS_NUM,
43 Quote_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
44 Quote_Number NUMBER := FND_API.G_MISS_NUM,
45 Quote_Source_Code VARCHAR2(240) := FND_API.G_MISS_CHAR,
46 Quote_Expiration_Date DATE := FND_API.G_MISS_DATE,
47 Resource_Id NUMBER := FND_API.G_MISS_NUM,
48 Resource_Grp_Id NUMBER := FND_API.G_MISS_NUM,
49 PRICING_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
50 TAX_STATUS_INDICATOR VARCHAR2(1) := FND_API.G_MISS_CHAR,
51 PRICE_UPDATED_DATE DATE := FND_API.G_MISS_DATE,
52 TAX_UPDATED_DATE DATE := FND_API.G_MISS_DATE
53 );
54
55 G_MISS_Copy_Quote_Header_Rec Copy_Quote_Header_Rec_Type;
56
57
58 -- *******************************************************
59 -- Start of Comments
60 -- *******************************************************
61 -- API Name: Copy_Quote
62 -- Type : Public
63 -- Pre-Req :
64 -- Parameters:
65 -- IN
66 -- p_api_version_number IN NUMBER Required
67 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
68 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
69 -- P_Copy_Quote_Header_Rec IN Copy_Quote_Header_Rec_Type Default = G_MISS_Copy_Quote_Header_Rec
70 -- P_Copy_Quote_Control_Rec IN Copy_Quote_Control_Rec_Type Default = G_MISS_Copy_Quote_Control_Rec
71 --
72 -- OUT:
73 -- x_qte_header_id OUT NOCOPY /* file.sql.39 change */ NUMBER
74 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
76 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77 --
78 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
79 -- and basic operation, developer must manually add parameters and business logic as necessary.
80 --
81 -- End of Comments
82 --
83
84 PROCEDURE Copy_Quote(
85 P_Api_Version_Number IN NUMBER,
86 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
87 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
88 P_Copy_Quote_Header_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Header_Rec_Type
89 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
90 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
91 := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
92 X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
93 X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
94 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
95 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
96 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
97
98
99
100 PROCEDURE Copy_Line(
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_Qte_Header_Id IN NUMBER,
105 P_Qte_Line_Id IN NUMBER := NULL,
106 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
107 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
108 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
109 X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
110 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
112 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
113
114 -- Overloaded Copy Line created for bug 4339146
115 PROCEDURE Copy_Line(
116 P_Api_Version_Number IN NUMBER,
117 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
118 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
119 P_Qte_Header_Id IN NUMBER,
120 P_Qte_Line_Id IN NUMBER := NULL,
121 P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
122 P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
123 P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
124 X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
125 X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
126 X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
127 X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
128 X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
129 End ASO_COPY_QUOTE_PUB;
130