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_CO_PGMH_PLIP_CT

Line 161: FROM HRI_CS_CO_PGMH_PLIP_CT cppd

157: AND cpp.effective_end_date
158: AND l_effective_date BETWEEN pln.effective_start_date
159: AND pln.effective_end_date
160: AND NOT EXISTS (SELECT 'x'
161: FROM HRI_CS_CO_PGMH_PLIP_CT cppd
162: WHERE cppd.plip_id = cpp.plip_id);
163: --
164: CURSOR c_plip_ernt_pl IS
165: SELECT cpp.plip_id plip_id, cpp.pl_id pl_id, cpp.pgm_id pgm_id,

Line 194: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd

190: CURSOR c_oiplip IS
191: SELECT opp.oiplip_id oiplip_id, opp.oipl_id oipl_id, cop.opt_id opt_id,
192: opp.plip_id plip_id, cppd.pl_typ_id pl_typ_id,
193: cppd.ptip_id ptip_id, cppd.pl_id pl_id, cppd.pgm_id pgm_id, cop.ordr_num oipl_ordr_num
194: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd
195: WHERE opp.plip_id = cppd.plip_id
196: AND cop.oipl_id = opp.oipl_id
197: AND l_effective_date BETWEEN opp.effective_start_date
198: AND opp.effective_end_date

Line 315: -- (3) Populate dimension table HRI_CS_CO_PGMH_PLIP_CT

311: --
312: output('Populated Plan Type In Program Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
313: --
314: --
315: -- (3) Populate dimension table HRI_CS_CO_PGMH_PLIP_CT
316: --
317: FOR l_plip_row in c_plip LOOP
318: --
319: INSERT INTO HRI_CS_CO_PGMH_PLIP_CT

Line 319: INSERT INTO HRI_CS_CO_PGMH_PLIP_CT

315: -- (3) Populate dimension table HRI_CS_CO_PGMH_PLIP_CT
316: --
317: FOR l_plip_row in c_plip LOOP
318: --
319: INSERT INTO HRI_CS_CO_PGMH_PLIP_CT
320: ( plip_id
321: , pl_id
322: , PGM_ID
323: , ptip_id

Line 545: DELETE FROM HRI_CS_CO_PGMH_PLIP_CT cppd

541: WHERE ctp.ptip_id = ctpd.ptip_id);
542: --
543: -- Plan In Program Dimension
544: --
545: DELETE FROM HRI_CS_CO_PGMH_PLIP_CT cppd
546: WHERE NOT EXISTS (SELECT 'x'
547: FROM ben_plip_f cpp
548: WHERE cpp.plip_id = cppd.plip_id);
549: --

Line 698: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd

694: IS
695: SELECT opp.oiplip_id oiplip_id, opp.oipl_id oipl_id, cop.opt_id opt_id,
696: opp.plip_id plip_id, cppd.pl_typ_id pl_typ_id,
697: cppd.ptip_id ptip_id, cppd.pl_id pl_id, cppd.pgm_id pgm_id, cop.ordr_num oipl_ordr_num
698: FROM ben_oiplip_f opp, ben_oipl_f cop, hri_cs_co_pgmh_plip_ct cppd
699: WHERE opp.plip_id = cppd.plip_id
700: AND cop.oipl_id = opp.oipl_id
701: AND l_effective_date BETWEEN opp.effective_start_date
702: AND opp.effective_end_date

Line 752: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PLIP_CT_WHO DISABLE');

748: -- Disable the WHO Triggers
749: --
750: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGM_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: --

Line 761: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGMH_PLIP_CT';

757: -- Truncate the target table prior to full refresh.
758: --
759: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || g_schema || '.HRI_CS_CO_PGM_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: --

Line 827: -- (3) Populate dimension table HRI_CS_CO_PGMH_PLIP_CT

823: END LOOP;
824: --
825: output('Populated Plan Type In Program Dimension: ' || to_char(sysdate,'HH24:MI:SS'));
826: --
827: -- (3) Populate dimension table HRI_CS_CO_PGMH_PLIP_CT
828: --
829: FOR l_plip_row in c_plip LOOP
830: --
831: INSERT INTO HRI_CS_CO_PGMH_PLIP_CT

Line 831: INSERT INTO HRI_CS_CO_PGMH_PLIP_CT

827: -- (3) Populate dimension table HRI_CS_CO_PGMH_PLIP_CT
828: --
829: FOR l_plip_row in c_plip LOOP
830: --
831: INSERT INTO HRI_CS_CO_PGMH_PLIP_CT
832: ( plip_id
833: , pl_id
834: , PGM_ID
835: , ptip_id

Line 1043: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGMH_PLIP_CT_WHO ENABLE');

1039: -- Enable the WHO triggers
1040: --
1041: run_sql_stmt_noerr('ALTER TRIGGER HRI_CS_CO_PGM_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: --

Line 1165: fnd_stats.gather_table_stats(g_schema, 'HRI_CS_CO_PGMH_PLIP_CT');

1161: -- Gather index stats
1162: --
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: --