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_PKG dependencies on CSD_REPAIR_ESTIMATE

Line 127: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;

123: Type RowidTabType is VARRAY(1000) of VARCHAR2(30);
124: rowid_mig RowidTabtype;
125:
126:
127: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;
128: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;
129: l_creation_date DATE;
130:
131: l_rma varchar2(30) := 'RMA';

Line 128: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;

124: rowid_mig RowidTabtype;
125:
126:
127: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;
128: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;
129: l_creation_date DATE;
130:
131: l_rma varchar2(30) := 'RMA';
132: l_ship varchar2(30) := 'SHIP';

Line 174: and not exists ( select '*' from csd_repair_estimate_lines crel

170: and ced.inventory_item_id = cra.inventory_item_id
171: and ced.source_code = 'DR'
172: and not exists ( select '*' from csd_product_transactions cpt
173: where cpt.estimate_detail_id = ced.estimate_detail_id)
174: and not exists ( select '*' from csd_repair_estimate_lines crel
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

Line 471: PROCEDURE CSD_REPAIR_ESTIMATE_MIG (p_slab_number IN NUMBER DEFAULT 1) IS

467:
468: End Csd_product_txn_lines_mig;
469:
470:
471: PROCEDURE CSD_REPAIR_ESTIMATE_MIG (p_slab_number IN NUMBER DEFAULT 1) IS
472:
473: TYPE NumArray IS VARRAY(10000) OF NUMBER;
474: TYPE Char3Array IS VARRAY(10000) OF VARCHAR2(3);
475: TYPE Char240Array IS VARRAY(10000) OF VARCHAR2(240);

Line 494: l_estimate_status CSD_REPAIR_ESTIMATE.ESTIMATE_STATUS%TYPE;

490:
491: l_dummy varchar2(1);
492: l_repair_estimate_id NUMBER;
493: l_repair_line_id NUMBER;
494: l_estimate_status CSD_REPAIR_ESTIMATE.ESTIMATE_STATUS%TYPE;
495: l_estimate_date DATE;
496: l_work_summary CSD_REPAIR_ESTIMATE.WORK_SUMMARY%TYPE;
497: l_lead_time CSD_REPAIR_ESTIMATE.LEAD_TIME%TYPE;
498: l_lead_time_uom CSD_REPAIR_ESTIMATE.LEAD_TIME_UOM%TYPE := 'DAY';

Line 496: l_work_summary CSD_REPAIR_ESTIMATE.WORK_SUMMARY%TYPE;

492: l_repair_estimate_id NUMBER;
493: l_repair_line_id NUMBER;
494: l_estimate_status CSD_REPAIR_ESTIMATE.ESTIMATE_STATUS%TYPE;
495: l_estimate_date DATE;
496: l_work_summary CSD_REPAIR_ESTIMATE.WORK_SUMMARY%TYPE;
497: l_lead_time CSD_REPAIR_ESTIMATE.LEAD_TIME%TYPE;
498: l_lead_time_uom CSD_REPAIR_ESTIMATE.LEAD_TIME_UOM%TYPE := 'DAY';
499: l_estimate_freeze_flag CSD_REPAIR_ESTIMATE.ESTIMATE_FREEZE_FLAG%TYPE := 'N';
500:

Line 497: l_lead_time CSD_REPAIR_ESTIMATE.LEAD_TIME%TYPE;

493: l_repair_line_id NUMBER;
494: l_estimate_status CSD_REPAIR_ESTIMATE.ESTIMATE_STATUS%TYPE;
495: l_estimate_date DATE;
496: l_work_summary CSD_REPAIR_ESTIMATE.WORK_SUMMARY%TYPE;
497: l_lead_time CSD_REPAIR_ESTIMATE.LEAD_TIME%TYPE;
498: l_lead_time_uom CSD_REPAIR_ESTIMATE.LEAD_TIME_UOM%TYPE := 'DAY';
499: l_estimate_freeze_flag CSD_REPAIR_ESTIMATE.ESTIMATE_FREEZE_FLAG%TYPE := 'N';
500:
501: v_error_text VARCHAR2(2000);

Line 498: l_lead_time_uom CSD_REPAIR_ESTIMATE.LEAD_TIME_UOM%TYPE := 'DAY';

494: l_estimate_status CSD_REPAIR_ESTIMATE.ESTIMATE_STATUS%TYPE;
495: l_estimate_date DATE;
496: l_work_summary CSD_REPAIR_ESTIMATE.WORK_SUMMARY%TYPE;
497: l_lead_time CSD_REPAIR_ESTIMATE.LEAD_TIME%TYPE;
498: l_lead_time_uom CSD_REPAIR_ESTIMATE.LEAD_TIME_UOM%TYPE := 'DAY';
499: l_estimate_freeze_flag CSD_REPAIR_ESTIMATE.ESTIMATE_FREEZE_FLAG%TYPE := 'N';
500:
501: v_error_text VARCHAR2(2000);
502: MAX_BUFFER_SIZE NUMBER := 500;

Line 499: l_estimate_freeze_flag CSD_REPAIR_ESTIMATE.ESTIMATE_FREEZE_FLAG%TYPE := 'N';

495: l_estimate_date DATE;
496: l_work_summary CSD_REPAIR_ESTIMATE.WORK_SUMMARY%TYPE;
497: l_lead_time CSD_REPAIR_ESTIMATE.LEAD_TIME%TYPE;
498: l_lead_time_uom CSD_REPAIR_ESTIMATE.LEAD_TIME_UOM%TYPE := 'DAY';
499: l_estimate_freeze_flag CSD_REPAIR_ESTIMATE.ESTIMATE_FREEZE_FLAG%TYPE := 'N';
500:
501: v_error_text VARCHAR2(2000);
502: MAX_BUFFER_SIZE NUMBER := 500;
503:

Line 521: and not exists ( select '*' from csd_repair_estimate cre

517: and ced.inventory_item_id <> cra.inventory_item_id
518: and ced.source_code = 'DR'
519: and ced.estimate_detail_id >= p_min_id -- slab limits
520: and ced.estimate_detail_id <= p_max_id -- slab limits
521: and not exists ( select '*' from csd_repair_estimate cre
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

Line 546: -- Migrate csd_repair_estimate

542: RETURN;
543: END IF;
544:
545: -- get default values if needed into variables from cursors
546: -- Migrate csd_repair_estimate
547: Begin
548: select 'x'
549: into l_dummy
550: from fnd_lookups

Line 600: INSERT INTO CSD_REPAIR_ESTIMATE

596: l_lead_time := 1;
597: End If;
598:
599: BEGIN
600: INSERT INTO CSD_REPAIR_ESTIMATE
601: ( REPAIR_ESTIMATE_ID
602: ,REPAIR_LINE_ID
603: ,ESTIMATE_STATUS
604: ,ESTIMATE_DATE

Line 616: CSD_REPAIR_ESTIMATE_S1.nextval

612: ,LAST_UPDATE_LOGIN
613: ,OBJECT_VERSION_NUMBER
614: ,ESTIMATE_FREEZE_FLAG)
615: VALUES (
616: CSD_REPAIR_ESTIMATE_S1.nextval
617: ,l_repair_line_id
618: ,l_estimate_status
619: ,l_estimate_date
620: ,l_work_summary

Line 643: 'CSD_REPAIR_ESTIMATE',

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,
647: '11.5.8');

Line 651: raise_application_error( -20000, 'Error while migrating CSD_ESTIMATE_DETAILS table data: Error while inserting into CSD_REPAIR_ESTIMATE. '|| v_error_text);

647: '11.5.8');
648:
649: commit;
650:
651: raise_application_error( -20000, 'Error while migrating CSD_ESTIMATE_DETAILS table data: Error while inserting into CSD_REPAIR_ESTIMATE. '|| v_error_text);
652:
653:
654: END ;
655:

Line 671: END CSD_REPAIR_ESTIMATE_MIG;

667:
668: COMMIT;
669: -- Api body ends here
670:
671: END CSD_REPAIR_ESTIMATE_MIG;
672:
673: PROCEDURE CSD_REPAIR_ESTIMATE_LINES_MIG (p_slab_number IN NUMBER DEFAULT 1) IS
674:
675: TYPE NumArray IS VARRAY(10000) OF NUMBER;

Line 673: PROCEDURE CSD_REPAIR_ESTIMATE_LINES_MIG (p_slab_number IN NUMBER DEFAULT 1) IS

669: -- Api body ends here
670:
671: END CSD_REPAIR_ESTIMATE_MIG;
672:
673: PROCEDURE CSD_REPAIR_ESTIMATE_LINES_MIG (p_slab_number IN NUMBER DEFAULT 1) IS
674:
675: TYPE NumArray IS VARRAY(10000) OF NUMBER;
676: TYPE Char3Array IS VARRAY(10000) OF VARCHAR2(3);
677: TYPE Char15Array IS VARRAY(10000) OF VARCHAR2(15);

Line 693: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;

689: l_array_size NUMBER; -- Number of elements in varrays
690: l_min_id NUMBER; -- Minimum Repair Line ID
691: l_max_id NUMBER; -- Maximum Repair Line ID
692:
693: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;
694: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;
695: l_item_cost CSD_REPAIR_ESTIMATE_LINES.ITEM_COST%TYPE;
696: l_creation_date DATE;
697:

Line 694: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;

690: l_min_id NUMBER; -- Minimum Repair Line ID
691: l_max_id NUMBER; -- Maximum Repair Line ID
692:
693: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;
694: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;
695: l_item_cost CSD_REPAIR_ESTIMATE_LINES.ITEM_COST%TYPE;
696: l_creation_date DATE;
697:
698: v_error_text VARCHAR2(2000);

Line 695: l_item_cost CSD_REPAIR_ESTIMATE_LINES.ITEM_COST%TYPE;

691: l_max_id NUMBER; -- Maximum Repair Line ID
692:
693: l_repair_estimate_id CSD_REPAIR_ESTIMATE_LINES.REPAIR_ESTIMATE_ID%TYPE;
694: l_estimate_detail_id CSD_REPAIR_ESTIMATE_LINES.ESTIMATE_DETAIL_ID%TYPE;
695: l_item_cost CSD_REPAIR_ESTIMATE_LINES.ITEM_COST%TYPE;
696: l_creation_date DATE;
697:
698: v_error_text VARCHAR2(2000);
699: MAX_BUFFER_SIZE NUMBER := 500;

Line 711: csd_repair_estimate cre

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
714: and ced.inventory_item_id <> cra.inventory_item_id
715: and ced.source_code = 'DR'

Line 718: and not exists ( select '*' from csd_repair_estimate_lines crel

714: and ced.inventory_item_id <> cra.inventory_item_id
715: and ced.source_code = 'DR'
716: and ced.estimate_detail_id >= p_min_id -- slab limits
717: and ced.estimate_detail_id <= p_max_id -- slab limits
718: and not exists ( select '*' from csd_repair_estimate_lines crel
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

Line 744: -- Migrate csd_repair_estimate

740: RETURN;
741: END IF;
742:
743: -- get default values if needed into variables from cursors
744: -- Migrate csd_repair_estimate
745:
746: -- Open main cursor
747: OPEN cur_estimate_lines( l_min_id, l_max_id );
748:

Line 776: INSERT INTO CSD_REPAIR_ESTIMATE_LINES(

772: l_creation_date := l_creation_date_arr(i);
773: l_item_cost := 1;
774:
775: BEGIN
776: INSERT INTO CSD_REPAIR_ESTIMATE_LINES(
777: REPAIR_ESTIMATE_LINE_ID
778: ,REPAIR_ESTIMATE_ID
779: ,CREATION_DATE
780: ,CREATED_BY

Line 788: CSD_REPAIR_ESTIMATE_LINES_S1.nextval

784: ,OBJECT_VERSION_NUMBER
785: ,ESTIMATE_DETAIL_ID
786: ,ITEM_COST)
787: VALUES (
788: CSD_REPAIR_ESTIMATE_LINES_S1.nextval
789: ,l_repair_estimate_id
790: ,l_creation_date
791: ,FND_GLOBAL.USER_ID
792: ,FND_GLOBAL.USER_ID

Line 810: 'CSD_REPAIR_ESTIMATE_LINES',

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,
814: '11.5.8');

Line 817: raise_application_error( -20000, 'Error while migrating CS_ESTIMATE_DETAILS table data: Error while inserting into CSD_REPAIR_ESTIMATE_LINES. '|| 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

Line 835: END CSD_REPAIR_ESTIMATE_LINES_MIG;

831:
832: COMMIT;
833: -- Api body ends here
834:
835: END CSD_REPAIR_ESTIMATE_LINES_MIG;
836:
837: -- Migration procedure for CSD_REPAIR_JOB_XREF
838: PROCEDURE CSD_REPAIR_JOB_XREF_MIG (p_slab_number NUMBER DEFAULT 1) IS
839: