APPS.PAY_BALANCE_PKG dependencies on DBMS_UTILITY

Line 397: dbms_utility.db_version(l_version, l_compatibility);

393: END IF;
394: -- check to see if the g_oracle_version already exists
395: IF g_oracle_version IS NULL THEN
396: -- get the current ORACLE version and compatibility values
397: dbms_utility.db_version(l_version, l_compatibility);
398: -- the oracle version number is held in the format:
399: -- x.x.x.x.x
400: -- set the version number to the first decimal position
401: -- e.g. 9.1.2.0.0 returns 9.1

Line 11502: l_start_time := dbms_utility.get_time;

11498: l_rb_status := 'Z';
11499: if (((p_assignment_id <> g_assignment_id) or (g_assignment_id is null)) or
11500: ((p_defined_balance_id <> g_defined_balance_id) or (g_defined_balance_id is null))) then --{ build gtab
11501: if g_debug then
11502: l_start_time := dbms_utility.get_time;
11503: hr_utility.set_location('pay_balance_pkg.run_balance_row_status. init gtab asg:'||p_assignment_id, 22);
11504: end if;
11505: g_assignment_id := p_assignment_id;
11506: g_defined_balance_id := p_defined_balance_id;

Line 11570: hr_utility.trace('gtab build rows:'||to_char(g_asg_actions_tab.count)||' time(hs):'||to_char(dbms_utility.get_time - l_start_time));

11566: group by assact.assignment_action_id order by assact.assignment_action_id;
11567: end if; --} primary balance
11568: end if; --} feeds exist
11569: if g_debug then
11570: hr_utility.trace('gtab build rows:'||to_char(g_asg_actions_tab.count)||' time(hs):'||to_char(dbms_utility.get_time - l_start_time));
11571: end if;
11572: end if; --} build gtab
11573:
11574: open csr_run_bal( p_defined_balance_id, p_assignment_action_id);

Line 11803: l_start_time := dbms_utility.get_time;

11799: l_rb_status := 'Z';
11800: if (((p_chunk_number <> g_chunk_number) or (g_chunk_number is null)) or
11801: ((p_defined_balance_id <> g_defined_balance_id) or (g_defined_balance_id is null))) then --{ build gtab
11802: if g_debug then
11803: l_start_time := dbms_utility.get_time;
11804: hr_utility.set_location('pay_balance_pkg.run_balance_row_status. init gtab chunk:'||p_chunk_number, 22);
11805: end if;
11806: g_chunk_number := p_chunk_number;
11807: g_defined_balance_id := p_defined_balance_id;

Line 11874: hr_utility.trace('gtab build rows:'||to_char(g_asg_actions_tab.count)||' time(hs):'||to_char(dbms_utility.get_time - l_start_time));

11870: group by assact.assignment_action_id order by assact.assignment_action_id;
11871: end if; --} primary balance
11872: end if; --} feeds exist
11873: if g_debug then
11874: hr_utility.trace('gtab build rows:'||to_char(g_asg_actions_tab.count)||' time(hs):'||to_char(dbms_utility.get_time - l_start_time));
11875: end if;
11876: end if; --} build gtab
11877:
11878: open csr_run_bal( p_defined_balance_id, p_assignment_action_id);