[Home] [Help]
47: CURSOR C_act_delivery_method_id IS
48: SELECT ams_act_delivery_methods_s.NEXTVAL
49: FROM dual;
50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT Create_Act_DelvMethod_PVT;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version,
55: p_api_version,
49: FROM dual;
50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT Create_Act_DelvMethod_PVT;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call ( l_api_version,
55: p_api_version,
56: l_api_name,
57: G_PACKAGE_NAME)
98: FETCH c_act_delivery_method_id INTO l_act_DelvMethod_rec.activity_delivery_method_id;
99: CLOSE c_act_delivery_method_id;
100: INSERT INTO AMS_ACT_DELIVERY_METHODS
101: (activity_delivery_method_id,
102: -- standard who columns
103: last_update_date,
104: last_updated_by,
105: creation_date,
106: created_by,
129: )
130: VALUES
131: (
132: l_act_DelvMethod_rec.activity_delivery_method_id,
133: -- standard who columns
134: sysdate,
135: FND_GLOBAL.User_Id,
136: sysdate,
137: FND_GLOBAL.User_Id,
161: x_act_delvmethod_id := l_act_DelvMethod_rec.activity_delivery_method_id;
162: --
163: -- END of API body.
164: --
165: -- Standard check of p_commit.
166: IF FND_API.To_Boolean ( p_commit )
167: THEN
168: COMMIT WORK;
169: END IF;
166: IF FND_API.To_Boolean ( p_commit )
167: THEN
168: COMMIT WORK;
169: END IF;
170: -- Standard call to get message count AND IF count is 1, get message info.
171: FND_MSG_PUB.Count_AND_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data,
174: p_encoded => FND_API.G_FALSE
231: -- Status Local Variables
232: l_return_status VARCHAR2(1); -- Return value from procedures
233: l_act_DelvMethod_rec act_DelvMethod_rec_type;
234: BEGIN
235: -- Standard Start of API savepoint
236: SAVEPOINT Update_Act_DelvMethod_PVT;
237: -- Standard call to check for call compatibility.
238: IF NOT FND_API.Compatible_API_Call ( l_api_version,
239: p_api_version,
233: l_act_DelvMethod_rec act_DelvMethod_rec_type;
234: BEGIN
235: -- Standard Start of API savepoint
236: SAVEPOINT Update_Act_DelvMethod_PVT;
237: -- Standard call to check for call compatibility.
238: IF NOT FND_API.Compatible_API_Call ( l_api_version,
239: p_api_version,
240: l_api_name,
241: G_PACKAGE_NAME)
318: END IF;
319: --
320: -- END of API body.
321: --
322: -- Standard check of p_commit.
323: IF FND_API.To_Boolean ( p_commit )
324: THEN
325: COMMIT WORK;
326: END IF;
323: IF FND_API.To_Boolean ( p_commit )
324: THEN
325: COMMIT WORK;
326: END IF;
327: -- Standard call to get message count AND IF count is 1, get message info.
328: FND_MSG_PUB.Count_AND_Get
329: ( p_count => x_msg_count,
330: p_data => x_msg_data,
331: p_encoded => FND_API.G_FALSE
388: -- Status Local Variables
389: l_return_status VARCHAR2(1); -- Return value from procedures
390: l_act_delivery_method_id NUMBER := p_act_DelvMethod_id;
391: BEGIN
392: -- Standard Start of API savepoint
393: SAVEPOINT Delete_Act_DelvMethod_PVT;
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call ( l_api_version,
396: p_api_version,
390: l_act_delivery_method_id NUMBER := p_act_DelvMethod_id;
391: BEGIN
392: -- Standard Start of API savepoint
393: SAVEPOINT Delete_Act_DelvMethod_PVT;
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call ( l_api_version,
396: p_api_version,
397: l_api_name,
398: G_PACKAGE_NAME)
427: END IF;
428: --
429: -- END of API body.
430: --
431: -- Standard check of p_commit.
432: IF FND_API.To_Boolean ( p_commit )
433: THEN
434: COMMIT WORK;
435: END IF;
432: IF FND_API.To_Boolean ( p_commit )
433: THEN
434: COMMIT WORK;
435: END IF;
436: -- Standard call to get message count AND IF count is 1, get message info.
437: FND_MSG_PUB.Count_AND_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data,
440: p_encoded => FND_API.G_FALSE
503: WHERE activity_delivery_method_id = p_act_delvmethod_id
504: and object_version_number = p_object_version
505: FOR UPDATE of activity_delivery_method_id NOWAIT;
506: BEGIN
507: -- Standard call to check for call compatibility.
508: IF NOT FND_API.Compatible_API_Call ( l_api_version,
509: p_api_version,
510: l_api_name,
511: G_PACKAGE_NAME)
539: CLOSE c_act_delivery_method;
540: --
541: -- END of API body.
542: --
543: -- Standard call to get message count AND IF count is 1, get message info.
544: FND_MSG_PUB.Count_AND_Get
545: ( p_count => x_msg_count,
546: p_data => x_msg_data,
547: p_encoded => FND_API.G_FALSE
613: l_act_DelvMethod_rec act_DelvMethod_rec_type := p_act_DelvMethod_rec;
614: l_default_act_DelvMethod_rec act_DelvMethod_rec_type;
615: l_act_delivery_method_id NUMBER;
616: BEGIN
617: -- Standard call to check for call compatibility.
618: IF NOT FND_API.Compatible_API_Call ( l_api_version,
619: p_api_version,
620: l_api_name,
621: G_PACKAGE_NAME)
860: l_api_version CONSTANT NUMBER := 1.0;
861: -- Status Local Variables
862: l_return_status VARCHAR2(1); -- Return value from procedures
863: BEGIN
864: -- Standard call to check for call compatibility.
865: IF NOT FND_API.Compatible_API_Call ( l_api_version,
866: l_api_version,
867: l_api_name,
868: G_PACKAGE_NAME)