APPS.JA_JAIN57F4_XMLP_PKG SQL Statements

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

Line: 18

    CURSOR C_COUNT_UPDATE IS
      SELECT
        FORM_ID,
        PRINT_CNT
      FROM
        JAI_PO_OSP_HDRS J57F4
      WHERE TRUNC(J57F4.ISSUE_DATE) <= NVL(P_TO_DATE
         ,TRUNC(SYSDATE))
        AND TRUNC(J57F4.ISSUE_DATE) >= TRUNC(NVL(P_FROM_DATE
               ,TRUNC(J57F4.ISSUE_DATE)))
        AND TRUNC(J57F4.FORM_ID) >= NVL(P_FORM_ID_FROM
         ,TRUNC(J57F4.FORM_ID))
        AND TRUNC(J57F4.FORM_ID) <= NVL(P_FORM_ID_TO
         ,TRUNC(J57F4.FORM_ID))
        AND UPPER(J57F4.ISSUE_APPROVED) = 'Y'
        AND J57F4.VENDOR_ID = NVL(P_VENDOR_ID
         ,J57F4.VENDOR_ID)
        AND ( J57F4.PRINT_ORIGINAL = 'Y'
      OR J57F4.PRINT_DUPLICATE = 'Y' );

Line: 40

    FOR c_cnt_upd IN C_COUNT_UPDATE LOOP
      V_COUNT := NVL(C_CNT_UPD.PRINT_CNT
                    ,0) + 1;

Line: 44

      UPDATE
        JAI_PO_OSP_HDRS
      SET
        PRINT_CNT = V_COUNT
        ,PRINT_ORIGINAL = 'N'
        ,PRINT_DUPLICATE = 'N'
      WHERE FORM_ID = V_FORM_ID;

Line: 59

      SELECT
        CONCURRENT_PROGRAM_ID,
        NVL(ENABLE_TRACE
           ,'N')
      FROM
        FND_CONCURRENT_REQUESTS
      WHERE REQUEST_ID = P_REQUEST_ID;

Line: 96

    FOR c_fetch_ec_code IN (SELECT
                              EC_CODE
                            FROM
                              JAI_CMN_VENDOR_SITES
                            WHERE VENDOR_ID = VENDOR_ID_v
                              AND VENDOR_SITE_ID = VENDOR_SITE_ID_v) LOOP
      V_EC_CODE := C_FETCH_EC_CODE.EC_CODE;

Line: 114

      SELECT
        PHA.SEGMENT1
      FROM
        PO_HEADERS_ALL PHA
      WHERE PHA.PO_HEADER_ID = P_PO_HEADER_ID;

Line: 138

      SELECT
        PRA.RELEASE_NUM
      FROM
        PO_RELEASES_ALL PRA
      WHERE PRA.PO_RELEASE_ID = P_RELEASE_ID;

Line: 163

      SELECT
        WE.WIP_ENTITY_NAME
      FROM
        WIP_ENTITIES WE
      WHERE WE.WIP_ENTITY_ID = P_WIP_ENTITY_ID
        AND WE.ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 189

      SELECT
        WDJ.SCHEDULED_START_DATE
      FROM
        WIP_DISCRETE_JOBS WDJ
      WHERE WDJ.WIP_ENTITY_ID = P_WIP_ENTITY_ID
        AND WDJ.ORGANIZATION_ID = P_ORGANIZATION_ID;

Line: 215

      SELECT
        MSIK.CONCATENATED_SEGMENTS
      FROM
        MTL_SYSTEM_ITEMS_KFV MSIK
      WHERE MSIK.INVENTORY_ITEM_ID = P_ASSEMBLY_ID
        AND MSIK.ORGANIZATION_ID = P_ORGANIZATION_ID;