eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_CS_GEO_LOCHR_CT

Line 45: g_target_lochr_table CONSTANT VARCHAR2(30) := 'HRI_CS_GEO_LOCHR_CT';

41: --
42: -- 115.15 4278978
43: -- New tables
44: -- changed data types to constants from defaults
45: g_target_lochr_table CONSTANT VARCHAR2(30) := 'HRI_CS_GEO_LOCHR_CT';
46: g_target_region_table CONSTANT VARCHAR2(30) := 'HRI_CS_GEO_REGION_CT';
47: g_target_country_table CONSTANT VARCHAR2(30) := 'HRI_CS_GEO_COUNTRY_CT';
48: --
49: g_cncrnt_prgrm_shrtnm CONSTANT VARCHAR2(30) := 'HRIGLOCHR';

Line 149: FROM hri_cs_geo_lochr_ct

145: -- Bug 2834228 added rownum condition to stop FTS
146: --
147: CURSOR csr_recs_exist IS
148: SELECT 'x'
149: FROM hri_cs_geo_lochr_ct
150: WHERE rownum < 2;
151: --
152: -- @@ Code specific to this view/table ENDS
153: --

Line 169: dbg('no data in table hri_cs_geo_lochr_ct');

165: IF (csr_recs_exist%NOTFOUND) THEN
166: --
167: l_exists := TRUE;
168: --
169: dbg('no data in table hri_cs_geo_lochr_ct');
170: --
171: ELSE
172: --
173: l_exists := FALSE;

Line 175: dbg('data exists in table hri_cs_geo_lochr_ct');

171: ELSE
172: --
173: l_exists := FALSE;
174: --
175: dbg('data exists in table hri_cs_geo_lochr_ct');
176: --
177: END IF;
178: --
179: CLOSE csr_recs_exist;

Line 214: TYPE l_number_tab_type IS TABLE OF hri_cs_geo_lochr_ct.location_id%TYPE;

210: -- -----------------------------------------------------------------------------
211: PROCEDURE Incr_Refresh_Lochr_Struct IS
212: --
213: -- PL/SQL table of updated location records
214: TYPE l_number_tab_type IS TABLE OF hri_cs_geo_lochr_ct.location_id%TYPE;
215: l_upd_location_ids L_NUMBER_TAB_TYPE;
216: --
217: BEGIN
218: --

Line 225: INTO hri_cs_geo_lochr_ct

221: dbg(' Table:'||g_schema||'.'||g_target_lochr_table);
222: --
223: dbg_time('Insert Start');
224: INSERT
225: INTO hri_cs_geo_lochr_ct
226: (area_code
227: ,country_code
228: ,region_code
229: ,city_cid

Line 260: FROM hri_cs_geo_lochr_ct tbl

256: --
257: WHERE TRUNC(last_change_date) BETWEEN g_start_date
258: AND g_end_date
259: AND NOT EXISTS (SELECT 'x'
260: FROM hri_cs_geo_lochr_ct tbl
261: WHERE svw.location_id = tbl.location_id
262: AND effective_start_date = tbl.effective_start_date
263: AND effective_end_date = tbl.effective_end_date)
264: ;

Line 286: UPDATE hri_cs_geo_lochr_ct tbl

282: -- last_change_date is effectively useless
283: -- Removed effective start and end date predicate as the dimension is not
284: -- slowly changing - if it was then the PK index should be composite.
285: --
286: UPDATE hri_cs_geo_lochr_ct tbl
287: SET
288: ( area_code
289: ,country_code
290: ,region_code

Line 347: FROM hri_cs_geo_lochr_ct tbl

343: -- Results from -> All hr locations deleted
344: --
345: dbg_time('Delete Start');
346: DELETE
347: FROM hri_cs_geo_lochr_ct tbl
348: WHERE NOT EXISTS
349: (SELECT 'x'
350: FROM hri_cs_geo_lochr_v svw
351: WHERE svw.location_id = tbl.location_id

Line 709: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_LOCHR_CT_WHO DISABLE');

705: --
706: dbg(' Table:'||g_schema||'.'||g_target_lochr_table);
707: --
708: dbg('Disabling trigger');
709: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_LOCHR_CT_WHO DISABLE');
710: --
711: dbg('Truncating table prior to full refresh');
712: g_sql_stmt := 'TRUNCATE TABLE ' || g_schema || '.'||g_target_lochr_table;
713: dbg_time('Truncate Start');

Line 726: INTO hri_cs_geo_lochr_ct

722: -- (Bug 2950564: Uses APPEND hint to disable MV Log)
723: --
724: dbg_time('Insert Start');
725: INSERT /*+ APPEND */
726: INTO hri_cs_geo_lochr_ct
727: (area_code
728: ,country_code
729: ,region_code
730: ,city_cid

Line 773: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_LOCHR_CT_WHO ENABLE');

769: --
770: COMMIT;
771: --
772: dbg('Re-Enabling Who Trigger');
773: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_LOCHR_CT_WHO ENABLE');
774: --
775: dbg_time('Gather Stats Start');
776: fnd_stats.gather_table_stats(g_schema, g_target_lochr_table);
777: dbg_time('Gather Stats End');

Line 1253: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');

1249: BEGIN
1250:
1251: l_full_refresh := hri_oltp_conc_param.get_parameter_value
1252: (p_parameter_name => 'FULL_REFRESH',
1253: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');
1254: IF (l_full_refresh = 'Y') THEN
1255: l_start_date := hri_oltp_conc_param.get_parameter_value
1256: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1257: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');

Line 1257: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');

1253: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');
1254: IF (l_full_refresh = 'Y') THEN
1255: l_start_date := hri_oltp_conc_param.get_parameter_value
1256: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
1257: p_process_table_name => 'HRI_CS_GEO_LOCHR_CT');
1258: ELSE
1259: -- Bug 4704157 - converted displaydt to canonical
1260: l_start_date := fnd_date.date_to_canonical
1261: (fnd_date.displaydt_to_date

Line 1263: ('HRI_OPL_GEO_LOCHR','HRI_CS_GEO_LOCHR_CT')));

1259: -- Bug 4704157 - converted displaydt to canonical
1260: l_start_date := fnd_date.date_to_canonical
1261: (fnd_date.displaydt_to_date
1262: (hri_bpl_conc_log.get_last_collect_to_date
1263: ('HRI_OPL_GEO_LOCHR','HRI_CS_GEO_LOCHR_CT')));
1264: END IF;
1265:
1266: hri_bpl_conc_log.dbg('Full refresh: ' || l_full_refresh);
1267: hri_bpl_conc_log.dbg('Collect from: ' || l_start_date);