eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_DI_ASSO_DOCASO_PVT SQL Statements

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

Line: 97


        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');

Line: 133


                IF p_x_association_tbl(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
                THEN
                p_x_association_tbl(I).LAST_UPDATE_DATE:=NULL;

Line: 136


                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;

Line: 141


                IF p_x_association_tbl(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM
                THEN
                        p_x_association_tbl(I).LAST_UPDATED_BY:=NULL;

Line: 144


                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;

Line: 164


                IF p_x_association_tbl(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
                THEN
                        p_x_association_tbl(I).LAST_UPDATE_LOGIN:=NULL;

Line: 167


                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;

Line: 415


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);

Line: 425


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);

Line: 441


   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);

Line: 448


   SELECT count(a.revision_no)
   FROM AHL_DOC_REVISIONS_B a
   WHERE upper(a.revision_no)=upper(c_revision_no);

Line: 454


   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;

Line: 462


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;

Line: 565


                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);

Line: 599


                                                FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

Line: 602


                                                        AHL_DEBUG_PUB.debug( 'Select document from lov');

Line: 678


                                               FND_MESSAGE.SET_NAME('AHL','AHL_DI_SELECT_FRM_LOV');

Line: 707


  SELECT REVISION_STATUS_CODE,
         OBSOLETE_DATE,
         REVISION_NO
   FROM  AHL_DOC_REVISIONS_B
   WHERE DOC_REVISION_ID = c_doc_revision_id;

Line: 720


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);

Line: 730


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;

Line: 741


 SELECT 'X'
  FROM AHL_DOCUMENTS_B
 WHERE document_id  = c_document_id;

Line: 747


  SELECT document_no
    FROM AHL_DOCUMENTS_B
   WHERE document_id = c_document_id;

Line: 753


SELECT revision_status_code
FROM ahl_operations_b
     WHERE operation_id = c_operation_id;

Line: 759


  SELECT revision_status_code
    FROM ahl_routes_b
   WHERE route_id = c_route_id;

Line: 775


 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');

Line: 793


 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);

Line: 855


                SELECT TYPE_CODE INTO l_type_code
                FROM AHL_MR_HEADERS_B
                WHERE MR_HEADER_ID=p_association_rec.ASO_OBJECT_ID;

Line: 1042


         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;

Line: 1051


         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');

Line: 1136


 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');

Line: 1339


                          delete from AHL_DOC_TITLE_ASSOS_TL
                            where DOC_TITLE_ASSO_ID    = p_x_association_tbl(I).DOC_TITLE_ASSO_ID;

Line: 1346


                                  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;

Line: 1358


                          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;

Line: 1395


                                  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);

Line: 1416


                            SELECT AHL_DOC_TITLE_ASSOS_B_S.Nextval INTO
                                   p_x_association_tbl(i).doc_title_asso_id from DUAL;

Line: 1419


                                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);