35:
36: IS
37: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Ps_Cndclses';
38: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
39: l_pvt_ps_cndclses_rec AMS_Ps_Cndclses_PVT.ps_cndclses_rec_type;
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_Ps_Cndclses_PUB;
43:
70: -- API body
71: --
72: -- Calling Private package: Create_Ps_Cndclses
73: -- Hint: Primary key needs to be returned
74: AMS_Ps_Cndclses_PVT.Create_Ps_Cndclses(
75: p_api_version_number => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
169: IS
170: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ps_Cndclses';
171: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
172: l_object_version_number NUMBER;
173: l_pvt_ps_cndclses_rec AMS_Ps_Cndclses_PVT.ps_cndclses_rec_type;
174: BEGIN
175: -- Standard Start of API savepoint
176: SAVEPOINT UPDATE_Ps_Cndclses_PUB;
177:
202:
203: --
204: -- API body
205: --
206: AMS_Ps_Cndclses_PVT.Update_Ps_Cndclses(
207: p_api_version_number => 1.0,
208: p_init_msg_list => FND_API.G_FALSE,
209: p_commit => p_commit,
210: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
300: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Ps_Cndclses';
301: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
302: l_CND_CLAUSE_ID NUMBER := p_CND_CLAUSE_ID;
303: l_object_version_number NUMBER := p_object_version_number;
304: l_pvt_ps_cndclses_rec AMS_Ps_Cndclses_PVT.ps_cndclses_rec_type;
305: BEGIN
306: -- Standard Start of API savepoint
307: SAVEPOINT DELETE_Ps_Cndclses_PUB;
308:
333:
334: --
335: -- API body
336: --
337: AMS_Ps_Cndclses_PVT.Delete_Ps_Cndclses(
338: p_api_version_number => 1.0,
339: p_init_msg_list => FND_API.G_FALSE,
340: p_commit => p_commit,
341: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
429:
430: IS
431: L_API_NAME CONSTANT VARCHAR2(30) := 'Lock_Ps_Cndclses';
432: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
433: l_pvt_ps_cndclses_rec AMS_Ps_Cndclses_PVT.ps_cndclses_rec_type;
434: BEGIN
435:
436: -- Standard call to check for call compatibility.
437: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
462: -- API body
463: --
464: -- Calling Private package: Create_Ps_Cndclses
465: -- Hint: Primary key needs to be returned
466: AMS_Ps_Cndclses_PVT.Lock_Ps_Cndclses(
467: p_api_version_number => 1.0,
468: p_init_msg_list => FND_API.G_FALSE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,