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_LINES

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 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 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 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: