APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PO_VENDORS

Line 4135: x_vendor_name po_vendors.vendor_name%TYPE;

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;
4138: x_order_number pon_bid_headers.order_number%TYPE;
4139: po_status varchar2(4000);

Line 4168: po_vendors pov,

4164: pbh.vendor_site_code,
4165: papf.full_name,
4166: pbh.order_number
4167: FROM pon_bid_headers pbh,
4168: po_vendors pov,
4169: per_all_people_f papf
4170: WHERE pbh.auction_header_id = x_auction_header_id
4171: AND pbh.bid_status = 'ACTIVE'
4172: AND pbh.po_header_id is NOT NULL

Line 4297: x_vendor_name po_vendors.vendor_name%TYPE;

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;
4300: x_order_number pon_bid_headers.order_number%TYPE;
4301: x_error_code pon_bid_headers.po_error_code%TYPE;

Line 4333: po_vendors pov,

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