1172:
1173: END IF; /* end (l_wt_target IS NOT NULL) */
1174:
1175: IF (p_mode = 'TOTAL') THEN
1176: DELETE jty_changed_terrs
1177: WHERE source_id = p_source_id
1178: AND star_request_id IS NOT NULL;
1179: ELSIF (p_mode = 'INCREMENTAL') THEN
1180: DELETE jty_changed_terrs
1176: DELETE jty_changed_terrs
1177: WHERE source_id = p_source_id
1178: AND star_request_id IS NOT NULL;
1179: ELSIF (p_mode = 'INCREMENTAL') THEN
1180: DELETE jty_changed_terrs
1181: WHERE source_id = p_source_id
1182: AND tap_request_id IS NOT NULL
1183: AND tap_request_id <> p_request_id;
1184:
1184:
1185: BEGIN
1186: SELECT 1
1187: INTO l_dummy
1188: FROM jty_changed_terrs
1189: WHERE source_id = p_source_id
1190: AND tap_request_id = p_request_id
1191: AND rownum <= 1;
1192: EXCEPTION
1190: AND tap_request_id = p_request_id
1191: AND rownum <= 1;
1192: EXCEPTION
1193: WHEN NO_DATA_FOUND THEN
1194: UPDATE jty_changed_terrs
1195: SET tap_request_id = p_request_id
1196: WHERE source_id = p_source_id
1197: AND star_request_id IS NOT NULL;
1198: END;