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 1220: bl.worksheet_name = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_name,to_char(null)),

1216: bl.retainage_rate_percent = DECODE(bli.retainage_negotiable_flag,'Y',bli.retainage_rate_percent,bl.retainage_rate_percent),
1217: 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),
1218: bl.last_update_date = sysdate,
1219: bl.last_updated_by = p_userid,
1220: bl.worksheet_name = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_name,to_char(null)),
1221: bl.worksheet_sequence_number = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_sequence_number,to_number(null));
1222:
1223: -- When a GROUP's child recieved a bid, we mark that group as part of the batch
1224: UPDATE pon_bid_item_prices bl

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

1217: 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),
1218: bl.last_update_date = sysdate,
1219: bl.last_updated_by = p_userid,
1220: bl.worksheet_name = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_name,to_char(null)),
1221: bl.worksheet_sequence_number = decode(p_spreadsheet_type, PON_BID_VALIDATIONS_PKG.g_xml_upload_mode, bli.worksheet_sequence_number,to_number(null));
1222:
1223: -- When a GROUP's child recieved a bid, we mark that group as part of the batch
1224: UPDATE pon_bid_item_prices bl
1225: SET batch_id = p_batch_id

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

1269: ba.last_updated_by = p_userid;
1270:
1271: -- For MAS, quantity or promised date are scored, they need to
1272: -- be updated in the bid attributes transaction table
1273: IF (p_mas = 'Y' and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_txt_upload_mode) THEN
1274: -- Update promised_date
1275: UPDATE pon_bid_attribute_values ba
1276: SET value =
1277: nvl((SELECT to_char(bl.promised_date, 'dd-mm-yyyy hh24:mi:ss')

Line 1351: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN

1347: END IF;
1348:
1349: IF (p_blanket = 'Y') THEN
1350:
1351: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1352: -- Copy over all Line level price differentials to transaction table
1353: MERGE INTO pon_bid_price_differentials bpd
1354: USING
1355: (SELECT

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

1441:
1442:
1443: END IF;
1444:
1445: IF (p_price_tiers_indicator = g_pt_indicator_quantitybased and p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode) THEN
1446: copy_shipment_interface_to_txn(
1447: p_batch_id=>p_batch_id,
1448: p_bid_number=>p_bid_number,
1449: p_userid =>p_userid,

Line 1455: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN

1451: p_shipment_type => g_shipment_type_quantitybased
1452: );
1453: END IF;
1454:
1455: IF p_spreadsheet_type = PON_BID_VALIDATIONS_PKG.g_xml_upload_mode THEN
1456: --Update bid header table with Xml Spreadsheet header info
1457: BEGIN
1458: UPDATE PON_BID_HEADERS pbh
1459: SET (pbh.SURROG_BID_RECEIPT_DATE,

Line 1479: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

1475:
1476: -- Copy payments to transaction tables
1477: IF p_progress_payment_type <> 'NONE' THEN
1478: PON_VALIDATE_PAYMENTS_INT.COPY_PAYMENTS_FROM_INT_TO_TXN(p_batch_id,
1479: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,
1480: p_bid_number,
1481: p_auction_header_id,
1482: l_result,
1483: l_error_code,

Line 1712: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload

1708: -- NOTE: group amount is only calculated at the time of publish
1709: -- PON_RESPONSE_PVT.calculate_group_amounts(p_bid_number, l_supplier_user, 'N', p_batch_id);
1710:
1711: -- Validate the data once it has been copied to the transaction tables
1712: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
1713: (l_auc_header_id,
1714: p_bid_number,
1715: 'BIDBYSPREADSHEET',
1716: PON_BID_VALIDATIONS_PKG.g_txt_upload_mode,

Line 1716: PON_BID_VALIDATIONS_PKG.g_txt_upload_mode,

1712: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
1713: (l_auc_header_id,
1714: p_bid_number,
1715: 'BIDBYSPREADSHEET',
1716: PON_BID_VALIDATIONS_PKG.g_txt_upload_mode,
1717: p_userid,
1718: p_batch_id,
1719: p_request_id,
1720: x_return_status,

Line 1756: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(

1752: INSERT ALL
1753: --1
1754: WHEN s_min_bid_change IS NOT NULL
1755: AND s_min_bid_change_type <> 'PERCENTAGE'
1756: AND PON_BID_VALIDATIONS_PKG.validate_price_precision(
1757: s_min_bid_change, s_bid_price_precision) = 'F' THEN
1758: INTO pon_interface_errors
1759: (INTERFACE_TYPE,
1760: COLUMN_NAME,

Line 2219: 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);

2215:
2216:
2217: --Validate payments fields
2218: IF p_progress_payment_type <> 'NONE' THEN
2219: 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);
2220: END IF;
2221:
2222: IF (l_attr_enabled_flag = 'Y') THEN
2223:

Line 3367: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

3363: l_header_disp_pf,
3364: l_blanket,
3365: l_mas,
3366: l_progress_payment_type,
3367: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,
3368: l_price_precision,
3369: l_price_tiers_indicator);
3370:
3371:

Line 3381: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload

3377: PON_RESPONSE_PVT.calculate_group_amounts(p_bid_number, l_supplier_user, 'N', p_batch_id);
3378:
3379:
3380: -- Validate the data once it has been copied to the transaction tables
3381: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
3382: (l_auc_header_id,
3383: p_bid_number,
3384: 'BIDBYSPREADSHEET',
3385: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

Line 3385: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,

3381: PON_BID_VALIDATIONS_PKG.validate_spreadsheet_upload
3382: (l_auc_header_id,
3383: p_bid_number,
3384: 'BIDBYSPREADSHEET',
3385: PON_BID_VALIDATIONS_PKG.g_xml_upload_mode,
3386: p_user_id,
3387: p_batch_id,
3388: p_request_id,
3389: x_return_status,