DBA Data[Home] [Help]

APPS.AMS_ACTDELVMETHOD_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 48

	SELECT ams_act_delivery_methods_s.NEXTVAL
	FROM dual;
Line: 100

	INSERT INTO AMS_ACT_DELIVERY_METHODS
	(activity_delivery_method_id,
	-- standard who columns
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
	last_update_login,
	-- other columns
	object_version_number,
	act_delivery_method_used_by_id,
	arc_act_delivery_used_by,
	delivery_media_type_code,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15
	)
	VALUES
	(
	l_act_DelvMethod_rec.activity_delivery_method_id,
	-- standard who columns
	sysdate,
	FND_GLOBAL.User_Id,
	sysdate,
	FND_GLOBAL.User_Id,
	FND_GLOBAL.Conc_Login_Id,
	1,  -- object_version_number
	l_act_DelvMethod_rec.act_delivery_method_used_by_id,
	l_act_DelvMethod_rec.arc_act_delivery_used_by,
	l_act_DelvMethod_rec.delivery_media_type_code,
	l_act_DelvMethod_rec.attribute_category,
	l_act_DelvMethod_rec.attribute1,
	l_act_DelvMethod_rec.attribute2,
	l_act_DelvMethod_rec.attribute3,
	l_act_DelvMethod_rec.attribute4,
	l_act_DelvMethod_rec.attribute5,
	l_act_DelvMethod_rec.attribute6,
	l_act_DelvMethod_rec.attribute7,
	l_act_DelvMethod_rec.attribute8,
	l_act_DelvMethod_rec.attribute9,
	l_act_DelvMethod_rec.attribute10,
	l_act_DelvMethod_rec.attribute11,
	l_act_DelvMethod_rec.attribute12,
	l_act_DelvMethod_rec.attribute13,
	l_act_DelvMethod_rec.attribute14,
	l_act_DelvMethod_rec.attribute15
	);
Line: 219

PROCEDURE Update_Act_DelvMethod
( p_api_version		IN	NUMBER,
  p_init_msg_list		IN	VARCHAR2	:= FND_API.G_FALSE,
  p_commit			IN	VARCHAR2	:= FND_API.G_FALSE,
  p_validation_level	IN	NUMBER	:= FND_API.G_VALID_LEVEL_FULL,
  x_return_status	 OUT NOCOPY VARCHAR2,
  x_msg_count		 OUT NOCOPY NUMBER,
  x_msg_data		 OUT NOCOPY VARCHAR2,
  p_act_DelvMethod_rec	IN	act_DelvMethod_rec_type
) IS
        l_api_name			CONSTANT VARCHAR2(30)  := 'Update_Act_DelvMethod';
Line: 236

        SAVEPOINT Update_Act_DelvMethod_PVT;
Line: 267

		  p_validation_mode 	=> JTF_PLSQL_API.g_update,
		  x_return_status		=> l_return_status
		);
Line: 281

	update AMS_ACT_DELIVERY_METHODS
	set
		last_update_date = sysdate
		,last_updated_by =  FND_GLOBAL.User_Id
		,last_update_login = FND_GLOBAL.Conc_Login_Id
		,object_version_number = l_act_DelvMethod_rec.object_version_number+1
		,act_delivery_method_used_by_id = l_act_DelvMethod_rec.act_delivery_method_used_by_id
		,arc_act_delivery_used_by = l_act_DelvMethod_rec.arc_act_delivery_used_by
		,delivery_media_type_code = l_act_DelvMethod_rec.delivery_media_type_code
		,attribute_category = l_act_DelvMethod_rec.attribute_category
		,attribute1 = l_act_DelvMethod_rec.attribute1
		,attribute2 = l_act_DelvMethod_rec.attribute2
		,attribute3 = l_act_DelvMethod_rec.attribute3
		,attribute4 = l_act_DelvMethod_rec.attribute4
		,attribute5 = l_act_DelvMethod_rec.attribute5
		,attribute6 = l_act_DelvMethod_rec.attribute6
		,attribute7 = l_act_DelvMethod_rec.attribute7
		,attribute8 = l_act_DelvMethod_rec.attribute8
		,attribute9 = l_act_DelvMethod_rec.attribute9
		,attribute10 = l_act_DelvMethod_rec.attribute10
		,attribute11 = l_act_DelvMethod_rec.attribute11
		,attribute12 = l_act_DelvMethod_rec.attribute12
		,attribute13 = l_act_DelvMethod_rec.attribute13
		,attribute14 = l_act_DelvMethod_rec.attribute14
		,attribute15 = l_act_DelvMethod_rec.attribute15
	where activity_delivery_method_id = l_act_DelvMethod_rec.activity_delivery_method_id
       and object_version_number = l_act_DelvMethod_rec.object_version_number;
Line: 335

	        ROLLBACK TO Update_Act_DelvMethod_PVT;
Line: 343

	        ROLLBACK TO Update_Act_DelvMethod_PVT;
Line: 351

	        ROLLBACK TO Update_Act_DelvMethod_PVT;
Line: 362

END Update_Act_DelvMethod;
Line: 375

PROCEDURE Delete_Act_DelvMethod
( p_api_version		IN     NUMBER,
  p_init_msg_list		IN     VARCHAR2	:= FND_API.G_FALSE,
  p_commit			IN     VARCHAR2	:= FND_API.G_FALSE,
  p_validation_level	IN     NUMBER		:= FND_API.G_VALID_LEVEL_FULL,
  x_return_status	 OUT NOCOPY    VARCHAR2,
  x_msg_count		 OUT NOCOPY    NUMBER,
  x_msg_data		 OUT NOCOPY    VARCHAR2,
  p_act_DelvMethod_id		IN     NUMBER,
  p_object_version       IN     NUMBER
) IS
        l_api_name		CONSTANT VARCHAR2(30)  := 'Delete_Act_DelvMethod';
Line: 393

        SAVEPOINT Delete_Act_DelvMethod_PVT;
Line: 413

		-- Delete header data
		DELETE FROM AMS_ACT_DELIVERY_METHODS
		WHERE  activity_delivery_method_id = l_act_delivery_method_id
		  and  object_version_number = p_object_version;
Line: 444

	        ROLLBACK TO Delete_Act_DelvMethod_PVT;
Line: 452

	        ROLLBACK TO Delete_Act_DelvMethod_PVT;
Line: 460

	        ROLLBACK TO Delete_Act_DelvMethod_PVT;
Line: 471

END Delete_Act_DelvMethod;
Line: 501

    	SELECT activity_delivery_method_id
          FROM AMS_ACT_DELIVERY_METHODS
	 WHERE activity_delivery_method_id = p_act_delvmethod_id
	   and object_version_number = p_object_version
	   FOR UPDATE of activity_delivery_method_id NOWAIT;
Line: 792

		    AMS_Utility_PVT.debug_message(l_pk_value ||': insert B');
Line: 895

     x_act_DelvMethod_rec.last_update_date := FND_API.g_miss_date;
Line: 896

     x_act_DelvMethod_rec.last_updated_by := FND_API.g_miss_num;
Line: 899

     x_act_DelvMethod_rec.last_update_login := FND_API.g_miss_num;
Line: 927

	SELECT *
	FROM ams_act_delivery_methods
	WHERE activity_delivery_method_id = p_act_DelvMethod_rec.activity_delivery_method_id;