1 PACKAGE ASO_BI_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: asovbildutls.pls 120.0 2005/05/31 01:27:35 appldev noship $ */
3
4 --This is the Initial Procedure to find the schema owner and tablespace
5
6 PROCEDURE INIT;
7
8 --This is used for Truncating Tables
9
10 PROCEDURE Truncate_Table(p_table_name IN VARCHAR2);
11
12
13 --This is used for Analysing Tables
14
15 Procedure Analyze_Table(p_table_Name IN VARCHAR2);
16
17 --This is a wrapper function for parallel execution
18
19 FUNCTION get_closest_rate_sql (
20 x_from_currency VARCHAR2,
21 x_to_currency VARCHAR2,
22 x_conversion_date DATE,
23 x_conversion_type VARCHAR2 DEFAULT NULL,
24 x_max_roll_days NUMBER ) RETURN NUMBER PARALLEL_ENABLE;
25
26
27 END ASO_BI_UTIL_PVT;