APPS.PON_AUCTION_PO_PKG SQL Statements

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

Line: 37

       SELECT count(*)
       INTO   x_number_of_pos
       FROM   pon_bid_headers pbh, pon_auction_headers_all pah
       WHERE  pbh.order_number = po_number and
              nvl(pah.org_id, -9999) = nvl(org_id,-9999) and
              pbh.auction_header_id = pah.auction_header_id;

Line: 129

        SELECT     replace(pbav.attribute_name, fnd_global.local_chr(13)), pbav.value
        FROM       pon_bid_attribute_values pbav,
                   pon_auction_attributes paa
        WHERE      pbav.auction_header_id = p_auction_header_id and
                   pbav.bid_number = p_bid_number and
                   pbav.line_number = p_line_number and
                   pbav.sequence_number > 0 and
                   pbav.auction_header_id = paa.auction_header_id and
                   pbav.line_number = paa.line_number and
                   pbav.sequence_number = paa.sequence_number and
                   paa.ip_category_id is null
        ORDER BY   pbav.sequence_number;

Line: 150

SELECT dt.doctype_group_name
INTO   x_doctype_group_name
FROM   pon_auction_headers_all auh, pon_auc_doctypes dt
WHERE  auh.auction_header_id = p_auction_header_id and
       auh.doctype_id = dt.doctype_id;

Line: 160

SELECT item_description, has_attributes_flag
INTO   x_item_description, x_has_attributes_flag
FROM   pon_auction_item_prices_all
WHERE  auction_header_id = p_auction_header_id and
       line_number = p_line_number;

Line: 228

        SELECT     replace(pbav.attribute_name, fnd_global.local_chr(13)),
                   pbav.value, paa.sequence_number
        FROM       pon_bid_attribute_values pbav, pon_auction_attributes paa
        WHERE      pbav.auction_header_id = p_auction_header_id and
                   pbav.bid_number = p_bid_number and
                   pbav.line_number = -1 and
                   paa.auction_header_id = pbav.auction_header_id and
                   paa.line_number = -1 and
                   paa.sequence_number = pbav.sequence_number and
                   nvl(paa.internal_attr_flag, 'N') = 'N' and
                   nvl(paa.display_only_flag, 'N') = 'N'
        UNION
        SELECT     replace(paa.attribute_name, fnd_global.local_chr(13)),
                   paa.value, paa.sequence_number
        FROM       pon_auction_attributes paa
        WHERE      paa.auction_header_id = p_auction_header_id and
                   paa.line_number = -1 and
                   nvl(paa.display_only_flag, 'N') = 'Y'
        ORDER BY   3;

Line: 256

SELECT dt.doctype_group_name
INTO   x_doctype_group_name
FROM   pon_auction_headers_all auh, pon_auc_doctypes dt
WHERE  auh.auction_header_id = p_auction_header_id and
       auh.doctype_id = dt.doctype_id;

Line: 266

SELECT auction_title, document_number, has_hdr_attr_flag
INTO   x_auction_title, x_document_number, x_has_attributes_flag
FROM   pon_auction_headers_all
WHERE  auction_header_id = p_auction_header_id;

Line: 333

SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
INTO   x_doctype_group_name, l_contract_type
FROM   pon_auction_headers_all auh, pon_auc_doctypes dt
WHERE  auh.auction_header_id = p_auction_header_id and
       auh.doctype_id = dt.doctype_id;

Line: 349

  SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
  INTO header_note, line_note
  FROM   pon_bid_headers pbh, pon_bid_item_prices pbip
  WHERE  pbh.auction_header_id = p_auction_header_id and
       pbh.bid_number = p_bid_number and
       pbip.bid_number = pbh.bid_number and
       pbip.line_number = p_line_number;

Line: 357

  SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13))
  INTO header_note
  FROM   pon_bid_headers pbh
  WHERE  pbh.auction_header_id = p_auction_header_id and
       pbh.bid_number = p_bid_number;

Line: 408

SELECT dt.doctype_group_name, nvl(auh.contract_type,'NO_DATA_FOUND')
INTO   x_doctype_group_name, l_contract_type
FROM   pon_auction_headers_all auh, pon_auc_doctypes dt
WHERE  auh.auction_header_id = p_auction_header_id and
       auh.doctype_id = dt.doctype_id;

Line: 419

  SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13)), replace(paip.note_to_bidders, fnd_global.local_chr(13))
  INTO   header_note, line_note
  FROM   pon_auction_headers_all pah, pon_auction_item_prices_all paip
  WHERE  pah.auction_header_id = p_auction_header_id and
         paip.auction_header_id = pah.auction_header_id and
         paip.line_number = p_line_number;

Line: 427

  SELECT replace(pah.note_to_bidders, fnd_global.local_chr(13))
  INTO   header_note
  FROM   pon_auction_headers_all pah
  WHERE  pah.auction_header_id = p_auction_header_id;

Line: 482

        SELECT     ppet.name,
                   flv.meaning,
                   pbpe.bid_currency_value
        FROM       pon_bid_price_elements pbpe, pon_price_element_types_tl ppet, fnd_lookup_values flv
        WHERE      pbpe.bid_number =  p_bid_number and
                   pbpe.auction_header_id = p_auction_header_id and
                   pbpe.line_number = p_line_number and
                   pbpe.price_element_type_id <> -10 and
                   pbpe.pf_type = 'SUPPLIER' and
                   pbpe.price_element_type_id = ppet.price_element_type_id and
                   ppet.language = PON_AUCTION_PKG.SessionLanguage and
                   flv.lookup_type = 'PON_PRICING_BASIS' and
                   flv.language = PON_AUCTION_PKG.SessionLanguage and
                   flv.view_application_id = 0 and
                   flv.security_group_id = 0 and
                   pbpe.pricing_basis = flv.lookup_code
        ORDER BY   sequence_number;

Line: 508

SELECT dt.doctype_group_name
INTO   x_doctype_group_name
FROM   pon_auction_headers_all auh, pon_auc_doctypes dt
WHERE  auh.auction_header_id = p_auction_header_id and
       auh.doctype_id = dt.doctype_id;

Line: 518

SELECT item_description, has_price_elements_flag
INTO   x_item_description, x_has_price_elements_flag
FROM   pon_auction_item_prices_all
WHERE  auction_header_id = p_auction_header_id and
       line_number = p_line_number;

Line: 572

SELECT dt.doctype_group_name
INTO   x_doctype_group_name
FROM   pon_auction_headers_all auh, pon_auc_doctypes dt
WHERE  auh.auction_header_id = p_auction_header_id and
       auh.doctype_id = dt.doctype_id;

Line: 586

SELECT replace(paip.additional_job_details, fnd_global.local_chr(13))
INTO 	 job_details
FROM   pon_auction_item_prices_all paip
WHERE  paip.auction_header_id = p_auction_header_id and
       paip.line_number = p_line_number;

Line: 626

	  SELECT replace(pys.note_to_bidders, fnd_global.local_chr(13))
	  INTO   pymt_note
	  FROM   pon_auc_payments_shipments pys
	  WHERE  payment_id= p_auction_payment_id;