DBA Data[Home] [Help]

PACKAGE: APPS.ASO_BI_UTIL_PVT

Source


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;