APPS.HRI_OPL_CMNTS dependencies on HRI_MB_CMNTS_CT

Line 152: INSERT INTO HRI_MB_CMNTS_CT (

148: --
149: l_current_time := SYSDATE;
150: l_user_id := fnd_global.user_id;
151: --
152: INSERT INTO HRI_MB_CMNTS_CT (
153: HRI_MB_CMNTS_CT_ID
154: ,EFFECTIVE_START_DATE
155: ,EFFECTIVE_END_DATE
156: ,ASSIGNMENT_ID

Line 153: HRI_MB_CMNTS_CT_ID

149: l_current_time := SYSDATE;
150: l_user_id := fnd_global.user_id;
151: --
152: INSERT INTO HRI_MB_CMNTS_CT (
153: HRI_MB_CMNTS_CT_ID
154: ,EFFECTIVE_START_DATE
155: ,EFFECTIVE_END_DATE
156: ,ASSIGNMENT_ID
157: ,ORGANIZATION_ID

Line 174: SELECT hri_mb_cmnts_ct_s.nextval

170: ,last_update_login
171: ,last_updated_by
172: ,created_by
173: ,creation_date)
174: SELECT hri_mb_cmnts_ct_s.nextval
175: ,pec.commitment_start_date
176: ,pec.commitment_end_date
177: ,pec.assignment_id
178: ,paaf.organization_id

Line 211: dbg(SQL%ROWCOUNT||' commitment records inserted into HRI_MB_CMNTS_CT');

207: AND pec.assignment_id BETWEEN p_start_object_id AND p_end_object_id
208: AND pec.commitment_start_date BETWEEN g_refresh_start_date AND g_refresh_end_date;
209:
210: --
211: dbg(SQL%ROWCOUNT||' commitment records inserted into HRI_MB_CMNTS_CT');
212: dbg('Exiting process');
213: --
214: EXCEPTION
215: WHEN OTHERS THEN

Line 252: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_CMNTS_CT_WHO DISABLE');

248: set_parameters( p_mthd_action_id => p_mthd_action_id );
249: --
250: -- Disable the WHO trigger
251: --
252: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_CMNTS_CT_WHO DISABLE');
253: --
254: -- ---------------------------------------------------------------------------
255: -- Full Refresh Section
256: -- ---------------------------------------------------------------------------

Line 268: p_table_name => 'HRI_MB_CMNTS_CT',

264: -- Drop Indexes
265: --
266: hri_utl_ddl.log_and_drop_indexes(
267: p_application_short_name => 'HRI',
268: p_table_name => 'HRI_MB_CMNTS_CT',
269: p_table_owner => l_schema);
270: --
271: -- Truncate the table
272: --

Line 273: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_CMNTS_CT';

269: p_table_owner => l_schema);
270: --
271: -- Truncate the table
272: --
273: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_CMNTS_CT';
274: --
275: -- Select all people with employee assignments in the collection range.
276: -- The bind variable must be present for this sql to work when called
277: -- by PYUGEN, else itwill give error.

Line 401: p_table_name => 'HRI_MB_CMNTS_CT',

397: dbg('Full Refresh selected - Creating indexes');
398: --
399: hri_utl_ddl.recreate_indexes(
400: p_application_short_name => 'HRI',
401: p_table_name => 'HRI_MB_CMNTS_CT',
402: p_table_owner => l_schema);
403: --
404: -- Collect the statistics only when the process is NOT invoked by a concurrent manager
405: --

Line 409: fnd_stats.gather_table_stats(l_schema,'HRI_MB_CMNTS_CT');

405: --
406: IF fnd_global.conc_request_id is null THEN
407: --
408: dbg('Full Refresh selected - gathering stats');
409: fnd_stats.gather_table_stats(l_schema,'HRI_MB_CMNTS_CT');
410: --
411: END IF;
412: --
413: END IF;

Line 426: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_CMNTS_CT_WHO ENABLE');

422: --
423: -- Enable the WHO trigger on the fact table
424: --
425: dbg('Enabling the who trigger');
426: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_CMNTS_CT_WHO ENABLE');
427: --
428: hri_bpl_conc_log.log_process_end(
429: p_status => TRUE
430: ,p_period_from => TRUNC(g_refresh_start_date)