APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_USED_SUM_DEFS_B

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

1365: PROCEDURE update_set_count_sum (ERRBUF OUT NOCOPY VARCHAR2,
1366: RETCODE OUT NOCOPY NUMBER)
1367: AS
1368:
1369: TYPE list_of_def_id_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DEF_ID%TYPE
1370: INDEX BY BINARY_INTEGER;
1371: list_of_def_id list_of_def_id_type;
1372: TYPE list_of_days_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DAYS%TYPE
1373: INDEX BY BINARY_INTEGER;

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

1368:
1369: TYPE list_of_def_id_type IS TABLE OF CS_KB_USED_SUM_DEFS_B.DEF_ID%TYPE
1370: INDEX BY BINARY_INTEGER;
1371: list_of_def_id list_of_def_id_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;

Line 1390: FROM CS_KB_USED_SUM_DEFS_B;

1386: x_user_id := FND_GLOBAL.user_id;
1387: x_login_id := FND_GLOBAL.login_id;
1388:
1389: SELECT def_id, days BULK COLLECT INTO list_of_def_id, list_of_days
1390: FROM CS_KB_USED_SUM_DEFS_B;
1391:
1392: -- for each set
1393: FOR set_record IN set_cursor LOOP
1394:

Line 1462: FROM cs_kb_used_sum_defs_b);

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;
1465: retcode := 0;
1466: END update_set_count_sum;