eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_HEADERS

Line 1049: pon_bid_headers bh,

1045: Decode(Nvl(itm.clm_info_flag,'N'), 'Y', 1, 0) AS clm_info_indicator
1046: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col , l_clm_info_flag
1047: FROM pon_auction_item_prices_all itm,
1048: pon_bid_item_prices bl,
1049: pon_bid_headers bh,
1050: pon_auction_headers_all pah
1051: WHERE itm.auction_header_id = p_auctionID AND
1052: itm.line_number = p_line_number AND
1053: bl.line_number = itm.line_number AND

Line 1877: pon_bid_headers pbh,

1873: pbh.external_idv,
1874: pah.umbrella_program_id,
1875: pah.fair_opp_notice_flag
1876: FROM pon_auction_headers_all pah,
1877: pon_bid_headers pbh,
1878: fnd_currencies fc
1879: WHERE pah.auction_header_id = p_auction_header_id and
1880: pbh.auction_header_id = pah.auction_header_id and
1881: pbh.bid_number = p_bid_number and

Line 1969: pon_bid_headers pbh,

1965: FROM
1966: pon_auction_item_prices_all paip,
1967: pon_bid_item_prices pbip,
1968: mtl_units_of_measure mtluom,
1969: pon_bid_headers pbh,
1970: fnd_currencies fc
1971: WHERE pbip.bid_number = p_bid_number and
1972: pbip.auction_header_id = p_auction_header_id and
1973: nvl(pbip.award_status, 'NO') = 'AWARDED' and

Line 3014: pon_bid_headers pbh,

3010: FROM
3011: pon_auction_item_prices_all paip,
3012: pon_bid_item_prices pbip,
3013: mtl_units_of_measure mtluom,
3014: pon_bid_headers pbh,
3015: fnd_currencies fc,
3016: pon_bid_shipments pbs
3017: WHERE
3018: pbip.bid_number = p_bid_number and

Line 3408: pon_bid_headers pbh,

3404: , paip.exhibit_number --ELINs project
3405: FROM pon_auction_item_prices_all paip,
3406: pon_bid_item_prices pbip,
3407: mtl_units_of_measure mtluom,
3408: pon_bid_headers pbh,
3409: fnd_currencies fc,
3410: pon_bid_shipments pbs
3411: WHERE pbip.bid_number = p_bid_number and
3412: pbip.auction_header_id = p_auction_header_id and

Line 4355: x_order_number pon_bid_headers.order_number%TYPE;

4351: x_line_number NUMBER;
4352: x_bid_number NUMBER;
4353: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4354: x_po_header_id NUMBER;
4355: x_order_number pon_bid_headers.order_number%TYPE;
4356: x_interface_header_id NUMBER;
4357: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
4358: x_auction_start_date DATE;
4359: x_auction_end_date DATE;

Line 4406: FROM pon_bid_headers pbh

4402: */
4403:
4404: CURSOR awardedBids IS
4405: SELECT pbh.bid_number
4406: FROM pon_bid_headers pbh
4407: WHERE pbh.auction_header_id = p_auction_header_id and
4408: nvl(pbh.bid_status, 'NONE') = 'ACTIVE' and
4409: --pbh.po_header_id is NULL and
4410: nvl(pbh.award_status, 'NO') IN ('AWARDED', 'PARTIAL') and

Line 4695: UPDATE pon_bid_headers

4691: x_pdoi_header.order_number := x_order_number;
4692: END IF;
4693:
4694:
4695: UPDATE pon_bid_headers
4696: SET po_header_id = decode(x_error_code, PO_SUCCESS, x_po_header_id, null),
4697: order_number = x_order_number,
4698: po_error_code = x_error_code,
4699: po_error_msg = x_error_msg,

Line 5064: FROM pon_bid_headers pbh

5060:
5061:
5062: SELECT count(pbh.bid_number)
5063: INTO x_number_of_failed_pos
5064: FROM pon_bid_headers pbh
5065: WHERE pbh.auction_header_id = x_auction_header_id and
5066: nvl(pbh.bid_status, 'NONE') not in ('ARCHIVED', 'DISQUALIFIED') and
5067: pbh.po_header_id is NULL and
5068: nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL');

