APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_CS_GEO_REGION_CT

Line 46: g_target_region_table CONSTANT VARCHAR2(30) := 'HRI_CS_GEO_REGION_CT';

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';
50: --

Line 448: UPDATE hri_cs_geo_region_ct tbl

444: -- 4) End Date
445: -- 4546781
446: -- Changed predicates of set select statement where and update where clause.
447: --
448: UPDATE hri_cs_geo_region_ct tbl
449: SET
450: ( geo_area_code
451: , geo_country_code
452: , geo_region_code

Line 495: FROM hri_cs_geo_region_ct tbl

491: -- 1) Location attribution to Region
492: --
493: dbg_time('Delete Start');
494: DELETE
495: FROM hri_cs_geo_region_ct tbl
496: WHERE NOT EXISTS
497: (SELECT 'X'
498: FROM hri_dbi_cs_geo_region_v csr
499: WHERE csr.geo_region_sk_pk = tbl.geo_region_sk_pk

Line 513: INTO hri_cs_geo_region_ct

509: -- 1) Location attribution to Region
510: --
511: dbg_time('Insert Start');
512: INSERT
513: INTO hri_cs_geo_region_ct
514: ( geo_area_code
515: , geo_country_code
516: , geo_region_code
517: , geo_region_sk_pk

Line 532: FROM hri_cs_geo_region_ct tbl

528: , csr.last_change_date
529: FROM hri_dbi_cs_geo_region_v csr
530: WHERE NOT EXISTS
531: (SELECT 'x'
532: FROM hri_cs_geo_region_ct tbl
533: WHERE csr.geo_region_sk_pk = tbl.geo_region_sk_pk
534: )
535: ;
536: dbg_time('Insert End');

Line 808: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_REGION_CT_WHO DISABLE');

804: --
805: dbg(' Table:'||g_schema||'.'||g_target_region_table);
806: --
807: dbg('Disabling trigger');
808: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_REGION_CT_WHO DISABLE');
809: --
810: dbg('Truncating table prior to full refresh');
811: g_sql_stmt := 'TRUNCATE TABLE ' || g_schema || '.'||g_target_region_table;
812: dbg_time('Truncate Start');

Line 818: INTO hri_cs_geo_region_ct

814: dbg_time('Truncate End');
815: --
816: dbg_time('Insert Start');
817: INSERT /*+APPEND */
818: INTO hri_cs_geo_region_ct
819: ( geo_area_code
820: , geo_country_code
821: , geo_region_code
822: , geo_region_sk_pk

Line 854: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_REGION_CT_WHO ENABLE');

850: dbg('Commiting');
851: COMMIT;
852: --
853: dbg('Re-Enabling Who Trigger');
854: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_REGION_CT_WHO ENABLE');
855: --
856: dbg_time('Gather Stats Start');
857: fnd_stats.gather_table_stats(g_schema, g_target_region_table);
858: dbg_time('Gather Stats End');