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_BID_ITEM_PRICES

Line 54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

50: (
51: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_bid_number IN pon_bid_headers.bid_number%TYPE,
53: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2
57: ) IS
58: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;

Line 55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

51: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
52: p_bid_number IN pon_bid_headers.bid_number%TYPE,
53: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
54: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
55: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
56: x_skip_pf_for_batch OUT NOCOPY VARCHAR2
57: ) IS
58: l_supplier_view pon_auction_headers_all.supplier_view_type%TYPE;
59: l_pf_type pon_auction_headers_all.pf_type_allowed%TYPE;

Line 79: UPDATE pon_bid_item_prices

75: -- or the view is untransformed (BUYER pf only)
76: IF (l_pf_type = 'NONE' OR l_has_pfs = 'N'
77: OR l_supplier_view = 'UNTRANSFORMED') THEN
78:
79: UPDATE pon_bid_item_prices
80: SET display_price_factors_flag = 'N'
81: WHERE bid_number = p_bid_number
82: AND line_number BETWEEN p_batch_start AND p_batch_end;
83:

Line 92: UPDATE pon_bid_item_prices bl

88:
89: -- Populate line level display_price_factors_flag
90: -- Y if there is a supplier price factor (besides line price)
91: -- N if not (buyer price factors handled by next sql)
92: UPDATE pon_bid_item_prices bl
93: SET bl.display_price_factors_flag =
94: nvl((SELECT 'Y'
95: FROM pon_price_elements apf
96: WHERE apf.auction_header_id = p_auc_header_id

Line 113: UPDATE pon_bid_item_prices bl

109: -- 2. The negotiation only allows SUPPLIER price factors
110: IF (p_supp_seq_number IS NOT null
111: AND l_pf_type <> 'SUPPLIER') THEN
112:
113: UPDATE pon_bid_item_prices bl
114: SET bl.display_price_factors_flag =
115: nvl((SELECT 'Y'
116: FROM pon_pf_supplier_values pfv
117: WHERE pfv.auction_header_id = p_auc_header_id

Line 131: FROM pon_bid_item_prices bl

127:
128: -- Determine if there are price factors in this batch
129: SELECT decode(count(bl.bid_number), 0, 'Y', 'N')
130: INTO x_skip_pf_for_batch
131: FROM pon_bid_item_prices bl
132: WHERE bl.bid_number = p_bid_number
133: AND bl.display_price_factors_flag = 'Y'
134: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
135: AND rownum = 1;

Line 173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

169: p_supp_seq_number IN pon_bidding_parties.sequence%TYPE,
170: p_rate IN pon_bid_headers.rate%TYPE,
171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,
172: p_curr_prec IN fnd_currencies.precision%TYPE,
173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
175: ) IS
176: l_skip_pf_for_batch VARCHAR2(1);
177: l_restricted_flag VARCHAR2(1);

Line 174: p_batch_end IN pon_bid_item_prices.line_number%TYPE

170: p_rate IN pon_bid_headers.rate%TYPE,
171: p_price_prec IN pon_bid_headers.number_price_decimals%TYPE,
172: p_curr_prec IN fnd_currencies.precision%TYPE,
173: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
174: p_batch_end IN pon_bid_item_prices.line_number%TYPE
175: ) IS
176: l_skip_pf_for_batch VARCHAR2(1);
177: l_restricted_flag VARCHAR2(1);
178: l_supp_seq_number pon_bidding_parties.sequence%TYPE;

Line 245: FROM pon_bid_item_prices pbip

241: AND aip.line_number = apb.line_number
242: AND nvl(aip.price_break_neg_flag, 'N') = 'Y'
243: AND NOT EXISTS
244: (SELECT pbip.line_number
245: FROM pon_bid_item_prices pbip
246: WHERE pbip.bid_number = p_bid_number
247: AND pbip.line_number = apb.line_number));
248:
249:

Line 273: * STEP 3: Insert missing auction lines. pon_bid_item_prices

269: END;
270:
271:
272: /************************************************************
273: * STEP 3: Insert missing auction lines. pon_bid_item_prices
274: ** has an index on (bid_number, line_number) so the EXISTS
275: ** clause does not result in a full table scan.
276: *************************************************************/
277:

Line 278: INSERT INTO pon_bid_item_prices

274: ** has an index on (bid_number, line_number) so the EXISTS
275: ** clause does not result in a full table scan.
276: *************************************************************/
277:
278: INSERT INTO pon_bid_item_prices
279: (
280: AUCTION_HEADER_ID,
281: AUCTION_LINE_NUMBER,
282: BID_NUMBER,

Line 356: FROM pon_bid_item_prices bl

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
356: FROM pon_bid_item_prices bl
357: WHERE bl.bid_number = p_bid_number
358: AND bl.line_number = al.line_number));
359:
360: /************************************************************

Line 366: DELETE FROM pon_bid_item_prices bl

362: *************************************************************/
363:
364: IF (l_restricted_flag = 'Y') THEN
365:
366: DELETE FROM pon_bid_item_prices bl
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

Line 539: pon_bid_item_prices bl

535: p_userid, -- LAST_UPDATED_BY
536: apf.pf_type -- PF_TYPE
537: FROM pon_price_elements apf,
538: pon_pf_supplier_values pf,
539: pon_bid_item_prices bl
540: WHERE apf.auction_header_id = p_auc_header_id
541: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
542: AND apf.display_to_suppliers_flag = 'Y'
543: AND bl.bid_number = p_bid_number

Line 687: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

683: PROCEDURE populate_old_value_columns
684: (
685: p_bid_number IN pon_bid_headers.bid_number%TYPE,
686: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
687: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
688: p_batch_end IN pon_bid_item_prices.line_number%TYPE
689: ) IS
690: BEGIN
691:

Line 688: p_batch_end IN pon_bid_item_prices.line_number%TYPE

684: (
685: p_bid_number IN pon_bid_headers.bid_number%TYPE,
686: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
687: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
688: p_batch_end IN pon_bid_item_prices.line_number%TYPE
689: ) IS
690: BEGIN
691:
692: -- Update line level old value columns

Line 693: UPDATE pon_bid_item_prices bl

689: ) IS
690: BEGIN
691:
692: -- Update line level old value columns
693: UPDATE pon_bid_item_prices bl
694: SET (bl.old_price,
695: bl.old_bid_currency_unit_price,
696: bl.old_bid_currency_price,
697: bl.old_bid_currency_limit_price,

Line 723: FROM pon_bid_item_prices old_bl

719: old_bl.recoupment_rate_percent,
720: old_bl.progress_pymt_rate_percent,
721: old_bl.retainage_rate_percent,
722: old_bl.bid_curr_max_retainage_amt
723: FROM pon_bid_item_prices old_bl
724: WHERE old_bl.bid_number = p_source_bid_num
725: AND old_bl.line_number = bl.line_number)
726: WHERE bl.bid_number = p_bid_number
727: AND bl.line_number BETWEEN p_batch_start AND p_batch_end;

Line 821: l_max_line_number pon_bid_item_prices.line_number%TYPE;

817: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
819: x_rebid_flag OUT NOCOPY VARCHAR2
820: ) IS
821: l_max_line_number pon_bid_item_prices.line_number%TYPE;
822: l_batch_start pon_bid_item_prices.line_number%TYPE;
823: l_batch_end pon_bid_item_prices.line_number%TYPE;
824: BEGIN
825:

Line 822: l_batch_start pon_bid_item_prices.line_number%TYPE;

818: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
819: x_rebid_flag OUT NOCOPY VARCHAR2
820: ) IS
821: l_max_line_number pon_bid_item_prices.line_number%TYPE;
822: l_batch_start pon_bid_item_prices.line_number%TYPE;
823: l_batch_end pon_bid_item_prices.line_number%TYPE;
824: BEGIN
825:
826: -- Determine the latest ACTIVE bid and set rebid_flag to Y

