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 543: pon_bid_item_prices bl

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

Line 691: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

687: PROCEDURE populate_old_value_columns
688: (
689: p_bid_number IN pon_bid_headers.bid_number%TYPE,
690: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
691: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
692: p_batch_end IN pon_bid_item_prices.line_number%TYPE
693: ) IS
694: BEGIN
695:

Line 692: p_batch_end IN pon_bid_item_prices.line_number%TYPE

688: (
689: p_bid_number IN pon_bid_headers.bid_number%TYPE,
690: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
691: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
692: p_batch_end IN pon_bid_item_prices.line_number%TYPE
693: ) IS
694: BEGIN
695:
696: -- Update line level old value columns

Line 697: UPDATE pon_bid_item_prices bl

693: ) IS
694: BEGIN
695:
696: -- Update line level old value columns
697: UPDATE pon_bid_item_prices bl
698: SET (bl.old_price,
699: bl.old_bid_currency_unit_price,
700: bl.old_bid_currency_price,
701: bl.old_bid_currency_limit_price,

Line 727: FROM pon_bid_item_prices old_bl

723: old_bl.recoupment_rate_percent,
724: old_bl.progress_pymt_rate_percent,
725: old_bl.retainage_rate_percent,
726: old_bl.bid_curr_max_retainage_amt
727: FROM pon_bid_item_prices old_bl
728: WHERE old_bl.bid_number = p_source_bid_num
729: AND old_bl.line_number = bl.line_number)
730: WHERE bl.bid_number = p_bid_number
731: AND bl.line_number BETWEEN p_batch_start AND p_batch_end;

Line 831: l_max_line_number pon_bid_item_prices.line_number%TYPE;

827: ------------------------------------------------------------------
828: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
829: x_rebid_flag OUT NOCOPY VARCHAR2
830: ) IS
831: l_max_line_number pon_bid_item_prices.line_number%TYPE;
832: l_batch_start pon_bid_item_prices.line_number%TYPE;
833: l_batch_end pon_bid_item_prices.line_number%TYPE;
834: BEGIN
835:

Line 832: l_batch_start pon_bid_item_prices.line_number%TYPE;

828: x_prev_bid_number OUT NOCOPY pon_bid_headers.bid_number%TYPE,
829: x_rebid_flag OUT NOCOPY VARCHAR2
830: ) IS
831: l_max_line_number pon_bid_item_prices.line_number%TYPE;
832: l_batch_start pon_bid_item_prices.line_number%TYPE;
833: l_batch_end pon_bid_item_prices.line_number%TYPE;
834: BEGIN
835:
836: -- Determine the latest ACTIVE bid and set rebid_flag to Y

Line 833: l_batch_end pon_bid_item_prices.line_number%TYPE;

829: x_rebid_flag OUT NOCOPY VARCHAR2
830: ) IS
831: l_max_line_number pon_bid_item_prices.line_number%TYPE;
832: l_batch_start pon_bid_item_prices.line_number%TYPE;
833: l_batch_end pon_bid_item_prices.line_number%TYPE;
834: BEGIN
835:
836: -- Determine the latest ACTIVE bid and set rebid_flag to Y
837: -- Since there can only exist a single ACTIVE bid on an amendment for

Line 888: UPDATE pon_bid_item_prices bl

884: WHILE (l_batch_start <= l_max_line_number) LOOP
885:
886: -- Copy over price columns and set copy_price_for_proxy_flag
887: -- If the proxy has been exhausted, copy_price_for_proxy flag changed to N
888: UPDATE pon_bid_item_prices bl
889: SET (bl.price, bl.proxy_bid_limit_price, bl.bid_currency_price,
890: bl.bid_currency_limit_price, bl.bid_currency_trans_price,
891: bl.unit_price, bl.bid_currency_unit_price, bl.copy_price_for_proxy_flag,
892: bl.old_price, bl.old_bid_currency_unit_price, bl.old_bid_currency_price,

Line 900: FROM pon_bid_item_prices old_bl

896: old_bl.unit_price, old_bl.bid_currency_unit_price,
897: decode(sign(old_bl.proxy_bid_limit_price - old_bl.price),
898: 0, 'N', 'Y'),
899: old_bl.price, old_bl.bid_currency_unit_price, old_bl.bid_currency_price, old_bl.bid_currency_limit_price
900: FROM pon_bid_item_prices old_bl
901: WHERE old_bl.bid_number = x_prev_bid_number
902: AND old_bl.line_number = bl.line_number)
903: WHERE bl.bid_number = p_draft_bid_num
904: AND bl.copy_price_for_proxy_flag = 'Y'

