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_BID_DEFAULTING_PKG dependencies on PO_LINES_ALL

Line 5612: PROCEDURE update_bid_line_to_po_line(p_po_line_id IN po_lines_all.po_line_id%TYPE,

5608: /* Bug 10052785 - Start */
5609: /* Added cost constraint to the procedure variables. This variable value
5610: is used to update pon_bid_item_prices table's data. */
5611:
5612: PROCEDURE update_bid_line_to_po_line(p_po_line_id IN po_lines_all.po_line_id%TYPE,
5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,
5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,

Line 5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,

5609: /* Added cost constraint to the procedure variables. This variable value
5610: is used to update pon_bid_item_prices table's data. */
5611:
5612: PROCEDURE update_bid_line_to_po_line(p_po_line_id IN po_lines_all.po_line_id%TYPE,
5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,
5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,
5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,

Line 5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,

5610: is used to update pon_bid_item_prices table's data. */
5611:
5612: PROCEDURE update_bid_line_to_po_line(p_po_line_id IN po_lines_all.po_line_id%TYPE,
5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,
5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,
5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,
5618: p_po_type IN po_lines_all.order_type_lookup_code%TYPE,

Line 5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,

5611:
5612: PROCEDURE update_bid_line_to_po_line(p_po_line_id IN po_lines_all.po_line_id%TYPE,
5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,
5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,
5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,
5618: p_po_type IN po_lines_all.order_type_lookup_code%TYPE,
5619: p_bid_number IN NUMBER,

Line 5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,

5612: PROCEDURE update_bid_line_to_po_line(p_po_line_id IN po_lines_all.po_line_id%TYPE,
5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,
5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,
5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,
5618: p_po_type IN po_lines_all.order_type_lookup_code%TYPE,
5619: p_bid_number IN NUMBER,
5620: p_auction_header_id IN NUMBER,

Line 5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,

5613: p_po_contract_type IN po_lines_all.contract_type%TYPE,
5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,
5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,
5618: p_po_type IN po_lines_all.order_type_lookup_code%TYPE,
5619: p_bid_number IN NUMBER,
5620: p_auction_header_id IN NUMBER,
5621: p_bid_line_number IN NUMBER) IS

Line 5618: p_po_type IN po_lines_all.order_type_lookup_code%TYPE,

5614: p_po_unit_price IN po_lines_all.unit_price%TYPE,
5615: p_po_clm_idc_type IN po_lines_all.clm_idc_type%TYPE,
5616: p_po_cost_constraint IN po_lines_all.cost_constraint%TYPE,
5617: p_po_quantity IN po_lines_all.cost_constraint%TYPE,
5618: p_po_type IN po_lines_all.order_type_lookup_code%TYPE,
5619: p_bid_number IN NUMBER,
5620: p_auction_header_id IN NUMBER,
5621: p_bid_line_number IN NUMBER) IS
5622:

Line 5687: (po_line_id po_lines_all.po_line_id%TYPE,

5683: category_id pon_bid_item_prices.category_id%TYPE,
5684: line_type_id pon_auction_item_prices_all.line_type_id%TYPE);
5685:
5686: TYPE po_line_info_record_type IS RECORD
5687: (po_line_id po_lines_all.po_line_id%TYPE,
5688: description po_lines_all.item_description%TYPE,
5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,

Line 5688: description po_lines_all.item_description%TYPE,

5684: line_type_id pon_auction_item_prices_all.line_type_id%TYPE);
5685:
5686: TYPE po_line_info_record_type IS RECORD
5687: (po_line_id po_lines_all.po_line_id%TYPE,
5688: description po_lines_all.item_description%TYPE,
5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,

Line 5689: category_id po_lines_all.category_id%TYPE,

5685:
5686: TYPE po_line_info_record_type IS RECORD
5687: (po_line_id po_lines_all.po_line_id%TYPE,
5688: description po_lines_all.item_description%TYPE,
5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,

Line 5690: line_type_id po_lines_all.line_type_id%TYPE,

5686: TYPE po_line_info_record_type IS RECORD
5687: (po_line_id po_lines_all.po_line_id%TYPE,
5688: description po_lines_all.item_description%TYPE,
5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,

Line 5691: --base_uom po_lines_all.base_uom%TYPE,

5687: (po_line_id po_lines_all.po_line_id%TYPE,
5688: description po_lines_all.item_description%TYPE,
5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,

Line 5692: contract_type po_lines_all.contract_type%TYPE,

5688: description po_lines_all.item_description%TYPE,
5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,
5696: quantity po_lines_all.quantity%TYPE,

Line 5693: unit_price po_lines_all.unit_price%TYPE,

5689: category_id po_lines_all.category_id%TYPE,
5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,
5696: quantity po_lines_all.quantity%TYPE,
5697: order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE);

Line 5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,

5690: line_type_id po_lines_all.line_type_id%TYPE,
5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,
5696: quantity po_lines_all.quantity%TYPE,
5697: order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE);
5698:

Line 5695: cost_constraint po_lines_all.cost_constraint%TYPE,

5691: --base_uom po_lines_all.base_uom%TYPE,
5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,
5696: quantity po_lines_all.quantity%TYPE,
5697: order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE);
5698:
5699: TYPE bid_info_table_type is table of bid_info_record_type index by binary_integer;

Line 5696: quantity po_lines_all.quantity%TYPE,

5692: contract_type po_lines_all.contract_type%TYPE,
5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,
5696: quantity po_lines_all.quantity%TYPE,
5697: order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE);
5698:
5699: TYPE bid_info_table_type is table of bid_info_record_type index by binary_integer;
5700: bid_info_table bid_info_table_type;

Line 5697: order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE);

5693: unit_price po_lines_all.unit_price%TYPE,
5694: clm_idc_type po_lines_all.clm_idc_type%TYPE,
5695: cost_constraint po_lines_all.cost_constraint%TYPE,
5696: quantity po_lines_all.quantity%TYPE,
5697: order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE);
5698:
5699: TYPE bid_info_table_type is table of bid_info_record_type index by binary_integer;
5700: bid_info_table bid_info_table_type;
5701:

Line 5715: from po_lines_all

5711: select po_line_id,item_description,category_id,line_type_id,
5712: contract_type,unit_price,clm_idc_type,cost_constraint,
5713: quantity, order_type_lookup_code
5714: bulk collect into po_line_info_table
5715: from po_lines_all
5716: where po_header_id = p_po_header_id;
5717:
5718: select bid.line_number,bid.item_description,
5719: bid.category_id,auction.line_type_id

Line 5794: l_contract_type po_lines_all.contract_type%TYPE;

5790: x_return_status OUT NOCOPY VARCHAR2,
5791: x_msg_count OUT NOCOPY NUMBER,
5792: x_msg_data OUT NOCOPY VARCHAR2) IS
5793:
5794: l_contract_type po_lines_all.contract_type%TYPE;
5795: l_unit_price po_lines_all.unit_price%TYPE;
5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;

Line 5795: l_unit_price po_lines_all.unit_price%TYPE;

5791: x_msg_count OUT NOCOPY NUMBER,
5792: x_msg_data OUT NOCOPY VARCHAR2) IS
5793:
5794: l_contract_type po_lines_all.contract_type%TYPE;
5795: l_unit_price po_lines_all.unit_price%TYPE;
5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;
5799: l_quantity po_lines_all.quantity%TYPE;

