APPS.AHL_PP_RESRC_REQUIRE_PVT dependencies on AHL_UTILITY_PVT

Line 790: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

786: Ahl_Debug_Pub.debug( 'For create l_valid_flag -->' || l_valid_flag);
787: Ahl_Debug_Pub.debug( 'QUERY -->' || 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
788: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID);
789:
790: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
791: 'AHL_OPERATION_RESOURCES',
792: 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
793: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID
794: );

Line 801: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (

797:
798: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID ||
799: ' AND OPERATION_RESOURCE_ID <> ' || p_resrc_Require_rec.OPERATION_RESOURCE_ID);
800:
801: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
802: 'AHL_OPERATION_RESOURCES',
803: 'RESOURCE_SEQUENCE_NUM = ' || p_resrc_Require_rec.RESOURCE_SEQ_NUMBER ||
804: ' AND WORKORDER_OPERATION_ID = ' || p_resrc_Require_rec.WORKORDER_OPERATION_ID ||
805: ' AND OPERATION_RESOURCE_ID <> ' || p_resrc_Require_rec.OPERATION_RESOURCE_ID