DBA Data[Home] [Help]

APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_CACHE_STATS_S

Line 1589: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,

1585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1587:
1588: p_cache_stat_id OUT NOCOPY jtf_prefab_cache_stats.cache_stat_id%TYPE,
1589: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,
1590: p_wsh_po_id IN jtf_prefab_cache_stats.wsh_po_id%TYPE,
1591: p_ca_comp_id IN jtf_prefab_cache_stats.ca_comp_id%TYPE,
1592: p_jvm_id IN jtf_prefab_cache_stats.jvm_id%TYPE,
1593: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%TYPE,

Line 1600: p_start_time IN jtf_prefab_cache_stats.start_time%TYPE,

1596: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%TYPE,
1597: p_num_invalidations IN jtf_prefab_cache_stats.num_invalidations%TYPE,
1598: p_num_objects IN jtf_prefab_cache_stats.num_objects%TYPE,
1599: p_expiration_time IN jtf_prefab_cache_stats.expiration_time%TYPE,
1600: p_start_time IN jtf_prefab_cache_stats.start_time%TYPE,
1601: p_end_time IN jtf_prefab_cache_stats.end_time%TYPE,
1602:
1603: p_object_version_number OUT NOCOPY jtf_prefab_cache_stats.object_version_number%TYPE,
1604:

Line 1614: SELECT jtf_prefab_cache_stats_s.NEXTVAL from dual;

1610: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_CACHE_STAT';
1611: l_api_version NUMBER := p_api_version;
1612:
1613: CURSOR sequence_cursor IS
1614: SELECT jtf_prefab_cache_stats_s.NEXTVAL from dual;
1615: BEGIN
1616: -- Standard Start of API savepoint
1617: SAVEPOINT INSERT_CACHE_STAT;
1618:

Line 1736: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,

1732: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1733: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1734:
1735: p_cache_stat_id IN jtf_prefab_cache_stats.cache_stat_id%TYPE,
1736: p_security_group_id IN jtf_prefab_cache_stats.security_group_id%TYPE,
1737: p_wsh_po_id IN jtf_prefab_cache_stats.wsh_po_id%TYPE,
1738: p_ca_comp_id IN jtf_prefab_cache_stats.ca_comp_id%TYPE,
1739: p_jvm_id IN jtf_prefab_cache_stats.jvm_id%TYPE,
1740: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%TYPE,

Line 1747: p_start_time IN jtf_prefab_cache_stats.start_time%TYPE,

1743: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%TYPE,
1744: p_num_invalidations IN jtf_prefab_cache_stats.num_invalidations%TYPE,
1745: p_num_objects IN jtf_prefab_cache_stats.num_objects%TYPE,
1746: p_expiration_time IN jtf_prefab_cache_stats.expiration_time%TYPE,
1747: p_start_time IN jtf_prefab_cache_stats.start_time%TYPE,
1748: p_end_time IN jtf_prefab_cache_stats.end_time%TYPE,
1749:
1750: p_object_version_number IN OUT NOCOPY jtf_prefab_cache_stats.object_version_number%TYPE,
1751: