APPS.PON_REMINDER_NOTIFICATION_PKG SQL Statements

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

Line: 165

      SELECT pah.auction_header_id auction_header_id,
             pah.close_bidding_date close_bidding_date,
             pah.open_bidding_date open_bidding_date,
             pah.view_by_date preview_date
      FROM pon_auction_headers_all pah
      WHERE pah.auction_status = 'ACTIVE'
      AND pah.close_bidding_date > SYSDATE
      AND SYSDATE > pah.open_bidding_date;

Line: 202

          SELECT Floor(c_neg_details.close_bidding_date - l_temp_sys_date) INTO l_diff_days
          FROM dual;

Line: 206

          SELECT Floor(l_temp_sys_date - c_neg_details.open_bidding_date) INTO l_diff_days
          FROM dual;

Line: 210

          SELECT Floor(l_temp_sys_date - c_neg_details.preview_date) INTO l_diff_days
          FROM dual;

Line: 246

	           UPDATE pon_auction_headers_all pah
	           SET  pah.no_of_notifications_sent = Nvl(pah.no_of_notifications_sent, 0) + 1
	           WHERE auction_header_id = c_neg_details.auction_header_id;

Line: 339

SELECT pbp.trading_partner_contact_id,
pbp.trading_partner_contact_name,
pbp.vendor_site_code,
pbp.trading_partner_name,
pbp.trading_partner_id,
pbp.vendor_site_id,
pbp.additional_contact_email

BULK COLLECT INTO l_TP_contact_id_table,
l_TP_contact_name_table,
l_vendor_site_code_table,
l_TP_name_table,
l_TP_id_table,
l_vendor_site_id_table,
l_add_con_email_table

FROM pon_bidding_parties pbp

WHERE
pbp.auction_header_id = p_auction_header_id
AND  pbp.trading_partner_contact_id NOT IN
  (SELECT  pbh.trading_partner_contact_id
  FROM pon_bid_headers pbh
  WHERE pbh.auction_header_id = p_auction_header_id
  AND pbh.bid_status = 'ACTIVE'
);

Line: 369

SELECT
auction_title,
trading_partner_name,
open_bidding_date,
close_bidding_date,
view_by_date,
wf_item_key,
Nvl(no_of_notifications_sent, 0) + 1,
document_number
INTO
p_auction_title,
p_trading_partner_name,
p_neg_open_date,
p_neg_close_date,
p_neg_preview_date,
p_wf_item_key,
p_notification_no,
p_document_number

FROM pon_auction_headers_all
WHERE auction_header_id = p_auction_header_id;

Line: 394

    SELECT person_id
    INTO p_person_id
    FROM  per_all_people_f
    WHERE party_id = (
                        SELECT trading_partner_contact_id
                        FROM pon_auction_headers_all
                        WHERE auction_header_id = p_auction_header_id
                      )
    AND SYSDATE BETWEEN effective_start_date AND effective_end_date;

Line: 443

          SELECT USER_NAME INTO p_supplier_role_name FROM FND_USER
          WHERE person_party_id = l_TP_contact_id_table(i)
          AND SYSDATE BETWEEN start_date AND nvl(end_date,SYSDATE+1);

Line: 453

          SELECT USER_NAME
          INTO p_supplier_role_name
          FROM FND_USER
          WHERE person_party_id = l_TP_contact_id_table(i)
          AND SYSDATE BETWEEN start_date AND nvl(end_date,SYSDATE+1)
          AND ROWNUM = 1;

Line: 501

        SELECT wf_user_name
        INTO
        p_add_con_role_name
        FROM pon_bidding_parties
        WHERE auction_header_id = p_auction_header_id
        AND trading_partner_id = p_supplier_id
        AND Nvl(vendor_site_id,-1) = p_supplier_site_id;

Line: 819

SELECT
pah.auction_header_id auction_header_id,
pah.wf_item_key

BULK COLLECT INTO
t_auction_header_id,
t_wf_item_key

FROM pon_auction_headers_all pah
WHERE pah.close_bidding_date < SYSDATE
AND SYSDATE > pah.open_bidding_date
AND Nvl(pah.no_of_notifications_sent, 0) > 0;

Line: 848

        SELECT item_key
        BULK COLLECT INTO
        t_exact_item_key
        FROM wf_items
        WHERE item_key LIKE l_item_key_like;

Line: 861

        END; -- SELECT STATEMENT

Line: 888

	          UPDATE pon_auction_headers_all pah
	          SET  pah.no_of_notifications_sent = -1
	          WHERE auction_header_id = t_auction_header_id(i);