41: l_currency_error VARCHAR2(5000);
42:
43: CURSOR chk_history_data IS
44: SELECT MAX(end_date)
45: FROM bim_rep_history
46: WHERE object = 'LEAD_IMPORT';
47:
48: BEGIN
49:
196: -----------------------------------------------------------------------
197: -- PROCEDURE
198: -- LOG_HISTORY
199: --
200: --Note: This procedure will insert a HISTORY record into bim_rep_history
201: --table whenever first and subsequent load has run successfully
202: -----------------------------------------------------------------------
203: PROCEDURE LOG_HISTORY(
204: p_object VARCHAR2,
205: p_start_date DATE,
206: p_end_date DATE )
207: IS
208: l_user_id NUMBER := FND_GLOBAL.USER_ID();
209: p_table_name VARCHAR2(100):='BIM_REP_HISTORY';
210: BEGIN
211: INSERT INTO
212: bim_rep_history
213: (creation_date,
208: l_user_id NUMBER := FND_GLOBAL.USER_ID();
209: p_table_name VARCHAR2(100):='BIM_REP_HISTORY';
210: BEGIN
211: INSERT INTO
212: bim_rep_history
213: (creation_date,
214: last_update_date,
215: created_by,
216: last_updated_by,