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_WRKFC_EVENTS dependencies on HRI_MB_WRKFC_EVT_CT

Line 50: p_process_table_name => 'HRI_MB_WRKFC_EVT_CT');

46:
47: l_dbi_collection_start_date :=
48: hri_oltp_conc_param.get_date_parameter_value
49: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
50: p_process_table_name => 'HRI_MB_WRKFC_EVT_CT');
51:
52: -- If called for the first time set the defaulted parameters
53: IF (p_mthd_stage_code = 'PRE_PROCESS') THEN
54:

Line 58: p_process_table_name => 'HRI_MB_WRKFC_EVT_CT');

54:
55: g_full_refresh :=
56: hri_oltp_conc_param.get_parameter_value
57: (p_parameter_name => 'FULL_REFRESH',
58: p_process_table_name => 'HRI_MB_WRKFC_EVT_CT');
59:
60: -- Log defaulted parameters so the slave processes pick up
61: hri_opl_multi_thread.update_parameters
62: (p_mthd_action_id => p_mthd_action_id,

Line 293: hri_mb_wrkfc_evt_ct wevt

289: ,wevt.employee_ind
290: ,wevt.contingent_ind
291: ,wevt.adt_pow_band
292: FROM
293: hri_mb_wrkfc_evt_ct wevt
294: ,fii_time_month mnth
295: WHERE mnth.end_date BETWEEN wevt.time_day_evt_fk
296: AND wevt.time_day_evt_end_fk
297: -- If assignment is ended, only snapshot the ended assignment once

Line 501: hri_mb_wrkfc_evt_ct wevt

497: ELSE 0
498: END last_month_in_year_ind
499: ,0 zero_row_ind
500: FROM
501: hri_mb_wrkfc_evt_ct wevt
502: ,fii_time_month mnth
503: WHERE wevt.time_day_evt_fk <= mnth.end_date
504: AND mnth.start_date <= wevt.time_day_evt_end_fk
505: -- If assignment is ended, only snapshot the ended assignment once

Line 572: hri_mb_wrkfc_evt_ct wevt

568: ELSE 0
569: END last_month_in_year_ind
570: ,1 zero_row_ind
571: FROM
572: hri_mb_wrkfc_evt_ct wevt
573: ,fii_time_month mnth
574: WHERE mnth.end_date BETWEEN wevt.time_day_evt_fk
575: AND wevt.time_day_evt_end_fk
576: -- If assignment is ended, no need to snapshot

Line 853: ,hri_mb_wrkfc_evt_ct wevt

849: ,wevt.adt_pow_band
850: ,eq.erlst_evnt_effective_date adt_event_date
851: FROM
852: hri_eq_wrkfc_mnth eq
853: ,hri_mb_wrkfc_evt_ct wevt
854: ,fii_time_month mnth
855: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
856: AND mnth.end_date BETWEEN wevt.time_day_evt_fk
857: AND wevt.time_day_evt_end_fk

Line 1065: ,hri_mb_wrkfc_evt_ct wevt

1061: END last_month_in_year_ind
1062: ,0 zero_row_ind
1063: FROM
1064: hri_eq_wrkfc_mnth eq
1065: ,hri_mb_wrkfc_evt_ct wevt
1066: ,fii_time_month mnth
1067: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
1068: AND mnth.end_date >= ADD_MONTHS(eq.erlst_evnt_effective_date, -1)
1069: AND wevt.time_day_evt_fk <= mnth.end_date

Line 1139: ,hri_mb_wrkfc_evt_ct wevt

1135: END last_month_in_year_ind
1136: ,1 zero_row_ind
1137: FROM
1138: hri_eq_wrkfc_mnth eq
1139: ,hri_mb_wrkfc_evt_ct wevt
1140: ,fii_time_month mnth
1141: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
1142: AND mnth.end_date BETWEEN wevt.time_day_evt_fk
1143: AND wevt.time_day_evt_end_fk

Line 1247: INSERT INTO hri_mb_wrkfc_evt_ct

1243: p_end_asg_id IN NUMBER) IS
1244:
1245: BEGIN
1246:
1247: INSERT INTO hri_mb_wrkfc_evt_ct
1248: (wevt_evtypcmb_fk
1249: ,asg_assgnmnt_fk
1250: ,per_person_fk
1251: ,per_person_mgr_fk

Line 1738: INSERT INTO hri_mb_wrkfc_evt_ct

1734: p_end_asg_id IN NUMBER) IS
1735:
1736: BEGIN
1737:
1738: INSERT INTO hri_mb_wrkfc_evt_ct
1739: (wevt_evtypcmb_fk
1740: ,asg_assgnmnt_fk
1741: ,per_person_fk
1742: ,per_person_mgr_fk

Line 2235: DELETE FROM hri_mb_wrkfc_evt_ct evt

2231:
2232: BEGIN
2233:
2234: -- Delete records later than earliest event date
2235: DELETE FROM hri_mb_wrkfc_evt_ct evt
2236: WHERE evt.rowid IN
2237: (SELECT /*+ ORDERED */
2238: evt2.rowid
2239: FROM

Line 2241: ,hri_mb_wrkfc_evt_ct evt2

2237: (SELECT /*+ ORDERED */
2238: evt2.rowid
2239: FROM
2240: hri_eq_wrkfc_evt eq
2241: ,hri_mb_wrkfc_evt_ct evt2
2242: WHERE evt2.asg_assgnmnt_fk = eq.assignment_id
2243: AND evt2.time_day_evt_fk >= eq.erlst_evnt_effective_date
2244: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id);
2245:

Line 2247: UPDATE hri_mb_wrkfc_evt_ct evt

2243: AND evt2.time_day_evt_fk >= eq.erlst_evnt_effective_date
2244: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id);
2245:
2246: -- End date records overlapping with event date
2247: UPDATE hri_mb_wrkfc_evt_ct evt
2248: SET evt.time_day_evt_end_fk =
2249: (SELECT eq.erlst_evnt_effective_date - 1
2250: FROM hri_eq_wrkfc_evt eq
2251: WHERE evt.asg_assgnmnt_fk = eq.assignment_id)

Line 2257: ,hri_mb_wrkfc_evt_ct evt2

2253: (SELECT /*+ ORDERED */
2254: evt2.rowid
2255: FROM
2256: hri_eq_wrkfc_evt eq2
2257: ,hri_mb_wrkfc_evt_ct evt2
2258: WHERE evt2.asg_assgnmnt_fk = eq2.assignment_id
2259: AND eq2.erlst_evnt_effective_date BETWEEN evt2.time_day_evt_fk
2260: AND evt2.time_day_evt_end_fk
2261: AND eq2.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id);

Line 2430: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_WRKFC_EVT_CT_WHO DISABLE');

2426: null;
2427: END IF;
2428:
2429: -- Disable WHO triggers
2430: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_WRKFC_EVT_CT_WHO DISABLE');
2431: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDS_WRKFC_MNTH_CT_WHO DISABLE');
2432:
2433: -- ********************
2434: -- Full Refresh Section

Line 2440: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_WRKFC_EVT_CT';

2436: IF (g_full_refresh = 'Y' OR
2437: g_mthd_action_array.foundation_hr_flag = 'Y') THEN
2438:
2439: -- Empty out base fact table
2440: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_WRKFC_EVT_CT';
2441: EXECUTE IMMEDIATE(l_sql_stmt);
2442:
2443: -- Empty out month summary table
2444: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MDS_WRKFC_MNTH_CT';

Line 2463: p_table_name => 'HRI_MB_WRKFC_EVT_CT',

2459:
2460: -- Drop all the indexes on the table
2461: hri_utl_ddl.log_and_drop_indexes
2462: (p_application_short_name => 'HRI',
2463: p_table_name => 'HRI_MB_WRKFC_EVT_CT',
2464: p_table_owner => l_schema,
2465: p_index_excptn_lst => 'HRI_MB_WRKFC_EVT_CT_U1');
2466:
2467: -- Drop all the indexes on the table

Line 2465: p_index_excptn_lst => 'HRI_MB_WRKFC_EVT_CT_U1');