Line 823: l_batch_end pon_bid_item_prices.line_number%TYPE;

819: x_rebid_flag OUT NOCOPY VARCHAR2
820: ) IS
821: l_max_line_number pon_bid_item_prices.line_number%TYPE;
822: l_batch_start pon_bid_item_prices.line_number%TYPE;
823: l_batch_end pon_bid_item_prices.line_number%TYPE;
824: BEGIN
825:
826: -- Determine the latest ACTIVE bid and set rebid_flag to Y
827: -- Since there can only exist a single ACTIVE bid on an amendment for

Line 872: UPDATE pon_bid_item_prices bl

868: WHILE (l_batch_start <= l_max_line_number) LOOP
869:
870: -- Copy over price columns and set copy_price_for_proxy_flag
871: -- If the proxy has been exhausted, copy_price_for_proxy flag changed to N
872: UPDATE pon_bid_item_prices bl
873: SET (bl.price, bl.proxy_bid_limit_price, bl.bid_currency_price,
874: bl.bid_currency_limit_price, bl.bid_currency_trans_price,
875: bl.unit_price, bl.bid_currency_unit_price, bl.copy_price_for_proxy_flag,
876: bl.old_price, bl.old_bid_currency_unit_price, bl.old_bid_currency_price,

Line 884: FROM pon_bid_item_prices old_bl

880: old_bl.unit_price, old_bl.bid_currency_unit_price,
881: decode(sign(old_bl.proxy_bid_limit_price - old_bl.price),
882: 0, 'N', 'Y'),
883: old_bl.price, old_bl.bid_currency_unit_price, old_bl.bid_currency_price, old_bl.bid_currency_limit_price
884: FROM pon_bid_item_prices old_bl
885: WHERE old_bl.bid_number = x_prev_bid_number
886: AND old_bl.line_number = bl.line_number)
887: WHERE bl.bid_number = p_draft_bid_num
888: AND bl.copy_price_for_proxy_flag = 'Y'

Line 892: UPDATE pon_bid_item_prices bl

888: AND bl.copy_price_for_proxy_flag = 'Y'
889: AND bl.line_number BETWEEN l_batch_start AND l_batch_end;
890:
891: -- Copy over the rank for all lines
892: UPDATE pon_bid_item_prices bl
893: SET rank =
894: (SELECT old_bl.rank
895: FROM pon_bid_item_prices old_bl
896: WHERE old_bl.bid_number = x_prev_bid_number

Line 895: FROM pon_bid_item_prices old_bl

891: -- Copy over the rank for all lines
892: UPDATE pon_bid_item_prices bl
893: SET rank =
894: (SELECT old_bl.rank
895: FROM pon_bid_item_prices old_bl
896: WHERE old_bl.bid_number = x_prev_bid_number
897: AND old_bl.line_number = bl.line_number)
898: WHERE bl.bid_number = p_draft_bid_num
899: AND bl.line_number BETWEEN l_batch_start AND l_batch_end;

Line 1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1153: p_userid IN pon_bid_headers.created_by%TYPE,
1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1155: p_rebid_flag IN VARCHAR2,
1156: p_restricted_flag IN VARCHAR2,
1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1158: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1159: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1160: ) IS
1161: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

Line 1158: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

1154: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1155: p_rebid_flag IN VARCHAR2,
1156: p_restricted_flag IN VARCHAR2,
1157: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1158: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1159: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1160: ) IS
1161: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1162: l_blanket VARCHAR2(1);

Line 1191: INSERT INTO pon_bid_item_prices

