DBA Data[Home] [Help]

APPS.AHL_FMP_PVT dependencies on AHL_UMP_UTIL_PKG

Line 946: ahl_ump_util_pkg.get_last_accomplishment(p_csi_item_instance_id => x_mr_item_inst_tbl(l_index-1).item_instance_id,

942: x_mr_item_inst_tbl(l_index-1).terminate_flag := 'N';
943: IF get_terminating_mr_tbl.COUNT > 0 THEN
944: FOR j in get_terminating_mr_tbl.FIRST..get_terminating_mr_tbl.LAST
945: LOOP
946: ahl_ump_util_pkg.get_last_accomplishment(p_csi_item_instance_id => x_mr_item_inst_tbl(l_index-1).item_instance_id,
947: p_mr_header_id => get_terminating_mr_tbl(j),
948: x_unit_effectivity_id => l_accom_ue_id,
949: x_accomplishment_date => l_dummy_date,
950: x_deferral_flag => l_dummy_boolean,

Line 2728: ahl_ump_util_pkg.get_last_accomplishment(p_csi_item_instance_id => l_instance_id_tbl(i),

2724: LOOP
2725: IF l_debug = 'Y' THEN
2726: AHL_DEBUG_PUB.debug('MR ID:Valid Flag:Term-MR:' || l_mr_header_id_tbl(i) || ':' || l_valid_mr_flag || ':' || get_terminating_mr_rec.mr_header_id, l_debug_prefix);
2727: END IF;
2728: ahl_ump_util_pkg.get_last_accomplishment(p_csi_item_instance_id => l_instance_id_tbl(i),
2729: p_mr_header_id => get_terminating_mr_rec.mr_header_id,
2730: x_unit_effectivity_id => l_accom_ue_id,
2731: x_accomplishment_date => l_dummy_date,
2732: x_deferral_flag => l_dummy_boolean,

Line 4294: AHL_UMP_UTIL_PKG.process_group_mrs;

4290: );
4291: END LOOP;
4292: END IF;
4293:
4294: AHL_UMP_UTIL_PKG.process_group_mrs;
4295:
4296: -- Delete visit types that do not match..
4297: DELETE AHL_APPLICABLE_MRS A
4298: WHERE NOT EXISTS (SELECT 'x' FROM AHL_MR_VISIT_TYPES