Line 908: UPDATE pon_bid_item_prices bl

904: AND bl.copy_price_for_proxy_flag = 'Y'
905: AND bl.line_number BETWEEN l_batch_start AND l_batch_end;
906:
907: -- Copy over the rank for all lines
908: UPDATE pon_bid_item_prices bl
909: SET rank =
910: (SELECT old_bl.rank
911: FROM pon_bid_item_prices old_bl
912: WHERE old_bl.bid_number = x_prev_bid_number

Line 911: FROM pon_bid_item_prices old_bl

907: -- Copy over the rank for all lines
908: UPDATE pon_bid_item_prices bl
909: SET rank =
910: (SELECT old_bl.rank
911: FROM pon_bid_item_prices old_bl
912: WHERE old_bl.bid_number = x_prev_bid_number
913: AND old_bl.line_number = bl.line_number)
914: WHERE bl.bid_number = p_draft_bid_num
915: AND bl.line_number BETWEEN l_batch_start AND l_batch_end;

Line 1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1190: p_userid IN pon_bid_headers.created_by%TYPE,
1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1196: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1197: ) IS
1198: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;

Line 1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

1191: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,
1192: p_rebid_flag IN VARCHAR2,
1193: p_restricted_flag IN VARCHAR2,
1194: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1195: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
1196: p_surrog_bid_flag IN pon_bid_headers.surrog_bid_flag%TYPE
1197: ) IS
1198: l_auctpid pon_auction_headers_all.trading_partner_id%TYPE;
1199: l_blanket VARCHAR2(1);

Line 1271: INSERT INTO pon_bid_item_prices

1267: l_last_pause_date
1268: FROM pon_auction_headers_all ah
1269: WHERE ah.auction_header_id = p_auc_header_id;
1270:
1271: INSERT INTO pon_bid_item_prices
1272: (
1273: AUCTION_HEADER_ID,
1274: AUCTION_LINE_NUMBER,
1275: BID_NUMBER,

Line 1570: pon_bid_item_prices bl

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
1574: AND old_al.auction_header_id (+) = bl.auction_header_id

Line 1597: UPDATE pon_bid_item_prices bl

1593: IF l_prev_rnd_active_bid_number IS NOT NULL THEN
1594: -- if active bid exists then
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

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 1618: DELETE FROM pon_bid_item_prices bl

1614:
1615: -- Delete excluded lines
1616: IF (p_restricted_flag = 'Y') THEN
1617:
1618: DELETE FROM pon_bid_item_prices bl
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

Line 1638: DELETE FROM pon_bid_item_prices bl_outer

1634: * Delete elins associated to option lines of a restricted line.
1635: */
1636: IF PON_EXHIBITS_PKG.IS_EXHIBITS_ENABLED(l_org_id, l_doctype_id) = 'Y' THEN
1637:
1638: DELETE FROM pon_bid_item_prices bl_outer
1639: WHERE bl_outer.bid_number = p_bid_number
1640: AND bl_outer.line_number BETWEEN p_batch_start AND p_batch_end
1641: AND bl_outer.line_number IN
1642: (SELECT al_outer.line_number

Line 1649: FROM pon_bid_item_prices bl

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
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

Line 1683: DELETE FROM pon_bid_item_prices bl

1679: ELSE
1680: l_closed_compare_date := sysdate;
1681: END IF;
1682:
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

Line 1845: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1841: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1842: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1843: p_userid IN pon_bid_headers.created_by%TYPE,
1844: p_rebid_flag IN VARCHAR2,
1845: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1846: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1847: ) IS
1848: BEGIN
1849:

Line 1846: p_batch_end IN pon_bid_item_prices.line_number%TYPE

1842: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1843: p_userid IN pon_bid_headers.created_by%TYPE,
1844: p_rebid_flag IN VARCHAR2,
1845: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1846: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1847: ) IS
1848: BEGIN
1849:
1850: -- Insert line attributes

Line 1895: pon_bid_item_prices bl

1891: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1892: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1893: FROM pon_auction_attributes aa,
1894: pon_bid_attribute_values ba,
1895: pon_bid_item_prices bl
1896: WHERE aa.auction_header_id = p_auc_header_id
1897: AND aa.line_number > 0
1898: AND bl.bid_number = p_bid_number
1899: AND bl.line_number = aa.line_number

Line 1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

1923: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1926: p_rebid_flag IN VARCHAR2,
1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1929: ) IS
1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;

Line 1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE

1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1926: p_rebid_flag IN VARCHAR2,
1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1929: ) IS
1930: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
1931: l_curr_prec fnd_currencies.precision%TYPE;
1932: l_rate pon_bid_headers.rate%TYPE;

Line 1997: pon_bid_item_prices bl

1993: apf.pf_type, -- PF_TYPE
1994: decode(p_rebid_flag, 'Y', bpf.bid_currency_value, null) -- OLD_BID_CURRENCY_VALUE
1995: FROM pon_price_elements apf,
1996: pon_bid_price_elements bpf,
1997: pon_bid_item_prices bl
1998: WHERE apf.auction_header_id = p_auc_header_id
1999: AND apf.pf_type = 'SUPPLIER' -- only for supplier price factors
2000: AND bl.bid_number = p_bid_number
2001: AND bl.line_number = apf.line_number

Line 2053: pon_bid_item_prices bl

2049: apf.pf_type, -- PF_TYPE
2050: null -- OLD_BID_CURRENCY_VALUE
2051: FROM pon_price_elements apf,
2052: pon_pf_supplier_values pf,
2053: pon_bid_item_prices bl
2054: WHERE apf.auction_header_id = p_auc_header_id
2055: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
2056: AND apf.display_to_suppliers_flag = 'Y'
2057: AND bl.bid_number = p_bid_number

Line 2088: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2084: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2085: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2086: p_userid IN pon_bid_headers.created_by%TYPE,
2087: p_rebid_flag IN VARCHAR2,
2088: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2089: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2090: ) IS
2091: BEGIN
2092:

Line 2089: p_batch_end IN pon_bid_item_prices.line_number%TYPE

2085: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2086: p_userid IN pon_bid_headers.created_by%TYPE,
2087: p_rebid_flag IN VARCHAR2,
2088: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2089: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2090: ) IS
2091: BEGIN
2092:
2093: -- Get all auction side price breaks for modified lines that had a bid

Line 2150: pon_bid_item_prices bl

2146: apb.has_price_differentials_flag, -- HAS_PRICE_DIFFERENTIALS_FLAG
2147: null, -- UNIT_PRICE
2148: null -- BID_CURRENCY_UNIT_PRICE
2149: FROM pon_auction_shipments_all apb,
2150: pon_bid_item_prices bl
2151: WHERE apb.auction_header_id = p_auc_header_id
2152: AND bl.bid_number = p_bid_number
2153: AND bl.line_number = apb.line_number
2154: -- we only insert those price breaks for which the line was modified

Line 2235: pon_bid_item_prices bl

2231: decode(p_rebid_flag, 'Y', bpb.quantity, null), -- OLD_QUANTITY
2232: decode(p_rebid_flag, 'Y', bpb.max_quantity, null), -- OLD_MAX_QUANTITY
2233: decode(p_rebid_flag, 'Y', bpb.price_type, null) -- OLD_PRICE_TYPE
2234: FROM pon_bid_shipments bpb,
2235: pon_bid_item_prices bl
2236: WHERE bpb.bid_number = p_source_bid_num
2237: AND bl.bid_number = p_bid_number
2238: AND bl.line_number = bpb.line_number
2239: -- only unmodified lines with bids

Line 2263: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2259: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2260: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2261: p_userid IN pon_bid_headers.created_by%TYPE,
2262: p_rebid_flag IN VARCHAR2,
2263: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2264: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2265: ) IS
2266: BEGIN
2267:

Line 2264: p_batch_end IN pon_bid_item_prices.line_number%TYPE

2260: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2261: p_userid IN pon_bid_headers.created_by%TYPE,
2262: p_rebid_flag IN VARCHAR2,
2263: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2264: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2265: ) IS
2266: BEGIN
2267:
2268: INSERT INTO pon_bid_price_differentials

Line 2302: pon_bid_item_prices bl

2298: null, -- LAST_UPDATE_LOGIN
2299: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2300: FROM pon_price_differentials apd,
2301: pon_bid_price_differentials bpd,
2302: pon_bid_item_prices bl
2303: WHERE apd.auction_header_id = p_auc_header_id
2304: AND apd.shipment_number = -1 -- only line level differentials
2305: AND bl.auction_header_id = apd.auction_header_id
2306: AND bl.bid_number = p_bid_number

Line 2335: pon_bid_item_prices bl

2331: decode(p_rebid_flag, 'Y', bpd.multiplier, null) -- OLD_MULTIPLIER
2332: FROM pon_price_differentials apd,
2333: pon_bid_price_differentials bpd,
2334: pon_bid_shipments bpb,
2335: pon_bid_item_prices bl
2336: WHERE apd.auction_header_id = p_auc_header_id
2337: AND apd.shipment_number <> -1 -- only shipment differentials
2338: AND bl.bid_number = p_bid_number
2339: AND bl.line_number = apd.line_number