1187: l_last_pause_date
1188: FROM pon_auction_headers_all ah
1189: WHERE ah.auction_header_id = p_auc_header_id;
1190:
1191: INSERT INTO pon_bid_item_prices
1192: (
1193: AUCTION_HEADER_ID,
1194: AUCTION_LINE_NUMBER,
1195: BID_NUMBER,

Line 1406: pon_bid_item_prices bl

1402: decode(al.modified_date-old_al.modified_date,
1403: 0, bl.has_quantity_tiers, al.has_quantity_tiers) -- HAS_quantity_tiers
1404: FROM pon_auction_item_prices_all al,
1405: pon_auction_item_prices_all old_al,
1406: pon_bid_item_prices bl
1407: WHERE al.auction_header_id = p_auc_header_id
1408: AND bl.bid_number(+) = p_source_bid_num
1409: AND bl.line_number(+) = al.line_number
1410: AND old_al.auction_header_id (+) = bl.auction_header_id

Line 1432: UPDATE pon_bid_item_prices bl

1428: IF l_prev_rnd_active_bid_number IS NOT NULL THEN
1429: -- if active bid exists then
1430: -- update the bid_start_price for the current bid lines
1431: -- using values from the previous round auction/bid
1432: UPDATE pon_bid_item_prices bl
1433: 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)
1434: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1
1435: WHERE al.auction_header_id = l_auction_header_id_prev_round
1436: AND al.line_number = bl.line_number

Line 1434: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1

1430: -- update the bid_start_price for the current bid lines
1431: -- using values from the previous round auction/bid
1432: UPDATE pon_bid_item_prices bl
1433: 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)
1434: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl1
1435: WHERE al.auction_header_id = l_auction_header_id_prev_round
1436: AND al.line_number = bl.line_number
1437: AND al.line_number = bl1.line_number
1438: AND bl1.bid_number = l_prev_rnd_active_bid_number), bid_start_price)

Line 1452: DELETE FROM pon_bid_item_prices bl

1448:
1449: -- Delete excluded lines
1450: IF (p_restricted_flag = 'Y') THEN
1451:
1452: DELETE FROM pon_bid_item_prices bl
1453: WHERE bl.bid_number = p_bid_number
1454: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1455: AND EXISTS
1456: (SELECT le.line_number

Line 1485: DELETE FROM pon_bid_item_prices bl

1481: ELSE
1482: l_closed_compare_date := sysdate;
1483: END IF;
1484:
1485: DELETE FROM pon_bid_item_prices bl
1486: WHERE bl.bid_number = p_bid_number
1487: AND bl.line_number BETWEEN p_batch_start AND p_batch_end
1488: AND EXISTS (SELECT al.line_number
1489: FROM pon_auction_item_prices_all al

Line 1613: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1609: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1611: p_userid IN pon_bid_headers.created_by%TYPE,
1612: p_rebid_flag IN VARCHAR2,
1613: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1614: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1615: ) IS
1616: BEGIN
1617:

Line 1614: p_batch_end IN pon_bid_item_prices.line_number%TYPE

1610: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1611: p_userid IN pon_bid_headers.created_by%TYPE,
1612: p_rebid_flag IN VARCHAR2,
1613: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1614: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1615: ) IS
1616: BEGIN
1617:
1618: -- Insert line attributes

Line 1663: pon_bid_item_prices bl

1659: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1660: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1661: FROM pon_auction_attributes aa,
1662: pon_bid_attribute_values ba,
1663: pon_bid_item_prices bl
1664: WHERE aa.auction_header_id = p_auc_header_id
1665: AND aa.line_number > 0
1666: AND bl.bid_number = p_bid_number
1667: AND bl.line_number = aa.line_number

Line 1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1694: p_rebid_flag IN VARCHAR2,
1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1697: ) IS
1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;

Line 1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE

1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1694: p_rebid_flag IN VARCHAR2,
1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1697: ) IS
1698: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1699: l_curr_prec fnd_currencies.precision%TYPE;
1700: l_rate pon_bid_headers.rate%TYPE;

Line 1763: pon_bid_item_prices bl

1759: apf.pf_type, -- PF_TYPE
1760: decode(p_rebid_flag, 'Y', bpf.bid_currency_value, null) -- OLD_BID_CURRENCY_VALUE
1761: FROM pon_price_elements apf,
1762: pon_bid_price_elements bpf,
1763: pon_bid_item_prices bl
1764: WHERE apf.auction_header_id = p_auc_header_id
1765: AND apf.pf_type = 'SUPPLIER' -- only for supplier price factors
1766: AND bl.bid_number = p_bid_number
1767: AND bl.line_number = apf.line_number

