[Home] [Help]
PACKAGE: APPS.BIL_BI_UTIL_COLLECTION_PKG
Source
1 PACKAGE bil_bi_util_collection_pkg AS
2 /*$Header: bilbutcs.pls 120.1 2006/03/27 22:04:46 jmahendr noship $*/
3
4 -- **********************************************************************
5 -- FUNCTION get_schema_name
6 --
7 -- Purpose:
8 -- To retrieve the schema name for the given Application Short Name
9 --
10 -- **********************************************************************
11
12 FUNCTION get_schema_name(p_appl_name IN VARCHAR2)
13 RETURN VARCHAR2;
14
15
16 -- **********************************************************************
17 -- FUNCTION get_apps_schema_name
18 --
19 -- Purpose:
20 -- To retrieve the apps schema name
21 --
22 -- **********************************************************************
23
24 FUNCTION get_apps_schema_name RETURN VARCHAR2;
25
26
27
28 -- **********************************************************************
29 -- PROCEDURE analyze_table
30 --
31 -- Purpose:
32 -- To Analyze the input Sales Intelligence table from the BIL
33 -- schema
34 --
35 -- **********************************************************************
36
37 PROCEDURE analyze_table (p_tbl_name IN VARCHAR2,
38 p_cascade IN BOOLEAN,
39 p_est_pct IN NUMBER,
40 p_granularity IN VARCHAR2);
41
42
43 -- ********************************************************************
44 -- PROCEDURE truncate_table
45 --
46 -- Purpose:
47 -- To remove all the records from the table specified.
48 --
49 -- ********************************************************************
50
51 PROCEDURE truncate_table (p_table_name IN varchar2);
52
53
54 -- ********************************************************************
55 -- PROCEDURE drop_table
56 --
57 -- Purpose:
58 -- To drop the table specified.
59 --
60 -- ********************************************************************
61
62 PROCEDURE drop_table (p_table_name IN varchar2) ;
63
64 -- ********************************************************************
65 -- FUNCTION get_profile_value
66 --
67 -- Purpose:
68 -- To get the profile value of the specified parameter
69 --
70 -- ********************************************************************
71
72 FUNCTION get_profile_value (p_profile_parameter IN VARCHAR2)
73 RETURN VARCHAR2 ;
74
75
76 -- **********************************************************************
77 -- FUNCTION chkLogLevel
78 --
79 -- Purpose
80 -- To check if log is Enabled for Messages
81 -- This function is a wrapper on FND APIs for OA Common Error
82 -- logging framework
83 --
84 -- p_log_level = Severity; valid values are -
85 -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
86 -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
87 -- 3. Event Level (FND_LOG.LEVEL_EVENT)
88 -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
89 -- 5. Error Level (FND_LOG.LEVEL_ERROR)
90 -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
91 --
92 -- Output values:-
93 -- = TRUE if FND Log is Enabled or BIS Log is Enabled
94 -- = FALSE if both are DISABLED
95 --
96 --
97 -- **********************************************************************
98
99 FUNCTION chkLogLevel (p_log_level IN NUMBER) RETURN BOOLEAN;
100
101
102
103 -- **********************************************************************
104 -- PROCEDURE writeLog
105 --
106 -- Purpose:
107 -- To log Messages
108 -- This procedure is a wrapper on FND APIs for OA Common Error
109 -- logging framework for Severity = Statement(1), Procedure(2)
110 -- , Event(3), Expected (4) and Error (5)
111 --
112 -- Input Variables :-
113 -- p_log_level = Severity; valid values are -
114 -- 1. Statement Level (FND_LOG.LEVEL_STATEMENT)
115 -- 2. Procedure Level (FND_LOG.LEVEL_PROCEDURE)
116 -- 3. Event Level (FND_LOG.LEVEL_EVENT)
117 -- 4. Exception Level (FND_LOG.LEVEL_EXCEPTION)
118 -- 5. Error Level (FND_LOG.LEVEL_ERROR)
119 -- 6. Unexpected Level (FND_LOG.LEVEL_UNEXPECTED)
120 -- p_module = Module Source Details
121 -- p_msg = Message String
122 -- p_force_log = Force message in log file. Default False.
123 --
124 -- **********************************************************************
125
126 PROCEDURE writeLog (p_log_level IN NUMBER,
127 p_module IN VARCHAR2,
128 p_msg IN VARCHAR2,
129 p_force_log IN BOOLEAN DEFAULT FALSE);
130
131
132
133 -- **********************************************************************
134 -- FUNCTION get_user_profile_name
135 --
136 -- Purpose
137 -- To return the User PRofile Name
138 --
139 -- Input value = p_profile_name = Profile Name
140 --
141 -- Output values:-
142 -- = Profile Option Name for the User
143 --
144 --
145 -- **********************************************************************
146
147
148 FUNCTION get_user_profile_name (p_profile_name IN VARCHAR2) RETURN VARCHAR2;
149
150 FUNCTION get_global_rate_p (code IN varchar2, rate_Date IN date) RETURN NUMBER PARALLEL_ENABLE;
151
152 FUNCTION get_global_rate_s (code IN varchar2, rate_Date IN date) RETURN NUMBER PARALLEL_ENABLE;
153
154 END bil_bi_util_collection_pkg;
155