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_JOB_XREF

Line 837: -- Migration procedure for CSD_REPAIR_JOB_XREF

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:
840: Type NumTabType is VARRAY(10000) of NUMBER;
841: inventory_item_id_mig NumTabType;

Line 838: PROCEDURE CSD_REPAIR_JOB_XREF_MIG (p_slab_number NUMBER DEFAULT 1) IS

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:
840: Type NumTabType is VARRAY(10000) of NUMBER;
841: inventory_item_id_mig NumTabType;
842: repair_job_xref_id_mig NumTabType;

Line 847: CURSOR csd_repair_job_xref_cursor (p_min number,p_max number) is

843:
844: Type RowidTabType is VARRAY(1000) of VARCHAR2(30);
845: rowid_mig RowidTabtype;
846:
847: CURSOR csd_repair_job_xref_cursor (p_min number,p_max number) is
848: select crjx.repair_job_xref_id,
849: cr.inventory_item_id,
850: crjx.rowid
851: from csd_repair_job_xref crjx,

Line 851: from csd_repair_job_xref crjx,

847: CURSOR csd_repair_job_xref_cursor (p_min number,p_max number) is
848: select crjx.repair_job_xref_id,
849: cr.inventory_item_id,
850: crjx.rowid
851: from csd_repair_job_xref crjx,
852: csd_repairs cr
853: where crjx.repair_line_id = cr.repair_line_id
854: and crjx.repair_job_xref_id >= p_min
855: and crjx.repair_job_xref_id <= p_max

