APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SET_USED_SUMS

Line 1227: v_used_count CS_KB_SET_USED_SUMS.USED_COUNT%TYPE;

1223: TYPE list_of_days_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DAYS%TYPE
1224: INDEX BY BINARY_INTEGER;
1225: list_of_days list_of_days_type;
1226: i NUMBER(10);
1227: v_used_count CS_KB_SET_USED_SUMS.USED_COUNT%TYPE;
1228: current_date DATE;
1229: whether_exist NUMBER:=0;
1230: x_user_id NUMBER;
1231: x_login_id NUMBER;

Line 1262: FROM CS_KB_SET_USED_SUMS

1258: IF(v_used_count> 0) THEN
1259:
1260: -- insert or update to set_used_sum
1261: SELECT count(SET_ID) INTO whether_exist
1262: FROM CS_KB_SET_USED_SUMS
1263: WHERE SET_ID=set_record.SET_ID AND DEF_ID=list_of_def_id(i);
1264:
1265: IF (whether_exist=0) THEN
1266:

Line 1267: INSERT INTO CS_KB_SET_USED_SUMS (

1263: WHERE SET_ID=set_record.SET_ID AND DEF_ID=list_of_def_id(i);
1264:
1265: IF (whether_exist=0) THEN
1266:
1267: INSERT INTO CS_KB_SET_USED_SUMS (
1268: SET_ID,
1269: DEF_ID,
1270: USED_COUNT,
1271: CREATION_DATE,

Line 1289: UPDATE CS_KB_SET_USED_SUMS SET

1285: );
1286:
1287: ELSE
1288:
1289: UPDATE CS_KB_SET_USED_SUMS SET
1290: USED_COUNT=v_used_count,
1291: LAST_UPDATE_DATE=current_date,
1292: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1293: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))

Line 1300: DELETE FROM CS_KB_SET_USED_SUMS

1296: END IF;
1297:
1298: ELSIF v_used_count = 0 THEN
1299:
1300: DELETE FROM CS_KB_SET_USED_SUMS
1301: WHERE set_id = set_record.set_id
1302: AND def_id = list_of_def_id(i);
1303:
1304: END IF;

Line 1311: DELETE FROM cs_kb_set_used_sums

1307: END LOOP;
1308: END LOOP;
1309:
1310: --clean up deleted summary definition entries
1311: DELETE FROM cs_kb_set_used_sums
1312: WHERE def_id NOT IN (SELECT def_id
1313: FROM cs_kb_used_sum_defs_b);
1314:
1315: COMMIT;