APPS.PO_CLM_CAR_WF_UTIL SQL Statements

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

Line: 26

  SELECT
  po_clm_car_util.get_car_number(PO_HEADER_ID, PO_DRAFT_ID) CAR_NUMBER,
  MESSAGE_CODE,
  NVL(PLC.DISPLAYED_FIELD, MESSAGE_LEVEL) MESSAGE_LEVEL_MEANING,
  MESSAGE_TEXT
  FROM
  PO_CLM_CAR_LOGS LOG, po_lookup_codes PLC
  WHERE
  LOG.PO_HEADER_ID = v_document_id AND
  LOG.PO_DRAFT_ID = v_draft_id AND
  PLC.LOOKUP_TYPE(+) = 'PO_CLM_CAR_MESSAGE_LEVELS' AND
  LOG.MESSAGE_LEVEL = PLC.LOOKUP_CODE (+);

Line: 166

  SELECT CAR_ID, REPORTING_METHOD, CAR_STATUS
  INTO l_car_id , l_reporting_method, l_car_status
  FROM PO_CLM_CARS
  WHERE PO_HEADER_ID = l_document_id
  AND PO_DRAFT_ID = l_draft_id;

Line: 205

  l_update_fpds_info VARCHAR2(200);

Line: 231

  l_update_fpds_info := 'JSP:/OA_HTML/OA.jsp?OAFunc=PO_UPDATE_FPDSNG_INFO&poHeaderId=' || To_Char(l_document_id)
     || '&DraftId=' || To_Char(l_draft_id)  || '&DOCUMENT_MODE=update&addBreadCrumb=Y';

Line: 277

                                   aname   => 'UPDATE_FPDS_INFO',
                                   avalue  => l_update_fpds_info);

Line: 336

  SELECT PO_CORE_S.retrieveOptionValue(p_org_id => l_org_id,
                                  p_option_column => PO_CORE_S.g_FPDS_REPORTING_COL)
  into l_fpds_reporting
  FROM dual;

Line: 366

    SELECT REPORTING_METHOD, APPROVED_WITHOUT_REPORTING
    INTO l_reporting_method, l_approved_without_reporting
    FROM PO_CLM_CARS
    WHERE PO_HEADER_ID = l_document_id
    AND PO_DRAFT_ID = l_draft_id;

Line: 421

    SELECT 'Y'
    INTO l_car_authenticated
    FROM PO_CLM_CARS
    WHERE PO_HEADER_ID = l_document_id
    AND PO_DRAFT_ID = l_draft_id
    AND CAR_STATUS in ('AUTHENTICATED', 'APPROVED')
    AND REPORTING_METHOD = 'SINGLE_CAR';