DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PUB dependencies on AHL_UTIL_UC_PKG

Line 670: SELECT ahl_util_uc_pkg.get_unit_name(cs.customer_product_id)

666: NULL;
667: END;
668:
669: BEGIN
670: SELECT ahl_util_uc_pkg.get_unit_name(cs.customer_product_id)
671: INTO x_create_nr_output_rec.unit_name
672: FROM cs_incidents_all_b cs
673: WHERE cs.incident_id = p_nr_task_rec.incident_id;
674: EXCEPTION

Line 864: SELECT AHL_UTIL_UC_PKG.get_unit_name(p_sr_task_rec.instance_id)

860: IF (l_log_statement >= l_log_current_level) THEN
861: fnd_log.string(fnd_log.level_statement,l_debug_module,'Populating unit_name, instance_id:' || p_sr_task_rec.instance_id);
862: END IF;
863: BEGIN
864: SELECT AHL_UTIL_UC_PKG.get_unit_name(p_sr_task_rec.instance_id)
865: INTO x_create_nr_output_rec.UNIT_NAME
866: FROM DUAL;
867: EXCEPTION
868: WHEN OTHERS THEN