APPS.POS_CLM_UTIL_PKG SQL Statements

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

Line: 115

      SELECT  Nvl(clm_info_flag,'N'),clm_funded_flag
      INTO    x_clm_info_flag, x_clm_funded_flag
      FROM   po_lines_draft_all
      WHERE  po_line_id = p_line_id;

Line: 120

      SELECT  Nvl(clm_info_flag,'N'),clm_funded_flag
      INTO    x_clm_info_flag, x_clm_funded_flag
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_line_id;

Line: 125

       SELECT  Nvl(clm_info_flag,'N'),clm_funded_flag
       INTO   x_clm_info_flag, x_clm_funded_flag
       FROM   pon_auction_item_prices_all
             WHERE  line_number = p_line_id
             AND auction_header_id = p_document_id;

Line: 133

        SELECT Nvl(clm_info_flag,'N'),clm_funded_flag
         INTO   x_clm_info_flag, x_clm_funded_flag
        FROM   pon_bid_item_prices
        WHERE  BID_NUMBER = p_line_id
        AND auction_header_id = p_document_id;

Line: 154

      SELECT LINE_NUM        --line_num_display
      INTO    l_line_num
      FROM   po_lines_draft_all
      WHERE  po_line_id = p_line_id;

Line: 159

      SELECT  LINE_NUM
      INTO     l_line_num
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_line_id;

Line: 164

       /*SELECT LINE_NUM_DISPLAY
       INTO   l_line_num
       FROM   pon_auction_item_prices_all
             WHERE  line_number = p_line_id
             AND auction_header_id = p_document_id;*/

Line: 172

       /* SELECT LINE_NUM_DISPLAY
         INTO   l_line_num
        FROM   pon_bid_item_prices
        WHERE  BID_NUMBER = p_line_id
        AND auction_header_id = p_document_id;*/

Line: 197

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   po_lines_draft_all
                         WHERE  CLM_BASE_LINE_NUM = p_line_id
                         AND PO_HEADER_ID=Nvl(p_document_id,PO_HEADER_ID));

Line: 207

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   po_requisition_lines_all
                         WHERE  CLM_BASE_LINE_NUM = p_line_id
                         AND    REQUISITION_HEADER_ID=Nvl(p_document_id,REQUISITION_HEADER_ID));

Line: 216

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   pon_auction_item_prices_all
                         WHERE  1=1
                         AND CLM_BASE_LINE_NUM = p_line_id
                         AND auction_header_id = p_document_id);

Line: 226

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  EXISTS (SELECT 'x'
                         FROM   pon_bid_item_prices
                         WHERE  CLM_BASE_LINE_NUM = p_line_id
                                AND auction_header_id = p_document_id);

Line: 255

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   po_lines_draft_all
                         WHERE  group_line_id = p_line_id);

Line: 264

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   po_requisition_lines_all
                         WHERE  group_line_id = p_line_id);

Line: 275

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   pon_auction_item_prices_all
                         WHERE  group_line_id = p_line_id
                                AND auction_header_id = p_document_id);

Line: 286

      SELECT 'Y'
      INTO   l_flag
      FROM   dual
      WHERE  NOT EXISTS (SELECT 'x'
                         FROM   pon_bid_item_prices
                         WHERE  group_line_id = p_line_id
                                AND auction_header_id = p_document_id);

Line: 314

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   po_lines_draft_all
      WHERE  po_line_id = p_group_line_id;

Line: 319

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   po_requisition_lines_all
      WHERE  requisition_line_id = p_group_line_id;

Line: 324

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   pon_auction_item_prices_all
      WHERE  auction_header_id = p_document_id
             AND line_number = p_group_line_id;

Line: 330

      SELECT group_line_id
      INTO   l_group_line_id
      FROM   pon_bid_item_prices
      WHERE  auction_header_id = p_document_id
             AND bid_number = p_group_line_id;

Line: 397

      SELECT LINE_TYPE
      INTO   x_line_type
      FROM   PO_LINE_TYPES
      WHERE  LINE_TYPE_ID = p_line_type_id AND
      ROWNUM=1;

Line: 411

      SELECT CONCATENATED_SEGMENTS
      INTO   x_item_number
      FROM   MTL_SYSTEM_ITEMS_KFV
      WHERE  INVENTORY_ITEM_ID = p_item_id AND
      ROWNUM=1;

Line: 426

      SELECT PJ.NAME
      INTO   x_job_title
      FROM   PER_JOBS PJ
      WHERE  PJ.JOB_ID = p_job_id AND
      ROWNUM=1;

Line: 442

         SELECT DISPLAYED_FIELD
         INTO   x_contract_type
         FROM   PO_LOOKUP_CODES
         WHERE  LOOKUP_CODE = p_contract_type AND
                LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY';

Line: 448

         SELECT DISPLAYED_FIELD
         INTO   x_contract_type
         FROM   PO_LOOKUP_CODES
         WHERE  LOOKUP_CODE = p_contract_type AND
                LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_AMT';

Line: 499

      SELECT LINE_TYPE
      INTO   x_line_type
      FROM   PO_LINE_TYPES
      WHERE  LINE_TYPE_ID = p_line_type_id AND
      ROWNUM=1;

Line: 513

      SELECT  name
      INTO    x_org_name
      FROM    hr_all_organization_units_tl
      WHERE   organization_id = p_org_id
      AND     language = USERENV('LANG');

Line: 528

         SELECT DISPLAYED_FIELD
         INTO   x_contract_type
         FROM   PO_LOOKUP_CODES
         WHERE  LOOKUP_CODE = p_contract_type AND
                LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_QTY';

