APPS.HRI_OPL_BDGTS dependencies on HRI_MB_BDGTS_CT

Line 132: INSERT INTO HRI_MB_BDGTS_CT (

128: l_current_time := SYSDATE;
129: l_user_id := fnd_global.user_id;
130: --
131: --
132: INSERT INTO HRI_MB_BDGTS_CT (
133: HRI_MB_BDGTS_CT_ID
134: ,BUDGET_ID
135: ,BUSINESS_GROUP_ID
136: ,BUDGETED_ENTITY_CD

Line 133: HRI_MB_BDGTS_CT_ID

129: l_user_id := fnd_global.user_id;
130: --
131: --
132: INSERT INTO HRI_MB_BDGTS_CT (
133: HRI_MB_BDGTS_CT_ID
134: ,BUDGET_ID
135: ,BUSINESS_GROUP_ID
136: ,BUDGETED_ENTITY_CD
137: ,BUDGET_MEASUREMENT_TYPE

Line 163: hri_mb_bdgts_ct_s.nextval

159: ,last_updated_by
160: ,created_by
161: ,creation_date)
162: SELECT
163: hri_mb_bdgts_ct_s.nextval
164: ,p_budget_id
165: ,p_business_group_id
166: ,p_budgeted_entity_cd
167: ,p_budget_measurement_type

Line 201: dbg(SQL%ROWCOUNT||' headcount records inserted into HRI_MB_BDGTS_CT');

197: AND det.budget_detail_id = prd.budget_detail_id
198: AND prd.start_time_period_id = ptps.time_period_id
199: AND prd.end_time_period_id = ptpe.time_period_id ;
200: --
201: dbg(SQL%ROWCOUNT||' headcount records inserted into HRI_MB_BDGTS_CT');
202: dbg('Exiting insert_headcount_budgets');
203: --
204: EXCEPTION
205: WHEN OTHERS THEN

Line 247: INSERT INTO HRI_MB_BDGTS_CT (

243: l_current_time := SYSDATE;
244: l_user_id := fnd_global.user_id;
245: --
246: --
247: INSERT INTO HRI_MB_BDGTS_CT (
248: HRI_MB_BDGTS_CT_ID
249: ,BUDGET_ID
250: ,BUSINESS_GROUP_ID
251: ,BUDGETED_ENTITY_CD

Line 248: HRI_MB_BDGTS_CT_ID

244: l_user_id := fnd_global.user_id;
245: --
246: --
247: INSERT INTO HRI_MB_BDGTS_CT (
248: HRI_MB_BDGTS_CT_ID
249: ,BUDGET_ID
250: ,BUSINESS_GROUP_ID
251: ,BUDGETED_ENTITY_CD
252: ,BUDGET_MEASUREMENT_TYPE

Line 283: hri_mb_bdgts_ct_s.nextval

279: ,last_updated_by
280: ,created_by
281: ,creation_date)
282: SELECT
283: hri_mb_bdgts_ct_s.nextval
284: ,p_budget_id
285: ,p_business_group_id
286: ,p_budgeted_entity_cd
287: ,p_budget_measurement_type

Line 334: dbg(SQL%ROWCOUNT||' labor cost records inserted into HRI_MB_BDGTS_CT');

330: AND prd.end_time_period_id = ptpe.time_period_id
331: AND bset.budget_set_id = ele.budget_set_id
332: AND ele.budget_element_id = src.budget_element_id;
333: --
334: dbg(SQL%ROWCOUNT||' labor cost records inserted into HRI_MB_BDGTS_CT');
335: dbg('Exiting insert_laborcost_budgets');
336: --
337: EXCEPTION
338: WHEN OTHERS THEN

Line 547: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_BDGTS_CT_WHO DISABLE');

543: set_parameters;
544: --
545: -- Disable the WHO trigger
546: --
547: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_BDGTS_CT_WHO DISABLE');
548: --
549: -- ---------------------------------------------------------------------------
550: -- Full Refresh Section
551: -- ---------------------------------------------------------------------------

Line 563: p_table_name => 'HRI_MB_BDGTS_CT',

559: -- Drop Indexes
560: --
561: hri_utl_ddl.log_and_drop_indexes(
562: p_application_short_name => 'HRI',
563: p_table_name => 'HRI_MB_BDGTS_CT',
564: p_table_owner => l_schema);
565: --
566: -- Truncate the table
567: --

Line 568: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_BDGTS_CT';

564: p_table_owner => l_schema);
565: --
566: -- Truncate the table
567: --
568: EXECUTE IMMEDIATE 'TRUNCATE TABLE ' || l_schema || '.HRI_MB_BDGTS_CT';
569: --
570: END IF;
571: --
572: END IF;

Line 607: p_table_name => 'HRI_MB_BDGTS_CT',

603: dbg('Full Refresh selected - Creating indexes');
604: --
605: hri_utl_ddl.recreate_indexes(
606: p_application_short_name => 'HRI',
607: p_table_name => 'HRI_MB_BDGTS_CT',
608: p_table_owner => l_schema);
609: --
610: -- Collect the statistics only when the process is NOT invoked by a concurrent manager
611: --

Line 615: fnd_stats.gather_table_stats(l_schema,'HRI_MB_BDGTS_CT');

611: --
612: IF fnd_global.conc_request_id is null THEN
613: --
614: dbg('Full Refresh selected - gathering stats');
615: fnd_stats.gather_table_stats(l_schema,'HRI_MB_BDGTS_CT');
616: --
617: END IF;
618: --
619: END IF;

Line 632: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_BDGTS_CT_WHO ENABLE');

628: --
629: -- Enable the WHO trigger on the fact table
630: --
631: dbg('Enabling the who trigger');
632: run_sql_stmt_noerr('ALTER TRIGGER HRI_MB_BDGTS_CT_WHO ENABLE');
633: --
634: hri_bpl_conc_log.log_process_end(
635: p_status => TRUE
636: ,p_period_from => TRUNC(g_refresh_start_date)