Line 1817: pon_bid_item_prices bl

1813: apf.pf_type, -- PF_TYPE
1814: null -- OLD_BID_CURRENCY_VALUE
1815: FROM pon_price_elements apf,
1816: pon_pf_supplier_values pf,
1817: pon_bid_item_prices bl
1818: WHERE apf.auction_header_id = p_auc_header_id
1819: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
1820: AND apf.display_to_suppliers_flag = 'Y'
1821: AND bl.bid_number = p_bid_number

Line 1852: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1848: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1850: p_userid IN pon_bid_headers.created_by%TYPE,
1851: p_rebid_flag IN VARCHAR2,
1852: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1853: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1854: ) IS
1855: BEGIN
1856:

Line 1853: p_batch_end IN pon_bid_item_prices.line_number%TYPE

1849: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1850: p_userid IN pon_bid_headers.created_by%TYPE,
1851: p_rebid_flag IN VARCHAR2,
1852: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1853: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1854: ) IS
1855: BEGIN
1856:
1857: -- Get all auction side price breaks for modified lines that had a bid

Line 1914: pon_bid_item_prices bl

1910: apb.has_price_differentials_flag, -- HAS_PRICE_DIFFERENTIALS_FLAG
1911: null, -- UNIT_PRICE
1912: null -- BID_CURRENCY_UNIT_PRICE
1913: FROM pon_auction_shipments_all apb,
1914: pon_bid_item_prices bl
1915: WHERE apb.auction_header_id = p_auc_header_id
1916: AND bl.bid_number = p_bid_number
1917: AND bl.line_number = apb.line_number
1918: -- we only insert those price breaks for which the line was modified

Line 1999: pon_bid_item_prices bl

1995: decode(p_rebid_flag, 'Y', bpb.quantity, null), -- OLD_QUANTITY
1996: decode(p_rebid_flag, 'Y', bpb.max_quantity, null), -- OLD_MAX_QUANTITY
1997: decode(p_rebid_flag, 'Y', bpb.price_type, null) -- OLD_PRICE_TYPE
1998: FROM pon_bid_shipments bpb,
1999: pon_bid_item_prices bl
2000: WHERE bpb.bid_number = p_source_bid_num
2001: AND bl.bid_number = p_bid_number
2002: AND bl.line_number = bpb.line_number
2003: -- only unmodified lines with bids

Line 2027: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2023: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2025: p_userid IN pon_bid_headers.created_by%TYPE,
2026: p_rebid_flag IN VARCHAR2,
2027: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2028: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2029: ) IS
2030: BEGIN
2031:

Line 2028: p_batch_end IN pon_bid_item_prices.line_number%TYPE

2024: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2025: p_userid IN pon_bid_headers.created_by%TYPE,
2026: p_rebid_flag IN VARCHAR2,
2027: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2028: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2029: ) IS
2030: BEGIN
2031:
2032: INSERT INTO pon_bid_price_differentials

Line 2066: pon_bid_item_prices bl

2062: null, -- LAST_UPDATE_LOGIN
2063: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2064: FROM pon_price_differentials apd,
2065: pon_bid_price_differentials bpd,
2066: pon_bid_item_prices bl
2067: WHERE apd.auction_header_id = p_auc_header_id
2068: AND apd.shipment_number = -1 -- only line level differentials
2069: AND bl.auction_header_id = apd.auction_header_id
2070: AND bl.bid_number = p_bid_number

Line 2099: pon_bid_item_prices bl

2095: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2096: FROM pon_price_differentials apd,
2097: pon_bid_price_differentials bpd,
2098: pon_bid_shipments bpb,
2099: pon_bid_item_prices bl
2100: WHERE apd.auction_header_id = p_auc_header_id
2101: AND apd.shipment_number <> -1 -- only shipment differentials
2102: AND bl.bid_number = p_bid_number
2103: AND bl.line_number = apd.line_number

