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 PON_AUCTION_ITEM_PRICES_ALL

Line 237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

233: sysdate, -- LAST_UPDATE_DATE
234: p_userid, -- LAST_UPDATED_BY
235: null, -- LAST_UPDATE_LOGIN
236: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
238: WHERE apb.auction_header_id = p_auc_header_id
239: AND aip.auction_header_id = apb.auction_header_id
240: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
241: AND aip.line_number = apb.line_number

Line 351: FROM pon_auction_item_prices_all al

347: 'N', -- HAS_BID_FLAG
348: 'N', -- HAS_BID_PAYMENTS_FLAG
349: al.bid_start_price, -- BID_START_PRICE
350: al.has_quantity_tiers -- HAS_QUANTITY_TIERS
351: FROM pon_auction_item_prices_all al
352: WHERE al.auction_header_id = p_auc_header_id
353: AND al.line_number BETWEEN p_batch_start AND p_batch_end
354: AND NOT EXISTS
355: (SELECT bl.line_number

Line 371: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al

367: WHERE bl.bid_number = p_bid_number
368: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
369: AND EXISTS
370: (SELECT le.line_number
371: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al
372: WHERE al.auction_header_id = p_auc_header_id
373: AND al.line_number = bl.line_number
374: AND le.auction_header_id = al.auction_header_id
375: AND le.line_number = nvl(al.parent_line_number, al.line_number)

Line 623: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

619: sysdate, -- LAST_UPDATE_DATE
620: p_userid, -- LAST_UPDATED_BY
621: null, -- LAST_UPDATE_LOGIN
622: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
623: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
624: WHERE apb.auction_header_id = p_auc_header_id
625: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
626: AND aip.auction_header_id = apb.auction_header_id
627: AND aip.line_number = apb.line_number

Line 1568: FROM pon_auction_item_prices_all al,

1564: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_PERIOD, null), -- CLM_PROMISE_PERIOD
1565: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_PERIOD_UOM, null), -- CLM_PROMISE_PERIOD_UOM
1566: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_POP_DURATION, null), -- CLM_PROMISE_POP_DURATION
1567: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_POP_DURATION_UOM, null) -- CLM_PROMISE_POP_DURATION_UOM
1568: FROM pon_auction_item_prices_all al,
1569: pon_auction_item_prices_all old_al,
1570: pon_bid_item_prices bl
1571: WHERE al.auction_header_id = p_auc_header_id
1572: AND bl.bid_number(+) = p_source_bid_num

Line 1569: pon_auction_item_prices_all old_al,

1565: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_PERIOD_UOM, null), -- CLM_PROMISE_PERIOD_UOM
1566: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_POP_DURATION, null), -- CLM_PROMISE_POP_DURATION
1567: decode(al.modified_date-old_al.modified_date,0, bl.CLM_PROMISE_POP_DURATION_UOM, null) -- CLM_PROMISE_POP_DURATION_UOM
1568: FROM pon_auction_item_prices_all al,
1569: pon_auction_item_prices_all old_al,
1570: pon_bid_item_prices bl
1571: WHERE al.auction_header_id = p_auc_header_id
1572: AND bl.bid_number(+) = p_source_bid_num
1573: AND bl.line_number(+) = al.line_number

Line 1599: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1

1595: -- update the bid_start_price for the current bid lines
1596: -- using values from the previous round auction/bid
1597: UPDATE pon_bid_item_prices bl
1598: SET bid_start_price = nvl((SELECT pon_bid_defaulting_pkg.apply_price_factors(p_auc_header_id, l_prev_rnd_active_bid_number, al.line_number, bl1.unit_price, bl1.quantity)
1599: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1
1600: WHERE al.auction_header_id = l_auction_header_id_prev_round
1601: AND al.line_number = bl.line_number
1602: AND al.line_number = bl1.line_number
1603: AND bl1.bid_number = l_prev_rnd_active_bid_number), bid_start_price)

Line 1623: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al

