The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT source_code_id, source_code, arc_source_code_for, source_code_for_id
FROM ams_source_codes
WHERE arc_source_code_for = 'CAMP'
AND source_code = l_camp_result_Rec.source_code
AND source_code_for_id = l_camp_result_Rec.object_id;
INSERT INTO jtf_ih_campaigns_results
(result_id
,object_id
,object_version_number
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,object_type
,source_code_id
,source_code)
VALUES
(l_camp_result_Rec.result_id
,l_camp_result_Rec.object_id
,l_camp_result_Rec.object_version_number
,l_camp_result_Rec.created_by
,l_camp_result_Rec.creation_date
,l_camp_result_Rec.last_updated_by
,l_camp_result_Rec.last_update_date
,l_camp_result_Rec.last_update_login
,l_camp_result_Rec.object_type
,l_camp_result_Rec.source_code_id
,l_camp_result_Rec.source_code
);
PROCEDURE Delete_camp_result(
P_Api_Version_Number 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,
P_camp_result_Rec IN camp_result_Rec_Type,
X_Return_Status OUT VARCHAR2,
X_Msg_Count OUT NUMBER,
X_Msg_Data OUT VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'Delete_camp_result';
SAVEPOINT DELETE_camp_result_PVT;
DELETE FROM jtf_ih_campaigns_results
WHERE result_id = l_camp_result_Rec.result_id
AND source_code = l_camp_result_Rec.source_code
AND object_id = l_camp_result_Rec.object_id;
End Delete_camp_result;