90: -- Pre-reqs : None.
91: -- Parameters :
92: -- IN : p_api_version IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_commit IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
92: -- IN : p_api_version IN NUMBER Required
93: -- p_init_msg_list IN VARCHAR2 Optional
94: -- Default = FND_API.G_FALSE
95: -- p_commit IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_plan_element IN plan_element_rec_type
100: -- OUT : x_return_status OUT VARCHAR2(1)
94: -- Default = FND_API.G_FALSE
95: -- p_commit IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_validation_level IN NUMBER Optional
98: -- Default = FND_API.G_VALID_LEVEL_FULL
99: -- p_plan_element IN plan_element_rec_type
100: -- OUT : x_return_status OUT VARCHAR2(1)
101: -- x_msg_count OUT NUMBER
102: -- x_msg_data OUT VARCHAR2(2000)
106: --
107: -- End of comments
108: PROCEDURE create_plan_element (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
111: p_commit IN VARCHAR2 := fnd_api.g_false,
112: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
113: p_plan_element IN OUT NOCOPY plan_element_rec_type,
114: x_return_status OUT NOCOPY VARCHAR2,
107: -- End of comments
108: PROCEDURE create_plan_element (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
111: p_commit IN VARCHAR2 := fnd_api.g_false,
112: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
113: p_plan_element IN OUT NOCOPY plan_element_rec_type,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
108: PROCEDURE create_plan_element (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
111: p_commit IN VARCHAR2 := fnd_api.g_false,
112: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
113: p_plan_element IN OUT NOCOPY plan_element_rec_type,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
116: x_msg_data OUT NOCOPY VARCHAR2
123: -- Pre-reqs : None.
124: -- Parameters :
125: -- IN : p_api_version IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional
127: -- Default = FND_API.G_FALSE
128: -- p_commit IN VARCHAR2 Optional
129: -- Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional
131: -- Default = FND_API.G_VALID_LEVEL_FULL
125: -- IN : p_api_version IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Optional
127: -- Default = FND_API.G_FALSE
128: -- p_commit IN VARCHAR2 Optional
129: -- Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional
131: -- Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_plan_element IN plan_element_rec_type
133: -- OUT : x_return_status OUT VARCHAR2(1)
127: -- Default = FND_API.G_FALSE
128: -- p_commit IN VARCHAR2 Optional
129: -- Default = FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Optional
131: -- Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_plan_element IN plan_element_rec_type
133: -- OUT : x_return_status OUT VARCHAR2(1)
134: -- x_msg_count OUT NUMBER
135: -- x_msg_data OUT VARCHAR2(2000)
138: --
139: -- End of comments
140: PROCEDURE update_plan_element (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: p_commit IN VARCHAR2 := fnd_api.g_false,
144: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
145: p_plan_element IN OUT NOCOPY plan_element_rec_type,
146: x_return_status OUT NOCOPY VARCHAR2,
139: -- End of comments
140: PROCEDURE update_plan_element (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: p_commit IN VARCHAR2 := fnd_api.g_false,
144: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
145: p_plan_element IN OUT NOCOPY plan_element_rec_type,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
140: PROCEDURE update_plan_element (
141: p_api_version IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
143: p_commit IN VARCHAR2 := fnd_api.g_false,
144: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
145: p_plan_element IN OUT NOCOPY plan_element_rec_type,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2
155: -- Pre-reqs : None.
156: -- Parameters :
157: -- IN : p_api_version IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional
159: -- Default = FND_API.G_FALSE
160: -- p_commit IN VARCHAR2 Optional
161: -- Default = FND_API.G_FALSE
162: -- p_validation_level IN NUMBER Optional
163: -- Default = FND_API.G_VALID_LEVEL_FULL
157: -- IN : p_api_version IN NUMBER Required
158: -- p_init_msg_list IN VARCHAR2 Optional
159: -- Default = FND_API.G_FALSE
160: -- p_commit IN VARCHAR2 Optional
161: -- Default = FND_API.G_FALSE
162: -- p_validation_level IN NUMBER Optional
163: -- Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_plan_element IN plan_element_rec_type
165: -- OUT : x_return_status OUT VARCHAR2(1)
159: -- Default = FND_API.G_FALSE
160: -- p_commit IN VARCHAR2 Optional
161: -- Default = FND_API.G_FALSE
162: -- p_validation_level IN NUMBER Optional
163: -- Default = FND_API.G_VALID_LEVEL_FULL
164: -- p_plan_element IN plan_element_rec_type
165: -- OUT : x_return_status OUT VARCHAR2(1)
166: -- x_msg_count OUT NUMBER
167: -- x_msg_data OUT VARCHAR2(2000)
170: --
171: -- End of comments
172: PROCEDURE delete_plan_element (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_plan_element IN OUT NOCOPY plan_element_rec_type,
178: x_return_status OUT NOCOPY VARCHAR2,
171: -- End of comments
172: PROCEDURE delete_plan_element (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_plan_element IN OUT NOCOPY plan_element_rec_type,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
172: PROCEDURE delete_plan_element (
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
175: p_commit IN VARCHAR2 := fnd_api.g_false,
176: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
177: p_plan_element IN OUT NOCOPY plan_element_rec_type,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2
206: -- Pre-reqs : None.
207: -- Parameters :
208: -- IN : p_api_version IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
208: -- IN : p_api_version IN NUMBER Required
209: -- p_init_msg_list IN VARCHAR2 Optional
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_plan_element IN plan_element_rec_type
216: -- OUT : x_return_status OUT VARCHAR2(1)
210: -- Default = FND_API.G_FALSE
211: -- p_commit IN VARCHAR2 Optional
212: -- Default = FND_API.G_FALSE
213: -- p_validation_level IN NUMBER Optional
214: -- Default = FND_API.G_VALID_LEVEL_FULL
215: -- p_plan_element IN plan_element_rec_type
216: -- OUT : x_return_status OUT VARCHAR2(1)
217: -- x_msg_count OUT NUMBER
218: -- x_msg_data OUT VARCHAR2(2000)
221: --
222: -- End of comments
223: PROCEDURE validate_plan_element (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
228: p_action IN VARCHAR2,
229: p_plan_element IN OUT NOCOPY plan_element_rec_type,
222: -- End of comments
223: PROCEDURE validate_plan_element (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
228: p_action IN VARCHAR2,
229: p_plan_element IN OUT NOCOPY plan_element_rec_type,
230: p_old_plan_element IN plan_element_rec_type := NULL,
223: PROCEDURE validate_plan_element (
224: p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
226: p_commit IN VARCHAR2 := fnd_api.g_false,
227: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
228: p_action IN VARCHAR2,
229: p_plan_element IN OUT NOCOPY plan_element_rec_type,
230: p_old_plan_element IN plan_element_rec_type := NULL,
231: x_return_status OUT NOCOPY VARCHAR2,
240: -- Pre-reqs : None.
241: -- Parameters :
242: -- IN : p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level IN NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
242: -- IN : p_api_version IN NUMBER Required
243: -- p_init_msg_list IN VARCHAR2 Optional
244: -- Default = FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level IN NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_comp_plan_id IN NUMBER
250: -- p_quota_id IN NUMBER
244: -- Default = FND_API.G_FALSE
245: -- p_commit IN VARCHAR2 Optional
246: -- Default = FND_API.G_FALSE
247: -- p_validation_level IN NUMBER Optional
248: -- Default = FND_API.G_VALID_LEVEL_FULL
249: -- p_comp_plan_id IN NUMBER
250: -- p_quota_id IN NUMBER
251: -- x_status_code OUT VARCHAR2(30)
252: -- OUT : x_return_status OUT VARCHAR2(1)
257: --
258: -- End of comments
259: PROCEDURE validate_plan_element (
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
262: p_commit IN VARCHAR2 := fnd_api.g_false,
263: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
264: p_comp_plan_id IN NUMBER := NULL,
265: p_quota_id IN NUMBER,
258: -- End of comments
259: PROCEDURE validate_plan_element (
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
262: p_commit IN VARCHAR2 := fnd_api.g_false,
263: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
264: p_comp_plan_id IN NUMBER := NULL,
265: p_quota_id IN NUMBER,
266: x_status_code OUT NOCOPY VARCHAR2,
259: PROCEDURE validate_plan_element (
260: p_api_version IN NUMBER,
261: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
262: p_commit IN VARCHAR2 := fnd_api.g_false,
263: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
264: p_comp_plan_id IN NUMBER := NULL,
265: p_quota_id IN NUMBER,
266: x_status_code OUT NOCOPY VARCHAR2,
267: x_return_status OUT NOCOPY VARCHAR2,