[Home] [Help]
163: ced.quantity_required,
164: ced.creation_date,
165: cra.repair_type_id,
166: ced.rowid
167: from cs_estimate_details ced,
168: csd_repairs cra
169: where ced.source_id = cra.repair_line_id
170: and ced.inventory_item_id = cra.inventory_item_id
171: and ced.source_code = 'DR'
175: where crel.estimate_detail_id = ced.estimate_detail_id)
176: and ced.estimate_detail_id >= p_start
177: and ced.estimate_detail_id <= p_end;
178: -- Shiv Ragunathan, 11/19/03, Added the above 'not exists' clause to
179: -- prevent data in cs_estimate_details from being migrated,
180: -- if this was created from Depot Repair in 11.5.8. IN 11.5.7, this
181: -- was not possible. This is introduced as this code is also run,
182: -- when upgrading from 11.5.8 ( or 11.5.9 ) as well.
183:
194: BEGIN
195:
196: -- Get the Slab Number for the table
197: Begin
198: CSD_MIG_SLABS_PKG.GET_TABLE_SLABS('CS_ESTIMATE_DETAILS'
199: ,'CSD'
200: ,p_slab_number
201: ,v_min
202: ,v_max);
415: UPGRADE_DATETIME,
416: ERROR_MESSAGE,
417: MIGRATION_PHASE)
418: VALUES(
419: 'CS_ESTIMATE_DETAILS'
420: ,'CSD_PRODUCT_TRANSACTIONS'
421: ,estimate_detail_id_mig(j)
422: ,sysdate
423: ,v_error_text
438: UPGRADE_DATETIME,
439: ERROR_MESSAGE,
440: MIGRATION_PHASE)
441: VALUES(
442: 'CS_ESTIMATE_DETAILS'
443: ,'CSD_PRODUCT_TRANSACTIONS'
444: ,estimate_detail_id_mig(j)
445: ,sysdate
446: ,v_error_text
508: cia.summary,
509: cra.creation_date,
510: NVL(cra.promise_date, cra.creation_date),
511: cra.approval_status
512: from cs_estimate_details ced,
513: cs_incidents_all_b cia,
514: csd_repairs cra
515: where ced.source_id = cra.repair_line_id
516: and ced.incident_id = cia.incident_id
522: where cre.repair_line_id = ced.source_id)
523: and not exists ( select '*' from csd_product_transactions cpt
524: where cpt.estimate_detail_id = ced.estimate_detail_id);
525: -- Shiv Ragunathan, 11/19/03, Added the above 'not exists' clause to
526: -- prevent data in cs_estimate_details from being migrated,
527: -- if this was created from Depot Repair in 11.5.8. IN 11.5.7, this
528: -- was not possible. This is introduced as this code is also run,
529: -- when upgrading from 11.5.8 ( or 11.5.9 ) as well.
530:
530:
531: BEGIN
532:
533: -- Initialize Update range boundaries
534: csd_mig_slabs_pkg.get_table_slabs ( 'CS_ESTIMATE_DETAILS',
535: 'CSD',
536: p_slab_number,
537: l_min_id,
538: l_max_id);
638: orig_system_reference_id,
639: upgrade_datetime,
640: error_message,
641: migration_phase)
642: VALUES ('CS_ESTIMATE_DETAILS',
643: 'CSD_REPAIR_ESTIMATE',
644: l_repair_line_id,
645: sysdate,
646: v_error_text,
705: ced.order_header_id,
706: ced.order_line_id,
707: ced.creation_date,
708: cre.repair_estimate_id
709: from cs_estimate_details ced,
710: csd_repairs cra,
711: csd_repair_estimate cre
712: where ced.source_id = cra.repair_line_id
713: and cra.repair_line_id = cre.repair_line_id
719: where crel.estimate_detail_id = ced.estimate_detail_id)
720: and not exists ( select '*' from csd_product_transactions cpt
721: where cpt.estimate_detail_id = ced.estimate_detail_id);
722: -- Shiv Ragunathan, 11/19/03, Added the above 'not exists' clause to
723: -- prevent data in cs_estimate_details from being migrated,
724: -- if this was created from Depot Repair in 11.5.8. IN 11.5.7, this
725: -- was not possible. This is introduced as this code is also run,
726: -- when upgrading from 11.5.8 ( or 11.5.9 ) as well.
727:
728:
729: BEGIN
730:
731: -- Initialize Update range boundaries
732: csd_mig_slabs_pkg.get_table_slabs ( 'CS_ESTIMATE_DETAILS',
733: 'CSD',
734: p_slab_number,
735: l_min_id,
736: l_max_id);
805: orig_system_reference_id,
806: upgrade_datetime,
807: error_message,
808: migration_phase)
809: VALUES ('CS_ESTIMATE_DETAILS',
810: 'CSD_REPAIR_ESTIMATE_LINES',
811: l_estimate_detail_id,
812: sysdate,
813: v_error_text,
813: v_error_text,
814: '11.5.8');
815: commit;
816:
817: raise_application_error( -20000, 'Error while migrating CS_ESTIMATE_DETAILS table data: Error while inserting into CSD_REPAIR_ESTIMATE_LINES. '|| v_error_text);
818:
819: END;
820:
821: END LOOP;-- end of inner