APPS.HRI_OPL_GEO_LOCHR dependencies on HRI_CS_GEO_COUNTRY_CT

Line 47: g_target_country_table CONSTANT VARCHAR2(30) := 'HRI_CS_GEO_COUNTRY_CT';

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: --
51: -- @@ Code specific to this view/table below ENDS

Line 584: UPDATE hri_cs_geo_country_ct tbl

580: -- 3) End Date
581: -- 4546781
582: -- Changed predicates of set select statement where and update where clause.
583: --
584: UPDATE hri_cs_geo_country_ct tbl
585: SET
586: ( geo_area_code
587: , geo_country_code
588: , start_date

Line 628: FROM hri_cs_geo_country_ct tbl

624: -- having that Region)
625: --
626: dbg_time('Delete Start');
627: DELETE
628: FROM hri_cs_geo_country_ct tbl
629: WHERE NOT EXISTS
630: (SELECT 'x'
631: FROM hri_dbi_cs_geo_country_v csc
632: WHERE csc.geo_country_code = tbl.geo_country_code

Line 649: INTO hri_cs_geo_country_ct

645: -- having that Region)
646: --
647: dbg_time('Insert Start');
648: INSERT
649: INTO hri_cs_geo_country_ct
650: ( geo_area_code
651: , geo_country_code
652: , start_date
653: , end_date

Line 664: FROM hri_cs_geo_country_ct tbl

660: , csc.last_change_date
661: FROM hri_dbi_cs_geo_country_v csc
662: WHERE NOT EXISTS
663: (SELECT 'x'
664: FROM hri_cs_geo_country_ct tbl
665: WHERE csc.geo_country_code = tbl.geo_country_code
666: )
667: ;
668: dbg_time('Insert End');

Line 888: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_COUNTRY_CT_WHO DISABLE');

884: --
885: dbg(' Table : '||g_schema||'.'||g_target_country_table);
886: --
887: dbg('Disabling trigger');
888: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_COUNTRY_CT_WHO DISABLE');
889: --
890: dbg('Truncating table prior to full refresh');
891: g_sql_stmt := 'TRUNCATE TABLE ' || g_schema || '.'||g_target_country_table;
892: dbg_time('Truncate Start');

Line 898: INTO hri_cs_geo_country_ct

894: dbg_time('Truncate End');
895: --
896: dbg_time('Insert Start');
897: INSERT /*+APPEND */
898: INTO hri_cs_geo_country_ct
899: ( geo_area_code
900: , geo_country_code
901: , start_date
902: , end_date

Line 932: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_COUNTRY_CT_WHO ENABLE');

928: --
929: -- Re-enable the WHO trigger
930: --
931: dbg('Re-Enabling Who Trigger');
932: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_GEO_COUNTRY_CT_WHO ENABLE');
933: --
934: dbg_time('Gather Stats Start');
935: fnd_stats.gather_table_stats(g_schema, g_target_country_table);
936: dbg_time('Gather Stats End');