APPS.HRI_OPL_WRKFC_EVENTS dependencies on HRI_MDS_WRKFC_MNTH_CT

Line 92: INSERT INTO hri_mds_wrkfc_mnth_ct

88: p_end_asg_id IN NUMBER) IS
89:
90: BEGIN
91:
92: INSERT INTO hri_mds_wrkfc_mnth_ct
93: (wevt_evtypcmb_fk
94: ,asg_assgnmnt_fk
95: ,per_person_fk
96: ,per_person_mgr_fk

Line 650: INSERT INTO hri_mds_wrkfc_mnth_ct

646: p_end_asg_id IN NUMBER) IS
647:
648: BEGIN
649:
650: INSERT INTO hri_mds_wrkfc_mnth_ct
651: (wevt_evtypcmb_fk
652: ,asg_assgnmnt_fk
653: ,per_person_fk
654: ,per_person_mgr_fk

Line 1224: DELETE FROM hri_mds_wrkfc_mnth_ct snp

1220: p_end_asg_id IN NUMBER) IS
1221:
1222: BEGIN
1223:
1224: DELETE FROM hri_mds_wrkfc_mnth_ct snp
1225: WHERE snp.rowid IN
1226: (SELECT /*+ ORDERED */
1227: snp2.rowid
1228: FROM

Line 1230: ,hri_mds_wrkfc_mnth_ct snp2

1226: (SELECT /*+ ORDERED */
1227: snp2.rowid
1228: FROM
1229: hri_eq_wrkfc_mnth eq
1230: ,hri_mds_wrkfc_mnth_ct snp2
1231: WHERE eq.assignment_id = snp2.asg_assgnmnt_fk
1232: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id
1233: AND snp2.time_month_snp_fk >=
1234: to_number(to_char(eq.erlst_evnt_effective_date, 'YYYYQMM')));

Line 2431: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDS_WRKFC_MNTH_CT_WHO DISABLE');

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
2435: -- ********************

Line 2444: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_MDS_WRKFC_MNTH_CT';

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';
2445: EXECUTE IMMEDIATE(l_sql_stmt);
2446:
2447: -- Empty out event type combination table
2448: hri_opl_wrkfc_evt_type.truncate_evtypcmb_table;

Line 2470: p_table_name => 'HRI_MDS_WRKFC_MNTH_CT',

2466:
2467: -- Drop all the indexes on the table
2468: hri_utl_ddl.log_and_drop_indexes
2469: (p_application_short_name => 'HRI',
2470: p_table_name => 'HRI_MDS_WRKFC_MNTH_CT',
2471: p_table_owner => l_schema);
2472:
2473: -- Set the SQL statement for the entire range
2474: p_sqlstr :=

Line 2529: run_sql_stmt_noerr('ALTER TRIGGER HRI_MDS_WRKFC_MNTH_CT_WHO ENABLE');

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
2533: null;

Line 2544: p_table_name => 'HRI_MDS_WRKFC_MNTH_CT',

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',
2545: p_table_owner => l_schema);
2546: END IF;
2547:
2548: -- Empty out absence summary event queue