APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_USED_SUM_DEFS_B

Line 1220: TYPE list_of_def_id_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DEF_ID%TYPE

1216: PROCEDURE update_set_count_sum (ERRBUF OUT NOCOPY VARCHAR2,
1217: RETCODE OUT NOCOPY NUMBER)
1218: AS
1219:
1220: TYPE list_of_def_id_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DEF_ID%TYPE
1221: INDEX BY BINARY_INTEGER;
1222: list_of_def_id list_of_def_id_type;
1223: TYPE list_of_days_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DAYS%TYPE
1224: INDEX BY BINARY_INTEGER;

Line 1223: TYPE list_of_days_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DAYS%TYPE

1219:
1220: TYPE list_of_def_id_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DEF_ID%TYPE
1221: INDEX BY BINARY_INTEGER;
1222: list_of_def_id list_of_def_id_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;

Line 1241: FROM CS_KB_USED_SUM_DEFS_B;

1237: x_user_id := FND_GLOBAL.user_id;
1238: x_login_id := FND_GLOBAL.login_id;
1239:
1240: SELECT def_id, days BULK COLLECT INTO list_of_def_id, list_of_days
1241: FROM CS_KB_USED_SUM_DEFS_B;
1242:
1243: -- for each set
1244: FOR set_record IN set_cursor LOOP
1245:

Line 1313: FROM cs_kb_used_sum_defs_b);

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;
1316: retcode := 0;
1317: END update_set_count_sum;