[Home] [Help]
3871: x_doc_type_to_create varchar2(25);
3872: v_old_policy varchar2(1);
3873: v_old_org_id number;
3874: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3875: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
3876: x_print_flag varchar2(1) := 'N';
3877: x_fax_flag varchar2(1) := 'N';
3878: x_email_flag varchar2(1) := 'N';
3879: x_eMail_address po_vendor_sites_all.email_address%TYPE := null;
3875: x_supplier_notif_method po_vendor_sites_all.supplier_notif_method%TYPE := null;
3876: x_print_flag varchar2(1) := 'N';
3877: x_fax_flag varchar2(1) := 'N';
3878: x_email_flag varchar2(1) := 'N';
3879: x_eMail_address po_vendor_sites_all.email_address%TYPE := null;
3880: x_fax_number varchar2(100) := null;
3881: x_po_api_return_status varchar2 (3) := null;
3882: x_msg_count number := NULL;
3883: x_msg_data varchar2(2000):= NULL;
4132: x_msg_suffix VARCHAR2(3) := '';
4133: x_user_name fnd_user.user_name%TYPE;
4134: x_bid_number pon_bid_headers.bid_number%TYPE;
4135: x_vendor_name po_vendors.vendor_name%TYPE;
4136: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
4137: x_agent_name per_all_people_f.full_name%TYPE;
4138: x_order_number pon_bid_headers.order_number%TYPE;
4139: po_status varchar2(4000);
4140: msgBid varchar2(2000);
4294: x_msg_suffix VARCHAR2(3) := '';
4295: x_user_name fnd_user.user_name%TYPE;
4296: x_bid_number NUMBER;
4297: x_vendor_name po_vendors.vendor_name%TYPE;
4298: x_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
4299: x_agent_name per_all_people_f.full_name%TYPE;
4300: x_order_number pon_bid_headers.order_number%TYPE;
4301: x_error_code pon_bid_headers.po_error_code%TYPE;
4302: po_status varchar2(4000);
4330: pbh.po_error_code,
4331: pbh.po_error_msg
4332: FROM pon_bid_headers pbh,
4333: po_vendors pov,
4334: po_vendor_sites_all povsa,
4335: per_all_people_f papf
4336: WHERE pbh.auction_header_id = x_auction_header_id
4337: AND pbh.bid_status = 'ACTIVE'
4338: AND nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL')