1 PACKAGE OZF_QP_PRODUCTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvoqpps.pls 120.3 2005/08/25 04:19:24 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 -- Mon Jun 20 2005:2/19 PM RSSHARMA Added new procedure copy_vo_discounts
13
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 -- G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- ozf_offer_line_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- object_version_number
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- security_group_id
33 -- Required
34 --
35 -- Defaults
36 --
37 -- Note: This is automatic generated record definition, it includes all columns
38 -- defined in the table, developer must manually add or delete some of the attributes.
39 --
40 -- End of Comments
41
42 --===================================================================
43 TYPE qp_product_rec_type IS RECORD
44 (
45 qp_product_id NUMBER
46 , off_discount_product_id NUMBER
47 , pricing_attribute_id NUMBER
48 , object_version_number NUMBER
49 , last_update_date DATE
50 , last_updated_by NUMBER
51 , creation_date DATE
52 , created_by NUMBER
53 , last_update_login NUMBER
54 , security_group_id NUMBER
55 );
56
57
58 g_miss_qp_prod_rec qp_product_rec_type := NULL;
59 TYPE qp_product_tbl_type IS TABLE OF qp_product_rec_type INDEX BY BINARY_INTEGER;
60 g_miss_qp_prod_tbl qp_product_tbl_type;
61
62 -- ==============================================================================
63 -- Start of Comments
64 -- ==============================================================================
65 -- API Name
66 -- Create_ozf_qp_product
67 -- Type
68 -- Private
69 -- Pre-Req
70 -- Parameters
71 --
72 -- IN
73 -- p_api_version_number IN NUMBER Required
74 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
75 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
76 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
77 -- p_qp_product_rec IN qp_product_rec_type
78 -- OUT
79 -- x_return_status OUT NOCOPY VARCHAR2
80 -- x_msg_count OUT NOCOPY NUMBER
81 -- x_msg_data OUT NOCOPY VARCHAR2
82 -- x_qp_product_id OUT NOCOPY NUMBER. qp product id of the market option just created
83 -- Version : Current version 1.0
84 --
85 -- History
86 --
87 -- Description
88 -- : Method to Create relation between ozf and qp products
89 -- End of Comments
90 -- ==============================================================================
91
92 PROCEDURE Create_ozf_qp_product(
93 p_api_version_number IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_commit IN VARCHAR2 := FND_API.G_FALSE,
96 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
97
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101
102 p_qp_product_rec IN qp_product_rec_type ,
103 x_qp_product_id OUT NOCOPY NUMBER
104 );
105
106
107 -- ==============================================================================
108 -- Start of Comments
109 -- ==============================================================================
110 -- API Name
111 -- Update_market_options
112 -- Type
113 -- Private
114 -- Pre-Req
115 -- validate_market_options
116 -- Parameters
117 --
118 -- IN
119 -- p_api_version_number IN NUMBER Required
120 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
121 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
122 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
123 -- p_qp_product_rec IN qp_product_rec_type
124 -- OUT
125 -- x_return_status OUT NOCOPY VARCHAR2
126 -- x_msg_count OUT NOCOPY NUMBER
127 -- x_msg_data OUT NOCOPY VARCHAR2
128 -- Version : Current version 1.0
129 --
130 -- History
131 --
132 -- Description
133 -- : Method to Update ozf qp product relation
134 -- End of Comments
135 -- ==============================================================================
136 PROCEDURE Update_ozf_qp_product(
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_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145
146 p_qp_product_rec IN qp_product_rec_type
147 );
148
149 -- ==============================================================================
150 -- Start of Comments
151 -- ==============================================================================
152 -- API Name
153 -- Delete_ozf_qp_product
154 -- Type
155 -- Private
156 -- Pre-Req
157 -- Parameters
158 --
159 -- IN
160 -- p_api_version_number IN NUMBER
161 -- p_init_msg_list IN VARCHAR2
162 -- p_commit IN VARCHAR2
163 -- p_validation_level IN NUMBER
164 -- p_qp_product_id IN NUMBER
165 -- p_object_version_number IN NUMBER
166
167 --
168 -- OUT
169 -- x_return_status OUT NOCOPY VARCHAR2
170 -- x_msg_count OUT NOCOPY NUMBER
171 -- x_msg_data OUT NOCOPY VARCHAR2
172
173 -- Version : Current version 1.0
174 --
175 -- History
176 -- Mon Jun 20 2005:7/55 PM Created
177 --
178 -- Description
179 -- End of Comments
180 -- ==============================================================================
181 PROCEDURE Delete_ozf_qp_product(
182 p_api_version_number IN NUMBER,
183 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184 p_commit IN VARCHAR2 := FND_API.G_FALSE,
185 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_qp_product_id IN NUMBER,
190 p_object_version_number IN NUMBER
191 );
192 PROCEDURE Validate_ozf_qp_products
193 (
194 p_api_version_number IN NUMBER,
195 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196 p_commit IN VARCHAR2 := FND_API.G_FALSE,
197 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198 p_validation_mode IN VARCHAR2,
199
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203
204 p_qp_product_rec IN qp_product_rec_type
205 );
206
207 END OZF_QP_PRODUCTS_PVT;
208