The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
AUCTION_HEADER_ID,
DOCUMENT_NUMBER ,
AUCTION_TITLE,
TO_CHAR(OPEN_BIDDING_DATE,'dd-mm-yyyy hh24:mi:ss'),
TO_CHAR(CLOSE_BIDDING_DATE,'dd-mm-yyyy hh24:mi:ss'),
TO_CHAR(PUBLISH_DATE,'dd-mm-yyyy hh24:mi:ss')
INTO
l_auction_header_id,
l_document_number,
l_auction_title,
l_open_bidding_date,
l_close_bidding_date,
l_publish_date
FROM PON_AUCTION_HEADERS_ALL
WHERE AUCTION_HEADER_ID = p_auction_header_id;
SELECT
B.BID_NUMBER,
B.AUCTION_HEADER_ID,
A.DOCUMENT_NUMBER,
B.TRADING_PARTNER_CONTACT_ID,
B.TRADING_PARTNER_ID,
TO_CHAR(B.PUBLISH_DATE,'dd-mm-yyyy hh24:mi:ss'),
B.SURROG_BID_CREATED_CONTACT_ID,
B.SURROG_BID_CREATED_TP_ID
INTO
l_bid_number,
l_auction_header_id,
l_document_number,
l_trading_partner_contact_id,
l_trading_partner_id,
l_publish_date,
l_surr_bid_created_contct_id,
l_surrog_bid_created_tp_id
FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A
WHERE B.BID_NUMBER = p_bid_number
AND A.AUCTION_HEADER_ID = B.AUCTION_HEADER_ID;
l_last_update_date VARCHAR2(100);
SELECT
B.BID_NUMBER,
B.AUCTION_HEADER_ID,
A.DOCUMENT_NUMBER,
B.TRADING_PARTNER_CONTACT_ID,
B.TRADING_PARTNER_ID,
TO_CHAR(B.PUBLISH_DATE,'dd-mm-yyyy hh24:mi:ss'),
TO_CHAR(B.LAST_UPDATE_DATE,'dd-mm-yyyy hh24:mi:ss'),
B.DISQUALIFY_REASON
INTO
l_bid_number,
l_auction_header_id,
l_document_number,
l_trading_partner_contact_id,
l_trading_partner_id,
l_publish_date,
l_last_update_date,
l_disqualify_reason
FROM PON_BID_HEADERS B, PON_AUCTION_HEADERS_ALL A
WHERE B.BID_NUMBER = p_bid_number
AND A.AUCTION_HEADER_ID = B.AUCTION_HEADER_ID;
p_value => l_last_update_date,
p_parameterlist => l_parameter_list);
SELECT
AUCTION_HEADER_ID,
DOCUMENT_NUMBER ,
AWARD_APPR_AME_TRANS_ID,
TO_CHAR(AWARD_APPR_AME_TXN_DATE,'dd-mm-yyyy hh24:mi:ss'),
AWARD_APPROVAL_STATUS,
WF_AWARD_APPROVAL_ITEM_KEY
INTO
l_auction_header_id,
l_document_number,
l_award_appr_ame_trans_id,
l_award_appr_ame_txn_date,
l_award_approval_status,
l_wf_award_approval_item_key
FROM PON_AUCTION_HEADERS_ALL
WHERE AUCTION_HEADER_ID = p_auction_header_id;
SELECT
AUCTION_HEADER_ID,
DOCUMENT_NUMBER ,
OUTCOME_STATUS,
SOURCE_REQS_FLAG,
SHARE_AWARD_DECISION,
TO_CHAR(AWARD_COMPLETE_DATE,'dd-mm-yyyy hh24:mi:ss'),
DECODE(NVL(AUCTION_ORIGINATION_CODE,'N'),'REQUISITION','Y','N')
INTO
l_auction_header_id ,
l_document_number ,
l_outcome_status,
l_source_reqs_flag,
l_share_award_decision,
l_award_complete_date,
l_requisition_based_flag
FROM PON_AUCTION_HEADERS_ALL
WHERE AUCTION_HEADER_ID = p_auction_header_id;
l_last_update_date VARCHAR2(100);
SELECT
AUCTION_HEADER_ID,
DOCUMENT_NUMBER ,
DOCTYPE_ID,
CONTRACT_TYPE,
OUTCOME_STATUS,
WF_PONCOMPL_ITEM_KEY,
WF_PONCOMPL_CURRENT_ROUND,
TO_CHAR(LAST_UPDATE_DATE,'dd-mm-yyyy hh24:mi:ss'),
NVL(SOURCE_REQS_FLAG,'N')
INTO
l_auction_header_id,
l_document_number,
l_doctype_id,
l_contract_type,
l_outcome_status,
l_wf_poncompl_item_key,
l_wf_poncompl_current_round,
l_last_update_date,
l_source_reqs_flag
FROM PON_AUCTION_HEADERS_ALL
WHERE AUCTION_HEADER_ID = p_auction_header_id;
p_value => l_last_update_date,
p_parameterlist => l_parameter_list);
l_parameter_list.DELETE;