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.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_VISITS

Line 4678: DELETE MSC_VISITS

4674: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
4675: AND VISIT_ID = c_rec.visit_id
4676: AND ORGANIZATION_ID = c_rec.organization_id;
4677:
4678: DELETE MSC_VISITS
4679: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
4680: AND VISIT_ID = c_rec.visit_id
4681: AND ORGANIZATION_ID = c_rec.organization_id;
4682:

Line 4698: UPDATE MSC_VISITS

4694:
4695: BEGIN
4696:
4697: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
4698: UPDATE MSC_VISITS
4699: SET
4700: VISIT_DESC = c_rec.VISIT_DESC,
4701: VISIT_START_DATE = c_rec.VISIT_START_DATE,
4702: VISIT_END_DATE = c_rec.VISIT_END_DATE,

Line 4713: INSERT INTO MSC_VISITS (

4709:
4710: END IF;
4711:
4712: IF (MSC_CL_COLLECTION.v_is_complete_refresh or MSC_CL_COLLECTION.v_is_partial_refresh) OR (MSC_CL_COLLECTION.v_is_legacy_refresh AND SQL%NOTFOUND) THEN
4713: INSERT INTO MSC_VISITS (
4714: VISIT_ID,
4715: VISIT_NAME,
4716: VISIT_DESC,
4717: VISIT_START_DATE,