APPS.PON_BIZ_EVENTS_PVT SQL Statements

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

Line: 96

	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;

Line: 225

	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;

Line: 349

	l_last_update_date           VARCHAR2(100);

Line: 369

	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;

Line: 420

				     p_value => l_last_update_date,
				     p_parameterlist => l_parameter_list);

Line: 511

	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;

Line: 644

	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;

Line: 772

	l_last_update_date	      VARCHAR2(100);

Line: 799

	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;

Line: 862

				     p_value => l_last_update_date,
				     p_parameterlist => l_parameter_list);

Line: 1014

   l_parameter_list.DELETE;