PACKAGE: APPS.ASO_BI_QOT_UTIL_PVT

Source

1 PACKAGE ASO_BI_QOT_UTIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: asovbiutls.pls 120.0 2005/05/31 01:27:03 appldev noship $  */
3 
4 -- Used to get conversion rate
5 FUNCTION GET_CUR_CONV_RATE(p_currency_code IN VARCHAR2,p_asof_date IN DATE)
6   RETURN NUMBER;
7 
8 -- Used for defaulting in parameter portlet
9 FUNCTION GET_DBI_PARAMS(p_region_id IN VARCHAR2) RETURN VARCHAR2;
10 
11 -- Parse and obtain the various input parameters
12 Procedure GET_PAGE_PARAMS(p_pmv_parameters IN BIS_PMV_PAGE_PARAMETER_TBL,
13                           x_conv_rate  OUT NOCOPY NUMBER,
14                           x_record_type_id OUT NOCOPY NUMBER,
15                           x_sysdate OUT NOCOPY DATE,
16                           x_sg_id OUT NOCOPY NUMBER,
17                           x_sr_id OUT NOCOPY NUMBER,
18                           x_asof_date  OUT NOCOPY DATE,
19                           x_priorasof_date OUT NOCOPY DATE,
20                           x_fdcp_date OUT NOCOPY DATE,
21                           x_fdpp_date OUT NOCOPY DATE,
22                           x_period_type OUT NOCOPY  VARCHAR2,
23                           x_comparision_type OUT NOCOPY  VARCHAR2,
24                           x_orderBy  OUT NOCOPY  VARCHAR2,
25                           x_sortBy   OUT NOCOPY VARCHAR2,
26                           x_viewby OUT NOCOPY VARCHAR2,
27                           x_prodcat_id OUT NOCOPY VARCHAR2,
28                           x_product_id OUT NOCOPY VARCHAR2);
29 
30 -- Write the query to log tables
31 PROCEDURE write_query (p_query IN VARCHAR2, p_module IN VARCHAR2);
32 
33 END ASO_BI_QOT_UTIL_PVT;