The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT A.*,B.CHAPTER,B.SECTION,B.SUBJECT,B.PAGE,B.FIGURE,B.NOTE
FROM AHL_DOC_TITLE_ASSOS_B a, AHL_DOC_TITLE_ASSOS_TL B
WHERE A.DOC_TITLE_ASSO_ID=B.DOC_TITLE_ASSO_ID
AND A.DOC_TITLE_ASSO_ID=C_DOC_TITLE_ASSO_ID
AND B.LANGUAGE=USERENV('LANG');
IF p_x_association_tbl(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
THEN
p_x_association_tbl(I).LAST_UPDATE_DATE:=NULL;
ELSIF p_x_association_tbl(I).LAST_UPDATE_DATE IS NULL
THEN
p_x_association_tbl(I).LAST_UPDATE_DATE:=l_doc_assos_rec.LAST_UPDATE_DATE;
IF p_x_association_tbl(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM
THEN
p_x_association_tbl(I).LAST_UPDATED_BY:=NULL;
ELSIF p_x_association_tbl(I).LAST_UPDATED_BY IS NULL
THEN
p_x_association_tbl(I).LAST_UPDATED_BY:=l_doc_assos_rec.LAST_UPDATED_BY;
IF p_x_association_tbl(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
THEN
p_x_association_tbl(I).LAST_UPDATE_LOGIN:=NULL;
ELSIF p_x_association_tbl(I).LAST_UPDATE_LOGIN IS NULL
THEN
p_x_association_tbl(I).LAST_UPDATE_LOGIN:=l_doc_assos_rec.LAST_UPDATE_LOGIN;
SELECT lookup_code
FROM FND_LOOKUP_VALUES_VL
WHERE lookup_type= c_lookup_type
AND upper(meaning)=upper(c_meaning)
AND sysdate between NVL(start_date_active,sysdate)
AND nvl(end_date_active,sysdate);
SELECT a.document_id,
a.document_no,
a.doc_type_code,
a.doc_sub_type_code,
a.document_title,
b.doc_revision_id,
b.revision_no,
b.revision_status_code
FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b
WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
and upper(a.document_no)=upper(c_document_no);
SELECT count(a.document_no)
FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b
WHERE A.DOCUMENT_ID=B.DOCUMENT_ID(+)
and upper(a.document_no)=upper(c_document_no);
SELECT count(a.revision_no)
FROM AHL_DOC_REVISIONS_B a
WHERE upper(a.revision_no)=upper(c_revision_no);
SELECT count(a.document_no)
FROM AHL_DOCUMENTS_B a,AHL_DOC_REVISIONS_B b
WHERE upper(a.document_no)=upper(c_document_no)
and a.document_id=b.document_id;
SELECT a.document_id,
a.document_no,
a.doc_type_code,
a.doc_sub_type_code,
a.document_title,
b.doc_revision_id,
b.revision_no,
b.revision_status_code
FROM ahl_documents_vl a ,AHL_DOC_REVISIONS_B b
WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
and A.DOCUMENT_no=c_document_no
and b.revision_no=c_revision_no;
SELECT count(a.document_no) into l_counter3
FROM ahl_documents_b a ,AHL_DOC_REVISIONS_B b
WHERE A.DOCUMENT_ID=B.DOCUMENT_ID
AND upper(a.document_no)=upper(p_x_association_tbl(i).document_no);
FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
AHL_DEBUG_PUB.debug( 'Select document from lov');
FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');
SELECT REVISION_STATUS_CODE,
OBSOLETE_DATE,
REVISION_NO
FROM AHL_DOC_REVISIONS_B
WHERE DOC_REVISION_ID = c_doc_revision_id;
SELECT lookup_code
FROM FND_LOOKUP_VALUES_VL
WHERE lookup_code = c_aso_object_type_code
AND lookup_type = 'AHL_OBJECT_TYPE'
AND sysdate between start_date_active
AND nvl(end_date_active,sysdate);
SELECT document_id,
doc_revision_id,
use_latest_rev_flag,
aso_object_type_code,
aso_object_id
FROM AHL_DOC_TITLE_ASSOS_B
WHERE doc_title_asso_id = c_doc_title_asso_id;
SELECT 'X'
FROM AHL_DOCUMENTS_B
WHERE document_id = c_document_id;
SELECT document_no
FROM AHL_DOCUMENTS_B
WHERE document_id = c_document_id;
SELECT revision_status_code
FROM ahl_operations_b
WHERE operation_id = c_operation_id;
SELECT revision_status_code
FROM ahl_routes_b
WHERE route_id = c_route_id;
SELECT DOC_TITLE_ASSO_ID,aso_object_id,aso_object_type_code,document_id,doc_revision_id
FROM AHL_DOC_TITLE_ASSOS_vl
WHERE aso_object_id = nvl(c_aso_object_id,0)
AND NVL(aso_object_type_code,'X') = NVL(c_aso_object_type_code,'X')
AND document_id = nvl(c_document_id,0)
AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)
AND NVL(SOURCE_REF_CODE,'X')=NVL(C_SOURCE_REF_CODE,'X')
AND NVL(SERIAL_NO,'X')=NVL(C_SERIAL_NO,'X')
AND NVL(chapter,'X') =NVL(c_chapter,'X')
AND NVL(section,'X') =NVL(c_section,'X')
AND NVL(subject,'X') =NVL(c_subject,'X')
AND NVL(page,'X') =NVL(c_page,'X')
AND NVL(figure,'X') =NVL(c_figure,'X');
SELECT *
FROM AHL_DOC_TITLE_ASSOS_B
WHERE aso_object_id=c_aso_object_id
AND aso_object_type_code=c_aso_object_type_code
AND document_id=c_document_id
AND use_latest_rev_flag<>nvl(c_use_latest_rev_flag,'X')
AND DOC_TITLE_ASSO_ID <> NVL(C_DOC_TITLE_ASSO_ID,0);
SELECT TYPE_CODE INTO l_type_code
FROM AHL_MR_HEADERS_B
WHERE MR_HEADER_ID=p_association_rec.ASO_OBJECT_ID;
SELECT count(*) into l_counter1
FROM AHL_DOC_TITLE_ASSOS_B
WHERE aso_object_id=nvl(p_association_rec.aso_object_id,0)
AND aso_object_type_code=nvl(p_association_rec.aso_object_type_code,'x')
AND document_id=nvl(p_association_rec.document_id,0)
AND nvl(use_latest_rev_flag,'N')='Y'
AND NVL(p_association_rec.DOC_TITLE_ASSO_ID,0)=0;
SELECT count(*) into l_counter
FROM AHL_DOC_TITLE_ASSOS_B
WHERE aso_object_id=nvl(p_association_rec.aso_object_id,0)
AND aso_object_type_code=nvl(p_association_rec.aso_object_type_code,'x')
AND document_id=nvl(p_association_rec.document_id,0)
AND use_latest_rev_flag<>NVL(p_association_rec.use_latest_rev_flag,'N');
SELECT DOC_TITLE_ASSO_ID
FROM AHL_DOC_TITLE_ASSOS_vl
WHERE aso_object_id = nvl(c_aso_object_id,0)
AND NVL(aso_object_type_code,'X') = NVL(c_aso_object_type_code,'X')
AND document_id = nvl(c_document_id,0)
AND nvl(doc_revision_id,0) = nvl(c_doc_revision_id,0)
AND NVL(SOURCE_REF_CODE,'X')=NVL(C_SOURCE_REF_CODE,'X')
AND NVL(SERIAL_NO,'X')=NVL(C_SERIAL_NO,'X')
AND NVL(chapter,'X') =NVL(c_chapter,'X')
AND NVL(section,'X') =NVL(c_section,'X')
AND NVL(subject,'X') =NVL(c_subject,'X')
AND NVL(page,'X') =NVL(c_page,'X')
AND NVL(figure,'X') =NVL(c_figure,'X');
delete from AHL_DOC_TITLE_ASSOS_TL
where DOC_TITLE_ASSO_ID = p_x_association_tbl(I).DOC_TITLE_ASSO_ID;
delete from AHL_DOC_TITLE_ASSOS_B
where DOC_TITLE_ASSO_ID = p_x_association_tbl(I).DOC_TITLE_ASSO_ID
and OBJECT_VERSION_NUMBER=p_x_association_tbl(I).OBJECT_VERSION_NUMBER;
update AHL_DOC_TITLE_ASSOS_B set
SERIAL_NO = p_x_association_tbl(i).SERIAL_NO,
ATTRIBUTE_CATEGORY = p_x_association_tbl(i).ATTRIBUTE_CATEGORY,
ATTRIBUTE1 = p_x_association_tbl(i).ATTRIBUTE1,
ATTRIBUTE2 = p_x_association_tbl(i).ATTRIBUTE2,
ATTRIBUTE3 = p_x_association_tbl(i).ATTRIBUTE3,
ATTRIBUTE4 = p_x_association_tbl(i).ATTRIBUTE4,
ATTRIBUTE5 = p_x_association_tbl(i).ATTRIBUTE5,
ATTRIBUTE6 = p_x_association_tbl(i).ATTRIBUTE6,
ATTRIBUTE7 = p_x_association_tbl(i).ATTRIBUTE7,
ATTRIBUTE8 = p_x_association_tbl(i).ATTRIBUTE8,
ATTRIBUTE9 = p_x_association_tbl(i).ATTRIBUTE9,
ATTRIBUTE10 = p_x_association_tbl(i).ATTRIBUTE10,
ATTRIBUTE11 = p_x_association_tbl(i).ATTRIBUTE11,
ATTRIBUTE12 = p_x_association_tbl(i).ATTRIBUTE12,
ATTRIBUTE13 = p_x_association_tbl(i).ATTRIBUTE13,
ATTRIBUTE14 = p_x_association_tbl(i).ATTRIBUTE14,
ATTRIBUTE15 = p_x_association_tbl(i).ATTRIBUTE15,
ASO_OBJECT_TYPE_CODE = p_x_association_tbl(i).ASO_OBJECT_TYPE_CODE,
SOURCE_REF_CODE = p_x_association_tbl(i).SOURCE_REF_CODE,
ASO_OBJECT_ID = p_x_association_tbl(i).ASO_OBJECT_ID,
DOCUMENT_ID = p_x_association_tbl(i).DOCUMENT_ID,
USE_LATEST_REV_FLAG= p_x_association_tbl(i).USE_LATEST_REV_FLAG,
DOC_REVISION_ID = p_x_association_tbl(i).DOC_REVISION_ID,
OBJECT_VERSION_NUMBER = p_x_association_tbl(i).OBJECT_VERSION_NUMBER+1,
LAST_UPDATE_DATE =SYSDATE,
LAST_UPDATED_BY =fnd_global.user_id,
LAST_UPDATE_LOGIN =fnd_global.user_id
where DOC_TITLE_ASSO_ID = p_x_association_tbl(i).DOC_TITLE_ASSO_ID
and OBJECT_VERSION_NUMBER=p_x_association_tbl(I).OBJECT_VERSION_NUMBER;
update AHL_DOC_TITLE_ASSOS_TL set
CHAPTER = p_x_association_tbl(i).CHAPTER,
SECTION = p_x_association_tbl(i).SECTION,
SUBJECT = p_x_association_tbl(i).SUBJECT,
FIGURE = p_x_association_tbl(i).FIGURE,
PAGE = p_x_association_tbl(i).PAGE,
NOTE = p_x_association_tbl(i).NOTE,
LAST_UPDATE_DATE = p_x_association_tbl(i).LAST_UPDATE_DATE,
LAST_UPDATED_BY = p_x_association_tbl(i).LAST_UPDATED_BY,
LAST_UPDATE_LOGIN = p_x_association_tbl(i).LAST_UPDATE_LOGIN,
SOURCE_LANG = userenv('LANG')
where DOC_TITLE_ASSO_ID = p_x_association_tbl(i).DOC_TITLE_ASSO_ID
and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
p_x_association_tbl(i).doc_title_asso_id from DUAL;
AHL_DOC_TITLE_ASSOS_PKG.INSERT_ROW(
X_ROWID =>l_rowid,
X_DOC_TITLE_ASSO_ID =>p_x_association_tbl(i).doc_title_asso_id,
X_SERIAL_NO =>p_x_association_tbl(i).serial_no,
X_ATTRIBUTE_CATEGORY =>p_x_association_tbl(i).attribute_category,
X_ATTRIBUTE1 =>p_x_association_tbl(i).attribute1,
X_ATTRIBUTE2 =>p_x_association_tbl(i).attribute2,
X_ATTRIBUTE3 =>p_x_association_tbl(i).attribute3,
X_ATTRIBUTE4 =>p_x_association_tbl(i).attribute4,
X_ATTRIBUTE5 =>p_x_association_tbl(i).attribute5,
X_ATTRIBUTE6 =>p_x_association_tbl(i).attribute6,
X_ATTRIBUTE7 =>p_x_association_tbl(i).attribute7,
X_ATTRIBUTE8 => p_x_association_tbl(i).attribute8,
X_ATTRIBUTE9 =>p_x_association_tbl(i).attribute9,
X_ATTRIBUTE10 =>p_x_association_tbl(i).attribute10,
X_ATTRIBUTE11 =>p_x_association_tbl(i).attribute11,
X_ATTRIBUTE12 =>p_x_association_tbl(i).attribute12,
X_ATTRIBUTE13 =>p_x_association_tbl(i).attribute13,
X_ATTRIBUTE14 =>p_x_association_tbl(i).attribute14,
X_ATTRIBUTE15 => p_x_association_tbl(i).attribute15,
X_ASO_OBJECT_TYPE_CODE => p_x_association_tbl(i).aso_object_type_code,
X_SOURCE_REF_CODE => p_x_association_tbl(i).SOURCE_REF_CODE,
X_ASO_OBJECT_ID => p_x_association_tbl(i).aso_object_id,
X_DOCUMENT_ID => p_x_association_tbl(i).document_id,
X_USE_LATEST_REV_FLAG =>nvl(p_x_association_tbl(i).use_latest_rev_flag,'N'),
X_DOC_REVISION_ID => p_x_association_tbl(i).doc_revision_id,
X_OBJECT_VERSION_NUMBER => 1,
X_CHAPTER => p_x_association_tbl(i).chapter,
X_SECTION => p_x_association_tbl(i).section,
X_SUBJECT => p_x_association_tbl(i).subject,
X_FIGURE => p_x_association_tbl(i).figure,
X_PAGE => p_x_association_tbl(i).page,
X_NOTE => p_x_association_tbl(i).note,
X_CREATION_DATE => sysdate,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_DATE => sysdate,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.login_id);