Line 5116: x_bid_number pon_bid_headers.bid_number%TYPE;

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

Line 5120: x_order_number pon_bid_headers.order_number%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);
5122: msgBid varchar2(2000);
5123: msgSupplier varchar2(2000);
5124: msgSupplierSite varchar2(2000);

Line 5149: FROM pon_bid_headers pbh,

5145: pov.vendor_name,
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'

Line 5285: x_order_number pon_bid_headers.order_number%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;
5287: po_status varchar2(4000);
5288: msgBid varchar2(2000);
5289: msgSupplier varchar2(2000);

Line 5286: x_error_code pon_bid_headers.po_error_code%TYPE;

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;
5287: po_status varchar2(4000);
5288: msgBid varchar2(2000);
5289: msgSupplier varchar2(2000);
5290: msgSupplierSite varchar2(2000);

Line 5307: x_error_msg pon_bid_headers.po_error_msg%type;

5303: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5304: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
5305: x_purchase_orders VARCHAR2(30);
5306: x_contract_type pon_auction_headers_all.contract_type%TYPE;
5307: x_error_msg pon_bid_headers.po_error_msg%type;
5308:
5309: CURSOR failedPOs is
5310: SELECT pbh.bid_number,
5311: pov.vendor_name,

Line 5317: FROM pon_bid_headers pbh,

5313: papf.full_name,
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

Line 5784: FROM pon_bid_headers pbh

5780: x_number_of_failed_pos := 0;
5781:
5782: SELECT count(pbh.bid_number)
5783: INTO x_number_of_failed_pos
5784: FROM pon_bid_headers pbh
5785: WHERE pbh.auction_header_id = p_auction_header_id and
5786: nvl(pbh.bid_status, 'NONE') = 'ACTIVE' and
5787: pbh.po_header_id is NULL and
5788: nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL');

Line 5889: -- update pon_bid_headers.po_wf_creation_rnd by incrementing by one

5885:
5886: x_itemkey := (to_char(p_auction_header_id)||'-'||to_char(x_sequence));
5887:
5888: -- update pon_auction_headers_all.wf_poncompl_current_round by incrementing by one
5889: -- update pon_bid_headers.po_wf_creation_rnd by incrementing by one
5890:
5891: UPDATE pon_auction_headers_all set
5892: wf_poncompl_item_key = x_itemkey,
5893: wf_poncompl_current_round = x_current_round+1,

Line 5897: UPDATE pon_bid_headers set

5893: wf_poncompl_current_round = x_current_round+1,
5894: last_update_date = sysdate
5895: WHERE auction_header_id = p_auction_header_id;
5896:
5897: UPDATE pon_bid_headers set
5898: po_wf_creation_rnd = x_current_round+1
5899: WHERE auction_header_id = p_auction_header_id;
5900:
5901: log_message(++l_progress || l_api_name || '. invoke start_po_workflow for itemkey=' || x_itemkey);

Line 6060: SELECT bid_number FROM pon_bid_headers

6056: log_message(x_progress);
6057: end if;
6058:
6059: DELETE FROM pon_award_allocations WHERE bid_number IN (
6060: SELECT bid_number FROM pon_bid_headers
6061: WHERE auction_header_id = p_auction_header_id
6062: AND po_header_id IS NULL)
6063: AND IS_LINKED_PR_LINE_YN = 'Y';
6064:

Line 6108: pon_bid_headers pbh,

6104: l_login_id,
6105: SYSDATE
6106:
6107: FROM pon_bid_item_prices pbip,
6108: pon_bid_headers pbh,
6109: po_clmreq_lines_v prl,
6110: (SELECT pbip1.auction_header_id, pbip1.auction_line_number,pbip1.bid_number, pbip1.line_number AS bid_line_number,
6111: pbr.requisition_line_id, pbr.requisition_header_id
6112: FROM pon_bid_item_references pir, pon_bid_backing_requisitions pbr, pon_bid_item_prices pbip1