123:
124: FOR c_rec IN c_del LOOP
125: BEGIN
126:
127: DELETE MSC_WO_MILESTONES
128: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
129: AND VISIT_ID = c_rec.visit_id
130: AND ORGANIZATION_ID = c_rec.organization_id;
131:
1392: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
1393: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1394: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
1395: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
1396: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_MILESTONES',
1397: MSC_CL_COLLECTION.v_instance_id,
1398: -1);
1399: ELSE
1400: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1397: MSC_CL_COLLECTION.v_instance_id,
1398: -1);
1399: ELSE
1400: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1401: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_WO_MILESTONES',
1402: MSC_CL_COLLECTION.v_instance_id,
1403: null,
1404: v_sub_str);
1405: END IF;
1409: BEGIN
1410: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
1411: lv_tbl:= 'WO_MILESTONES_'||MSC_CL_COLLECTION.v_instance_code;
1412: ELSE
1413: lv_tbl:= 'MSC_WO_MILESTONES';
1414: END IF;
1415:
1416: lv_cursor_stmt:=
1417: 'INSERT INTO '||lv_tbl
1459: IF (MSC_CL_COLLECTION.v_is_incremental_refresh) OR
1460: MSC_CL_COLLECTION.v_is_legacy_refresh THEN
1461: FOR c_rec IN c_del LOOP
1462: BEGIN
1463: DELETE MSC_WO_MILESTONES
1464: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
1465: AND MILESTONE = c_rec.milestone
1466: AND VISIT_ID = c_rec.visit_id
1467: AND ORGANIZATION_ID = c_rec.organization_id;
1474: END;
1475: END LOOP;
1476: COMMIT;
1477: FOR c_rec IN c1 LOOP
1478: UPDATE MSC_WO_MILESTONES
1479: SET
1480: MILESTONE_DESC = c_rec.MILESTONE_DESC,
1481: EARLIEST_START_DATE = c_rec.EARLIEST_START_DATE,
1482: TARGET_COMPLETION_DATE = c_rec.TARGET_COMPLETION_DATE,
1541: END;
1542: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
1543: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
1544: lv_retcode,
1545: 'MSC_WO_MILESTONES',
1546: MSC_CL_COLLECTION.v_INSTANCE_CODE,
1547: MSC_UTIL.G_ERROR);
1548:
1549: IF lv_retcode = MSC_UTIL.G_ERROR THEN