Line 2141: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2137: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2138: p_userid IN pon_bid_headers.created_by%TYPE,
2139: p_rebid_flag IN VARCHAR2,
2140: p_new_round_or_amended IN VARCHAR2,
2141: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2142: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2143: ) IS
2144:
2145:

Line 2142: p_batch_end IN pon_bid_item_prices.line_number%TYPE

2138: p_userid IN pon_bid_headers.created_by%TYPE,
2139: p_rebid_flag IN VARCHAR2,
2140: p_new_round_or_amended IN VARCHAR2,
2141: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2142: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2143: ) IS
2144:
2145:
2146:

Line 2160: PON_BID_ITEM_PRICES bl

2156: FROM
2157: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2158: FND_ATTACHED_DOCUMENTS fnd,
2159: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2160: PON_BID_ITEM_PRICES bl
2161: WHERE bl.auction_header_id = p_auc_header_id
2162: AND bl.bid_number = p_bid_number
2163: AND bl.has_bid_flag = 'Y'
2164: AND dest_pay.bid_number = bl.bid_number

Line 2231: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt

2227: apmt.PAYMENT_TYPE_CODE, --PAYMENT_TYPE_CODE,
2228: apmt.QUANTITY, --QUANTITY,
2229: apmt.UOM_CODE, --UOM_CODE,
2230: bl.promised_date --PROMISED_DATE,
2231: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt
2232: WHERE bl.auction_header_id = p_auc_header_id
2233: AND bl.bid_number = p_bid_number
2234: AND bl.auction_header_id = apmt.auction_header_id
2235: AND bl.line_number = apmt.line_number

Line 2297: FROM pon_bid_item_prices bl,

2293: apmt.PAYMENT_TYPE_CODE, --PAYMENT_TYPE_CODE,
2294: apmt.QUANTITY, --QUANTITY,
2295: apmt.UOM_CODE, --UOM_CODE,
2296: bl.promised_date --PROMISED_DATE,
2297: FROM pon_bid_item_prices bl,
2298: pon_auc_payments_shipments apmt
2299: WHERE bl.auction_header_id = p_auc_header_id
2300: AND bl.bid_number = p_bid_number
2301: AND bl.auction_header_id = apmt.auction_header_id

Line 2378: FROM pon_bid_item_prices bl,

2374: decode(p_rebid_flag, 'Y',bpmt.QUANTITY,null), --OLD_QUANTITY,
2375: decode(p_rebid_flag, 'Y',bpmt.UOM_CODE, null), --OLD_UOM_CODE,
2376: decode(p_rebid_flag, 'Y',bpmt.BID_CURRENCY_PRICE, null), --OLD_BID_CURRENCY_PRICE,
2377: decode(p_rebid_flag, 'Y',bpmt.PROMISED_DATE, null) --OLD_PROMISED_DATE
2378: FROM pon_bid_item_prices bl,
2379: pon_bid_payments_shipments bpmt
2380: WHERE bl.auction_header_id = p_auc_header_id
2381: AND bl.bid_number = p_bid_number
2382: AND bpmt.bid_number = p_source_bid_num

Line 2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2432: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,
2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2437: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2438: p_to_category_id IN NUMBER,
2439: p_change_categ_id IN VARCHAR2
2440: ) IS

Line 2437: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

2433: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2434: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2435: p_userid IN pon_bid_headers.created_by%TYPE,
2436: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2437: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2438: p_to_category_id IN NUMBER,
2439: p_change_categ_id IN VARCHAR2
2440: ) IS
2441:

Line 2444: FROM fnd_attached_documents ad, pon_bid_item_prices bl

2440: ) IS
2441:
2442: CURSOR bid_lines_with_attachments IS
2443: SELECT DISTINCT ad.pk3_value
2444: FROM fnd_attached_documents ad, pon_bid_item_prices bl
2445: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
2446: AND ad.pk1_value = p_source_header_id
2447: AND ad.pk2_value = p_source_bid_num
2448: AND ad.pk3_value IS NOT null

