[Home] [Help]
4932:
4933: l_doctype_Id pon_auction_Headers_all.doctype_id%TYPE;
4934: rfi_doctype_id pon_auction_Headers_all.doctype_id%TYPE;
4935: l_org_Id pon_auction_Headers_all.org_id%TYPE;
4936: l_style_Id pon_auction_Headers_all.style_id%TYPE;
4937: l_po_style_Id pon_auction_Headers_all.po_style_id%TYPE;
4938: l_po_style_name pon_auction_Headers_interface.po_style_name%TYPE;
4939: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4940: l_tpc_id fnd_user.user_id%TYPE;
6308: print_log('populate_neg_header_rec begin ');
6309:
6310: -- For amendment neg_header_record_data.auction_header_id will not be used
6311: IF ( p_is_amendment <> 'Y' ) THEN
6312: SELECT pon_auction_headers_all_s.NEXTVAL INTO neg_header_record_data.auction_header_id FROM dual;
6313: END IF;
6314:
6315: SELECT person_party_id,user_name
6316: INTO neg_header_record_data.trading_partner_contact_id,neg_header_record_data.trading_partner_contact_name
6960: fnd_global.user_Id,
6961: fnd_global.login_id);
6962:
6963:
6964: UPDATE pon_auction_headers_all SET
6965: OPEN_BIDDING_DATE=neg_header_record_data.open_bidding_date,
6966: CLOSE_BIDDING_DATE=neg_header_record_data.CLOSE_BIDDING_DATE,
6967: PUBLISH_DATE=neg_header_record_data.publish_date,
6968: AUTO_EXTEND_FLAG='N'
7366: l_OPEN_BIDDING_DATE pon_auction_headers_all.OPEN_BIDDING_DATE%TYPE;
7367: l_auction_status pon_auction_headers_all.auction_status%TYPE;
7368: l_auc_tpc_id pon_auction_headers_all.trading_partner_contact_id%TYPE;
7369: l_auc_tp_id pon_auction_headers_all.trading_partner_id%TYPE;
7370: l_security_level_code pon_auction_headers_all.security_level_code%TYPE;
7371: l_username fnd_user.user_name%TYPE;
7372: P_ERROR_CODE VARCHAR2(50);
7373: P_ERROR_MESSAGE VARCHAR2(50);
7374: l_check VARCHAR(1);