APPS.OKC_REP_UDA_FUNCTIONS SQL Statements

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

Line: 27

    SELECT currency_code INTO l_currency_code
    FROM po_headers_draft_all
    WHERE po_header_id  = p_po_header_id AND draft_id = p_po_draft_id;

Line: 40

    SELECT DECODE(matching_basis, 'AMOUNT', amount, nvl2(l_min_unit, round(quantity*unit_price/l_min_unit) * l_min_unit, round((quantity*unit_price),l_precision)) ) -- Bug# 5378134
    INTO l_line_amount
    FROM po_lines_merge_v
    WHERE po_line_id = p_po_line_id AND draft_id = p_po_draft_id;

Line: 115

        SELECT line_number INTO l_auc_line_num
        FROM (SELECT line_number FROM pon_auction_item_prices_all WHERE auction_header_id = p_source_doc_id
              ORDER BY clm_amount DESC, item_description ASC)
        WHERE rownum = 1;

Line: 122

        SELECT po_line_id INTO l_po_line_id
        FROM (SELECT po_line_id FROM po_lines_draft_all WHERE draft_id = p_source_doc_id
              ORDER BY getPoLineAmount(po_header_id, po_line_id, draft_id) DESC, item_description ASC)
        WHERE rownum = 1;

Line: 149

          SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
          INTO x_buyer_name
          FROM pon_auction_headers_all
          WHERE auction_header_id = p_source_doc_id;

Line: 154

          SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'addresses', NULL, 'contact', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
          INTO x_buyer_name
          FROM po_headers_draft_all
          WHERE draft_id = p_source_doc_id;

Line: 187

          SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
          INTO x_issuing_off_symbol
          FROM pon_auction_headers_all
          WHERE auction_header_id = p_source_doc_id;

Line: 192

          SELECT PO_UDA_PUB.get_address_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'addresses', NULL, 'addresscode', 'ISSUING_OFFICE', 'DISPLAY_VALUE')
          INTO x_issuing_off_symbol
          FROM po_headers_draft_all
          WHERE draft_id = p_source_doc_id;

Line: 225

          SELECT Sum(Nvl(clm_amount, 0)) INTO x_total_amount
          FROM pon_auction_item_prices_all
          WHERE auction_header_id = p_source_doc_id;

Line: 229

          SELECT changed_amt INTO x_total_amount
          FROM po_drafts
          WHERE draft_id = p_source_doc_id;

Line: 261

          SELECT currency_code INTO x_currency
          FROM pon_auction_headers_all
          WHERE auction_header_id = p_source_doc_id;

Line: 265

          SELECT currency_code INTO x_currency
          FROM po_headers_draft_all
          WHERE draft_id = p_source_doc_id;

Line: 305

          SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'NAICS', 'INTERNAL_VALUE' )
          INTO x_naics_code
          FROM po_headers_draft_all
          WHERE draft_id = p_source_doc_id;

Line: 345

          SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, auction_header_id, NULL, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
          INTO x_size_standard
          FROM pon_auction_headers_all
          WHERE auction_header_id = p_source_doc_id;

Line: 350

          SELECT PO_UDA_PUB.get_single_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'SET_ASIDE_INFO', NULL, 'SIZE_STANDARD', 'INTERNAL_VALUE')
          INTO x_size_standard
          FROM po_headers_draft_all
          WHERE draft_id = p_source_doc_id;

Line: 391

          SELECT PO_UDA_PUB.get_multi_attr_value(uda_template_id, NULL, po_header_id, draft_id, NULL, NULL, NULL, NULL, 'FSC_PSC', NULL, 'FSC_PSC', NULL, 'INTERNAL_VALUE')
          INTO l_fsc_svc_codes
          FROM po_headers_draft_all
          WHERE draft_id = p_source_doc_id;