2461: hri_utl_ddl.log_and_drop_indexes
2462: (p_application_short_name => 'HRI',
2463: p_table_name => 'HRI_MB_WRKFC_EVT_CT',
2464: p_table_owner => l_schema,
2465: p_index_excptn_lst => 'HRI_MB_WRKFC_EVT_CT_U1');
2466:
2467: -- Drop all the indexes on the table
2468: hri_utl_ddl.log_and_drop_indexes
2469: (p_application_short_name => 'HRI',

Line 2518: hri_bpl_conc_log.record_process_start('HRI_MB_WRKFC_EVT_CT');

2514: (p_mthd_action_id => p_mthd_action_id,
2515: p_mthd_stage_code => 'POST_PROCESS');
2516:
2517: -- Log process end
2518: hri_bpl_conc_log.record_process_start('HRI_MB_WRKFC_EVT_CT');
2519: hri_bpl_conc_log.log_process_end(
2520: p_status => TRUE
2521: ,p_period_from => TRUNC(g_refresh_start_date)
2522: ,p_period_to => TRUNC(SYSDATE)

Line 2528: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_WRKFC_EVT_CT_WHO ENABLE');

2524:
2525: END IF;
2526:
2527: -- Enable WHO trigger
2528: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_WRKFC_EVT_CT_WHO ENABLE');
2529: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDS_WRKFC_MNTH_CT_WHO ENABLE');
2530:
2531: -- Get HRI schema name - get_app_info populates l_schema
2532: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN

Line 2540: p_table_name => 'HRI_MB_WRKFC_EVT_CT',

2536: -- Recreate indexes
2537: IF (g_full_refresh = 'Y') THEN
2538: hri_utl_ddl.recreate_indexes
2539: (p_application_short_name => 'HRI',
2540: p_table_name => 'HRI_MB_WRKFC_EVT_CT',
2541: p_table_owner => l_schema);
2542: hri_utl_ddl.recreate_indexes
2543: (p_application_short_name => 'HRI',
2544: p_table_name => 'HRI_MDS_WRKFC_MNTH_CT',