[Home] [Help]
PACKAGE: APPS.BIS_COLLECTION_UTILITIES
Source
1 package BIS_COLLECTION_UTILITIES AS
2 /*$Header: BISDBUTS.pls 120.0 2005/06/01 16:41:26 appldev noship $*/
3
4 g_debug Boolean;
5
6 /* removed EDW_TRACE and g_trace for bug3320661
7 g_trace Boolean;
8 */
9
10 g_hash_area_size NUMBER;
11 g_sort_area_size NUMBER;
12 g_parallel NUMBER;
13 g_op_table_space dba_tablespaces.tablespace_name%TYPE; --??? size
14 g_status boolean;
15 g_status_message varchar2(30000);
16 g_object_name varchar2(400);
17 g_start_date date;
18 g_request_id number;
19 g_concurrent_id number;
20 g_user_id PLS_INTEGER := 0;
21 g_login_id PLS_INTEGER := 0;
22 g_space varchar2(30) := ' ';
23 g_line varchar2(30) := '-------------------------';
24 g_indenting varchar2(10) := ' ';
25 g_length_rate_type number := 12;
26 g_length_from_currency number := 17;
27 g_length_to_currency number := 15;
28 g_length_date number := 20;
29 g_length_from_to_uom number := 15;
30 g_length_inventory_item number := 19;
31
32 g_length_contract_no number := 25; --increased to 25 for bug 4105469
33 g_length_status number := 15;
34 g_length_contract_id number := 15;
35
36
37
38 FUNCTION SETUP(p_object_name IN VARCHAR2,
39 p_parallel IN NUMBER default null) RETURN BOOLEAN;
40
41 PROCEDURE WRAPUP(
42 p_status IN BOOLEAN,
43 p_count IN NUMBER default 0,
44 p_message IN VARCHAR2 DEFAULT NULL,
45 p_period_from IN DATE default null,
46 p_period_to IN DATE default null,
47 p_attribute1 IN VARCHAR2 default null,
48 p_attribute2 IN VARCHAR2 default null,
49 p_attribute3 IN VARCHAR2 default null,
50 p_attribute4 IN VARCHAR2 default null,
51 p_attribute5 IN VARCHAR2 default null,
52 p_attribute6 IN VARCHAR2 default null,
53 p_attribute7 IN VARCHAR2 default null,
54 p_attribute8 IN VARCHAR2 default null,
55 p_attribute9 IN VARCHAR2 default null,
56 p_attribute10 IN VARCHAR2 default null); --??? para type
57
58 PROCEDURE WRITE_BIS_REFRESH_LOG(
59 p_status IN BOOLEAN,
60 p_count IN NUMBER default 0,
61 p_message IN VARCHAR2 DEFAULT NULL,
62 p_period_from IN DATE default null,
63 p_period_to IN DATE default null,
64 p_attribute1 IN VARCHAR2 default null,
65 p_attribute2 IN VARCHAR2 default null,
66 p_attribute3 IN VARCHAR2 default null,
67 p_attribute4 IN VARCHAR2 default null,
68 p_attribute5 IN VARCHAR2 default null,
69 p_attribute6 IN VARCHAR2 default null,
70 p_attribute7 IN VARCHAR2 default null,
71 p_attribute8 IN VARCHAR2 default null,
72 p_attribute9 IN VARCHAR2 default null,
73 p_attribute10 IN VARCHAR2 default null); --??? para type
74
75 function get_last_failure_period(p_object_name in varchar2) return varchar2;
76
77 /*
78 * Overloaded get_last_failure_period for bug#4365064 to return both period_to
79 * and p_period_from
80 */
81 procedure get_last_failure_period(
82 p_object_name in varchar2,
83 p_period_from OUT NOCOPY varchar2,
84 p_period_to OUT NOCOPY varchar2
85 );
86
87 function get_last_refresh_period(p_object_name in varchar2) return varchar2;
88
89 procedure get_last_refresh_dates(
90 p_object_name IN VARCHAR2,
91 p_start_date OUT NOCOPY DATE,
92 p_end_date OUT NOCOPY DATE,
93 p_period_from OUT NOCOPY DATE,
94 p_period_to OUT NOCOPY DATE
95 ) ;
96
97 procedure get_last_user_attributes(
98 p_object_name IN VARCHAR2,
99 p_attribute_table OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
100 p_count OUT NOCOPY NUMBER );
101
102 procedure log(
103 p_message IN VARCHAR2,
104 p_indenting IN NUMBER default 0) ;
105
106 procedure debug(
107 p_message IN VARCHAR2,
108 p_indenting IN NUMBER default 0) ;
109
110 procedure out(
111 p_message IN VARCHAR2,
112 p_indenting IN NUMBER default 0) ;
113
114 PROCEDURE put_names(
115 p_log_file VARCHAR2,
116 p_out_file VARCHAR2,
117 p_directory VARCHAR2);
118
119 PROCEDURE put_line(
120 p_text VARCHAR2) ;
121
122 PROCEDURE put_line_out(
123 p_text VARCHAR2);
124
125 Procedure writeMissingRateHeader;
126 FUNCTION getMissingRateHeader return VARCHAR2;
127
128 Procedure writeMissingRate(
129 p_rate_type IN VARCHAR2, /* Rate type */
130 p_from_currency IN VARCHAR2, /* From Currency */
131 p_to_currency in VARCHAR2, /* To Currency */
132 p_date IN DATE, /* Date in default format */
133 p_date_override IN VARCHAR2 default null); /* Formatted date, will output this instead of p_date */
134
135 FUNCTION getMissingRateText(
136 p_rate_type IN VARCHAR2, /* Rate type */
137 p_from_currency IN VARCHAR2, /* From Currency */
138 p_to_currency in VARCHAR2, /* To Currency */
139 p_date IN DATE, /* Date in default format */
140 p_date_override IN VARCHAR2 default null) return VARCHAR2; /* Formatted date, will output this instead of p_date */
141
142 Procedure writeMissingContractHeader;
143
144 Procedure writeMissingContract(
145 P_contract_no IN VARCHAR2, /* Contract Number*/
146 P_contract_status IN VARCHAR2, /* Contract Status*/
147 p_contract_id IN VARCHAR2,
148 p_rate_type IN VARCHAR2, /* Rate type */
149 p_from_currency IN VARCHAR2, /* From Currency */
150 p_to_currency in VARCHAR2, /* To Currency */
151 p_date IN DATE, /* Date in default format */
152 p_date_override IN VARCHAR2 default null/* Formatted date, will output this instead of p_date */
153 );
154
155
156 PROCEDURE deleteLogForObject(p_object_name IN VARCHAR2);
157 PROCEDURE enableParallelDML;
158 Procedure disableParallelDML;
159
160
161
162 PROCEDURE writeMissingUOMHeader;
163
164 PROCEDURE writeMissingUOM(
165 p_from_uom IN VARCHAR2, /* From UOM */
166 p_to_uom IN VARCHAR2, /* To UOM */
167 p_inventory_item IN VARCHAR2); /* Inventory Item ID */
168
169 /*
170 * Added for FND_LOG uptaking
171 */
172
173 PROCEDURE put_line(
174 p_text VARCHAR2,
175 p_severity NUMBER) ;
176
177 procedure put_fnd_log(
178 p_text IN VARCHAR2,
179 p_severity NUMBER) ;
180
181 PROCEDURE put_conc_log(p_text VARCHAR2);
182
183 procedure log(
184 p_message IN VARCHAR2,
185 p_indenting IN NUMBER default 0,
186 p_severity NUMBER) ;
187
188 procedure debug(
189 p_message IN VARCHAR2,
190 p_indenting IN NUMBER default 0,
191 p_severity NUMBER) ;
192
193
194 END BIS_COLLECTION_UTILITIES;