DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_ELEMENTS_B

Line 905: FROM cs_kb_elements_b

901: pworker IN NUMBER DEFAULT 0)
902: IS
903: CURSOR delay_marked_stmts_batch_csr( c_batch_size NUMBER ) IS
904: SELECT element_id
905: FROM cs_kb_elements_b
906: -- 3679483
907: -- WHERE reindex_flag = 'Y'
908: WHERE reindex_flag = 'U'
909: -- 3679483 eof

Line 986: UPDATE cs_kb_elements_b

982: SET composite_text_index = 'U'
983: WHERE element_id = l_statement_id;
984:
985: -- Clear the delayed index mark on the statement
986: UPDATE cs_kb_elements_b
987: SET reindex_flag = NULL
988: WHERE element_id = l_statement_id;
989:
990: l_num_batch_rows_updated := l_num_batch_rows_updated + 1;