1619: WHERE bl.bid_number = p_bid_number
1620: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1621: AND EXISTS
1622: (SELECT le.line_number
1623: FROM pon_party_line_exclusions le, pon_auction_item_prices_all al
1624: WHERE al.auction_header_id = p_auc_header_id
1625: AND al.line_number = bl.line_number
1626: AND le.auction_header_id = al.auction_header_id
1627: AND le.line_number = coalesce(al.parent_line_number, al.group_line_id, al.clm_base_line_num,al.line_number)

Line 1645: FROM pon_auction_item_prices_all al

1641: AND bl_outer.line_number IN
1642: (SELECT al_outer.line_number
1643: FROM pon_auction_exhibit_details exh_outer,
1644: (SELECT al.line_number line_number
1645: FROM pon_auction_item_prices_all al
1646: WHERE al.auction_header_id = p_auc_header_id
1647: AND NOT EXISTS
1648: (SELECT bl.line_number
1649: FROM pon_bid_item_prices bl

Line 1653: pon_auction_item_prices_all al_outer

1649: FROM pon_bid_item_prices bl
1650: WHERE bl.auction_header_id = al.auction_header_id
1651: AND bl.bid_number = p_bid_number
1652: AND bl.line_number = al.line_number)) missing_bid_lines,
1653: pon_auction_item_prices_all al_outer
1654: WHERE exh_outer.auction_header_id = p_auc_header_id
1655: AND Nvl(exh_outer.is_cdrl, 'N') = 'N'
1656: AND exh_outer.associated_to_line = missing_bid_lines.line_number
1657: AND al_outer.auction_header_id = exh_outer.auction_header_id

Line 1687: FROM pon_auction_item_prices_all al

1683: DELETE FROM pon_bid_item_prices bl
1684: WHERE bl.bid_number = p_bid_number
1685: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1686: AND EXISTS (SELECT al.line_number
1687: FROM pon_auction_item_prices_all al
1688: WHERE al.auction_header_id = p_auc_header_id
1689: AND al.line_number = bl.line_number
1690: AND al.close_bidding_date < l_closed_compare_date);
1691: END IF;

Line 2767: FROM pon_auction_item_prices_all al

2763: OR EXISTS
2764:
2765: -- Check auction side to check quantity
2766: (SELECT al.line_number
2767: FROM pon_auction_item_prices_all al
2768: WHERE al.auction_header_id = bl.auction_header_id
2769: AND al.line_number = bl.line_number
2770: AND (l_full_qty_reqd <> 'Y'
2771: AND al.order_type_lookup_code <> 'AMOUNT'

Line 2909: l_order_type_lookup_type pon_auction_item_prices_all.order_type_lookup_code%TYPE;

2905: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
2906: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;
2907: l_line_number pon_bid_item_prices.line_number%TYPE;
2908:
2909: l_order_type_lookup_type pon_auction_item_prices_all.order_type_lookup_code%TYPE;
2910: l_auc_quantity pon_auction_item_prices_all.quantity%TYPE;
2911:
2912: l_rate PON_BID_HEADERS.RATE%TYPE;
2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;

Line 2910: l_auc_quantity pon_auction_item_prices_all.quantity%TYPE;

2906: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;
2907: l_line_number pon_bid_item_prices.line_number%TYPE;
2908:
2909: l_order_type_lookup_type pon_auction_item_prices_all.order_type_lookup_code%TYPE;
2910: l_auc_quantity pon_auction_item_prices_all.quantity%TYPE;
2911:
2912: l_rate PON_BID_HEADERS.RATE%TYPE;
2913: l_tp_id PON_BID_HEADERS.TRADING_PARTNER_ID%TYPE;
2914: l_vendor_site_id PON_BID_HEADERS.VENDOR_SITE_ID%TYPE;

Line 2936: FROM PON_BID_ITEM_PRICES pbip, pon_auction_item_prices_all paip

2932: l_price NUMBER;
2933:
2934: CURSOR bid_values IS
2935: SELECT pbip.DISPLAY_PRICE_FACTORS_FLAG, pbip.quantity AS bid_quantity, pbip.bid_currency_unit_price, pbip.line_number, paip.order_type_lookup_code, paip.quantity AS auc_quantity
2936: FROM PON_BID_ITEM_PRICES pbip, pon_auction_item_prices_all paip
2937: WHERE paip.auction_header_id = p_auc_header_id
2938: AND pbip.bid_number = x_bid_number
2939: AND pbip.line_number(+) = paip.line_number;
2940:

Line 5429: FROM PON_AUCTION_ITEM_PRICES_ALL pai,

5425: SELECT 'Y'
5426: INTO x_can_create_payments
5427: FROM dual
5428: WHERE EXISTS (SELECT 1
5429: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
5430: PON_BID_ITEM_PRICES pbi,
5431: PON_AUCTION_HEADERS_ALL pah
5432: WHERE pai.auction_header_id = p_auction_header_id
5433: AND pai.group_type NOT IN ('GROUP','LOT_LINE')

Line 5533: pon_auction_item_prices_all aip,

5529: nvl(aip.quantity, 1)
5530: )
5531: INTO l_auc_pf_unit_price
5532: FROM pon_pf_supplier_formula ppsf,
5533: pon_auction_item_prices_all aip,
5534: pon_bid_headers pbh
5535: WHERE ppsf.auction_header_id = p_auction_header_id
5536: AND ppsf.line_number = p_line_number
5537: AND ppsf.trading_partner_id = pbh.trading_partner_id

Line 5567: pon_auction_item_prices_all aip

5563: )
5564: ,0)
5565: INTO l_bid_line_pf_unit_price
5566: FROM pon_bid_price_elements spf,
5567: pon_auction_item_prices_all aip
5568: WHERE spf.bid_number = p_prev_auc_active_bid_number
5569: AND spf.line_number = p_line_number
5570: AND spf.sequence_number <> -10
5571: AND spf.pf_type = 'SUPPLIER'

Line 5655: quantity = NVL((SELECT quantity FROM pon_auction_item_prices_all

5651: Bid_currency_unit_price = l_bid_curr_unit_price,
5652: bid_currency_price = l_bid_curr_unit_price,
5653: clm_idc_type = p_po_clm_idc_type,
5654: clm_cost_constraint = p_po_cost_constraint,
5655: quantity = NVL((SELECT quantity FROM pon_auction_item_prices_all
5656: WHERE auction_header_id = p_auction_header_id
5657: AND line_number = p_bid_line_number),quantity)
5658: WHERE auction_header_id = p_auction_header_id
5659: AND bid_number = p_bid_number

Line 5684: line_type_id pon_auction_item_prices_all.line_type_id%TYPE);

5680: TYPE bid_info_record_type IS RECORD
5681: (line_number pon_bid_item_prices.line_number%TYPE,
5682: description pon_bid_item_prices.item_description%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,

Line 5723: pon_auction_item_prices_all auction

5719: bid.category_id,auction.line_type_id
5720: bulk collect into bid_info_table
5721: from
5722: pon_bid_item_prices bid,
5723: pon_auction_item_prices_all auction
5724: where bid.bid_number = p_bid_number
5725: and bid.auction_header_id = auction.auction_header_id;
5726:
5727: IF po_line_info_table.first > 0 AND bid_info_table.first > 0 THEN

Line 5856: l_contract_type pon_auction_item_prices_all.clm_contract_type%TYPE;

5852: l_auction_template_id NUMBER;
5853: l_doctype_id NUMBER;
5854: l_uda_template_id NUMBER;
5855: l_is_uda_enabled NUMBER;
5856: l_contract_type pon_auction_item_prices_all.clm_contract_type%TYPE;
5857: l_clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE;
5858: l_cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE;
5859: l_err_msg VARCHAR2(100);
5860: l_return_status VARCHAR2(1);

Line 5857: l_clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE;

5853: l_doctype_id NUMBER;
5854: l_uda_template_id NUMBER;
5855: l_is_uda_enabled NUMBER;
5856: l_contract_type pon_auction_item_prices_all.clm_contract_type%TYPE;
5857: l_clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE;
5858: l_cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE;
5859: l_err_msg VARCHAR2(100);
5860: l_return_status VARCHAR2(1);
5861: l_msg_count NUMBER;

Line 5858: l_cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE;

5854: l_uda_template_id NUMBER;
5855: l_is_uda_enabled NUMBER;
5856: l_contract_type pon_auction_item_prices_all.clm_contract_type%TYPE;
5857: l_clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE;
5858: l_cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE;
5859: l_err_msg VARCHAR2(100);
5860: l_return_status VARCHAR2(1);
5861: l_msg_count NUMBER;
5862: l_msg_data VARCHAR2(1000);

Line 5865: (contract_type pon_auction_item_prices_all.clm_contract_type%TYPE,

5861: l_msg_count NUMBER;
5862: l_msg_data VARCHAR2(1000);
5863:
5864: TYPE pon_line_info_record_type IS RECORD
5865: (contract_type pon_auction_item_prices_all.clm_contract_type%TYPE,
5866: clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE,
5867: cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE,
5868: line_number pon_auction_item_prices_all.line_number%TYPE);
5869:

Line 5866: clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE,

5862: l_msg_data VARCHAR2(1000);
5863:
5864: TYPE pon_line_info_record_type IS RECORD
5865: (contract_type pon_auction_item_prices_all.clm_contract_type%TYPE,
5866: clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE,
5867: cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE,
5868: line_number pon_auction_item_prices_all.line_number%TYPE);
5869:
5870: TYPE pon_line_info_table_type is table of pon_line_info_record_type index by binary_integer;

Line 5867: cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE,

5863:
5864: TYPE pon_line_info_record_type IS RECORD
5865: (contract_type pon_auction_item_prices_all.clm_contract_type%TYPE,
5866: clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE,
5867: cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE,
5868: line_number pon_auction_item_prices_all.line_number%TYPE);
5869:
5870: TYPE pon_line_info_table_type is table of pon_line_info_record_type index by binary_integer;
5871: pon_line_info_table pon_line_info_table_type;

Line 5868: line_number pon_auction_item_prices_all.line_number%TYPE);

5864: TYPE pon_line_info_record_type IS RECORD
5865: (contract_type pon_auction_item_prices_all.clm_contract_type%TYPE,
5866: clm_idc_type pon_auction_item_prices_all.clm_idc_type%TYPE,
5867: cost_constraint pon_auction_item_prices_all.clm_cost_constraint%TYPE,
5868: line_number pon_auction_item_prices_all.line_number%TYPE);
5869:
5870: TYPE pon_line_info_table_type is table of pon_line_info_record_type index by binary_integer;
5871: pon_line_info_table pon_line_info_table_type;
5872:

Line 5896: from pon_auction_item_prices_all

5892: bid_number = p_bid_number;
5893:
5894: select clm_contract_type, clm_idc_type, clm_cost_constraint, line_number
5895: bulk collect into pon_line_info_table
5896: from pon_auction_item_prices_all
5897: where auction_header_id = p_auction_header_id;
5898:
5899:
5900: FOR i IN pon_line_info_table.first..pon_line_info_table.last

Line 5911: FROM pon_auction_item_prices_all

5907: bid_number = p_bid_number and
5908: auction_line_number = pon_line_info_table(i).line_number;
5909:
5910: SELECT uda_template_id INTO l_auction_template_id
5911: FROM pon_auction_item_prices_all
5912: WHERE auction_header_id = p_auction_header_id AND
5913: line_number = pon_line_info_table(i).line_number;
5914:
5915: BEGIN

Line 5947: from pon_auction_item_prices_all

5943: END LOOP;
5944: ELSE
5945: select clm_contract_type, clm_idc_type, clm_cost_constraint, uda_template_id
5946: into l_contract_type, l_clm_idc_type, l_cost_constraint, l_auction_template_id
5947: from pon_auction_item_prices_all
5948: where auction_header_id = p_auction_header_id AND
5949: line_number = p_auction_line_number;
5950:
5951: UPDATE pon_bid_item_prices

Line 6060: pon_auction_item_prices_all items,

6056: x_max_internal_line_num
6057: --x_max_document_line_num,
6058: --x_max_disp_line_num
6059: FROM
6060: pon_auction_item_prices_all items,
6061: pon_bid_item_prices bid_items
6062: WHERE
6063: items.auction_header_id = p_auction_header_id
6064: and bid_items.bid_number = p_bid_number