APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SET_USED_SUMS

Line 1376: v_used_count CS_KB_SET_USED_SUMS.USED_COUNT%TYPE;

1372: TYPE list_of_days_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DAYS%TYPE
1373: INDEX BY BINARY_INTEGER;
1374: list_of_days list_of_days_type;
1375: i NUMBER(10);
1376: v_used_count CS_KB_SET_USED_SUMS.USED_COUNT%TYPE;
1377: current_date DATE;
1378: whether_exist NUMBER:=0;
1379: x_user_id NUMBER;
1380: x_login_id NUMBER;

Line 1411: FROM CS_KB_SET_USED_SUMS

1407: IF(v_used_count> 0) THEN
1408:
1409: -- insert or update to set_used_sum
1410: SELECT count(SET_ID) INTO whether_exist
1411: FROM CS_KB_SET_USED_SUMS
1412: WHERE SET_ID=set_record.SET_ID AND DEF_ID=list_of_def_id(i);
1413:
1414: IF (whether_exist=0) THEN
1415:

Line 1416: INSERT INTO CS_KB_SET_USED_SUMS (

1412: WHERE SET_ID=set_record.SET_ID AND DEF_ID=list_of_def_id(i);
1413:
1414: IF (whether_exist=0) THEN
1415:
1416: INSERT INTO CS_KB_SET_USED_SUMS (
1417: SET_ID,
1418: DEF_ID,
1419: USED_COUNT,
1420: CREATION_DATE,

Line 1438: UPDATE CS_KB_SET_USED_SUMS SET

1434: );
1435:
1436: ELSE
1437:
1438: UPDATE CS_KB_SET_USED_SUMS SET
1439: USED_COUNT=v_used_count,
1440: LAST_UPDATE_DATE=current_date,
1441: LAST_UPDATED_BY=x_user_id, --to_number(FND_PROFILE.VALUE ('USER_ID')),
1442: LAST_UPDATE_LOGIN=x_login_id --to_number(FND_PROFILE.VALUE('LOGIN_ID'))

Line 1449: DELETE FROM CS_KB_SET_USED_SUMS

1445: END IF;
1446:
1447: ELSIF v_used_count = 0 THEN
1448:
1449: DELETE FROM CS_KB_SET_USED_SUMS
1450: WHERE set_id = set_record.set_id
1451: AND def_id = list_of_def_id(i);
1452:
1453: END IF;

Line 1460: DELETE FROM cs_kb_set_used_sums

1456: END LOOP;
1457: END LOOP;
1458:
1459: --clean up deleted summary definition entries
1460: DELETE FROM cs_kb_set_used_sums
1461: WHERE def_id NOT IN (SELECT def_id
1462: FROM cs_kb_used_sum_defs_b);
1463:
1464: COMMIT;