DBA Data[Home] [Help]

APPS.OZF_VOL_OFFR_PVT dependencies on FND_API

Line 82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

78: -- Parameters
79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86: --

Line 83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

79: --
80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86: --
87: -- OUT

Line 84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

80: -- IN
81: -- p_api_version_number IN NUMBER Required
82: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
83: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
84: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
85: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
86: --
87: -- OUT
88: -- x_return_status OUT VARCHAR2

Line 104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

100: -- ==============================================================================
101:
102: PROCEDURE Create_Vol_Offr(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,

Line 105: p_commit IN VARCHAR2 := FND_API.G_FALSE,

101:
102: PROCEDURE Create_Vol_Offr(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,

Line 106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

102: PROCEDURE Create_Vol_Offr(
103: p_api_version_number IN NUMBER,
104: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
105: p_commit IN VARCHAR2 := FND_API.G_FALSE,
106: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
107:
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,

Line 129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133: --

Line 130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133: --
134: -- OUT

Line 131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2

Line 151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

147: -- ==============================================================================
148:
149: PROCEDURE Update_Vol_Offr(
150: p_api_version_number IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,

Line 152: p_commit IN VARCHAR2 := FND_API.G_FALSE,

148:
149: PROCEDURE Update_Vol_Offr(
150: p_api_version_number IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,

Line 153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

149: PROCEDURE Update_Vol_Offr(
150: p_api_version_number IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
152: p_commit IN VARCHAR2 := FND_API.G_FALSE,
153: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
154:
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,

Line 176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

172: -- Parameters
173: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_volume_offer_tiers_id IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

173: --
174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_volume_offer_tiers_id IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
181: --

Line 178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

174: -- IN
175: -- p_api_version_number IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
177: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
179: -- p_volume_offer_tiers_id IN NUMBER
180: -- p_object_version_number IN NUMBER Optional Default = NULL
181: --
182: -- OUT

Line 199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

195: -- ==============================================================================
196:
197: PROCEDURE Delete_Vol_Offr(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,

Line 200: p_commit IN VARCHAR2 := FND_API.G_FALSE,

196:
197: PROCEDURE Delete_Vol_Offr(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,

Line 201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

197: PROCEDURE Delete_Vol_Offr(
198: p_api_version_number IN NUMBER,
199: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200: p_commit IN VARCHAR2 := FND_API.G_FALSE,
201: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_volume_offer_tiers_id IN NUMBER,

Line 222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

218: -- Parameters
219: --
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226: --

Line 223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

219: --
220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226: --
227: -- OUT

Line 224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

220: -- IN
221: -- p_api_version_number IN NUMBER Required
222: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
223: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
224: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_vol_offr_tier_rec IN vol_offr_tier_rec_type Required
226: --
227: -- OUT
228: -- x_return_status OUT VARCHAR2

Line 244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

240: -- ==============================================================================
241:
242: PROCEDURE Lock_Vol_Offr(
243: p_api_version_number IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245:
246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,

Line 278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

274:
275:
276: PROCEDURE Validate_Vol_Offr(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
281: p_validation_mode IN VARCHAR2,
282: x_return_status OUT NOCOPY VARCHAR2,

Line 279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

275:
276: PROCEDURE Validate_Vol_Offr(
277: p_api_version_number IN NUMBER,
278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_vol_offr_tier_rec IN vol_offr_tier_rec_type,
281: p_validation_mode IN VARCHAR2,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,

Line 337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

333:
334:
335: PROCEDURE Validate_Vol_Offr_Tier_Rec (
336: p_api_version_number IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: x_return_status OUT NOCOPY VARCHAR2,
339: x_msg_count OUT NOCOPY NUMBER,
340: x_msg_data OUT NOCOPY VARCHAR2,
341: p_vol_offr_tier_rec IN vol_offr_tier_rec_type