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 134: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

130:
131:
132: PROCEDURE populate_has_bid_changed_line
133: (
134: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
135: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
136: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
137: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
138: p_batch_start IN NUMBER,

Line 135: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

131:
132: PROCEDURE populate_has_bid_changed_line
133: (
134: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
135: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
136: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
137: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
138: p_batch_start IN NUMBER,
139: p_batch_end IN NUMBER,

Line 136: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,

132: PROCEDURE populate_has_bid_changed_line
133: (
134: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
135: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
136: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
137: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
138: p_batch_start IN NUMBER,
139: p_batch_end IN NUMBER,
140: p_rebid_flag IN VARCHAR2,

Line 137: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,

133: (
134: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
135: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
136: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
137: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
138: p_batch_start IN NUMBER,
139: p_batch_end IN NUMBER,
140: p_rebid_flag IN VARCHAR2,
141: p_blanket IN VARCHAR2,

Line 161: UPDATE pon_bid_item_prices bl

157: -- since power bidding is always a rebid, we will always be
158: -- initializing all is_changed_line_flag to 'N' and then selectively
159: -- setting them to 'Y' with the is_changed_line logic below
160:
161: UPDATE pon_bid_item_prices bl
162: SET bl.has_bid_flag = decode(p_use_batch_id, 'Y', 'Y', bl.has_bid_flag),
163: bl.is_changed_line_flag = decode(p_rebid_flag, 'N', 'Y', 'N'),
164: bl.has_user_bid_flag = Decode(g_is_fed, 'Y',
165: decode(p_use_batch_id, 'Y', 'Y', bl.has_user_bid_flag),'') -- ELIN project changes

Line 181: UPDATE pon_bid_item_prices bl

177: IF (p_use_batch_id = 'Y' AND p_rebid_flag = 'N') THEN
178: RETURN;
179: END IF;
180:
181: UPDATE pon_bid_item_prices bl
182: SET bl.is_changed_line_flag = 'Y'
183: WHERE bl.bid_number = p_bid_number
184: AND ((p_use_batch_id = 'Y' AND bl.batch_id = p_batch_id)
185: OR (p_use_batch_id = 'N'

Line 307: UPDATE pon_bid_item_prices pbip

303:
304:
305: -- process groups
306: -- when a group line has been changed, change the group too.
307: UPDATE pon_bid_item_prices pbip
308: SET pbip.is_changed_line_flag = 'Y'
309: WHERE pbip.bid_number = p_bid_number
310: AND pbip.line_number IN
311: (SELECT al.parent_line_number

Line 312: FROM pon_bid_item_prices bl,

308: SET pbip.is_changed_line_flag = 'Y'
309: WHERE pbip.bid_number = p_bid_number
310: AND pbip.line_number IN
311: (SELECT al.parent_line_number
312: FROM pon_bid_item_prices bl,
313: pon_auction_item_prices_all al
314: WHERE bl.bid_number = p_bid_number
315: AND bl.auction_header_id = al.auction_header_id
316: AND bl.line_number = al.line_number

Line 336: UPDATE pon_bid_item_prices bl

332:
333: -- Check all unmodified lines against source_bid if the source_bid is valid
334: IF (p_spreadsheet = g_xml_upload_mode and p_blanket = 'Y' AND p_rebid_flag = 'Y' AND p_source_bid > 0) THEN
335:
336: UPDATE pon_bid_item_prices bl
337: SET bl.is_changed_line_flag = 'Y'
338: WHERE bl.bid_number = p_bid_number
339: AND bl.batch_id = p_batch_id
340: AND (EXISTS

Line 374: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

370:
371: -- wrapper for spreadsheet case
372: PROCEDURE populate_has_bid_changed_line
373: (
374: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
375: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
376: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
377: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
378: p_rebid_flag VARCHAR2,

Line 375: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

371: -- wrapper for spreadsheet case
372: PROCEDURE populate_has_bid_changed_line
373: (
374: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
375: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
376: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
377: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
378: p_rebid_flag VARCHAR2,
379: p_blanket VARCHAR2,

Line 376: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,

372: PROCEDURE populate_has_bid_changed_line
373: (
374: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
375: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
376: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
377: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
378: p_rebid_flag VARCHAR2,
379: p_blanket VARCHAR2,
380: p_spreadsheet IN VARCHAR2

Line 377: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,

373: (
374: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
375: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
376: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
377: p_batch_id IN pon_bid_item_prices.batch_id%TYPE,
378: p_rebid_flag VARCHAR2,
379: p_blanket VARCHAR2,
380: p_spreadsheet IN VARCHAR2
381: )

Line 394: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

390:
391: -- wrapper for online case
392: PROCEDURE populate_has_bid_changed_line
393: (
394: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
395: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
396: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
397: p_batch_start IN NUMBER,
398: p_batch_end IN NUMBER,

Line 395: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

391: -- wrapper for online case
392: PROCEDURE populate_has_bid_changed_line
393: (
394: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
395: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
396: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
397: p_batch_start IN NUMBER,
398: p_batch_end IN NUMBER,
399: p_rebid_flag IN VARCHAR2,

Line 396: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,

392: PROCEDURE populate_has_bid_changed_line
393: (
394: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
395: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
396: p_source_bid IN pon_bid_item_prices.bid_number%TYPE,
397: p_batch_start IN NUMBER,
398: p_batch_end IN NUMBER,
399: p_rebid_flag IN VARCHAR2,
400: p_blanket IN VARCHAR2,

Line 413: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

409:
410:
411: PROCEDURE calc_total_weighted_score
412: (
413: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
414: p_batch_id IN pon_bid_item_prices.batch_id%TYPE
415: ) IS
416: BEGIN
417:

Line 414: p_batch_id IN pon_bid_item_prices.batch_id%TYPE

410:
411: PROCEDURE calc_total_weighted_score
412: (
413: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
414: p_batch_id IN pon_bid_item_prices.batch_id%TYPE
415: ) IS
416: BEGIN
417:
418: -- First populate the score for each attribute

Line 448: FROM pon_bid_item_prices bl

444: AND to_date(nvl(s.to_range, ba.value), 'dd-mm-yyyy')))),
445: nvl2(ba.value, 0, null))
446: WHERE ba.bid_number = p_bid_number
447: AND EXISTS (SELECT bl.line_number
448: FROM pon_bid_item_prices bl
449: WHERE bl.bid_number = p_bid_number
450: AND bl.line_number = ba.line_number
451: AND bl.batch_id = p_batch_id);
452:

Line 465: FROM pon_bid_item_prices bl

461: AND aa.line_number = ba.line_number
462: AND aa.sequence_number = ba.sequence_number)
463: WHERE ba.bid_number = p_bid_number
464: AND EXISTS (SELECT bl.line_number
465: FROM pon_bid_item_prices bl
466: WHERE bl.bid_number = p_bid_number
467: AND bl.line_number = ba.line_number
468: AND bl.batch_id = p_batch_id);
469:

Line 481: UPDATE pon_bid_item_prices bl

477: -- 0, if line has bid then 100 else null,
478: -- # scored attr with bids,
479: -- score, null)
480:
481: UPDATE pon_bid_item_prices bl
482: SET bl.total_weighted_score =
483: (SELECT decode(sum(sign(aa.weight)),
484: null, decode(bl.has_bid_flag, 'Y', 100, null),
485: 0, decode(bl.has_bid_flag, 'Y', 100, null),

Line 501: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

497: END calc_total_weighted_score;
498:
499: PROCEDURE validate_bids_placed
500: (
501: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
502: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
503: p_interface_type IN pon_interface_errors.interface_type%TYPE,
504: p_userid IN pon_interface_errors.created_by%TYPE,
505: p_rebid IN VARCHAR2,

Line 502: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

498:
499: PROCEDURE validate_bids_placed
500: (
501: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
502: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
503: p_interface_type IN pon_interface_errors.interface_type%TYPE,
504: p_userid IN pon_interface_errors.created_by%TYPE,
505: p_rebid IN VARCHAR2,
506: p_bid_all_lines IN VARCHAR2,

Line 563: FROM pon_bid_item_prices

559: l_changed_unsol_line_count := 0;
560:
561: SELECT Count(*)
562: INTO l_changed_unsol_line_count
563: FROM pon_bid_item_prices
564: WHERE bid_number = p_bid_number
565: AND auction_line_number = -1
566: AND Nvl(is_changed_line_flag,'N') = 'Y';
567:

Line 707: FROM pon_bid_item_prices bl,

703: Decode( Decode(paha.contract_type,'STANDARD','Y','N'),'N',1,
704: 0))), 0), 0), 0))) s_bidded_lines
705:
706: ----------------------------------------------------------------------------
707: FROM pon_bid_item_prices bl,
708: pon_auction_item_prices_all paip
709: -- added by Allen Yang for surrogate bid bug 7703665, #8220778 2009/02/03
710: ---------------------------------------------------------------
711: , pon_auction_headers_all paha,

Line 730: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

726: END validate_bids_placed;
727:
728: PROCEDURE validate_lots_and_groups
729: (
730: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
731: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
732: p_interface_type IN pon_interface_errors.interface_type%TYPE,
733: p_userid IN pon_interface_errors.created_by%TYPE,
734: p_spreadsheet IN VARCHAR2,

Line 731: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

727:
728: PROCEDURE validate_lots_and_groups
729: (
730: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
731: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
732: p_interface_type IN pon_interface_errors.interface_type%TYPE,
733: p_userid IN pon_interface_errors.created_by%TYPE,
734: p_spreadsheet IN VARCHAR2,
735: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 746: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

742: -- All lines in a GROUP must be bid on simultaneously
743: WHEN s_group_type = 'GROUP' AND
744: (SELECT decode(sum(decode(bl.has_bid_flag, 'Y', 1, 0)), 0, 'OK',
745: count(bl.bid_number), 'OK', 'N')
746: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
747: WHERE bl.bid_number = p_bid_number
748: AND al.auction_header_id = bl.auction_header_id
749: AND al.line_number = bl.line_number
750: AND al.auction_header_id = p_auc_header_id

Line 774: 'PON_BID_ITEM_PRICES',

770: WORKSHEET_SEQUENCE_NUMBER,
771: ENTITY_MESSAGE_CODE)
772: VALUES
773: (p_interface_type,
774: 'PON_BID_ITEM_PRICES',
775: p_batch_id,
776: s_interface_line_id,
777: 'PON_GROUP_PARTIAL_BID_ERR',
778: p_userid,

Line 797: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al

793:
794: -- If a lot has no bid, none of it's children can be bid on
795: WHEN s_group_type = 'LOT' AND s_has_bid_flag = 'N' AND EXISTS
796: (SELECT bl.bid_number
797: FROM pon_bid_item_prices bl, pon_auction_item_prices_all al
798: WHERE bl.bid_number = p_bid_number
799: AND al.auction_header_id = bl.auction_header_id
800: AND al.line_number = bl.line_number
801: AND al.auction_header_id = p_auc_header_id

Line 827: 'PON_BID_ITEM_PRICES',

823: WORKSHEET_SEQUENCE_NUMBER,
824: ENTITY_MESSAGE_CODE)
825: VALUES
826: (p_interface_type,
827: 'PON_BID_ITEM_PRICES',
828: p_batch_id,
829: s_interface_line_id,
830: 'PON_LOT_NOT_BID_ERR',
831: p_userid,

Line 860: FROM pon_bid_item_prices bl

856: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number,
857: to_number(null)) s_worksheet_sequence_number,
858: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
859: al.line_num_display s_clm_line_num_display
860: FROM pon_bid_item_prices bl
861: , pon_auction_item_prices_all al
862: , pon_bid_headers pbh
863: WHERE bl.bid_number = p_bid_number
864: AND al.auction_header_id = bl.auction_header_id

Line 876: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

872: END validate_lots_and_groups;
873:
874: PROCEDURE validate_lines
875: (
876: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
877: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
878: p_interface_type IN pon_interface_errors.interface_type%TYPE,
879: p_userid IN pon_interface_errors.created_by%TYPE,
880: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,

Line 877: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

873:
874: PROCEDURE validate_lines
875: (
876: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
877: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
878: p_interface_type IN pon_interface_errors.interface_type%TYPE,
879: p_userid IN pon_interface_errors.created_by%TYPE,
880: p_tpid IN pon_bid_headers.trading_partner_id%TYPE,
881: p_vensid IN pon_bid_headers.vendor_site_id%TYPE,

Line 949: 'PON_BID_ITEM_PRICES',

945: (p_interface_type,
946: decode(p_spreadsheet, g_xml_upload_mode,
947: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_DEC' || p_suffix),
948: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
949: 'PON_BID_ITEM_PRICES',
950: p_batch_id,
951: s_interface_line_id,
952: 'PON_AUCTS_MIN_DEC_NULL' || p_suffix,
953: p_userid,

Line 1005: 'PON_BID_ITEM_PRICES',

1001: WORKSHEET_SEQUENCE_NUMBER,
1002: ENTITY_MESSAGE_CODE)
1003: VALUES
1004: (p_interface_type,
1005: 'PON_BID_ITEM_PRICES',
1006: p_batch_id,
1007: s_interface_line_id,
1008: 'PON_BID_PRICE_QTY_REQD' || p_suffix,
1009: p_userid,

Line 1061: 'PON_BID_ITEM_PRICES',

1057: WORKSHEET_SEQUENCE_NUMBER,
1058: ENTITY_MESSAGE_CODE)
1059: VALUES
1060: (p_interface_type,
1061: 'PON_BID_ITEM_PRICES',
1062: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
1063: p_batch_id,
1064: s_interface_line_id,
1065: 'PON_BID_PRICE_REQUIRED' || p_suffix,

Line 1113: 'PON_BID_ITEM_PRICES',

1109: WORKSHEET_SEQUENCE_NUMBER,
1110: ENTITY_MESSAGE_CODE)
1111: VALUES
1112: (p_interface_type,
1113: 'PON_BID_ITEM_PRICES',
1114: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1115: p_batch_id,
1116: s_interface_line_id,
1117: 'PON_BID_QUANTITY_REQUIRED' || p_suffix,

Line 1168: 'PON_BID_ITEM_PRICES',

1164: ENTITY_MESSAGE_CODE)
1165: VALUES
1166: (p_interface_type,
1167: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1168: 'PON_BID_ITEM_PRICES',
1169: p_batch_id,
1170: s_interface_line_id,
1171: 'PON_AUC_BIDQTY_NEG' || p_suffix,
1172: p_userid,

Line 1223: 'PON_BID_ITEM_PRICES',

1219: ENTITY_MESSAGE_CODE)
1220: VALUES
1221: (p_interface_type,
1222: fnd_message.get_string('PON', 'PON_AUCTS_BID_QTY' || p_suffix),
1223: 'PON_BID_ITEM_PRICES',
1224: p_batch_id,
1225: s_interface_line_id,
1226: 'PON_INVALID_BID_QTY' || p_suffix,
1227: p_userid,

Line 1283: 'PON_BID_ITEM_PRICES',

1279: ENTITY_MESSAGE_CODE)
1280: VALUES
1281: (p_interface_type,
1282: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1283: 'PON_BID_ITEM_PRICES',
1284: p_batch_id,
1285: s_interface_line_id,
1286: 'PON_AUC_PROMISED_DATE_REQ',
1287: p_userid,

Line 1342: 'PON_BID_ITEM_PRICES',

1338: ENTITY_MESSAGE_CODE)
1339: VALUES
1340: (p_interface_type,
1341: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1342: 'PON_BID_ITEM_PRICES',
1343: p_batch_id,
1344: s_interface_line_id,
1345: 'PON_AUC_PDATE_TOO_EARLY',
1346: p_userid,

Line 1399: 'PON_BID_ITEM_PRICES',

1395: ENTITY_MESSAGE_CODE)
1396: VALUES
1397: (p_interface_type,
1398: fnd_message.get_string('PON', 'PON_AUCTS_PROMISED_DATE'),
1399: 'PON_BID_ITEM_PRICES',
1400: p_batch_id,
1401: s_interface_line_id,
1402: 'PON_CLM_PROMISE_POPDT_LINE_VAL',
1403: p_userid,

Line 1456: 'PON_BID_ITEM_PRICES',

1452: ENTITY_MESSAGE_CODE)
1453: VALUES
1454: (p_interface_type,
1455: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),
1456: 'PON_BID_ITEM_PRICES',
1457: p_batch_id,
1458: s_interface_line_id,
1459: 'PON_CLM_PROMISE_POP_ENDDT_REQ',
1460: p_userid,

Line 1512: 'PON_BID_ITEM_PRICES',

1508: ENTITY_MESSAGE_CODE)
1509: VALUES
1510: (p_interface_type,
1511: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
1512: 'PON_BID_ITEM_PRICES',
1513: p_batch_id,
1514: s_interface_line_id,
1515: 'PON_CLM_PROMISE_POP_STDT_REQ',
1516: p_userid,

Line 1570: 'PON_BID_ITEM_PRICES',

1566: ENTITY_MESSAGE_CODE)
1567: VALUES
1568: (p_interface_type,
1569: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
1570: 'PON_BID_ITEM_PRICES',
1571: p_batch_id,
1572: s_interface_line_id,
1573: 'PON_CLM_PROMISE_POP_DATE_VALX',
1574: p_userid,

Line 1628: 'PON_BID_ITEM_PRICES',

1624: ENTITY_MESSAGE_CODE)
1625: VALUES
1626: (p_interface_type,
1627: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_START_DATE'),
1628: 'PON_BID_ITEM_PRICES',
1629: p_batch_id,
1630: s_interface_line_id,
1631: 'PON_BID_POP_START_BEF_TODAY',
1632: p_userid,

Line 1686: 'PON_BID_ITEM_PRICES',

1682: ENTITY_MESSAGE_CODE)
1683: VALUES
1684: (p_interface_type,
1685: fnd_message.get_string('PON', 'PON_CLM_PROMISE_POP_END_DATE'),
1686: 'PON_BID_ITEM_PRICES',
1687: p_batch_id,
1688: s_interface_line_id,
1689: 'PON_BID_POP_END_BEF_TODAY',
1690: p_userid,

Line 1745: 'PON_BID_ITEM_PRICES',

1741: ENTITY_MESSAGE_CODE)
1742: VALUES
1743: (p_interface_type,
1744: fnd_message.get_string('PON', 'PON_CLM_PROMISE_PERIOD'),
1745: 'PON_BID_ITEM_PRICES',
1746: p_batch_id,
1747: s_interface_line_id,
1748: 'PON_BID_INV_PERIOD',
1749: p_userid,

Line 1803: 'PON_BID_ITEM_PRICES',

1799: ENTITY_MESSAGE_CODE)
1800: VALUES
1801: (p_interface_type,
1802: fnd_message.get_string('PON', 'PON_CLM_PROMISE_PERIOD'),
1803: 'PON_BID_ITEM_PRICES',
1804: p_batch_id,
1805: s_interface_line_id,
1806: 'PON_BID_INV_POP_DUR',
1807: p_userid,

Line 1857: 'PON_BID_ITEM_PRICES',

1853: ENTITY_MESSAGE_CODE)
1854: VALUES
1855: (p_interface_type,
1856: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1857: 'PON_BID_ITEM_PRICES',
1858: p_batch_id,
1859: s_interface_line_id,
1860: 'PON_AUC_MINREL_POS_ZERO' || p_suffix,
1861: p_userid,

Line 1912: 'PON_BID_ITEM_PRICES',

1908: ENTITY_MESSAGE_CODE)
1909: VALUES
1910: (p_interface_type,
1911: fnd_message.get_string('PON', 'PON_AUC_BID_MIN_REL_AMOUNT' || p_suffix),
1912: 'PON_BID_ITEM_PRICES',
1913: p_batch_id,
1914: s_interface_line_id,
1915: 'PON_AUC_MINREL_MIN_PREC' || p_suffix,
1916: p_userid,

Line 1974: 'PON_BID_ITEM_PRICES',

1970: ENTITY_MESSAGE_CODE)
1971: VALUES
1972: (p_interface_type,
1973: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
1974: 'PON_BID_ITEM_PRICES',
1975: p_batch_id,
1976: s_interface_line_id,
1977: 'PON_LINEPRICE_MUST_BE_POS',
1978: p_userid,

Line 2037: 'PON_BID_ITEM_PRICES',

2033: ENTITY_MESSAGE_CODE)
2034: VALUES
2035: (p_interface_type,
2036: fnd_message.get_string('PON', 'PON_AUCTION_ITEM_PRICE' || p_suffix),
2037: 'PON_BID_ITEM_PRICES',
2038: p_batch_id,
2039: s_interface_line_id,
2040: 'PON_LINEPRICE_MIN_PREC' || p_suffix,
2041: p_userid,

Line 2096: 'PON_BID_ITEM_PRICES',

2092: ENTITY_MESSAGE_CODE)
2093: VALUES
2094: (p_interface_type,
2095: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2096: 'PON_BID_ITEM_PRICES',
2097: p_batch_id,
2098: s_interface_line_id,
2099: 'PON_BID_PRICE_REQUIRED' || p_suffix,
2100: p_userid,

Line 2156: , pon_bid_item_prices bl

2152: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
2153: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
2154: al.line_num_display s_clm_line_num_display
2155: FROM pon_auction_item_prices_all al
2156: , pon_bid_item_prices bl
2157: , pon_bid_headers pbh
2158: WHERE al.auction_header_id = p_auc_header_id
2159: AND bl.bid_number = p_bid_number
2160: AND al.line_number = bl.line_number

Line 2205: 'PON_BID_ITEM_PRICES',

2201: ENTITY_MESSAGE_CODE)
2202: VALUES
2203: (p_interface_type,
2204: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2205: 'PON_BID_ITEM_PRICES',
2206: p_batch_id,
2207: s_interface_line_id,
2208: decode(p_trans_view, 'N',
2209: 'PON_AUC_BIDPRICE_MUST_BE_POS' || p_suffix,

Line 2270: 'PON_BID_ITEM_PRICES',

2266: ENTITY_MESSAGE_CODE)
2267: VALUES
2268: (p_interface_type,
2269: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2270: 'PON_BID_ITEM_PRICES',
2271: p_batch_id,
2272: s_interface_line_id,
2273: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,
2274: p_userid,

Line 2334: 'PON_BID_ITEM_PRICES',

2330: ENTITY_MESSAGE_CODE)
2331: VALUES
2332: (p_interface_type,
2333: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2334: 'PON_BID_ITEM_PRICES',
2335: p_batch_id,
2336: s_interface_line_id,
2337: 'PON_AUCTS_BIDPRICE_MIN_PREC' || p_suffix,
2338: p_userid,

Line 2396: 'PON_BID_ITEM_PRICES',

2392: ENTITY_MESSAGE_CODE)
2393: VALUES
2394: (p_interface_type,
2395: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2396: 'PON_BID_ITEM_PRICES',
2397: p_batch_id,
2398: s_interface_line_id,
2399: 'PON_LINE_BIDPRICE_INVALID_1' || p_suffix,
2400: p_userid,

Line 2458: 'PON_BID_ITEM_PRICES',

2454: decode(p_spreadsheet,
2455: g_xml_upload_mode,
2456: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2457: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2458: 'PON_BID_ITEM_PRICES',
2459: p_batch_id,
2460: s_interface_line_id,
2461: 'PON_AUC_LIMPRICE_MUST_BE_POS',
2462: p_userid,

Line 2520: 'PON_BID_ITEM_PRICES',

2516: decode(p_spreadsheet,
2517: g_xml_upload_mode,
2518: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2519: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2520: 'PON_BID_ITEM_PRICES',
2521: p_batch_id,
2522: s_interface_line_id,
2523: 'PON_AUCTS_LIMIT_MIN_PREC' || p_suffix,
2524: p_userid,

Line 2602: 'PON_BID_ITEM_PRICES',

2598: ENTITY_MESSAGE_CODE)
2599: VALUES
2600: (p_interface_type,
2601: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2602: 'PON_BID_ITEM_PRICES',
2603: p_batch_id,
2604: s_interface_line_id,
2605: 'PON_BP_LTE_BIDSTARTPRICE' || p_suffix,
2606: p_userid,

Line 2683: 'PON_BID_ITEM_PRICES',

2679: )
2680: VALUES
2681: (p_interface_type,
2682: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2683: 'PON_BID_ITEM_PRICES',
2684: p_batch_id,
2685: s_interface_line_id,
2686: 'PON_MIN_BID_DECREMENT' || p_suffix,
2687: p_userid,

Line 2759: 'PON_BID_ITEM_PRICES',

2755: )
2756: VALUES
2757: (p_interface_type,
2758: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2759: 'PON_BID_ITEM_PRICES',
2760: p_batch_id,
2761: s_interface_line_id,
2762: 'PON_MIN_BESTBID_DECREMENT' || p_suffix,
2763: p_userid,

Line 2827: 'PON_BID_ITEM_PRICES',

2823: ENTITY_MESSAGE_CODE)
2824: VALUES
2825: (p_interface_type,
2826: fnd_message.get_string('PON', 'PON_AUCTS_BID_PRICE' || p_suffix),
2827: 'PON_BID_ITEM_PRICES',
2828: p_batch_id,
2829: s_interface_line_id,
2830: decode(p_bid_decr_method,'BEST_PRICE','PON_BESTBID_PRICE_LOWER','PON_BID_PRICE_LOWER') || p_suffix,
2831: p_userid,

Line 2894: 'PON_BID_ITEM_PRICES',

2890: decode(p_spreadsheet,
2891: g_xml_upload_mode,
2892: fnd_message.get_string('PON', 'PON_AUCTS_PROXY_MIN'),
2893: fnd_message.get_string('PON', 'PON_AUCTS_MIN_BID_PRICE')),
2894: 'PON_BID_ITEM_PRICES',
2895: p_batch_id,
2896: s_interface_line_id,
2897: 'PON_AUCTS_LIMIT_MIN_LESS_PRI' || p_suffix,
2898: p_userid,

Line 2944: 'PON_BID_ITEM_PRICES',

2940: WORKSHEET_SEQUENCE_NUMBER,
2941: ENTITY_MESSAGE_CODE)
2942: VALUES
2943: (p_interface_type,
2944: 'PON_BID_ITEM_PRICES',
2945: p_batch_id,
2946: s_interface_line_id,
2947: 'PON_CANNOT_UNBID' || p_suffix,
2948: p_userid,

Line 3000: 'PON_BID_ITEM_PRICES',

2996: WORKSHEET_SEQUENCE_NUMBER,
2997: ENTITY_MESSAGE_CODE)
2998: VALUES
2999: (p_interface_type,
3000: 'PON_BID_ITEM_PRICES',
3001: p_batch_id,
3002: s_interface_line_id,
3003: 'PON_AUC_BAD_PBTYPE_GLOBAL',
3004: p_userid,

Line 3063: 'PON_BID_ITEM_PRICES',

3059: WORKSHEET_SEQUENCE_NUMBER,
3060: ENTITY_MESSAGE_CODE)
3061: VALUES
3062: (p_interface_type,
3063: 'PON_BID_ITEM_PRICES',
3064: p_batch_id,
3065: s_interface_line_id,
3066: 'PON_AUC_BAD_PBTYPE_SHIPS',
3067: p_userid,

Line 3128: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,

3124: bh.number_price_decimals s_precision,
3125: al.line_num_display s_clm_line_num_display,
3126: nvl(bl.clm_cost_constraint,'X') s_clm_cost_constraint, -- CLM QA Bug : 9835426
3127: al.order_type_lookup_code s_order_type_lookup_code --For clm bug : 10136754
3128: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl,
3129: pon_bid_headers bh
3130: WHERE al.auction_header_id = p_auc_header_id
3131: AND bh.bid_number = p_bid_number
3132: AND bl.bid_number = p_bid_number

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

3156: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3157: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3158: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3159: VALUES
3160: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3161: p_batch_id, s_interface_line_id, 'PON_RTNG_RATE_WRONG_L', --2
3162: p_userid, sysdate, p_userid, --3
3163: sysdate, p_request_id, 'BID_ITEMS', --4
3164: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

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

3182: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3183: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3184: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3185: VALUES
3186: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
3187: p_batch_id, s_interface_line_id, 'PON_MAX_RTNG_WRONG_L', --2
3188: p_userid, sysdate, p_userid, --3
3189: sysdate, p_request_id, 'BID_ITEMS', --4
3190: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

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

3208: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3209: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3210: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3211: VALUES
3212: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3213: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_WRONG_L', --2
3214: p_userid, sysdate, p_userid, --3
3215: sysdate, p_request_id, 'BID_ITEMS', --4
3216: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

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

3235: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3236: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3237: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3238: VALUES
3239: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3240: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_RATE_WRONG_L', --2
3241: p_userid, sysdate, p_userid, --3
3242: sysdate, p_request_id, 'BID_ITEMS', --4
3243: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

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

3262: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3263: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3264: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3265: VALUES
3266: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3267: p_batch_id, s_interface_line_id, 'PON_RECOUP_RATE_WRONG', --2
3268: p_userid, sysdate, p_userid, --3
3269: sysdate, p_request_id, 'BID_ITEMS', --4
3270: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

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

3290: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3291: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
3292: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3293: VALUES
3294: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3295: p_batch_id, s_interface_line_id, 'PON_PROG_PYMT_NEEDED_L', --2
3296: p_userid, sysdate, p_userid, --3
3297: sysdate, p_request_id, 'BID_ITEMS', --4
3298: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'TXT', --5

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

3320: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3321: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3322: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3323: VALUES
3324: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3325: p_batch_id, s_interface_line_id, 'PON_RETAINAGE_NEEDED_L', --2
3326: p_userid, sysdate, p_userid, --3
3327: sysdate, p_request_id, 'BID_ITEMS', --4
3328: 'RetainageRatePercent', retainage_rate_percent, 'TXT', --5

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

3350: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3351: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
3352: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3353: VALUES
3354: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
3355: p_batch_id, s_interface_line_id, 'PON_MAX_RETAINAGE_NEEDED_L', --2
3356: p_userid, sysdate, p_userid, --3
3357: sysdate, p_request_id, 'BID_ITEMS', --4
3358: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'TXT', --5

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

3383: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3384: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3385: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3386: VALUES
3387: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3388: p_batch_id, s_interface_line_id, 'PON_RECUP_RATE_NEEDED_L', --2
3389: p_userid, sysdate, p_userid, --3
3390: sysdate, p_request_id, 'BID_ITEMS', --4
3391: 'RecoupmentRatePercent', recoupment_rate_percent, 'TXT', --5

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

3414: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3415: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3416: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3417: VALUES
3418: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3419: p_batch_id, s_interface_line_id, 'PON_ADVANCE_AMT_NEEDED_L', --2
3420: p_userid, sysdate, p_userid, --3
3421: sysdate, p_request_id, 'BID_ITEMS', --4
3422: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'TXT', --5

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

3454: decode(p_spreadsheet, g_xml_upload_mode, bl.worksheet_sequence_number, to_number(null)) s_worksheet_sequence_number,
3455: decode(p_spreadsheet, g_xml_upload_mode, 'PON_AUC_ITEMS', to_char(null)) s_entity_message_code,
3456: al.line_num_display s_clm_line_num_display,
3457: Nvl(al.clm_info_flag, 'N') s_clm_info_flag
3458: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3459: WHERE al.auction_header_id = p_auc_header_id
3460: AND bl.bid_number = p_bid_number
3461: AND pah.auction_header_id = p_auc_header_id
3462: AND al.line_number = bl.line_number

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

3483: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3484: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE, --7
3485: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3486: VALUES
3487: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3488: p_batch_id, s_interface_line_id, 'PON_ADV_AMT_MORE_L', --2
3489: p_userid, sysdate, p_userid, --3
3490: sysdate, p_request_id, 'BID_ITEMS', --4
3491: NULL, bid_curr_advance_amount, 'NUM', --5

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

3516: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3517: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
3518: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3519: VALUES
3520: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3521: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_PYMT_L', --2
3522: p_userid, sysdate, p_userid, --3
3523: sysdate, p_request_id, 'BID_ITEMS', --4
3524: NULL, recoupment_rate_percent, 'NUM', --5

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

3545: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3546: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,--7
3547: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3548: VALUES
3549: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3550: p_batch_id, s_interface_line_id, 'PON_RECOUP_LESS_THAN_ADV_L', --2
3551: p_userid, sysdate, p_userid, --3
3552: sysdate, p_request_id, 'BID_ITEMS', --4
3553: NULL, recoupment_rate_percent, 'NUM', --5

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

3577: TOKEN2_NAME, TOKEN2_VALUE,
3578: TOKEN3_NAME, TOKEN3_VALUE,
3579: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3580: VALUES
3581: (p_interface_type, NULL, 'PON_BID_ITEM_PRICES', --1
3582: p_batch_id, s_interface_line_id, 'PON_PYMNT_AMT_MORE_ACTUAL', --2
3583: p_userid, sysdate, p_userid, --3
3584: sysdate, p_request_id, 'BID_ITEMS', --4
3585: NULL, NULL, 'TXT', --5

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

3612: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3613: EXPIRATION_DATE, TOKEN1_NAME, TOKEN1_VALUE,
3614: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --7
3615: VALUES
3616: (p_interface_type, NULL, 'PON_BID_ITEM_PRICES', --1
3617: p_batch_id, s_interface_line_id, 'PON_PYMNT_AMT_MORE_FINANCE', --2
3618: p_userid, sysdate, p_userid, --3
3619: sysdate, p_request_id, 'BID_ITEMS', --4
3620: NULL, NULL, 'TXT', --5

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

3639: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3640: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE,
3641: WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3642: VALUES
3643: (p_interface_type, fnd_message.get_string('PON','PON_ADVANCE_AMOUNT_FLAG'), 'PON_BID_ITEM_PRICES', --1
3644: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
3645: p_userid, sysdate, p_userid, --3
3646: sysdate, p_request_id, 'BID_ITEMS', --4
3647: 'BidCurrAdvanceAmount', bid_curr_advance_amount, 'NUM', --5

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

3667: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3668: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3669: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3670: VALUES
3671: (p_interface_type, fnd_message.get_string('PON','PON_MAX_RETAINAGE_AMOUNT'), 'PON_BID_ITEM_PRICES', --1
3672: p_batch_id, s_interface_line_id, 'PON_LINEAMT_INVALID_PRECISION', --2
3673: p_userid, sysdate, p_userid, --3
3674: sysdate, p_request_id, 'BID_ITEMS', --4
3675: 'BidCurrMaxRetainageAmt', bid_curr_max_retainage_amt, 'NUM', --5

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

3695: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3696: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3697: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3698: VALUES
3699: (p_interface_type, fnd_message.get_string('PON','PON_PROGRESS_PYMT_RATE'), 'PON_BID_ITEM_PRICES', --1
3700: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3701: p_userid, sysdate, p_userid, --3
3702: sysdate, p_request_id, 'BID_ITEMS', --4
3703: 'ProgressPymtRatePercent', progress_pymt_rate_percent, 'NUM', --5

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

3723: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3724: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3725: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME, WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3726: VALUES
3727: (p_interface_type, fnd_message.get_string('PON','PON_RETAINAGE_RATE'), 'PON_BID_ITEM_PRICES', --1
3728: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3729: p_userid, sysdate, p_userid, --3
3730: sysdate, p_request_id, 'BID_ITEMS', --4
3731: 'RetainageRatePercent', retainage_rate_percent, 'NUM', --5

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

3751: AUCTION_HEADER_ID, BID_NUMBER, LINE_NUMBER, --6
3752: BID_PAYMENT_ID, EXPIRATION_DATE, TOKEN1_NAME, --7
3753: TOKEN1_VALUE, TOKEN2_NAME, TOKEN2_VALUE, WORKSHEET_NAME,WORKSHEET_SEQUENCE_NUMBER, ENTITY_MESSAGE_CODE) --8
3754: VALUES
3755: (p_interface_type, fnd_message.get_string('PON','PON_RECOUPMENT_RATE'), 'PON_BID_ITEM_PRICES', --1
3756: p_batch_id, s_interface_line_id, 'PON_INVALID_RATE_PRECISION_L', --2
3757: p_userid, sysdate, p_userid, --3
3758: sysdate, p_request_id, 'BID_ITEMS', --4
3759: 'RecoupmentRatePercent', recoupment_rate_percent, 'NUM', --5

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

3794: FROM pon_bid_payments_shipments pbps
3795: WHERE pbps.auction_header_id = p_auc_header_id
3796: AND pbps.bid_number = p_bid_number
3797: AND pbps.bid_line_number = bl.line_number) s_sum_pymt_amt --bug 14657112
3798: FROM pon_auction_item_prices_all al, pon_bid_item_prices bl, pon_auction_headers_all pah
3799: WHERE al.auction_header_id = p_auc_header_id
3800: AND bl.bid_number = p_bid_number
3801: AND pah.auction_header_id = p_auc_header_id
3802: AND al.line_number = bl.line_number

Line 3810: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

3806: END validate_lines;
3807:
3808: PROCEDURE validate_requirements
3809: (
3810: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3811: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3812: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3813: p_userid IN pon_interface_errors.created_by%TYPE,
3814: p_spreadsheet IN VARCHAR2,

Line 3811: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

3807:
3808: PROCEDURE validate_requirements
3809: (
3810: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3811: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3812: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3813: p_userid IN pon_interface_errors.created_by%TYPE,
3814: p_spreadsheet IN VARCHAR2,
3815: p_suffix IN VARCHAR2,

Line 3994: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

3990:
3991:
3992: PROCEDURE validate_attributes
3993: (
3994: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3995: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3996: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3997: p_userid IN pon_interface_errors.created_by%TYPE,
3998: p_spreadsheet IN VARCHAR2,

Line 3995: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

3991:
3992: PROCEDURE validate_attributes
3993: (
3994: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
3995: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
3996: p_interface_type IN pon_interface_errors.interface_type%TYPE,
3997: p_userid IN pon_interface_errors.created_by%TYPE,
3998: p_spreadsheet IN VARCHAR2,
3999: p_suffix IN VARCHAR2,

Line 4139: , pon_bid_item_prices bl

4135: al.line_num_display s_clm_line_num_display
4136: FROM pon_bid_attribute_values ba
4137: , pon_auction_attributes aa
4138: , pon_auction_item_prices_all al
4139: , pon_bid_item_prices bl
4140: , pon_bid_headers pbh
4141: WHERE ba.bid_number = p_bid_number
4142: AND ba.line_number <> -1
4143: AND aa.auction_header_id = ba.auction_header_id

Line 4159: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

4155: END validate_attributes;
4156:
4157: PROCEDURE validate_cost_factors
4158: (
4159: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4160: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4161: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4162: p_userid IN pon_interface_errors.created_by%TYPE,
4163: p_spreadsheet IN VARCHAR2,

Line 4160: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

4156:
4157: PROCEDURE validate_cost_factors
4158: (
4159: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4160: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4161: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4162: p_userid IN pon_interface_errors.created_by%TYPE,
4163: p_spreadsheet IN VARCHAR2,
4164: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 4496: , pon_bid_item_prices bl

4492: fnd_message.get_string('PON', 'PON_AUC_PE_BID_VALUE_REQ' || p_suffix)) s_column_name,
4493: al.line_num_display s_clm_line_num_display
4494: FROM pon_bid_price_elements bpf
4495: , pon_auction_item_prices_all al
4496: , pon_bid_item_prices bl
4497: , pon_price_element_types_tl pft
4498: , pon_bid_headers pbh
4499: WHERE bpf.bid_number = p_bid_number
4500: AND bpf.pf_type = 'SUPPLIER' -- only validate SUPPLIER cost factors

Line 4516: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

4512: END validate_cost_factors;
4513:
4514: PROCEDURE validate_price_breaks
4515: (
4516: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4517: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4518: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4519: p_userid IN pon_interface_errors.created_by%TYPE,
4520: p_spreadsheet IN VARCHAR2,

Line 4517: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

4513:
4514: PROCEDURE validate_price_breaks
4515: (
4516: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
4517: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
4518: p_interface_type IN pon_interface_errors.interface_type%TYPE,
4519: p_userid IN pon_interface_errors.created_by%TYPE,
4520: p_spreadsheet IN VARCHAR2,
4521: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 5627: , pon_bid_item_prices bl

5623: null
5624: ) s_entity_name,
5625: al.line_num_display s_clm_line_num_display
5626: FROM pon_bid_shipments bpb
5627: , pon_bid_item_prices bl
5628: , pon_auction_item_prices_all al
5629: , pon_bid_headers pbh
5630: WHERE bpb.bid_number = p_bid_number
5631: AND bl.bid_number = bpb.bid_number

Line 5660: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

5656: * =======================================================*/
5657:
5658: PROCEDURE VALIDATE_QTY_BASED_PRICE_TIERS
5659: (
5660: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
5661: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5662: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5663: p_userid IN pon_interface_errors.created_by%TYPE,
5664: p_spreadsheet IN VARCHAR2,

Line 5661: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

5657:
5658: PROCEDURE VALIDATE_QTY_BASED_PRICE_TIERS
5659: (
5660: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
5661: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
5662: p_interface_type IN pon_interface_errors.interface_type%TYPE,
5663: p_userid IN pon_interface_errors.created_by%TYPE,
5664: p_spreadsheet IN VARCHAR2,
5665: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 6374: 'PON_BID_ITEM_PRICES',

6370: ENTITY_MESSAGE_CODE
6371: )
6372: VALUES
6373: (p_interface_type,
6374: 'PON_BID_ITEM_PRICES',
6375: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_MAX_QUANTITY'), null ),
6376: p_batch_id,
6377: s_interface_line_id,
6378: 'PON_BID_QTY_NOT_WITHIN_TIERS',

Line 6437: 'PON_BID_ITEM_PRICES',

6433: ENTITY_MESSAGE_CODE
6434: )
6435: VALUES
6436: (p_interface_type,
6437: 'PON_BID_ITEM_PRICES',
6438: decode(p_spreadsheet, g_xml_upload_mode, fnd_message.get_string('PON', 'PON_BIDS_PRICE'), null ),
6439: p_batch_id,
6440: s_interface_line_id,
6441: 'PON_BID_PRICE_NOT_WITHIN_TIERS',

Line 6483: pon_bid_item_prices bl,

6479: null
6480: ) s_entity_name,
6481: al.line_num_display s_clm_line_num_display
6482: FROM pon_bid_shipments bpb,
6483: pon_bid_item_prices bl,
6484: pon_auction_item_prices_all al,
6485: (SELECT MAX(shipments.max_quantity) max_quantity,
6486: shipments.bid_number,
6487: shipments.line_number

Line 6553: From pon_bid_item_prices bl

6549: bl.line_number,
6550: g_exp_date,
6551: 'LINENUM',
6552: al.document_disp_line_number
6553: From pon_bid_item_prices bl
6554: , pon_auction_item_prices_all al
6555: , pon_bid_headers pbh
6556: where bl.bid_number = p_bid_number
6557: AND al.auction_header_id = bl.auction_header_id

Line 6584: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

6580: END VALIDATE_QTY_BASED_PRICE_TIERS;
6581:
6582: PROCEDURE validate_price_differentials
6583: (
6584: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6585: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6586: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6587: p_userid IN pon_interface_errors.created_by%TYPE,
6588: p_spreadsheet IN VARCHAR2,

Line 6585: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

6581:
6582: PROCEDURE validate_price_differentials
6583: (
6584: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
6585: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
6586: p_interface_type IN pon_interface_errors.interface_type%TYPE,
6587: p_userid IN pon_interface_errors.created_by%TYPE,
6588: p_spreadsheet IN VARCHAR2,
6589: p_suffix IN VARCHAR2,

Line 7006: , pon_bid_item_prices bl

7002: null
7003: ) s_entity_name,
7004: al.line_num_display s_clm_line_num_display
7005: FROM pon_bid_price_differentials bpd
7006: , pon_bid_item_prices bl
7007: , pon_auction_item_prices_all al
7008: , pon_price_differentials apd
7009: , pon_auction_shipments_all apb
7010: , po_price_diff_lookups_v pdl

Line 7036: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7032:
7033:
7034: PROCEDURE validate_payments
7035: (
7036: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7037: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7038: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7039: p_userid IN pon_interface_errors.created_by%TYPE,
7040: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 7037: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7033:
7034: PROCEDURE validate_payments
7035: (
7036: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7037: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7038: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7039: p_userid IN pon_interface_errors.created_by%TYPE,
7040: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
7041: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 7085: 'PON_BID_ITEM_PRICES',

7081: TOKEN2_VALUE)
7082: SELECT
7083: p_interface_type,
7084: fnd_message.get_string('PON','PON_AUCTS_PAYITEM_NUMBER'),
7085: 'PON_BID_ITEM_PRICES',
7086: p_batch_id,
7087: 'PON_PYMT_NUM_NOT_UNQ',
7088: p_userid,
7089: sysdate,

Line 7391: PON_BID_ITEM_PRICES pbi

7387: pbp.bid_payment_id,
7388: pbi.line_number bid_line_number
7389: FROM PON_BID_PAYMENTS_SHIPMENTS pbp,
7390: PON_AUCTION_ITEM_PRICES_ALL pai,
7391: PON_BID_ITEM_PRICES pbi
7392: WHERE pbp.auction_header_id = pai.auction_header_id
7393: AND pbp.auction_line_number = pai.line_number
7394: AND pbi.auction_header_id = pai.auction_header_id
7395: AND pbi.line_number = pai.line_number

Line 7424: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7420: --or 'EEXEMPTED' |
7421: -----------------------------------------------------------------*/
7422: PROCEDURE validate_emd_status
7423: (
7424: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7425: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7426: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7427: p_userid IN pon_interface_errors.created_by%TYPE,
7428: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,

Line 7425: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7421: -----------------------------------------------------------------*/
7422: PROCEDURE validate_emd_status
7423: (
7424: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7425: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7426: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7427: p_userid IN pon_interface_errors.created_by%TYPE,
7428: p_price_precision IN pon_bid_headers.number_price_decimals%TYPE,
7429: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 7512: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7508: -----------------------------------Yao Zhang add end---------------------------------------
7509:
7510: PROCEDURE perform_all_validations
7511: (
7512: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7513: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7514: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7515: p_userid IN pon_interface_errors.created_by%TYPE,
7516: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 7513: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7509:
7510: PROCEDURE perform_all_validations
7511: (
7512: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7513: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7514: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7515: p_userid IN pon_interface_errors.created_by%TYPE,
7516: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7517: p_request_id IN pon_interface_errors.request_id%TYPE,

Line 7966: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7962: END perform_all_validations;
7963:
7964: PROCEDURE validate_bid
7965: (
7966: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7967: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7968: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7969: p_userid IN pon_interface_errors.created_by%TYPE,
7970: p_batch_id IN pon_interface_errors.batch_id%TYPE,

Line 7967: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7963:
7964: PROCEDURE validate_bid
7965: (
7966: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7967: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7968: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7969: p_userid IN pon_interface_errors.created_by%TYPE,
7970: p_batch_id IN pon_interface_errors.batch_id%TYPE,
7971: p_request_id IN pon_interface_errors.request_id%TYPE,

Line 7984: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,

7980: END validate_bid;
7981:
7982: PROCEDURE validate_spreadsheet_upload
7983: (
7984: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7985: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7986: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7987: p_spreadsheet_type IN VARCHAR2,
7988: p_userid IN pon_interface_errors.created_by%TYPE,

Line 7985: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,

7981:
7982: PROCEDURE validate_spreadsheet_upload
7983: (
7984: p_auc_header_id IN pon_bid_item_prices.auction_header_id%TYPE,
7985: p_bid_number IN pon_bid_item_prices.bid_number%TYPE,
7986: p_interface_type IN pon_interface_errors.interface_type%TYPE,
7987: p_spreadsheet_type IN VARCHAR2,
7988: p_userid IN pon_interface_errors.created_by%TYPE,
7989: p_batch_id IN pon_interface_errors.batch_id%TYPE,