APPS.OPIMXRU dependencies on OPI_EDW_RES_UTIL_PUSH_LOG

Line 81: insert into opi_edw_res_util_push_log

77: -- --------------------------------------------------------
78: -- Insert 24 hr available resource into the push_log table
79: -- actual usage is 0
80: -- --------------------------------------------------------
81: insert into opi_edw_res_util_push_log
82: ( res_util_pk, organization_code, resource_code,
83: department_code, trx_date, sob_id,
84: uom, act_res_usage, avail_res )
85: SELECT /*+ ALL_ROWS */

Line 129: INSERT INTO opi_edw_res_util_push_log

125:
126: -- --------------------------------------------------------
127: -- Insert shift based available resource into push log
128: -- --------------------------------------------------------
129: INSERT INTO opi_edw_res_util_push_log
130: ( res_util_pk, organization_code, resource_code,
131: department_code, trx_date, sob_id,
132: uom, act_res_usage, avail_res )
133: SELECT

Line 202: UPDATE opi_edw_res_util_push_log

198: -- running out
199: -- --------------------------------------------------------
200:
201: FOR l_wip IN wip_used(p_uom_class, p_hr_base_rate) LOOP
202: UPDATE opi_edw_res_util_push_log
203: SET act_res_usage = l_wip.act_res_usage
204: WHERE res_util_pk = l_wip.res_util_pk;
205:
206: IF sql%rowcount = 0 THEN -- not existed

Line 208: INSERT INTO opi_edw_res_util_push_log

204: WHERE res_util_pk = l_wip.res_util_pk;
205:
206: IF sql%rowcount = 0 THEN -- not existed
207:
208: INSERT INTO opi_edw_res_util_push_log
209: ( res_util_pk, organization_code, resource_code,
210: department_code, trx_date, sob_id,
211: uom, act_res_usage, avail_res )
212: values ( l_wip.res_util_pk, l_wip.organization_code, l_wip.resource_code,