[Home] [Help]
15: --
16: -- History:
17: -- 03-OCT-2010 kmaddi o Created
18: -- 09-APR-2011 pstawar Interface Repository Annotation
19: -- Standards are incorporated.
20:
21: -- Procedure to create a new index rent
22: PROCEDURE CREATE_INDEX_RENT
23: (
43:
44: BEGIN
45:
46:
47: -- Standard start of API savepoint
48:
49: SAVEPOINT CREATE_INDEX_RENT;
50: -- Initialize API return status to success
51:
58: THEN
59: fnd_msg_pub.initialize;
60: END IF;
61:
62: -- Standard call to check for call compatibility
63: IF NOT fnd_api.compatible_api_call (l_api_version
64: , p_api_version
65: , l_api_name
66: , g_pkg_name
218: , x_return_status => x_return_status
219: , x_msg_count => x_msg_count
220: , x_msg_data => x_msg_data
221: );
222: -- Standard check of p_commit
223: IF fnd_api.to_boolean (p_commit)
224: THEN
225: COMMIT WORK;
226: END IF;
309: --
310: -- History:
311: -- 03-OCT-2010 kmaddi o Created
312: -- 09-APR-2011 pstawar Interface Repository Annotation
313: -- Standards are incorporated.
314:
315: -- Procedure to update a index rent
316: PROCEDURE UPDATE_INDEX_RENT(
317: p_api_version IN NUMBER
333: || l_api_name;
334: l_func_name CONSTANT VARCHAR2 (100) := 'PN_INDEX_RENT_PVT.UPDATE_INDEX_RENT';
335:
336: BEGIN
337: -- Standard start of API savepoint
338: SAVEPOINT UPDATE_INDEX_RENT;
339:
340: --Added to clear message cache in case of API call wrong version.
341:
344: THEN
345: fnd_msg_pub.initialize;
346: END IF;
347:
348: -- Standard call to check for call compatibility
349: IF NOT fnd_api.compatible_api_call (l_api_version
350: , p_api_version
351: , l_api_name
352: , g_pkg_name
442: , x_msg_count => x_msg_count
443: , x_msg_data => x_msg_data
444: );
445:
446: -- Standard check of p_commit
447: IF fnd_api.to_boolean (p_commit)
448: THEN
449: COMMIT WORK;
450: END IF;