APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_VENDORS

Line 5117: x_vendor_name po_vendors.vendor_name%TYPE;

5113: x_round_number NUMBER;
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);

Line 5150: po_vendors pov,

5146: pbh.vendor_site_code,
5147: papf.full_name,
5148: pbh.order_number
5149: FROM pon_bid_headers pbh,
5150: po_vendors pov,
5151: per_all_people_f papf
5152: WHERE pbh.auction_header_id = x_auction_header_id
5153: AND pbh.bid_status = 'ACTIVE'
5154: AND pbh.po_header_id is NOT NULL

Line 5282: x_vendor_name po_vendors.vendor_name%TYPE;

5278: x_auction_header_id NUMBER;
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;

Line 5318: po_vendors pov,

5314: pbh.order_number,
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'