Line 868: (p_table_name =>'CSD_REPAIR_JOB_XREF',

864: BEGIN
865:
866: -- Initialize the min and max limit
867: csd_mig_slabs_pkg.get_table_slabs
868: (p_table_name =>'CSD_REPAIR_JOB_XREF',
869: p_module =>'CSD',
870: p_slab_number => p_slab_number,
871: x_start_slab => l_min,
872: x_end_slab => l_max);

Line 880: OPEN csd_repair_job_xref_cursor(l_min,l_max);

876: RETURN;
877: END IF;
878:
879: -- Open the cursor and update the table
880: OPEN csd_repair_job_xref_cursor(l_min,l_max);
881: LOOP
882: FETCH csd_repair_job_xref_cursor bulk collect into
883: repair_job_xref_id_mig,
884: inventory_item_id_mig,

Line 882: FETCH csd_repair_job_xref_cursor bulk collect into

878:
879: -- Open the cursor and update the table
880: OPEN csd_repair_job_xref_cursor(l_min,l_max);
881: LOOP
882: FETCH csd_repair_job_xref_cursor bulk collect into
883: repair_job_xref_id_mig,
884: inventory_item_id_mig,
885: rowid_mig
886: LIMIT MAX_BUFFER_SIZE;

Line 891: SAVEPOINT CSD_REPAIR_JOB_XREF;

887:
888: FOR j in 1..repair_job_xref_id_mig.count
889: LOOP
890:
891: SAVEPOINT CSD_REPAIR_JOB_XREF;
892:
893: BEGIN
894: UPDATE csd_repair_job_xref
895: SET inventory_item_id = inventory_item_id_mig(j),

Line 894: UPDATE csd_repair_job_xref

890:
891: SAVEPOINT CSD_REPAIR_JOB_XREF;
892:
893: BEGIN
894: UPDATE csd_repair_job_xref
895: SET inventory_item_id = inventory_item_id_mig(j),
896: last_update_date = sysdate,
897: last_update_login = fnd_global.login_id,
898: last_updated_by = fnd_global.user_id

Line 904: Rollback to CSD_REPAIR_JOB_XREF;

900: EXCEPTION
901: WHEN OTHERS THEN
902: -- when errored rollback and insert the message into
903: -- the csd upgrade errors table
904: Rollback to CSD_REPAIR_JOB_XREF;
905: l_error_text := 'Repair job xref updation Error '||substr(sqlerrm,1,1000);
906:
907: INSERT INTO csd_upg_errors
908: (orig_system_reference,

Line 915: ('CSD_REPAIR_JOB_XREF',

911: upgrade_datetime,
912: error_message,
913: migration_phase)
914: VALUES
915: ('CSD_REPAIR_JOB_XREF',
916: 'CSD_REPAIR_JOB_XREF',
917: repair_job_xref_id_mig(j),
918: sysdate,
919: l_error_text,

Line 916: 'CSD_REPAIR_JOB_XREF',

912: error_message,
913: migration_phase)
914: VALUES
915: ('CSD_REPAIR_JOB_XREF',
916: 'CSD_REPAIR_JOB_XREF',
917: repair_job_xref_id_mig(j),
918: sysdate,
919: l_error_text,
920: '11.5.8');

Line 924: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '|| l_error_text);

920: '11.5.8');
921:
922: commit;
923:
924: raise_application_error( -20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '|| l_error_text);
925:
926:
927: END;
928:

Line 933: EXIT WHEN csd_repair_job_xref_cursor%notfound;

929: END LOOP;
930:
931: COMMIT;
932:
933: EXIT WHEN csd_repair_job_xref_cursor%notfound;
934: END LOOP;
935:
936: if csd_repair_job_xref_cursor%isopen then
937: close csd_repair_job_xref_cursor;

Line 936: if csd_repair_job_xref_cursor%isopen then

932:
933: EXIT WHEN csd_repair_job_xref_cursor%notfound;
934: END LOOP;
935:
936: if csd_repair_job_xref_cursor%isopen then
937: close csd_repair_job_xref_cursor;
938: end if;
939:
940: EXCEPTION

Line 937: close csd_repair_job_xref_cursor;

933: EXIT WHEN csd_repair_job_xref_cursor%notfound;
934: END LOOP;
935:
936: if csd_repair_job_xref_cursor%isopen then
937: close csd_repair_job_xref_cursor;
938: end if;
939:
940: EXCEPTION
941: WHEN OTHERS THEN

Line 943: if csd_repair_job_xref_cursor%isopen then

939:
940: EXCEPTION
941: WHEN OTHERS THEN
942: l_error_text := substr(sqlerrm,1,1000);
943: if csd_repair_job_xref_cursor%isopen then
944: close csd_repair_job_xref_cursor;
945: end if;
946: RAISE_APPLICATION_ERROR(-20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '||l_error_text);
947: END CSD_REPAIR_JOB_XREF_MIG;

Line 944: close csd_repair_job_xref_cursor;

940: EXCEPTION
941: WHEN OTHERS THEN
942: l_error_text := substr(sqlerrm,1,1000);
943: if csd_repair_job_xref_cursor%isopen then
944: close csd_repair_job_xref_cursor;
945: end if;
946: RAISE_APPLICATION_ERROR(-20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '||l_error_text);
947: END CSD_REPAIR_JOB_XREF_MIG;
948:

Line 946: RAISE_APPLICATION_ERROR(-20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '||l_error_text);

942: l_error_text := substr(sqlerrm,1,1000);
943: if csd_repair_job_xref_cursor%isopen then
944: close csd_repair_job_xref_cursor;
945: end if;
946: RAISE_APPLICATION_ERROR(-20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '||l_error_text);
947: END CSD_REPAIR_JOB_XREF_MIG;
948:
949:
950: -- Migration procedure for CSD_REPAIR_TYPES_B

Line 947: END CSD_REPAIR_JOB_XREF_MIG;

943: if csd_repair_job_xref_cursor%isopen then
944: close csd_repair_job_xref_cursor;
945: end if;
946: RAISE_APPLICATION_ERROR(-20000, 'Error while migrating CSD_REPAIR_JOB_XREF table data. '||l_error_text);
947: END CSD_REPAIR_JOB_XREF_MIG;
948:
949:
950: -- Migration procedure for CSD_REPAIR_TYPES_B
951: PROCEDURE CSD_REPAIR_TYPES_B_MIG IS