APPS.BIM_SOURCE_CODE_PKG dependencies on BIM_R_LOCATIONS

Line 47: This procedure will Populate BIM_R_SOURCE_CODES and BIM_R_LOCATIONS tables

43:
44: END LOG_HISTORY;
45:
46: /*----------------------------------------------------------------------------
47: This procedure will Populate BIM_R_SOURCE_CODES and BIM_R_LOCATIONS tables
48: ----------------------------------------------------------------------------*/
49:
50: PROCEDURE LOAD_DATA
51: (p_api_version_number IN NUMBER

Line 118: --ams_utility_pvt.write_conc_log('TABLES BIM_R_SOURCE_CODES and BIM_R_LOCATIONS are already POPULATED Today');

114: /* Begin of the code for checking whether first-time or subsequent run */
115: IF ((l_creation_date) = trunc(sysdate)) THEN
116: /* Return control back to the caller before the normal end of procedure is reached */
117: /* No messages in the LOG file */
118: --ams_utility_pvt.write_conc_log('TABLES BIM_R_SOURCE_CODES and BIM_R_LOCATIONS are already POPULATED Today');
119: return;
120: END IF;
121:
122: l_table_name := 'BIM_R_LOCATIONS';

Line 122: l_table_name := 'BIM_R_LOCATIONS';

118: --ams_utility_pvt.write_conc_log('TABLES BIM_R_SOURCE_CODES and BIM_R_LOCATIONS are already POPULATED Today');
119: return;
120: END IF;
121:
122: l_table_name := 'BIM_R_LOCATIONS';
123: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
124: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126:

Line 127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';

123: fnd_message.set_name('BIM','BIM_R_TRUNCATE_TABLE');
124: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126:
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';
128:
129: l_table_name := 'BIM_R_LOCATIONS';
130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

Line 129: l_table_name := 'BIM_R_LOCATIONS';

125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126:
127: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' ||l_schema||'.BIM_R_LOCATIONS';
128:
129: l_table_name := 'BIM_R_LOCATIONS';
130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
132: fnd_file.put_line(fnd_file.log,fnd_message.get);
133:

Line 134: /* The INSERT statement to populate BIM_R_LOCATIONS table begins here */

130: fnd_message.set_name('BIM','BIM_R_POPULATE_TABLE');
131: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
132: fnd_file.put_line(fnd_file.log,fnd_message.get);
133:
134: /* The INSERT statement to populate BIM_R_LOCATIONS table begins here */
135:
136: INSERT
137: INTO BIM_R_LOCATIONS
138: (

Line 137: INTO BIM_R_LOCATIONS

133:
134: /* The INSERT statement to populate BIM_R_LOCATIONS table begins here */
135:
136: INSERT
137: INTO BIM_R_LOCATIONS
138: (
139: country,
140: region)
141: SELECT

Line 148: l_table_name := 'BIM_R_LOCATIONS';

144: WHERE location_type_code = 'COUNTRY'
145: AND country_code is not null;
146:
147:
148: l_table_name := 'BIM_R_LOCATIONS';
149: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:

Line 153: -- Analyze the bim_r_locations table

149: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:
153: -- Analyze the bim_r_locations table
154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,
155: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
156:
157:

Line 154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,

150: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
151: fnd_file.put_line(fnd_file.log,fnd_message.get);
152:
153: -- Analyze the bim_r_locations table
154: DBMS_STATS.gather_table_stats('BIM','BIM_R_LOCATIONS', estimate_percent => 5,
155: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
156:
157:
158: /* Dropping INdexes */