The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT PAGE_CONTENT_ID
FROM PA_PAGE_CONTENTS
WHERE OBJECT_TYPE = P_OBJECT_TYPE
AND NVL(PK1_VALUE,0) = NVL(P_PK1_VALUE,0)
AND NVL(PK2_VALUE,0) = NVL(P_PK2_VALUE,0)
AND NVL(PK3_VALUE,0) = NVL(P_PK3_VALUE,0)
AND NVL(PK4_VALUE,0) = NVL(P_PK4_VALUE,0)
AND NVL(PK5_VALUE,0) = NVL(P_PK5_VALUE,0);
procedure DELETE_PAGE_CONTENTS (
p_api_version IN NUMBER := 1.0
,p_init_msg_list IN VARCHAR2 := fnd_api.g_true
,p_commit IN VARCHAR2 := FND_API.g_false
,p_validate_only IN VARCHAR2 := FND_API.g_true
,p_max_msg_count IN NUMBER := FND_API.g_miss_num
,P_PAGE_CONTENT_ID IN NUMBER :=NULL
,P_OBJECT_TYPE IN VARCHAR2 :=NULL
,P_PK1_VALUE IN VARCHAR2 :=NULL
,P_PK2_VALUE IN VARCHAR2 :=NULL
,P_PK3_VALUE IN VARCHAR2 :=NULL
,P_PK4_VALUE IN VARCHAR2 :=NULL
,P_PK5_VALUE IN VARCHAR2 :=NULL
-- ,x_page_content_id OUT NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) is
l_rowid ROWID;
SELECT PAGE_CONTENT_ID
FROM PA_PAGE_CONTENTS
WHERE OBJECT_TYPE = P_OBJECT_TYPE
AND NVL(PK1_VALUE,0) = NVL(P_PK1_VALUE,0)
AND NVL(PK2_VALUE,0) = NVL(P_PK2_VALUE,0)
AND NVL(PK3_VALUE,0) = NVL(P_PK3_VALUE,0)
AND NVL(PK4_VALUE,0) = NVL(P_PK4_VALUE,0)
AND NVL(PK5_VALUE,0) = NVL(P_PK5_VALUE,0);
PA_DEBUG.init_err_stack('PA_PAGE_CONTENTS_PUB.Delete_Page_Contents');
PA_PAGE_CONTENTS_PVT.DELETE_PAGE_CONTENTS (
p_api_version
,p_init_msg_list
,p_commit
,p_validate_only
,p_max_msg_count
,l_content_id
,x_return_status
,x_msg_count
,x_msg_data);
FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_CONTENTS_PUB.DELETE_PAGE_CONTENTS'
,p_procedure_name => PA_DEBUG.G_Err_Stack );
end DELETE_PAGE_CONTENTS;