APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_RET_PA_LATEST_DETAILS

Line 9300: -- move them to HXC_RET_PA_LATEST_DETAILS

9296: t_l_measure,
9297: t_l_object_version_number;
9298:
9299: -- If there are any successful deletes from hxc_pa_latest_details
9300: -- move them to HXC_RET_PA_LATEST_DETAILS
9301: -- Keep recording whichever bb ids are updated.
9302:
9303: IF t_l_resource_id.COUNT > 0
9304: THEN

Line 9309: UPDATE /*+ INDEX(ret HXC_RET_PA_LATEST_DETAILS_FK1) */

9305:
9306: -- Bug 11797402
9307: -- Hint specified
9308: FORALL i IN t_l_time_building_block_id.FIRST..t_l_time_building_block_id.LAST
9309: UPDATE /*+ INDEX(ret HXC_RET_PA_LATEST_DETAILS_FK1) */
9310: hxc_ret_pa_latest_details ret
9311: SET old_attribute1 = attribute1,
9312: old_attribute2 = attribute2,
9313: old_attribute3 = attribute3,

Line 9310: hxc_ret_pa_latest_details ret

9306: -- Bug 11797402
9307: -- Hint specified
9308: FORALL i IN t_l_time_building_block_id.FIRST..t_l_time_building_block_id.LAST
9309: UPDATE /*+ INDEX(ret HXC_RET_PA_LATEST_DETAILS_FK1) */
9310: hxc_ret_pa_latest_details ret
9311: SET old_attribute1 = attribute1,
9312: old_attribute2 = attribute2,
9313: old_attribute3 = attribute3,
9314: old_measure = measure,

Line 9389: INSERT INTO hxc_ret_pa_latest_details

9385:
9386:
9387: -- Insert the records which are new into the table.
9388: FORALL i IN l_time_building_block_id.FIRST..l_time_building_block_id.LAST
9389: INSERT INTO hxc_ret_pa_latest_details
9390: (resource_id,
9391: time_building_block_id,
9392: approval_status,
9393: start_time,