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_VALIDATIONS_PKG dependencies on PON_BID_ITEM_PRICES

Line 130: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

126:
127:
128: PROCEDURE populate_has_bid_changed_line
129: (
130: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
131: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
132: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
133: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
134: p_batch_start IN NUMBER,

Line 131: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

127:
128: PROCEDURE populate_has_bid_changed_line
129: (
130: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
131: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
132: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
133: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
134: p_batch_start IN NUMBER,
135: p_batch_end IN NUMBER,

Line 132: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,

128: PROCEDURE populate_has_bid_changed_line
129: (
130: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
131: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
132: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
133: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
134: p_batch_start IN NUMBER,
135: p_batch_end IN NUMBER,
136: p_rebid_flag IN VARCHAR2,

Line 133: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,

129: (
130: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
131: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
132: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
133: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
134: p_batch_start IN NUMBER,
135: p_batch_end IN NUMBER,
136: p_rebid_flag IN VARCHAR2,
137: p_blanket IN VARCHAR2,

Line 157: UPDATE pon_bid_item_prices bl

153: -- since power bidding is always a rebid, we will always be
154: -- initializing all is_changed_line_flag to 'N' and then selectively
155: -- setting them to 'Y' with the is_changed_line logic below
156:
157: UPDATE pon_bid_item_prices bl
158: SET bl.has_bid_flag = decode(p_use_batch_id, 'Y', 'Y', bl.has_bid_flag),
159: bl.is_changed_line_flag = decode(p_rebid_flag, 'N', 'Y', 'N')
160: WHERE bl.bid_number = p_bid_number
161: AND ((p_use_batch_id = 'Y' AND bl.batch_id = p_batch_id)

Line 172: UPDATE pon_bid_item_prices bl

168: IF (p_use_batch_id = 'Y' AND p_rebid_flag = 'N') THEN
169: RETURN;
170: END IF;
171:
172: UPDATE pon_bid_item_prices bl
173: SET bl.is_changed_line_flag = 'Y'
174: WHERE bl.bid_number = p_bid_number
175: AND ((p_use_batch_id = 'Y' AND bl.batch_id = p_batch_id)
176: OR (p_use_batch_id = 'N'

Line 294: UPDATE pon_bid_item_prices pbip

290:
291:
292: -- process groups
293: -- when a group line has been changed, change the group too.
294: UPDATE pon_bid_item_prices pbip
295: SET pbip.is_changed_line_flag = 'Y'
296: WHERE pbip.bid_number = p_bid_number
297: AND pbip.line_number IN
298: (SELECT al.parent_line_number

Line 299: FROM pon_bid_item_prices bl,

295: SET pbip.is_changed_line_flag = 'Y'
296: WHERE pbip.bid_number = p_bid_number
297: AND pbip.line_number IN
298: (SELECT al.parent_line_number
299: FROM pon_bid_item_prices bl,
300: pon_auction_item_prices_all al
301: WHERE bl.bid_number = p_bid_number
302: AND bl.auction_header_id = al.auction_header_id
303: AND bl.line_number = al.line_number

Line 323: UPDATE pon_bid_item_prices bl

319:
320: -- Check all unmodified lines against source_bid if the source_bid is valid
321: IF (p_spreadsheet = g_xml_upload_mode and p_blanket = 'Y' AND p_rebid_flag = 'Y' AND p_source_bid > 0) THEN
322:
323: UPDATE pon_bid_item_prices bl
324: SET bl.is_changed_line_flag = 'Y'
325: WHERE bl.bid_number = p_bid_number
326: AND bl.batch_id = p_batch_id
327: AND (EXISTS

Line 361: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

357:
358: -- wrapper for spreadsheet case
359: PROCEDURE populate_has_bid_changed_line
360: (
361: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
362: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
363: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
364: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
365: p_rebid_flag VARCHAR2,

Line 362: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

358: -- wrapper for spreadsheet case
359: PROCEDURE populate_has_bid_changed_line
360: (
361: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
362: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
363: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
364: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
365: p_rebid_flag VARCHAR2,
366: p_blanket VARCHAR2,

Line 363: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,

359: PROCEDURE populate_has_bid_changed_line
360: (
361: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
362: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
363: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
364: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
365: p_rebid_flag VARCHAR2,
366: p_blanket VARCHAR2,
367: p_spreadsheet IN VARCHAR2

Line 364: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,

360: (
361: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
362: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
363: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
364: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
365: p_rebid_flag VARCHAR2,
366: p_blanket VARCHAR2,
367: p_spreadsheet IN VARCHAR2
368: )

Line 381: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

377:
378: -- wrapper for online case
379: PROCEDURE populate_has_bid_changed_line
380: (
381: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
382: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
383: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
384: p_batch_start IN NUMBER,
385: p_batch_end IN NUMBER,

Line 382: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

378: -- wrapper for online case
379: PROCEDURE populate_has_bid_changed_line
380: (
381: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
382: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
383: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
384: p_batch_start IN NUMBER,
385: p_batch_end IN NUMBER,
386: p_rebid_flag IN VARCHAR2,

Line 383: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,

379: PROCEDURE populate_has_bid_changed_line
380: (
381: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
382: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
383: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
384: p_batch_start IN NUMBER,
385: p_batch_end IN NUMBER,
386: p_rebid_flag IN VARCHAR2,
387: p_blanket IN VARCHAR2,

Line 400: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

396:
397:
398: PROCEDURE calc_total_weighted_score
399: (
400: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
401: p_batch_id IN pon_bid_item_prices.batch_id%TYPE
402: ) IS
403: BEGIN
404:

Line 401: p_batch_id IN pon_bid_item_prices.batch_id%TYPE

397:
398: PROCEDURE calc_total_weighted_score
399: (
400: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
401: p_batch_id IN pon_bid_item_prices.batch_id%TYPE
402: ) IS
403: BEGIN
404:
405: -- First populate the score for each attribute

Line 435: FROM pon_bid_item_prices bl

431: AND to_date(nvl(s.to_range, ba.value), 'dd-mm-yyyy')))),
432: nvl2(ba.value, 0, null))
433: WHERE ba.bid_number = p_bid_number
434: AND EXISTS (SELECT bl.line_number
435: FROM pon_bid_item_prices bl
436: WHERE bl.bid_number = p_bid_number
437: AND bl.line_number = ba.line_number
438: AND bl.batch_id = p_batch_id);
439:

Line 452: FROM pon_bid_item_prices bl

448: AND aa.line_number = ba.line_number
449: AND aa.sequence_number = ba.sequence_number)
450: WHERE ba.bid_number = p_bid_number
451: AND EXISTS (SELECT bl.line_number
452: FROM pon_bid_item_prices bl
453: WHERE bl.bid_number = p_bid_number
454: AND bl.line_number = ba.line_number
455: AND bl.batch_id = p_batch_id);
456:

Line 468: UPDATE pon_bid_item_prices bl

464: -- 0, if line has bid then 100 else null,
465: -- # scored attr with bids,
466: -- score, null)
467:
468: UPDATE pon_bid_item_prices bl
469: SET bl.total_weighted_score =
470: (SELECT decode(sum(sign(aa.weight)),
471: null, decode(bl.has_bid_flag, 'Y', 100, null),
472: 0, decode(bl.has_bid_flag, 'Y', 100, null),

Line 488: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

484: END calc_total_weighted_score;
485:
486: PROCEDURE validate_bids_placed
487: (
488: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
489: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
490: p_interface_type IN pon_interface_errors.interface_type%TYPE,
491: p_userid IN pon_interface_errors.created_by%TYPE,
492: p_rebid IN VARCHAR2,

Line 489: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

485:
486: PROCEDURE validate_bids_placed
487: (
488: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
489: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
490: p_interface_type IN pon_interface_errors.interface_type%TYPE,
491: p_userid IN pon_interface_errors.created_by%TYPE,
492: p_rebid IN VARCHAR2,
493: p_bid_all_lines IN VARCHAR2,

Line 641: FROM pon_bid_item_prices bl,

637: decode(NVL(paha.Two_Part_Flag, 'N'), 'Y',
638: decode(NVL(paha.TECHNICAL_EVALUATION_STATUS, 'NOT_COMPLETED'), 'NOT_COMPLETED',
639: decode(NVL(pbh.surrog_bid_flag, 'N'), 'Y', 1, 0), 0), 0), 0))) s_bidded_lines
640: ----------------------------------------------------------------------------
641: FROM pon_bid_item_prices bl,
642: pon_auction_item_prices_all paip
643: -- added by Allen Yang for surrogate bid bug 7703665, #8220778 2009/02/03
644: ---------------------------------------------------------------
645: , pon_auction_headers_all paha,

Line 662: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

658: END validate_bids_placed;
659:
660: PROCEDURE validate_lots_and_groups
661: (
662: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
663: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
664: p_interface_type IN pon_interface_errors.interface_type%TYPE,
665: p_userid IN pon_interface_errors.created_by%TYPE,
666: p_spreadsheet IN VARCHAR2,

Line 663: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

659:
660: PROCEDURE validate_lots_and_groups
661: (
662: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
663: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
664: p_interface_type IN pon_interface_errors.interface_type%TYPE,
665: p_userid IN pon_interface_errors.created_by%TYPE,
666: p_spreadsheet IN VARCHAR2,
667: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 678: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

674: -- All lines in a GROUP must be bid on simultaneously
675: WHEN s_group_type = 'GROUP' AND
676: (SELECT decode(sum(decode(bl.has_bid_flag, 'Y', 1, 0)), 0, 'OK',
677: count(bl.bid_number), 'OK', 'N')
678: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
679: WHERE bl.bid_number = p_bid_number
680: AND al.auction_header_id = bl.auction_header_id
681: AND al.line_number = bl.line_number
682: AND al.auction_header_id = p_auc_header_id

Line 706: 'PON_BID_ITEM_PRICES',

702: WORKSHEET_SEQUENCE_NUMBER,
703: ENTITY_MESSAGE_CODE)
704: VALUES
705: (p_interface_type,
706: 'PON_BID_ITEM_PRICES',
707: p_batch_id,
708: s_interface_line_id,
709: 'PON_GROUP_PARTIAL_BID_ERR',
710: p_userid,

Line 728: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

724:
725: -- If a lot has no bid, none of it's children can be bid on
726: WHEN s_group_type = 'LOT' AND s_has_bid_flag = 'N' AND EXISTS
727: (SELECT bl.bid_number
728: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
729: WHERE bl.bid_number = p_bid_number
730: AND al.auction_header_id = bl.auction_header_id
731: AND al.line_number = bl.line_number
732: AND al.auction_header_id = p_auc_header_id

Line 758: 'PON_BID_ITEM_PRICES',

754: WORKSHEET_SEQUENCE_NUMBER,
755: ENTITY_MESSAGE_CODE)
756: VALUES
757: (p_interface_type,
758: 'PON_BID_ITEM_PRICES',
759: p_batch_id,
760: s_interface_line_id,
761: 'PON_LOT_NOT_BID_ERR',
762: p_userid,

Line 789: FROM pon_bid_item_prices bl

785: to_char(null)) s_worksheet_name,
786: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number,
787: to_number(null)) s_worksheet_sequence_number,
788: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
789: FROM pon_bid_item_prices bl
790: , pon_auction_item_prices_all al
791: , pon_bid_headers pbh
792: WHERE bl.bid_number = p_bid_number
793: AND al.auction_header_id = bl.auction_header_id

Line 805: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

801: END validate_lots_and_groups;
802:
803: PROCEDURE validate_lines
804: (
805: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
807: p_interface_type IN pon_interface_errors.interface_type%TYPE,
808: p_userid IN pon_interface_errors.created_by%TYPE,
809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

802:
803: PROCEDURE validate_lines
804: (
805: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
806: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
807: p_interface_type IN pon_interface_errors.interface_type%TYPE,
808: p_userid IN pon_interface_errors.created_by%TYPE,
809: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
810: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 878: 'PON_BID_ITEM_PRICES',

874: (p_interface_type,
875: decode(p_spreadsheet, g_xml_upload_mode,
876: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),
877: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
878: 'PON_BID_ITEM_PRICES',
879: p_batch_id,
880: s_interface_line_id,
881: 'PON_AUCTS_MIN_DEC_NULL' || p_suffix,
882: p_userid,

Line 933: 'PON_BID_ITEM_PRICES',

929: WORKSHEET_SEQUENCE_NUMBER,
930: ENTITY_MESSAGE_CODE)
931: VALUES
932: (p_interface_type,
933: 'PON_BID_ITEM_PRICES',
934: p_batch_id,
935: s_interface_line_id,
936: 'PON_BID_PRICE_QTY_REQD' || p_suffix,
937: p_userid,

Line 988: 'PON_BID_ITEM_PRICES',

984: WORKSHEET_SEQUENCE_NUMBER,
985: ENTITY_MESSAGE_CODE)
986: VALUES
987: (p_interface_type,
988: 'PON_BID_ITEM_PRICES',
989: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
990: p_batch_id,
991: s_interface_line_id,
992: 'PON_BID_PRICE_REQUIRED' || p_suffix,

Line 1039: 'PON_BID_ITEM_PRICES',

1035: WORKSHEET_SEQUENCE_NUMBER,
1036: ENTITY_MESSAGE_CODE)
1037: VALUES
1038: (p_interface_type,
1039: 'PON_BID_ITEM_PRICES',
1040: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1041: p_batch_id,
1042: s_interface_line_id,
1043: 'PON_BID_QUANTITY_REQUIRED' || p_suffix,

Line 1093: 'PON_BID_ITEM_PRICES',

1089: ENTITY_MESSAGE_CODE)
1090: VALUES
1091: (p_interface_type,
1092: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1093: 'PON_BID_ITEM_PRICES',
1094: p_batch_id,
1095: s_interface_line_id,
1096: 'PON_AUC_BIDQTY_NEG' || p_suffix,
1097: p_userid,

Line 1147: 'PON_BID_ITEM_PRICES',

1143: ENTITY_MESSAGE_CODE)
1144: VALUES
1145: (p_interface_type,
1146: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1147: 'PON_BID_ITEM_PRICES',
1148: p_batch_id,
1149: s_interface_line_id,
1150: 'PON_INVALID_BID_QTY' || p_suffix,
1151: p_userid,

Line 1206: 'PON_BID_ITEM_PRICES',

1202: ENTITY_MESSAGE_CODE)
1203: VALUES
1204: (p_interface_type,
1205: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1206: 'PON_BID_ITEM_PRICES',
1207: p_batch_id,
1208: s_interface_line_id,
1209: 'PON_AUC_PROMISED_DATE_REQ',
1210: p_userid,

Line 1264: 'PON_BID_ITEM_PRICES',

1260: ENTITY_MESSAGE_CODE)
1261: VALUES
1262: (p_interface_type,
1263: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1264: 'PON_BID_ITEM_PRICES',
1265: p_batch_id,
1266: s_interface_line_id,
1267: 'PON_AUC_PDATE_TOO_EARLY',
1268: p_userid,

Line 1317: 'PON_BID_ITEM_PRICES',

1313: ENTITY_MESSAGE_CODE)
1314: VALUES
1315: (p_interface_type,
1316: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1317: 'PON_BID_ITEM_PRICES',
1318: p_batch_id,
1319: s_interface_line_id,
1320: 'PON_AUC_MINREL_POS_ZERO' || p_suffix,
1321: p_userid,

Line 1371: 'PON_BID_ITEM_PRICES',

1367: ENTITY_MESSAGE_CODE)
1368: VALUES
1369: (p_interface_type,
1370: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1371: 'PON_BID_ITEM_PRICES',
1372: p_batch_id,
1373: s_interface_line_id,
1374: 'PON_AUC_MINREL_MIN_PREC' || p_suffix,
1375: p_userid,

Line 1432: 'PON_BID_ITEM_PRICES',

1428: ENTITY_MESSAGE_CODE)
1429: VALUES
1430: (p_interface_type,
1431: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1432: 'PON_BID_ITEM_PRICES',
1433: p_batch_id,
1434: s_interface_line_id,
1435: 'PON_LINEPRICE_MUST_BE_POS',
1436: p_userid,

Line 1494: 'PON_BID_ITEM_PRICES',

1490: ENTITY_MESSAGE_CODE)
1491: VALUES
1492: (p_interface_type,
1493: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1494: 'PON_BID_ITEM_PRICES',
1495: p_batch_id,
1496: s_interface_line_id,
1497: 'PON_LINEPRICE_MIN_PREC' || p_suffix,
1498: p_userid,

Line 1552: 'PON_BID_ITEM_PRICES',

1548: ENTITY_MESSAGE_CODE)
1549: VALUES
1550: (p_interface_type,
1551: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1552: 'PON_BID_ITEM_PRICES',
1553: p_batch_id,
1554: s_interface_line_id,
1555: 'PON_BID_PRICE_REQUIRED' || p_suffix,
1556: p_userid,

Line 1601: , pon_bid_item_prices bl

1597: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
1598: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
1599: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
1600: FROM pon_auction_item_prices_all al
1601: , pon_bid_item_prices bl
1602: , pon_bid_headers pbh
1603: WHERE al.auction_header_id = p_auc_header_id
1604: AND bl.bid_number = p_bid_number
1605: AND al.line_number = bl.line_number

Line 1650: 'PON_BID_ITEM_PRICES',

1646: ENTITY_MESSAGE_CODE)
1647: VALUES
1648: (p_interface_type,
1649: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1650: 'PON_BID_ITEM_PRICES',
1651: p_batch_id,
1652: s_interface_line_id,
1653: decode(p_trans_view, 'N',
1654: 'PON_AUC_BIDPRICE_MUST_BE_POS' || p_suffix,

Line 1713: 'PON_BID_ITEM_PRICES',

1709: ENTITY_MESSAGE_CODE)
1710: VALUES
1711: (p_interface_type,
1712: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1713: 'PON_BID_ITEM_PRICES',
1714: p_batch_id,
1715: s_interface_line_id,
1716: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,
1717: p_userid,

Line 1774: 'PON_BID_ITEM_PRICES',

1770: ENTITY_MESSAGE_CODE)
1771: VALUES
1772: (p_interface_type,
1773: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1774: 'PON_BID_ITEM_PRICES',
1775: p_batch_id,
1776: s_interface_line_id,
1777: 'PON_LINE_BIDPRICE_INVALID_1' || p_suffix,
1778: p_userid,

Line 1835: 'PON_BID_ITEM_PRICES',

1831: decode(p_spreadsheet,
1832: g_xml_upload_mode,
1833: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
1834: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
1835: 'PON_BID_ITEM_PRICES',
1836: p_batch_id,
1837: s_interface_line_id,
1838: 'PON_AUC_LIMPRICE_MUST_BE_POS',
1839: p_userid,

Line 1896: 'PON_BID_ITEM_PRICES',

1892: decode(p_spreadsheet,
1893: g_xml_upload_mode,
1894: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
1895: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
1896: 'PON_BID_ITEM_PRICES',
1897: p_batch_id,
1898: s_interface_line_id,
1899: 'PON_AUCTS_LIMIT_MIN_PREC' || p_suffix,
1900: p_userid,

Line 1965: 'PON_BID_ITEM_PRICES',

1961: ENTITY_MESSAGE_CODE)
1962: VALUES
1963: (p_interface_type,
1964: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1965: 'PON_BID_ITEM_PRICES',
1966: p_batch_id,
1967: s_interface_line_id,
1968: 'PON_BP_LTE_BIDSTARTPRICE' || p_suffix,
1969: p_userid,

Line 2045: 'PON_BID_ITEM_PRICES',

2041: )
2042: VALUES
2043: (p_interface_type,
2044: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2045: 'PON_BID_ITEM_PRICES',
2046: p_batch_id,
2047: s_interface_line_id,
2048: 'PON_MIN_BID_DECREMENT' || p_suffix,
2049: p_userid,

Line 2120: 'PON_BID_ITEM_PRICES',

2116: )
2117: VALUES
2118: (p_interface_type,
2119: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2120: 'PON_BID_ITEM_PRICES',
2121: p_batch_id,
2122: s_interface_line_id,
2123: 'PON_MIN_BESTBID_DECREMENT' || p_suffix,
2124: p_userid,

Line 2187: 'PON_BID_ITEM_PRICES',

2183: ENTITY_MESSAGE_CODE)
2184: VALUES
2185: (p_interface_type,
2186: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2187: 'PON_BID_ITEM_PRICES',
2188: p_batch_id,
2189: s_interface_line_id,
2190: decode(p_bid_decr_method,'BEST_PRICE','PON_BESTBID_PRICE_LOWER','PON_BID_PRICE_LOWER') || p_suffix,
2191: p_userid,

Line 2253: 'PON_BID_ITEM_PRICES',

2249: decode(p_spreadsheet,
2250: g_xml_upload_mode,
2251: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2252: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2253: 'PON_BID_ITEM_PRICES',
2254: p_batch_id,
2255: s_interface_line_id,
2256: 'PON_AUCTS_LIMIT_MIN_LESS_PRI' || p_suffix,
2257: p_userid,

Line 2302: 'PON_BID_ITEM_PRICES',

2298: WORKSHEET_SEQUENCE_NUMBER,
2299: ENTITY_MESSAGE_CODE)
2300: VALUES
2301: (p_interface_type,
2302: 'PON_BID_ITEM_PRICES',
2303: p_batch_id,
2304: s_interface_line_id,
2305: 'PON_CANNOT_UNBID' || p_suffix,
2306: p_userid,

Line 2355: 'PON_BID_ITEM_PRICES',

2351: WORKSHEET_SEQUENCE_NUMBER,
2352: ENTITY_MESSAGE_CODE)
2353: VALUES
2354: (p_interface_type,
2355: 'PON_BID_ITEM_PRICES',
2356: p_batch_id,
2357: s_interface_line_id,
2358: 'PON_AUC_BAD_PBTYPE_GLOBAL',
2359: p_userid,

Line 2417: 'PON_BID_ITEM_PRICES',

2413: WORKSHEET_SEQUENCE_NUMBER,
2414: ENTITY_MESSAGE_CODE)
2415: VALUES
2416: (p_interface_type,
2417: 'PON_BID_ITEM_PRICES',
2418: p_batch_id,
2419: s_interface_line_id,
2420: 'PON_AUC_BAD_PBTYPE_SHIPS',
2421: p_userid,

Line 2476: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,

2472: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
2473: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
2474: bh.rate s_rate,
2475: bh.number_price_decimals s_precision
2476: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,
2477: pon_bid_headers bh
2478: WHERE al.auction_header_id = p_auc_header_id
2479: AND bh.bid_number = p_bid_number
2480: AND bl.bid_number = p_bid_number

Line 2508: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1

2504: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2505: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2506: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2507: VALUES
2508: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
2509: p_batch_id, s_interface_line_id, 'PON_RTNG_RATE_WRONG_L', --2
2510: p_userid, sysdate, p_userid, --3
2511: sysdate, p_request_id, 'BID_ITEMS', --4
2512: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

Line 2533: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1

2529: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2530: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2531: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2532: VALUES
2533: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
2534: p_batch_id, s_interface_line_id, 'PON_MAX_RTNG_WRONG_L', --2
2535: p_userid, sysdate, p_userid, --3
2536: sysdate, p_request_id, 'BID_ITEMS', --4
2537: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

Line 2558: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2554: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2555: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2556: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2557: VALUES
2558: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2559: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_WRONG_L', --2
2560: p_userid, sysdate, p_userid, --3
2561: sysdate, p_request_id, 'BID_ITEMS', --4
2562: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

Line 2584: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1

2580: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2581: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2582: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2583: VALUES
2584: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
2585: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_RATE_WRONG_L', --2
2586: p_userid, sysdate, p_userid, --3
2587: sysdate, p_request_id, 'BID_ITEMS', --4
2588: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

Line 2610: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2606: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2607: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2608: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2609: VALUES
2610: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2611: p_batch_id, s_interface_line_id, 'PON_RECOUP_RATE_WRONG', --2
2612: p_userid, sysdate, p_userid, --3
2613: sysdate, p_request_id, 'BID_ITEMS', --4
2614: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

Line 2637: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1

2633: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2634: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
2635: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2636: VALUES
2637: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
2638: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_NEEDED_L', --2
2639: p_userid, sysdate, p_userid, --3
2640: sysdate, p_request_id, 'BID_ITEMS', --4
2641: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'TXT', --5

Line 2665: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1

2661: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2662: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2663: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2664: VALUES
2665: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
2666: p_batch_id, s_interface_line_id, 'PON_RETAINAGE_NEEDED_L', --2
2667: p_userid, sysdate, p_userid, --3
2668: sysdate, p_request_id, 'BID_ITEMS', --4
2669: 'RetainageRatePercent', retainage_rate_percent, 'TXT', --5

Line 2693: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1

2689: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2690: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
2691: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2692: VALUES
2693: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
2694: p_batch_id, s_interface_line_id, 'PON_MAX_RETAINAGE_NEEDED_L', --2
2695: p_userid, sysdate, p_userid, --3
2696: sysdate, p_request_id, 'BID_ITEMS', --4
2697: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'TXT', --5

Line 2724: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2720: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2721: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2722: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2723: VALUES
2724: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2725: p_batch_id, s_interface_line_id, 'PON_RECUP_RATE_NEEDED_L', --2
2726: p_userid, sysdate, p_userid, --3
2727: sysdate, p_request_id, 'BID_ITEMS', --4
2728: 'RecoupmentRatePercent', recoupment_rate_percent, 'TXT', --5

Line 2752: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2748: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2749: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2750: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2751: VALUES
2752: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2753: p_batch_id, s_interface_line_id, 'PON_ADVANCE_AMT_NEEDED_L', --2
2754: p_userid, sysdate, p_userid, --3
2755: sysdate, p_request_id, 'BID_ITEMS', --4
2756: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'TXT', --5

Line 2788: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

2784: pah.contract_type,
2785: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
2786: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
2787: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
2788: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
2789: WHERE al.auction_header_id = p_auc_header_id
2790: AND bl.bid_number = p_bid_number
2791: AND pah.auction_header_id = p_auc_header_id
2792: AND al.line_number = bl.line_number

Line 2817: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2813: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2814: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, --7
2815: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2816: VALUES
2817: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2818: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_MORE_L', --2
2819: p_userid, sysdate, p_userid, --3
2820: sysdate, p_request_id, 'BID_ITEMS', --4
2821: NULL, bid_curr_advance_amount, 'NUM', --5

Line 2849: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2845: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2846: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
2847: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2848: VALUES
2849: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2850: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_PYMT_L', --2
2851: p_userid, sysdate, p_userid, --3
2852: sysdate, p_request_id, 'BID_ITEMS', --4
2853: NULL, recoupment_rate_percent, 'NUM', --5

Line 2876: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

2872: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2873: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
2874: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2875: VALUES
2876: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
2877: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_ADV_L', --2
2878: p_userid, sysdate, p_userid, --3
2879: sysdate, p_request_id, 'BID_ITEMS', --4
2880: NULL, recoupment_rate_percent, 'NUM', --5

Line 2908: (p_interface_type, NULL, 'PON_BID_ITEM_PRICES', --1

2904: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2905: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2906: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2907: VALUES
2908: (p_interface_type, NULL, 'PON_BID_ITEM_PRICES', --1
2909: p_batch_id, s_interface_line_id, 'PON_PYMNT_AMT_MORE_ACTUAL', --2
2910: p_userid, sysdate, p_userid, --3
2911: sysdate, p_request_id, 'BID_ITEMS', --4
2912: NULL, NULL, 'TXT', --5

Line 2940: (p_interface_type, NULL, 'PON_BID_ITEM_PRICES', --1

2936: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2937: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
2938: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
2939: VALUES
2940: (p_interface_type, NULL, 'PON_BID_ITEM_PRICES', --1
2941: p_batch_id, s_interface_line_id, 'PON_PYMNT_AMT_MORE_FINANCE', --2
2942: p_userid, sysdate, p_userid, --3
2943: sysdate, p_request_id, 'BID_ITEMS', --4
2944: NULL, NULL, 'TXT', --5

Line 2967: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1

2963: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2964: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
2965: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2966: VALUES
2967: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
2968: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
2969: p_userid, sysdate, p_userid, --3
2970: sysdate, p_request_id, 'BID_ITEMS', --4
2971: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

Line 2994: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1

2990: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
2991: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
2992: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
2993: VALUES
2994: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
2995: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
2996: p_userid, sysdate, p_userid, --3
2997: sysdate, p_request_id, 'BID_ITEMS', --4
2998: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

Line 3021: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1

3017: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3018: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3019: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3020: VALUES
3021: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3022: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3023: p_userid, sysdate, p_userid, --3
3024: sysdate, p_request_id, 'BID_ITEMS', --4
3025: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

Line 3048: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1

3044: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3045: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3046: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3047: VALUES
3048: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3049: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3050: p_userid, sysdate, p_userid, --3
3051: sysdate, p_request_id, 'BID_ITEMS', --4
3052: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

Line 3075: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1

3071: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3072: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3073: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME,WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3074: VALUES
3075: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3076: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3077: p_userid, sysdate, p_userid, --3
3078: sysdate, p_request_id, 'BID_ITEMS', --4
3079: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

Line 3111: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah

3107: pah.contract_type,
3108: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_name, to_char(null)) s_worksheet_name,
3109: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3110: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code
3111: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3112: WHERE al.auction_header_id = p_auc_header_id
3113: AND bl.bid_number = p_bid_number
3114: AND pah.auction_header_id = p_auc_header_id
3115: AND al.line_number = bl.line_number

Line 3123: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

3119: END validate_lines;
3120:
3121: PROCEDURE validate_requirements
3122: (
3123: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3124: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3125: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3126: p_userid IN pon_interface_errors.created_by%TYPE,
3127: p_spreadsheet IN VARCHAR2,

Line 3124: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

3120:
3121: PROCEDURE validate_requirements
3122: (
3123: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3124: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3125: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3126: p_userid IN pon_interface_errors.created_by%TYPE,
3127: p_spreadsheet IN VARCHAR2,
3128: p_suffix IN VARCHAR2,

Line 3294: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

3290:
3291:
3292: PROCEDURE validate_attributes
3293: (
3294: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3295: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3296: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3297: p_userid IN pon_interface_errors.created_by%TYPE,
3298: p_spreadsheet IN VARCHAR2,

Line 3295: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

3291:
3292: PROCEDURE validate_attributes
3293: (
3294: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3295: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3296: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3297: p_userid IN pon_interface_errors.created_by%TYPE,
3298: p_spreadsheet IN VARCHAR2,
3299: p_suffix IN VARCHAR2,

Line 3437: , pon_bid_item_prices bl

3433: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ATTRIBUTES', null) s_entity_message_code
3434: FROM pon_bid_attribute_values ba
3435: , pon_auction_attributes aa
3436: , pon_auction_item_prices_all al
3437: , pon_bid_item_prices bl
3438: , pon_bid_headers pbh
3439: WHERE ba.bid_number = p_bid_number
3440: AND ba.line_number <> -1
3441: AND aa.auction_header_id = ba.auction_header_id

Line 3457: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

3453: END validate_attributes;
3454:
3455: PROCEDURE validate_cost_factors
3456: (
3457: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3458: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3460: p_userid IN pon_interface_errors.created_by%TYPE,
3461: p_spreadsheet IN VARCHAR2,

Line 3458: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

3454:
3455: PROCEDURE validate_cost_factors
3456: (
3457: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3458: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3459: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3460: p_userid IN pon_interface_errors.created_by%TYPE,
3461: p_spreadsheet IN VARCHAR2,
3462: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 3788: , pon_bid_item_prices bl

3784: fnd_message.get_string('PON', 'PON_AUCTS_ATTR_BID_VALUE' || p_suffix),
3785: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name
3786: FROM pon_bid_price_elements bpf
3787: , pon_auction_item_prices_all al
3788: , pon_bid_item_prices bl
3789: , pon_price_element_types_tl pft
3790: , pon_bid_headers pbh
3791: WHERE bpf.bid_number = p_bid_number
3792: AND bpf.pf_type = 'SUPPLIER' -- only validate SUPPLIER cost factors

Line 3808: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

3804: END validate_cost_factors;
3805:
3806: PROCEDURE validate_price_breaks
3807: (
3808: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3809: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3810: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3811: p_userid IN pon_interface_errors.created_by%TYPE,
3812: p_spreadsheet IN VARCHAR2,

Line 3809: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

3805:
3806: PROCEDURE validate_price_breaks
3807: (
3808: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3809: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3810: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3811: p_userid IN pon_interface_errors.created_by%TYPE,
3812: p_spreadsheet IN VARCHAR2,
3813: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 4899: , pon_bid_item_prices bl

4895: 'PON_AUCTS_PRICE_BREAKS',
4896: null
4897: ) s_entity_name
4898: FROM pon_bid_shipments bpb
4899: , pon_bid_item_prices bl
4900: , pon_auction_item_prices_all al
4901: , pon_bid_headers pbh
4902: WHERE bpb.bid_number = p_bid_number
4903: AND bl.bid_number = bpb.bid_number

Line 4932: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

4928: * =======================================================*/
4929:
4930: PROCEDURE VALIDATE_QTY_BASED_PRICE_TIERS
4931: (
4932: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4933: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,

Line 4933: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

4929:
4930: PROCEDURE VALIDATE_QTY_BASED_PRICE_TIERS
4931: (
4932: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4933: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4934: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4935: p_userid IN pon_interface_errors.created_by%TYPE,
4936: p_spreadsheet IN VARCHAR2,
4937: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 5636: 'PON_BID_ITEM_PRICES',

5632: ENTITY_MESSAGE_CODE
5633: )
5634: VALUES
5635: (p_interface_type,
5636: 'PON_BID_ITEM_PRICES',
5637: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
5638: p_batch_id,
5639: s_interface_line_id,
5640: 'PON_BID_QTY_NOT_WITHIN_TIERS',

Line 5698: 'PON_BID_ITEM_PRICES',

5694: ENTITY_MESSAGE_CODE
5695: )
5696: VALUES
5697: (p_interface_type,
5698: 'PON_BID_ITEM_PRICES',
5699: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
5700: p_batch_id,
5701: s_interface_line_id,
5702: 'PON_BID_PRICE_NOT_WITHIN_TIERS',

Line 5742: pon_bid_item_prices bl,

5738: 'PON_AUCTS_PRICE_TIERS',
5739: null
5740: ) s_entity_name
5741: FROM pon_bid_shipments bpb,
5742: pon_bid_item_prices bl,
5743: pon_auction_item_prices_all al,
5744: (SELECT MAX(shipments.max_quantity) max_quantity,
5745: shipments.bid_number,
5746: shipments.line_number

Line 5812: From pon_bid_item_prices bl

5808: bl.line_number,
5809: g_exp_date,
5810: 'LINENUM',
5811: al.document_disp_line_number
5812: From pon_bid_item_prices bl
5813: , pon_auction_item_prices_all al
5814: , pon_bid_headers pbh
5815: where bl.bid_number = p_bid_number
5816: AND al.auction_header_id = bl.auction_header_id

Line 5843: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

5839: END VALIDATE_QTY_BASED_PRICE_TIERS;
5840:
5841: PROCEDURE validate_price_differentials
5842: (
5843: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
5844: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5845: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5846: p_userid IN pon_interface_errors.created_by%TYPE,
5847: p_spreadsheet IN VARCHAR2,

Line 5844: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

5840:
5841: PROCEDURE validate_price_differentials
5842: (
5843: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
5844: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5845: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5846: p_userid IN pon_interface_errors.created_by%TYPE,
5847: p_spreadsheet IN VARCHAR2,
5848: p_suffix IN VARCHAR2,

Line 6258: , pon_bid_item_prices bl

6254: 'PON_PRICE_DIFFERENTIALS',
6255: null
6256: ) s_entity_name
6257: FROM pon_bid_price_differentials bpd
6258: , pon_bid_item_prices bl
6259: , pon_auction_item_prices_all al
6260: , pon_price_differentials apd
6261: , pon_auction_shipments_all apb
6262: , po_price_diff_lookups_v pdl

Line 6288: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

6284:
6285:
6286: PROCEDURE validate_payments
6287: (
6288: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

6285:
6286: PROCEDURE validate_payments
6287: (
6288: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6289: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6290: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6291: p_userid IN pon_interface_errors.created_by%TYPE,
6292: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
6293: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 6337: 'PON_BID_ITEM_PRICES',

6333: TOKEN2_VALUE)
6334: SELECT
6335: p_interface_type,
6336: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'),
6337: 'PON_BID_ITEM_PRICES',
6338: p_batch_id,
6339: 'PON_PYMT_NUM_NOT_UNQ',
6340: p_userid,
6341: sysdate,

Line 6643: PON_BID_ITEM_PRICES pbi

6639: pbp.bid_payment_id,
6640: pbi.line_number bid_line_number
6641: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,
6642: PON_AUCTION_ITEM_PRICES_ALL pai,
6643: PON_BID_ITEM_PRICES pbi
6644: WHERE pbp.auction_header_id = pai.auction_header_id
6645: AND pbp.auction_line_number = pai.line_number
6646: AND pbi.auction_header_id = pai.auction_header_id
6647: AND pbi.line_number = pai.line_number

Line 6669: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

6665: END validate_payments;
6666:
6667: PROCEDURE perform_all_validations
6668: (
6669: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6672: p_userid IN pon_interface_errors.created_by%TYPE,
6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

6666:
6667: PROCEDURE perform_all_validations
6668: (
6669: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6670: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6671: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6672: p_userid IN pon_interface_errors.created_by%TYPE,
6673: p_batch_id IN pon_interface_errors.batch_id%TYPE,
6674: p_request_id IN pon_interface_errors.request_id%TYPE,

Line 7052: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7048: END perform_all_validations;
7049:
7050: PROCEDURE validate_bid
7051: (
7052: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7055: p_userid IN pon_interface_errors.created_by%TYPE,
7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7049:
7050: PROCEDURE validate_bid
7051: (
7052: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7053: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7054: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7055: p_userid IN pon_interface_errors.created_by%TYPE,
7056: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7057: p_request_id IN pon_interface_errors.request_id%TYPE,

Line 7070: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7066: END validate_bid;
7067:
7068: PROCEDURE validate_spreadsheet_upload
7069: (
7070: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7071: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7073: p_spreadsheet_type IN VARCHAR2,
7074: p_userid IN pon_interface_errors.created_by%TYPE,

Line 7071: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7067:
7068: PROCEDURE validate_spreadsheet_upload
7069: (
7070: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7071: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7072: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7073: p_spreadsheet_type IN VARCHAR2,
7074: p_userid IN pon_interface_errors.created_by%TYPE,
7075: p_batch_id IN pon_interface_errors.batch_id%TYPE,