DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PUB dependencies on AHL_UTIL_UC_PKG

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

681: NULL;
682: END;
683:
684: BEGIN
685: SELECT ahl_util_uc_pkg.get_unit_name(cs.customer_product_id)
686: INTO x_create_nr_output_rec.unit_name
687: FROM cs_incidents_all_b cs
688: WHERE cs.incident_id = p_nr_task_rec.incident_id;
689: EXCEPTION

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

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