75: -- Parameters
76: --
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- p_qual_mo_rec IN qual_mo_rec_type
83: -- OUT NOCOPY
76: --
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- p_qual_mo_rec IN qual_mo_rec_type
83: -- OUT NOCOPY
84: -- x_return_status OUT NOCOPY VARCHAR2
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- p_qual_mo_rec IN qual_mo_rec_type
83: -- OUT NOCOPY
84: -- x_return_status OUT NOCOPY VARCHAR2
85: -- x_msg_count OUT NOCOPY NUMBER
96: -- ==============================================================================
97:
98: PROCEDURE Create_qual_market_options(
99: p_api_version_number IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103:
104: x_return_status OUT NOCOPY VARCHAR2,
97:
98: PROCEDURE Create_qual_market_options(
99: p_api_version_number IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103:
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
98: PROCEDURE Create_qual_market_options(
99: p_api_version_number IN NUMBER,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: p_commit IN VARCHAR2 := FND_API.G_FALSE,
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103:
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
122: -- Parameters
123: --
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_qual_mo_rec IN qual_mo_rec_type Required Record Containing qualifier Market options Data
130: -- x_return_status OUT NOCOPY VARCHAR2
123: --
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_qual_mo_rec IN qual_mo_rec_type Required Record Containing qualifier Market options Data
130: -- x_return_status OUT NOCOPY VARCHAR2
131: -- x_msg_count OUT NOCOPY NUMBER
124: -- IN
125: -- p_api_version_number IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
127: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
129: -- p_qual_mo_rec IN qual_mo_rec_type Required Record Containing qualifier Market options Data
130: -- x_return_status OUT NOCOPY VARCHAR2
131: -- x_msg_count OUT NOCOPY NUMBER
132: -- x_msg_data OUT NOCOPY VARCHAR2
140: -- End of Comments
141: -- ==============================================================================
142: PROCEDURE update_qual_market_options(
143: p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_commit IN VARCHAR2 := FND_API.G_FALSE
146: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
147:
148: , x_return_status OUT NOCOPY VARCHAR2
141: -- ==============================================================================
142: PROCEDURE update_qual_market_options(
143: p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_commit IN VARCHAR2 := FND_API.G_FALSE
146: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
147:
148: , x_return_status OUT NOCOPY VARCHAR2
149: , x_msg_count OUT NOCOPY VARCHAR2
142: PROCEDURE update_qual_market_options(
143: p_api_version_number IN NUMBER
144: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
145: , p_commit IN VARCHAR2 := FND_API.G_FALSE
146: , p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL
147:
148: , x_return_status OUT NOCOPY VARCHAR2
149: , x_msg_count OUT NOCOPY VARCHAR2
150: , x_msg_data OUT NOCOPY VARCHAR2
186: -- End of Comments
187: -- ==============================================================================
188: PROCEDURE Delete_qual_market_options(
189: p_api_version_number IN NUMBER
190: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: , p_commit IN VARCHAR2 := FND_API.G_FALSE
192: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY VARCHAR2
187: -- ==============================================================================
188: PROCEDURE Delete_qual_market_options(
189: p_api_version_number IN NUMBER
190: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: , p_commit IN VARCHAR2 := FND_API.G_FALSE
192: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY VARCHAR2
195: , x_msg_data OUT NOCOPY VARCHAR2
188: PROCEDURE Delete_qual_market_options(
189: p_api_version_number IN NUMBER
190: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
191: , p_commit IN VARCHAR2 := FND_API.G_FALSE
192: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
193: , x_return_status OUT NOCOPY VARCHAR2
194: , x_msg_count OUT NOCOPY VARCHAR2
195: , x_msg_data OUT NOCOPY VARCHAR2
196: , p_qualifier_market_option_id IN NUMBER