[Home] [Help]
PACKAGE: APPS.OZF_MO_PRESET_TIERS_PVT
Source
1 PACKAGE OZF_MO_PRESET_TIERS_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvmopts.pls 120.2 2005/08/24 06:08:44 rssharma noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 --
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 -- Mon Jul 11 2005:6/27 PM RSSHARMA Created
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 -- mo_preset_rec_type
24 -- -------------------------------------------------------
25 -- Parameters:
26 -- MARKET_PRESET_TIER_ID
27 -- OFFER_MARKET_OPTION_ID
28 -- PBH_OFFER_DISCOUNT_ID
29 -- DIS_OFFER_DISCOUNT_ID
30 -- OBJECT_VERSION_NUMBER
31 -- LAST_UPDATE_DATE
32 -- LAST_UPDATED_BY
33 -- CREATION_DATE
34 -- CREATED_BY
35 -- LAST_UPDATE_LOGIN
36 -- Required
37 --
38 -- Defaults
39 --
40 --
41 -- End of Comments
42
43 --===================================================================
44 TYPE mo_preset_rec_type IS RECORD
45 (
46 MARKET_PRESET_TIER_ID NUMBER
47 , OFFER_MARKET_OPTION_ID NUMBER
48 , PBH_OFFER_DISCOUNT_ID NUMBER
49 , DIS_OFFER_DISCOUNT_ID NUMBER
50 , OBJECT_VERSION_NUMBER NUMBER
51 , LAST_UPDATE_DATE DATE
52 , LAST_UPDATED_BY NUMBER
53 , CREATION_DATE DATE
54 , CREATED_BY NUMBER
55 , LAST_UPDATE_LOGIN NUMBER
56 );
57
58
59 g_miss_mo_preset_rec_type mo_preset_rec_type := NULL;
60 TYPE mo_preset_tbl_type IS TABLE OF mo_preset_rec_type INDEX BY BINARY_INTEGER;
61 g_miss_mo_preset_tbl mo_preset_tbl_type;
62
63 -- ==============================================================================
64 -- Start of Comments
65 -- ==============================================================================
66 -- API Name
67 -- Create_mo_preset_tiers
68 -- Type
69 -- Private
70 -- Pre-Req
71 -- Parameters
72 --
73 -- IN
74 -- p_api_version_number IN NUMBER Required
75 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
76 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
77 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
78 -- p_vo_mo_rec IN mo_preset_rec_type
79 -- OUT
80 -- x_return_status OUT NOCOPY VARCHAR2
81 -- x_msg_count OUT NOCOPY NUMBER
82 -- x_msg_data OUT NOCOPY VARCHAR2
83 -- x_market_preset_tier_id OUT NOCOPY NUMBER. Market Preset id of the market option just created
84 -- Version : Current version 1.0
85 --
86 -- History
87 --
88 -- Description
89 -- : Method to Create New Market Options.
90 -- End of Comments
91 -- ==============================================================================
92 PROCEDURE Create_mo_preset_tiers(
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_preset_tier_rec IN mo_preset_rec_type ,
103 x_market_preset_tier_id OUT NOCOPY NUMBER
104 );
105
106
107 -- ==============================================================================
108 -- Start of Comments
109 -- ==============================================================================
110 -- API Name
111 -- Update_mo_preset_tiers
112 -- Type
113 -- Private
114 -- Pre-Req
115 -- validate_mo_preset_tiers
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_mo_preset_rec IN mo_preset_rec_type Required Record Containing Market Preset Tiers Data
124 -- x_return_status OUT NOCOPY VARCHAR2
125 -- x_msg_count OUT NOCOPY NUMBER
126 -- x_msg_data OUT NOCOPY VARCHAR2
127 -- Version : Current version 1.0
128 --
129 -- History
130 --
131 -- Description
132 -- : Method to Update Preset Tiers.
133 -- End of Comments
134 -- ==============================================================================
135 PROCEDURE Update_mo_preset_tiers(
136 p_api_version_number IN NUMBER,
137 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
138 p_commit IN VARCHAR2 := FND_API.G_FALSE,
139 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
140
141 x_return_status OUT NOCOPY VARCHAR2,
142 x_msg_count OUT NOCOPY NUMBER,
143 x_msg_data OUT NOCOPY VARCHAR2,
144
145 p_preset_tier_rec IN mo_preset_rec_type
146 );
147
148 -- ==============================================================================
149 -- Start of Comments
150 -- ==============================================================================
151 -- API Name
152 -- Delete_mo_preset_tiers
153 -- Type
154 -- Private
155 -- Pre-Req
156 -- Parameters
157 --
158 -- IN
159 -- p_api_version_number IN NUMBER
160 -- p_init_msg_list IN VARCHAR2
161 -- p_commit IN VARCHAR2
162 -- p_validation_level IN NUMBER
163 -- p_market_preset_id IN NUMBER
164 -- p_object_version_number IN NUMBER
165
166 --
167 -- OUT
168 -- x_return_status OUT NOCOPY VARCHAR2
169 -- x_msg_count OUT NOCOPY NUMBER
170 -- x_msg_data OUT NOCOPY VARCHAR2
171
172 -- Version : Current version 1.0
173 --
174 -- History
175 --
176 -- Description
177 -- End of Comments
178 -- ==============================================================================
179 PROCEDURE Delete_mo_preset_tiers(
180 p_api_version_number IN NUMBER,
181 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182 p_commit IN VARCHAR2 := FND_API.G_FALSE,
183 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
184 x_return_status OUT NOCOPY VARCHAR2,
185 x_msg_count OUT NOCOPY NUMBER,
186 x_msg_data OUT NOCOPY VARCHAR2,
187 p_market_preset_tier_id IN NUMBER,
188 p_object_version_number IN NUMBER
189 );
190
191
192 END OZF_MO_PRESET_TIERS_PVT;
193