eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PREFAB_CACHE_PUB dependencies on JTF_PREFAB_CACHE_STATS

Line 1588: p_cache_stat_id OUT NOCOPY jtf_prefab_cache_stats.cache_stat_id%TYPE,

1584: p_api_version IN NUMBER,
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,

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 1590: p_wsh_po_id IN jtf_prefab_cache_stats.wsh_po_id%TYPE,

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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,

Line 1591: p_ca_comp_id IN jtf_prefab_cache_stats.ca_comp_id%TYPE,

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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%TYPE,

Line 1592: p_jvm_id IN jtf_prefab_cache_stats.jvm_id%TYPE,

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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%TYPE,
1596: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%TYPE,

Line 1593: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1596: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1597: p_num_invalidations IN jtf_prefab_cache_stats.num_invalidations%TYPE,

1593: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%TYPE,
1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1598: p_num_objects IN jtf_prefab_cache_stats.num_objects%TYPE,

1594: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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:

Line 1599: p_expiration_time IN jtf_prefab_cache_stats.expiration_time%TYPE,

1595: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

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 1601: p_end_time IN jtf_prefab_cache_stats.end_time%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:
1605: x_return_status OUT NOCOPY VARCHAR2,

Line 1603: p_object_version_number OUT NOCOPY jtf_prefab_cache_stats.object_version_number%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:
1605: x_return_status OUT NOCOPY VARCHAR2,
1606: x_msg_count OUT NOCOPY NUMBER,
1607: x_msg_data OUT NOCOPY VARCHAR2

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 1645: INSERT INTO jtf_prefab_cache_stats(cache_stat_id,

1641: FETCH sequence_cursor INTO p_cache_stat_id;
1642: CLOSE sequence_cursor;
1643: p_object_version_number := 1;
1644:
1645: INSERT INTO jtf_prefab_cache_stats(cache_stat_id,
1646: object_version_number,
1647: created_by,
1648: creation_date,
1649: last_updated_by,

Line 1735: p_cache_stat_id IN jtf_prefab_cache_stats.cache_stat_id%TYPE,

1731: p_api_version IN NUMBER,
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,

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 1737: p_wsh_po_id IN jtf_prefab_cache_stats.wsh_po_id%TYPE,

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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,

Line 1738: p_ca_comp_id IN jtf_prefab_cache_stats.ca_comp_id%TYPE,

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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%TYPE,

Line 1739: p_jvm_id IN jtf_prefab_cache_stats.jvm_id%TYPE,

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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%TYPE,
1743: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%TYPE,

Line 1740: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1743: p_num_invalidate_call IN jtf_prefab_cache_stats.num_invalidate_call%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,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1744: p_num_invalidations IN jtf_prefab_cache_stats.num_invalidations%TYPE,

1740: p_num_cache_miss IN jtf_prefab_cache_stats.num_cache_miss%TYPE,
1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

Line 1745: p_num_objects IN jtf_prefab_cache_stats.num_objects%TYPE,

1741: p_num_cache_hit IN jtf_prefab_cache_stats.num_cache_hit%TYPE,
1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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:

Line 1746: p_expiration_time IN jtf_prefab_cache_stats.expiration_time%TYPE,

1742: p_num_loader_miss IN jtf_prefab_cache_stats.num_loader_miss%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,

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:

Line 1748: p_end_time IN jtf_prefab_cache_stats.end_time%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:
1752: x_return_status OUT NOCOPY VARCHAR2,

Line 1750: p_object_version_number IN OUT NOCOPY jtf_prefab_cache_stats.object_version_number%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:
1752: x_return_status OUT NOCOPY VARCHAR2,
1753: x_msg_count OUT NOCOPY NUMBER,
1754: x_msg_data OUT NOCOPY VARCHAR2

Line 1785: UPDATE jtf_prefab_cache_stats

1781:
1782: -- real logic --
1783: ----------------
1784:
1785: UPDATE jtf_prefab_cache_stats
1786: SET object_version_number = p_object_version_number,
1787: last_updated_by = G_USER_ID,
1788: last_update_date = SYSDATE,
1789: last_update_login = G_LOGIN_ID,

Line 1888: UPDATE jtf_prefab_cache_stats

1884:
1885: -- real logic --
1886: ----------------
1887:
1888: UPDATE jtf_prefab_cache_stats
1889: SET end_time = GREATEST(expiration_time, sysdate), num_objects = 0
1890: WHERE expiration_time < sysdate and
1891: end_time < start_time;
1892:

Line 1977: DELETE FROM jtf_prefab_cache_stats

1973:
1974: -- real logic --
1975: ----------------
1976:
1977: DELETE FROM jtf_prefab_cache_stats
1978: WHERE wsh_po_id = p_wsh_po_id and
1979: ca_comp_id = p_ca_comp_id and
1980: expiration_time < sysdate;
1981:

Line 1982: UPDATE jtf_prefab_cache_stats

1978: WHERE wsh_po_id = p_wsh_po_id and
1979: ca_comp_id = p_ca_comp_id and
1980: expiration_time < sysdate;
1981:
1982: UPDATE jtf_prefab_cache_stats
1983: SET num_cache_miss = 0, num_cache_hit = 0, num_loader_miss = 0,
1984: num_invalidate_call = 0, num_invalidations = 0, num_objects = 0,
1985: start_time = sysdate
1986: WHERE wsh_po_id = p_wsh_po_id and