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_BEN_DIM_REFRESH dependencies on HRI_CS_TIME_BENRL_PRD_CT

Line 231: FROM HRI_CS_TIME_BENRL_PRD_CT enpd

227: AND pet.popl_enrt_typ_cycl_id = enp.popl_enrt_typ_cycl_id
228: AND l_effective_date BETWEEN pet.effective_start_date
229: AND pet.effective_end_date
230: AND NOT EXISTS (SELECT 'x'
231: FROM HRI_CS_TIME_BENRL_PRD_CT enpd
232: WHERE enpd.enrt_perd_id = enp.enrt_perd_id);
233: --
234: CURSOR c_pl_enrt_perd
235: IS

Line 238: FROM hri_cs_time_benrl_prd_ct enpd,

234: CURSOR c_pl_enrt_perd
235: IS
236: SELECT enp.enrt_perd_id, enpd.pgm_id, enp.strt_dt, enp.end_dt,
237: enp.asnd_lf_evt_dt ASND_LF_EVT_DT
238: FROM hri_cs_time_benrl_prd_ct enpd,
239: ben_plip_f cpp,
240: ben_popl_enrt_typ_cycl_f pet,
241: ben_enrt_perd enp
242: WHERE enpd.pgm_id = cpp.pgm_id

Line 251: FROM HRI_CS_TIME_BENRL_PRD_CT enpd

247: AND cpp.effective_end_date
248: AND l_effective_date BETWEEN pet.effective_start_date
249: AND pet.effective_end_date
250: AND NOT EXISTS (SELECT 'x'
251: FROM HRI_CS_TIME_BENRL_PRD_CT enpd
252: WHERE enpd.enrt_perd_id = enp.enrt_perd_id);
253: --
254: BEGIN
255: --

Line 463: -- (7) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Program Enrollment Periods

459: END LOOP;
460: --
461: output('Populated Reporting Group Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
462: --
463: -- (7) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Program Enrollment Periods
464: --
465: FOR l_enrt_perd_row in c_pgm_enrt_perd LOOP
466: --
467: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

Line 467: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

463: -- (7) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Program Enrollment Periods
464: --
465: FOR l_enrt_perd_row in c_pgm_enrt_perd LOOP
466: --
467: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
468: ( enrt_perd_id
469: , pgm_id
470: , enrt_strt_dt
471: , enrt_thru_dt

Line 494: -- (8) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Plan Enrollment Periods

490: );
491: --
492: END LOOP;
493: --
494: -- (8) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Plan Enrollment Periods
495: --
496: FOR l_pl_enrt_perd_row in c_pl_enrt_perd LOOP
497: --
498: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

Line 498: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

494: -- (8) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Plan Enrollment Periods
495: --
496: FOR l_pl_enrt_perd_row in c_pl_enrt_perd LOOP
497: --
498: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
499: ( enrt_perd_id
500: , pgm_id
501: , enrt_strt_dt
502: , enrt_thru_dt

Line 583: DELETE FROM HRI_CS_TIME_BENRL_PRD_CT enpd

579: );
580: --
581: -- Enrollment Period Dimension
582: --
583: DELETE FROM HRI_CS_TIME_BENRL_PRD_CT enpd
584: WHERE NOT EXISTS (SELECT 'x'
585: FROM ben_enrt_perd enp
586: WHERE enp.enrt_perd_id = enpd.enrt_perd_id);
587: --

Line 731: FROM hri_cs_time_benrl_prd_ct enpd,

727: CURSOR c_pl_enrt_perd
728: IS
729: SELECT enp.enrt_perd_id, enpd.pgm_id, enp.strt_dt, enp.end_dt,
730: enp.asnd_lf_evt_dt ASND_LF_EVT_DT
731: FROM hri_cs_time_benrl_prd_ct enpd,
732: ben_plip_f cpp,
733: ben_popl_enrt_typ_cycl_f pet,
734: ben_enrt_perd enp
735: WHERE enpd.pgm_id = cpp.pgm_id

Line 755: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_TIME_BENRL_PRD_CT_WHO DISABLE');

751: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PTIP_CT_WHO DISABLE');
752: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PLIP_CT_WHO DISABLE');
753: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_RPGH_PIRG_CT_WHO DISABLE');
754: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_COMPOBJ_CT_WHO DISABLE');
755: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_TIME_BENRL_PRD_CT_WHO DISABLE');
756: --
757: -- Truncate the target table prior to full refresh.
758: --
759: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGM_CT';

Line 764: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_TIME_BENRL_PRD_CT';

760: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGMH_PTIP_CT';
761: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGMH_PLIP_CT';
762: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_COMPOBJ_CT';
763: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_RPGH_PIRG_CT';
764: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_TIME_BENRL_PRD_CT';
765: --
766: -- Write timing information to log
767: --
768: output('Truncated the tables: ' || to_char(sysdate,'HH24:MI:SS'));

Line 973: -- (7) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Program Enrollment Periods

969: END LOOP;
970: --
971: output('Populated Reporting Group Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
972: --
973: -- (7) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Program Enrollment Periods
974: --
975: FOR l_enrt_perd_row in c_pgm_enrt_perd LOOP
976: --
977: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

Line 977: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

973: -- (7) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Program Enrollment Periods
974: --
975: FOR l_enrt_perd_row in c_pgm_enrt_perd LOOP
976: --
977: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
978: ( enrt_perd_id
979: , pgm_id
980: , enrt_strt_dt
981: , enrt_thru_dt

Line 1004: -- (8) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Plan Enrollment Periods

1000: );
1001: --
1002: END LOOP;
1003: --
1004: -- (8) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Plan Enrollment Periods
1005: --
1006: FOR l_pl_enrt_perd_row in c_pl_enrt_perd LOOP
1007: --
1008: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

Line 1008: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT

1004: -- (8) Populate dimension table HRI_CS_TIME_BENRL_PRD_CT for Plan Enrollment Periods
1005: --
1006: FOR l_pl_enrt_perd_row in c_pl_enrt_perd LOOP
1007: --
1008: INSERT INTO HRI_CS_TIME_BENRL_PRD_CT
1009: ( enrt_perd_id
1010: , pgm_id
1011: , enrt_strt_dt
1012: , enrt_thru_dt

Line 1046: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_TIME_BENRL_PRD_CT_WHO ENABLE');

1042: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PTIP_CT_WHO ENABLE');
1043: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PLIP_CT_WHO ENABLE');
1044: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_RPGH_PIRG_CT_WHO ENABLE');
1045: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_COMPOBJ_CT_WHO ENABLE');
1046: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_TIME_BENRL_PRD_CT_WHO ENABLE');
1047: --
1048: EXCEPTION
1049: --
1050: WHEN OTHERS THEN

Line 1167: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_TIME_BENRL_PRD_CT');

1163: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGM_CT');
1164: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGMH_PTIP_CT');
1165: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGMH_PLIP_CT');
1166: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_RPGH_PIRG_CT');
1167: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_TIME_BENRL_PRD_CT');
1168: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGM_CT');
1169: --
1170: -- Write timing information to log
1171: --