APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SETS_B

Line 41: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

37: )
38: IS
39: CURSOR all_published_solutions IS
40: SELECT tl.rowid -- tl.set_id
41: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
42: WHERE b.set_id = tl.set_id
43: AND b.status = 'PUB';
44:
45:

Line 845: FROM cs_kb_sets_b

841: attachment IN VARCHAR2)
842: IS
843: CURSOR delay_marked_solns_batch_csr( c_batch_size NUMBER ) IS
844: SELECT set_id
845: FROM cs_kb_sets_b
846: -- 3679483
847: -- WHERE reindex_flag = 'Y'
848: WHERE reindex_flag = 'U'
849: -- 3679483 eof

Line 980: UPDATE cs_kb_sets_b

976: --END IF;
977: --12.1.3
978:
979: -- Clear the delayed index mark on the solution
980: UPDATE cs_kb_sets_b
981: SET reindex_flag = NULL
982: WHERE set_id = l_solution_id;
983:
984: l_num_batch_rows_updated := l_num_batch_rows_updated + 1;

Line 1383: SELECT SET_ID FROM CS_KB_SETS_B;

1379: x_user_id NUMBER;
1380: x_login_id NUMBER;
1381:
1382: CURSOR set_cursor IS
1383: SELECT SET_ID FROM CS_KB_SETS_B;
1384: BEGIN
1385: SELECT SysDate INTO current_date FROM dual;
1386: x_user_id := FND_GLOBAL.user_id;
1387: x_login_id := FND_GLOBAL.login_id;

Line 1586: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

1582: retcode OUT nocopy NUMBER )
1583: IS
1584: CURSOR all_published_solutions IS
1585: SELECT tl.set_id
1586: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
1587: WHERE b.set_id = tl.set_id
1588: AND b.status = 'PUB';
1589: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;
1590: solnIdList solnIdListType;