APPS.AMW_OBJECT_ASSESSMENTS_PVT SQL Statements

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

Line: 21

	SELECT 1 INTO l_dummy
	FROM amw_object_assessments
	WHERE assessment_id = p_assessment_id
	AND object_type = p_object_type;

Line: 85

		UPDATE amw_object_assessments apa
		SET apa.assessment_id      = p_assessment_id
		WHERE apa.pk1              = p_certification_id
		AND  apa.pk2               = p_org_id
		AND  apa.pk3               = p_process_id
                AND  apa.object_type       = p_object_type;

Line: 92

		INSERT INTO amw_object_assessments (
			object_assessment_id,
			assessment_id,
                        object_type,
			pk1,
			pk2,
			pk3,
			last_update_date,
			last_updated_by,
			creation_date,
			created_by,
			last_update_login,
			object_version_number)
		SELECT 	amw_object_assessments_s.nextval,
			p_assessment_id,
                        p_object_type,
			p_certification_id,
			p_org_id,
			p_process_id,
			sysdate,
			fnd_global.user_id,
			sysdate,
			fnd_global.user_id,
			fnd_global.user_id,
			1
		FROM dual
		WHERE NOT EXISTS
			  (SELECT 'Y' FROM amw_object_assessments
			   WHERE pk1     = p_certification_id
			   AND pk2       = p_org_id
			   AND pk3       = p_process_id
               AND object_type = 'PROCESS'
			  );

Line: 141

PROCEDURE update_object_assessment
(
 p_api_version_number   IN NUMBER   := 1.0,
 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,
 p_object_type          IN VARCHAR2,
 p_assessment_id	IN NUMBER,
 p_certification_id	IN NUMBER,
 p_org_id	        IN NUMBER,
 p_process_id		IN NUMBER,
 x_return_status        OUT nocopy VARCHAR2,
 x_msg_count            OUT nocopy NUMBER,
 x_msg_data             OUT nocopy VARCHAR2
)
IS

l_api_name           CONSTANT VARCHAR2(30) := 'update_object_assessment';

Line: 167

	SAVEPOINT UPDATE_OBJECT;

Line: 189

		UPDATE amw_object_assessments apa
		SET apa.assessment_id      = p_assessment_id
		WHERE apa.pk1              = p_certification_id
		AND  apa.pk2               = p_org_id
		AND  apa.pk3               = p_process_id
                AND  apa.object_type       = p_object_type;

Line: 198

	ROLLBACK TO UPDATE_OBJECT;

Line: 208

END update_object_assessment;

Line: 257

		DELETE FROM amw_object_assessments apa
		WHERE apa.pk1              = p_certification_id
		AND  apa.pk2               = p_org_id
		AND  apa.pk3               = p_process_id
                AND  apa.object_type       = p_object_type;