[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATED_BY%TYPE;
OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_DATE%TYPE;
OF CSD.CSD_MASS_RO_SN_ERRORS.LAST_UPDATE_LOGIN%TYPE;
SELECT
MASS_RO_SN_ERROR_ID, REPAIR_LINE_ID, MASS_RO_SN_ID,
ERROR_TYPE, ERROR_MSG, CREATED_BY,
CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE,
lAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER
FROM csd_mass_ro_sn_errors;
SELECT 'x'
FROM CSD_GENERIC_ERRMSGS
WHERE MODULE_CODE ='SN'
AND SOURCE_ENTITY_ID1= p_rep_line_id
AND SOURCE_ENTITY_ID2 = p_id2
AND SOURCE_ENTITY_TYPE_CODE = 'SERIAL_NUMBER';
APPS.CSD_GENERIC_ERRMSGS_PKG.INSERT_ROW(PX_GENERIC_ERRMSGS_ID => l_generic_errmsgs_id,
P_MODULE_CODE => 'SN',
--P_SOURCE_ENTITY_ID1 => sn_errors_arr(j).repair_line_id,
P_SOURCE_ENTITY_ID1 => repair_line_id_arr(j),
--P_SOURCE_ENTITY_ID2 => sn_errors_arr(j).mass_ro_sn_id,
P_SOURCE_ENTITY_ID2 => mass_ro_sn_id_arr(j),
P_SOURCE_ENTITY_TYPE_CODE => 'SERIAL_NUMBER',
P_MSG_TYPE_CODE => 'E',
--P_MSG => sn_errors_arr(j).ERROR_MSG,
P_MSG => ERROR_MSG_arr(j),
P_MSG_STATUS => 'O',
P_CREATED_BY => fnd_global.user_id,
P_CREATION_DATE => sysdate,
P_LAST_UPDATED_BY => fnd_global.user_id,
P_LAST_UPDATE_DATE => sysdate,
P_LAST_UPDATE_LOGIN => fnd_global.login_id,
P_OBJECT_VERSION_NUMBER => 1);
INSERT INTO CSD_UPG_ERRORS
(ORIG_SYSTEM_REFERENCE,
TARGET_SYSTEM_REFERENCE,
ORIG_SYSTEM_REFERENCE_ID,
UPGRADE_DATETIME,
ERROR_MESSAGE,
MIGRATION_PHASE)
VALUES ('CSD_MASS_RO_SN_ERRORS',
'CSD_GENERIC_ERRMSGS',
--sn_errors_arr(j).mass_ro_sn_error_id,
mrs_error_id_arr(j),
sysdate,
v_error_text,
'11.5.10');
raise_application_error( -20000, 'Error while migrating CSD_GENERIC_ERRMSGS table data: Error while inserting into CSD_GENERIC_ERRMSGS. '|| v_error_text);