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_PKG4 dependencies on CSD_MASS_RO_SN_ERRORS

Line 22: --TYPE SN_ERRS_REC_ARRAY_TYPE IS VARRAY(1000) OF CSD.CSD_MASS_RO_SN_ERRORS%ROWTYPE;

18: IS
19:
20:
21: --Changed since the 8i does no tsupport the collections type.
22: --TYPE SN_ERRS_REC_ARRAY_TYPE IS VARRAY(1000) OF CSD.CSD_MASS_RO_SN_ERRORS%ROWTYPE;
23: TYPE MRS_ERROR_ID_ARRAY_TYPE IS VARRAY(1000)
24: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ERROR_ID%TYPE;
25: TYPE MASS_RO_SN_ID_ARRAY_TYPE IS VARRAY(1000)
26: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ID%TYPE;

Line 24: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ERROR_ID%TYPE;

20:
21: --Changed since the 8i does no tsupport the collections type.
22: --TYPE SN_ERRS_REC_ARRAY_TYPE IS VARRAY(1000) OF CSD.CSD_MASS_RO_SN_ERRORS%ROWTYPE;
23: TYPE MRS_ERROR_ID_ARRAY_TYPE IS VARRAY(1000)
24: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ERROR_ID%TYPE;
25: TYPE MASS_RO_SN_ID_ARRAY_TYPE IS VARRAY(1000)
26: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ID%TYPE;
27: TYPE REPAIR_LINE_ID_ARRAY_TYPE IS VARRAY(1000)
28: OF CSD.CSD_MASS_RO_SN_ERRORS.REPAIR_LINE_ID%TYPE;

Line 26: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ID%TYPE;

22: --TYPE SN_ERRS_REC_ARRAY_TYPE IS VARRAY(1000) OF CSD.CSD_MASS_RO_SN_ERRORS%ROWTYPE;
23: TYPE MRS_ERROR_ID_ARRAY_TYPE IS VARRAY(1000)
24: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ERROR_ID%TYPE;
25: TYPE MASS_RO_SN_ID_ARRAY_TYPE IS VARRAY(1000)
26: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ID%TYPE;
27: TYPE REPAIR_LINE_ID_ARRAY_TYPE IS VARRAY(1000)
28: OF CSD.CSD_MASS_RO_SN_ERRORS.REPAIR_LINE_ID%TYPE;
29: TYPE ERROR_TYPE_ARRAY_TYPE IS VARRAY(1000)
30: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_TYPE%TYPE;

Line 28: OF CSD.CSD_MASS_RO_SN_ERRORS.REPAIR_LINE_ID%TYPE;

24: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ERROR_ID%TYPE;
25: TYPE MASS_RO_SN_ID_ARRAY_TYPE IS VARRAY(1000)
26: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ID%TYPE;
27: TYPE REPAIR_LINE_ID_ARRAY_TYPE IS VARRAY(1000)
28: OF CSD.CSD_MASS_RO_SN_ERRORS.REPAIR_LINE_ID%TYPE;
29: TYPE ERROR_TYPE_ARRAY_TYPE IS VARRAY(1000)
30: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_TYPE%TYPE;
31: TYPE ERROR_MSG_ARRAY_TYPE IS VARRAY(1000)
32: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_MSG%TYPE;

Line 30: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_TYPE%TYPE;

26: OF CSD.CSD_MASS_RO_SN_ERRORS.MASS_RO_SN_ID%TYPE;
27: TYPE REPAIR_LINE_ID_ARRAY_TYPE IS VARRAY(1000)
28: OF CSD.CSD_MASS_RO_SN_ERRORS.REPAIR_LINE_ID%TYPE;
29: TYPE ERROR_TYPE_ARRAY_TYPE IS VARRAY(1000)
30: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_TYPE%TYPE;
31: TYPE ERROR_MSG_ARRAY_TYPE IS VARRAY(1000)
32: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_MSG%TYPE;
33: TYPE CREATED_BY_ARRAY_TYPE IS VARRAY(1000)
34: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATED_BY%TYPE;

Line 32: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_MSG%TYPE;

28: OF CSD.CSD_MASS_RO_SN_ERRORS.REPAIR_LINE_ID%TYPE;
29: TYPE ERROR_TYPE_ARRAY_TYPE IS VARRAY(1000)
30: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_TYPE%TYPE;
31: TYPE ERROR_MSG_ARRAY_TYPE IS VARRAY(1000)
32: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_MSG%TYPE;
33: TYPE CREATED_BY_ARRAY_TYPE IS VARRAY(1000)
34: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATED_BY%TYPE;
35: TYPE CREATION_DT_ARRAY_TYPE IS VARRAY(1000)
36: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATION_DATE%TYPE;

Line 34: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATED_BY%TYPE;

30: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_TYPE%TYPE;
31: TYPE ERROR_MSG_ARRAY_TYPE IS VARRAY(1000)
32: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_MSG%TYPE;
33: TYPE CREATED_BY_ARRAY_TYPE IS VARRAY(1000)
34: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATED_BY%TYPE;
35: TYPE CREATION_DT_ARRAY_TYPE IS VARRAY(1000)
36: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATION_DATE%TYPE;
37: TYPE LAST_UPD_BY_ARRAY_TYPE IS VARRAY(1000)
38: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;

Line 36: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATION_DATE%TYPE;

32: OF CSD.CSD_MASS_RO_SN_ERRORS.ERROR_MSG%TYPE;
33: TYPE CREATED_BY_ARRAY_TYPE IS VARRAY(1000)
34: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATED_BY%TYPE;
35: TYPE CREATION_DT_ARRAY_TYPE IS VARRAY(1000)
36: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATION_DATE%TYPE;
37: TYPE LAST_UPD_BY_ARRAY_TYPE IS VARRAY(1000)
38: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;
39: TYPE LAST_UPD_DT_ARRAY_TYPE IS VARRAY(1000)
40: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;

Line 38: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;

34: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATED_BY%TYPE;
35: TYPE CREATION_DT_ARRAY_TYPE IS VARRAY(1000)
36: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATION_DATE%TYPE;
37: TYPE LAST_UPD_BY_ARRAY_TYPE IS VARRAY(1000)
38: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;
39: TYPE LAST_UPD_DT_ARRAY_TYPE IS VARRAY(1000)
40: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;
41: TYPE LAST_UPD_LGN_ARRAY_TYPE IS VARRAY(1000)
42: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_LOGIN%TYPE;

Line 40: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;

36: OF CSD.CSD_MASS_RO_SN_ERRORS.CREATION_DATE%TYPE;
37: TYPE LAST_UPD_BY_ARRAY_TYPE IS VARRAY(1000)
38: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;
39: TYPE LAST_UPD_DT_ARRAY_TYPE IS VARRAY(1000)
40: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;
41: TYPE LAST_UPD_LGN_ARRAY_TYPE IS VARRAY(1000)
42: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_LOGIN%TYPE;
43: TYPE OBJ_VER_NUM_ARRAY_TYPE IS VARRAY(1000)
44: OF CSD.CSD_MASS_RO_SN_ERRORS.OBJECT_VERSION_NUMBER%TYPE;

Line 42: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_LOGIN%TYPE;

38: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;
39: TYPE LAST_UPD_DT_ARRAY_TYPE IS VARRAY(1000)
40: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;
41: TYPE LAST_UPD_LGN_ARRAY_TYPE IS VARRAY(1000)
42: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_LOGIN%TYPE;
43: TYPE OBJ_VER_NUM_ARRAY_TYPE IS VARRAY(1000)
44: OF CSD.CSD_MASS_RO_SN_ERRORS.OBJECT_VERSION_NUMBER%TYPE;
45:
46: --sn_errors_arr SN_ERRS_REC_ARRAY_TYPE;

Line 44: OF CSD.CSD_MASS_RO_SN_ERRORS.OBJECT_VERSION_NUMBER%TYPE;

40: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;
41: TYPE LAST_UPD_LGN_ARRAY_TYPE IS VARRAY(1000)
42: OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_LOGIN%TYPE;
43: TYPE OBJ_VER_NUM_ARRAY_TYPE IS VARRAY(1000)
44: OF CSD.CSD_MASS_RO_SN_ERRORS.OBJECT_VERSION_NUMBER%TYPE;
45:
46: --sn_errors_arr SN_ERRS_REC_ARRAY_TYPE;
47: mrs_error_id_arr MRS_ERROR_ID_ARRAY_TYPE;
48: mASS_RO_SN_id_arr MASS_RO_SN_ID_ARRAY_TYPE;

Line 77: FROM csd_mass_ro_sn_errors;

73: MASS_RO_SN_ERROR_ID, REPAIR_LINE_ID, MASS_RO_SN_ID,
74: ERROR_TYPE, ERROR_MSG, CREATED_BY,
75: CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
76: lAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER
77: FROM csd_mass_ro_sn_errors;
78:
79: CURSOR cur_check_exists(p_rep_line_id NUMBER, p_id2 NUMBER) IS
80: SELECT 'x'
81: FROM CSD_GENERIC_ERRMSGS

Line 108: SAVEPOINT CSD_MASS_RO_SN_ERRORS;

104: LAST_UPD_LGN_arr, OBJ_VER_NUM_arr;
105: --FOR j IN 1..sn_errors_arr.COUNT
106: FOR j IN 1..mrs_error_id_arr.COUNT
107: LOOP
108: SAVEPOINT CSD_MASS_RO_SN_ERRORS;
109:
110: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
112: 'CSD.PLSQL.CSD_Migrate_From_115X_PKG4.csd_generic_messages_mig4',

Line 157: ROLLBACK TO CSD_MASS_RO_SN_ERRORS;

153:
154: EXCEPTION
155: WHEN error_process THEN
156: CLOSE cur_check_exists;
157: ROLLBACK TO CSD_MASS_RO_SN_ERRORS;
158: v_error_text := substr(sqlerrm, 1, 1000)
159: || 'Mass ro sn Id:'
160: --|| sn_errors_arr(j).mass_ro_sn_error_id;
161: || mrs_error_id_arr(j);

Line 170: VALUES ('CSD_MASS_RO_SN_ERRORS',

166: ORIG_SYSTEM_REFERENCE_ID,
167: UPGRADE_DATETIME,
168: ERROR_MESSAGE,
169: MIGRATION_PHASE)
170: VALUES ('CSD_MASS_RO_SN_ERRORS',
171: 'CSD_GENERIC_ERRMSGS',
172: --sn_errors_arr(j).mass_ro_sn_error_id,
173: mrs_error_id_arr(j),
174: sysdate,