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
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
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
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,
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,
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,
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
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
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
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,
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,
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,
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,
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,
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,