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_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUCTION_ITEM_PRICES_ALL

Line 909: PON_AUCTION_ITEM_PRICES_ALL

905: DISPLAY_TARGET_PRICE_FLAG sel_display_target_price_flag,
906: NEED_BY_START_DATE sel_need_by_start_date,
907: NEED_BY_DATE sel_need_by_date
908: FROM
909: PON_AUCTION_ITEM_PRICES_ALL
910: WHERE
911: AUCTION_HEADER_ID = p_auction_header_id;
912:
913:

Line 1177: FROM PON_AUCTION_ITEM_PRICES_ALL

1173: (
1174: sel_group_type IN ('LOT', 'GROUP') AND
1175: NOT EXISTS (
1176: SELECT LINE_NUMBER
1177: FROM PON_AUCTION_ITEM_PRICES_ALL
1178: WHERE
1179: AUCTION_HEADER_ID = p_auction_header_id AND
1180: PARENT_LINE_NUMBER = sel_line_number
1181: )

Line 1492: PON_AUCTION_ITEM_PRICES_ALL

1488: PO_AGREED_AMOUNT sel_po_agreed_amount,
1489: LINE_ORIGINATION_CODE sel_line_origination_code,
1490: SHIP_TO_LOCATION_ID sel_ship_to_location_id
1491: FROM
1492: PON_AUCTION_ITEM_PRICES_ALL
1493: WHERE
1494: AUCTION_HEADER_ID = p_auction_header_id;
1495:
1496: IF (FND_LOG.level_procedure>= FND_LOG.g_current_runtime_level) THEN --{

Line 1897: PON_AUCTION_ITEM_PRICES_ALL PAIP,

1893: PAIP.PO_AGREED_AMOUNT sel_po_agreed_amount,
1894: PAIP.UNIT_TARGET_PRICE sel_unit_target_price,
1895: PAIP.QUANTITY sel_quantity
1896: FROM
1897: PON_AUCTION_ITEM_PRICES_ALL PAIP,
1898: PO_LINE_TYPES_B PLTB
1899: WHERE
1900: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
1901: PLTB.LINE_TYPE_ID = PAIP.LINE_TYPE_ID;

Line 1961: PON_AUCTION_ITEM_PRICES_ALL PAIP,

1957: p_user_id, -- LAST_UPDATED_BY
1958: sysdate, -- LAST_UPDATE_DATE
1959: p_login_id -- LAST_UPDATE_LOGIN
1960: FROM
1961: PON_AUCTION_ITEM_PRICES_ALL PAIP,
1962: PO_LINE_TYPES_B PLTB
1963: WHERE
1964: AUCTION_HEADER_ID = p_auction_header_id AND
1965: PAIP.LINE_TYPE_ID = PLTB.LINE_TYPE_ID AND

Line 2329: PON_AUCTION_ITEM_PRICES_ALL PAIP

2325: PAIP.DOCUMENT_DISP_LINE_NUMBER sel_document_disp_line_number,
2326: PAA.SCORING_TYPE sel_scoring_type
2327: FROM
2328: PON_AUCTION_ATTRIBUTES PAA,
2329: PON_AUCTION_ITEM_PRICES_ALL PAIP
2330: WHERE
2331: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
2332: PAA.AUCTION_HEADER_ID = p_auction_header_id AND
2333: PAIP.LINE_NUMBER = PAA.LINE_NUMBER AND

Line 3064: PON_AUCTION_ITEM_PRICES_ALL PAIP,

3060: PASA.SHIP_TO_LOCATION_ID sel_ship_to_location_id,
3061: PASA.SHIP_TO_ORGANIZATION_ID sel_ship_to_organization_id,
3062: PASA.DIFFERENTIAL_RESPONSE_TYPE sel_differential_response_type
3063: FROM
3064: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3065: PON_AUCTION_SHIPMENTS_ALL PASA
3066: WHERE
3067: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3068: PASA.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3362: PON_AUCTION_ITEM_PRICES_ALL PAIP,

3358: PASA.PRICE sel_price,
3359: PASA.QUANTITY sel_min_quantity,
3360: PASA.MAX_QUANTITY sel_max_quantity
3361: FROM
3362: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3363: PON_AUCTION_SHIPMENTS_ALL PASA
3364: WHERE
3365: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3366: PASA.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3401: FROM pon_auction_item_prices_all paip

3397: sysdate, -- CREATION_DATE
3398: p_user_id, -- LAST_UPDATED_BY
3399: sysdate, -- LAST_UPDATE_DATE
3400: p_login_id -- LAST_UPDATE_LOGIN
3401: FROM pon_auction_item_prices_all paip
3402: WHERE paip.auction_header_id = p_auction_header_id
3403: AND paip.line_number IN
3404: (SELECT DISTINCT pasa.line_number
3405: FROM pon_auction_shipments_all pasa1,

Line 3461: PON_AUCTION_ITEM_PRICES_ALL PAIP

3457: sysdate, -- LAST_UPDATE_DATE
3458: p_login_id -- LAST_UPDATE_LOGIN
3459: FROM
3460: PON_PRICE_DIFFERENTIALS PPD,
3461: PON_AUCTION_ITEM_PRICES_ALL PAIP
3462: WHERE
3463: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
3464: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3465: PPD.LINE_NUMBER = PAIP.LINE_NUMBER AND

Line 3501: PON_AUCTION_ITEM_PRICES_ALL PAIP,

3497: sysdate, -- LAST_UPDATE_DATE
3498: p_login_id -- LAST_UPDATE_LOGIN
3499: FROM
3500: PON_PRICE_DIFFERENTIALS PPD,
3501: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3502: PON_AUCTION_SHIPMENTS_ALL PAS
3503: WHERE
3504: PPD.AUCTION_HEADER_ID = p_auction_header_id AND
3505: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3633: PON_AUCTION_ITEM_PRICES_ALL PAIP,

3629: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc,
3630: PPD.PRICE_TYPE sel_price_type
3631: FROM
3632: PON_PRICE_DIFFERENTIALS PPD,
3633: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3634: PO_PRICE_DIFF_LOOKUPS_V PPDL
3635: WHERE
3636: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND
3637: PPD.AUCTION_HEADER_ID = p_auction_header_id AND

Line 3728: PON_AUCTION_ITEM_PRICES_ALL PAIP,

3724: PPD.PRICE_TYPE sel_price_type,
3725: PPD.SHIPMENT_NUMBER sel_shipment_number,
3726: PPDL.PRICE_DIFFERENTIAL_DESC sel_price_differential_desc
3727: FROM
3728: PON_AUCTION_ITEM_PRICES_ALL PAIP,
3729: PON_AUCTION_SHIPMENTS_ALL PASA,
3730: PON_PRICE_DIFFERENTIALS PPD,
3731: PO_PRICE_DIFF_LOOKUPS_V PPDL
3732: WHERE

Line 4094: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4090: PPE.PRICING_BASIS sel_pricing_basis,
4091: PPET.ENABLED_FLAG sel_enabled_flag,
4092: PPET.SYSTEM_FLAG sel_system_flag
4093: FROM
4094: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4095: PON_PRICE_ELEMENTS PPE,
4096: PON_PRICE_ELEMENT_TYPES_TL PPETL,
4097: PON_PRICE_ELEMENT_TYPES PPET
4098: WHERE

Line 4161: PON_AUCTION_ITEM_PRICES_ALL PAIP,

4157: p_user_id, -- LAST_UPDATED_BY
4158: sysdate, -- LAST_UPDATE_DATE
4159: p_login_id -- LAST_UPDATE_LOGIN
4160: FROM
4161: PON_AUCTION_ITEM_PRICES_ALL PAIP,
4162: PON_PRICE_ELEMENTS PPE,
4163: PON_PRICE_ELEMENT_TYPES_TL PPETL
4164: WHERE
4165: PAIP.AUCTION_HEADER_ID = p_auction_header_id AND

Line 4214: pon_auction_item_prices_all

4210: COUNT(LINE_NUMBER)
4211: INTO
4212: l_major_line_count
4213: FROM
4214: pon_auction_item_prices_all
4215: WHERE
4216: auction_header_id = p_auction_header_id AND
4217: group_type IN ('LOT', 'GROUP', 'LINE');
4218:

Line 4522: PON_AUCTION_ITEM_PRICES_ALL PAIP

4518: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
4519: PAIP.DOCUMENT_DISP_LINE_NUMBER,
4520: PAIP.LINE_NUMBER
4521: FROM
4522: PON_AUCTION_ITEM_PRICES_ALL PAIP
4523: WHERE
4524: PAIP.AUCTION_HEADER_ID = p_auction_header_id;
4525:
4526: INSERT ALL

Line 4640: PON_AUCTION_ITEM_PRICES_ALL PAIP

4636: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
4637: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID
4638: FROM
4639: PON_AUCTION_SHIPMENTS_ALL PSA,
4640: PON_AUCTION_ITEM_PRICES_ALL PAIP
4641: WHERE
4642: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
4643: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
4644: PSA.LINE_NUMBER = PAIP.LINE_NUMBER;

Line 4754: PON_AUCTION_ITEM_PRICES_ALL PAIP

4750: PAIP.ITEM_REVISION SELECTED_ITEM_REVISION,
4751: PAIP.LINE_TYPE_ID SELECTED_LINE_TYPE_ID
4752: FROM
4753: PON_AUCTION_SHIPMENTS_ALL PSA,
4754: PON_AUCTION_ITEM_PRICES_ALL PAIP
4755: WHERE
4756: PSA.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
4757: PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
4758: PSA.LINE_NUMBER = PAIP.LINE_NUMBER;

Line 4820: PON_AUCTION_ITEM_PRICES_ALL PAIP

4816: sysdate, -- LAST_UPDATE_DATE
4817: p_login_id -- LAST_UPDATE_LOGIN
4818: FROM
4819: PO_LINE_TYPES_B PLTB,
4820: PON_AUCTION_ITEM_PRICES_ALL PAIP
4821: WHERE
4822: PAIP.AUCTION_HEADER_ID=p_auction_header_id AND
4823: PLTB.LINE_TYPE_ID= PAIP.LINE_TYPE_ID AND
4824: PLTB.OUTSIDE_OPERATION_FLAG='Y' AND

Line 4854: FROM PON_AUCTION_ITEM_PRICES_ALL

4850: CURSOR l_proj_cursor IS
4851: SELECT line_number, document_disp_line_number,
4852: project_id, project_task_id, project_expenditure_type,
4853: project_exp_organization_id, project_expenditure_item_date
4854: FROM PON_AUCTION_ITEM_PRICES_ALL
4855: WHERE auction_header_id=p_auction_header_id
4856: AND project_id IS NOT NULL
4857: AND project_task_id IS NOT NULL
4858: AND project_expenditure_type IS NOT NULL

Line 4903: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

4899: paip.PURCHASE_BASIS,
4900: paip.ORDER_TYPE_LOOKUP_CODE,
4901: paip.line_number s_line_number,
4902: plt.outside_operation_flag po_outside_operation_flag
4903: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
4904: PO_LINE_TYPES plt
4905: WHERE paip.auction_header_id = p_auction_header_id
4906: AND paip.line_type_id = plt.line_type_id (+)
4907: AND paip.group_type NOT IN ('GROUP','LOT_LINE');

Line 5291: FROM PON_AUCTION_ITEM_PRICES_ALL paip,

5287: paip.ORDER_TYPE_LOOKUP_CODE,
5288: paip.LINE_ORIGINATION_CODE,
5289: paip.has_payments_flag,
5290: plt.outside_operation_flag po_outside_operation_flag
5291: FROM PON_AUCTION_ITEM_PRICES_ALL paip,
5292: PO_LINE_TYPES plt
5293: WHERE paip.auction_header_id = p_auction_header_id
5294: AND paip.line_type_id = plt.line_type_id (+)
5295: AND paip.group_type NOT IN ('GROUP','LOT_LINE');

Line 5331: FROM PON_AUCTION_ITEM_PRICES_ALL paip

5327: paip.AUCTION_HEADER_ID,
5328: paip.LINE_NUMBER s_line_number,
5329: paip.DOCUMENT_DISP_LINE_NUMBER,
5330: paip.WORK_APPROVER_USER_ID
5331: FROM PON_AUCTION_ITEM_PRICES_ALL paip
5332: WHERE paip.auction_header_id = p_auction_header_id
5333: AND paip.WORK_APPROVER_USER_ID IS NOT NULL;
5334:
5335:

Line 5485: FROM PON_AUCTION_ITEM_PRICES_ALL paip

5481: paip.PROJECT_AWARD_ID pai_project_award_id,
5482: paip.PROJECT_EXPENDITURE_TYPE pai_project_exp_type,
5483: paip.PROJECT_EXP_ORGANIZATION_ID pai_project_exp_org_id,
5484: paip.PROJECT_EXPENDITURE_ITEM_DATE pai_project_exp_item_date
5485: FROM PON_AUCTION_ITEM_PRICES_ALL paip
5486: WHERE paip.auction_header_id = p_auction_header_id
5487: AND paip.PROJECT_ID IS NOT NULL
5488: AND paip.PROJECT_TASK_ID IS NOT NULL
5489: AND paip.PROJECT_EXPENDITURE_TYPE IS NOT NULL

Line 5557: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai

5553: sysdate, -- LAST_UPDATE_DATE
5554: p_login_id, -- LAST_UPDATE_LOGIN
5555: p_request_id --REQUEST_ID
5556: FROM
5557: PON_AUC_PAYMENTS_SHIPMENTS paps, PON_AUCTION_ITEM_PRICES_ALL pai
5558: WHERE paps.auction_header_id=pai.auction_header_id
5559: AND paps.line_number = pai.line_number
5560: AND paps.auction_header_id = p_auction_header_id
5561: GROUP BY paps.auction_header_id, paps.line_number,

Line 5597: PON_AUCTION_ITEM_PRICES_ALL paip

5593: paps.project_id, paps.project_task_id, paps.project_expenditure_type,
5594: paps.project_exp_organization_id, paps.project_expenditure_item_date,
5595: paip.line_number, paip.document_disp_line_number
5596: FROM PON_AUC_PAYMENTS_SHIPMENTS paps,
5597: PON_AUCTION_ITEM_PRICES_ALL paip
5598: WHERE paps.auction_header_id=p_auction_header_id
5599: AND paps.project_id IS NOT NULL
5600: AND paps.project_task_id IS NOT NULL
5601: AND paps.project_expenditure_type IS NOT NULL

Line 5957: PON_AUCTION_ITEM_PRICES_ALL pai,

5953: pah.close_bidding_date pah_close_bidding_date,
5954: pah.supplier_enterable_pymt_flag,
5955: pai.line_number s_line_number
5956: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
5957: PON_AUCTION_ITEM_PRICES_ALL pai,
5958: PON_AUCTION_HEADERS_ALL pah
5959: WHERE ppi.auction_header_id = pai.auction_header_id
5960: AND ppi.line_number = pai.line_number
5961: AND pah.auction_header_id = ppi.auction_header_id

Line 6145: PON_AUCTION_ITEM_PRICES_ALL pai,

6141: pai.document_disp_line_number,
6142: ppi.work_approver_user_id,
6143: pai.line_number s_line_number
6144: FROM PON_AUC_PAYMENTS_SHIPMENTS ppi,
6145: PON_AUCTION_ITEM_PRICES_ALL pai,
6146: PON_AUCTION_HEADERS_ALL pah
6147: WHERE ppi.auction_header_id = pai.auction_header_id
6148: AND ppi.line_number = pai.line_number
6149: AND ppi.auction_header_id = p_auction_header_id

Line 6299: PON_AUCTION_ITEM_PRICES_ALL

6295: LINE_NUMBER
6296: INTO
6297: l_line_number
6298: FROM
6299: PON_AUCTION_ITEM_PRICES_ALL
6300: WHERE
6301: AUCTION_HEADER_ID = p_auction_header_id AND
6302: PURCHASE_BASIS = 'TEMP LABOR' AND
6303: ROWNUM = 1;

Line 6319: PON_AUCTION_ITEM_PRICES_ALL PAIP

6315: BEGIN
6316: --HAS_ATTRIBUTES_FLAG, HAS_SHIPMENTS_FLAG, HAS_PRICE_ELEMENTS_FLAG,
6317: --HAS_BUYER_PFS_FLAG, HAS_PRICE_DIFFERENTIALS_FLAG,HAS_QUANTITY_TIERS
6318: UPDATE
6319: PON_AUCTION_ITEM_PRICES_ALL PAIP
6320: SET
6321: HAS_ATTRIBUTES_FLAG = NVL(
6322: (SELECT 'Y'
6323: FROM PON_AUCTION_ATTRIBUTES

Line 6382: FROM PON_AUCTION_ITEM_PRICES_ALL

6378: BEGIN
6379:
6380: SELECT MAX (DISP_LINE_NUMBER)
6381: INTO x_max_disp_line_number
6382: FROM PON_AUCTION_ITEM_PRICES_ALL
6383: WHERE AUCTION_HEADER_ID = p_auction_header_id
6384: AND PARENT_LINE_NUMBER = p_parent_line_number;
6385:
6386: IF (x_max_disp_line_number IS NULL) THEN

Line 6389: FROM PON_AUCTION_ITEM_PRICES_ALL

6385:
6386: IF (x_max_disp_line_number IS NULL) THEN
6387: SELECT DISP_LINE_NUMBER
6388: INTO x_max_disp_line_number
6389: FROM PON_AUCTION_ITEM_PRICES_ALL
6390: WHERE AUCTION_HEADER_ID = p_auction_header_id
6391: AND LINE_NUMBER = p_parent_line_number;
6392: END IF;
6393:

Line 7039: UPDATE pon_auction_item_prices_all paip

7035: module => g_module_prefix || l_module_name,
7036: message => 'Entered procedure = ' || l_module_name);
7037: END IF;
7038:
7039: UPDATE pon_auction_item_prices_all paip
7040: SET
7041: -- the max sub line sequence number is set to the greatest
7042: -- max_sub_line_sequence_number between this round and the
7043: -- previous round

Line 7049: pon_auction_item_prices_all

7045: (
7046: SELECT
7047: NVL (MAX (sub_line_sequence_number),0)
7048: FROM
7049: pon_auction_item_prices_all
7050: WHERE
7051: auction_header_id=p_auction_header_id AND
7052: parent_line_number = paip.line_number AND
7053: group_type IN ('LOT_LINE', 'GROUP_LINE')

Line 7061: UPDATE pon_auction_item_prices_all paip

7057: line_number >= p_curr_from_line_number AND
7058: line_number <= p_curr_to_line_number AND
7059: group_type IN ('LOT', 'GROUP');
7060:
7061: UPDATE pon_auction_item_prices_all paip
7062: SET
7063: close_bidding_date = decode(p_stag_closing_enabled_flag, 'Y', close_bidding_date, p_close_bidding_date),
7064:
7065: -- If the line has any attributes this flag will be Y else N

Line 7199: pon_auction_item_prices_all

7195: order_type_lookup_code,
7196: unit_target_price,
7197: unit_display_target_flag
7198: FROM
7199: pon_auction_item_prices_all
7200: WHERE
7201: auction_header_id = p_auction_header_id AND
7202: (has_price_elements_flag = 'Y' OR has_buyer_pfs_flag = 'Y') AND
7203: line_number >= p_from_line_number AND

Line 7272: pon_auction_item_prices_all paip,

7268: sum(decode(ppe.pricing_basis, 'PER_UNIT', ppsv.value, 0)) unit_price,
7269: sum(decode(ppe.pricing_basis, 'FIXED_AMOUNT', ppsv.value, 0)) fixed_amount,
7270: 1 + sum(decode(ppe.pricing_basis, 'PERCENTAGE', ppsv.value/100, 0)) percentage
7271: from
7272: pon_auction_item_prices_all paip,
7273: pon_bidding_parties pbp,
7274: pon_pf_supplier_values ppsv,
7275: pon_price_elements ppe
7276: where

Line 7541: FROM pon_auction_item_prices_all

7537: l_batch_size := PON_LARGE_AUCTION_UTIL_PKG.BATCH_SIZE;
7538:
7539: SELECT NVL (MAX (line_number), 0)
7540: INTO l_max_line_number
7541: FROM pon_auction_item_prices_all
7542: WHERE auction_header_id = p_auction_header_id;
7543:
7544: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
7545: FND_LOG.string (log_level => FND_LOG.level_procedure,

Line 7733: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP

7729:
7730: BEGIN
7731: SELECT 'N'
7732: INTO l_has_pe_for_all_items
7733: FROM PON_AUCTION_ITEM_PRICES_ALL PAIP
7734: WHERE PAIP.AUCTION_HEADER_ID = P_AUCTION_HEADER_ID AND
7735: HAS_PRICE_ELEMENTS_FLAG = 'N' AND
7736: HAS_BUYER_PFS_FLAG = 'N' AND
7737: ROWNUM = 1;

Line 7764: PON_AUCTION_ITEM_PRICES_ALL PAIP

7760: MAX_INTERNAL_LINE_NUM = GREATEST (NVL (PAHA.MAX_INTERNAL_LINE_NUM,0),
7761: (SELECT
7762: MAX(PAIP.LINE_NUMBER)
7763: FROM
7764: PON_AUCTION_ITEM_PRICES_ALL PAIP
7765: WHERE
7766: PAIP.AUCTION_HEADER_ID = p_auction_header_id)),
7767: MAX_DOCUMENT_LINE_NUM = GREATEST (NVL (PAHA.MAX_DOCUMENT_LINE_NUM,0),
7768: (SELECT

Line 7771: PON_AUCTION_ITEM_PRICES_ALL PAIP

7767: MAX_DOCUMENT_LINE_NUM = GREATEST (NVL (PAHA.MAX_DOCUMENT_LINE_NUM,0),
7768: (SELECT
7769: MAX(PAIP.SUB_LINE_SEQUENCE_NUMBER)
7770: FROM
7771: PON_AUCTION_ITEM_PRICES_ALL PAIP
7772: WHERE
7773: PAIP.GROUP_TYPE IN ('LOT', 'GROUP', 'LINE')
7774: AND PAIP.AUCTION_HEADER_ID = p_auction_header_id))
7775: WHERE

Line 7835: FROM pon_auction_item_prices_all

7831: WHERE auction_header_id = p_auction_header_id;
7832:
7833: SELECT NVL (MAX (line_number), 0)
7834: INTO l_max_line_number
7835: FROM pon_auction_item_prices_all
7836: WHERE auction_header_id = p_auction_header_id;
7837:
7838: -- clean up from any previous failures
7839: