41: -- create a row in AMS_ACT_MARKET_SEGMENTS
42: -- Parameters
43: -- IN:
44: -- p_api_version IN NUMBER
45: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
46: -- p_commit IN VARCHAR2 := FND_API.g_false
47: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
48: --
49: -- p_mks_rec IN mks_rec_type
42: -- Parameters
43: -- IN:
44: -- p_api_version IN NUMBER
45: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
46: -- p_commit IN VARCHAR2 := FND_API.g_false
47: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
48: --
49: -- p_mks_rec IN mks_rec_type
50: --
43: -- IN:
44: -- p_api_version IN NUMBER
45: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
46: -- p_commit IN VARCHAR2 := FND_API.g_false
47: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
48: --
49: -- p_mks_rec IN mks_rec_type
50: --
51: -- OUT:
57: ------------------------------------------------------------------------------
58: PROCEDURE create_market_segments
59: (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62: p_commit IN VARCHAR2 := FND_API.g_false,
63: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
58: PROCEDURE create_market_segments
59: (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62: p_commit IN VARCHAR2 := FND_API.g_false,
63: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
59: (
60: p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
62: p_commit IN VARCHAR2 := FND_API.g_false,
63: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
64:
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
77: -- update a row in AMS_ACT_MARKET_SEGMENTS
78: -- Parameters
79: -- IN:
80: -- p_api_version IN NUMBER
81: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
82: -- p_commit IN VARCHAR2 := FND_API.g_false
83: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
84: --
85: -- p_mks_rec IN mks_rec_type
78: -- Parameters
79: -- IN:
80: -- p_api_version IN NUMBER
81: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
82: -- p_commit IN VARCHAR2 := FND_API.g_false
83: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
84: --
85: -- p_mks_rec IN mks_rec_type
86: --
79: -- IN:
80: -- p_api_version IN NUMBER
81: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
82: -- p_commit IN VARCHAR2 := FND_API.g_false
83: -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
84: --
85: -- p_mks_rec IN mks_rec_type
86: --
87: -- OUT:
91: ------------------------------------------------------------------------------
92: PROCEDURE update_market_segments
93: (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98:
99: x_return_status OUT NOCOPY VARCHAR2,
92: PROCEDURE update_market_segments
93: (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98:
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
93: (
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
96: p_commit IN VARCHAR2 := FND_API.g_false,
97: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
98:
99: x_return_status OUT NOCOPY VARCHAR2,
100: x_msg_count OUT NOCOPY NUMBER,
101: x_msg_data OUT NOCOPY VARCHAR2,
110: -- delete a row from AMS_ACT_MARKET_SEGMENTS
111: -- Parameters
112: -- IN:
113: -- p_api_version IN NUMBER
114: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
115: -- p_commit IN VARCHAR2 := FND_API.g_false
116: --
117: -- p_act_mks_id IN NUMBER
118: -- p_object_version IN NUMBER
111: -- Parameters
112: -- IN:
113: -- p_api_version IN NUMBER
114: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
115: -- p_commit IN VARCHAR2 := FND_API.g_false
116: --
117: -- p_act_mks_id IN NUMBER
118: -- p_object_version IN NUMBER
119: --
124: ------------------------------------------------------------------------------
125: PROCEDURE delete_market_segments
126: (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129: p_commit IN VARCHAR2 := FND_API.g_false,
130:
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
125: PROCEDURE delete_market_segments
126: (
127: p_api_version IN NUMBER,
128: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
129: p_commit IN VARCHAR2 := FND_API.g_false,
130:
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2,
143: -- lock a row form AMS_ACT_MARKET_SEGMENTS
144: -- Parameters
145: -- IN:
146: -- p_api_version IN NUMBER
147: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
148: --
149: -- p_act_mks_id IN NUMBER
150: -- p_object_version IN NUMBER
151: --
156: ------------------------------------------------------------------------------
157: PROCEDURE lock_market_segments
158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
161:
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
174: -- validate a record before inserting or updating AMS_ACT_MARKET_SEGMENTS
175: -- Parameters
176: -- IN:
177: -- p_api_version IN NUMBER
178: -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
179: -- p_validation_mode IN VARCHAR2
180: --
181: -- p_mks_rec IN mks_rec_type
182: --
187: ------------------------------------------------------------------------------
188: PROCEDURE validate_market_segments
189: (
190: p_api_version IN NUMBER,
191: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193:
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
188: PROCEDURE validate_market_segments
189: (
190: p_api_version IN NUMBER,
191: P_init_msg_list IN VARCHAR2 := FND_API.g_false,
192: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
193:
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,