[Home] [Help]
4853: x_doc_type_to_create varchar2(25);
4854: v_old_policy varchar2(1);
4855: v_old_org_id number;
4856: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4857: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
4858: x_print_flag varchar2(1) := 'N';
4859: x_fax_flag varchar2(1) := 'N';
4860: x_email_flag varchar2(1) := 'N';
4861: x_eMail_address po_vendor_sites_all.email_address%TYPE := null;
4857: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
4858: x_print_flag varchar2(1) := 'N';
4859: x_fax_flag varchar2(1) := 'N';
4860: x_email_flag varchar2(1) := 'N';
4861: x_eMail_address po_vendor_sites_all.email_address%TYPE := null;
4862: x_fax_number varchar2(100) := null;
4863: x_po_api_return_status varchar2 (3) := null;
4864: x_msg_count number := NULL;
4865: x_msg_data varchar2(2000):= NULL;
5114: x_msg_suffix VARCHAR2(3) := '';
5115: x_user_name fnd_user.user_name%TYPE;
5116: x_bid_number pon_bid_headers.bid_number%TYPE;
5117: x_vendor_name po_vendors.vendor_name%TYPE;
5118: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
5119: x_agent_name per_all_people_f.full_name%TYPE;
5120: x_order_number pon_bid_headers.order_number%TYPE;
5121: po_status varchar2(4000);
5122: msgBid varchar2(2000);
5279: x_msg_suffix VARCHAR2(3) := '';
5280: x_user_name fnd_user.user_name%TYPE;
5281: x_bid_number NUMBER;
5282: x_vendor_name po_vendors.vendor_name%TYPE;
5283: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
5284: x_agent_name per_all_people_f.full_name%TYPE;
5285: x_order_number pon_bid_headers.order_number%TYPE;
5286: x_error_code pon_bid_headers.po_error_code%TYPE;
5287: po_status varchar2(4000);
5315: pbh.po_error_code,
5316: pbh.po_error_msg
5317: FROM pon_bid_headers pbh,
5318: po_vendors pov,
5319: po_vendor_sites_all povsa,
5320: per_all_people_f papf
5321: WHERE pbh.auction_header_id = x_auction_header_id
5322: AND pbh.bid_status = 'ACTIVE'
5323: AND nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL')