34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37:
38: p_action_rec IN AMS_LISTACTION_PVT.action_rec_type,
39: x_action_id OUT NOCOPY NUMBER
40: ) IS
41:
42: l_api_name CONSTANT VARCHAR2(30) := 'Create_ListAction';
42: l_api_name CONSTANT VARCHAR2(30) := 'Create_ListAction';
43: l_api_version CONSTANT NUMBER := 1.0;
44:
45: l_return_status VARCHAR2(1); -- Return value from procedures
46: l_action_rec AMS_LISTACTION_PVT.action_rec_type := p_action_rec;
47: l_action_id NUMBER;
48: Begin
49:
50:
55: IF FND_API.to_boolean(p_init_msg_list) THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:
59: AMS_LISTACTION_PVT.Create_ListAction
60: ( p_api_version => p_api_version,
61: p_init_msg_list => FND_API.G_FALSE,
62: p_commit => FND_API.G_FALSE,
63: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154:
155: p_action_rec IN AMS_LISTACTION_PVT.action_rec_type
156: ) IS
157:
158: l_api_name CONSTANT VARCHAR2(30) := 'Update_ListAction';
159: l_api_version CONSTANT NUMBER := 1.0;
159: l_api_version CONSTANT NUMBER := 1.0;
160:
161: -- Status Local Variables
162: l_return_status VARCHAR2(1); -- Return value from procedures
163: l_action_rec AMS_LISTACTION_PVT.action_rec_type := p_action_rec;
164:
165: Begin
166:
167: SAVEPOINT update_listaction_pub;
171: IF FND_API.to_boolean(p_init_msg_list) THEN
172: FND_MSG_PUB.initialize;
173: END IF;
174:
175: AMS_LISTACTION_PVT.Update_ListAction
176: ( p_api_version => p_api_version,
177: p_init_msg_list => FND_API.G_FALSE,
178: p_commit => FND_API.G_FALSE,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
398: IF FND_API.to_boolean(p_init_msg_list) THEN
399: FND_MSG_PUB.initialize;
400: END IF;
401:
402: AMS_LISTACTION_PVT.Lock_ListAction
403: ( p_api_version => p_api_version,
404: p_init_msg_list => FND_API.G_FALSE,
405: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
406:
485: x_return_status OUT NOCOPY VARCHAR2,
486: x_msg_count OUT NOCOPY NUMBER,
487: x_msg_data OUT NOCOPY VARCHAR2,
488:
489: p_action_rec IN AMS_LISTACTION_PVT.action_rec_type
490: ) IS
491:
492: l_api_name CONSTANT VARCHAR2(30) := 'Validate_ListAction';
493: l_api_version CONSTANT NUMBER := 1.0;
493: l_api_version CONSTANT NUMBER := 1.0;
494:
495: -- Status Local Variables
496: l_return_status VARCHAR2(1); -- Return value from procedures
497: l_action_rec AMS_LISTACTION_PVT.action_rec_type := p_action_rec;
498:
499: BEGIN
500:
501: SAVEPOINT Validate_ListAction_pub;