Line 2445: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'

2441:
2442: CURSOR bid_lines_with_attachments IS
2443: SELECT DISTINCT ad.pk3_value
2444: FROM fnd_attached_documents ad, pon_bid_item_prices bl
2445: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
2446: AND ad.pk1_value = p_source_header_id
2447: AND ad.pk2_value = p_source_bid_num
2448: AND ad.pk3_value IS NOT null
2449: AND bl.bid_number = p_bid_number

Line 2459: (x_from_entity_name => 'PON_BID_ITEM_PRICES',

2455: IF p_change_categ_id = 'Y' then
2456: -- Copy the line's attachments only for unmodified lines, with new target category.
2457: FOR line IN bid_lines_with_attachments LOOP
2458: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2459: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2460: x_from_pk1_value => p_source_header_id,
2461: x_from_pk2_value => p_source_bid_num,
2462: x_from_pk3_value => line.pk3_value,
2463: x_to_entity_name => 'PON_BID_ITEM_PRICES',

Line 2463: x_to_entity_name => 'PON_BID_ITEM_PRICES',

2459: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2460: x_from_pk1_value => p_source_header_id,
2461: x_from_pk2_value => p_source_bid_num,
2462: x_from_pk3_value => line.pk3_value,
2463: x_to_entity_name => 'PON_BID_ITEM_PRICES',
2464: x_to_pk1_value => p_auc_header_id,
2465: x_to_pk2_value => p_bid_number,
2466: x_to_pk3_value => line.pk3_value,
2467: x_created_by => p_userid,

Line 2475: (x_from_entity_name => 'PON_BID_ITEM_PRICES',

2471: ELSE
2472: -- Copy the line's attachments only for unmodified lines
2473: FOR line IN bid_lines_with_attachments LOOP
2474: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2475: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2476: x_from_pk1_value => p_source_header_id,
2477: x_from_pk2_value => p_source_bid_num,
2478: x_from_pk3_value => line.pk3_value,
2479: x_to_entity_name => 'PON_BID_ITEM_PRICES',

Line 2479: x_to_entity_name => 'PON_BID_ITEM_PRICES',

2475: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2476: x_from_pk1_value => p_source_header_id,
2477: x_from_pk2_value => p_source_bid_num,
2478: x_from_pk3_value => line.pk3_value,
2479: x_to_entity_name => 'PON_BID_ITEM_PRICES',
2480: x_to_pk1_value => p_auc_header_id,
2481: x_to_pk2_value => p_bid_number,
2482: x_to_pk3_value => line.pk3_value,
2483: x_created_by => p_userid,

Line 2513: UPDATE pon_bid_item_prices bl

2509: FROM pon_auction_headers_all ah
2510: WHERE ah.auction_header_id = p_auc_header_id;
2511:
2512: -- First set has_bid_flag to N
2513: UPDATE pon_bid_item_prices bl
2514: SET bl.has_bid_flag = 'N'
2515: WHERE bl.bid_number = p_bid_number;
2516:
2517: -- Then, determine which lines have a bid

Line 2518: UPDATE pon_bid_item_prices bl

2514: SET bl.has_bid_flag = 'N'
2515: WHERE bl.bid_number = p_bid_number;
2516:
2517: -- Then, determine which lines have a bid
2518: UPDATE pon_bid_item_prices bl
2519: SET bl.has_bid_flag = 'Y'
2520: WHERE bl.bid_number = p_bid_number
2521: AND ((bl.promised_date IS NOT null
2522: OR bl.price IS NOT null

Line 2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;

2634: l_rel12_draft VARCHAR2(1);
2635: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2637:
2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2639: l_batch_start pon_bid_item_prices.line_number%TYPE;
2640: l_batch_end pon_bid_item_prices.line_number%TYPE;
2641: l_skip_pf_for_batch VARCHAR2(1);
2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;

Line 2639: l_batch_start pon_bid_item_prices.line_number%TYPE;

2635: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2637:
2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2639: l_batch_start pon_bid_item_prices.line_number%TYPE;
2640: l_batch_end pon_bid_item_prices.line_number%TYPE;
2641: l_skip_pf_for_batch VARCHAR2(1);
2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;

Line 2640: l_batch_end pon_bid_item_prices.line_number%TYPE;

2636: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2637:
2638: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2639: l_batch_start pon_bid_item_prices.line_number%TYPE;
2640: l_batch_end pon_bid_item_prices.line_number%TYPE;
2641: l_skip_pf_for_batch VARCHAR2(1);
2642: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2643: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2644: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;

Line 3027: FROM pon_bid_item_prices bl

3023: -- It is 'Y' if any line has the line level flag set
3024: UPDATE pon_bid_headers bh
3025: SET bh.display_price_factors_flag =
3026: nvl((SELECT 'Y'
3027: FROM pon_bid_item_prices bl
3028: WHERE bl.bid_number = bh.bid_number
3029: AND bl.display_price_factors_flag = 'Y'
3030: AND rownum = 1), 'N')
3031: WHERE bh.bid_number = x_bid_number;

Line 3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;

3063: l_rate pon_bid_headers.rate%TYPE;
3064: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3065: l_curr_prec fnd_currencies.precision%TYPE;
3066:
3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3068: l_batch_start pon_bid_item_prices.line_number%TYPE;
3069: l_batch_end pon_bid_item_prices.line_number%TYPE;
3070: l_skip_pf_for_batch VARCHAR2(1);
3071: BEGIN

Line 3068: l_batch_start pon_bid_item_prices.line_number%TYPE;

3064: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3065: l_curr_prec fnd_currencies.precision%TYPE;
3066:
3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3068: l_batch_start pon_bid_item_prices.line_number%TYPE;
3069: l_batch_end pon_bid_item_prices.line_number%TYPE;
3070: l_skip_pf_for_batch VARCHAR2(1);
3071: BEGIN
3072:

Line 3069: l_batch_end pon_bid_item_prices.line_number%TYPE;

3065: l_curr_prec fnd_currencies.precision%TYPE;
3066:
3067: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3068: l_batch_start pon_bid_item_prices.line_number%TYPE;
3069: l_batch_end pon_bid_item_prices.line_number%TYPE;
3070: l_skip_pf_for_batch VARCHAR2(1);
3071: BEGIN
3072:
3073: -- Need to get auction_header_id and supplier info

Line 3208: FROM pon_bid_item_prices bl

3204: -- It is 'Y' if any line has the line level flag set
3205: UPDATE pon_bid_headers bh
3206: SET bh.display_price_factors_flag =
3207: nvl((SELECT 'Y'
3208: FROM pon_bid_item_prices bl
3209: WHERE bl.bid_number = bh.bid_number
3210: AND bl.display_price_factors_flag = 'Y'
3211: AND rownum = 1), 'N')
3212: WHERE bh.bid_number = p_bid_number;

Line 4459: PON_BID_ITEM_PRICES pbi,

4455: INTO x_can_create_payments
4456: FROM dual
4457: WHERE EXISTS (SELECT 1
4458: FROM PON_AUCTION_ITEM_PRICES_ALL pai,
4459: PON_BID_ITEM_PRICES pbi,
4460: PON_AUCTION_HEADERS_ALL pah
4461: WHERE pai.auction_header_id = p_auction_header_id
4462: AND pai.group_type NOT IN ('GROUP','LOT_LINE')
4463: AND pbi.auction_header_id = pai.auction_header_id

Line 4519: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;

4515:
4516: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4517: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
4518:
4519: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
4520: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
4521:
4522: l_is_spo_transformed VARCHAR2(1);
4523:

Line 4520: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

4516: l_contract_type pon_auction_headers_all.contract_type%TYPE;
4517: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
4518:
4519: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
4520: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
4521:
4522: l_is_spo_transformed VARCHAR2(1);
4523:
4524: BEGIN