APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_CHANGED_TERRS

Line 1102: DELETE jty_changed_terrs

1098:
1099: END IF; /* end (l_wt_target IS NOT NULL) */
1100:
1101: IF (p_mode = 'TOTAL') THEN
1102: DELETE jty_changed_terrs
1103: WHERE source_id = p_source_id
1104: AND star_request_id IS NOT NULL;
1105: ELSIF (p_mode = 'INCREMENTAL') THEN
1106: DELETE jty_changed_terrs

Line 1106: DELETE jty_changed_terrs

1102: DELETE jty_changed_terrs
1103: WHERE source_id = p_source_id
1104: AND star_request_id IS NOT NULL;
1105: ELSIF (p_mode = 'INCREMENTAL') THEN
1106: DELETE jty_changed_terrs
1107: WHERE source_id = p_source_id
1108: AND tap_request_id IS NOT NULL
1109: AND tap_request_id <> p_request_id;
1110:

Line 1114: FROM jty_changed_terrs

1110:
1111: BEGIN
1112: SELECT 1
1113: INTO l_dummy
1114: FROM jty_changed_terrs
1115: WHERE source_id = p_source_id
1116: AND tap_request_id = p_request_id
1117: AND rownum <= 1;
1118: EXCEPTION

Line 1120: UPDATE jty_changed_terrs

1116: AND tap_request_id = p_request_id
1117: AND rownum <= 1;
1118: EXCEPTION
1119: WHEN NO_DATA_FOUND THEN
1120: UPDATE jty_changed_terrs
1121: SET tap_request_id = p_request_id
1122: WHERE source_id = p_source_id
1123: AND star_request_id IS NOT NULL;
1124: END;