APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PER_JOBS

Line 432: per_jobs pjo

428: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_line_number NUMBER) IS
429: SELECT itm.document_disp_line_number, itm.item_number, itm.item_revision, itm.item_description,
430: itm.requisition_number, pjo.name
431: FROM pon_auction_item_prices_all itm,
432: per_jobs pjo
433: WHERE itm.auction_header_id = p_auction_header_id AND
434: itm.line_number = p_line_number AND
435: pjo.job_id (+) = itm.job_id;
436:

Line 609: per_jobs pjo,

605: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_orig_req_line_id NUMBER) IS
606: SELECT distinct paa.bid_line_number, itm.item_number, itm.item_revision, itm.item_description,
607: itm.requisition_number, pjo.name
608: FROM pon_auction_item_prices_all itm,
609: per_jobs pjo,
610: pon_award_allocations paa
611: WHERE paa.auction_header_id = itm.auction_header_id AND
612: paa.bid_line_number = itm.line_number AND
613: paa.orig_req_line_id = p_orig_req_line_id AND

Line 5502: x_job_name PER_JOBS.NAME%TYPE;

5498: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
5499: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
5500: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
5501: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
5502: x_job_name PER_JOBS.NAME%TYPE;
5503: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
5504: l_resultout VARCHAR2(10);
5505:
5506: x_open_bidding_date date;