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 990: pon_bid_headers bh,

986: bl.bid_currency_unit_price
987: BULK COLLECT INTO l_award_col, l_bid_number_col, l_bid_price_col
988: FROM pon_auction_item_prices_all itm,
989: pon_bid_item_prices bl,
990: pon_bid_headers bh,
991: pon_auction_headers_all pah
992: WHERE itm.auction_header_id = p_auctionID AND
993: itm.line_number = p_line_number AND
994: bl.line_number = itm.line_number AND

Line 1725: pon_bid_headers pbh,

1721: pah.po_style_id,
1722: pah.progress_payment_type,
1723: pah.supplier_enterable_pymt_flag
1724: FROM pon_auction_headers_all pah,
1725: pon_bid_headers pbh,
1726: fnd_currencies fc
1727: WHERE pah.auction_header_id = p_auction_header_id and
1728: pbh.auction_header_id = pah.auction_header_id and
1729: pbh.bid_number = p_bid_number and

Line 1789: pon_bid_headers pbh,

1785: FROM
1786: pon_auction_item_prices_all paip,
1787: pon_bid_item_prices pbip,
1788: mtl_units_of_measure mtluom,
1789: pon_bid_headers pbh,
1790: fnd_currencies fc
1791: WHERE pbip.bid_number = p_bid_number and
1792: pbip.auction_header_id = p_auction_header_id and
1793: nvl(pbip.award_status, 'NO') = 'AWARDED' and

Line 2512: pon_bid_headers pbh,

2508: FROM
2509: pon_auction_item_prices_all paip,
2510: pon_bid_item_prices pbip,
2511: mtl_units_of_measure mtluom,
2512: pon_bid_headers pbh,
2513: fnd_currencies fc,
2514: pon_bid_shipments pbs
2515: WHERE
2516: pbip.bid_number = p_bid_number and

Line 2833: pon_bid_headers pbh,

2829: null) -- amount
2830: FROM pon_auction_item_prices_all paip,
2831: pon_bid_item_prices pbip,
2832: mtl_units_of_measure mtluom,
2833: pon_bid_headers pbh,
2834: fnd_currencies fc,
2835: pon_bid_shipments pbs
2836: WHERE pbip.bid_number = p_bid_number and
2837: pbip.auction_header_id = p_auction_header_id and

Line 3460: x_order_number pon_bid_headers.order_number%TYPE;

3456: x_line_number NUMBER;
3457: x_bid_number NUMBER;
3458: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3459: x_po_header_id NUMBER;
3460: x_order_number pon_bid_headers.order_number%TYPE;
3461: x_interface_header_id NUMBER;
3462: x_last_update_date pon_auction_headers_all.last_update_date%TYPE;
3463: x_auction_start_date DATE;
3464: x_auction_end_date DATE;

Line 3511: FROM pon_bid_headers pbh

3507: */
3508:
3509: CURSOR awardedBids IS
3510: SELECT pbh.bid_number
3511: FROM pon_bid_headers pbh
3512: WHERE pbh.auction_header_id = p_auction_header_id and
3513: nvl(pbh.bid_status, 'NONE') = 'ACTIVE' and
3514: pbh.po_header_id is NULL and
3515: nvl(pbh.award_status, 'NO') IN ('AWARDED', 'PARTIAL')

Line 3776: UPDATE pon_bid_headers

3772: x_pdoi_header.order_number := x_order_number;
3773: END IF;
3774:
3775:
3776: UPDATE pon_bid_headers
3777: SET po_header_id = decode(x_error_code, PO_SUCCESS, x_po_header_id, null),
3778: order_number = x_order_number,
3779: po_error_code = x_error_code,
3780: po_error_msg = x_error_msg,

Line 4082: FROM pon_bid_headers pbh

4078:
4079:
4080: SELECT count(pbh.bid_number)
4081: INTO x_number_of_failed_pos
4082: FROM pon_bid_headers pbh
4083: WHERE pbh.auction_header_id = x_auction_header_id and
4084: nvl(pbh.bid_status, 'NONE') not in ('ARCHIVED', 'DISQUALIFIED') and
4085: pbh.po_header_id is NULL and
4086: nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL');

Line 4134: x_bid_number pon_bid_headers.bid_number%TYPE;

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

Line 4138: x_order_number pon_bid_headers.order_number%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);
4140: msgBid varchar2(2000);
4141: msgSupplier varchar2(2000);
4142: msgSupplierSite varchar2(2000);

Line 4167: FROM pon_bid_headers pbh,

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

Line 4300: x_order_number pon_bid_headers.order_number%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;
4302: po_status varchar2(4000);
4303: msgBid varchar2(2000);
4304: msgSupplier varchar2(2000);

Line 4301: x_error_code pon_bid_headers.po_error_code%TYPE;

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;
4302: po_status varchar2(4000);
4303: msgBid varchar2(2000);
4304: msgSupplier varchar2(2000);
4305: msgSupplierSite varchar2(2000);

Line 4322: x_error_msg pon_bid_headers.po_error_msg%type;

4318: x_progress FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4319: itemkey pon_auction_headers_all.wf_poncompl_item_key%TYPE;
4320: x_purchase_orders VARCHAR2(30);
4321: x_contract_type pon_auction_headers_all.contract_type%TYPE;
4322: x_error_msg pon_bid_headers.po_error_msg%type;
4323:
4324: CURSOR failedPOs is
4325: SELECT pbh.bid_number,
4326: pov.vendor_name,

Line 4332: FROM pon_bid_headers pbh,

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

Line 4747: FROM pon_bid_headers pbh

4743: x_number_of_failed_pos := 0;
4744:
4745: SELECT count(pbh.bid_number)
4746: INTO x_number_of_failed_pos
4747: FROM pon_bid_headers pbh
4748: WHERE pbh.auction_header_id = p_auction_header_id and
4749: nvl(pbh.bid_status, 'NONE') = 'ACTIVE' and
4750: pbh.po_header_id is NULL and
4751: nvl(pbh.award_status, 'NO') in ('AWARDED', 'PARTIAL');

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

4848:
4849: x_itemkey := (to_char(p_auction_header_id)||'-'||to_char(x_sequence));
4850:
4851: -- update pon_auction_headers_all.wf_poncompl_current_round by incrementing by one
4852: -- update pon_bid_headers.po_wf_creation_rnd by incrementing by one
4853:
4854: UPDATE pon_auction_headers_all set
4855: wf_poncompl_item_key = x_itemkey,
4856: wf_poncompl_current_round = x_current_round+1,

Line 4860: UPDATE pon_bid_headers set

4856: wf_poncompl_current_round = x_current_round+1,
4857: last_update_date = sysdate
4858: WHERE auction_header_id = p_auction_header_id;
4859:
4860: UPDATE pon_bid_headers set
4861: po_wf_creation_rnd = x_current_round+1
4862: WHERE auction_header_id = p_auction_header_id;
4863:
4864: log_message(++l_progress || l_api_name || '. invoke start_po_workflow for itemkey=' || x_itemkey);