DBA Data[Home] [Help]

APPS.BIM_SOURCE_CODE_PKG dependencies on BIM_REP_HISTORY

Line 9: BIM_REP_HISTORY table, whenever the LOAD_DATA procedure is called

5: g_file_name CONSTANT VARCHAR2(20) := 'bimsrcdb.pls';
6:
7: /* ----------------------------------------------------------------------
8: This procedure will insert a record for object = 'SOURCE' in
9: BIM_REP_HISTORY table, whenever the LOAD_DATA procedure is called
10: for the first time in the day.
11: ----------------------------------------------------------------------*/
12: PROCEDURE LOG_HISTORY
13: (

Line 25: INSERT INTO BIM_REP_HISTORY

21: l_api_version_number CONSTANT NUMBER := 1.0;
22: l_api_name CONSTANT VARCHAR2(30) := 'LOG_HISTORY';
23: BEGIN
24:
25: INSERT INTO BIM_REP_HISTORY
26: (creation_date,
27: last_update_date,
28: created_by,
29: last_updated_by,

Line 80: FROM BIM_REP_HISTORY

76:
77: CURSOR chk_history_data
78: IS
79: SELECT trunc(max(creation_date))
80: FROM BIM_REP_HISTORY
81: WHERE object = 'SOURCE';
82: l_status VARCHAR2(5);
83: l_industry VARCHAR2(5);
84: l_schema VARCHAR2(30);