3448:
3449:
3450:
3451: --x_auction_header_id NUMBER;
3452: --x_user_name fnd_user.user_name%TYPE;
3453:
3454: x_language_code VARCHAR2(4);
3455: x_round_number NUMBER;
3456: x_line_number NUMBER;
3948: FROM dual;
3949:
3950: SELECT employee_id
3951: INTO x_preparer_id
3952: FROM fnd_user
3953: WHERE user_id = p_user_id;
3954:
3955: x_doc_id:= p_po_header_id;
3956:
4129: x_substr VARCHAR2(4000);
4130: x_auction_header_id NUMBER;
4131: x_round_number NUMBER;
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;
4291: x_index NUMBER;
4292: x_substr VARCHAR2(4000);
4293: x_auction_header_id NUMBER;
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;