Line 2377: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2373: p_supplier_flag IN pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE,
2374: p_userid IN pon_bid_headers.created_by%TYPE,
2375: p_rebid_flag IN VARCHAR2,
2376: p_new_round_or_amended IN VARCHAR2,
2377: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2378: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2379: ) IS
2380:
2381:

Line 2378: p_batch_end IN pon_bid_item_prices.line_number%TYPE

2374: p_userid IN pon_bid_headers.created_by%TYPE,
2375: p_rebid_flag IN VARCHAR2,
2376: p_new_round_or_amended IN VARCHAR2,
2377: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2378: p_batch_end IN pon_bid_item_prices.line_number%TYPE
2379: ) IS
2380:
2381:
2382:

Line 2396: PON_BID_ITEM_PRICES bl

2392: FROM
2393: PON_BID_PAYMENTS_SHIPMENTS source_pay,
2394: FND_ATTACHED_DOCUMENTS fnd,
2395: PON_BID_PAYMENTS_SHIPMENTS dest_pay,
2396: PON_BID_ITEM_PRICES bl
2397: WHERE bl.auction_header_id = p_auc_header_id
2398: AND bl.bid_number = p_bid_number
2399: AND bl.has_bid_flag = 'Y'
2400: AND dest_pay.bid_number = bl.bid_number

Line 2467: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt

2463: apmt.PAYMENT_TYPE_CODE, --PAYMENT_TYPE_CODE,
2464: apmt.QUANTITY, --QUANTITY,
2465: apmt.UOM_CODE, --UOM_CODE,
2466: bl.promised_date --PROMISED_DATE,
2467: FROM pon_bid_item_prices bl,pon_auc_payments_shipments apmt
2468: WHERE bl.auction_header_id = p_auc_header_id
2469: AND bl.bid_number = p_bid_number
2470: AND bl.auction_header_id = apmt.auction_header_id
2471: AND bl.line_number = apmt.line_number

Line 2533: FROM pon_bid_item_prices bl,

2529: apmt.PAYMENT_TYPE_CODE, --PAYMENT_TYPE_CODE,
2530: apmt.QUANTITY, --QUANTITY,
2531: apmt.UOM_CODE, --UOM_CODE,
2532: bl.promised_date --PROMISED_DATE,
2533: FROM pon_bid_item_prices bl,
2534: pon_auc_payments_shipments apmt
2535: WHERE bl.auction_header_id = p_auc_header_id
2536: AND bl.bid_number = p_bid_number
2537: AND bl.auction_header_id = apmt.auction_header_id

Line 2614: FROM pon_bid_item_prices bl,

2610: decode(p_rebid_flag, 'Y',bpmt.QUANTITY,null), --OLD_QUANTITY,
2611: decode(p_rebid_flag, 'Y',bpmt.UOM_CODE, null), --OLD_UOM_CODE,
2612: decode(p_rebid_flag, 'Y',bpmt.BID_CURRENCY_PRICE, null), --OLD_BID_CURRENCY_PRICE,
2613: decode(p_rebid_flag, 'Y',bpmt.PROMISED_DATE, null) --OLD_PROMISED_DATE
2614: FROM pon_bid_item_prices bl,
2615: pon_bid_payments_shipments bpmt
2616: WHERE bl.auction_header_id = p_auc_header_id
2617: AND bl.bid_number = p_bid_number
2618: AND bpmt.bid_number = p_source_bid_num

Line 2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,

2668: p_bid_number IN pon_bid_headers.bid_number%TYPE,
2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2673: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2674: p_to_category_id IN NUMBER,
2675: p_change_categ_id IN VARCHAR2
2676: ) IS

Line 2673: p_batch_end IN pon_bid_item_prices.line_number%TYPE,

2669: p_source_header_id IN pon_bid_headers.auction_header_id%TYPE,
2670: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
2671: p_userid IN pon_bid_headers.created_by%TYPE,
2672: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
2673: p_batch_end IN pon_bid_item_prices.line_number%TYPE,
2674: p_to_category_id IN NUMBER,
2675: p_change_categ_id IN VARCHAR2
2676: ) IS
2677:

Line 2680: FROM fnd_attached_documents ad, pon_bid_item_prices bl

