92: l_conc_start_date DATE;
93: l_conc_end_date DATE;
94: l_start_date DATE;
95: l_end_date DATE;
96: l_user_id NUMBER := FND_GLOBAL.USER_ID();
97: l_api_version_number CONSTANT NUMBER := 1.0;
98: l_api_name CONSTANT VARCHAR2(30) := 'BIM_I_LEAD_FACTS_PKG';
99: l_mesg_text VARCHAR2(100);
100: l_load_type VARCHAR2(100);
281: ,x_msg_data OUT NOCOPY VARCHAR2
282: ,x_return_status OUT NOCOPY VARCHAR2
283: )
284: IS
285: l_user_id NUMBER := FND_GLOBAL.USER_ID();
286: l_api_version_number CONSTANT NUMBER := 1.0;
287: l_api_name CONSTANT VARCHAR2(30) := 'FIRST_LOAD';
288: l_table_name VARCHAR2(100);
289: l_conv_opp_status VARCHAR2(30);
841: ,x_msg_data OUT NOCOPY VARCHAR2
842: ,x_return_status OUT NOCOPY VARCHAR2
843: )
844: IS
845: l_user_id NUMBER := FND_GLOBAL.USER_ID();
846: l_api_version_number CONSTANT NUMBER := 1.0;
847: l_api_name CONSTANT VARCHAR2(30) := 'INCREMENTAL_LOAD';
848: l_table_name VARCHAR2(100);
849: l_conv_opp_status VARCHAR2(30);