APPS.PAY_PST_UTILS dependencies on DBMS_UTILITY

Line 6: g_last_time NUMBER := dbms_utility.get_time;

2: /* $Header: pypstutl.pkb 120.0 2006/06/07 02:14:56 exjones noship $ */
3: --
4: g_last_batch_id NUMBER := -1;
5: g_last_api_id NUMBER := -1;
6: g_last_time NUMBER := dbms_utility.get_time;
7: g_cache_age NUMBER := 1000; -- In hundredths of a second
8: --
9: g_batch_status VARCHAR2(30) := 'BATCH_STATUS_UNKNOWN';
10: g_percent_complete NUMBER := -1;

Line 103: g_last_time + g_cache_age < dbms_utility.get_time

99: l_phase VARCHAR2(30);
100: --
101: BEGIN
102: IF p_batch_id <> g_last_batch_id OR
103: g_last_time + g_cache_age < dbms_utility.get_time
104: THEN
105: g_last_time := dbms_utility.get_time;
106: g_last_batch_id := p_batch_id;
107: --

Line 105: g_last_time := dbms_utility.get_time;

101: BEGIN
102: IF p_batch_id <> g_last_batch_id OR
103: g_last_time + g_cache_age < dbms_utility.get_time
104: THEN
105: g_last_time := dbms_utility.get_time;
106: g_last_batch_id := p_batch_id;
107: --
108: OPEN csr_count(p_batch_id);
109: FETCH csr_count

Line 206: g_last_time + g_cache_age < dbms_utility.get_time

202: cache_batch_data(p_batch_id);
203: --
204: IF p_batch_id <> l_last_batch_id OR
205: p_api_id <> g_last_api_id OR
206: g_last_time + g_cache_age < dbms_utility.get_time
207: THEN
208: g_last_time := dbms_utility.get_time;
209: g_last_batch_id := p_batch_id;
210: g_last_api_id := p_api_id;

Line 208: g_last_time := dbms_utility.get_time;

204: IF p_batch_id <> l_last_batch_id OR
205: p_api_id <> g_last_api_id OR
206: g_last_time + g_cache_age < dbms_utility.get_time
207: THEN
208: g_last_time := dbms_utility.get_time;
209: g_last_batch_id := p_batch_id;
210: g_last_api_id := p_api_id;
211: --
212: OPEN csr_count(p_batch_id,p_api_id);