DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_CACHE_STATS

Line 48: FROM qp_cache_stats;

44: FROM qp_cache_do_sizes;
45:
46: CURSOR cache_stat_csr IS
47: SELECT count(*)
48: FROM qp_cache_stats;
49:
50: CURSOR header_csr IS
51: SELECT count(*)
52: FROM qp_list_headers_b

Line 775: Insert into qp_cache_stats;

771: l_min_size := l_perm_size + greatest(l_max_cache_key_size(L_MODIFIER_CACHE_KEY), l_max_cache_key_size(L_PRICE_CACHE_KEY), l_max_cache_key_size(L_FORMULA_CACHE_KEY), l_max_cache_key_size(L_FACTOR_CACHE_KEY));
772:
773:
774: /*****************************************************************
775: Insert into qp_cache_stats;
776: *****************************************************************/
777:
778: l_cache_type_tbl(1) := 'FULL_SIZE';
779: l_cache_size_tbl(1) := l_full_size;

Line 845: DELETE FROM qp_cache_stats;

841: l_program_upd_date_final_tbl(i) := sysdate;
842: l_request_id_final_tbl(i) := FND_GLOBAL.CONC_REQUEST_ID;
843: END LOOP;
844:
845: DELETE FROM qp_cache_stats;
846:
847: forall i in 1..l_cache_type_tbl.last
848: INSERT INTO qp_cache_stats (
849: name,

Line 848: INSERT INTO qp_cache_stats (

844:
845: DELETE FROM qp_cache_stats;
846:
847: forall i in 1..l_cache_type_tbl.last
848: INSERT INTO qp_cache_stats (
849: name,
850: value,
851: CREATION_DATE,
852: CREATED_BY,