2676: ) IS
2677:
2678: CURSOR bid_lines_with_attachments IS
2679: SELECT DISTINCT ad.pk3_value
2680: FROM fnd_attached_documents ad, pon_bid_item_prices bl
2681: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
2682: AND ad.pk1_value = p_source_header_id
2683: AND ad.pk2_value = p_source_bid_num
2684: AND ad.pk3_value IS NOT null

Line 2681: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'

2677:
2678: CURSOR bid_lines_with_attachments IS
2679: SELECT DISTINCT ad.pk3_value
2680: FROM fnd_attached_documents ad, pon_bid_item_prices bl
2681: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
2682: AND ad.pk1_value = p_source_header_id
2683: AND ad.pk2_value = p_source_bid_num
2684: AND ad.pk3_value IS NOT null
2685: AND bl.bid_number = p_bid_number

Line 2695: (x_from_entity_name => 'PON_BID_ITEM_PRICES',

2691: IF p_change_categ_id = 'Y' then
2692: -- Copy the line's attachments only for unmodified lines, with new target category.
2693: FOR line IN bid_lines_with_attachments LOOP
2694: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2695: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2696: x_from_pk1_value => p_source_header_id,
2697: x_from_pk2_value => p_source_bid_num,
2698: x_from_pk3_value => line.pk3_value,
2699: x_to_entity_name => 'PON_BID_ITEM_PRICES',

Line 2699: x_to_entity_name => 'PON_BID_ITEM_PRICES',

2695: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2696: x_from_pk1_value => p_source_header_id,
2697: x_from_pk2_value => p_source_bid_num,
2698: x_from_pk3_value => line.pk3_value,
2699: x_to_entity_name => 'PON_BID_ITEM_PRICES',
2700: x_to_pk1_value => p_auc_header_id,
2701: x_to_pk2_value => p_bid_number,
2702: x_to_pk3_value => line.pk3_value,
2703: x_created_by => p_userid,

Line 2711: (x_from_entity_name => 'PON_BID_ITEM_PRICES',

2707: ELSE
2708: -- Copy the line's attachments only for unmodified lines
2709: FOR line IN bid_lines_with_attachments LOOP
2710: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments
2711: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2712: x_from_pk1_value => p_source_header_id,
2713: x_from_pk2_value => p_source_bid_num,
2714: x_from_pk3_value => line.pk3_value,
2715: x_to_entity_name => 'PON_BID_ITEM_PRICES',

Line 2715: x_to_entity_name => 'PON_BID_ITEM_PRICES',

2711: (x_from_entity_name => 'PON_BID_ITEM_PRICES',
2712: x_from_pk1_value => p_source_header_id,
2713: x_from_pk2_value => p_source_bid_num,
2714: x_from_pk3_value => line.pk3_value,
2715: x_to_entity_name => 'PON_BID_ITEM_PRICES',
2716: x_to_pk1_value => p_auc_header_id,
2717: x_to_pk2_value => p_bid_number,
2718: x_to_pk3_value => line.pk3_value,
2719: x_created_by => p_userid,

Line 2749: UPDATE pon_bid_item_prices bl

2745: FROM pon_auction_headers_all ah
2746: WHERE ah.auction_header_id = p_auc_header_id;
2747:
2748: -- First set has_bid_flag to N
2749: UPDATE pon_bid_item_prices bl
2750: SET bl.has_bid_flag = 'N'
2751: WHERE bl.bid_number = p_bid_number;
2752:
2753: -- Then, determine which lines have a bid

Line 2754: UPDATE pon_bid_item_prices bl

2750: SET bl.has_bid_flag = 'N'
2751: WHERE bl.bid_number = p_bid_number;
2752:
2753: -- Then, determine which lines have a bid
2754: UPDATE pon_bid_item_prices bl
2755: SET bl.has_bid_flag = 'Y'
2756: WHERE bl.bid_number = p_bid_number
2757: AND ((bl.promised_date IS NOT null
2758: OR bl.price IS NOT null

Line 2881: l_max_line_number pon_bid_item_prices.line_number%TYPE;

2877: l_rel12_draft VARCHAR2(1);
2878: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2879: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2880:
2881: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2882: l_batch_start pon_bid_item_prices.line_number%TYPE;
2883: l_batch_end pon_bid_item_prices.line_number%TYPE;
2884: l_skip_pf_for_batch VARCHAR2(1);
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;

Line 2882: l_batch_start pon_bid_item_prices.line_number%TYPE;

2878: l_source_bid_status pon_bid_headers.bid_status%TYPE;
2879: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2880:
2881: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2882: l_batch_start pon_bid_item_prices.line_number%TYPE;
2883: l_batch_end pon_bid_item_prices.line_number%TYPE;
2884: l_skip_pf_for_batch VARCHAR2(1);
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;

Line 2883: l_batch_end pon_bid_item_prices.line_number%TYPE;

2879: l_supp_seq_number pon_bidding_parties.sequence%TYPE;
2880:
2881: l_max_line_number pon_bid_item_prices.line_number%TYPE;
2882: l_batch_start pon_bid_item_prices.line_number%TYPE;
2883: l_batch_end pon_bid_item_prices.line_number%TYPE;
2884: l_skip_pf_for_batch VARCHAR2(1);
2885: l_supplier_flag pon_auction_headers_all.SUPPLIER_ENTERABLE_PYMT_FLAG%TYPE;
2886: l_payment_type pon_auction_headers_all.PROGRESS_PAYMENT_TYPE%TYPE;
2887: l_contract_type pon_auction_headers_all.CONTRACT_TYPE%TYPE;

Line 2904: l_display_pf_flag pon_bid_item_prices.DISPLAY_PRICE_FACTORS_FLAG%TYPE;

2900: l_categ_id_supp_tech NUMBER; -- to store category id of "FromSupplierTechnical"
2901: l_change_categ_id VARCHAR2(1) := 'N'; -- change category id ?
2902:
2903: -- Variables for bug 12607365 (FP of 11665610)
2904: l_display_pf_flag pon_bid_item_prices.DISPLAY_PRICE_FACTORS_FLAG%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:

Line 2905: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

2901: l_change_categ_id VARCHAR2(1) := 'N'; -- change category id ?
2902:
2903: -- Variables for bug 12607365 (FP of 11665610)
2904: l_display_pf_flag pon_bid_item_prices.DISPLAY_PRICE_FACTORS_FLAG%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;

Line 2906: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;

2902:
2903: -- Variables for bug 12607365 (FP of 11665610)
2904: l_display_pf_flag pon_bid_item_prices.DISPLAY_PRICE_FACTORS_FLAG%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;

Line 2907: l_line_number pon_bid_item_prices.line_number%TYPE;

2903: -- Variables for bug 12607365 (FP of 11665610)
2904: l_display_pf_flag pon_bid_item_prices.DISPLAY_PRICE_FACTORS_FLAG%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:

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 2941: CURSOR supplier_pf_curr(v_line_number pon_bid_item_prices.line_number%TYPE) IS

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:
2941: CURSOR supplier_pf_curr(v_line_number pon_bid_item_prices.line_number%TYPE) IS
2942: SELECT PRICING_BASIS, BID_CURRENCY_VALUE, PRICE_ELEMENT_TYPE_ID
2943: FROM PON_BID_PRICE_ELEMENTS
2944: WHERE AUCTION_HEADER_ID = p_auc_header_id
2945: AND BID_NUMBER = x_bid_number

Line 2953: l_uda_template_id pon_bid_item_prices.UDA_TEMPLATE_ID%TYPE;

2949: /* */
2950: l_doctype_id pon_auction_headers_all.DOCTYPE_ID%TYPE;
2951: l_msg_count NUMBER;
2952: l_msg_data VARCHAR2(32767);
2953: l_uda_template_id pon_bid_item_prices.UDA_TEMPLATE_ID%TYPE;
2954: l_is_uda_enabled NUMBER;
2955: l_err_msg VARCHAR2(100);
2956: l_return_status VARCHAR2(1);
2957: /* */

Line 3457: UPDATE PON_BID_ITEM_PRICES

3453: SELECT ROUND(l_trans_price, decode(l_precision, 10000, 10, l_precision)) INTO l_bid_curr_trans_price FROM dual;
3454:
3455: l_price := l_trans_price/l_rate;
3456:
3457: UPDATE PON_BID_ITEM_PRICES
3458: SET BID_CURRENCY_PRICE = l_truncated_value,
3459: BID_CURRENCY_TRANS_PRICE = l_bid_curr_trans_price,
3460: PRICE = l_price
3461: WHERE AUCTION_HEADER_ID = p_auc_header_id

Line 3493: UPDATE PON_BID_ITEM_PRICES

3489: SELECT ROUND(l_trans_price, decode(l_precision, 10000, 10, l_precision)) INTO l_bid_curr_trans_price FROM dual;
3490:
3491: l_price := l_trans_price/l_rate;
3492:
3493: UPDATE PON_BID_ITEM_PRICES
3494: SET BID_CURRENCY_PRICE = l_bid_curr_unit_price,
3495: BID_CURRENCY_TRANS_PRICE = l_bid_curr_trans_price,
3496: PRICE = l_price
3497: WHERE AUCTION_HEADER_ID = p_auc_header_id

Line 3597: FROM pon_bid_item_prices bl

3593: -- It is 'Y' if any line has the line level flag set
3594: UPDATE pon_bid_headers bh
3595: SET bh.display_price_factors_flag =
3596: nvl((SELECT 'Y'
3597: FROM pon_bid_item_prices bl
3598: WHERE bl.bid_number = bh.bid_number
3599: AND bl.display_price_factors_flag = 'Y'
3600: AND rownum = 1), 'N')
3601: WHERE bh.bid_number = x_bid_number;

Line 3637: l_max_line_number pon_bid_item_prices.line_number%TYPE;

3633: l_rate pon_bid_headers.rate%TYPE;
3634: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3635: l_curr_prec fnd_currencies.precision%TYPE;
3636:
3637: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3638: l_batch_start pon_bid_item_prices.line_number%TYPE;
3639: l_batch_end pon_bid_item_prices.line_number%TYPE;
3640: l_skip_pf_for_batch VARCHAR2(1);
3641: BEGIN

Line 3638: l_batch_start pon_bid_item_prices.line_number%TYPE;

3634: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
3635: l_curr_prec fnd_currencies.precision%TYPE;
3636:
3637: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3638: l_batch_start pon_bid_item_prices.line_number%TYPE;
3639: l_batch_end pon_bid_item_prices.line_number%TYPE;
3640: l_skip_pf_for_batch VARCHAR2(1);
3641: BEGIN
3642:

Line 3639: l_batch_end pon_bid_item_prices.line_number%TYPE;

3635: l_curr_prec fnd_currencies.precision%TYPE;
3636:
3637: l_max_line_number pon_bid_item_prices.line_number%TYPE;
3638: l_batch_start pon_bid_item_prices.line_number%TYPE;
3639: l_batch_end pon_bid_item_prices.line_number%TYPE;
3640: l_skip_pf_for_batch VARCHAR2(1);
3641: BEGIN
3642:
3643: -- Need to get auction_header_id and supplier info

Line 3778: FROM pon_bid_item_prices bl

3774: -- It is 'Y' if any line has the line level flag set
3775: UPDATE pon_bid_headers bh
3776: SET bh.display_price_factors_flag =
3777: nvl((SELECT 'Y'
3778: FROM pon_bid_item_prices bl
3779: WHERE bl.bid_number = bh.bid_number
3780: AND bl.display_price_factors_flag = 'Y'
3781: AND rownum = 1), 'N')
3782: WHERE bh.bid_number = p_bid_number;

Line 5430: PON_BID_ITEM_PRICES pbi,

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')
5434: AND pbi.auction_header_id = pai.auction_header_id

Line 5490: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;

5486:
5487: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5488: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5489:
5490: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5491: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
5492:
5493: l_is_spo_transformed VARCHAR2(1);
5494:

Line 5491: l_bid_quantity pon_bid_item_prices.quantity%TYPE;

5487: l_contract_type pon_auction_headers_all.contract_type%TYPE;
5488: l_supplier_view_type pon_auction_headers_all.supplier_view_type%TYPE;
5489:
5490: l_bid_auction_curr_unit_price pon_bid_item_prices.unit_price%TYPE;
5491: l_bid_quantity pon_bid_item_prices.quantity%TYPE;
5492:
5493: l_is_spo_transformed VARCHAR2(1);
5494:
5495: BEGIN

Line 5610: is used to update pon_bid_item_prices table's data. */

5606: END apply_price_factors;
5607:
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,

Line 5623: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;

5619: p_bid_number IN NUMBER,
5620: p_auction_header_id IN NUMBER,
5621: p_bid_line_number IN NUMBER) IS
5622:
5623: l_bid_curr_unit_price pon_bid_item_prices.bid_currency_unit_price%TYPE;
5624: l_price_prec pon_bid_headers.number_price_decimals%TYPE;
5625: l_curr_prec fnd_currencies.precision%TYPE;
5626: l_rate pon_bid_headers.rate%TYPE;
5627: BEGIN

Line 5645: UPDATE pon_bid_item_prices

5641: ELSE
5642: l_bid_curr_unit_price := round(p_po_quantity * l_rate, l_price_prec);
5643: END IF;
5644:
5645: UPDATE pon_bid_item_prices
5646: SET
5647: idv_line_id = p_po_line_id,
5648: clm_contract_type = p_po_contract_type,
5649: price = Decode(p_po_type,'QUANTITY',p_po_unit_price,p_po_quantity),

Line 5671: This variable value is used to update pon_bid_item_prices table's data.

5667:
5668:
5669: /* Bug 10052785 - Start */
5670: /* Fetch cost constraint and pass it to update_bid_line_to_po_line procedure.
5671: This variable value is used to update pon_bid_item_prices table's data.
5672: Update IS_CHANGED_LINE_FLAG to 'Y' whenever IDV reference lines matches with
5673: Offer lines. */
5674:
5675: PROCEDURE default_idv_line_id (p_po_header_id IN NUMBER,

Line 5681: (line_number pon_bid_item_prices.line_number%TYPE,

5677: p_bid_number IN NUMBER)
5678: IS
5679:
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:

Line 5682: description pon_bid_item_prices.item_description%TYPE,

5678: IS
5679:
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

Line 5683: category_id pon_bid_item_prices.category_id%TYPE,

5679:
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,

Line 5722: pon_bid_item_prices bid,

5718: select bid.line_number,bid.item_description,
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:

Line 5749: UPDATE pon_bid_item_prices

5745: p_bid_number,
5746: p_auction_header_id,
5747: bid_info_table(i).line_number);
5748:
5749: UPDATE pon_bid_item_prices
5750: SET IS_CHANGED_LINE_FLAG = 'Y',
5751: HAS_USER_BID_FLAG = 'Y'
5752: WHERE auction_header_id = p_auction_header_id
5753: AND bid_number = p_bid_number

Line 5782: This variable value is used to update pon_bid_item_prices table's data. */

5778: END default_idv_pricing_details;
5779:
5780: /* Bug 10052785 - Start */
5781: /* Added cost constraint to update_bid_line_to_po_line procedure variables.
5782: This variable value is used to update pon_bid_item_prices table's data. */
5783:
5784: /* CLM : This is a wrapper procedure that calls uda copy procedure and
5785: * updates some bid columns for po line.
5786: */

Line 5841: clm_idc_type, clm_cost_constraint values of pon_bid_item_prices.

5837: Else condition - This defaults data for specific offer line. */
5838:
5839: /* 1) Update IS_CHANGED_LINE_FLAG, idv_line_id, unit_price, price,
5840: Bid_currency_unit_price,bid_currency_price, clm_contract_type,
5841: clm_idc_type, clm_cost_constraint values of pon_bid_item_prices.
5842: 2) Copy UDA data for each line or specific line by calling
5843: PON_COPY_UDAS_GRP.COPY_BID_LINE_UDA procedure.
5844: */
5845:

Line 5875: UPDATE pon_bid_item_prices

5871: pon_line_info_table pon_line_info_table_type;
5872:
5873: BEGIN
5874: IF p_auction_line_number IS NULL THEN
5875: UPDATE pon_bid_item_prices
5876: SET IS_CHANGED_LINE_FLAG = 'N',
5877: HAS_USER_BID_FLAG = 'N'
5878: WHERE auction_header_id = p_auction_header_id AND
5879: bid_number = p_bid_number AND

Line 5884: UPDATE pon_bid_item_prices

5880: idv_line_id IS NOT NULL AND
5881: --ELINs project
5882: NOT (Nvl(user_marked_flag,'N') = 'Y' AND Nvl(has_user_bid_flag,'N') = 'Y');
5883:
5884: UPDATE pon_bid_item_prices
5885: SET idv_line_id = null,
5886: unit_price = null,
5887: price = null,
5888: quantity=null,

Line 5902: UPDATE pon_bid_item_prices

5898:
5899:
5900: FOR i IN pon_line_info_table.first..pon_line_info_table.last
5901: LOOP
5902: UPDATE pon_bid_item_prices
5903: SET clm_contract_type = pon_line_info_table(i).contract_type,
5904: clm_idc_type = pon_line_info_table(i).clm_idc_type,
5905: clm_cost_constraint = pon_line_info_table(i).cost_constraint
5906: WHERE auction_header_id = p_auction_header_id AND

Line 5951: UPDATE pon_bid_item_prices

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
5952: SET idv_line_id = null,
5953: unit_price = null,
5954: price = null,
5955: Bid_currency_unit_price = null,

Line 6061: pon_bid_item_prices bid_items

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
6065: and items.auction_header_id = bid_items.auction_header_id;

Line 6109: UPDATE pon_bid_item_prices

6105: p_bid_number IN NUMBER) IS
6106:
6107: BEGIN
6108:
6109: UPDATE pon_bid_item_prices
6110: SET idv_line_id = NULL
6111: WHERE auction_header_id = p_auction_header_id
6112: AND bid_number = p_bid_number
6113: AND auction_line_number = -1;