APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SETS_B

Line 39: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

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

Line 741: FROM cs_kb_sets_b

737: pworker IN NUMBER DEFAULT 0)
738: IS
739: CURSOR delay_marked_solns_batch_csr( c_batch_size NUMBER ) IS
740: SELECT set_id
741: FROM cs_kb_sets_b
742: -- 3679483
743: -- WHERE reindex_flag = 'Y'
744: WHERE reindex_flag = 'U'
745: -- 3679483 eof

Line 831: UPDATE cs_kb_sets_b

827: SET composite_assoc_index = 'U'
828: WHERE set_id = l_solution_id;
829:
830: -- Clear the delayed index mark on the solution
831: UPDATE cs_kb_sets_b
832: SET reindex_flag = NULL
833: WHERE set_id = l_solution_id;
834:
835: l_num_batch_rows_updated := l_num_batch_rows_updated + 1;

Line 1234: SELECT SET_ID FROM CS_KB_SETS_B;

1230: x_user_id NUMBER;
1231: x_login_id NUMBER;
1232:
1233: CURSOR set_cursor IS
1234: SELECT SET_ID FROM CS_KB_SETS_B;
1235: BEGIN
1236: SELECT SysDate INTO current_date FROM dual;
1237: x_user_id := FND_GLOBAL.user_id;
1238: x_login_id := FND_GLOBAL.login_id;

Line 1437: FROM cs_kb_sets_tl tl, cs_kb_sets_b b

1433: retcode OUT nocopy NUMBER )
1434: IS
1435: CURSOR all_published_solutions IS
1436: SELECT tl.set_id
1437: FROM cs_kb_sets_tl tl, cs_kb_sets_b b
1438: WHERE b.set_id = tl.set_id
1439: AND b.status = 'PUB';
1440: TYPE solnIdListType IS TABLE OF cs_kb_sets_tl.set_id%TYPE INDEX BY BINARY_INTEGER;
1441: solnIdList solnIdListType;