APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PER_JOBS

Line 406: per_jobs pjo

402: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_line_number NUMBER) IS
403: SELECT itm.document_disp_line_number, itm.item_number, itm.item_revision, itm.item_description,
404: itm.requisition_number, pjo.name
405: FROM pon_auction_item_prices_all itm,
406: per_jobs pjo
407: WHERE itm.auction_header_id = p_auction_header_id AND
408: itm.line_number = p_line_number AND
409: pjo.job_id (+) = itm.job_id;
410:

Line 583: per_jobs pjo,

579: CURSOR wf_item_cur (p_auction_header_id NUMBER, p_orig_req_line_id NUMBER) IS
580: SELECT distinct paa.bid_line_number, itm.item_number, itm.item_revision, itm.item_description,
581: itm.requisition_number, pjo.name
582: FROM pon_auction_item_prices_all itm,
583: per_jobs pjo,
584: pon_award_allocations paa
585: WHERE paa.auction_header_id = itm.auction_header_id AND
586: paa.bid_line_number = itm.line_number AND
587: paa.orig_req_line_id = p_orig_req_line_id AND

Line 4514: x_job_name PER_JOBS.NAME%TYPE;

4510: x_item_number pon_auction_item_prices_all.ITEM_NUMBER%TYPE;
4511: x_item_description pon_auction_item_prices_all.ITEM_DESCRIPTION%TYPE;
4512: x_item_revision pon_auction_item_prices_all.ITEM_REVISION%TYPE;
4513: x_requisition_number PON_AUCTION_ITEM_PRICES_ALL.REQUISITION_NUMBER%TYPE;
4514: x_job_name PER_JOBS.NAME%TYPE;
4515: x_document_disp_line_number PON_AUCTION_ITEM_PRICES_ALL.DOCUMENT_DISP_LINE_NUMBER%TYPE;
4516: l_resultout VARCHAR2(10);
4517:
4518: x_open_bidding_date date;