Line: 534

         SELECT DISPLAYED_FIELD
         INTO   x_contract_type
         FROM   PO_LOOKUP_CODES
         WHERE  LOOKUP_CODE = p_contract_type AND
                LOOKUP_TYPE = 'PO_FEDERAL_CONTRACT_TYPES_AMT';

Line: 549

      SELECT CONCATENATED_SEGMENTS
      INTO   x_item_name
      FROM   MTL_SYSTEM_ITEMS_KFV
      WHERE  INVENTORY_ITEM_ID = p_item_id AND
      ROWNUM=1;

Line: 563

         SELECT CURRENCY_CODE
         INTO   x_currency_code
         FROM   po_headers_all
         WHERE  PO_HEADER_ID = p_header_id;

Line: 568

         SELECT CURRENCY_CODE
         INTO   x_currency_code
         FROM   po_headers_merge_v
         WHERE  PO_HEADER_ID = p_header_id AND
                DRAFT_ID = p_draftId;

Line: 584

         SELECT DISPLAYED_FIELD
         INTO   x_idc_type
         FROM   PO_LOOKUP_CODES
         WHERE  LOOKUP_CODE = p_idc_type AND
                LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES';

Line: 590

         SELECT DISPLAYED_FIELD
         INTO   x_idc_type
         FROM   PO_LOOKUP_CODES
         WHERE  LOOKUP_CODE = p_idc_type AND
                LOOKUP_TYPE = 'PO_FEDERAL_IDC_TYPES';

Line: 605

        SELECT PO_CLM_CP_LABEL_EXT.getHintLabel(p_matching_basis,
                                                p_contract_type,
                                                p_idc_type)
        INTO   x_ext_price_label
        FROM   dual;

Line: 618

         SELECT TYPE_LOOKUP_CODE
         INTO   x_document_type
         FROM   po_headers_all
         WHERE  PO_HEADER_ID = p_header_id;

Line: 623

         SELECT TYPE_LOOKUP_CODE
         INTO   x_document_type
         FROM   po_headers_merge_v
         WHERE  PO_HEADER_ID = p_header_id AND
                DRAFT_ID = p_draftId;

Line: 700

      SELECT CHANGED_AMT, CHANGED_AMT_EXCL_OPT
      INTO   x_chg_amt, x_chg_amt_wo_opt
      FROM   PO_DRAFTS
      WHERE  DRAFT_ID = p_draftId AND
             DOCUMENT_ID = p_header_id;

Line: 751

       SELECT VENDOR_NAME INTO x_vendor_name FROM PO_VENDORS WHERE VENDOR_ID = p_vendor_id;

Line: 761

       SELECT VENDOR_SITE_CODE,
              ADDRESS_LINE1,
              ADDRESS_LINE2,
              ADDRESS_LINE3,
              CITY||', '||STATE||' '||ZIP CITYSTATE,
              COUNTRY
       INTO   x_vendor_site_code,
              x_addr_line1,
              x_addr_line2,
              x_addr_line3,
              x_city_state,
              x_country
      FROM   PO_VENDOR_SITES_ALL
       WHERE  VENDOR_SITE_ID = p_vendor_site_id;

Line: 789

       SELECT EMP.person_id,
              EMP.full_name,
              nvl(EMP.location_id, 0),
              POA.agent_id
       INTO   x_employee_id,
              x_employee_full_name,
              x_emp_location_id,
              x_agent_id
       FROM   fnd_user FU,
              per_workforce_current_x EMP,
              po_agents POA
       WHERE  FU.employee_id = p_user_id
              AND FU.employee_id = EMP.person_id (+)
              AND EMP.person_id = POA.agent_id (+)
              AND sysdate BETWEEN NVL(POA.start_date_active (+), sysdate - 1)
              AND NVL(POA.end_date_active (+), sysdate + 1)
              AND ROWNUM=1;

Line: 825

       SELECT NAME INTO x_pay_term_name FROM ap_terms WHERE term_id = p_term_id;

Line: 835

       SELECT displayed_field
       INTO   x_freight_meaning
       FROM   po_lookup_codes
       WHERE  lookup_type = 'FREIGHT TERMS'
              AND lookup_code = p_freight_lookup_code;

Line: 849

       SELECT displayed_field
       INTO   x_ship_cntrl_meaning
       FROM   po_lookup_codes
       WHERE  lookup_type = 'SHIPPING CONTROL'
              AND lookup_code = p_ship_cntrl_lookup_code;

Line: 863

       SELECT displayed_field
       INTO   x_fob_meaning
       FROM   po_lookup_codes
       WHERE  lookup_type = 'FOB'
              AND lookup_code = p_fob_lookup_code;

Line: 877

       SELECT ADDRESS_LINE_1,
              ADDRESS_LINE_2,
              ADDRESS_LINE_3,
              TOWN_OR_CITY||', '||REGION_2||' '||POSTAL_CODE SHIP_CITY_STATE
       INTO   x_ship_addr1,
              x_ship_addr2,
              x_ship_addr3,
              x_ship_city_state
       FROM   HR_LOCATIONS_ALL
       WHERE  LOCATION_ID = p_ship_to_loc_id;

Line: 899

       SELECT ADDRESS_LINE_1,
              ADDRESS_LINE_2,
              ADDRESS_LINE_3,
              TOWN_OR_CITY||', '||REGION_2||' '||POSTAL_CODE SHIP_CITY_STATE
       INTO   x_bill_addr1,
              x_bill_addr2,
              x_bill_addr3,
              x_bill_city_state
       FROM   HR_LOCATIONS_ALL
       WHERE  LOCATION_ID = p_bill_to_loc_id;