APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_WO_MILESTONES

Line 4673: DELETE MSC_WO_MILESTONES

4669:
4670: FOR c_rec IN c_del LOOP
4671: BEGIN
4672:
4673: DELETE MSC_WO_MILESTONES
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:

Line 4782: DELETE MSC_WO_MILESTONES

4778: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'IN LOAD MILESTONES- Inst :'||MSC_CL_COLLECTION.v_instance_id );
4779: FOR c_rec IN c_del LOOP
4780: BEGIN
4781:
4782: DELETE MSC_WO_MILESTONES
4783: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
4784: AND MILESTONE = c_rec.milestone
4785: AND VISIT_ID = c_rec.visit_id
4786: AND ORGANIZATION_ID = c_rec.organization_id;

Line 4805: UPDATE MSC_WO_MILESTONES

4801:
4802: BEGIN
4803:
4804: IF MSC_CL_COLLECTION.v_is_legacy_refresh THEN
4805: UPDATE MSC_WO_MILESTONES
4806: SET
4807: MILESTONE_DESC = c_rec.MILESTONE_DESC,
4808: REFRESH_ID = MSC_CL_COLLECTION.v_last_collection_id,
4809: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,

Line 4818: INSERT INTO MSC_WO_MILESTONES (

4814: AND ORGANIZATION_ID = c_rec.ORGANIZATION_ID;
4815:
4816: END IF;
4817: 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
4818: INSERT INTO MSC_WO_MILESTONES (
4819: MILESTONE,
4820: MILESTONE_DESC,
4821: VISIT_ID,
4822: ORGANIZATION_ID,