Line 5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;

5792: x_msg_data OUT NOCOPY VARCHAR2) IS
5793:
5794: l_contract_type po_lines_all.contract_type%TYPE;
5795: l_unit_price po_lines_all.unit_price%TYPE;
5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;
5799: l_quantity po_lines_all.quantity%TYPE;
5800: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;

Line 5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;

5794: l_contract_type po_lines_all.contract_type%TYPE;
5795: l_unit_price po_lines_all.unit_price%TYPE;
5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;
5799: l_quantity po_lines_all.quantity%TYPE;
5800: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;
5801:
5802: BEGIN

Line 5799: l_quantity po_lines_all.quantity%TYPE;

5795: l_unit_price po_lines_all.unit_price%TYPE;
5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;
5799: l_quantity po_lines_all.quantity%TYPE;
5800: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;
5801:
5802: BEGIN
5803: select auction_header_id

Line 5800: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;

5796: l_clm_idc_type po_lines_all.clm_idc_type%TYPE;
5797: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
5798: l_cost_constraint po_lines_all.cost_constraint%TYPE;
5799: l_quantity po_lines_all.quantity%TYPE;
5800: l_order_type_lookup_code po_lines_all.order_type_lookup_code%TYPE;
5801:
5802: BEGIN
5803: select auction_header_id
5804: into l_auction_header_id

Line 5810: from po_lines_all

5806: where bid_number = p_bid_header_id;
5807:
5808: select contract_type,unit_price,clm_idc_type,cost_constraint,quantity,order_type_lookup_code
5809: into l_contract_type,l_unit_price,l_clm_idc_type,l_cost_constraint,l_quantity,l_order_type_lookup_code
5810: from po_lines_all
5811: where po_line_id = p_po_line_id;
5812:
5813: update_bid_line_to_po_line(p_po_line_id,
5814: l_contract_type,