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.CSD_MIGRATE_FROM_115X_PKG3 dependencies on CSD_REPAIR_ESTIMATE

Line 27: -- csd_repair_estimate_lines_v since the view only has lines of

23:
24: CURSOR get_act_hdr(p_start_rep_line_id number, p_end_rep_line_id number)
25: IS
26: -- gilam: changed the EXISTS query part so that the lines are not getting from
27: -- csd_repair_estimate_lines_v since the view only has lines of
28: -- charge line type = ESTIMATE, but we want lines that have type ACTUAL
29: SELECT distinct cr.repair_line_id repair_line_id
30: FROM csd_repairs cr
31: , csd_repair_estimate cre

Line 31: , csd_repair_estimate cre

27: -- csd_repair_estimate_lines_v since the view only has lines of
28: -- charge line type = ESTIMATE, but we want lines that have type ACTUAL
29: SELECT distinct cr.repair_line_id repair_line_id
30: FROM csd_repairs cr
31: , csd_repair_estimate cre
32: WHERE cr.repair_line_id = cre.repair_line_id
33: AND EXISTS ( SELECT 'x'
34: FROM csd_repair_estimate_lines crel, cs_estimate_details ced
35: WHERE cre.repair_estimate_id = crel.repair_estimate_id

Line 34: FROM csd_repair_estimate_lines crel, cs_estimate_details ced

30: FROM csd_repairs cr
31: , csd_repair_estimate cre
32: WHERE cr.repair_line_id = cre.repair_line_id
33: AND EXISTS ( SELECT 'x'
34: FROM csd_repair_estimate_lines crel, cs_estimate_details ced
35: WHERE cre.repair_estimate_id = crel.repair_estimate_id
36: AND crel.estimate_detail_id = ced.estimate_detail_id
37: AND ced.order_line_id is not null)
38: AND NOT EXISTS ( SELECT 'x'

Line 173: , csd_repair_estimate_lines cr

169: CURSOR get_est_lines(p_start_est_det_id number, p_end_est_det_id number)
170: IS
171: SELECT ced.estimate_detail_id
172: FROM cs_estimate_details ced
173: , csd_repair_estimate_lines cr
174: WHERE cr.estimate_detail_id = ced.estimate_detail_id
175: AND ced.charge_line_type = 'ACTUAL'
176: AND ced.order_line_id is null
177: AND ced.original_source_code = 'DR'

Line 191: , csd_repair_estimate cre

187: IS
188: SELECT ced.estimate_detail_id
189: FROM cs_estimate_details ced
190: , csd_repairs cr
191: , csd_repair_estimate cre
192: , csd_repair_estimate_lines crel
193: WHERE cr.repair_line_id = cre.repair_line_id
194: AND cre.repair_estimate_id = crel.repair_estimate_id
195: AND crel.estimate_detail_id = ced.estimate_detail_id

Line 192: , csd_repair_estimate_lines crel

188: SELECT ced.estimate_detail_id
189: FROM cs_estimate_details ced
190: , csd_repairs cr
191: , csd_repair_estimate cre
192: , csd_repair_estimate_lines crel
193: WHERE cr.repair_line_id = cre.repair_line_id
194: AND cre.repair_estimate_id = crel.repair_estimate_id
195: AND crel.estimate_detail_id = ced.estimate_detail_id
196: AND ced.charge_line_type = 'ACTUAL'

Line 271: VALUES ('CSD_REPAIR_ESTIMATE_LINES',

267: ORIG_SYSTEM_REFERENCE_ID,
268: UPGRADE_DATETIME,
269: ERROR_MESSAGE,
270: MIGRATION_PHASE)
271: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
272: 'CS_ESTIMATE_DETAILS',
273: est_lines_arr(j),
274: sysdate,
275: v_error_text,

Line 296: /* procedure name: CSD_REPAIR_ESTIMATE_LINES_MIG3 */

292: COMMIT;
293: END csd_charge_estimate_lines_mig3;
294:
295: /*-------------------------------------------------------------------------------*/
296: /* procedure name: CSD_REPAIR_ESTIMATE_LINES_MIG3 */
297: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */
298: /* table from 11.5.9 to 11.5.10 */
299: /* purpose : Mandatory Step for all CSD_REPAIR_ESTIMATE_LINES records */
300: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/

Line 299: /* purpose : Mandatory Step for all CSD_REPAIR_ESTIMATE_LINES records */

295: /*-------------------------------------------------------------------------------*/
296: /* procedure name: CSD_REPAIR_ESTIMATE_LINES_MIG3 */
297: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */
298: /* table from 11.5.9 to 11.5.10 */
299: /* purpose : Mandatory Step for all CSD_REPAIR_ESTIMATE_LINES records */
300: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/
301: /* New Cols Added : EST_LINE_SOURCE_TYPE_CODE = 'MANUAL' */
302: /* , EST_LINE_SOURCE_ID1 = NULL */
303: /* , EST_LINE_SOURCE_ID2 = NULL */

Line 300: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/

296: /* procedure name: CSD_REPAIR_ESTIMATE_LINES_MIG3 */
297: /* description : procedure for migrating ESTIMATES data in CS_ESTIMATE_DETAILS */
298: /* table from 11.5.9 to 11.5.10 */
299: /* purpose : Mandatory Step for all CSD_REPAIR_ESTIMATE_LINES records */
300: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/
301: /* New Cols Added : EST_LINE_SOURCE_TYPE_CODE = 'MANUAL' */
302: /* , EST_LINE_SOURCE_ID1 = NULL */
303: /* , EST_LINE_SOURCE_ID2 = NULL */
304: /* , RO_SERVICE_CODE_ID = NULL */

Line 308: PROCEDURE csd_repair_estimate_lines_mig3(p_slab_number IN NUMBER DEFAULT 1)

304: /* , RO_SERVICE_CODE_ID = NULL */
305: /* */
306: /*-------------------------------------------------------------------------------*/
307:
308: PROCEDURE csd_repair_estimate_lines_mig3(p_slab_number IN NUMBER DEFAULT 1)
309: IS
310:
311: TYPE REP_EST_LINES_REC_ARRAY_TYPE IS VARRAY(1000) OF NUMBER;
312: rep_est_lines_arr REP_EST_LINES_REC_ARRAY_TYPE;

Line 324: FROM csd_repair_estimate_lines cr

320: /*
321: CURSOR get_rep_est_lines(p_start_rep_est_lin_id number, p_end_rep_est_lin_id number)
322: IS
323: SELECT cr.repair_estimate_line_id
324: FROM csd_repair_estimate_lines cr
325: WHERE cr.est_line_source_type_code is null
326: AND cr.repair_estimate_line_id >= p_start_rep_est_lin_id
327: AND cr.repair_estimate_line_id <= p_end_rep_est_lin_id;
328: */

Line 334: , csd_repair_estimate cre

330: CURSOR get_rep_est_lines(p_start_rep_line_id number, p_end_rep_line_id number)
331: IS
332: SELECT crel.repair_estimate_line_id
333: FROM csd_repairs cr
334: , csd_repair_estimate cre
335: , csd_repair_estimate_lines crel
336: WHERE cr.repair_line_id = cre.repair_line_id
337: AND cre.repair_estimate_id = crel.repair_estimate_id
338: AND crel.est_line_source_type_code is null

Line 335: , csd_repair_estimate_lines crel

331: IS
332: SELECT crel.repair_estimate_line_id
333: FROM csd_repairs cr
334: , csd_repair_estimate cre
335: , csd_repair_estimate_lines crel
336: WHERE cr.repair_line_id = cre.repair_line_id
337: AND cre.repair_estimate_id = crel.repair_estimate_id
338: AND crel.est_line_source_type_code is null
339: AND cr.repair_line_id >= p_start_rep_line_id

Line 351: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_ESTIMATE_LINES',

347: BEGIN
348:
349: -- gilam: bug 3410383 - changed slab table to csd_repairs
350: /*
351: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_ESTIMATE_LINES',
352: 'CSD',
353: p_slab_number,
354: v_min,
355: v_max);

Line 384: UPDATE CSD_REPAIR_ESTIMATE_LINES

380: SAVEPOINT CSD_ESTIMATE_LINES;
381:
382: BEGIN
383:
384: UPDATE CSD_REPAIR_ESTIMATE_LINES
385: SET EST_LINE_SOURCE_TYPE_CODE = 'MANUAL'
386: , EST_LINE_SOURCE_ID1 = NULL
387: , EST_LINE_SOURCE_ID2 = NULL
388: , RO_SERVICE_CODE_ID = NULL

Line 410: VALUES ('CSD_REPAIR_ESTIMATE_LINES',

406: ORIG_SYSTEM_REFERENCE_ID,
407: UPGRADE_DATETIME,
408: ERROR_MESSAGE,
409: MIGRATION_PHASE)
410: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
411: 'CSD_REPAIR_ESTIMATE_LINES',
412: rep_est_lines_arr(j),
413: sysdate,
414: v_error_text,

Line 411: 'CSD_REPAIR_ESTIMATE_LINES',

407: UPGRADE_DATETIME,
408: ERROR_MESSAGE,
409: MIGRATION_PHASE)
410: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
411: 'CSD_REPAIR_ESTIMATE_LINES',
412: rep_est_lines_arr(j),
413: sysdate,
414: v_error_text,
415: '11.5.10');

Line 418: raise_application_error( -20000, 'Error while migrating ESTIMATES data in CS_ESTIMATE_DETAILS: Error while Updating CSD_REPAIR_ESTIMATE_LINES. '|| v_error_text);

414: v_error_text,
415: '11.5.10');
416: commit;
417:
418: raise_application_error( -20000, 'Error while migrating ESTIMATES data in CS_ESTIMATE_DETAILS: Error while Updating CSD_REPAIR_ESTIMATE_LINES. '|| v_error_text);
419:
420: END;
421: END LOOP;
422: COMMIT;

Line 431: END csd_repair_estimate_lines_mig3;

427: THEN
428: CLOSE get_rep_est_lines;
429: END IF;
430: COMMIT;
431: END csd_repair_estimate_lines_mig3;
432:
433: /*-------------------------------------------------------------------------------*/
434: /* procedure name: CSD_ACTTOEST_CHARGE_LINE_MIG3 */
435: /* description : procedure for copying the ACTUAL CHARGE LINE TO ESTIMATE */

Line 438: /* for the CSD_REPAIR_ESTIMATE_LINES table data */

434: /* procedure name: CSD_ACTTOEST_CHARGE_LINE_MIG3 */
435: /* description : procedure for copying the ACTUAL CHARGE LINE TO ESTIMATE */
436: /* CHARGE LINE and linking the Actual charge line to Depot Actuals*/
437: /* and Estimate charge line to Depot Estimate line */
438: /* for the CSD_REPAIR_ESTIMATE_LINES table data */
439: /* during migration from 11.5.9 to 11.5.10 */
440: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/
441: /* purpose : Step 2A and 2B of 11510 Actuals Data Migration Steps */
442: /* creates new Estimate charge line */

Line 440: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/

436: /* CHARGE LINE and linking the Actual charge line to Depot Actuals*/
437: /* and Estimate charge line to Depot Estimate line */
438: /* for the CSD_REPAIR_ESTIMATE_LINES table data */
439: /* during migration from 11.5.9 to 11.5.10 */
440: /* Update all records in 1159 CSD_REPAIR_ESTIMATE_LINES table for*/
441: /* purpose : Step 2A and 2B of 11510 Actuals Data Migration Steps */
442: /* creates new Estimate charge line */
443: /* 1. linking the new Estimate charge line to Depot Estimate line*/
444: /* 2. create a new Depot Actual line and */

Line 958: , csd_repair_estimate_lines cr

954: ced.submit_error_message,
955: ced.line_submitted,
956: ced.submit_from_system
957: FROM cs_estimate_details ced
958: , csd_repair_estimate_lines cr
959: WHERE cr.estimate_detail_id = ced.estimate_detail_id
960: AND ced.charge_line_type = 'ACTUAL'
961: AND ced.order_line_id is not null
962: AND ced.original_source_code = 'DR'

Line 1194: , csd_repair_estimate cre

1190: --sangigup
1191:
1192: FROM cs_estimate_details ced
1193: , csd_repairs cr
1194: , csd_repair_estimate cre
1195: , csd_repair_estimate_lines crel
1196: WHERE cr.repair_line_id = cre.repair_line_id
1197: AND cre.repair_estimate_id = crel.repair_estimate_id
1198: AND crel.estimate_detail_id = ced.estimate_detail_id

Line 1195: , csd_repair_estimate_lines crel

1191:
1192: FROM cs_estimate_details ced
1193: , csd_repairs cr
1194: , csd_repair_estimate cre
1195: , csd_repair_estimate_lines crel
1196: WHERE cr.repair_line_id = cre.repair_line_id
1197: AND cre.repair_estimate_id = crel.repair_estimate_id
1198: AND crel.estimate_detail_id = ced.estimate_detail_id
1199: AND ced.charge_line_type = 'ACTUAL'

Line 1513: FROM CSD_REPAIR_ESTIMATE_LINES

1509: -- gilam: add this query to get repair estimate line id for creating actual line
1510: -- get the repair estimate line id : to set as the source id of the new actual line
1511: SELECT repair_estimate_line_id
1512: INTO l_rep_est_line_id
1513: FROM CSD_REPAIR_ESTIMATE_LINES
1514: WHERE estimate_detail_id = l_old_est_detail_id;
1515:
1516: BEGIN
1517: -- Now copy the Actual line to Estimate charge line

Line 1815: UPDATE CSD_REPAIR_ESTIMATE_LINES

1811: BEGIN
1812:
1813: -- Update the Depot Estimate line to point to new charge line (type - Estimate)
1814: -- where it is pointing to the old charge line (type - Actual)
1815: UPDATE CSD_REPAIR_ESTIMATE_LINES
1816: SET ESTIMATE_DETAIL_ID = l_new_est_detail_id
1817: WHERE ESTIMATE_DETAIL_ID = l_old_est_detail_id;
1818:
1819: EXCEPTION

Line 1822: || 'UPDATE CSD_REPAIR_ESTIMATE_LINES Failed - To update Estimate Detail Id to :'

1818:
1819: EXCEPTION
1820: WHEN OTHERS THEN
1821: v_error_text := substr(sqlerrm, 1, 1000)
1822: || 'UPDATE CSD_REPAIR_ESTIMATE_LINES Failed - To update Estimate Detail Id to :'
1823: || l_new_est_detail_id
1824: || ' from Estimate Detail Id: '
1825: || l_old_est_detail_id;
1826: RAISE error_process;

Line 1852: VALUES ('CSD_REPAIR_ESTIMATE_LINES',

1848: ORIG_SYSTEM_REFERENCE_ID,
1849: UPGRADE_DATETIME,
1850: ERROR_MESSAGE,
1851: MIGRATION_PHASE)
1852: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
1853: 'CS_ESTIMATE_DETAILS',
1854: v_ESTIMATE_DETAIL_ID(j),
1855: sysdate,
1856: v_error_text,

Line 1897: FROM CSD_REPAIR_ESTIMATE_LINES

1893: -- gilam: add this query to get repair estimate line id for creating actual line
1894: -- get the repair estimate line id : to set as the source id of the new actual line
1895: SELECT repair_estimate_line_id
1896: INTO l_rep_est_line_id
1897: FROM CSD_REPAIR_ESTIMATE_LINES
1898: WHERE estimate_detail_id = l_old_est_detail_id;
1899:
1900: BEGIN
1901: -- Now copy the Actual line to Estimate charge line

Line 2193: UPDATE CSD_REPAIR_ESTIMATE_LINES

2189: BEGIN
2190:
2191: -- Update the Depot Estimate line to point to new charge line (type - Estimate)
2192: -- where it is pointing to the old charge line (typa - Actual)
2193: UPDATE CSD_REPAIR_ESTIMATE_LINES
2194: SET ESTIMATE_DETAIL_ID = l_new_est_detail_id
2195: WHERE ESTIMATE_DETAIL_ID = l_old_est_detail_id;
2196:
2197: EXCEPTION

Line 2200: || 'UPDATE CSD_REPAIR_ESTIMATE_LINES Failed - To update Estimate Detail Id to :'

2196:
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: v_error_text := substr(sqlerrm, 1, 1000)
2200: || 'UPDATE CSD_REPAIR_ESTIMATE_LINES Failed - To update Estimate Detail Id to :'
2201: || l_new_est_detail_id
2202: || ' from Estimate Detail Id: '
2203: || l_old_est_detail_id;
2204: RAISE error_process;

Line 2230: VALUES ('CSD_REPAIR_ESTIMATE_LINES',

2226: ORIG_SYSTEM_REFERENCE_ID,
2227: UPGRADE_DATETIME,
2228: ERROR_MESSAGE,
2229: MIGRATION_PHASE)
2230: VALUES ('CSD_REPAIR_ESTIMATE_LINES',
2231: 'CS_ESTIMATE_DETAILS',
2232: est_det_arr(j).estimate_detail_id,
2233: sysdate,
2234: v_error_text,

Line 2522: /* description : procedure for migrating csd_repair_estimate_lines */

2518:
2519:
2520: /*-------------------------------------------------------------------------------*/
2521: /* procedure name: CSD_COST_DATA_MIG3 */
2522: /* description : procedure for migrating csd_repair_estimate_lines */
2523: /* table cost data */
2524: /* from 11.5.9 to 11.5.10 */
2525: /* */
2526: /* If item_cost is not null and in differnt currency from the estimate line, */

Line 2580: -- Added a new column ORIGINAL_COST to CSD_REPAIR_ESTIMATE_LINES table.

2576: l_est_line_uom_code varchar2(3);
2577: l_billing_category_type varchar2(10);
2578: l_res_cost number;
2579: l_res_uom_code varchar2(3);
2580: -- Added a new column ORIGINAL_COST to CSD_REPAIR_ESTIMATE_LINES table.
2581: -- This column will be updated with the item_cost during migration. If conversion goes through
2582: -- succesfully then item_cost is updated with the converted value and original_Cost is
2583: --updated with the original item_cost. IF conversion does not go through then item_cost is
2584: --updated with null and original_cost is updated with the old item_cost. Thus we pick only those

Line 2587: -- Select rows from csd_repair_estimate_lines. Also get the currency code, uom for each line

2583: --updated with the original item_cost. IF conversion does not go through then item_cost is
2584: --updated with null and original_cost is updated with the old item_cost. Thus we pick only those
2585: --records for which either item_cost or original_cost are null. If they are both null then we ignore
2586: --those records.
2587: -- Select rows from csd_repair_estimate_lines. Also get the currency code, uom for each line
2588: Cursor cur_getEstimateLines(p_start number, p_end number)
2589: IS
2590: SELECT rel.repair_estimate_line_id estimate_line_id, rel.item_cost item_cost,
2591: rel.original_cost original_cost, ced.currency_code, ced.creation_date ,

Line 2593: FROM csd_repair_estimate_lines rel, cs_estimate_details ced

2589: IS
2590: SELECT rel.repair_estimate_line_id estimate_line_id, rel.item_cost item_cost,
2591: rel.original_cost original_cost, ced.currency_code, ced.creation_date ,
2592: ced.unit_of_measure_code, ced.estimate_detail_id, rel.resource_id, rel.rowid
2593: FROM csd_repair_estimate_lines rel, cs_estimate_details ced
2594: WHERE rel.estimate_detail_id = ced.estimate_detail_id
2595: and (
2596: ( rel.item_cost is not null and rel.original_cost is null)
2597: OR ( rel.item_cost is null and rel.original_cost is not null)

Line 2623: FROM csd_repair_estimate_lines ESTL,

2619: -- Cursor to get the estimate line category for a given estimate line id
2620: CURSOR cur_getBillCategoryType (p_estimate_detail_id number)
2621: IS
2622: SELECT BCAT.billing_category
2623: FROM csd_repair_estimate_lines ESTL,
2624: cs_estimate_details ESTD,
2625: cs_txn_billing_types TXNT,
2626: cs_billing_type_categories BCAT
2627: WHERE ESTL.repair_estimate_line_id = p_estimate_detail_id

Line 2652: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_ESTIMATE_LINES',

2648: BEGIN
2649:
2650: --Get the slab number for the table
2651: Begin
2652: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CSD_REPAIR_ESTIMATE_LINES',
2653: 'CSD',
2654: p_slab_number,
2655: v_min,
2656: v_max);

Line 2704: SAVEPOINT CSD_REPAIR_ESTIMATE_LINES;

2700: LIMIT MAX_BUFFER_SIZE;
2701:
2702: FOR j in 1..repair_estimate_line_id_mig.count
2703: LOOP
2704: SAVEPOINT CSD_REPAIR_ESTIMATE_LINES;
2705:
2706: Begin
2707: --populate l_orig_or_item_cost variable. If item_cost is null then
2708: --l_orig_or_item_cost = original_cost else = item_cost

Line 2725: Update csd_repair_Estimate_lines

2721:
2722: if (l_est_line_uom_code <> chg_uom_code_mig(j) ) then
2723: -- If not then stamp item_cost with null and log the message in upg_errors.
2724:
2725: Update csd_repair_Estimate_lines
2726: set original_cost = item_cost,
2727: item_cost = null
2728: where repair_estimate_line_id = repair_estimate_line_id_mig(j);
2729: --skip the record

Line 2754: Update csd_repair_Estimate_lines

2750: CLOSE cur_getResUOMCode;
2751: --check if the reosurce uom = charge line uom
2752: if (l_res_uom_code <> chg_uom_code_mig(j) ) then
2753: -- If not then stamp item_cost with null and log the message in upg_errors.
2754: Update csd_repair_Estimate_lines
2755: set original_cost = item_cost,
2756: item_cost = null
2757: where repair_estimate_line_id = repair_estimate_line_id_mig(j);
2758: -- skip the record

Line 2763: Update csd_repair_Estimate_lines

2759: raise skip_process;
2760: -- log_error(repair_estimate_line_id_mig(j),item_cost_mig(j), l_cost_currency_code);
2761: else
2762: -- resource and estimate line UOM matched. Stamp item_cost, original_cost with resource_cost
2763: Update csd_repair_Estimate_lines
2764: set original_cost = l_res_cost,
2765: item_cost = l_res_cost
2766: where repair_estimate_line_id = repair_estimate_line_id_mig(j);
2767: --Update the variable l_orig_or_item_cost with l_res_cost so

Line 2796: Update csd_repair_Estimate_lines

2792: -- If l_rate is -1 or -2 then conversion did not happen.
2793: -- Update original_cost with the item_cost and item_cost
2794: --with null and save this info in CSD_UPG_ERRORS table.
2795: IF l_rate < 0 then
2796: Update csd_repair_Estimate_lines
2797: set original_cost = item_cost,
2798: item_cost = null
2799: where repair_estimate_line_id = repair_estimate_line_id_mig(j);
2800: --Log the item_cost for the estimate that is being reset to null

Line 2807: Update csd_repair_Estimate_lines

2803:
2804: else
2805: -- Update original_cost with the item_cost and item_cost with the converted value since conversion
2806: --went thru fine.
2807: Update csd_repair_Estimate_lines
2808: set original_cost = item_cost,
2809: item_cost = x_conv_amount
2810: where repair_estimate_line_id =
2811: repair_estimate_line_id_mig(j);

Line 2820: Update csd_repair_Estimate_lines

2816: end if;
2817: ELSE
2818: -- No need to convert because charge and cost currencies were the same. Just update
2819: -- original_cost with the item_cost so that the row does not get picked during reruns.
2820: Update csd_repair_Estimate_lines
2821: set original_cost = item_cost
2822: where repair_estimate_line_id =
2823: repair_estimate_line_id_mig(j);
2824:

Line 2834: -- ROLLBACK to CSD_REPAIR_ESTIMATE_LINES;

2830: Exception
2831: when Skip_process then
2832: -- 4/26/04, Shiv Ragunathan,
2833: -- Commented out the following line as this would undo the null updates done to the cost line
2834: -- ROLLBACK to CSD_REPAIR_ESTIMATE_LINES;
2835:
2836: -- 4/26/04, Shiv ragunathan, Commented out following line as log_error itself has an error_text
2837: -- v_error_text := substr(sqlerrm,1,1000)||'Estimate_Line_id:'||repair_estimate_line_id_mig(j) ;
2838:

Line 2848: VALUES('CSD_REPAIR_ESTIMATE_LINES',

2844: ORIG_SYSTEM_REFERENCE_ID,
2845: UPGRADE_DATETIME,
2846: ERROR_MESSAGE,
2847: MIGRATION_PHASE)
2848: VALUES('CSD_REPAIR_ESTIMATE_LINES',
2849: 'CSD_REPAIR_ESTIMATE_LINES',
2850: repair_estimate_line_id_mig(j),
2851: sysdate,
2852: v_error_text,

Line 2849: 'CSD_REPAIR_ESTIMATE_LINES',

2845: UPGRADE_DATETIME,
2846: ERROR_MESSAGE,
2847: MIGRATION_PHASE)
2848: VALUES('CSD_REPAIR_ESTIMATE_LINES',
2849: 'CSD_REPAIR_ESTIMATE_LINES',
2850: repair_estimate_line_id_mig(j),
2851: sysdate,
2852: v_error_text,
2853: '11.5.10');*/

Line 2868: VALUES('CSD_REPAIR_ESTIMATE_LINES',

2864: ORIG_SYSTEM_REFERENCE_ID,
2865: UPGRADE_DATETIME,
2866: ERROR_MESSAGE,
2867: MIGRATION_PHASE)
2868: VALUES('CSD_REPAIR_ESTIMATE_LINES',
2869: 'CSD_REPAIR_ESTIMATE_LINES',
2870: repair_estimate_line_id_mig(j),
2871: sysdate,
2872: v_error_text,

Line 2869: 'CSD_REPAIR_ESTIMATE_LINES',

2865: UPGRADE_DATETIME,
2866: ERROR_MESSAGE,
2867: MIGRATION_PHASE)
2868: VALUES('CSD_REPAIR_ESTIMATE_LINES',
2869: 'CSD_REPAIR_ESTIMATE_LINES',
2870: repair_estimate_line_id_mig(j),
2871: sysdate,
2872: v_error_text,
2873: '11.5.10');

Line 2877: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_ESTIMATE_LINES cost data. '|| v_error_text);

2873: '11.5.10');
2874:
2875: commit;
2876:
2877: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_ESTIMATE_LINES cost data. '|| v_error_text);
2878:
2879:
2880: END;
2881: END LOOP;

Line 2898: /* csd_repair_estimate_lines table cost data */

2894: END CSD_Cost_data_mig3;
2895: /*-------------------------------------------------------------------------------*/
2896: /* procedure name: LOG_ERROR */
2897: /* description : procedure for logging errors while migrating */
2898: /* csd_repair_estimate_lines table cost data */
2899: /* from 11.5.9 to 11.5.10 */
2900: /* */
2901: /* This procedure will log the item_cost in CSD_UPG_ERRORS table */
2902: /*-------------------------------------------------------------------------------*/

Line 2918: VALUES('CSD_REPAIR_ESTIMATE_LINES',

2914: ORIG_SYSTEM_REFERENCE_ID,
2915: UPGRADE_DATETIME,
2916: ERROR_MESSAGE,
2917: MIGRATION_PHASE)
2918: VALUES('CSD_REPAIR_ESTIMATE_LINES',
2919: 'CSD_REPAIR_ESTIMATE_LINES',
2920: p_estimate_line_id,
2921: sysdate,
2922: v_error_text,

Line 2919: 'CSD_REPAIR_ESTIMATE_LINES',

2915: UPGRADE_DATETIME,
2916: ERROR_MESSAGE,
2917: MIGRATION_PHASE)
2918: VALUES('CSD_REPAIR_ESTIMATE_LINES',
2919: 'CSD_REPAIR_ESTIMATE_LINES',
2920: p_estimate_line_id,
2921: sysdate,
2922: v_error_text,
2923: '11.5.10');