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_RESPONSE_IMPORT_PKG dependencies on PON_BID_VALIDATIONS_PKG

Line 1021: bl.worksheet_name = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_name,to_char(null)),

1017: bl.retainage_rate_percent = DECODE(bli.retainage_negotiable_flag,'Y',bli.retainage_rate_percent,bl.retainage_rate_percent),
1018: bl.bid_curr_max_retainage_amt = DECODE(bli.max_retainage_negotiable_flag,'Y',bli.bid_curr_max_retainage_amt,bl.bid_curr_max_retainage_amt),
1019: bl.last_update_date = sysdate,
1020: bl.last_updated_by = p_userid,
1021: bl.worksheet_name = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_name,to_char(null)),
1022: bl.worksheet_sequence_number = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_sequence_number,to_number(null));
1023:
1024: -- When a GROUP's child recieved a bid, we mark that group as part of the batch
1025: UPDATE pon_bid_item_prices bl

Line 1022: bl.worksheet_sequence_number = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_sequence_number,to_number(null));

1018: bl.bid_curr_max_retainage_amt = DECODE(bli.max_retainage_negotiable_flag,'Y',bli.bid_curr_max_retainage_amt,bl.bid_curr_max_retainage_amt),
1019: bl.last_update_date = sysdate,
1020: bl.last_updated_by = p_userid,
1021: bl.worksheet_name = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_name,to_char(null)),
1022: bl.worksheet_sequence_number = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_sequence_number,to_number(null));
1023:
1024: -- When a GROUP's child recieved a bid, we mark that group as part of the batch
1025: UPDATE pon_bid_item_prices bl
1026: SET batch_id = p_batch_id

Line 1074: IF (p_mas = 'Y' and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN

1070: ba.last_updated_by = p_userid;
1071:
1072: -- For MAS, quantity or promised date are scored, they need to
1073: -- be updated in the bid attributes transaction table
1074: IF (p_mas = 'Y' and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN
1075: -- Update promised_date
1076: UPDATE pon_bid_attribute_values ba
1077: SET value =
1078: nvl((SELECT to_char(bl.promised_date, 'dd-mm-yyyy hh24:mi:ss')

Line 1152: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN

1148: END IF;
1149:
1150: IF (p_blanket = 'Y') THEN
1151:
1152: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1153: -- Copy over all Line level price differentials to transaction table
1154: MERGE INTO pon_bid_price_differentials bpd
1155: USING
1156: (SELECT

Line 1246: IF (p_price_tiers_indicator = g_pt_indicator_quantitybased and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode) THEN

1242:
1243:
1244: END IF;
1245:
1246: IF (p_price_tiers_indicator = g_pt_indicator_quantitybased and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode) THEN
1247: copy_shipment_interface_to_txn(
1248: p_batch_id=>p_batch_id,
1249: p_bid_number=>p_bid_number,
1250: p_userid =>p_userid,

Line 1256: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN

1252: p_shipment_type => g_shipment_type_quantitybased
1253: );
1254: END IF;
1255:
1256: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1257: --Update bid header table with Xml Spreadsheet header info
1258: BEGIN
1259: UPDATE PON_BID_HEADERS pbh
1260: SET (pbh.SURROG_BID_RECEIPT_DATE,

Line 1280: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

1276:
1277: -- Copy payments to transaction tables
1278: IF p_progress_payment_type <> 'NONE' THEN
1279: PON_VALIDATE_PAYMENTS_INT.COPY_PAYMENTS_FROM_INT_TO_TXN(p_batch_id,
1280: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,
1281: p_bid_number,
1282: p_auction_header_id,
1283: l_result,
1284: l_error_code,

Line 1499: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload

1495: -- NOTE: group amount is only calculated at the time of publish
1496: -- PON_RESPONSE_PVT.calculate_group_amounts(p_bid_number, l_supplier_user, 'N', p_batch_id);
1497:
1498: -- Validate the data once it has been copied to the transaction tables
1499: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
1500: (l_auc_header_id,
1501: p_bid_number,
1502: 'BIDBYSPREADSHEET',
1503: PON_BID_VALIDATIONS_PKG.g_txt_upload_mode,

Line 1503: PON_BID_VALIDATIONS_PKG.g_txt_upload_mode,

1499: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
1500: (l_auc_header_id,
1501: p_bid_number,
1502: 'BIDBYSPREADSHEET',
1503: PON_BID_VALIDATIONS_PKG.g_txt_upload_mode,
1504: p_userid,
1505: p_batch_id,
1506: p_request_id,
1507: x_return_status,

Line 1543: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(

1539: INSERT ALL
1540: --1
1541: WHEN s_min_bid_change IS NOT NULL
1542: AND s_min_bid_change_type <> 'PERCENTAGE'
1543: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(
1544: s_min_bid_change, s_bid_price_precision) = 'F' THEN
1545: INTO pon_interface_errors
1546: (INTERFACE_TYPE,
1547: COLUMN_NAME,

Line 2006: PON_VALIDATE_PAYMENTS_INT.VALIDATE_RESPONSE(PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, p_batch_Id, p_bid_number, p_auction_header_id, p_request_id);

2002:
2003:
2004: --Validate payments fields
2005: IF p_progress_payment_type <> 'NONE' THEN
2006: PON_VALIDATE_PAYMENTS_INT.VALIDATE_RESPONSE(PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, p_batch_Id, p_bid_number, p_auction_header_id, p_request_id);
2007: END IF;
2008:
2009: IF (l_attr_enabled_flag = 'Y') THEN
2010:

Line 3154: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

3150: l_header_disp_pf,
3151: l_blanket,
3152: l_mas,
3153: l_progress_payment_type,
3154: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,
3155: l_price_precision,
3156: l_price_tiers_indicator);
3157:
3158:

Line 3168: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload

3164: PON_RESPONSE_PVT.calculate_group_amounts(p_bid_number, l_supplier_user, 'N', p_batch_id);
3165:
3166:
3167: -- Validate the data once it has been copied to the transaction tables
3168: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
3169: (l_auc_header_id,
3170: p_bid_number,
3171: 'BIDBYSPREADSHEET',
3172: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

Line 3172: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

3168: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
3169: (l_auc_header_id,
3170: p_bid_number,
3171: 'BIDBYSPREADSHEET',
3172: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,
3173: p_user_id,
3174: p_batch_id,
3175: p_request_id,
3176: x_return_status,